Summary report showing balances and categorized income/expenses

anon123

I am trying to generate a summary report for last year showing the starting balance of all my accounts on Jan 1, all income and expenses by category for the year, and then the ending balance of all my accounts on Dec 31.

Is there a way to do this? 

Thank you.

Tom Young

The report created by Reports > Banking > Transactions and subtotaled by Category has that basic layout.  It's going to be a long report though because it is geared to showing transaction detail. 

Frankly it probably would be better to run a Spending report for the year, export that to Excel, then type in the beginning and ending balances.  If beginning balance +/- "Overall Total" on Spending report = ending balance, then all's good.

Tom Young

The report created by Reports > Banking > Transactions and subtotaled by Category has that basic layout.  It's going to be a long report though because it is geared to showing transaction detail. 

Frankly it probably would be better to run a Spending report for the year, export that to Excel, then type in the beginning and ending balances.  If beginning balance +/- "Overall Total" on Spending report = ending balance, then all's good.

anon123

Thank you. I will give it a try.