A step-by-step reconciliation method for QuickBooks Online, plus the independent spreadsheet control that helps you prove the difference instead of plugging it.
QuickBooks Online already has a reconciliation workflow. The spreadsheet’s job is different: it gives you an independent workpaper for the statement balance, book balance, deposits in transit, outstanding checks, bank charges, and the unexplained difference. That separation is valuable when the QuickBooks difference is not zero and you need a calm place to prove what belongs in the current period.
Use QuickBooks as the ledger and the workbook as the control. Do not maintain two competing sets of books, and never “fix” a difference by posting an unexplained adjustment. The goal is a reconciliation that another person can follow from statement to ledger without guessing.
Before you begin, confirm that you are reconciling one account, one statement period, and one ending balance. Mixing a bank feed balance with a statement balance is the most common false start.
The Month-End Close Template includes a Bank Reconciliation sheet for bank versus book, deposits in transit, outstanding checks, and bank fees, interest, or NSF adjustments. Its Close Checklist places reconciliation in the full monthly sequence, while the Journal Entries sheet records accruals, depreciation, and corrections and the P&L Dashboard shows the reviewed result.
Forcing the ending balance, deleting a reconciled transaction, changing an old date, or combining several accounts can make this month balance while damaging the next one. Investigate stale checks rather than quietly removing them; a payment may have been duplicated, lost, or recorded to the wrong payee.
For an individual business, start with the $29 Month-End Close Template and use its reconciliation sheet beside QuickBooks. Firms that want to standardize the workbook across clients can review the $299-per-year Firm License, which covers the catalog for unlimited clients under one firm license.
No. It is an Excel and Google Sheets workbook used as an independent close and reconciliation workpaper beside QuickBooks Online. It does not connect to or import from QuickBooks.
Common causes are duplicates, missing bank charges, transactions dated in the wrong period, edited reconciled items, deposits recorded net instead of gross, or an incorrect beginning balance.
The Firm License is the route for client use across a practice. A single retail template purchase should not be treated as a firm-wide license.