Independent bookkeeping & advisory firm · Serving clients nationwide, remotely
TechBrot

QuickBooks

Clean up the QuickBooks file, or start a new one? How to decide.

Starting a fresh QuickBooks file sounds like the clean way out of a messy one. Sometimes it is. But a new file still has to begin from balances that are right, and it leaves the history behind — which is exactly what lenders, CPAs and auditors tend to ask for.

Somewhere around the third reconciliation that won't tie, most owners have the same thought: wouldn't it be easier to start a new QuickBooks file and leave this mess behind?

Sometimes it would. More often the idea skips one awkward fact. Here is how to decide, and what each choice actually involves.

What "starting over" really means

A new file starts on a date you choose. Everything before that date is represented by opening balances: what was in each bank account, what was owed on each card and loan, what customers owed you and what you owed vendors, all as of the start date. The old file is kept, read-only, as the record of everything before.

That is the awkward fact: the opening balances have to be right. They have to agree with reconciled figures on the start date. If the old books are wrong, someone has to work out the right balances anyway, and that is a large part of the work a cleanup would have done.

When starting over is the right call

  • The file is damaged beyond repair. If QuickBooks Desktop's Verify and Rebuild can't produce a file that verifies clean, a new file from verified balances can be the honest answer.
  • The history isn't needed. No lender, buyer or auditor will ask for it, the past years are filed, and your CPA agrees.
  • The structure is wrong from the root. A chart of accounts built for a different business, a different entity, or a file that mixes two companies can be cheaper to rebuild than to untangle.
  • You are changing systems anyway and decide, on purpose and with your CPA, not to carry the history across.

When a cleanup is the right call

  • The history matters. Lenders ask for prior years; buyers ask for more; your CPA needs comparatives. A new file can't produce what it never held.
  • The problems start at a known point. If the reconciliations broke at a specific month, a cleanup rebuilds from the last one that tied, and everything before it stays as it was.
  • Payroll and sales tax history live in the file. Rebuilding them elsewhere is work; leaving them behind is risk.
  • The file itself is sound. Most messy files aren't broken files. They are correct software holding wrong entries, which is exactly what a cleanup fixes.

Questions that decide it

  1. Will anyone (lender, buyer, CPA, auditor) need the history from this file?
  2. Does the file verify, or is it damaged?
  3. When did the books last reconcile, and how many accounts are wrong since?
  4. Is the chart of accounts fixable, or built for the wrong business?
  5. Can the correct balances on the start date be established without fixing the old books first?

If the answers are "yes, it verifies, recently, fixable, no", clean it up. If they are "no, damaged, years ago, wrong business, yes", a new file deserves a serious look.

What each costs

A cleanup is quoted as a fixed fee from the file's condition: what moves a cleanup fee breaks that down. A new file is a QuickBooks setup, plus the work of establishing opening balances you can trust, which on a messy file is rarely small. Compare the two on the same scope, not on the hope that starting over is free.

Get it measured before you choose

Most of the decision comes down to two facts you can't see from inside the mess: how far back the problems go, and whether the file itself is sound. A free QuickBooks file review measures both and says, in writing, which way the file points. If it is a cleanup, QuickBooks cleanup sets out what is repaired and what you receive at the end.

TechBrot does the operational bookkeeping and hands your CPA a file they can file from.

Cleanup or a fresh file, answered.

Is it cheaper to start a new QuickBooks file than to clean up the old one?
Not always. A new file still needs opening balances that agree with reconciled figures on the start date, which means someone has to get the old books right as of that date anyway. Starting over saves money mainly when the history isn’t needed and the old file can’t be trusted or repaired.
What happens to my history if I start a new file?
It stays in the old file, which you keep, read-only, for reference and for your records. The new file starts at the date you choose and holds only opening balances for anything before it.
Can a corrupted QuickBooks Desktop file always be repaired?
Often, not always. QuickBooks Desktop’s Verify and Rebuild tools fix many data problems; some files are damaged beyond what they can repair. When a file won’t verify after repair, starting a new file from verified balances can be the honest answer.
Should I start over when moving from Desktop to Online?
Not by default. A migration can carry the history across, and it should be cleaned before the move rather than after. Starting fresh in QuickBooks Online makes sense when the history isn’t worth moving; that is a decision to make on purpose, with your CPA.
Who should make the call?
You, with your CPA, after someone has measured the file. A file review shows how far back the problems go and whether the file itself is sound; that answers most of the question.

Not sure which you need?

Let someone measure the file first.

Tell us what’s wrong with the books. We’ll tell you whether cleanup, catch-up or monthly bookkeeping fits.

If we miss you, we return your call within one business day. Written fixed-fee scope within 3 business days. No hourly billing.

Articles are general information, not tax, legal, or financial advice.