Learn how to reconcile your accounts so they always match your bank and credit card statements.
Just like balancing your chequebook, you need to review your accounts in QuickBooks to make sure they match your bank and credit card statements. This process is called reconciling.
When you have your bank statement in hand, you'll compare each transaction with the ones entered into QuickBooks. If everything matches, you know your accounts are balanced and accurate. We recommend reconciling your current, savings, and credit card accounts every month. Here's how to get started. Or, check out our complete reconciliation guide.
Step 1: Review your opening balance
If you're reconciling an account for the first time, review the opening balance. It needs to match the balance of your real-life bank account for the day you decided to start tracking transactions in QuickBooks.
Once you have your monthly bank or credit card statement, you can start reconciling. If you're reconciling multiple months, do them one statement at a time, starting with your oldest statement:
Go to Settings ⚙ and then Reconcile (Take me there). If you're reconciling for the very first time, select Get started.
From the Account ▼ dropdown, select the account you want to reconcile. Make sure it's the same one on your statement.
Important: If you see a message about a previous reconciliation, select We can help you fix it. You need to fix this before you start.
Review the Beginning balance. Make sure the beginning balance in QuickBooks matches the one on your statement. Here's what to do if they don't match.
Enter the Ending balance and Ending date on your statement. Some banks call the ending balance a "new balance" or a "closing balance."
If you see it, review the Last statement ending date. This is the end date of your last reconciliation. Your current bank statement should start the day after.
When you're ready to start, select Start reconciling.
Now, simply compare the transactions on your statement with what's in QuickBooks. Go over them one-by-one. The tricky part is making sure you have the right dates and transactions in QuickBooks so you know everything matches.
Follow the section for the type of account you're reconciling:
Since all of your transaction info comes directly from your bank, reconciling should be a breeze. In some cases, your accounts are already balanced.
Start with the first transaction on your statement.
Find the same transaction in the Reconciliation window in QuickBooks.
Compare the two transactions. If they match, put a tick next to the amount in QuickBooks. This marks it as reconciled.
If a transaction doesn't appear on your statement but you see it in QuickBooks, don't put a tick.
Compare each transaction in your statement with what's in QuickBooks. Tip: If you're absolutely sure you've found a match but something small isn't quite right, like the payee, don't worry. Select the transaction in QuickBooks to expand the view. Then select Edit. Make edits so the details match your statement.
When you reach the end, the difference between your statement and QuickBooks should be EUR €0.00. If it is, select Finish now.
Note: If the difference isn't EUR €0.00, or you can't find a transaction that should be in QuickBooks, don't worry. Here's how to review and fix common issues.
Not connected to online banking? No problem. Here's what to do:
Start with the first transaction on your statement.
Find the same transaction in the Reconciliation window in QuickBooks.
Compare the two transactions. If they match, put a tick next to the amount in QuickBooks. This marks it as reconciled.
If a transaction doesn't appear in your statement but you see it in QuickBooks, don't put a tick.
Compare each transaction in your statement with what's in QuickBooks. Tip: If you're absolutely sure you've found a match but something small isn't quite right, like the payee, don't worry. Select the transaction in QuickBooks to expand the view. Then select Edit. Make edits so the details match your statement.
When you reach the end, the difference between your statement and QuickBooks should be EUR €0.00. If it is, select Finish now.
Note: If the difference isn't EUR €0.00, or you can't find a transaction that should be in QuickBooks, don't worry. Here's how to review and fix common issues.
You can make changes to past reconciliations, but be careful. Changes can unbalance your accounts and other reconciliations. It also affects the beginning balance of your next reconciliation.
