Why a repeatable month-end close checklist matters
The fastest way to make month-end slower is to improvise it. When you close each client a little differently, you spend mental energy deciding what to do next instead of doing it, and small steps get skipped on busy days. A written checklist turns the close into a sequence you can run on autopilot, hand to a team member, or audit later if a client questions a number.
It also protects you. A standardized close is the single best defense against duplicate, missing, and miscategorized transactions slipping into a client's financials. The steps below assume QuickBooks Online, but the structure applies to any cloud ledger. Work through them in order: each one depends on the one before it.
Phase 1: Get the data in (before you reconcile)
You cannot reconcile an account that is missing transactions, so the first job is making sure everything that happened during the period is actually in the books.
- Clear the bank feed. Open the bank feed and categorize or match every transaction up to the statement date. Don't reconcile until the "For review" tab is empty for the period you're closing.
- Apply and review your bank rules. Rules cut manual coding and keep categorization consistent month to month, but they also quietly miscode things when a vendor's description changes. Spot-check a handful of rule-matched transactions instead of trusting them blindly.
- Enter anything outside the feed. Cash expenses, owner reimbursements, journal entries, and bills that haven't hit the bank yet need to be recorded now, not discovered during reconciliation.
- Confirm the statement period. Have the bank and credit card statements in hand with their closing dates and ending balances. You'll reconcile to those exact figures.
Phase 2: Reconcile every account
Reconciliation is the heart of the close. Every reliable month-end starts here, because an account that ties out is an account you can build a report on.
- Reconcile bank accounts. In QuickBooks Online, go to the reconcile screen, enter the statement ending balance and date, and match transactions line by line. The difference should be zero before you finish.
- Reconcile credit cards. Treat each card like a bank account. Enter charges, match them to the statement, and reconcile to the ending balance.
- Reconcile loans and lines of credit. Tie the balance to the lender statement and confirm the principal/interest split on any payments.
- Investigate uncleared items. Old uncleared checks or deposits are a red flag, they may be duplicates, voided payments, or data entry errors. Don't force a reconciliation; find out why the item never cleared.
If the reconciliation won't balance, resist the urge to plug the difference to a clearing account and move on. A forced reconciliation hides exactly the kind of error your client is paying you to catch.
Phase 3: The 5 data-quality checks
Reconciled accounts tell you the cash is right. They don't tell you the books are clean. These five checks catch the issues that quietly distort a client's financial statements even when every account ties out. Run all five, every month.
1. Uncategorized transactions
Look for balances sitting in Uncategorized Income, Uncategorized Expense, Uncategorized Asset, or the Ask My Accountant account. A common rule of thumb: if your Profit & Loss or Balance Sheet shows an "Uncategorized" line with more than a few hundred dollars on it, the file needs attention before you report. Reclassify each item to the right account; if you genuinely don't know, ask the client rather than guessing.
2. Opening Balance Equity
Opening Balance Equity is a holding account QuickBooks creates when opening balances are entered, for example when a new account is connected or a balance is set during setup. In a clean file, this account should be zero. A lingering balance almost always means an opening balance was entered but never moved to retained earnings or the correct equity/asset account. If you see a balance here, trace where it came from and clear it. We cover the full process in our guide to fixing Opening Balance Equity in QuickBooks Online.
3. Duplicate transactions
Duplicates creep in when a transaction is both manually entered and matched from the bank feed, or when a feed re-imports after a connection hiccup. Scan for two identical amounts to the same payee on the same or adjacent dates. Duplicates inflate expenses, understate profit, and can throw off sales tax.
4. Missing payees and accounts
Transactions with no payee (or no category) make reports vague and trip up year-end 1099 prep. Filter your expense detail for blank payee fields and fill them in while the context is fresh. A name you can identify today is a mystery in February.
5. Negative balances and oddities
Check for accounts that shouldn't go negative: a negative bank balance that isn't an overdraft, a negative accounts payable, a negative inventory count. These usually signal a misapplied payment, a transaction in the wrong account, or a timing error. Also glance at your aging reports: stale open invoices and overdue bills distort cash flow and the balance sheet, and they're often the symptom of a deeper data problem.
Running these five checks by hand on every client adds up fast. CleanupLedger's free cleanup preview scans a QuickBooks Online export and flags uncategorized transactions, Opening Balance Equity, likely duplicates, and missing payees in one pass, so you can spend your time fixing issues instead of hunting for them. No card required.
Phase 4: Adjusting entries and accruals
With the data clean, post the entries that make the period reflect reality rather than just cash movement.
- Accruals and deferrals. Record expenses incurred but not yet paid, and defer revenue or prepaid expenses that belong to a future period.
- Depreciation and amortization. Post the monthly portion if your client tracks fixed assets.
- Payroll and tax accruals. Reconcile payroll liabilities and accrue any taxes owed for the period.
- Loan interest. Split loan payments into principal and interest if your bank rule lumped them together.
Keep a short standing list of recurring entries per client so you never forget the depreciation entry or the monthly prepaid insurance amortization.
Phase 5: Review the reports before you report
Now pull the statements and read them like a skeptic. Note that as of May 22, 2026, QuickBooks Online runs all standard reports on its modern reporting engine, the classic view has been retired, so your filters and custom report layouts now live there.
- Profit & Loss. Compare to the prior month and the same month last year. Any line that swings hard deserves a reason you can explain in plain English.
- Balance Sheet. Confirm cash matches your reconciled balances, Opening Balance Equity is zero, and nothing is parked in a suspense or uncategorized account.
- A/R and A/P aging. Verify open balances look right and follow up on anything stale.
- General Ledger spot-check. Sample a few large or unusual transactions to confirm they landed where you expect.
If a number surprises you, it will surprise your client. Resolve it now, before it shows up in a report you've already sent.
Phase 6: Build and send the client report
The close isn't finished when the books are clean, it's finished when the client understands their numbers. A bare P&L PDF rarely does that. The clients who renew are the ones who get a clear monthly snapshot: what came in, what went out, where the money went, and a few sentences of plain-English commentary on what changed.
This is where a lot of bookkeepers leave value on the table. If you're sending raw QuickBooks exports, consider packaging the close into a branded monthly report instead. We walk through how to do that well in monthly reports for bookkeeping clients.
- Generate the report (income, expenses, category breakdown, month-over-month commentary).
- Write 3 to 5 sentences of context. Translate the numbers into what the client should notice or do.
- Send it on a schedule the client can count on, the same window every month builds trust.
Phase 7: Lock the books
Once everything is reconciled, clean, reviewed, and sent, close the period. QuickBooks Online lets you set a closing date with a password so transactions in the closed period can't be changed without warning. This protects your reconciled work from accidental edits and keeps your reports consistent if anyone goes back into the file.
The copy-usable checklist
Here's the whole thing in one block you can paste into your workflow:
- Clear the bank feed (categorize/match through statement date)
- Review bank rules and spot-check matches
- Enter cash, journal entries, and off-feed transactions
- Reconcile bank accounts to zero
- Reconcile credit cards, loans, and lines of credit
- Investigate uncleared items (don't force the balance)
- Check: uncategorized transactions
- Check: Opening Balance Equity is zero
- Check: duplicate transactions
- Check: missing payees and accounts
- Check: negative balances and aging oddities
- Post accruals, deferrals, depreciation, payroll, interest
- Review P&L, Balance Sheet, and aging reports
- Spot-check the general ledger
- Build and send the branded client report with commentary
- Lock the period with a closing date password
Run it the same way every month and the close stops being a scramble. The reconciliation and reporting steps will always need your judgment, but the data-quality checks in Phase 3 are the most repetitive part, and the part most worth automating. Catch the issues early, fix them while the context is fresh, and send your clients a report they actually read.
FAQ
What is the right order for a QuickBooks Online month-end close?
Get all transactions into the books first (clear the bank feed and enter off-feed items), then reconcile every account, run your data-quality checks, post adjusting entries, review the reports, send the client report, and finally lock the period. Each step depends on the one before it, reconciling before the feed is clear, or reporting before the data is checked, just creates rework.
What are the most common QuickBooks data-quality issues to check at month-end?
Five recurring ones: uncategorized transactions (including the Ask My Accountant account), a non-zero Opening Balance Equity balance, duplicate transactions from feed-and-manual double entry, transactions missing a payee or category, and unexpected negative balances. These can distort a client's financials even when every account reconciles cleanly.
Why should Opening Balance Equity be zero?
Opening Balance Equity is a temporary holding account QuickBooks uses when opening balances are entered during setup or when an account is connected. In a clean file it should net to zero, the balance is supposed to be moved to retained earnings or the correct equity/asset account. A lingering balance means an opening balance was entered but never properly cleared.
Can a books-health check replace reconciliation?
No. Reconciliation confirms the cash is right by tying accounts to bank statements, and that always needs your judgment. A books-health check is a complement: it scans for data-quality problems (uncategorized amounts, Opening Balance Equity, likely duplicates, missing payees) that reconciliation alone won't surface. Run both, reconcile first, then check the data quality.
What changed with QuickBooks Online reports in 2026?
As of May 22, 2026, QuickBooks Online retired the classic reports view and now runs all standard reports on its modern reporting engine. Filters, favorites, schedules, and customizations carry over automatically, but your month-end report review now happens entirely in the modern view, so it's worth confirming your saved report layouts came across correctly.