Monthly Reconciliation Statement: Complete Guide
Quick answer: A monthly reconciliation statement is set of reconciliation documents produced at end of every accounting period to verify that each balance sheet account matches its supporting source. It covers bank accounts, credit cards, accounts receivable, accounts payable, prepaids, fixed assets, and equity. The monthly cadence is what separates firms that close in 5 days from firms that close in 20.
You know what a reconciliation statement is. You know how bank reconciliation works in QBO. You know cash reconciliation covers more than just bank.
The question isn't "what" anymore. It's "how do I do this every single month, across every account, for every client, without it eating first two weeks of next month?"
That's what this guide is about. The monthly reconciliation workflow. The timeline. The tracker. The checklist that ensures nothing gets skipped. And automation that turns a 20-hour monthly process into a 4-hour exception review.
What a monthly reconciliation statement includes
A monthly reconciliation statement is not one document. It's a package. Every balance sheet account gets its own reconciliation, and package is complete set.
For a typical small business with 2 bank accounts, 2 credit cards, AR, AP, prepaids, fixed assets, and one loan, that's roughly 10-12 individual reconciliations per month. At 15-30 minutes each (manual), that's 3 to 6 hours just for reconciliation, before you even start on adjusting entries or financial statement review.
For a bookkeeper managing 15 clients, multiply by 15. That's 45 to 90 hours of reconciliation per month. This is why monthly reconciliation either gets automated or gets skipped.
The monthly reconciliation timeline
The reconciliation timeline determines whether you close in 5 business days or 15. Here's sequence that works.
A 5-day close is aggressive but achievable for small to mid-size businesses with clean books and consistent processes. The AICPA recommends that controllers aim for a close cycle under 10 business days. If your close takes 15+, bottleneck is almost always reconciliation (not analysis or reporting).
For full close workflow beyond reconciliation, see financial close and accounting close guides.
The monthly reconciliation tracker
Every firm needs a tracking document that shows status of each reconciliation for each client, each month. Without it, things fall through cracks.
This tracker is simplest version. It works in Google Sheets. Each client gets a tab. Each month gets a fresh copy. The controller reviews "Status" column daily during close week and follows up on anything stuck at "In Progress" or "Not Started" past Day 3.
For firms managing 20+ clients, a spreadsheet tracker becomes unwieldy. That's where tools like Finlens replace manual tracker with a dashboard that shows reconciliation status across all clients in one view.
How to prepare monthly bank reconciliation
The monthly bank reconciliation is first and largest reconciliation in package. Here's abbreviated process (full step-by-step QBO walkthrough is in bank reconciliation guide; document format is in reconciliation statement guide):
- Download bank statement for month from your US financial institution
- In QuickBooks Online, go to Accounting > Reconcile
- Enter statement ending balance and date
- Check off every matching transaction
- Investigate any differences (deposits in transit, outstanding checks, bank fees, errors)
- Reach a $0 difference and finish
- Save reconciliation report as documentation
Repeat for every bank account, every credit card. In US, bank statements are typically available by 1st business day of following month. Credit card statements may close on different dates (15th, 25th), so check cycle date for each card.
Monthly bank reconciliation best practices:
- Reconcile same week you receive statement. Don't let it sit.
- Review reconciliation report after finishing. Does beginning balance match last month's ending balance? If not, someone edited a transaction in a prior closed period.
- Lock closing date in QBO after reconciliation to prevent retroactive edits.
- File report. This is audit documentation.
What to do when a monthly reconciliation doesn't balance
The reconciliation for a given account doesn't always balance on first pass. Here's systematic approach:
Step 1: Check beginning balance. If beginning balance in QBO doesn't match last month's ending balance, a transaction in a prior period was edited or deleted. Run prior month's reconciliation report and compare.
Step 2: Look for duplicates. Same vendor, same amount, same date recorded twice. QBO's bank feed imports sometimes create duplicates when a transaction is also entered manually.
Step 3: Look for missing transactions. A bank fee on statement that nobody recorded. A deposit on books that bank reversed (NSF check). A payment that posted to wrong account.
Step 4: Check for transpositions. $1,530 recorded as $1,350. The difference is always divisible by 9 when two digits are swapped. If your unresolved difference is divisible by 9, start looking for transposition errors.
Step 5: Check for rounding. Multi-currency transactions, tax calculations, and percentage-based fees can create small rounding differences. If difference is under $1, it's likely rounding. Document it and record a small adjustment.
If difference is larger than your materiality threshold and you can't find it after 30 minutes, flag it on tracker, move to next account, and come back with fresh eyes. Staring at same transactions for an hour rarely produces answer. A colleague reviewing it often finds it in 5 minutes.
The monthly reconciliation checklist (all accounts)
For firms that want a single checklist to follow each month:
That's 17 tasks. For a single small business client, this takes 3 to 6 hours when done manually. For a firm managing 15 clients, it's 45 to 90 hours per month. The tasks that repeat identically every month (steps 8-12) are automation candidates.
How to automate monthly reconciliation process
Three levels of automation, from basic to full:
Level 1: Recurring journal entries in QBO. Set up recurring transactions for fixed-amount adjusting entries (monthly depreciation, prepaid amortization at consistent amounts). These post automatically on your schedule. This saves 15 to 30 minutes per client per month.
Level 2: Bank feed automation. Ensure every bank account and credit card is connected to QBO via bank feed. Auto-categorization rules handle recurring transactions (same vendor, same amount, same category). This saves time on steps 2 through 4 by reducing manual matching.
Level 3: Platform automation. Finlens automates matching, categorization, reconciliation, and adjusting entry process across all accounts and all clients. The monthly reconciliation statement package is produced automatically. The bookkeeper reviews exceptions (unmatched transactions, unexpected variances, new vendors) instead of manually reconciling every line.
The goal at Level 3 is to reduce 3 to 6 hours per client to under 90 minutes, with human time focused entirely on judgment calls: is this new vendor legitimate? Should this invoice be written off? Does this prepaid schedule need updating?
Monthly reconciliation for multi-client accounting firms
For firms managing 15 to 50+ clients, monthly reconciliation process has to scale. The math is simple: if each client takes 4 hours and you have 30 clients, that's 120 hours of reconciliation per month. One person working full-time produces roughly 160 hours per month. That means reconciliation alone consumes 75% of one full-time employee's capacity.
The firms that scale past this do three things:
Standardize process. Every client follows same checklist (one above). Same order, same tracker, same documentation format. New team members can pick up any client because process is identical.
Stagger close dates. Not every client needs to close on Day 5. Spread clients across month. Some close by 5th. Some by 10th. Some by 15th. This prevents bottleneck of 30 clients all needing reconciliation in same week.
Automate repetitive work. Bank matching, recurring entries, and schedule-based reconciliations (prepaids, depreciation) are same every month. Automate them. The human reviews exceptions and handles 5 to 10% of transactions that need judgment. Finlens is built for this exact workflow. The bookkeeping for startups covers how this fits into broader service model.
FAQ
What is a monthly reconciliation statement?
A monthly reconciliation statement is set of reconciliation documents produced at each month-end to verify that every balance sheet account matches its supporting source. It covers bank accounts, credit cards, AR, AP, prepaids, fixed assets, loans, deferred revenue, and equity.
How often should reconciliation statements be prepared?
Monthly is standard for all balance sheet accounts. High-volume cash accounts (checking, registers) benefit from weekly reconciliation. The complete monthly reconciliation package should be finished within 5 to 10 business days of month-end.
How do you prepare a monthly bank reconciliation?
Download bank statement, open reconcile tool in QBO, enter ending balance, check off matching transactions, investigate differences (deposits in transit, outstanding checks, bank fees), reach a zero difference, and save reconciliation report. Repeat for every bank account. See bank reconciliation guide for full QBO walkthrough.
What's difference between a reconciliation statement and a monthly reconciliation statement?
A reconciliation statement is a single document for one account. A monthly reconciliation statement is complete package of all reconciliation documents produced at month-end. The monthly version includes reconciliation statements for every balance sheet account, not just one.
How long should monthly reconciliation take?
For a single small business: 3 to 6 hours manually. With bank feed automation: 2 to 3 hours. With full platform automation (Finlens): under 90 minutes. The biggest time savings come from automated matching and recurring adjusting entries.
What do I do if a reconciliation doesn't balance?
Check beginning balance against last month's ending balance. Look for duplicates. Look for missing transactions. Check for transposition errors (difference divisible by 9). Check for rounding. If you can't find it in 30 minutes, flag it, move on, and return with fresh eyes.
