QuickBooks Company File Health: Verify, Rebuild, Backup, Keep It Readable

If you're keeping QuickBooks Desktop for the long haul, the company file matters more than the software. A healthy .QBW file opens fast, avoids corruption, and stays recoverable. Here's the maintenance routine to run.

1. Verify Data (catch problems early)

File › Utilities › Verify Data checks your file for integrity issues. Run it monthly and before every major backup. If it reports a problem, run Rebuild.

2. Rebuild Data (fix what Verify finds)

File › Utilities › Rebuild Data repairs many common issues. It forces a backup first -- let it. Rebuild, then Verify again to confirm the file is clean.

3. Back up -- properly

• Use File › Back Up Company › Create Local Backup to make a .QBB.
• Keep multiple dated copies on separate media (not just the same drive).
• Follow a simple 3-2-1 habit: 3 copies, 2 media types, 1 off-site.
• Since online backup ends at discontinuation, schedule local backups and copy them off the machine yourself.

4. Condense (only if needed)

If the file is very large and slow, File › Utilities › Condense Data can shrink it by summarizing old transactions. Condensing is irreversible -- always keep a pre-condense backup you never overwrite, because that backup is your only full-detail history afterward.

5. Keep the data readable without QuickBooks

Software outlives no one; your records should outlive the software. Periodically:

• Export key reports (P&L, Balance Sheet, GL, transaction detail) to PDF and CSV.
• Know your file types -- .QBW (working file), .QBB (backup), .QBM (portable), .ND/.TLG (network/transaction log). Keep the .QBB copies especially.
• For power users, ODBC/QODBC access lets you query the data directly for archival.

Understand the file types

Run this routine and your books stay healthy and portable -- independent of any version's support status.