I am trying to generate a report showing by month (or quarter or year) for a given date range: * balance of selected accounts on the first of the month with subtotal line, * then section for income by category with subtotal line * then section for expenses by category with subtotal line * then the ending balances of my accounts on end of the month with subtotal line * then total change for that column. Is there a way to do this? Where do I start?

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to report balances with income/expenses by month?

Lizzie160

I am trying to generate a report showing by month (or quarter or year) for a given date range:

balance of selected accounts on the first of the month with subtotal line,
then section for income by category with subtotal line
then section for expenses by category with subtotal line
then the ending balances of my accounts on end of the month with subtotal line
then total change for that column.

Is there a way to do this? Where do I start?

Find more posts tagged with

Reports

balances

Accepted answers

Tom Young

On an Account-by-Account basis the closest report to what you're asking for would be the "Register Report" customized to "Last month" and subtotaled by Category. That would show, for each Account, the information you're looking for. The Register Report is only available for Spending Accounts.

All comments

NotACPA

~~You're trying to combine a balance sheet report (month beginning and ending amounts) with an Income & Expense report.~~

~~Such doesn't exist in Q. You need two reports, one Balances and one Income/Expense.~~

~~Also note that if you include any investment accounts, they can change value without there being any additions or withdrawals, due to the security values changing.~~

I was wrong. @Tom Young figured it out.

Jim_Harman

The problem with a report like this is that a report by Category looks at all transactions for the selected Categories and Payees. If you do not select all Categories and Payees, the Category subtotals and account balances will not be meaningful.

You could do this with two reports - Net Worth & Balances > Account Balances and Spending > Income and Expense by Category.

You might also find the In/Out/What's Left panel on the Home tab classic dashboard useful.

Tom Young

NotACPA

@Tom Young I, obviously, never thought of that route. BUT, there's a slight correction. The Register Report is available for SOME, but not all, Property & Debt type accounts such as the liability account that I use to track my "Medicare Prescription Payment Plan" debt.

Tom Young

@NotACPA

I wasn't sure about the ability to get this the Register Report out of Accounts other then Spending Accounts - the checking, credit card, savings, and cash Accounts - so I only specified the Spending Accounts in my reply.

Looking through all 11 of the Property & Debt Accounts in my file, they all had the Register Report available, so I'm kind of surprised that that you have a liability Account that doesn't. Since you said "debt" for the Medicare Prescription Payment Plan Account, maybe that's a loan account of some sort?