Hi Glen77,

There's a way to do it using Departments, or Projects, or Simply / Sage Intelligence, or XLGL.

In the olden days, I would just set up a template In Excel, one tab was for the Trial Balance, and one for the Income Statement report.  

To update the report, I would run a Trial Balance report, open it in Excel, clear the merged cell formats for the whole sheet, then just copy the data into the Trial Balance tab of the report worksheet.

To set up the first one:

- Run the Trial Balance report, make sure that '[ ] Hide Accounts With Zero Balance' is unchecked.

- Use Open In Excel to get it into a worksheet.

- To the right of the data, in E6, set up a formula =C6-D6 that calculates the net of the debits and credits, and copy the formula down to the end of the Trial balance.  

- Add another tab to the worksheet, and set up formulas for each item you want on your report, by referencing back to the Trial Balance sheet.  (press = and then use the mouse to switch to the other tab and select the cell you want)

If you also use formulas for the Account Number and Description, you'll notice right away if the Chart Of Accounts has changed.

This can also be done with lookup formulas from one tab to another.  The advantage of lookup formulas is that if accounts are added or removed in the list, the lookup will find '5020' whether it's on line 60 or 63, or if you forget to only do the accounts with a zero balance.