On this most recent Reconciliation you're saying you put in:
Statement Closing Date
Statement Beginning Balance
Statement Ending Balance
And when you finished matching what the bank showed as cleared the Reconciliation showed a $0 Difference. Correct?
And with all the prior times you Reconciled you also came out with a $0 Difference? There was never a time you just let it go thinking you'd catch it later? (That doesn't really work easily with QBs.)
If all of your outstanding items are accounted for (both credit & debit) then there has to have been a change to the account. By any chance were any reconciled items deleted or changed? Even if an item(s) was deleted by mistake and then added back in and checked as reconciled, it will affect the Reconciliation Balance.
Go through the Reconcile process again and put in all the info from the last statement (you can cancel out at the end). Does anything still show up in the list that stands out to you as an issue? Often old items that were deleted and added back up will show up here.
Thank you for your help! I just started working with this client today - reconciled all of 2019 to the ending balance that he gave. Then I reconciled Jan - Aug of 2020 with $0 difference on all but one month which I made a $504 adj. I have done all of this within about 4 hours, so I don't believe anything has changed....
There are 'old transactions', 6 that total $73,450 only
It really makes no sense to me. This is a start up company so not too many transactions.......
Let me step in and assist you in reconciling your account.
In reconciling your account, you'll have to match the transactions you've entered in your QuickBooks and your bank statement. You can follow these steps on how to fix the discrepancies on your account:
Step 1: Review the opening and beginning balance
You'll have to review the opening and beginning balance so that you will not having trouble in you reconciling your account.
Step 2: Check the ending balance you entered
Enter the ending balance from your bank statement when you start reconciling your account.
While doing your reconciliation, click the Edit info button in the reconciliation window.
Check the Ending balance and Ending date. Make sure it matches your financial institution statement and your QuickBooks.