A QuickBooks cleanup starts at the last reliable reconciliation for each bank and credit card account and works forward one statement period at a time. Gather every statement after that point, protect periods tied to filed returns, and finish each month before starting the next. A month is done when the ledger agrees with the statement and the remaining exceptions are explained, not when the bank-feed list is empty. An AI connected through DeepLedger can speed up catch-up bookkeeping by inventorying problems and preparing the work, while a person approves the changes.
This guide is for a QuickBooks Online file with usable history but missing or unreliable months. If you only need to fix uncategorized accounts, use the narrower uncategorized-transactions guide.
What is the difference between cleanup and catch-up?
| Catch-up bookkeeping | QuickBooks cleanup | |
|---|---|---|
| What it fixes | Months that were never recorded or reviewed | Work already in the file that is wrong |
| Typical tasks | Uploading old transactions, categorizing, reconciling skipped statements | Removing duplicates, fixing accounts, repairing broken reconciliations, applying payments |
| Main risk | Adding activity that already exists | Changing a period that was filed or closed |
A file can need both. Adding months of downloaded activity before diagnosing old errors can duplicate transactions or carry a bad opening balance into every later reconciliation. Intuit's bookkeeping cleanup checklist covers the wider review areas. The sequence below is the order of operations inside QuickBooks Online.
Where must the cleanup stop?
Write down the target period and the accounts in scope. Then identify anything that needs the person responsible for the books before you change it:
- A period used in a filed income, payroll, or sales-tax return.
- A QuickBooks closing date or password prompt.
- Inventory, loan, fixed-asset, equity, multicurrency, or tax balances you do not understand.
- A reconciliation that was complete but now has a different beginning balance.
Do not reopen a prior period because a current report looks odd. QuickBooks can restrict edits on or before a closing date; Intuit's closing-date guide explains the warning and password options.
If a correction changes a filed or closed period, document the issue and involve the reviewer. The right outcome may be a current-period adjustment, an amended filing, or no change. That decision cannot be read from a bank memo.
How do I do a QuickBooks cleanup, step by step?
1. Save the before state
Choose one cutoff date and one accounting basis. Save or export these reports before making changes:
- Balance Sheet as of the cutoff date.
- Profit and Loss and Trial Balance for the cleanup period.
- Accounts receivable and accounts payable aging as of the cutoff date, where your plan has them. QuickBooks aging reports are accrual as-of snapshots.
- Reconciliation history for each bank and credit card account.
Also open Settings > Audit log in QuickBooks and note the period you are about to review. Intuit's Audit log instructions explain the filters.
These reports are a baseline, not proof that the file is correct. After the cleanup, you should be able to explain every material difference from them.
2. Build a statement map
For each bank and credit card account, record:
| Account | Last reliable statement ending date | Last reconciled date | Next statement available | Beginning balance agrees? |
|---|---|---|---|---|
| Operating checking | June 30, 2026 | June 30, 2026 | July 31, 2026 | Yes |
| Business card | May 31, 2026 | May 31, 2026 | June 30, 2026 | Needs review |
Use your real accounts and dates. Accounts rarely stop on the same day.
In QuickBooks, open All apps > Accounting > Reconcile and select the account. Review the last statement ending date and the beginning balance. Intuit's reconciliation workflow uses the next statement's ending date and ending balance.
If a reconciled account starts with the wrong balance, stop there. Intuit lists causes such as edits, deletions, voids, moves, or unreconciled transactions from an earlier period. Use the Reconcile Discrepancy Report process and the Audit log to find what changed. Fix only a change that was actually wrong.
3. Gather the missing source records
Collect the complete bank and credit card statements for every gap, plus sales records, bills, payroll reports, loan statements, tax filings and receipts that affect the period. A transaction description can identify a merchant, but it rarely proves the business purpose or the right account.
If online banking does not reach far enough back, Intuit's manual upload guide covers Web Connect (.qbo), .qfx and CSV files. Before uploading, check the oldest and newest transaction already in that account and choose a date range that fills the gap without overlap. An imported row still needs to be matched, added, or excluded.
4. Work one statement period at a time
Start with the oldest open month for one account. Finish that statement before moving on.
Review downloaded and uploaded items. On Bank transactions, separate:
- A transaction already recorded that should be matched.
- A genuinely missing transaction that needs the right payee, account, tax treatment and document.
- A transfer between business accounts, which is neither expense nor income.
- A duplicate download or non-business item that may need exclusion.
Use Intuit's categorize and match guidance. Do not create a replacement expense because the existing transaction has the wrong category. For suspected double entries, follow the duplicate bills and invoices guide.
Review receivables and payables. Run aging reports as of month-end. An old balance may be unpaid, or it may be a payment recorded without being applied. Confirm the customer or vendor, document number, date, amount and payment before changing it.
Reconcile to the statement. Enter the statement ending date and balance, then match each transaction. Finish only when the difference is zero and the activity is supported. A zero difference proves the selected activity agrees with that statement balance. Category, customer, vendor, tax, class and location still need their own review.
5. Review the month as a set of financial statements
After reconciling every cash and card account for the month, rerun the reports on the same dates and basis. Review:
- New or unexplained balances on the Balance Sheet.
- Large changes or unexpected accounts on the Profit and Loss.
- Old receivables and payables that remain open.
- Uncategorized accounts and entries missing documents.
- Changes in a closed or previously reconciled period.
Do not clear an exception by moving it to Miscellaneous, opening balance equity, or a reconciliation adjustment without evidence. Keep an exception list with the transaction, amount, proposed treatment, missing support and the person who decides.
Then repeat for the next statement period. Working forward makes each ending balance the next month's tested beginning balance. Once the file is current, switch to the accounting month-end close checklist.
How can AI help with catch-up bookkeeping?
An AI app such as Claude or ChatGPT, connected through DeepLedger's QuickBooks MCP server, can read dated QuickBooks reports and transaction history, prepare reconciliations and propose corrections. It works when you ask. It cannot prove what is on a bank statement it has not seen, or why an undocumented purchase was made.
1. Write the rules down first. Catch-up work repeats the same decisions hundreds of times. Put them in the company's AI Brain, under Expense rules and Income rules:
- "Home Depot purchases for jobs go to Job Materials."
- "Transfers between Operating Checking and Savings are transfers, never income."
- "Owner's personal charges on the business card go to Owner's Draw."
Ask the AI to read the AI Brain and skills before each session. It applies the rules you wrote instead of guessing from merchant names.
2. Start read-only.
Read Pinebridge Studio's AI Brain and skills. For January 1 through August 31, 2026, confirm the company and reporting currency. Retrieve the Profit and Loss, Balance Sheet and General Ledger on the accrual basis, and aged receivables and payables at August 31. State each report's dates, basis and whether every page was retrieved. List possible duplicates, uncategorized entries, old open balances and missing-document questions. Do not create or change any QuickBooks record.
Check the company, dates, basis and page completeness, then compare the observations with statements and source documents.
3. Reconcile one statement at a time. Ask the AI to prepare the reconciliation for the oldest open statement. It matches statement lines to QuickBooks transactions; a person signs off in DeepLedger and finishes it in QuickBooks. The automated bank reconciliation guide walks through it.
4. Send questions to Tasks. Each unexplained transfer or missing receipt becomes a task in the company's Tasks for the client or reviewer, instead of a guess in the books.
5. Approve corrections one by one. DeepLedger refuses any write that does not name its company, and asks for confirmation before a void or a delete. Approve only the changes you can support.
When should you stop and get help?
Pause when you find a change that affects a filed return, an unexplained opening or beginning balance, a loan or equity account you cannot substantiate, payroll or sales-tax discrepancies, or missing records large enough to change a decision. Keep the baseline and exception list so the next reviewer can see what was found.
Do not tell a lender, tax preparer or other third party that the file is acceptable because the bank accounts reconcile. Ask what statements, schedules, basis and review they require.
Frequently asked questions
What is the difference between QuickBooks cleanup and catch-up bookkeeping?
Catch-up bookkeeping records or reviews activity for missing months. Cleanup corrects existing problems such as duplicates, wrong accounts, broken reconciliations, or open bills and invoices that were actually paid. A file can need both. Diagnose existing errors before adding more transactions.
Where should I start when QuickBooks is months behind?
Start with the last reliable reconciliation for each bank and credit card account. Gather every statement after that date, note closed or filed periods, and save baseline reports before editing. Work forward one statement period at a time instead of trying to repair the newest month first.
Can I upload old bank transactions into QuickBooks Online?
Yes. QuickBooks Online supports manual uploads for earlier periods, including Web Connect (.qbo), .qfx and CSV transaction files. Review the account and date range first because an upload can overlap transactions already downloaded or entered. Uploaded items still need to be matched, categorized, or excluded.
Why is the beginning balance wrong when I reconcile?
Common causes include an incorrect opening balance or a previously reconciled transaction that was edited, deleted, moved, voided, or unreconciled. Use QuickBooks' Reconcile Discrepancy Report and Audit log to identify the change. Do not create a balancing adjustment just to make the warning disappear.
How do I know the catch-up is finished?
Every bank and credit card account should reconcile to its statement through the target date with a zero difference. Review aged receivables and payables, explain remaining uncleared or uncategorized items, compare the final reports with the saved baseline, and retain the reconciliation reports and supporting documents.
Can an AI agent clean up QuickBooks automatically?
No. An AI connected through DeepLedger can inventory reports and transactions, group possible issues, prepare reconciliations and propose corrections when you ask. It cannot determine the purpose of undocumented spending, and a person signs off each reconciliation and approves each accounting change. Nothing in DeepLedger runs on its own.
Related guides
- Automated bank reconciliation for QuickBooks
- Find duplicate bills and invoices in QuickBooks Online
- Accounting month-end close checklist
Connect your AI app on AI Platforms & Integrations, add three expense rules to one company's AI Brain, then run the read-only inventory prompt above on one month.