Reconciling QuickBooks at Month-End: A Step-by-Step Checklist

Month-end reconciliation is the process of matching every transaction in QuickBooks against your actual bank, credit card, and loan statements so your books reflect reality – not just what got entered. Skip it, and small errors compound into big problems by tax time. This checklist walks through all nine steps, in order, so nothing gets missed.

Built for U.S. small businesses, bookkeepers, and controllers closing their books in QuickBooks Online or QuickBooks Desktop.

WHY IT MATTERS

Reconciling QuickBooks at Month-End: A Step-by-Step Checklist

Reconciliation isn’t paperwork for its own sake – it’s what keeps the rest of your financial picture trustworthy. A month-end close process that includes reconciliation catches problems while they’re still small and cheap to fix.

  • Prevents inaccurate tax filings and IRS discrepancy notices
  • Protects cash flow visibility for payroll and vendor obligations
  • Keeps books audit-ready for lenders, investors, or IRS review
  • Catches fraud, duplicate charges, or bookkeeping errors early
  • Supports GAAP compliance for small businesses that need lender-ready financials

Before You Start

What You Need Before You Start Reconciling

Gather these before you open the Reconcile tool. Doing this upfront means you can move through the checklist below without stopping to hunt down documents.

  • Current bank, credit card, and loan statements (PDF or CSV)
  • Prior month's completed reconciliation report
  • Access to the QuickBooks Online bank feed and connected accounts
  • Payroll provider reports for the period
  • Sales tax liability report by state and jurisdiction
  • Up-to-date chart of accounts
The Process

The 9-Step QuickBooks Month-End Reconciliation Checklist

Work through these in order. Each step builds on the last, and the goal at every stage is the same: a difference that reads zero before you move on.

Reconcile Bank & Credit Card Accounts

Pull every bank, credit card, and loan statement for the month, then confirm each account’s opening balance ties out to last month’s reconciled closing balance before you touch anything else.

  • Download statements for every connected account
  • Confirm the beginning balance matches last month's ending balance
  • Note the statement end date you're reconciling to

Work through the QuickBooks bank feed first. Match imported transactions to existing entries and categorize anything new before you open the Reconcile tool this step alone prevents most of the discrepancies people run into later.

  • Use "Find Match" before creating new entries
  • Apply or refine bank rules for recurring vendors
  • Flag anything that can't be matched for follow-up

Open the Reconcile tool for each account, check off cleared transactions against the statement, and don’t finish until the difference reads zero.

  • Enter the statement ending balance and date
  • Check off every cleared transaction
  • Investigate any non-zero difference before completing

Pull the A/R Aging Summary and compare it to the general ledger balance. This is where you catch unapplied payments and confirm invoiced revenue is actually reflected correctly.

  • Run the A/R Aging Summary and compare it to the GL
  • Apply unapplied customer payments and credits
  • Write off or flag long-overdue balances per your policy

Do the same on the payable side: compare the A/P Aging Summary to the GL to confirm vendor bills, payments, and outstanding balances match what you actually owe.

  • Run the A/R Aging Summary and compare it to the GL
  • Apply unapplied customer payments and credits
  • Write off or flag long-overdue balances per your policy

Match payroll tax deposits and liability accounts against your payroll provider’s reports to confirm federal (941/940) and state payroll taxes are fully accounted for.

  • Match payroll runs to bank withdrawals
  • Confirm payroll liabilities cleared after tax payments post
  • Reconcile employer tax accounts to provider reports

Use the Sales Tax Center not manual journal entries to confirm collected sales tax by state and jurisdiction matches what’s actually due before your next filing deadline.

  • Compare the Sales Tax Liability Report to the GL balance
  • Confirm rates by state and local jurisdiction
  • Adjust correctly for exempt or out-of-state sales

Generate the Reconciliation Report and Reconciliation Discrepancy Report for every account. These documents are what you’ll pull if a lender, investor, or the IRS ever asks how you closed the books.

  • Save or export the Reconciliation Report per account
  • Review the Discrepancy Report for red flags
  • Archive reports in a dedicated month-end folder

Set the QuickBooks closing date and password so reconciled transactions can’t be edited without leaving a trail, then move on to next month.

  • Set the closing date to the last day reconciled
  • Apply a closing date password
  • Log any post-close changes with a reason in the audit log

Before You Start

Balanced. Documented. Locked.

Once every account clears with a zero difference, the job isn’t quite done. Export the Reconciliation Report for each account, archive it somewhere you’ll actually find it again, then set a closing date password so the period can’t be quietly reopened. That’s what turns a reconciled month into an audit-ready one.

Before You Start

Common QuickBooks Reconciliation
Errors (and How to Fix Them)

Most reconciliation headaches trace back to one of a handful of causes. Here’s what to check
first when the numbers won’t line up.
Error Likely Cause Fix
Beginning balance doesn’t match bank statement A prior period’s reconciliation was edited or deleted after it was closed Run the Reconciliation Discrepancy Report, restore the prior period’s closing balance, then re-lock it with a closing date password
Duplicate transactions after connecting a bank feed The same transaction was entered manually and also imported via the bank feed Match, don’t add, imported transactions to existing entries – use “Find Match” before “Add”
Uncleared or stale transactions from 60+ days ago Outstanding checks, unrecorded fees, or forgotten manual entries Review the uncleared list on the Reconciliation Report, then contact the payee or void and reissue stale checks
Reconciliation adjustment needed to force a match A hidden data-entry error or a missing transaction Skip the auto-adjustment shortcut; track down the exact missing or incorrect entry before closing the period
Sales tax payable balance looks off Tax rate changes, exempt sales miscoded, or manual journal entries that bypassed the Sales Tax Center Reconcile through the Sales Tax Center rather than manual GL entries, and confirm rates by state and jurisdiction
Payroll liabilities don’t clear after tax payments Payroll was run in a separate system, or e-payments haven’t synced Match payroll tax payments to liability entries using the Payroll Tax Center or a bank feed rule
 

Built-In Tools

QuickBooks Features That Make Reconciliation Easier

QuickBooks has several built-in tools that, used consistently, cut down how much manual cleanup each month-end requires.

Bank Rules

Auto-categorize recurring vendor and customer transactions.

Reconcile Tool

Built-in statement matching with a running difference.

Reconciliation Discrepancy Report

Flags changes made after a period was closed.

Audit Log

Tracks every edit for accountability and IRS-ready documentation.

Closing Date & Password

Locks reconciled periods from accidental edits.

QuickBooks Online Accountant view

Lets an outside bookkeeper reconcile remotely.

U.S. Compliance

U.S. Compliance Considerations for Month-End Reconciliation

Reconciliation isn’t just good practice for U.S. businesses, it directly supports several compliance obligations.

  • IRS recordkeeping — keep reconciliation reports for three to seven years to support your filings
  • 1099-NEC tracking — reconcile vendor payment totals before year-end issuance
  • Multi-state sales tax nexus — confirm collected tax matches your liability by state
  • Payroll tax deposits — match 941/940 deposits to payroll liability accounts
  • GAAP-consistent reporting — often required for lenders, investors, or SBA loan applications

Habits

Best Practices to Keep Your Books Audit-Ready Year-Round

A smooth month-end close is mostly a matter of habit. These practices make each month easier than the last.

  • Reconcile on the same date every month to build a consistent habit
  • Keep business and personal accounts fully separate at all times
  • Review bank rules periodically so auto-categorization stays accurate
  • Archive every reconciliation report in a dedicated month-end folder
  • Schedule a quarterly review with a bookkeeper or accountant

Monthly, at minimum, and always before filing quarterly payroll or sales tax returns. Businesses with high transaction volume often reconcile bank and credit card accounts weekly and close the full books monthly.

Don’t force an adjusting entry. Compare statement dates, check for duplicate or missing transactions, and confirm the beginning balance matches the last accepted reconciliation before digging further.

Many owners handle basic bank account reconciliation on their own. Multi-entity, payroll, sales tax, or investor-reporting situations usually benefit from a bookkeeper or accountant to reduce IRS and audit risk.

Categorizing assigns a transaction to the correct account for reporting. Reconciling confirms that every categorized transaction actually matches an external bank or credit card statement, dollar for dollar.

The IRS generally recommends keeping financial records, including reconciliation reports, for at least three years, and up to seven years if a return involves worthless securities or bad debt deductions.

Timelines vary by scope and complexity. Targeted initiatives like AI automation take three to six months. Enterprise-wide programs typically span 18 to 36 months with phased rollouts ensuring continuous value delivery.

Frequently Asked Questions