Year-End Is in 7 Weeks. Your Last Bank Rec Was in February.

Here's a fictional scenario that illustrates the problem. A bookkeeper is hired in November to prepare year-end. They open the accounting file and find the last bank reconciliation is dated February, with the year ending in 7 weeks.

In this scenario, the owner didn't know the books were 8 months behind. The previous bookkeeper had been pulling the bank feed, "categorizing" transactions, and never doing a real reconciliation.

This post is about why that happens, what it can cost, and the one habit that prevents it.

The bank-feed-is-not-reconciliation problem

Modern accounting software automatically pulls in your bank transactions. A connected bank feed can look like reconciliation to an owner. Ask for the statement tie-out before treating it as one.

It is not.

A bank reconciliation is the formal process of matching your accounting records (bank balance per books) to your actual bank statement (bank balance per bank). The differences should be explainable: outstanding deposits, uncleared checks, bank fees, transposition errors.

The bank feed only shows you what cleared. It does not catch:

• Duplicates from incorrectly matching credit card payments to charges
• Missing transactions the bank didn't push or that posted late
• Bank corrections (NSF, returns, fraud reversals)
• Items posted to the wrong account entirely

An owner question worth answering: if the bank feed is connected, why would the credit card accounts show as never reconciled, and why would checking carry uncleared items that look like duplicates of card payments? One possible cause is that a card payment was matched once as a transfer and again as an expense, and no one compared the card statement balance to the books.

Without a real monthly reconciliation, your books drift. Slowly at first. Then catastrophically.

What actually happens when you skip 8 months of recs

Here's an illustrative cascade for a fictional $2-5M services business. The timing and dollar ranges are planning assumptions, not measured figures:

Months 1-2: Mostly fine. A few duplicates. Some uncategorized items.

Months 3-4: In this example, cash balance per books is $30-80K different from the bank statement. Owner assumes this is "timing."

Months 5-6: Sales tax remittance off because revenue is wrong. P&L shows margins that don't reconcile to cash.

Months 7-8: Year-end approaches. CPA asks for trial balance. Bookkeeper realizes nothing reconciles. Owner finds out.

The cleanup: under the illustrative hours-times-rate model in the recovery plan below, roughly $5,100-$12,500 of catch-up bookkeeping fees for the fictional four-account, eight-month gap (redoing a month is sometimes faster than surgically fixing it), plus any penalties, interest or amended filings tied to returns prepared on bad numbers.

The pattern: bookkeeper "categorizing" instead of reconciling

One pattern that produces this situation:

1. Owner hires a low-cost bookkeeper, often part-time, under a scope that never defines reconciliation
2. Bookkeeper logs in monthly, "categorizes" the bank feed (clicks accept on suggested categories)
3. No reconciliation report is ever produced
4. No discrepancy investigation happens
5. The owner sees activity in QuickBooks and assumes work is being done

The bookkeeper isn't lying, they did do work. They just did part of the job. Categorizing the feed without reconciling is like washing the dishes without rinsing them.

A related owner question: why doesn't my P&L show where the money is actually going? Check the miscellaneous and uncategorized expense lines. If a large share of total expenses sits there, the P&L can't answer that question until those transactions are recoded.

The 7-week recovery plan

If you discover this in November and year-end is December 31, here's the brute-force recovery plan:

Week 1: Stop the bleeding

• Pull bank statements (PDF) for every month from the last reconciliation forward
• Pull credit card statements
• Identify all deposit account, loan, and merchant accounts
• Get into all of them. No exceptions.

Weeks 2-3: Reconcile in chronological order

Start at the first un-reconciled month and walk forward. Do not skip months hoping to "true up" at the end. The errors compound.

For each month:

1. Mark deposits/withdrawals that match bank statement
2. Investigate uncleared items older than 60 days (check for duplicates, voids, stale outstanding checks and misdated entries)
3. Investigate items in QB but not on bank (data entry errors, voids, deposits that bounced)
4. Investigate items on bank but not in QB (missed entries, fees, automatic transfers)

Week 4: Credit cards + loans + merchant accounts

Same process. Merchant accounts (Square, Stripe, Shopify) are where the worst hidden errors live, fees, refunds, chargebacks all need to be split out from gross deposits.

Weeks 5-6: Sales tax + payroll true-up

Reconcile taxable sales, exemptions, jurisdiction and remittances to sales-tax returns with the tax preparer. Reconcile payroll registers, tax deposits, payroll liabilities and filed returns separately. Bank reconciliation alone does not establish taxable sales or the accuracy of employment-tax returns. Submit corrections only through the appropriate approved filing process.

Week 7: Trial balance + close

Everything should tie. Generate a clean P&L and balance sheet. Hand to the CPA.

As an illustrative planning assumption, not a measured average, take a fictional file with 4 accounts (checking, credit card, loan, merchant) that is 8 months behind. That is 32 account-months. At about 2 to 3 hours each, the plan needs 64-96 hours of skilled bookkeeping work, plus a separate assumed 4-hour setup/review allowance, totaling 68-100 hours. At an assumed $75-125/hour, that's $5,100-$12,500 (68 x $75 = $5,100; 100 x $125 = $12,500), paid in 7 weeks of panic instead of spread across the year. Recount accounts and months for your own file. More merchant, loan or payroll accounts add hours.

The one habit that prevents this

A monthly close, not just categorization, an actual close, that produces three artifacts every month:

1. A bank reconciliation report for every cash, credit, and loan account
2. A management P&L and balance sheet delivered to the owner
3. A short close memo noting any unusual items, accruals, or follow-ups

If your bookkeeper isn't producing these three things every month, you don't have monthly bookkeeping. You have monthly data entry. Those are different services at different price points and they produce wildly different outcomes.

How to verify your books right now (5-minute test)

1. Log into your accounting software
2. Find the reconciliation reports. Intuit's current QBO instructions use Reports, Standard reports and a search for Reconciliation Report. Product and menu labels can vary.
3. Check the account, statement ending date, beginning and ending balances, and any unexplained difference. A report run today for February does not mean October is reconciled.

For a monthly close, a statement ending date more than 45 days behind is a planning review trigger; more than 90 days merits an urgent scope check. Those are operating thresholds, not tax deadlines. If no report is visible, check your permissions, product and the provider's retained workpapers before concluding no reconciliation was done.

This test takes 5 minutes and is one of the cheapest checks you can run this week.

When to call for help

If you're more than 4 months behind and you have a tax filing deadline coming, get external help. The compounding cost of waiting (penalties, interest, rushed work, errors) can exceed the cleanup fee. Confirm actual filing deadlines with your CPA first, since those dates set the schedule.

Level handles multi-month bookkeeping cleanups for service businesses, often as the first phase of an ongoing engagement. Before work starts, ask any cleanup provider for a written scope that covers four things: every account and month to be reconciled, how open items will be researched, who coordinates any tax notices with your CPA, and the target date for the first monthly close with its three artifacts.

If your books are behind, the worst thing you can do is pretend they're not. The second worst is to hand them to the same bookkeeper who let them get this way.

FAQ

How often should bank accounts be reconciled? Monthly, with a written report. Some high-volume businesses (multi-channel ecommerce, large field-service operations) benefit from weekly reconciliation, but monthly is a reasonable minimum for most operating businesses.

My bookkeeper says they "reconcile through the feed." Is that real? No. Bank feed matching is a step in reconciliation, not the whole thing. A real reconciliation requires comparing the cleared balance per books to the cleared balance per bank statement and explaining any difference. Ask for the dated reconciliation report or equivalent statement-to-ledger workpaper. An absent PDF alone does not prove the work was never done.

How much does multi-month bookkeeping cleanup cost? Use the same hours-times-rate model as the recovery plan, as a planning estimate rather than a measured market price. Count account-months (accounts x months behind), multiply by an assumed 2 to 3 hours each, then multiply by the hourly rate. In the fictional 4-account, 8-month example, that's 64-96 hours, plus 4 assumed setup/review hours, or 68-100 total hours and $5,100-$12,500 at $75-125/hour. More accounts, more months or heavier merchant and payroll issues raise the hours. Agree on the cleanup scope, pricing and completion evidence in the signed engagement before work begins, separately from the ongoing monthly scope.

Can I just wait until next year and start fresh? No. Tax filings need accurate numbers. Sales tax depends on accurate revenue. Lenders need clean financials. And every month you wait, the problem compounds, old transactions become harder to research, and human memory decays. The cheapest cleanup is the one done sooner.

Related reading:

• When to Outgrow QuickBooks
• Why QuickBooks Is Failing Small Businesses
• Building a Contractor Financial Dashboard