Being months behind in QuickBooks tends to come to a head at tax time. One owner, categorizing transactions for taxes and finding four months missing, asked what everyone in that spot is wondering:
Do I have to cross-check every single transaction?
info2376, a QuickBooks Self-Employed user, on the QuickBooks Community
Yes, once, against your bank statements. That's what reconciling is. A QuickBooks cleanup is mostly doing that check in the right order, so you only have to do it once. This guide walks a QuickBooks Online owner through that order, step by step, with each step checked against Intuit's own help articles as they read in October 2026. Intuit has renamed some screens, so where it matters this guide gives both names.
What is a QuickBooks cleanup?
A QuickBooks cleanup brings your books up to date and corrects them so they match what really happened: every bank and card transaction recorded once, in the right account, and every account reconciled to its statements. When you're done, your profit and loss and balance sheet are numbers you, your accountant and a lender can rely on.
You probably need one if:
- The Pending list holds hundreds of transactions, or several months of them.
- Uncategorized Income, Uncategorized Expense or Uncategorized Asset show a balance on your reports.
- Your last reconciliation was months ago, or the beginning balance no longer matches your statement.
- The bank balance in QuickBooks doesn't match the bank.
- Your accountant sent back a list of questions, or tax season is close.
- You're about to apply for a loan or sell the business.
The QuickBooks cleanup, step by step
1. Gather every statement and pick your start date
Download statements for every bank account, credit card, loan and payment processor (Stripe, Square, PayPal) for the whole period you're fixing. Pull receipts and invoices for anything large or unclear. Then pick a start date: the last month you know was right, such as the last statement you reconciled or the end of the last year your accountant closed.
Don't delete transactions to make numbers line up. A reconciled transaction that gets deleted or edited is one of the causes Intuit lists when a beginning balance stops matching your statement (Intuit).
2. Fill the gaps in your bank feed
How far back QuickBooks can download depends on your bank: Intuit says the window ranges from 90 days to 24 months (Intuit). If your cleanup goes back further, or an account was never connected, download the history from your bank as a file and upload it. Go to All apps, Accounting, Bank transactions, then choose Upload from file in the Link account menu. QuickBooks accepts .csv, .txt, .qbo and .ofx files, up to 1,000 lines and 350 KB per upload (Intuit).
Two cautions. Don't upload a date range the feed already downloaded, because an import that overlaps your bank feed is one of the causes of duplicates Intuit lists. And don't disconnect and reconnect a bank to refresh it. Intuit warns that reconnecting makes QuickBooks download past transactions again, which creates more duplicates (Intuit).
3. Work through the Pending (For review) list
Everything QuickBooks downloads waits here first. In Intuit's current layout the tab is called Pending; older screens, and many of Intuit's own articles, call it For review. Either way, Intuit says those transactions don't affect your books until you match or categorize them (Intuit). A thousand pending transactions means a thousand transactions missing from your reports.
Each one gets one of three choices:
| Choice | Use it when | What it does |
|---|---|---|
| Match | You already recorded it: an invoice payment, a bill you entered, a transfer | Links the bank line to the existing record, with nothing new created |
| Categorize (add) | Nothing in QuickBooks covers it yet | Creates a new record in the account you pick |
| Exclude | It's a duplicate, or it doesn't belong in these books | Keeps it out of your books |
Match first. QuickBooks suggests matches with the same amount from 90 days before to 20 days after the bank date. Outside that window it won't suggest one, so on an old backlog, look for the existing invoice or bill yourself before you add anything. Adding a downloaded transaction instead of matching it is one of the causes of duplicates Intuit names.
Personal charges stay in. If personal spending went through the business account, don't exclude it. It's on the statement, so the account won't reconcile without it. Record it as money the owner took out, not as a business expense. Which account that goes to depends on how your business is set up, so ask your accountant, and see Intuit's article on recording personal expenses and owner draws.
Build rules as you go. Once you've categorized the same payee a few times, make a bank rule for it (the bank rules section below covers how). Intuit says QuickBooks applies your rules automatically to transactions waiting for review, so each rule shrinks the rest of the backlog.
Anything you genuinely can't place, leave for step 5. Don't guess.
4. Clear Uncategorized Income, Expense and Asset
When something goes into the books without a real category, QuickBooks parks it in a holding account. Intuit describes Uncategorized Income and Uncategorized Expense as accounts QuickBooks creates on its own to track money earned or spent that still needs a category, and Uncategorized Asset as where it records assets it can't match to an account (Intuit). You can't deactivate or merge these accounts. The goal is a zero balance in each.
Open each one from your chart of accounts and work through what's in it. Intuit gives two ways to fix a bank transaction that landed in the wrong account: change the account directly on the transaction, or select Undo on the Posted tab, which sends it back to Pending so you can categorize it again (Intuit).
Check Uncategorized Income closely. Deposits there can be customers paying invoices you already sent. Undo those and match them to the invoices instead, so each invoice shows as paid and the sale isn't on the books twice.
If you're facing hundreds of these, Intuit's Reclassify transactions tool moves many at once, but it's only in QuickBooks Online Advanced and QuickBooks Online Accountant (Intuit). Your accountant may have the second one.
5. Park the real unknowns in Ask My Accountant
Some transactions you truly can't place: a transfer from a name you don't recognize, a charge that could be equipment or a repair. Intuit's own advice is to set up an account in your chart of accounts called Ask My Accountant and record each one there with a short description and the amount. Your accountant then runs a report on that account and moves each item to the right place (QuickBooks). It's an account you add yourself, so if your accountant already added one, use theirs.
The difference from Uncategorized: QuickBooks parks things in Uncategorized automatically, with no explanation. You park things in Ask My Accountant on purpose, with a note. Make the note useful ("$2,400 from J. Smith, maybe the deposit for the Oak Street job?"). Uncategorized should be at zero before you hand the books over. Ask My Accountant should be at zero once your accountant has been through it.
6. Remove duplicates already in your books
Intuit lists the usual causes: reconnecting an account, importing a file that overlaps your bank feed, adding a downloaded transaction instead of matching it, or recording the same sale two different ways (Intuit).
For a duplicate that's already posted, select Undo so it goes back to Pending, then match it to the record you already have, or exclude it. If one of the two copies is reconciled, keep that one. And exclude rather than delete: Intuit warns that a deleted bank transaction gets downloaded again from the bank.
7. Reconcile every account, one statement at a time
This is the cross-check from the top of this guide, and it's the step that's most tempting to skip. One owner who let sales receipts pile up for nearly a year, and then needed reconciled statements to renew the company's bank loans, concluded there was no shortcut to knowing how the business did. There was "no way to do that without matching up each credit card transaction" (nlh on Hacker News).
Intuit's steps for QuickBooks Online (Intuit):
- Go to All apps, Accounting, then Reconcile, and choose the account.
- Enter the ending balance and ending date from the statement.
- Check off each transaction that appears on the statement.
- Keep going until the difference is $0.00, which means the account is balanced.
- Finish. QuickBooks saves a reconciliation report, which you'll find under History by account.
Before you start a statement, Intuit says every transaction for that period should already be added and categorized. That's why the Pending list comes first. Each statement should start the day after the last one you reconciled ended, so work oldest first, for every bank, card and loan account, until you reach the latest statement. (Intuit's article on reconciling several months at once applies to QuickBooks Desktop, not Online.)
If the beginning balance is wrong. Intuit says this happens when a transaction that was already reconciled gets edited, deleted, voided, moved or unreconciled. QuickBooks shows a Reconcile Discrepancy Report listing the changes, and it won't let you continue until the difference is accounted for. If a past reconciliation itself was wrong, your primary admin or your accountant can undo it from the History by account screen (Intuit). If it's the account's first reconciliation, the opening balance entry is the only thing that should already be reconciled (Intuit).
If the difference won't reach zero. Check the ending balance and date you typed, then look for a transaction that's missing, doubled, or entered for the wrong amount. QuickBooks can add an adjusting entry for the difference, but Intuit says to talk to your accountant before you do, and that it's usually best to resolve the difference instead. An adjustment hides the problem rather than finding it.
8. Check Opening Balance Equity and your balance sheet
Opening Balance Equity is where QuickBooks offsets the starting balances you enter when you set up an account, so the books stay balanced (Intuit). A balance there isn't an error by itself, but it is a question: starting balances went in, and the offset hasn't been moved into your regular equity accounts. Where it belongs depends on how your business is organized, so that one's for your accountant. If you never entered an opening balance for an account, Intuit says you can go back and record it with a journal entry (Intuit).
Then read your balance sheet line by line. Bank and card balances should match their statements. Intuit's own cleanup guide adds that loan balances should match your lenders' year-end statements (QuickBooks). Accounts receivable should list only invoices customers really haven't paid.
9. Hand off the questions, then lock the books
Send your accountant the Ask My Accountant report, the reconciliation reports, and a note on anything you changed in a year they've already filed. If the cleanup changes numbers on a return already filed, ask your CPA whether to amend it. Amendments run on the IRS's period of limitations, which it defines as "the period of time in which you can amend your tax return to claim a credit or refund, or the IRS can assess additional tax" (IRS).
Keep the statements and receipts you used. The IRS's general rule is three years, and longer in some situations. In Canada, the CRA generally requires records to be kept "for a period of six years from the end of the last tax year they relate to" (CRA).
Then lock the period, which stops changes to past transactions. It's under Settings, Account and settings, Advanced, where you can allow changes after a warning, or only after a warning and a password. Intuit says to set the lock date once you've reviewed and reconciled your accounts (Intuit).
QuickBooks cleanup checklist
| # | Step | Where in QuickBooks Online | Done when |
|---|---|---|---|
| 1 | Gather statements | Your bank, card, loan and processor portals | You have every statement for every account in the period |
| 2 | Fill feed gaps | Bank transactions, Link account, Upload from file | Every account has transactions for every month |
| 3 | Clear Pending | Bank transactions, Pending (For review) tab | Nothing left pending for the cleanup period |
| 4 | Fix Uncategorized | Chart of accounts | Uncategorized Income, Expense and Asset are at zero |
| 5 | Park unknowns | Your Ask My Accountant account | Each item has a note your accountant can act on |
| 6 | Remove duplicates | Posted tab, Undo, then Exclude | No transaction appears twice |
| 7 | Reconcile | Accounting, Reconcile | Every account reconciled through the latest statement at $0.00 |
| 8 | Check the balance sheet | Balance Sheet report | Bank, card and loan balances match statements; Opening Balance Equity explained |
| 9 | Hand off and lock | Settings, Account and settings, Advanced | Your accountant has the questions, and a lock date is set |
Keep it from piling up again: bank rules and a monthly reconcile
QuickBooks bank rules do the repetitive categorizing for you. Create them under All Apps, Accounting, Rules. A rule can have up to 5 conditions, QuickBooks applies only one rule per transaction (so their order matters), and you can have up to 2,000. Intuit recommends starting with simple, consistent transactions such as rent or gas (Intuit).
Be careful with the setting that adds transactions automatically. Intuit warns that with it on, you don't get to review those transactions, and they never show up in the review list at all (Intuit). A wrong rule on autopilot quietly builds your next cleanup.
Reconcile monthly. Intuit's advice is to reconcile every month, once your bank statement arrives. Even a careful business finds things that way. Describing his own company's books, Michael Pryor wrote that even with a strict process there are "a few charges that go unnoticed that reconciling finds every month" (Money Stack Exchange). A month takes far less time than a year.
How long does a QuickBooks cleanup take?
It depends on the number of months, accounts and transactions, and on how complete your statements are. No source gives a reliable average. As one benchmark, Intuit says the cleanup done by its own bookkeeping service takes about 30 days from the time its bookkeepers receive everything they need from you (Intuit).
When to hire a pro, and what drives the cost
Doing it yourself is realistic when it's a few accounts and the problem is mostly a backlog. Bring in a bookkeeper or accountant when:
- You filed tax returns from these books and the cleanup changes the numbers.
- Payroll, sales tax or inventory runs through QuickBooks.
- Old reconciliations are broken: a long Reconcile Discrepancy Report, or beginning balances that won't match.
- Opening Balance Equity carries a balance nobody can explain.
- You're borrowing or selling soon. Buyers and lenders read these books closely; see getting your books ready to sell your business.
- You've started the cleanup twice and stalled both times.
Cost. None of the ranking cleanup guides we read give a figure with a source, and Intuit doesn't publish its own. Its bookkeeping service charges a flat fee for cleanup and setup in the first month when you have at least 2 months of data in QuickBooks, and its pricing page doesn't list the amount. What moves any quote:
- How many months you're behind
- How many accounts need reconciling (each bank, card, loan and processor)
- How many transactions a month you have
- Whether statements and receipts are complete
- Whether payroll, sales tax or inventory is involved
- Whether old reconciliations need undoing, or filed returns need amending
As one commenter on Hacker News pointed out, accountants cost more when the books are messy. To get a firm quote, send a bookkeeper your list of accounts, the months involved and a rough count of transactions per month. For how to find and choose one, see how to hire a QuickBooks bookkeeper.
Even with help, some of the work stays with you. Only you know what that $2,400 transfer was.
Should you delete everything and start over?
Usually not. Intuit's option to delete your data and start over works only on QuickBooks Online Essentials, Plus and Advanced, only for a company less than 60 days old, and the deletion is permanent. For an older company, you have to cancel it and start a new one, and you keep read-only access to the old data for a year (Intuit). With months of history, a fresh company means entering that history again anyway, so cleaning up the file you have is usually less work. Talk to your accountant before you delete anything.
Where Ruth fits
The cleanup is a one-time job. Staying caught up afterward is the part that slips. Ruth is Clef's AI bookkeeper, and she runs your QuickBooks for you day to day. Once you connect QuickBooks Online, you text her or send a file, and she enters expenses and income in QuickBooks with the receipt or invoice attached. She books transactions to the right accounts and asks you about the ones she can't place. She checks QuickBooks for a matching entry before adding one, so nothing goes in twice.
She works alongside your accountant, not instead of one: she keeps QuickBooks current, so your accountant gets clean books and can spend their time on advice, review and taxes. Her limits are real. QuickBooks' API doesn't show the bank feed's Pending (For review) list to outside apps, so clearing that list stays with you. She never moves money, and she doesn't file taxes. See how Ruth works.
This is general information, not tax, legal or accounting advice. Your accountant or CPA can apply it to your business.
Intuit and QuickBooks are registered trademarks of Intuit Inc.
Frequently asked questions
What does Uncategorized Expense mean in QuickBooks?
It's a holding account QuickBooks creates automatically for money you spent that still needs a category. Uncategorized Income does the same for money coming in. You can't deactivate or merge either one, so the fix is to open each transaction in it, give it the right account, and bring the balance to zero.
How do I use Ask My Accountant in QuickBooks Online?
Add an account named Ask My Accountant to your chart of accounts, if your accountant hasn't already. Record each transaction you can't place there, with a short note saying what you do know. Your accountant runs a report on that account and moves each item to the right place.
How much does a QuickBooks cleanup cost?
There's no reliable published average. Intuit's own bookkeeping service charges a flat fee for cleanup and setup but doesn't list the amount on its pricing page. A quote depends on how many months you're behind, how many accounts need reconciling, how many transactions you have, whether statements are missing, and whether payroll, sales tax or filed tax returns are involved.
How long does a QuickBooks cleanup take?
It depends on the number of months, accounts and transactions. As one benchmark, Intuit says the cleanup done by its own bookkeeping service takes about 30 days from the time its bookkeepers receive everything they need from you.
Can I delete everything in QuickBooks Online and start over?
Only if the company is less than 60 days old and on Essentials, Plus or Advanced, and the data is deleted permanently. An older company has to be canceled and replaced with a new one, and you keep read-only access to the old data for a year. With months of history, cleaning up the file you have is usually less work.