QuickBooks uses different file extensions and formats to store company data, templates, backups, payroll information, accountant changes, and other financial records. Understanding these file types helps businesses manage accounting data safely, troubleshoot errors faster, and avoid accidental file corruption.
Whether you use QuickBooks Desktop, QuickBooks Online, or work with accountants and payroll services, knowing what each QuickBooks file extension does can make daily accounting tasks much easier.
This guide explains the most common QuickBooks file extensions and formats used in 2026, what they are used for, and when you may need them.
What Are QuickBooks File Extensions?
A file extension is the group of letters that appears after a file name, such as .QBW or .QBB. These extensions tell QuickBooks and Windows what type of file it is and how it should be opened.
For example:
- CompanyFile.QBW
- BackupFile.QBB
- PortableFile.QBM
Each extension serves a different purpose inside QuickBooks.
List of QuickBooks Common File Extensions
QuickBooks files are categorized based on their function inside the QuickBooks ecosystem. Some files store your accounting data, while others handle backups, network connectivity, banking imports, accountant collaboration, and recovery operations.
Understanding these common QuickBooks file extensions can help you troubleshoot errors, manage backups safely, and maintain smoother QuickBooks performance.
| File Type | Extension | When is This Extension Created? |
| QuickBooks Company File | .QBW | Created automatically when you create a new company file in QuickBooks Desktop. This is the primary working file that stores all accounting data. |
| QuickBooks Backup File | .QBB | Generated whenever you create a backup of your QuickBooks company file for recovery or migration purposes. |
| Portable QuickBooks File | .QBM | Created when you generate a portable company file for emailing, transferring, or moving QuickBooks data between systems. |
| QuickBooks Bank Statement File | .QBO | Created when you download banking transactions from your financial institution for import into QuickBooks. |
| Network Data File | .ND | Automatically created when QuickBooks Database Server Manager enables multi-user access for the company file. |
| Transaction Log File | .TLG | Created alongside the company file to track all transaction changes since the last successful backup. |
| Accountant Transfer File | .QBX | Generated when a business creates an Accountant’s Copy to share with an accountant or CPA for review. |
| Accountant Working File | .QBA | Created when the accountant opens and works on the QBX file inside QuickBooks Accountant Edition. |
| Accountant Changes File | .QBY | Generated after the accountant completes adjustments and sends changes back to the client for import. |
| Intuit Interchange Format File | .IIF | Created during import or export of lists, transactions, and accounting data between QuickBooks and third-party applications. |
| Form Template File | .DES | Created when users customize invoice templates, sales receipts, and other QuickBooks forms. |
| Log File | .LOG | Automatically generated during QuickBooks verification and rebuild operations for diagnostic purposes. |
| License Data File | .LGB | Created during QuickBooks registration and activation to store license information. |
| Encryption Certificate File | .ECML | Generated by QuickBooks encrypted communications manager for secure licensing and connectivity functions. |
| Configuration Data File | .DAT | Created to store various QuickBooks configuration and support settings. |
QuickBooks Files for Windows
QBW File
Type of File: QuickBooks Company File
The .QBW file is the primary company file in QuickBooks Desktop. Every company created in QuickBooks automatically receives this extension.
Example – Easy123.QBW
What a QBW File Stores
A QBW file contains almost all core business and accounting information, including:
- Financial transactions
- Customer invoices and payments
- Vendor bills
- Payroll data
- Banking and reconciliation records
- Inventory details
- Sales tax information
- Reports and financial statements
- User permissions and preferences
Why the QBW File Is Important
This is the most critical QuickBooks file because it acts as the central accounting database for the business. If this file becomes damaged or inaccessible, users may lose access to financial records.
Common QBW File Errors
- Error 6000 series
- Company file corruption
- Multi-user access issues
- Permission denied errors
- Network hosting problems
- “QuickBooks cannot open the company file” message
Best Practices
- Store QBW files on a secure local drive or dedicated server
- Avoid saving company files on unstable cloud-sync folders
- Perform regular backups
- Use Verify and Rebuild Data utilities periodically
QBB File
Type of File: QuickBooks Backup File
The .QBB file is created whenever users back up a company file their QuickBooks company data.
Purpose of QBB Files
Backup files help restore accounting data if:
- The QBW file becomes corrupted
- Hardware failure occurs
- Data is accidentally deleted
- Malware damages files
- QuickBooks migration fails
Important Information
Unlike QBW files, QBB files are compressed backup copies and cannot be edited directly until restored.
Recommended Backup Strategy
Keep backups in multiple locations:
- Local drive
- External hard drive
- Secure cloud storage
- Offsite backup location
Pro Tip
Businesses should maintain:
- Daily backups
- Weekly archive backups
- Monthly long-term backups
This significantly reduces the risk of permanent financial data loss.
QBM File
Type of File: QuickBooks Portable File
The .QBM extension is used for portable company files.
Portable files are compressed versions of company data mainly used for transferring QuickBooks data between systems.
What QBM Files Exclude
To reduce file size, portable files usually exclude:
- Logos
- Templates
- Attachments
- Some customized forms
Best Use Cases
- Sending files to accountants
- Moving QuickBooks to another computer
- Uploading files to hosted environments
- Reducing file size for email transfer
Important Note
A QBM file is not a replacement for a full backup because it does not contain all supporting files and preferences.
Common Issue
Portable files may sometimes fail to restore if:
- The file transfer is incomplete
- Different QuickBooks versions are used
- The portable file becomes corrupted during download
QBO File
Type of File: QuickBooks Bank Statement File
The .QBO file is used to import online banking transactions directly into QuickBooks.
Common Uses
- Importing bank transactions
- Downloading credit card statements
- Connecting online banking feeds
- Simplifying bank reconciliation
Benefits of QBO Files
- Reduces manual data entry
- Minimizes bookkeeping mistakes
- Speeds up reconciliation
- Improves transaction accuracy
Important Note
Not all banks support direct QBO downloads. Some banks may provide:
- CSV files
- OFX files
- Web Connect files
Which may require conversion before importing.
QuickBooks Files for Accountants
QuickBooks includes specialized file formats designed for accountant collaboration and year-end adjustments.
| File Extension | Purpose |
| .QBX | Accountant transfer file |
| .QBA | Accountant working copy |
| .QBY | Accountant changes file |
| .QBJ | General journal entries file |
QBX File
Type of File: Accountant’s Transfer Copy File
The .QBX file is created when a business sends an Accountant’s Copy to an accountant or CPA.
Purpose
This file allows accountants to review and adjust company data without directly editing the live company file.
Common Uses
- Tax preparation
- Year-end adjustments
- Financial statement reviews
- Audit support
Key Advantage
Business operations can continue while the accountant works separately on the Accountant’s Copy.
QBA File
Type of File: Accountant’s Working Copy File
The .QBA file is generated after the accountant opens the QBX transfer file.
This becomes the accountant’s editable working version of the company data.
What Accountants Typically Do
- Create adjusting journal entries
- Correct bookkeeping errors
- Reconcile accounts
- Prepare tax adjustments
QBY File
Type of File: Accountant’s Changes File
After completing adjustments, the accountant creates a .QBY file containing approved changes.
The business imports this file back into the original company file.
Common Issues
- Version mismatch errors
- Import failures
- Locked transaction conflicts
- Duplicate transaction warnings
Important Recommendation
Always create a backup before importing a QBY file.
QBJ File
Type of File: General Journal Entries File
The .QBJ file stores journal entries prepared by accountants.
Common Uses
- Adjusting entries
- Tax corrections
- Financial statement modifications
- Year-end accounting entries
Why It Matters
QBJ files help accountants transfer journal entries efficiently without manually re-entering data.
Utility & Support Files
These files support QuickBooks networking, imports, recovery, troubleshooting, licensing, and system configuration.
IIF File
Type of File: Intuit Interchange Format File
The .IIF file is used for importing and exporting accounting data between QuickBooks and external systems.
Common Uses
- Customer imports
- Vendor imports
- Chart of accounts transfers
- Transaction imports
- Third-party software integrations
Risks of Incorrect IIF Imports
Improper imports may:
- Corrupt accounting records
- Create duplicate transactions
- Damage lists or balances
Best Practice
Always test imports using a sample company file before importing into a live production file.
ND File
Type of File: Network Data File
The .ND file is automatically created when QuickBooks multi-user mode is enabled.
Purpose
It helps workstations locate and connect to the company file stored on the server.
Common Errors
- H202
- H505
- Server connectivity issues
- Multi-user hosting problems
Quick Fix
Deleting or renaming the ND file often forces QuickBooks to recreate a fresh copy automatically.
Important Note
The ND file does not contain accounting data. It only stores network configuration information.
TLG File
Type of File: Transaction Log File
The .TLG file records transaction changes made since the last successful backup.
Why TLG Files Are Important
TLG files help:
- Recover recent transactions
- Restore damaged company files
- Support QuickBooks Auto Data Recovery
Why TLG Files Become Large
If backups are not performed regularly, the TLG file continues growing because QuickBooks keeps recording transaction activity.
Recommended Maintenance
Regularly run:
- Manual backups
- Verify Data
- Rebuild Data
This helps reset and reduce TLG file size.
DSN File
Type of File: Data Source Name File
The .DSN file helps QuickBooks connect to databases and external data sources.
Stored Information
- User ID
- Password references
- Server location
- Database path
- Connection settings
Security Consideration
Because DSN files may contain connection-related details, businesses should restrict unauthorized access to them.
LOG File
Type of File: Event Log File
LOG files record QuickBooks system activities and troubleshooting information.
Common LOG Files
QWC.LOG
Tracks:
- Web Connector activity
- Connection issues
- Integration errors
QBWIN.LOG
Tracks:
- Verify and Rebuild errors
- Data integrity issues
- Corruption details
Are LOG Files Safe to Delete?
Generally yes. LOG files are diagnostic files and are recreated automatically when needed.
However, they may be useful for technical troubleshooting before deletion.
ECML File
Type of File: Entitlement File
The .ECML file is generated during QuickBooks installation and activation.
Purpose
It verifies that QuickBooks is properly licensed and activated.
Important Note
Deleting or damaging the ECML file may:
- Trigger activation errors
- Require product re-registration
- Prevent QuickBooks from opening properly
QBP File
Type of File: QuickBooks Print File
The .QBP file stores printer settings and form printing preferences.
Common Problems
Corrupted QBP files may cause:
- Printing failures
- Misaligned invoices
- Missing forms
- Blank printouts
Quick Fix
Renaming the QBP file often allows QuickBooks to generate a fresh print configuration automatically.
QuickBooks Files for Mac
QuickBooks for Mac uses separate file formats compared to Windows versions.
| File Extension | Purpose |
| .QB2016 | QuickBooks Mac 2016 company file |
| .QB2019 | QuickBooks Mac 2019 company file |
| .MAC.QBB | Mac backup file |
| .DMG | Apple disk image backup |
| .PLIST | Apple property list file |
QB2016 & QB2019 Files
These file extensions are specific to QuickBooks Desktop for Mac versions.
Purpose
They store:
- Company accounting data
- User settings
- Financial transactions
- Reports and lists
Important Note
Mac company files may require conversion before opening in QuickBooks Desktop for Windows.
MAC.QBB File
Type of File: Mac Backup File
The .MAC.QBB format is used when transferring QuickBooks Mac backup files to QuickBooks Desktop for Windows.
Why It Matters
This file helps businesses migrate between Mac and Windows environments while preserving accounting data.
DMG File
Type of File: Apple Disk Image File
The .DMG extension stores QuickBooks backup data inside mounted disk images on macOS systems.
Common Uses
- Software installation
- Backup archiving
- Secure file transfer
PLIST File
Type of File: Apple Property List File
PLIST files store QuickBooks application settings and macOS preferences.
Stored Information
- User preferences
- Registration details
- Application configurations
- System-level settings
Common Issue
Damaged PLIST files may cause:
- Startup issues
- Preference reset problems
- Unexpected QuickBooks behavior
Why Are QuickBooks File Extensions Important?
QuickBooks primarily uses its own proprietary file extensions for accounting operations, alongside support for common formats like Excel, CSV, and PDF. The company has developed its own lingo. Distinct file extensions have different properties and are used for different reasons. The causes for this include the following:
- By glancing at the extension of a file, it becomes easy to figure out what it contains. Everything is clearly labeled.
- To avoid disorganization, users might organize their data by file extension. It also facilitates auditing.
- When a file is identified, the desktop can open it in the appropriate program.
- QuickBooks file extensions allow users to authenticate and safeguard data files.
Different extensions also help QuickBooks determine which program or process should open a file automatically.
QuickBooks file extensions are part of a complete accounting file ecosystem. From the main QBW company file to support files like ND, TLG, LOG, and ECML, each extension helps QuickBooks manage accounting data, networking, recovery, backups, and collaboration.
You do not need to memorize all QuickBooks extensions, but understanding the most important ones can help you troubleshoot errors faster, manage backups safely, and maintain a more stable QuickBooks environment.
Accounting Professionals, CPA, Enterprises, Owners
Looking for a professional expert to get the right assistance for your problems? Here, we have a team of professional and experienced team members to fix your technical, functional, data transfer, installation, update, upgrade, or data migrations errors. We are here at Dancing Numbers available to assist you with all your queries. To fix these queries you can get in touch with us via a toll-free number
+1-800-596-0806 or chat with experts.
Frequently Asked Questions
Can I open a .QBW or .QBB file without having QuickBooks installed?
No, These are proprietary formats that require QuickBooks software or an official migration tool to access the data. You must restore the file within the application or export the data to a universal format like Excel.
What is the Difference between a .QBB (Backup) and a .QBM (Portable) file?
A .QBB file is a complete backup including all templates and images, while a .QBM file is a smaller, highly compressed version designed for emailing. Use .QBB for data security and .QBM for quick transfers to your accountant or a new device.
How do I fix “Company File Not Found” errors related to .ND files?
Renaming or deleting the .ND (Network Data) file forces QuickBooks to recreate it and refresh the connection to the server. This is a standard fix for common multi-user hosting errors like H202 or H505.
Why is my .TLG file so Large, and is it safe to delete?
The .TLG file grows with every transaction until a full backup is performed, which resets its size. Do not manually delete it; instead, run a manual backup with verification to shrink the file safely.
How do I import an Accountant’s Changes from a .QBY file?
Open your .QBW file, go to the File menu, and select “Import Accountant’s Changes from File” to merge the adjustments. This file cannot be opened directly and must be imported into the specific company file it was created from.
Are .log, .nd, and .ecml Files Safe to Delete?
Yes, .log and .nd files are safe to delete as QuickBooks automatically recreates them to resolve connection and diagnostic issues. However, deleting .ecml files will wipe your registration data, forcing you to re-activate the software with your license and product keys.
