QuickBooks Desktop 2023 Company File Types: What to Protect

A guide to QuickBooks Desktop 2023 file types (.QBW, .QBB, .QBM, .ND, .TLG) and how to safeguard your accounting data as the software approaches its 2026 s

QuickBooks Desktop 2023 creates several different files to manage, store, and route your accounting data. As this version approaches its service discontinuation date on May 31, 2026, understanding exactly which files you have—and which ones you need to protect—becomes critical for long-term survival. Here is a breakdown of the core file types in QuickBooks Desktop 2023 and how to handle them.

The Primary Data File (.QBW)

The .QBW file is your live company file. This is the main working file where QuickBooks stores all of your financial data, including your chart of accounts, transactions, customer information, and vendor records.

Because this file is constantly being written to whenever you or another user makes changes, it is highly susceptible to corruption if your computer crashes, loses power, or experiences a network drop during a save. You must protect this file, but you should never back it up simply by copying the active .QBW file while QuickBooks is running, as doing so can capture the data in an incomplete state and cause structural damage.

The Backup File (.QBB)

The .QBB file is a compressed backup created from within QuickBooks. This is the most important file for your long-term data protection.

Creating a .QBB compresses your financial data into a single, safe file that can be easily moved to an external drive or cloud storage provider. Because this file format is self-contained, it is the safest way to preserve your data against hard drive failures or accidental deletion. The process for creating and restoring a .QBB file is identical across QuickBooks Desktop versions. If your primary .QBW file ever becomes unreadable, a recent .QBB backup is your fastest path back to operational status.

The Portable Company File (.QBM)

A .QBM is a highly compressed version of your company file designed specifically for easy transfer, such as emailing the file to an accountant or moving it across a slow network connection.

While a portable file is excellent for sending data, it is not a substitute for a full .QBB backup. A .QBM strips out some temporary and log data to achieve its small file size. You can use it to restore your company data in an emergency, but it should be viewed as a transport mechanism rather than a primary archiving tool.

The Transaction Log (.TLG)

The .TLG file stores a record of every transaction entered into your company file since your last full backup. Its primary purpose is to help restore data if your main .QBW file is damaged or corrupted right before a backup can be completed.

You should never delete, rename, or move the .TLG file manually. If your company file ever requires advanced data recovery, the .TLG file is essential for piecing your most recent transactions back together. If you ever need to move your company file to a new computer, always move the .QBW and .TLG files together into the same folder.

The Network Data File (.ND)

The .ND file allows multiple users to access the company file simultaneously across a network. QuickBooks creates this small initialization file automatically when you set up multi-user mode.

If you ever receive a connection error (such as Error H202) when trying to open your company file on a network, the .ND file is often the culprit. The standard fix—which is the same across all recent Desktop versions—is to use the QuickBooks Database Server Manager to scan the folder containing your company file, which safely regenerates the .ND file without harming your data.

Which Files to Protect for the Long Haul?

For a QuickBooks Desktop 2023 user planning to stay on this version indefinitely, your preservation strategy should focus on two specific files:

  1. The .QBB Backup: This is your permanent record. Schedule automatic local backups through QuickBooks and manually copy your .QBB files to an external drive at least once a month.
  2. The .QBW Working File: Keep a clean, closed copy of your .QBW file stored safely on a separate drive. If you ever need to move your accounting system to a new offline computer, having the exact working file ready prevents the need for complex upgrades or migrations.

The .ND and .TLG files will naturally travel with your .QBW file and should be kept in the same directory, but they do not need to be archived independently. If your .QBW file ever suffers structural damage that a .QBB restore cannot fix, keeping the .TLG safely alongside it provides the best chance of repairing the damaged QuickBooks company file without losing your most recent work.

Keep going

Your Desktop doesn’t have to end when Intuit says so.

Start with the master survival guide, or jump straight to the fix you need.