If the beginning balance on your statement doesn't match what you have in QuickBooks, it's called a beginning balance discrepancy. To accurately reconcile an account so your books agree with your bank, you need to fix the discrepancy in QuickBooks before you reconcile.
Grab a cup of coffee and we'll walk you through this one step at a time.
Fix an incorrect beginning balance when:
You're in luck. Click the link in the discrepancy alert. It takes you to the discrepancy report.
The discrepancy report finds any transaction that was:
The discrepancy report helps you can fix your beginning balance, one transaction at a time.
Click the Gear icon > Reconcile.
If the transaction amount or account was changed:
If a transaction was unreconciled in the register:
To fix deleted transactions:
Find the recreated transaction in the registerand click its reconciliation status until it shows R for reconciled.
Click the Gear icon > Reconcile.
If a transaction was reconciled in the register:
If a transaction is marked as cleared (C) in the register, it will have a checkmark on the reconciliation screen.
Once you resolve all the changed transactions that caused the discrepancy, the difference will be $0.00. Well done! The alert stops appearing and you can start reconciling.
Click the Gear icon > Chart of Accounts.
When you connect your bank, it automatically records a beginning balance based on how far back you downloaded transactions (usually 90 days back). If the account has any transactions prior to this time period, this automatically recorded opening balance may not be the correct beginning balance.
If your QuickBooks beginning balance doesn't match your statement's but there's no alert, check the following:
This is easy to miss, especially if you have multiple accounts with the same bank.
Click the Gear icon > Reconcile.
If you're reconciling the right month and the beginning balance is wrong and there's no alert, it's possible that this account has never been reconciled using the reconciliation tool in QuickBooks Online. We recommend that you call your accountant or us to help you sort this out.
Want to learn more about beginning balance discrepancies and how they happen? Are you wondering where to start? See Why doesn't my QuickBooks beginning balance match my statement?