If there’s one QuickBooks task that separates clean books from chaos, it’s this: Reconciliation.
Yet, it’s also one of the most skipped, or misunderstood, steps in QuickBooks Online. If your reports don’t match your bank balance, your numbers feel “off,” or tax season always turns into a scramble… there’s a good chance reconciliation is the missing piece.
Here’s exactly how to do it — step by step — in QuickBooks Online.
Reconciliation simply means making sure the transactions in QuickBooks match your bank and credit card statements
You’re confirming that:
Every transaction is recorded
Nothing is duplicated
Nothing is missing
If everything lines up, your books are accurate.
If not, you’ve got something to fix, and it’s better to catch it now than at tax time.
Before reconciling, make sure you have:
Your latest bank or credit card statement
Access to QuickBooks Online
All transactions entered (or bank feed updated)
Pro tip: Always reconcile monthly, not once a year.
Step 1: Go to the Reconcile Tool
In QuickBooks Online:
Click Accounting (left menu)
Select Reconcile
From there:
Choose the account (bank or credit card)
Enter the statement ending balance
Enter the statement ending date
Click Start reconciling
Step 2: Match Transactions
You’ll now see a list of transactions.
Your job: Check off each transaction that appears on your bank statement
As you do this:
The difference at the top should move toward $0.00
Step 3: Watch for Red Flags
If things don’t match, look for:
Duplicate Transactions
Common when:
Bank feeds import twice
Manual entries overlap with imports
Missing Transactions
If it’s on your bank statement but not in QuickBooks:
You’ll need to add it
Incorrect Amounts
Even small differences matter — fix them immediately.
Uncategorized Items
These may reconcile, but they’ll cause problems later (especially at tax time).
Step 4: Get the Difference to $0.00
This is the goal: Difference = $0.00
If it’s not zero:
Double-check amounts
Review unchecked transactions
Look for duplicates
Do NOT force it to balance with adjustments unless you understand why it’s off.
Step 5: Finish and Save the Reconciliation
Once the difference is $0:
Click Finish now
QuickBooks will save your reconciliation and generate a report. Save that report. It’s your audit trail.
Step 6: Review Your Reconciliation Report
After finishing:
Go to Reports → Reconciliation Reports
This shows:
What was matched
What’s still outstanding
Your ending balance
If something looks off, this is where you’ll catch it.
Common Mistakes to Avoid
Even experienced users run into these:
Reconciling Too Late
Waiting months (or a year) makes errors harder to fix.
Ignoring Small Differences
A $5 error today can turn into a $5,000 issue over time.
Using “Plug” Adjustments
Adding random entries just to make it balance creates bigger problems later.
Not Reconciling Credit Cards
These accounts are often overlooked and just as important.
How Often Should You Reconcile?
At minimum: Once per month per account
If you have high transaction volume: Weekly is even better
If you’re seeing:
Large unexplained differences
Multiple months unreconciled
Reports that don’t make sense
…it’s worth having a professional review your books.
Because reconciliation issues don’t fix themselves — they compound into even worse problems that could seriously impact your bottom line.
Reconciliation isn’t just a QuickBooks task. It’s the foundation of accurate financial reporting.
Done consistently, it helps you:
Trust your numbers
Catch errors early
Avoid tax-time stress
Make better business decisions
The best part? Once you get into a rhythm, it takes less than an hour per month.
Sign up for our newsletters and get our articles delivered right to your inbox.
Check the background of your financial professional on FINRA's BrokerCheck
Avantax affiliated Financial Professionals may only conduct business with residents of the states for which they are properly registered. Please note that not all of the investments and services mentioned are available in every state. Securities offered through Avantax Investment Services℠, Member FINRA, SIPC, Investment Advisory services offered through Avantax Advisory ServicesSM, Insurance services offered through an Avantax affiliated insurance agency. 3200 Olympus Blvd., Suite 100, Dallas, TX 75019. 972-870-6000.
The Avantax family of companies exclusively provide financial products and services through its financial representatives. Although Avantax Wealth Management® does not provide or supervise tax or accounting services, Avantax representatives may offer these services through their independent outside business. Content, links, and some material within this website may have been created by a third party for use by an Avantax affiliated representative. This content is for educational and informational purposes only and does not represent the views and opinions of Avantax Wealth Management® or its subsidiaries. Avantax Wealth Management® is not responsible for and does not control, adopt, or endorse any content contained on any third party website.
This information is not intended as tax or legal advice. Please consult legal or tax professionals for specific information regarding your individual situation.
The information being provided is strictly as a courtesy. When you link to any of the web sites provided here, you are leaving this web site. We make no representation as to the completeness or accuracy of information provided at these web sites. Nor is the company liable for any direct or indirect technical or system issues or any consequences.
For Important Information and Form CRS please visit https://www.avantax.com/disclosures.