lenraphael wrote:Was trying out new QBDesktop tax line grouping function (slow and no keyboard shortcuts but ok),
What "new function"? I don't see any such thing through ver. 2019, just the same old "tax lines for accounts". Something new for 2020 version, just released?
"An account's tax line associates each income and expense account with the appropriate tax form and line on your company income tax return"I use this for all my tax clients where I also prepare the business return, including Schedule C, 1120S, and 1065. For me, it's not slow, and all the normal keyboard shortcuts work. The big payoff, of course, comes when you start working on years 2-
n, when it is so much faster and easier to start with the Income Tax Summary report.
One disadvantage of relying on Excel for translation to the tax form is that every time you export the data from one program to another, you introduce the possibility of error. I can simply save a PDF of the Tax Summary Report with my work papers since it reconciles directly to the tax return, no intermediate spreadsheet required.
lenraphael wrote:[...] exported to Excel, and sorted by tax line grouping. Other than manually subtotaling each tax line subgrouping, isn't there a way to use "outlining" or "auto subtotaling" or some such Excel feature to do that?
In general, to use this feature in Excel, you first make sure there is a column header row, next sort by the column of interest, then from the "Outline" menu, choose "Subtotal". The dialog box should be somewhat self-explanatory, if you are comfortable with Excel.