Welcome back to the Community, HFDTreasurer.

I can help point you in the right direction about running a report that will show all the details mentioned above.

The suggestion shared by my colleague is a workaround to get the total of all account balances for a custom end date. In regard to your other concern, you’ll no longer have to shrink the transaction details. The Rows/Columns feature can help add or remove a specific row and column to appear on the report. Let’s deselect the Transaction Type box so it will not show on the statement.

Here’s how:

1. Go to Reports on the left panel and enter Transaction Detail by Account in the field box.
2. Click the Report period drop-down to set the correct date range.
3. Hit the Customize button to open the Customize report window.
4. From there, tap on the Change columns link and then uncheck the box for Transaction Type.
5. Click Run report to keep the changes.
6. Press the Export icon to select Export to Excel.
7. Then, manually customize the data on the report.
   

For tips to easily customize, save, and share reports, check out the You can do WHAT in QuickBooks? Customizing Reports guide. Aside from hiding columns, this article will also guide you on how to use the following options: General, Rows/Columns, Aging, Filter, Header/Footer, etc.

Reach out to me if you need further assistance with any of these steps. I’ll be glad to help. Have a great rest of the week.