Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
I just acquired a new account who has been in business since 2014. Previous bookkeeper did not reconcile any bank statements for 2021. I am working on this now. My problem is that the Jan. 2021 beginning balance does not equal the checkbook register and all previous years have been reconciled. How do I correct this or find out what the problem is??
Solved! Go to Solution.
That's a tough one to figure out. Some of the big "gotchas" are:
- Previously Reconciled transaction was deleted
- Previously Reconciled transaction was changed
- Big possibility that in Dec. 2021 they made an entry into Jan 2021 when they meant 2022
- And amount was modified
- Are you over or under? So are you looking for a Payment or Deposit?
You get the idea. Maybe start with sorting the Register by Amount and see if you can find a transaction for the same amount. Next, start a Reconciliation (doesn't matter the numbers are wrong) and just look to see if you find anything pending that's dated Jan 2021 or any other transaction out of wack. Also just look through Dec and Jan to see if you see anything out of wack.
Next, I'd take a chance that something changed in Dec. OR to confirm the Nov Reconciliation was correct, UnReconcile December and do it again. Hopefully the ending number in Nov will match the beginning number for Dec. If not, then you've got a bigger issue and the prior Bookkeeper may have just been checking things off vs. actually reconciling the accounts.
From there I'd check with the Accountant. They may be okay with just an entry to fix it (pending the amount). If not, it sounds like a fair amount of time will be involved to UnReconcile back to where you find there error and then move forward again.
Hope you'll find an obvious error.
I've got some steps we can perform to get your bank balance fixed, LuckyLady2.
The Beginning Balance is incorrect due to one of the following reasons:
To find the transactions causing the discrepancy, we can run the Reconcile Discrepancy report. Here's how:
To correct the discrepancy, you may need to re-enter or edit the transactions. We can also undo a previous reconciliation and redo it. Let me show you how:
To provide you other troubleshooting solutions, you can check out this article: Fix beginning balance issues in QuickBooks Desktop.
Feel free to browse this link here if you need help with other tasks with bank feeds and reconciling accounts. It'll route you to our general payroll topics with articles.
Please know that I'm just a post away if you have any other questions about handling your accounts in QuickBooks. It'll always be my pleasure to help. Have a great day ahead.
That's a tough one to figure out. Some of the big "gotchas" are:
- Previously Reconciled transaction was deleted
- Previously Reconciled transaction was changed
- Big possibility that in Dec. 2021 they made an entry into Jan 2021 when they meant 2022
- And amount was modified
- Are you over or under? So are you looking for a Payment or Deposit?
You get the idea. Maybe start with sorting the Register by Amount and see if you can find a transaction for the same amount. Next, start a Reconciliation (doesn't matter the numbers are wrong) and just look to see if you find anything pending that's dated Jan 2021 or any other transaction out of wack. Also just look through Dec and Jan to see if you see anything out of wack.
Next, I'd take a chance that something changed in Dec. OR to confirm the Nov Reconciliation was correct, UnReconcile December and do it again. Hopefully the ending number in Nov will match the beginning number for Dec. If not, then you've got a bigger issue and the prior Bookkeeper may have just been checking things off vs. actually reconciling the accounts.
From there I'd check with the Accountant. They may be okay with just an entry to fix it (pending the amount). If not, it sounds like a fair amount of time will be involved to UnReconcile back to where you find there error and then move forward again.
Hope you'll find an obvious error.
Check written in Jan was entered in Dec. and was showing as cleared. That was the difference.
Thx so much for your help!!
Glad it worked out. Those kind of issues often are really obvious or they can be a royal pain to find.
I deleted a transaction from 2020 somehow... it's in the discrepancy report. How do I fix it so that the opening balance in QB actually matches the banks balance.
Let's work together and solve this,GeoZero
Deleted transactions that had the Reconciled status could mess up your balances. To fix this, you'll need to manually re-create the deleted transactions and reconcile them again.
We can visit the Audit Log to see the specific transaction that was deleted from 2020. Here's how:
Then, you can use the information displayed to recreate the transactions. Let's make sure to update the status of the transactions in the register to R for Reconciled.
If the opening balance is now correct, you can now start reconciling. If there are any discrepancies, you can check this article to help you fix them: Fix issues for accounts you have reconciled in the past in QuickBooks Online.
Keep your post coming if you need additional assistance while managing your reconciled transactions. I'm always here to help. Have a great day!
I don't have a gear icon as I am in Desktop not online version.
Anyway... I fixed it just added the transaction again and at the next reconcile it zeroed out.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here