Home Quicken for Mac Errors and Troubleshooting (Mac)
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

reconciliation errors

Greydog9928Greydog9928 Member, Windows Beta, Mac Beta Beta
I am running Quicken 6.0.1 on Macintosh 10.15.7. One of my accounts through Pacific Premier Bank has all its transactions directly downloaded. After every download, I reconcile without issues for many years. As of a few weeks ago, I suddenly have a very large discrepency that prevents reconciliation. I checked my most recent statement and there are no new transactions on either end.

What is causing this issue especially since I am only downloading transactions.
Tagged:

Best Answer

  • smayer97smayer97 SuperUser, Mac Beta, Canada Beta ✭✭✭✭✭
    edited December 2020 Accepted Answer
    Yes, this is a very challenging problem. Currently, the Prior Balance is a calculated number, the sum of all Reconciled transactions in your account register. Often times the lack of successful reconciliation because of this can be due any one of the following reasons (which can be due to user error or a bug in Quicken). These reasons include:
    • changed Reconcile status
    • changed amount
    • transaction was deleted
    • in the case of transfer transactions, the matching transfer-to transaction was changed or deleted in the other account register, or the transaction was re-categorized as no longer transfer but a categorized Income or Expense
    • if you Sync to Mobile, the Sync process changed something or you made changes to an existing transaction on the web / phone app
    Either way, you need to figure out what changed and fix it as needed. The first one is the easiest to try to tackle. One quick troubleshooting step is to sort the register by the CLR field (if that columns is not visible, change your Column settings in the register) (you want the small triangle to the right of CLR to point down so all of the transactions marked as Reconciled will be grouped at the top) so the running balance of the last Reconciled transaction should be the same as the Prior Balance.  

    Now either scroll to the bottom of the register to see all the unreconciled transactions (OR click the CLR column again to to show them at the top). Look for any older transactions that may have lost their flag. If you find any, you can easily reset the flag by Option-Clicking the field to cycle through the Blank, Cleared and Reconciled flags.

    For any of the other reasons, you will have to figure it out by brute force, that is, compare transactions with previous records, such as, statements or online info.
    If not successful, read this FAQ to see if it helps: Quicken Mac v3.5+ (QM2016+) Reconcile Troubleshooting.

    Meanwhile, there is a feature in QM2007 that has not been re-implemented in "modern" QMac that would make this task far easier, reducing it to minutes or even seconds, vs hours or days. You can add your VOTE to Track/store Prior Reconciled Statements/periods.

    First, click on the underlined link above to go there, then click the little grey triangle under the VOTE count at the top of page 1 in the blue banner, so your vote will count for THIS feature and increase its visibility to the developers by seeking to have the features you need or desire end up in the latest version (it may take a moment for your vote to register).
    (If the triangle is black, your vote has already been counted.)

    Your VOTES matter!


    Have Questions? Check out these FAQs:COMPLETE list of Product Ideas - Quicken for Mac to VOTE on

    Object to Quicken's business model, using up 25% of your screen
    ? Add your vote here:
    Quicken should eliminate the LARGE Ad space when a subscription expires


    (
    Canadian user since '92, STILL using QM2007)


Answers

  • Greydog9928Greydog9928 Member, Windows Beta, Mac Beta Beta
    Update: I went back to a backup about a month ago before this issue presented and reconciliation went to 0. I downloaded new transactions and the reconciliation went fine and went to 0. I updated my other accounts and now when I go back to this problem account, it says there is a very large discrepancy, but no new transactions.
  • Tom YoungTom Young SuperUser ✭✭✭✭✭
    I'm not sure if I'm following along with your description of events but it sounds to me like during this month some transaction or transactions before this month got altered or deleted in some fashion.  That is, if all transactions are properly presented and accounted for in this month but the end of month balance doesn't reconcile to the bank statement, them something "upstream" of this month must have changed.
    Go back to that "about a month ago" backup and check the balance in the Account at that time, then come back to your live Account and check that Account's balance for the same date.  If the numbers are different then the problem is obvious.
    If the numbers are the same then that suggests some previous transaction that was marked as reconciled somehow lost that status.
  • Greydog9928Greydog9928 Member, Windows Beta, Mac Beta Beta
    Thanks for the suggestion. I checked the balance in both the back up from several weeks ago and the recent one and the balance is indeed different in both accounts on a chosen day [I picked approximately 1 month ago]. So I assume something got switched before the date I checked.

    What do you do with this information other than create an adjustment? Seems like it's a software problem if it is changing reconciled transactions and would be very hard to identify the offending transaction[s].
  • smayer97smayer97 SuperUser, Mac Beta, Canada Beta ✭✭✭✭✭
    edited December 2020 Accepted Answer
    Yes, this is a very challenging problem. Currently, the Prior Balance is a calculated number, the sum of all Reconciled transactions in your account register. Often times the lack of successful reconciliation because of this can be due any one of the following reasons (which can be due to user error or a bug in Quicken). These reasons include:
    • changed Reconcile status
    • changed amount
    • transaction was deleted
    • in the case of transfer transactions, the matching transfer-to transaction was changed or deleted in the other account register, or the transaction was re-categorized as no longer transfer but a categorized Income or Expense
    • if you Sync to Mobile, the Sync process changed something or you made changes to an existing transaction on the web / phone app
    Either way, you need to figure out what changed and fix it as needed. The first one is the easiest to try to tackle. One quick troubleshooting step is to sort the register by the CLR field (if that columns is not visible, change your Column settings in the register) (you want the small triangle to the right of CLR to point down so all of the transactions marked as Reconciled will be grouped at the top) so the running balance of the last Reconciled transaction should be the same as the Prior Balance.  

    Now either scroll to the bottom of the register to see all the unreconciled transactions (OR click the CLR column again to to show them at the top). Look for any older transactions that may have lost their flag. If you find any, you can easily reset the flag by Option-Clicking the field to cycle through the Blank, Cleared and Reconciled flags.

    For any of the other reasons, you will have to figure it out by brute force, that is, compare transactions with previous records, such as, statements or online info.
    If not successful, read this FAQ to see if it helps: Quicken Mac v3.5+ (QM2016+) Reconcile Troubleshooting.

    Meanwhile, there is a feature in QM2007 that has not been re-implemented in "modern" QMac that would make this task far easier, reducing it to minutes or even seconds, vs hours or days. You can add your VOTE to Track/store Prior Reconciled Statements/periods.

    First, click on the underlined link above to go there, then click the little grey triangle under the VOTE count at the top of page 1 in the blue banner, so your vote will count for THIS feature and increase its visibility to the developers by seeking to have the features you need or desire end up in the latest version (it may take a moment for your vote to register).
    (If the triangle is black, your vote has already been counted.)

    Your VOTES matter!


    Have Questions? Check out these FAQs:COMPLETE list of Product Ideas - Quicken for Mac to VOTE on

    Object to Quicken's business model, using up 25% of your screen
    ? Add your vote here:
    Quicken should eliminate the LARGE Ad space when a subscription expires


    (
    Canadian user since '92, STILL using QM2007)


  • Tom YoungTom Young SuperUser ✭✭✭✭✭

    What you've discovered suggest some dollar amount for a transaction in a prior period either got changed or or perhaps a transaction got deleted.
    You can create an adjustment, of course, but the "more correct" (and harder) way of going is to fined the error or errors and fix it or them.
    One approach that should be fairly quick and easy to do is to open the backup and write down or print out the month end balances in the Account, perhaps a year's worth.  Then open your current file and start comparing the month end balances in your Account to the list.  If you never get a match then you know the error is in time period before that 12 month listing and maybe at that point you settle for an adjustment.  But if you go back a few months and at that point the balances match, then you know that the error occurred in the month immediately after that "match" month.  Knowing the size of the adjustment you might look at your bank statement for that month and see if you spot that amount, which might point to the missing transaction.  If that doesn't work then trace every single transaction on the statement to your Quicken file.  You should see either one or more missing transactions or one or more transactions where the amounts don't agree.
    How much work you put into this is a function of how material the adjustment is and your own desire for "perfect" or "close enough."
    Quicken is a retail-level accounting program that's touted as "easy", and "easy" almost always means it's also easy to make mistakes.  In the Windows program there's a default warning that pops up if you attempt to either change a reconciled item or delete it, but that doesn't stop you from doing either, and that warning can be turned off by the user so if a user simply rushes through that warning or turns it off all together, it's "easy" to screw things up.  The Windows program also has a function you can turn on that "protects" transactions before a date you set.  If you try to delete or change a transaction before that date Quicken throws up a warning and demands a password before you're allowed to do either.  So the function doesn't entirely disallow deletion or changes to prior transactions and if you never turned it on in the first place, it's "easy" to mess things up.
    If Quicken Mac has similar features I'd advise turning them on, particularly that prior period protection feature. 
     

  • jacobsjacobs SuperUser, Mac Beta Beta
    @Greydog9928 A good method for hunting down where a change occurred is the bisection or half-interval method. If you have 20 years of transactions in an account, go back to sometime 10 years ago -- roughly the midpoint -- to see if the account balance matches your backup file as of that date. If yes, you've ruled out a problem prior to that date, so the problem is in the past 10 years; if no, the problem is more than 10 years ago. Jump to roughly the midway point of the 10 years with the problem, and again check your current balance versus the backup file balance. Keep going halfway forward or backward until you find the months where the discrepancy first shows up. This way, you can pinpoint the problem month from 20 years of data by checking the balance on just 8 dates.
    Quicken Mac Subscription • Quicken user since 1993
  • ericdsaericdsa Member
    I have been having issues as well for a few months. I would go to reconcile and prior months that were already reconciled change. I noticed this morning that Quicken is grabbing reconciled transactions from prior month to match a new transaction. This then changes the balance of the closing date of the last reconciled month.
  • Quicken_TykaQuicken_Tyka Moderator mod
    Hello @ericdsa

    Thank you for taking the time to visit the Community to post your issue, although I apologize that you haven't received a response.

    At this time I would recommend contacting support directly for advanced troubleshooting steps.

    https://www.quicken.com/support#contact-support

    Quicken Care has the ability to initiate a screen share to view the issue in real-time to review and research this further.

    Thank you,

    -Quicken Tyka

    ~~~***~~~
Sign In or Register to comment.