Quicken Community is moving to Single Sign On! Starting 1/22/21, you'll sign in to the community with your Quicken ID. For more information: http://bit.ly/CommunitySSO

Starting and ending Balance on Category transactions Report

Alessio
Alessio Member
Hallo All,
I'm looking for a solution to include the starting and ending balance for the month, in the TRANSACTIONS BY CATEGORY report.

Can somebody help me with this?
Thank in advance.
Tagged:

Best Answer

  • jacobs
    jacobs SuperUser, Mac Beta Beta
    Accepted Answer
    In a transactions report, there is no starting or ending balance, as the report is tallying just the selected transactions. (Transaction reports can be restricted to a single account, but in general apply to multiple or all accounts. The report may also be limited to selected categories or tags, so again the concept of a starting and ending balance doesn't make sense for most instances of a report of transactions.)

    If you want a report of transactions in just a single account for a particular time period, you can get that by selecting the account in the left sidebar, setting the date filter to the range of time you want, and then selecting to print (or export) the transactions. This register report will include the running balance column, so you'll be able to see the ending balance on the last transaction, and the opening balance will be the balance on the first transaction plus/minus the value of that first transaction. You can sort this report by the Category column, but it won't provide sub-totals for each category, and won't break apart split transactions. For that reason, you might want to export the transaction report to compile what you need in Excel or Numbers.

    Alternatively, you could to the transactions by category report you've been doing, and use the Net Worth report to get the account balance as of the first date and as of the last date of your time period; you'd have to write those values in by hand.
    Quicken Mac Subscription • Quicken user since 1993

Answers

  • jacobs
    jacobs SuperUser, Mac Beta Beta
    Accepted Answer
    In a transactions report, there is no starting or ending balance, as the report is tallying just the selected transactions. (Transaction reports can be restricted to a single account, but in general apply to multiple or all accounts. The report may also be limited to selected categories or tags, so again the concept of a starting and ending balance doesn't make sense for most instances of a report of transactions.)

    If you want a report of transactions in just a single account for a particular time period, you can get that by selecting the account in the left sidebar, setting the date filter to the range of time you want, and then selecting to print (or export) the transactions. This register report will include the running balance column, so you'll be able to see the ending balance on the last transaction, and the opening balance will be the balance on the first transaction plus/minus the value of that first transaction. You can sort this report by the Category column, but it won't provide sub-totals for each category, and won't break apart split transactions. For that reason, you might want to export the transaction report to compile what you need in Excel or Numbers.

    Alternatively, you could to the transactions by category report you've been doing, and use the Net Worth report to get the account balance as of the first date and as of the last date of your time period; you'd have to write those values in by hand.
    Quicken Mac Subscription • Quicken user since 1993
  • Alessio
    Alessio Member
    Thank you, exporting the Register report solved my necessity.
    Would it be the possibility to show the whole Category tree (Main category - Sub c1 - Sub c.2) in a NET WORTH Detail report?
  • RickO
    RickO SuperUser, Mac Beta Beta
    No, that would not make sense. Categories are about individual transactions, while Net Worth is about account values. Showing categories on a Net Worth report would not make sense.
    Quicken Mac Subscription; Quicken Mac user since the early 90s
  • jacobs
    jacobs SuperUser, Mac Beta Beta
    @Alessio Net Worth (also known as a Balance Sheet) shows the balances of your assets and liabilities at a specific moment in time. For instance, as of the end of 2020, what were the totals of each of my bank accounts, credit cards, investments, loans, etc.?; the bottom line is your assets minus your liabilities.

    A Category report (also known as an Income Statement, Profit & Loss Statement, or P&L) is a breakdown of your revenues and expenses over a specified period of time, with the bottom line being your gain or loss -- revenues minus expenses -- during that period.

    So categories do not have anything to do with Net Worth, and do not appear in a Net Worth report; only accounts appear in a Net Worth report.
    Quicken Mac Subscription • Quicken user since 1993
This discussion has been closed.