Learn about different file types and extensions used by QuickBooks Desktop

QuickBooks Desktop is one of the most popular accounting software that is used by hundreds of thousands of people around the globe. It is a software which is used by both small as well as medium-sized companies. Now, as it is used by so many different companies and the regions as well as preferred file formats are pretty varied from one another, there are a handful of file types and extensions that are used by QuickBooks Desktop. So, in this article, we will go through all of the important and commonly used file types and extensions. Thus, make sure to go through the post till the end.

However, you can also get in touch with our QuickBooks support team via our toll-free number i.e. 1-800-761-1787. Our team of experts and certified professionals will ensure to provide the best possible support services related to any QuickBooks query.

You may also read: Resolve Error QuickBooks has stopped working

What is QuickBooks file extension?

QuickBooks file extension is basically the extension used at the end of the file name, which defines the purpose of the file. It is generally in the form .xxx. The QB file extension basically helps the user in identifying the files and finding out the what purpose is to be served by each of the files. QuickBooks file extensions are essential for the users to identify the file and avoid any kind of mess related to the data.

How significant are QuickBooks file extensions?

It should be noted that the every QuickBooks file extension carries a different significance and server different purpose. Let us check out how significant are file extensions:

  • Determining the type of content a particular file is containing becomes easy for the users with extensions.
  • With extensions, it is possible for the user to categorize the same kind of the QuickBooks file extension to keep the accounting data categorized and prevent data from merging.
  • The extensions help in identifying the file type, which can ultimately help the desktop to launch the file in the right application.
  • They also assist in verifying the authentication of data files in a manner to secure them.
  • By simply looking at the file extension, the user will be able to identify the file type and save a lot of time.

Types of File Extensions in QuickBooks Desktop

There are different types of file extensions that can be explored from below. Extensions related to similar files are categorized below:

Common QuickBooks File Extensions

File Extension File Type Description
QBWQuickBooks company fileWhen the user creates a company file, at that very time a file with .qbw extension is automatically created by the QuickBooks accounting software. The file so created basically holds the company file and the other relevant account info. To understand it in a better way, let us take an example, if you create a company with the name Mycompany, then in that case the file will be saved as Mycompany.qbw by QuickBooks accounting software.
QBOQuickBooks Bank statement fileDuring the process of downloading transaction from the bank, the QuickBooks accounting software opens the transactions from a file with an extension as .qbo. The user can easily import a QBO file, in order to get transactions into the bank register in a faster way.
QBBQuickBooks backup file The .qbb extension file, a backup file is crafted by the QuickBooks accounting software, when the user takes a backup of the original company file.
QBMQuickBooks portable fileTalking about this extension, when a user tries to email or transfer a company file, in that situation the QuickBooks accounting software crafts .qbm extension file, which is a compressed version of a company file.

See Also: Uses of QuickBooks tool hub

Additional QuickBooks files

File Extension File Type Description
QWCQuickBooks Web connector fileIf the user uses the QuickBooks Web connector, the user might need to open apps. When the web connector app is opened up by the third party developers, a file with .qwc file extension is crafted.
QBRQuickBooks Report Template FileIn case the user exports a memorized report template, QuickBooks software creates a file with the extension as .qbr
DESLayout Designer Template file  In case the user exports a customized form template, QuickBooks accounting software creates a file with .des extension. QuickBooks offers a variety of templates. The user might want to export the custom templates to use in the other company files or share with others.
Qbstbl2.usaUS Tax Table FileIf the user runs payroll in QuickBooks desktop, he/she will be required to get the current tax tables. It has all of the latest payroll information required to calculate the payroll taxes.

Accountant files

File Extension File TypeDescription
QBX Accountant’s review copy (export file)At the time while the user generate an accountant’s review copy of QuickBooks company file, the QuickBooks software generates an accountant’s review copy with a QBX extension.
QBJGeneral journal entries fileIn case the users want to add journal entries created by the accountant, then ask them to send a general journal entries file. This file comes with a .qbj extension.
QBAAccountant’s copy fileAn accountant copy is considered to be a file with .qbx extension sent by a client to the accountant for review purpose. This file comes with an extension as .qba.
QBYAccountant’s copy import fileOnce the accountant reviews their account copy and makes necessary changes, they send a file with .qby extension to the user. The user can easily import or apply changes to the company file.

Utility and log files

File ExtensionFile Type Description
IIF Intuit interchange format file When the user export the list info, QuickBooks accounting software creates a file with an .iif extension. The user can use this file to share the lists with other company files.
LOGEvent log file.log extension is used by QuickBooks to record essential events. There can be two types of Log files:

# Qbwin.log: this records the issues that are detected during a rebuild.
# QWC.log: it records the web connect errors It should be noted that the log files can be used for troubleshooting purposes.
QBPQuickBooks Print fileWhen the user set the printing preferences, the QuickBooks software saves them in a file with the extension as .qbp. It should be noted that QuickBooks auto-saves the settings. However, the user might be required to make changes to the file, in case of printer issues.
ECMLEntitlement fileAt the time when the user installs and registers QuickBooks, it creates an .ecml file extension. This file communicates to QuickBooks that the user is making use of a licensed product.
TLGTransaction log fileSince the last backup, any changes made to the company file are noticed by the QuickBooks accounting software. This software saves the information into a file, which is named with .tlg extension. The next time user takes a backup of the company file, QB will automatically reset the file.
NDNetwork data file In case of multi user mode, QuickBooks accounting software creates a file with .nd as the extension. This .nd file helps the software in managing the user access settings.

Read Also: What is QuickBooks student discount?

QuickBooks statement writer files

File extensionFile type
QSS When the user customizes the statements and reports with QuickBooks statement writer, the software saves the settings in a file with .qss as the extension. The user can make use of this file, in order to apply settings to other reports.
QSMIn case the users make use of the QuickBooks statement writer, the software saves the information with .qsm extension. QSW file can be used by the QuickBooks users in MS EXCEL.
QSTIf a specific layout is required by the user, a template file can be used, which is already available. These files generally have .qst as an extension.

QuickBooks for MAC

File ExtensionFile TypeDescription
QB2016Company fileThis is the company file for the 2016 version of QuickBooks for Mac.
PlistApple property list filesThis plist file stores the registration and preferences.
QB201Company fileSimilar to the QB2016, this is the company file for the 2019 version of QuickBooks for Mac.
DMApple disk image fileThis is the backup QuickBooks company file, which is saved as an apple disk image by QuickBooks.
MAC.QBBBackup fileThe user can use a MAC.QBB file in order to move the QuickBooks Mac file over QB desktop for windows.

Miscellaneous File Extensions

File ExtensionFile TypeDescription
Temp 1234.qbtTemp rebuild fileThis file is created during “Pass 1 of the rebuild” & is deleted on its own when the rebuild is finished.
QBwin.logQuickBooks Log fileThe Qbwin.log file is created/updated when the users run or verify/rebuild option. This file helps the user to spot “Log problems and situations corrected”. The Qbwin.log file is generally stored in QuickBooks installation directory.
QuickBooks Letters Templates folder Letters FolderThe QuickBooks letters templates folders contain the word document templates for QuickBooks writer letters function.
QBrestor.TMPTemp restore the fileThis file is usually made at the time of restoring the QBB file, which was deleted automatically during the restore process.
Inet FolderInetThis folder was earlier used to store “License information” for QuickBooks.
Images folder Images folderThe images folder stores the temporary copies of images that are used by QuickBooks.
QBInstanceFinder Instance finder fileThe user can delete the file, but it might come up again in a few of the QuickBooks versions.
CONNLOG.TXTConnection Log FileThe CONNLOG.TXT file is the online banking connection log file, which a log of each connection for the online banking.
.TDBQuickBooks Pro Timer files There is a time tracking data from QuickBooks timer, which can be found in QBTIMER directory.
DownloadQBXX folderDownload folderThe DownloadQBXX folder is made by QuickBooks for storing the updates that are downloaded at the time when the user make use of update QuickBooks function.
copy XX/XX/200X ABC.QBWAn archive copy of the data fileIt should be noted that a separate QBW file is made with the name of Archive Copy XX/XX200X with QBW file name. It is an exact copy of the company file before being condensed. The user can use this file in to order to view the info that was present in the unmodified file.
QBW.TLGTransaction log file (for QuickBooks company file)This file helps the users to retrieve the lost data for QuickBooks company file.
QBW192.168.X.XXmtaTemporary database fileThis file is made by QuickBooks database server manager and is a temporary file. It is generated at time of opening the company file. The time when the user opens up the main file, the temporary file gets deleted on its own.

Read Also: How to resolve QuickBooks error code 6000 832?

File Types of QuickBooks Desktop for Windows

These file extensions are for the Windows users and these are divided into several parts as per their nominal features:

Common File Extensions for QuickBooks Desktop

  • QBW (QuickBooks Company File): This file extension format is used by the software when a new company file is being created. This file format is useful in case when a user is looking to hold account information and company files.
  • QBM (QuickBooks Portable File): This file format is created whenever a user creates a new compressed version of the company file which is of the .qbm extension. Also, it is created when the user moves or e-mails a company file.
  • QBB (QuickBooks Backup file): This format is especially available only in the case of the creation of a backup file. So, in case the company file is backed up, the users will get the file with a .qbb extension.
  • QBO (QuickBooks Bank Statement File): This format comes with the files which are Bank statements. Such files are easy to import and are lightning-fast in terms of getting the transactions into the bank register.

Additional QuickBooks File Extension

  • DES (Layout Designer Template File): A .des file extension is created whenever a user exports a customized form template. This file is easy to export and can be used in other company files or for sharing it with others
  • QWC (QuickBooks Web Connector File): When a user uses QuickBooks Web Connecter, they might need to open up some apps. Now, whenever a third-party developer application creates a web connector app, it creates a .qwc file extension.
  • QBR (QuickBooks Report Template File): Whenever a memorized report template is exported, QuickBooks creates a file that is of .qbr extension
  • QBSTBL2.USA (US Tax Table File): In case a user runs payroll in QuickBooks Desktop, a qbstbl2.usa file is required to get the current tax table. Now, with this file, the user can calculate the payroll taxes.

Accountant Files

  • QBY (Accountant’s Copy Import File): Once the files and accounts are reviewed by the accountant, the file which he sends forward is .qby extension
  • QBX (Accountant’s Review Copy or Transfer File): Whenever a duplicate or backup of the company file is created, the newly created file comes up in the .qbx format.
  • QBJ (General Journal File): Any changes that are to be made by the accountant in the form of General Journal Entries, the file extension required to complete the same task is .qbj
  • QBA (Accountant’s Copy File): Once a client sends the accounts to the accountant by creating an accountant copy then the created files will be in the .qba file extension.

QuickBooks for Mac

Following are the file types and file extensions that are available on a Mac OS System:

  • DMG (Apple Disk Image): Whenever a backup of a company file is created, the file is saved as Apple Disk Image
  • QB2016 (Company File): This file extension will appear with your company file on the 2016 version of QuickBooks Desktop
  • QB2019 (Company File): This file extension will appear with your company file on the 2019 version of QuickBooks Desktop
  • MAC.QBB (Backup File): The files of this file extension are used to move QuickBooks Mac file over to the QuickBooks Desktop for Windows
  • Plist (Apple Property list files): This file extension is created whenever the user stores a preference or a registration

Fixed Asset Manager Files

  • *.Fx0- Compressed FAM data file. Stores Asset data
  • *.Fx1- Stores system data
  • *.Mx0- Header File
  • *.FPx- Stores report data
  • *.FXR- FAM backup sync log file
  • *.FIM- Stores CSV import data headers.

Connectivity factors in file extension

QuickBooks provides the components of easy to use for QuickBooks facilities tasks like adding, updating, development, seller information, and employee information, transaction, etc. QuickBooks helps the user to access QuickBooks remotely which include QuickBooks attach component or free remote connector for QuickBooks utility:

  • Fast performance
  • Fully integrated components
  • Expendable and uniform design
  • Connect to QuickBooks remotely

You may also read: How to Fix QuickBooks error code 1935?

Final Words!

These are some of the most commonly used and well-known file types and extensions used by QuickBooks Desktop. It is essential for any user to have an idea of as to what these extensions are and which file type they are related to. There are many other file types and file extensions apart from those mentioned in this post. So, make sure to check for the file related details before you change, edit or move any file on the storage or network. For more details, you can get in touch with our 24/7 QuickBooks enterprise support team via our toll-free number i.e. 1-800-761-1787.

Our team will provide you with the most relevant information and will ensure that all your queries related to QuickBooks are answered in the best possible way.


Few other helpful articles:

How to Fix QuickBooks multi-user mode not working problem?

Resolve QuickBooks POS Error code 1330