Learn about different file types and extensions used by QuickBooks Desktop:

Quickbooks has sprawled a widespread revolution in the accounting industry with its uncountable features. Quite obviously, these multifarious features are a result of complex algorithms. The multitudinous diversity of the software is evident from the wide number of extensions and file types within the Quickbooks software. in this comprehensive blog, we shall be diving into the long list of file types and extensions used in QuickBooks Desktop. By the end of this article, users will be well versed with all the extensions involved in the software. So, it is advised that users go through this article till the very end.

There is always a likelihood of queries and confusion. If in case you too are facing any issues, then don’t feel the slightest hesitation in reaching out to our QuickBooks support team using our support line i.e. 1-800-761-1787, and get instant assistance.

What is meant by QuickBooks file extension?

File extensions in QuickBooks are the extensions included at the end of a file name, which define the purpose of the file. The general format of the QuickBooks file extension is in form .xxx. The file extension assists users in identifying the files and finding out the purpose served by each of the files. QuickBooks file extensions are thus essential for users as they assist in the easy identification of the file.

Significance of QuickBooks file extensions

It should be noted that every QuickBooks file extension carries some specific significance and serves a different purpose. Check out the significance of different file extensions given as under:

  • Determining the type of content a particular file is containing becomes easy for users with extensions.
  • With extensions, it is possible for you to categorize the same kind of 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, you will be able to identify the file type and save a lot of time.

You may read also: How to Fix QuickBooks multi-user mode not working problem?

Types of File Extensions in QuickBooks Desktop

There are different types of file extensions that can be explored 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 My Company, then in that case the file will be saved as Mycompany.qbw by QuickBooks accounting software.
QBOQuickBooks Bank statement fileDuring the process of downloading transactions from the bank, the QuickBooks accounting software opens the transactions from a file with an extension as .qbo. You 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 you take 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.

Additional QuickBooks file extensions

File Extension File Type Description
QWCQuickBooks Web connector fileIf users employ the QuickBooks Web connector, then you might be required to open apps. When the web connector app is opened up by third-party developers, a file with a .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 a .des extension. QuickBooks offers a variety of templates. The user might have to export the custom templates to use in the other company files or share them with others.
Qbstbl2.usaUS Tax Table FileWhile running payroll on QuickBooks desktop, users will be required to get the current tax tables. It has all of the latest payroll information required to calculate payroll taxes.

Accountant files

File Extension File TypeDescription
QBX Accountant’s review copy (export file)At the time when users generate an accountant’s review copy of the QuickBooks company file, the QuickBooks software generates an accountant’s review copy with a QBX extension.
QBJGeneral journal entries fileIn case the user wants 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 a .qbx extension sent by a client to the accountant for review purposes. 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 users. QuickBooks users can easily import or apply changes to the company file.

Related Article: How to Set up access between QuickBooks Desktop and connected Intuit services?

Utility and log files

File ExtensionFile Type Description
IIF Intuit interchange format file When you export the list info, QuickBooks accounting software creates a file with a .iif extension. Users can make use of 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 users 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, users 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 a .ecml file extension. This file communicates to QuickBooks that users are using 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 the .tlg extension. The next time users take a backup of the company file, QB will automatically reset the file.
NDNetwork data file In the 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. Users can make use of this file, in order to apply settings to other reports.
QSMIn case the user makes use of the QuickBooks statement writer, the software saves the information with the .qsm extension. QSW file can be used 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 fileYou can use a MAC.QBB file in order to move the QuickBooks Mac file over the 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 user runs the verify/rebuild option. This file will help to spot “Log problems and situations corrected”. The Qbwin.log file is generally stored in the QuickBooks installation directory.
QuickBooks Letters Templates folder Letters FolderThe QuickBooks letters templates folders contain the word document templates for the 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 is a log of each connection for online banking.
.TDBQuickBooks Pro Timer files There is a time tracking data from QuickBooks timer, which can be found in the QBTIMER directory.
DownloadQBXX folderDownload folderThe DownloadQBXX folder is made by QuickBooks for storing the updates that are downloaded at the time when users make use of the 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 the QBW file name. It is an exact copy of the company file before being condensed. You can use this file in order to view the info that was present in the unmodified file.
QBW.TLGTransaction log file (for QuickBooks company file)This file will help the user 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 the time of opening the company file. The time when users open up the main file, the temporary file gets deleted on its own.

Read it also: Steps to Fix issues when you’re reconciling in QuickBooks Desktop

File Types of QuickBooks Desktop for Windows

These file extensions are for 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 created. This file format is useful in case users are looking to hold their account information and company files.
  • QBM (QuickBooks Portable File): This file format is created whenever the user creates a new compressed version of the company file which is of the .qbm extension. Also, it is created when users move or e-mail 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, 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 the user exports a customized form template. This file is easy to export and can be used in other company files or for sharing with others.
  • QWC (QuickBooks Web Connector File): When QuickBooks users use the QuickBooks Web Connector, then they might be required to open up some apps. 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 the user runs payroll in QuickBooks Desktop, a qbstbl2.USA file is required to get the current tax table. Now, with this file, the user will be able to calculate the payroll taxes.

Accountant Files

  • QBY (Accountant’s Copy Import File): Once the files and accounts are reviewed by the accountant, the file that he/she 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.

Read Also: Steps to Fix backup company file issues in QuickBooks Desktop

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 an Apple Disk Image.
  • QB2016 (Company File): This file extension will appear with the company file on the 2016 version of QuickBooks Desktop.
  • QB2019 (Company File): This file extension appears with the company file on the 2019 version of QuickBooks Desktop.
  • MAC.QBB (Backup File): The files of this file extension are used to move the QuickBooks Mac files 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 easy-to-use components for QuickBooks tasks like adding, updating, developing, selling information, employee information, transaction, etc. QuickBooks lets users access QuickBooks remotely which includes QuickBooks attach component or free remote connector for QuickBooks utility:

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

See Also: How to Move your QuickBooks Desktop file to QuickBooks Online?

Final Words!

These are the most frequently utilized and widely known extensions and file types used by QuickBooks Desktop. The knowledge encapsulated in this article is essential for users to have an idea of the various file extensions and file types. Though we have enlisted the most conspicuous file types in this article, there are still numerous other file types and extensions that are not mentioned in this piece of writing. Therefore, be sure to check for the file-related details prior to making changes to the file’s name, and edit or move any file stored on your network or storage.

For more details, you can get in touch with our 24/7 QuickBooks enterprise support team with the help of our dedicated support line 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:

Fixing QuickBooks Error 6000-77 When Opening Company File

How to Fix QuickBooks Desktop Update Errors?

Voiced by Amazon Polly
Call Now +1-800-761-1787