Reconciling your accounts in QuickBooks Online is one of the most important bookkeeping habits you can develop. While the word “reconciliation” may sound intimidating, the process itself is quite straightforward once you understand the steps. More importantly, regular reconciliation ensures that your books are accurate, reliable, and ready for tax time or financial decision-making.
In this guide, we’ll walk through , and what to do if things don’t balance. Whether you’re a small business owner, freelancer, or bookkeeper, this guide will help you feel confident about reconciling your accounts.
Reconciliation is the process of comparing your QuickBooks Online records with your bank or credit card statements to make sure they match. In simple terms, you’re checking that:
Every transaction in QuickBooks appears on your bank statement
Every transaction on your bank statement is recorded correctly in QuickBooks
If the ending balance in QuickBooks matches the ending balance on your statement, your account is reconciled.
QuickBooks Online allows you to reconcile:
Bank accounts
Credit card accounts
Other account types, such as income or expense accounts, are not reconciled in the same way.
Reconciling regularly isn’t just an accounting task—it’s a powerful way to protect your business.
Here’s why reconciliation matters:
If your accounts aren’t reconciled, your profit and loss statement and balance sheet may be misleading. Decisions based on incorrect numbers can harm your business.
Reconciliation helps you spot:
Duplicate transactions
Missing income or expenses
Incorrect amounts
Bank fees you forgot to record
Unexpected withdrawals or charges become visible quickly when you reconcile.
Reconciled books mean fewer surprises and less stress during tax season.
Preparation is key. Before you begin, make sure you have the following:
You’ll need the statement for the period you’re reconciling. This can be a PDF, printed copy, or online statement.
The opening balance in QuickBooks must match the opening balance on your statement. If this is wrong, reconciliation will not work.
Ensure that all income, expenses, transfers, and fees for the period have been entered into QuickBooks.
Let’s walk through the reconciliation process in detail.
Sign in to your QuickBooks Online account using your credentials.
Click Settings in the top right corner
Select Reconcile under the “Tools” section
Select the bank or credit card account you want to reconcile. Be careful to choose the correct account, especially if you manage multiple accounts.
Click Start Reconciliation.
You’ll be prompted to enter:
Statement ending balance
Statement ending date
Enter these numbers exactly as shown on your bank or credit card statement.
If the opening balance matches, QuickBooks will allow you to proceed. If it doesn’t, QuickBooks will alert you, and you’ll need to investigate before continuing.
You’ll now see a list of transactions from QuickBooks for the selected period.
Your job is to:
Compare each transaction with your bank statement
Check off transactions that appear on the statement
As you check items, QuickBooks will automatically calculate the difference between the statement balance and QuickBooks balance.
Tips for this step:
Work methodically from top to bottom
Use the filter or search feature if the list is long
Don’t check transactions unless they appear on the statement
At the top of the screen, you’ll see a Difference amount.
If the difference is not zero, something is missing or incorrect
If the difference becomes $0.00, your reconciliation is complete
Take your time here—accuracy matters more than speed.
Once the difference is zero:
Click Finish now
QuickBooks will confirm the reconciliation
A reconciliation report will be generated automatically
Congratulations—your account is reconciled!
The best practice is to reconcile monthly, using your monthly bank or credit card statement.
Some businesses reconcile:
Weekly (high transaction volume)
Daily (cash-heavy businesses)
The more frequently you reconcile, the easier it becomes.
Even experienced users encounter issues. Here are common problems and practical solutions.
This usually happens if:
Someone edited or deleted a previously reconciled transaction
An account was set up incorrectly
Solution:
Review prior reconciliation reports and check for changes to older transactions.
Possible causes include:
Missing transactions
Duplicate entries
Incorrect amounts
Solution:
Compare each transaction line by line with your statement and double-check dates and amounts.
Sometimes transactions don’t appear because:
The date is outside the reconciliation period
They were recorded to the wrong account
Solution:
Adjust the date range or search for the transaction in another account.
This often happens when bank feeds and manual entries overlap.
Solution:
Delete or exclude the duplicate, but only after confirming which entry is correct.
Once an account is reconciled:
Transactions are marked as reconciled in QuickBooks
Financial reports become more reliable
You should avoid editing reconciled transactions
If a change is necessary, it’s best to consult an accountant or bookkeeper before making edits.
To make reconciliation smoother and stress-free, follow these best practices:
Reconcile every month without skipping periods
Avoid editing reconciled transactions
Attach bank statements to reconciliation reports
Review reconciliation reports regularly
Use bank feeds carefully and avoid duplicates
Reconciling in QuickBooks Online may feel tedious at first, but it’s one of the most valuable habits you can build for your business. It keeps your books clean, your reports accurate, and your financial decisions well-informed.
By following the steps outlined in this guide and reconciling consistently, you’ll gain confidence in your numbers and peace of mind knowing your financial data is reliable.
If reconciliation ever feels overwhelming, remember—it’s better to slow down and get it right than rush and risk errors. Over time, the process becomes second nature, and your business will be better for it.