Verifying a Repaired QuickBooks File by Restoring It Into a Trial Copy
A repaired QuickBooks file should not go straight back into use. Here is how our engineers confirm every list and transaction survived the repair.
A file repair usually comes back as a portable company file, sometimes as a backup. Either way, the returned copy has not earned trust yet. Our engineers treat every repaired file as unproven until it opens cleanly, verifies, and survives a number-by-number comparison against a baseline. Here is the sequence we use.
Before you restore anything
Gather the pieces first. You need the repaired file, its admin password, and a QuickBooks install or trial of the same edition and year, or a newer one. Enterprise files open only in Enterprise, so match the edition. A restored company file can run several times larger than the portable, so check free disk space first.
Never restore over the live file. The restore creates a new company file, so point it at a fresh folder and give it a name you cannot confuse with production. If the machine hosts the live company, close it and switch to single-user mode before you start. Keep the damaged original untouched; it is your fallback and one of your comparison baselines.
Restore the repaired file into a trial copy
- Launch the trial edition and close any company that opens automatically, so no file is in use.
- Go to File, then Open or Restore Company, and choose the option to restore a portable company file. If you received a .qbb backup instead, choose the backup option.
- Select the repaired portable file and continue.
- When asked where to save it, choose the fresh folder and a distinct file name.
- Let the restore finish. A large file can take several minutes, and cancelling midway helps nobody.
- Enter the admin password when prompted. A newer-year trial may update the data file on first open; that is expected and harmless for this check.
How do you know the data came back?
Press F2 to open the Product Information window and read the counts: customers, vendors, transactions, and targets. Targets are the database's internal postings, and they are a sensitive gauge. Compare every count with the same screen on your original file. Matching counts are the first good sign; a shortfall tells you where to look.
Next, run Verify on the restored copy. Choose File, then Utilities, then Verify Data, and let it finish. A clean run reports that QuickBooks found no problems with your data. If Verify fails on a freshly repaired file, the repair did not fully take, and no amount of spot-checking will paper over that.
Then open the centers. Count the names in the Customer and Vendor Centers, open a few invoices you know well, and confirm the oldest transaction you expect is present.
Export the reports to Excel or CSV
- Run the list reports first: Customer Contact List, Vendor Contact List, and Account List.
- Run the control reports with the date filter set to All Dates. Start with Profit and Loss Standard, then a Balance Sheet Standard as of your last period end.
- Add a Trial Balance for each fiscal year end, plus the A/R and A/P aging summaries. Pick one basis, accrual or cash, and keep it consistent across both files.
- On each report, click the Excel button and pick the comma separated values (.csv) option, or Create New Worksheet if you prefer a workbook.
- Name each export after the report and its as-of date so nothing gets mixed up later.
CSV keeps every export neutral and readable by any spreadsheet program.
Compare the exports against your originals
You need a baseline from before the repair. Saved reports work best. The damaged original may still open far enough to print the same reports, which is worth trying. Bank statements, filed returns, and prior-year financials serve as outside evidence when neither file can speak.
Compare row counts first, then totals. Row counts catch missing customers, vendors, and accounts. Totals catch missing or altered transactions; net income by year, trial balance debits and credits, and aging totals do most of the work. A lookup formula in any spreadsheet will flag names present in one list and absent from the other.
What if something does not match?
Treat a mismatch as a finding, not a nuisance. A missing handful of list entries is one kind of problem. A fiscal year that will not tie is another, and it means the damage reached transactions. Verification cannot repair what the source never contained. That deeper class of loss needs a fuller recovery effort, such as our QuickBooks Desktop file repair and data recovery service, rather than another pass of checks.
The limits of this check
Verification proves the copy you were handed is sound and matches your baselines. It cannot conjure records the source never contained. If the repair was built from an older backup, everything after that backup date is simply absent, and no comparison will find it.
Portable files also exclude attached documents, templates, logos, and letters. If you depend on those, check them separately. A clean Verify today is not a promise about next quarter, so re-run Verify after the first month of real use. Once everything ties, deploy the repaired file to the licensed install and put the trial copy aside.