QuickBooks › File cleanup
QuickBooks cleanup: the file, Online or Desktop.
Published range $850–$2,500
Some problems live in the software, not in your records: payments stranded in Undeposited Funds, bank rules posting to the wrong accounts, a Desktop file failing Verify Data. We work through the file's own tools and hand back a file that behaves.
Reviewed before delivery: before the file comes back to you, each account in it is reconciled to its statement and anything unresolved is written down. The six review steps.
One fixed fee, agreed in writing once the free review is done. The work happens inside your own QuickBooks subscription.
Quick answer
Test where the fault lives. If your statements and source documents are complete but QuickBooks reports disagree with them, the problem is the file and a QuickBooks cleanup fits. If the records underneath are missing or wrong for months, a bookkeeping cleanup or catch-up is the right job, and file work waits until after it.
The file-only range assumes the records underneath are sound; if they aren't, a books cleanup is scoped instead. What the range covers.
Records wrong underneath the file? That's a whole-ledger bookkeeping cleanup. One account that won't match its statement? See account reconciliation. Racing a filing date? The same work runs deadline-first, with no rush fees.
Why two ranges: the file-only fix ($850–$2,500) assumes the records underneath are sound, so the work stays inside the software; a books cleanup ($1,800–$6,000) rebuilds the ledger itself, month by month. Not sure which yours is? Score your file with the health check: it points to repair in place, reconstruction or migration.
Online vs Desktop
The same fault, fixed with different tools in each version.
QuickBooks Online and QuickBooks Desktop fail in similar ways but give you different instruments to find and fix the damage. This is the toolkit we reach for in each.
| What we're fixing | QuickBooks Online | QuickBooks Desktop |
|---|---|---|
| Data integrity | No user-run utility; faults are found and corrected transaction by transaction. | Verify Data, then Rebuild Data, run on a backup copy and verified again. |
| Change history | The audit log shows who added, changed or deleted each transaction. | The Audit Trail report lists changes by user and date. |
| Past reconciliations | Reconciliation reports by account and period; accountant users can undo a reconciliation. | Previous reconciliation reports, Locate Discrepancies, and Undo Last Reconciliation. |
| Feed automation | Bank rules, with an optional auto-add that posts without review. | Bank feed rules that assign payees and accounts as transactions download. |
| Finished periods | A closing date with a password under the advanced settings. | Set Closing Date, with a closing-date password. |
| File size | Not a factor; the data lives on Intuit's servers. | Large files slow down. Condense Data shrinks them but removes detail, so it's a last resort after a backup. |
The instruments differ; the finish line doesn't. A file is done when every account ties to its statement and the reports agree with each other. Choosing between the two versions? See how Online and Desktop compare.
File architecture
The file's skeleton, taken apart and rebuilt part by part.
A QuickBooks file misbehaves when its structure does. We rebuild the structure in a fixed order, since later parts post into earlier ones: the chart first, then the lists pointing at it, then the automation filling it.
| Part of the file | What goes wrong inside it | How it's rebuilt |
|---|---|---|
| Chart of accounts | Near-identical accounts, unused sub-accounts, and balance-sheet items parked as expenses. | Merged, renamed or made inactive against a map you approve; account types corrected so balances land on the right report. |
| Products and services | Items pointing at the wrong income or expense account, so every invoice using them posts there too. | Items re-pointed to their proper accounts, duplicates merged, inventory quantities compared with the shelf. |
| Classes and locations | Switched on but only half used, so department or site reports carry a large unassigned column. | Kept only where someone reads the report, with a tagging rule for those kept; the rest switched off. |
| Bank rules | Broad rules and auto-add posting downloaded lines to guessed accounts with nobody looking. | Rules read one by one, then narrowed or deleted; auto-add kept only for recurring lines whose category stays fixed. |
| Undeposited Funds | Customer payments stranded because the downloaded deposit was added as new income. | Stranded payments matched to their real deposits, as the next section shows. |
| Opening balance equity | Leftovers from setup and from reconciliations forced to agree. | Traced to the entries behind them and moved where they belong; anything touching a filed year goes to your CPA first. |
The order is deliberate: re-pointing items or rewriting rules before the chart is settled just sends postings to accounts about to be merged away.
Undeposited Funds
How the holding account inflates, and how it's unwound.
It's a frequent file-level fault because the deposit step is easy to skip, and it follows the same three steps in both versions.
A payment is received
Recording a customer payment parks it in Undeposited Funds until a bank deposit is recorded against it.
The deposit should empty it
The bank deposit is meant to group those payments and move them into the bank account. When the feed's deposit is added as new income instead of matched, the payment stays behind.
Income doubles, the balance grows
Revenue is counted twice and the holding balance climbs every month. We match each stranded payment to its real deposit; writing the balance off with a journal entry would hide the double count instead.
Figure data as a table
| Account | Debit | Credit | What changes |
|---|---|---|---|
| Sales | 2,860.00 | — | Removes the second count: the feed deposit added as new income |
| Undeposited Funds | — | 2,860.00 | The stranded payment leaves the holding account |
| Checking | — | — | No change: the deposit is now matched, not added |
| Net effect | 2,860.00 | 2,860.00 | Income counted once; the holding balance shows only what is really waiting |
Feeds, repair, migration
Where the rest of the file work goes.
Desktop files get a health check first. Backup, Verify Data, read the errors, Rebuild Data, verify again. A file that still fails needs repair work before any transactions are touched, or the cleanup builds on damage.
Migration comes after cleanup. Converting Desktop to Online copies the file as it stands. Clean it, confirm balances against statements, then migrate, so the new file starts from numbers you can trust.
Rules audit
Every bank rule read, broad ones narrowed, and auto-add switched off wherever it has been posting unseen errors.
Duplicate imports removed
Re-imported feed activity and app syncs that double up with the feed are found and excluded or deleted.
Match before add
Downloaded deposits and payments matched to the invoices, bills and payments already in the file rather than added as new.
Lists trimmed
Duplicate items, customers, vendors and accounts merged or made inactive so reports are readable again.
File symptoms
Six signs the trouble is in the software file.
Each of these can happen in a file whose underlying records are perfectly sound.
“Undeposited Funds keeps growing.”
Customer payments went into the holding account but were never grouped into a bank deposit, so each one waits there while the feed deposit gets booked as fresh income.
Free books review Runaway rules“Bank rules post things to the wrong place.”
A rule written for one vendor now catches dozens of others, and auto-add means nobody looks before it posts.
Free books review Integrity errors“Verify Data reports problems in the Desktop file.”
Damaged lists or transactions make reports disagree with each other. That's a repair job before it is a bookkeeping job.
QuickBooks file repair Integration doubles“Every sale shows up twice.”
An app sync and the bank feed both record the same sales, or a reconnected feed re-imports weeks of activity that was already entered.
Free books review Bloated lists“The item and account lists are unusable.”
Hundreds of near-duplicate items, customers and accounts make every report longer and every entry more error-prone.
QuickBooks setup Migration next“You're about to move from Desktop to Online.”
Conversion copies what's in the file, errors included. Cleaning first means the new file starts right.
QuickBooks migrationFile job or records job
When a file cleanup is enough, and when it isn't.
Sound records, faulty file → this page
Statements and source documents are complete; the software is misposting, duplicating or damaged. The fix happens inside QuickBooks.
Wrong records underneath → bookkeeping cleanup
Months are miscoded, balances unexplained, equity unsupported. That needs the ledger rebuilt from its starting balances, whatever software it lives in.
Whole-ledger cleanupFigure data as a table
| Where the fault is | What it looks like | The work | Published range |
|---|---|---|---|
| In the software file | Records sound underneath | QuickBooks file cleanup | $850–$2,500 |
| In the records | Months miscoded, unexplained | Bookkeeping cleanup | $1,800–$6,000 |
| Months missing | Nothing recorded at all | Catch-up bookkeeping | $1,800–$6,000 |
Months missing rather than misposted? That calls for building the missing months. A free review tells you which job your file needs, and scopes more than one together when it has to.
The tangled QuickBooks files we open keep tracing back to automation nobody reviewed. Turn that automation back into a tool someone checks, and the file starts agreeing with the bank again.
FAQ · Updated October 2026
What owners ask about fixing a QuickBooks file.
The pricing factors are set out in what a QuickBooks cleanup costs. Software questions after the cleanup? See QuickBooks support.
Get a free books review
Let us look inside the file.
Give us access to the QuickBooks file. We check its health, name the mechanics causing trouble, and tell you whether it's a file job or a records job. The free books review closes with a written scope and one fixed fee; no price is guessed on the call. See a sample of the written findings, illustrated with an invented file.