Catch-Up Bookkeeping: How to Do a Year of Books in an Afternoon

Catch-up bookkeeping, meaning recreating months or years of unrecorded books, used to be the job everyone dreaded and deferred. With an AI agent on a real ledger, it's now an afternoon: you gather statements, the agent imports and categorizes month by month, you review what it flags, and you lock each month as it reconciles. This guide is the exact workflow, including the prompts, the order of operations, and the traps that make catch-up jobs go wrong.

Why catch-up is the perfect AI job

Backlogged books are 95% mechanical: every transaction already happened, the bank recorded it, and the work is transcription plus categorization at volume. That's exactly the shape of work AI does tirelessly and humans do resentfully at hour three. The 5% that needs judgment (the odd transaction, the personal charge on the business card) is precisely what a good agent flags for you instead of guessing.

One warning before the workflow: do this on a ledger with guardrails (balance enforced, immutable history, idempotent imports, audit log). A year of AI output in a spreadsheet just produces a bigger mess to audit. Here's why the guardrails matter.

Step 0: Gather the raw material (the only slow part)

• Bank and card statements for every business account, every month you're behind. CSV exports are ideal; PDFs work. Most banks let you download 12–24 months in a few clicks.
• Loan statements, if any, so principal vs interest splits correctly.
• A list of your accounts (checking, savings, cards) and roughly what each is for.
• Last filed tax return or prior books, if they exist, for opening balances.

Fifteen minutes of downloading beats every later step. Missing months are the #1 cause of books that won't reconcile.

Step 1: Set up the books and the chart

Create a free book and let the agent seed a standard chart of accounts, then tune it in one sentence:“Set up books for my consulting LLC. I invoice clients, pay two contractors, and run everything through one checking account and one card.” Resist the urge to over-customize: a lean chart of accounts makes categorization dramatically more consistent, for AIs and humans alike. If you have prior books, have the agent post opening balances as of your start date.

Step 2: Import month by month, oldest first

Feed statements in chronological order, one month (or one quarter) at a time:

"Here is January's checking statement. Import it,
categorize everything against my chart, match any
transfers, and flag anything you're not sure about.
Don't guess on ambiguous ones."

Why not all at once? Three reasons: review stays digestible, transfer matching works best when both sides of a move are present before you advance, and each month can be reconciled and locked before the next builds on it. Batch imports dedupe on the file's rows, and on a proper ledger each row posts independently, so one weird transaction never blocks the other 200. If an import goes sideways, retract the batch and redo it; that's what batch IDs are for.

Step 3: Review the flags (your actual job)

A well-prompted agent hands you back a short list: “these 6 of 214 need your eye.” Typical flags and fast answers:

• “Is this personal?” Personal spend on the business account posts as Owner's Draw, and the books still tie to the bank. Business spend on a personal card posts as Owner's Contribution.
• “Same amount, same day, two sources.” Possible duplicate. Confirm or dismiss, but never let anything auto-merge; legitimate double purchases exist.
• “Big round number to an unknown payee.” Often a loan payment, a tax payment, or a transfer to an account you forgot to mention. Tell the agent what it is once; it remembers the merchant.

Step 4: Reconcile and lock each month

Before moving on: “Reconcile checking against the January statement; ending balance $8,214.55.” If it ties, lock the month so nothing can post into it later, and advance. If it doesn't tie, the cause is almost always a missing statement page or an unmatched transfer, and the agent can show you the exact difference to hunt. The tie-out is what turns “transactions in software” into books. The full monthly routine lives in our month-end close checklist.

Step 5: The year-end sweep

Once all months tie: “Tag every vendor we paid this year and run the 1099 report” (details in the 1099 prep guide), “register any equipment purchases as fixed assets and book depreciation,” and “run the P&L and balance sheet for the year.” Hand your CPA the reports plus CSV exports; a catch-up done this way (reconciled monthly, immutable history, full audit trail) is more defensible than most books kept live by hand.

How long does it really take?

The bottleneck is genuinely the statement downloads, not the bookkeeping.

Start the afternoon

Books are free, and both major assistants connect in about a minute: Claude setup · ChatGPT setup. If you're choosing between them for a big backlog job, our comparison has a verdict. Pick your messiest month, hand it over, and see what comes back.