Last Updated: October 26, 2026
Quick Summary
QuickBooks Online reconciliation is the process of comparing your accounting records to your bank statement and making sure they match. It involves reviewing your opening balance, matching transactions, and resolving discrepancies to ensure your financial data is accurate and trustworthy.
- Reconciliation has three core steps: review opening balance, match transactions, and investigate unmatched items
- Common discrepancies include duplicate transactions, incorrect amounts, timing issues, and unrecorded bank fees
- Reconcile in strict chronological order, starting with the oldest unreconciled month to prevent cascading errors
- Professional providers should hold QuickBooks ProAdvisor certification or bookkeeping credentials like CB or CPB
- Never provide bank username, password, or disable MFA when hiring a reconciliation service provider
Table of Contents
- Why QuickBooks Online Reconciliation Services Matter
- How to Reconcile in QuickBooks Online: The Core Process
- Handling QuickBooks Reconciliation Discrepancies
- Your QuickBooks Reconciliation Checklist for Accuracy
- QuickBooks Catch-Up Bookkeeping: Cleaning Years of Backlog
- When to Use a Professional Reconciliation Service
- Evaluating a QuickBooks Online Reconciliation Service Provider
- Book Your Free Financial Evaluation
- Frequently Asked Questions
Why QuickBooks Online Reconciliation Services Matter
Bank reconciliation is an important financial task for small businesses.
When your QuickBooks Online account doesn’t match your bank statement, you can’t trust your financial data, you can’t see real cash flow, make confident decisions, or survive tax season with incomplete records.
QuickBooks Online reconciliation services solve this by matching every transaction in your accounting software to your actual bank activity. At Over The Moon Bookkeeping LLC, we provide bookkeeping support to help business owners keep their financial records organized.
Below, we’ll show you how reconciliation works, how to do it yourself, and when professional help makes sense.
How to Reconcile in QuickBooks Online: The Core Process
QuickBooks Online reconciliation is the process of comparing your accounting records to your bank statement and making sure they match. When they don’t, you investigate why and correct the discrepancies.
The core process has three steps: review your opening balance, match transactions, and resolve any gaps.
Step 1: Review Your Opening Balance
Your opening balance is where reconciliation starts, the amount your bank says you had at the beginning of the period.
In QuickBooks Online, open the Reconcile tool, select the account, and enter the ending balance and statement date from your bank statement. The opening balance QuickBooks shows should match your bank’s figure for the previous period.
If it doesn’t match, you have a problem from an earlier period that needs fixing first. Don’t move forward until the opening balance is correct.
Step 2: Match Transactions to Your Bank Statement
QuickBooks displays all transactions for the period; your bank statement lists all deposits and withdrawals. Go through each statement line, find the matching QuickBooks entry, and mark it as matched.
Some transactions match immediately. Others may need investigation. A few appear in QuickBooks but not yet on the statement, outstanding items.
Step 3: Investigate and Resolve Unmatched Items
After matching what you can, some transactions will remain unmatched on either side.
Bank statement transactions with no QuickBooks match need to be investigated.
QuickBooks transactions missing from the bank statement may need investigation.
Reconciling QuickBooks Online for Beginners(page:1) provides step-by-step guidance if you’re new to the process and want more detail on each phase.
Handling QuickBooks Reconciliation Discrepancies
When your QuickBooks balance doesn’t match your bank statement, investigate the difference.
Possible causes include duplicate or missing transactions, incorrect amounts, transactions recorded in the wrong month, and unrecorded bank fees or interest.
Sometimes the issue is timing: a check written in December might not clear until January.
How to Clean Up QuickBooks Books: Step-by-Step Guide(page:2) walks you through fixing the specific errors that cause reconciliation problems, including duplicate entries and miscoded transactions.
Your QuickBooks Reconciliation Checklist for Accuracy
Use this checklist every time you reconcile to catch problems early and stay organized.
| Task | Frequency | Notes |
|---|---|---|
| Verify opening balance matches prior reconciliation | Monthly | Stop if it doesn’t match, fix prior period first |
| Review bank statement for new fees or interest | Monthly | Add to QuickBooks if missing |
| Match cleared transactions | Monthly | Use bank feed to speed this up |
| Investigate unmatched items | Monthly | Look for timing issues, duplicates, missing entries |
| Correct errors in QuickBooks | As needed | Never adjust the bank balance |
| Document the reconciliation | Monthly | Save for audit trail and tax time |
During reconciliation, take your time.
QuickBooks Catch-Up Bookkeeping: Cleaning Years of Backlog
If your QuickBooks account is behind, catch-up and clean-up bookkeeping can help organize your records.
Decide the scope before you touch anything
Define three things in writing first:
- The start date. The earliest month you can support with complete statements. If statements are missing, request them from your bank, most institutions provide at least seven years of statements on request, often for a fee.
- The end date. The last closed month. Everything after that is current work, not catch-up.
- The accounts in scope. Every bank, credit card, loan, and payment processor account that had activity during the period. Missing an account is the most common reason a cleanup has to be redone.
Build the source-of-truth file
Before importing anything, assemble a reconciliation binder: one folder per account per year containing the monthly statements as PDFs. This file becomes your audit trail and the reference for every adjustment. If a statement is missing, note it and move on, do not guess at balances.
Import and categorize in waves, not all at once
Export a transaction list from QuickBooks after each wave and tie the total to the sum of that year’s statement activity. If the totals don’t match, stop and find the gap before moving to the next year.
The four cleanup problems you will hit
Duplicate transactions.
Beginning balance changes.
Bank feed gaps.
Uncleared items that will never clear.
Reconcile in strict chronological order
Reconcile the oldest unreconciled month first, then the next, and so on. Each month’s opening balance depends on the prior month being correct, so skipping ahead guarantees a discrepancy you’ll have to unwind later. Use QuickBooks Online’s Reconcile tool with the statement ending balance and date for each month. When a month balances, save the reconciliation report to the binder and move on.
Know when to stop and call a professional
How to Clean Up QuickBooks Books: Step-by-Step Guide(page:2) walks you through fixing the specific errors that cause reconciliation problems, including duplicate entries and miscoded transactions.
When to Use a Professional Reconciliation Service
If your books are behind, Over The Moon Bookkeeping LLC offers catch-up and clean-up bookkeeping support.
Five Signs You Are Ready to Outsource Bookkeeping(page:3) outlines when outsourcing makes financial and strategic sense for your business.
Evaluating a QuickBooks Online Reconciliation Service Provider
If you decide to hire help, consider the scope of the services offered.
Credentials and qualifications to verify
- QuickBooks ProAdvisor certification. Intuit maintains a public ProAdvisor directory. Confirm the firm or individual appears there and check whether they hold the Online or Advanced tier.
- Bookkeeping certifications. The American Institute of Professional Bookkeepers (AIPB) offers the Certified Bookkeeper (CB) designation (The Certified Bookkeeper (CB) Designation). The National Association of Certified Public Bookkeepers (NACPB) offers the Certified Public Bookkeeper (CPB) license (2026 Certified Public Bookkeeper (CPB)). Either indicates formal training beyond software familiarity.
- CPA involvement. If your books feed into tax filing or lending decisions, ask whether a CPA reviews the work. A bookkeeper prepares; a CPA attests. Know which one you’re hiring.
- Errors and omissions (E&O) insurance and a surety bond. Ask for a certificate of insurance. A provider handling your bank data should carry professional liability coverage.
Scope: what “reconciliation service” actually includes
| Scope item | What to confirm |
|---|---|
| Bank and credit card accounts | Number of accounts covered; per-account fees for adding more |
| Loan and line-of-credit accounts | Whether liability balances are reconciled, not just payment entries |
| Payment processor accounts (Stripe, Square, PayPal) | Whether clearing accounts and fees are reconciled |
| Undeposited funds and merchant clearing | Whether these are cleaned up or ignored |
| Sales tax liability accounts | Whether the payable balance is reconciled to filed returns |
| Payroll clearing and tax liabilities | Whether payroll journal entries are tied out |
| Prior-period cleanup | Whether historical months are fixed or only current months |
| Month-end close and reporting | Whether you receive a reconciliation report and P&L/balance sheet |
| Communication cadence | Scheduled calls vs. email-only; response-time commitments |
Security and access controls
If a provider asks for your bank username and password, or requests that you disable MFA on your accounts, walk away. No legitimate bookkeeping engagement requires that.
Questions to ask before you sign
- Who will actually do the work, a named individual, or an offshore team you’ll never speak with?
- How many clients does each bookkeeper handle, and what is the typical turnaround after month-end?
- What happens when you find a discrepancy, do you correct it, flag it to me, or both?
- Can you show me a redacted sample reconciliation report and month-end package?
- How do you handle a prior year that was never reconciled?
- What is your policy if an error is found after you’ve closed a period?
- Are you a QuickBooks ProAdvisor, and can I verify that in Intuit’s directory?
- What are your fees for out-of-scope work, such as a large cleanup or audit support?
Pricing models and what they signal
What a FREE Book Evaluation Includes(page:4) shows what a professional evaluation covers, helping you understand what to expect when you consult with a provider.
Book Your Free Financial Evaluation
If your QuickBooks account is out of sync with your bank, or if you’re unsure whether your books are accurate, book a FREE Evaluation.
Contact me immediately for a FREE evaluation of your books. Pick a time below, or reach out by phone or email.(page:5)
Frequently Asked Questions
How do I reconcile a bank account in QuickBooks Online?
Start by opening your bank account in QuickBooks Online and selecting the Reconcile option. Enter your bank statement’s opening balance and ending balance, then review transactions from your bank statement. Match each cleared transaction by checking it off in QuickBooks. Once all transactions match and your cleared balance equals your bank statement balance, click Finish. If amounts don’t match, investigate uncleared or duplicate transactions before completing reconciliation.
What should I do if my QuickBooks Online balance doesn’t match my bank statement?
A mismatch may have several possible causes. Review the records and consider seeking professional bookkeeping support if you need help.
How often should I reconcile accounts in QuickBooks Online?
Monthly reconciliation is the standard practice and aligns with your bank statement cycle. Many businesses also reconcile credit card accounts monthly. Quarterly or annual reconciliation is insufficient because discrepancies compound over time, making them harder to trace. Regular monthly reconciliation ensures your financial statements remain accurate, catches errors early, and gives you reliable data for tax preparation and business decisions.
What is QuickBooks catch-up bookkeeping, and do I really need it?
Catch-up and clean-up bookkeeping can help organize historical financial records. Over The Moon Bookkeeping LLC offers catch-up and clean-up bookkeeping support.
Getting your QuickBooks Online account reconciled and accurate takes time and attention to detail. If you’re struggling with discrepancies, missing transactions, or simply don’t have the bandwidth to do it yourself, professional help removes the stress and gives you the financial clarity you need to run your business with confidence.
