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.
Our Mission: At Prestige Accounting Services Group, we are on a mission to redefine the tax experience for individuals and small businesses. With a focus on personalized service, strategic planning, and expert guidance, we aim to empower our clients to succeed financially with confidence and ease.
Expertise in Action: With a wealth of experience and a team of dedicated professionals, we specialize in individual and small business tax preparation. While we excel in all areas of taxation, our passion lies in serving the unique needs of small business owners in New Jersey. We understand that small business taxation requires specialized knowledge and attention to detail, which is why we go above and beyond to ensure our clients receive the guidance and support they deserve.
Tailored Solutions for Every Client: Whether you're a high-net-worth individual seeking comprehensive tax planning or a small business owner in need of accounting and bookkeeping assistance, we have the expertise to meet your needs. Our team takes the time to understand your specific situation and develop customized solutions that align with your goals and objectives.
Why Choose Us?: What sets us apart from other New Jersey tax firms is our commitment to excellence and innovation in the field of taxation. We don't just prepare tax returns; we provide strategic insights, proactive planning, and actionable advice to help our clients achieve their financial goals. With a team of two CPAs, an EA, and an ERO, we have the expertise and resources to deliver exceptional service and results.
Your Success is Our Priority: At Prestige Accounting Services Group, we measure our success by the success of our clients. We are dedicated to building long-lasting relationships, providing unparalleled service, and helping our clients thrive in today's ever-changing tax landscape.
We can't wait for you to experience the Prestige Accounting Services Group difference.
Get the latest in tax and small business updates and issues that affect your finances and growth prospects.