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-888-383-0323. 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

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 ExtensionFile TypeDescription
QBW   QuickBooks 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.  
QBO QuickBooks 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.
QBB QuickBooks backup fileThe .qbb extension file, a backup file is crafted by the QuickBooks accounting software, when the user takes a backup of the original company file.
QBM QuickBooks portable file  Talking 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.

Additional QuickBooks files

File ExtensionFile TypeDescription
QWC QuickBooks 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.  
QBR QuickBooks Report Template FileIn case the user exports a memorized report template, QuickBooks software creates a file with the extension as .qbr  
DES Layout 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.usa   US 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.  

See Also: Uses of QuickBooks tool hub

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.  
QBJ General 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.  
QBA Accountant’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.  
QBY Accountant’s copy import file  Once 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 TypeDescription
IIF Intuit interchange format fileWhen 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.
LOG Event 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.
QBP QuickBooks 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.
ECML   Entitlement file  At 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.
TLG Transaction 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, QuickBooks will automatically reset the file.
ND   Network data fileIn 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.  

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.
QSM   In 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.
QST If 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.

Read Also: What is QuickBooks student discount?

QuickBooks for MAC

File ExtensionFile TypeDescription
QB2016 Company fileThis is the company file for the 2016 version of QuickBooks for Mac.  
Plist Apple property list filesThis plist file stores the registration and preferences.
QB2019 Company fileSimilar to the QB2016, this is the company file for the 2019 version of QuickBooks for Mac.
DMG Apple disk image fileThis is the backup QuickBooks company file, which is saved as an apple disk image by QuickBooks.
MAC.QBB Backup fileThe user can use a MAC.QBB file in order to move the QuickBooks Mac file over QuickBooks 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 Folder  InetThis 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.TXT Connection Log FileThe CONNLOG.TXT file is the online banking connection log file, which a log of each connection for the online banking.  
.TDB QuickBooks Pro Timer filesThere is a time tracking data from QuickBooks timer, which can be found in QBTIMER directory.
DownloadQBXX folder Download 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.QBW   An archive copy of the data file  It 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.TLG Transaction log file (for QuickBooks company file)This file helps the users to retrieve the lost data for QuickBooks company file.    
QBW192.168.X.XXmta Temporary 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.  

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.

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

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.

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-888-383-0323.

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

Alert: Content is Protected !!!

Pin It on Pinterest

Share This