QuickBooks File Types Explained: The Complete Guide

Why File Types Matter

QuickBooks Desktop creates and maintains a surprising number of files behind the scenes. Most users only interact with one -- their company file -- but QuickBooks quietly manages a constellation of supporting files that serve critical functions: transaction logging, backups, network discovery, print templates, and more.

Understanding what each file does -- and which ones are genuinely important -- is not academic trivia. It is practical knowledge that determines whether you can recover from a disaster, diagnose a problem, or clean up a cluttered file system without accidentally deleting something vital.

The most common file management mistakes all trace back to the same root cause: people did not know what a particular file was for, so they either deleted something they needed or kept everything in a disorganized mess that made recovery harder when trouble arrived.

Primary Company Files

.QBW -- The Company File

The .QBW file is the company file. It is the single most important file in your QuickBooks ecosystem. Everything lives inside it: your chart of accounts, customer and vendor lists, every transaction you have ever entered, memorized reports, user permissions, preferences, and company information.

When someone says "my QuickBooks file," they mean the .QBW.

Default location: C:\Users\Public\Public Documents\Intuit\QuickBooks\Company Files\ (varies by version and installation choices).

Key facts:

• This is a proprietary binary format -- you cannot open it in a text editor or spreadsheet.
• The file grows over time as you add transactions. It never shrinks on its own, even if you delete transactions.
• Pro and Premier files typically range from 50 MB to 500 MB. Enterprise files can reach several gigabytes.
• There should be exactly one .QBW file per company. If you find multiple .QBW files with similar names, you likely have copies from different points in time -- and you need to figure out which one is current.

What can go wrong: The .QBW file is susceptible to corruption from power failures, network interruptions, hardware problems, and file system errors. Because it is a single monolithic file, damage to any part of it can affect the entire file. This is why backups are non-negotiable.

.QBB -- The Backup File

The .QBB file is a compressed backup of your company file. When you run a backup from within QuickBooks (File > Back Up Company > Create Local Backup), QuickBooks compresses the .QBW file and saves it as a .QBB.

Key facts:

• A .QBB file is a complete snapshot of your company data at the moment the backup was created.
• You cannot open a .QBB file directly in QuickBooks. You must restore it first, which decompresses it back into a .QBW file.
• The .QBB is typically 60-70% smaller than the .QBW because of compression.
• The file name usually includes the date and time of the backup, e.g., MyCompany (Backup Feb 23 2026 03-45 PM).QBB.

Why it matters: The .QBB is your primary disaster recovery mechanism. If your .QBW becomes corrupted or your hard drive fails, you restore from the most recent .QBB. The gap between your last backup and the moment of failure is your data loss window -- this is why backup frequency matters so much.

Common mistake: Storing the .QBB file on the same drive as the .QBW. If the drive fails, you lose both. Always store backups on a separate physical device or location.

.QBM -- The Portable Company File

The .QBM (QuickBooks Portable) file is a highly compressed version of the company file designed for transfer. It strips out non-essential data like letter templates, logos, and images to minimize file size.

Key facts:

• Created via File > Create Copy > Portable Company File.
• Even more compressed than a .QBB -- useful for emailing or uploading when bandwidth is limited.
• Must be restored (File > Open or Restore Company > Restore a Portable File) before you can work with it.
• Does not include transaction log history, templates, or attached documents.

When to use it: The .QBM is ideal when you need to send your file to an accountant, transfer it between computers, or upload it to a service. Its small size makes it practical for transfers where a full .QBB would be too large.

Limitation: Because the .QBM strips some data during compression, it is not a substitute for a full .QBB backup. Use it for transfers, not for disaster recovery.

Transaction and Logging Files

.TLG -- The Transaction Log File

The .TLG file is the transaction log. It sits alongside your .QBW file (same folder, same base name) and records every transaction that has been entered since the last backup was created. QuickBooks writes to this file in real time as you work.

Key facts:

• The .TLG file resets (starts fresh) each time you create a backup.
• Its purpose is to provide a recovery bridge: if your .QBW becomes damaged, a data recovery specialist can use the .TLG in combination with your last .QBB to recover transactions that were entered after the backup.
• The .TLG can grow quite large if you have not backed up in a while.
• It is stored in the same directory as the .QBW file.

Why it matters enormously: Many people do not know the .TLG exists, and some actively delete it because it "seems unnecessary." This is a serious mistake. The .TLG is your bridge between your last backup and the present. Without it, any recovery from backup means losing all transactions entered since that backup was created.

Common mistake: Moving or copying only the .QBW file to a new location and leaving the .TLG behind. Always keep the .QBW and .TLG together.

.ND -- The Network Data File

The .ND (Network Data) file is a configuration file that QuickBooks uses for multi-user access. It contains information about the host server and the path to the company file, allowing workstations to locate and connect to the file across the network.

Key facts:

• Created and maintained by the QuickBooks Database Server Manager (QBDBSM).
• One .ND file exists per company file, in the same directory as the .QBW.
• The file name matches the company file: MyCompany.qbw.nd.
• It is safe to delete the .ND file -- Database Server Manager will recreate it. This is actually a common troubleshooting step for multi-user connectivity issues (H-series errors).

.DSN -- The Data Source Name File

Some QuickBooks configurations create .DSN files for ODBC (Open Database Connectivity) connections. These are used when external applications need to query QuickBooks data.

Key facts:

• Only present if ODBC access has been configured.
• Not required for normal QuickBooks operation.
• Safe to ignore unless you use third-party reporting tools that connect to QuickBooks via ODBC.

Configuration and Support Files

.QBW.adr -- The Auto Data Recovery File

Starting with QuickBooks 2012, Intuit introduced Auto Data Recovery (ADR). QuickBooks maintains a hidden copy of your company file in a folder called QuickBooksAutoDataRecovery located in the same directory as your .QBW.

Key facts:

• The ADR folder contains a copy of your .QBW and .TLG files, updated periodically (typically every 12 hours).
• This is a last-resort recovery mechanism. If your main .QBW and your backups are all unusable, the ADR copy might save you.
• ADR is not available in QuickBooks Pro -- only Premier and Enterprise.
• The ADR copy is not a substitute for real backups. It is a safety net, not a strategy.

Common mistake: Relying on ADR instead of creating proper backups. ADR updates are not continuous -- there can be up to 12 hours of data loss. And if the corruption has been present for a while before being noticed, the ADR copy may already contain the same corruption.

.QBW.tlg.adr -- The ADR Transaction Log

This is the Auto Data Recovery version of the transaction log file. It exists alongside the ADR copy of the .QBW inside the QuickBooksAutoDataRecovery folder.

.LGB -- The Audit Log

The .LGB file contains the QuickBooks Closing Date audit log. It tracks changes made to transactions in closed periods (transactions dated before the closing date).

Key facts:

• Located in the same folder as the .QBW.
• Useful for auditing purposes -- it records who changed what and when.
• Not required for QuickBooks to function. If deleted, QuickBooks will create a new one, but you lose the historical audit trail.

Template and Form Files

.DES -- Custom Form Templates

QuickBooks stores customized invoice, estimate, and other form templates in .DES files. These contain your layout customizations, logos, and formatting.

Key facts:

• Custom templates can be exported and imported between company files.
• If you have spent significant time customizing forms, these files are worth backing up independently.
• Stored within the QuickBooks program data folders, not alongside the .QBW.

.QBO -- Web Connect Import File

The .QBO file is a bank transaction import file. When you download transactions from your bank's website in "Web Connect" format, the file has a .QBO extension.

Key facts:

• This is an import file, not a QuickBooks data file. It contains bank transactions in OFX (Open Financial Exchange) format.
• Double-clicking a .QBO file opens QuickBooks and starts the import process.
• These files are temporary -- once the transactions are imported, the .QBO file is no longer needed.

.IIF -- Intuit Interchange Format

The .IIF file is a tab-delimited text file used for importing and exporting lists and transactions. It is QuickBooks' oldest import/export format.

Key facts:

• IIF files can be opened and edited in Excel or any text editor.
• Used for bulk imports of chart of accounts, customer lists, vendor lists, and transactions.
• The format is rigid and unforgiving -- a single formatting error can cause the entire import to fail or, worse, import incorrect data silently.
• IIF imports do not have an undo function. Always back up before importing.

.SND -- Send Forms File

These files are created when QuickBooks queues forms (invoices, estimates, statements) to be sent via email. They are temporary and can be safely deleted if they accumulate.

Files Created During Installation and Updates

.QBCfg -- Configuration Files

QuickBooks configuration files store application settings, registration data, and preferences. They live in the Windows ProgramData folders.

EntitlementDataStore.ecml

This file stores your QuickBooks license and registration data. It is the file behind Error 3371 -- if it becomes corrupted, QuickBooks cannot validate your license. Located in C:\ProgramData\Intuit\Entitlement Client\.

Where Files Live: Default Locations

QuickBooks scatters its files across several Windows directories. Here are the key locations:

Company Files

• Default: C:\Users\Public\Public Documents\Intuit\QuickBooks\Company Files\
• Many users change this to a custom location. Check your QuickBooks preferences (File > Open Previous Company) to see where your file actually lives.

Program Files

• 32-bit: C:\Program Files (x86)\Intuit\QuickBooks [Year]\
• 64-bit (Enterprise 2022+): C:\Program Files\Intuit\QuickBooks Enterprise Solutions [Year]\

Application Data

• C:\ProgramData\Intuit\QuickBooks Enterprise Solutions [Year]\ (shared settings)
• C:\Users\[Username]\AppData\Local\Intuit\QuickBooks [Year]\ (user-specific settings)

Auto Data Recovery

• Same directory as your .QBW file, inside a subfolder named QuickBooksAutoDataRecovery

Which Files Are Critical for Disaster Recovery?

If you could only save a handful of files, here is the priority order:

1. The most recent .QBB backup -- This is your primary recovery source.
2. The current .TLG file -- This bridges the gap between your last backup and the present.
3. The current .QBW file (even if corrupted) -- A data recovery specialist may be able to repair it directly.
4. The ADR folder contents (if available) -- A secondary recovery source.

Everything else -- .ND files, .DES templates, .IIF imports, configuration files -- can be recreated or reconfigured. The data itself is what matters.

Common File Management Mistakes

Storing the Company File on the Desktop

The Windows Desktop is not a reliable location for a critical data file. It is tied to a specific user profile, it is easy to accidentally delete or move, and some backup software skips Desktop files by default. Store your .QBW in a dedicated folder with a short, simple path.

Running the Company File Over Wi-Fi

QuickBooks was designed for wired network access. Running a .QBW file over Wi-Fi introduces latency and packet loss that can corrupt the file during write operations. Every multi-user QuickBooks installation should use wired Ethernet connections.

Keeping Dozens of Old .QBB Files in the Same Folder

While having multiple backups is good, keeping them all in the same folder as your .QBW creates confusion. Move old backups to a dedicated backup folder (on a separate drive), keeping only the most recent two or three alongside the .QBW.

Copying the .QBW While QuickBooks Is Open

Never copy a .QBW file while QuickBooks is running. The file is in an active state with open transactions and write operations in progress. A copy made during this state is likely to be corrupted. Always close QuickBooks on all workstations before copying the file.

Renaming Files With Special Characters

Keep your QuickBooks file names simple: letters, numbers, and hyphens. Avoid spaces (though QuickBooks handles them), and absolutely avoid special characters like &, @, #, or parentheses. These can cause Error 80070057 and other access issues, particularly on network paths.

A Practical File Management Checklist

A clean QuickBooks file environment looks like this:

• The .QBW file lives in a dedicated folder with a short path (e.g., C:\QBData\ or D:\QuickBooks\).
• The .TLG file sits right next to the .QBW (it will be there automatically -- just do not move it).
• Backups (.QBB files) are stored on a separate physical drive or in cloud storage, with a clear naming convention that includes dates.
• Old portable files (.QBM) are cleaned up after the transfer is complete.
• Bank import files (.QBO) are deleted after successful import.
• The folder permissions grant full read/write access to all QuickBooks users.
• No other applications store files in the QuickBooks data folder.

QuickBooks file management is not glamorous, but it is the foundation everything else rests on. A well-organized file structure with proper backups turns a potential disaster into a minor inconvenience. A messy one turns a minor hiccup into a catastrophe.