report not consistent

Options
mhaseltine
mhaseltine Member ✭✭

I'm using quicken mac v 7.6.1, and when I run a report for 2023, all categories for one bank account, the numbers don't work. Here's what I mean. If I take the beginning balance, add income and subtract expenses, the final number doesn't agree with the final balance for 2023 in quicken. It's off by $4.09. I just spent 40 minutes on the phone with quicken support and she came up with no answer other than user error. However, all the numbers are from quicken and they all agree with bank statements, and the account is reconciled up through mid Feb. 2024 with no errors.

Answers

  • RickO
    RickO SuperUser, Mac Beta Beta
    Options

    Which exact report are you starting with? Is it from the "other reports" group?

    Quicken Mac Subscription; Quicken Mac user since the early 90s
  • mhaseltine
    mhaseltine Member ✭✭
    Options

    No, not one of the old reports. Just a standard transactions by category report.

  • jacobs
    jacobs SuperUser, Mac Beta Beta
    Options

    I think you have to be missing something somewhere. I'd guess you have a transaction during the year which are a Transfer, or which use the category "Credit Card Payment" or "Adjustment"? Any of those can move money in or out of an account without being counted as income or expense.

    In your bank account register, try this: click on the first transaction of the year, scroll to the end of the year, and Shift-click on the last transaction of the year. This will highlight all the transactions, and in the upper right, Quicken shows in parentheses the number of highlighted transactions and their net balance:

    That value is your total of inflows and outflows for the year. If you add this value to the account balance as of the end of the prior year, the total will match the running balance on the last day of the year.

    But inflows and outflows may not equal income and expenses, because of the previously mentioned cash flow transactions which affect your balance but are neither income nor expenses.

    Quicken Mac Subscription • Quicken user since 1993
  • mhaseltine
    mhaseltine Member ✭✭
    Options

    Interesting to compare with the report. Doing what you suggested gives a difference of 181.02, whereas the difference between income and expenses gives 185.11, the same as the error I reported. How to track down the odd item(s)?

    It shows 326 items selected. How could I compare that to what's in the report without counting. BTW, I have accounted for transfers, and there are no adjustments or "credit card payments". One of the transfers is to another account to pay a CC bill, but that's accounted for with the transfers and is for 24.54, not 4.09. Also, searching for 4.09 get nothing.

  • Jon
    Jon SuperUser, Mac Beta Beta
    Options

    Try breaking it down into smaller time periods. Is the error in the first half of 2023 or the second half? Which quarter of that half? & so on. Once you’ve figured out which month it is it should be easier to find the actual problem.

    Quicken Mac subscription. Quicken user since 1990.

  • mhaseltine
    mhaseltine Member ✭✭
    Options

    Will give it a try and see what I can find. Thanks for your help!

  • mhaseltine
    mhaseltine Member ✭✭
    Options

    Tracked it to second half, then third quarter, then October. Found it as part of a split even though when I had searched o 4.09, it found nothing. Based on some other mentions, I changed its category, but then the 4.09 didn't show up in the report anywhere. Then I noticed a "q" in the tag field. After deleting that and trying to save it, it said I was changing a transfer record, did I want to go to the transfer or save anyway. Knowing it was not part of a transfer, I saved it then changed the category back to the original, and everything was good! Report and quicken balances agreed finally.

    Much obliged to be shown how to track this down.

This discussion has been closed.