SMALL BUSINESS BOOKKEEPING GUIDE
How to reconcile bank accounts in QuickBooks Online
A practical, statement-by-statement guide to matching transactions, understanding reconciliation differences and keeping your small-business books organized.
By Bryan Dietz · Dietz Bookkeeping · Tampa-based, serving businesses nationwide
The short answer
To reconcile an account in QuickBooks Online, select the correct account and statement period, enter the bank statement’s ending balance and date, match the cleared transactions in QuickBooks to that statement, investigate any remaining difference, and finish once the difference is $0.00. Save the reconciliation report for your records.
This is general bookkeeping education, not an audit or a recommendation to edit historical records without review. QuickBooks screens may change over time.
Why reconciliation matters
A QuickBooks bank balance and the bank’s actual statement balance are not always the same. An outstanding check, a transaction entered twice, a processor fee or a payment still in transit can change the picture. Reconciliation helps you explain those differences for a particular statement period rather than simply trusting the bank feed.
For a cleaning company, that may involve a recurring client deposit and card fees. For a handyman or contracting business, it may involve material purchases and checks that have not cleared. The records and accounting treatment depend on what actually happened in the business.
Before you start: gather these records
- The complete bank or credit card statement for the period, including the ending date and balance.
- Access to the matching account in QuickBooks Online, with downloaded transactions reviewed and categorized.
- The prior reconciliation report, if the account has been reconciled before.
- Invoices, receipts and payment processor records that help explain uncertain activity.
Use your bank’s official statement, not just a screenshot of your current online balance. Never share banking passwords through a public contact or estimate form.
Step-by-step: reconcile in QuickBooks Online
Intuit’s current navigation starts at All apps → Accounting → Reconcile. If your QuickBooks layout differs, use its in-app search for “Reconcile.” Check Intuit’s current instructions.
- 1
Check the account and opening point
Choose the specific bank or credit card account you intend to reconcile. If it has been reconciled before, the beginning balance should agree with the previous reconciliation. If this is your first reconciliation, verify the opening balance against the appropriate statement.
- 2
Open the Reconcile screen
In the current QuickBooks Online interface, go to All apps, Accounting, then Reconcile (menus can vary by product view). Select Reconcile or Get started, and choose the account from the account list.
- 3
Enter the statement ending information
Use the ending balance and ending date printed on the actual bank or card statement. Confirm the last statement ending date makes sense before you start reconciling.
- 4
Compare the transactions line by line
Check QuickBooks transactions against the statement for the same account and period. Mark only the items that cleared the account according to the statement. Review dates, amounts, deposits, withdrawals and transfer details rather than checking every imported item automatically.
- 5
Resolve any difference before finishing
The reconciliation difference should reach $0.00 after the correct transactions have been matched. If it does not, recheck the ending information, missing or duplicated entries, fees and transactions marked as cleared in error. Do not invent an entry merely to force a zero difference.
- 6
Finish and save the report
When the difference is zero and you have reviewed the matching transactions, choose Finish now and Done. QuickBooks Online saves a reconciliation report that you can later access using History by account.
Example: tracking down an $18 difference
Imagine a small business finishes checking its statement transactions, but QuickBooks still shows an $18.00 difference. The bank statement includes a confirmed $18.00 monthly service charge, and the bookkeeper finds that no matching charge was recorded in QuickBooks.
Unresolved difference
$18.00
Verified missing bank fee
$18.00
Difference after correct entry and matching
$0.00
Illustrative example only; not a customer case. The proper entry depends on the account, source documents and existing bookkeeping. Do not post a guessed fee to make the numbers agree.
When your QuickBooks reconciliation does not match
Beginning balance does not match
Review the previous reconciliation or the first opening balance. A previously reconciled entry may have been edited, removed or unreconciled. Investigate before changing historical entries.
Difference remains after matching
Verify statement ending date and balance, then check for missing deposits, bank charges, duplicates, wrong amounts, outstanding checks and items matched to the wrong month.
Downloaded transactions look correct
Bank feeds are useful but do not replace the official statement. Confirm whether each entry was categorized or matched correctly and belongs to the relevant account.
Old months have never been reconciled
Identify the oldest incomplete period and gather statements before proceeding. A backlog may need a separate cleanup plan rather than a quick one-month fix.
Avoid forcing a reconciliation to balance
An adjustment may hide the actual cause of the discrepancy. If you cannot identify why the books differ from the statement, review the source records or consult an accountant rather than creating an unsupported adjusting entry.
Intuit has separate instructions for incorrect beginning balances and differences at the end of reconciliation.
After reconciliation: keep the process repeatable
Save or retain the QuickBooks reconciliation report with the corresponding bank statement. Track outstanding or unresolved items with the person responsible for the books. For many small businesses, repeating this process when each monthly statement closes keeps discrepancies from accumulating.
Reconciliation supports accurate bookkeeping, but it does not by itself prove every transaction was correctly classified, that the financial statements are audited, or that fraud has been ruled out.
If you want help making account reviews part of a regular bookkeeping routine, see our QuickBooks Online bookkeeping service. We can discuss the records involved, reconciliations and reports before agreeing on a monthly scope.
QuickBooks reconciliation FAQs
Does a QuickBooks bank feed automatically reconcile my accounts?
No. Downloaded transactions can make matching easier, but reconciliation still involves comparing the bookkeeping records with the official statement for a defined period.
What should I do if my beginning balance is wrong?
Check whether this is the first reconciliation or a later one. For a later reconciliation, review the prior report and any changes to already reconciled transactions. Avoid deleting or changing old entries without understanding their effect.
Can I finish when QuickBooks shows a difference?
QuickBooks may offer an adjustment, but that can create another accounting entry rather than resolve the underlying problem. Intuit advises treating adjustments as a last resort and consulting an accountant when unsure.
How often should I reconcile bank and credit card accounts?
A monthly reconciliation for each business account after its statement closes is a practical routine for many small businesses. Your actual schedule may depend on activity and reporting needs.
Is reconciling the same as categorizing bank transactions?
No. Categorization records what an item represents; reconciliation checks whether the recorded activity agrees with the bank or credit card statement for that period.
Can Dietz Bookkeeping help me if several months are missing?
We can review your accounts, statements and the periods needing attention, then discuss a separate cleanup scope. Monthly bookkeeping and historical cleanup are quoted based on the work involved.
Official QuickBooks references
The product navigation and reconciliation guidance were checked against Intuit’s current help documentation. Always follow the steps shown in your own QuickBooks Online account.
- Reconcile an account in QuickBooks Online — Intuit
- Fix beginning balance issues — Intuit
- Fix an ending reconciliation difference — Intuit
Guide prepared by Dietz Bookkeeping. QuickBooks is a trademark of Intuit Inc.; Dietz Bookkeeping is an independent business and does not claim Intuit endorsement through this article.
Need help reconciling your business accounts?
Dietz Bookkeeping offers remote account reconciliation, monthly bookkeeping and separate catch-up discussions for small businesses across the United States. Tell us what is behind, which accounts are involved and what records you have available.
Work directly with Bryan Dietz · Tampa-based · Available remotely nationwide