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.
This is the way it is supposed to be when QB is in order. But not what is happening for me. No reconciled transaction has been changed. Twice now I have had this problem on accounts for which I downloaded transactions from my bank/credit card. This seems to cause some data problem. Once I had my balance thrown off after a crash. Ruined my beginning balances going back three years.
Your thinking is the reverse of my problem. It does not throw off all subsequent balances. It throws off all Previous balances. Going back years. This seems like a glitch. Usually my data tests as bad. But rebuilding data does not solve the problem.
Welcome to the Community. I'm here to help you fix the data problem in QuickBooks Desktop.
Since there are no changes to your reconciled transactions and the problem persists after running Verify/Rebuild Data utility, I recommend running the QuickBooks Tool Hub. It also helps fix issues related to the program.
To know more about the set of tools for addressing different types of problems when running the tool, check out this article: Fix common problems and errors with the QuickBooks Desktop Tool Hub.
If the problem persists, I suggest contacting our Customer Support Team. Our support can help you further with fixing your previous balances.
Let me walk you through how:
For additional reference, I've attached a link you can use about how to repair the QuickBooks software: Repair your QuickBooks Desktop for Windows.
Please know that I'm just a post away if you have any other questions about the balances in QuickBooks. Take care.