I was attempting to reconcile this month’s checking account and the beginning balance was off. I used time machine to narrow down when the beginning balanced changed. I have a version of the company file from 10/13/17 where the beginning balance is fine when running the reconciliation report, and on the version of the company file from 10/14/17 it’s off when running the reconciliation report. If I try to undo previous reconciliations over and over the beginning balance remains off by the same amount all the way back to the beginning of the account. This would lead me to believe the error is very early in the register, however if I run a balance sheet report in both versions of the company file up to a date of 9/1/17, they are the same, but different from 9/31/17. This leads me to believe the error is in September. I do see where the mistakes are in September, but I don’t understand why this is affecting the beginning balance on old reports. Is there a way to fix this without having to go back to the last known good version of the file and re-enter all data for the past month or so?
Solved! Go to Solution.
Is there anyway you can tell me how you fixed this in detail? I am having the same problem but cannot see anything I have done wrong. It changed it all the way back to my original start date in 2015. Any help is appreciated :)
Reconciliation Discrepancies are caused by modified transactions and adjustments from previous reconciliation. We can review reports to determine the transaction that's causing the problem. You can browse these articles for more information:
You might want to ask assistance from you accountant so they can give you further details on how to correct your data.
We'll be right here if you need anything else.
How to you "change" a deleted transaction (causing beginning balance to be off). I've added it back in manually, and account still won't reconcile showing beginning balance off by the same amount, regardless of my re-inputting the expense.
Hello there, @JScarb,
I appreciate you for recreating the deleted expense. Doing this won't automatically reconcile your account. With this, you'll have to perform the special reconciliation process again, so it fixes the beginning balance difference. This also ensures your account in QuickBooks matches your bank statement. For detailed instructions, go through this article: Reconcile Bank and Credit Card Account.
You can always run the four reports below to trace your account activities every time you reconcile it. The reports help you fix any reconciliation differences in the future.
For more information, check out this website: Find Reconciliation Discrepancies (Mac).
I'm always here to help if you have other concerns. Happy Holidays, @JScarb.