Skip to main content

File Types and Extensions Used by QuickBooks

· 5 min read
Debits

Introduction​

QuickBooks uses various file types and extensions to manage different aspects of your financial data. Understanding these file formats is essential for efficiently handling backups, data transfers, imports, and troubleshooting within QuickBooks. This guide provides a comprehensive overview of the primary file types and extensions used in QuickBooks Desktop.

Primary QuickBooks File Types​

1. QuickBooks Company File (.QBW)​

  • Description: The .QBW file is the main file format used by QuickBooks to store your company's financial data, including transactions, accounts, and reports.
  • Usage: This file is the core of your QuickBooks data and is the one you'll interact with most frequently during daily operations.

2. QuickBooks Backup File (.QBB)​

  • Description: The .QBB file is a backup file that contains a copy of your QuickBooks company file (.QBW), templates, letters, logos, and other necessary documents.
  • Usage: Use this file to restore your company data in case of corruption, data loss, or when transferring data to another computer.

3. QuickBooks Portable Company File (.QBM)​

  • Description: The .QBM file is a compressed version of your company file, making it smaller and easier to transfer via email or other storage devices.
  • Usage: This file is ideal for sharing your company data with accountants or transferring the file over the internet.

4. QuickBooks Accountant's Copy (.QBX, .QBA, .QBY)​

  • QBX (Accountant’s Transfer File): This file is created when you send your company file to an accountant. It allows the accountant to make adjustments without affecting your ongoing work.
  • QBA (Accountant’s Copy): The .QBA file is what the accountant works on after opening the .QBX file. It allows for editing and making necessary adjustments.
  • QBY (Accountant’s Changes): After the accountant makes changes, the .QBY file is generated and sent back to the client to be incorporated into the original .QBW file.

5. QuickBooks Transaction Log File (.TLG)​

  • Description: The .TLG file logs all transactions entered into QuickBooks since the last backup was made.
  • Usage: This file helps in recovering data in case the .QBW file becomes corrupted. It works alongside the .QBW file to restore lost data.

6. QuickBooks Network Data File (.ND)​

  • Description: The .ND file supports multi-user access by storing configuration information that allows QuickBooks to locate the company file on a network.
  • Usage: This file is essential for enabling multi-user mode, where multiple users can access the company file simultaneously.

7. QuickBooks Configuration File (.INI)​

  • Description: The .INI file stores configuration settings for QuickBooks, such as your preferences and initial setup details.
  • Usage: QuickBooks reads this file upon startup to load your customized settings.

Additional QuickBooks File Types​

1. QuickBooks Web Connect File (.QBO)​

  • Description: The .QBO file is used to import bank transactions into QuickBooks. It is downloaded directly from your bank's website and then imported into QuickBooks.
  • Usage: This file simplifies the process of reconciling your bank accounts by automatically importing transaction data.

2. QuickBooks Statement File (.QIF)​

  • Description: The .QIF file format is used to import bank statements into QuickBooks. However, it is less common and has been largely replaced by .QBO files.
  • Usage: Primarily used for importing older bank statement data.

3. QuickBooks Report Template (.QBR)​

  • Description: The .QBR file contains custom report templates created in QuickBooks that can be shared and imported into other company files.
  • Usage: Use this file to export and import customized reports across different QuickBooks files or companies.

4. QuickBooks Form Template File (.DES)​

  • Description: The .DES file stores customized forms such as invoices, purchase orders, and estimates.
  • Usage: Use this file to transfer or back up custom form designs in QuickBooks.

5. QuickBooks Backup of QuickBooks Desktop for Mac (.DMG)​

  • Description: The .DMG file is a backup file format specifically for QuickBooks Desktop for Mac users.
  • Usage: This file is used to create and restore backups on Mac versions of QuickBooks Desktop.

Best Practices for Managing QuickBooks Files​

  • Regular Backups: Always create regular backups of your .QBW file to ensure you can recover your data in case of corruption or data loss.
  • File Organization: Keep your QuickBooks files organized in dedicated folders, clearly labeled by date or purpose, to make retrieval and restoration easier.
  • Use Portable Files: When sharing QuickBooks data with accountants or colleagues, consider using .QBM or .QBX files to simplify the transfer process.
  • Secure Your Files: Protect your QuickBooks files with strong passwords and store backup files in secure locations to prevent unauthorized access.

Conclusion​

Understanding the different file types and extensions used by QuickBooks is crucial for managing your financial data effectively. Each file type serves a specific purpose, from everyday data entry and backups to file sharing and troubleshooting. By familiarizing yourself with these file formats, you can ensure that your QuickBooks data remains organized, secure, and easily accessible when needed.