What are the File types and Extensions used by QuickBooks Desktop?

How to learn about different file types and extensions used by QuickBooks Desktop:

No doubt QuickBooks is one of the biggest names in the accounting software industry with its innumerable features. And because of these multitudinous features, file types and extensions used in QuickBooks Desktop by many business owners or accountants. To run their small to medium sized business. While managing all the financial aspects like your invoices, pay bills, tax payment, bank account tracking and cash flow, QuickBooks encounters many types of files. The QuickBooks file extensions are used for different purposes in the program to save the data. Different type of file extensions are used with different editions of QuickBooks. This includes QuickBooks 2017 will be using different file extension than that of used by QuickBooks 2018. So, in order to know more about these file extensions and their types used by QuickBooks read this comprehensive article till the very end.

See Also: QuickBooks unable to Open Company File?

What do you understand by File Extensions and QuickBooks File Extensions?

At first, File extensions are the abbreviations generally available at the end of the file name. It further indicates the type of content and the purpose of the file.

Some common file extensions used are:

• A JPEG uses the .jpg or .jpeg extension (for example, image.jpg)
• A Word document uses the .docx extension (for e.g. – CoverLetter.docx)
• An Excel spreadsheet uses the .xlsx extension (for example, budget.xls)

Whereas QuickBooks file extensions are exclusively for QuickBooks. QuickBooks file extensions are generally in the format of .xxx. Most commonly used QuickBooks file extensions are .QBW, .QBO, .QBB etc.

Importance of using QuickBooks File Extensions

It is important to emphasize that, different types of QuickBooks file extensions have different aspects. They are further used for different purposes. Let’s check out the importance of different file extensions given below:

• File extensions make it easy for the users to determine what type of content a particular file contains. As everything is clearly labeled.
• With the help of file extensions, it becomes easy for the user to organize their accounting data. As it categorizes the same kind of file extensions. This prevents data from merging and also facilitates auditing.
• By just looking at the file extension user can easily identify the type of file. And this saves a lot of time.
• File Extensions help in easy identification of file type that helps desktop to open the file in the right application.
• QuickBooks file extensions assist in verification of authentication of data files in order to safeguard data files.

Read Also: TLS Error: QuickBooks Online Internet Explorer Security Changes

Types of QuickBooks File Extensions that are used commonly:

Different types of file extensions that are commonly used while working with QuickBooks are categorized below:

File Extension	File Type	Characterization
‘.QBW’	QuickBooks Company File	It is used by QuickBooks software to store accounting data, letters, logos, images and other relevant info of company files which is saved by using ‘.qbw’ file extension.
‘.QBO’	QuickBooks Online Bank Statement File	A file saved by ‘.qbo’ extension holds electronic bank statements that can be easily opened up by QuickBooks software during the process of downloading transactions from the back.
‘.QBB’	QuickBooks Backup File	Files usually saved by ‘.qbb’ extension are backup files of QuickBooks company file that are created by QuickBooks accounting software and usually hold the backups of financial records, images, logos, templates, and letters.
‘.QBM’	QuickBooks Portable File	Files that are saved by ‘.qbm’ extensions are the compressed version of ‘.qbw’ files usually created by QuickBooks accounting software while moving a company file.
‘.QBX’	Accountant’s review copy (Export file)	File with ‘.qbx’ extension are the files crafted by QuickBooks software during the generation of accountant’s review copy of QuickBooks Company file. This is the export file that can be sent to your accountant.
‘.QBA’	QuickBooks Accountant Copy working file.	A file with ‘.qba’ file extension is an accountant copy that is sent by clients for the accountant’s review purposes.
‘.QBJ’	General Journal Entries File	A file with ‘.qbj’ extension is the file created when the user wants to add journal entries created by the accountant, to send a general journal entries file.
‘.QBY’	Accountant’s Copy import file	A file with a .qby extension is the file sent to QuickBooks users after the accountant review their accountant copy and makes changes. This is the import file where users can easily apply changes to the company file.
‘.ND’	Network Data File	While accessing to multi-user mode, QuickBooks usually crafts file with ‘.nd’ as extension that helps QuickBooks to manage the user access settings
‘.TLG’	Transaction Log File	QuickBooks always keeps track of changes made to your company file since the last backup. This QuickBooks software saves this information in a file which is named with a ‘.tlg’ extension. So, the next time when you take a backup of your company file, it will automatically reset the file.
‘.LOG’	Event Log File	Files with ‘.log’ extension are created by QuickBooks to record essential events. These log files are mainly used for troubleshooting purposes. Two types of LOG files are:Qbwin.log – records issues detected during a rebuild.QWC.log – record the QuickBooks Event log errors of Web Connect.
‘.DES’	Layout Designer Template file	File with a ‘.des’ file extension is created by QuickBooks when the user exports a customized form template. It is easy to export this file and can be used in other company files or shared with others.
‘.QBR’	QuickBooks Report Template File.	A file with a ‘.qbr’ extension is created by QuickBooks when the user wants to export a memorized report template.
‘.QBSTBL2.USA ‘	US Tax Table File	A file with ‘.qbstbl2.usa’ is created when you run a payroll in QuickBooks Desktop that gives you the current tax table. This file also gives all the latest payroll info that will be required to calculate the payroll taxes easily.

Also Read: QuickBooks – Application with Revoked Certificate

Utility and Log files

File Extension	File Type	Description
IIF	Intuit Interchange format file	When the user exports the list info, QuickBooks creates a file that has .iif extension. This file can be used to share lists with other company files.
QBP	QuickBooks Print file	When you set the printing preferences, the software saves them in a file with .qbp extension.
ECML	Entitlement File	When you install or register QuickBooks, a file with .ecml extension is generated, it further communicates to QuickBooks that the user is making use of a licensed product.

QuickBooks Statement Writer Files

File Extension	File Type
QSS	When you customize the statements and reports with QuickBooks statement writer, the software usually saves the settings in a file with .qss as the extension. You can use this file to apply settings to other reports.
QSM	When you use QuickBooks statement writer, it saves the information with .qsm extension. The QSW file can be used in MS excel.
QST	In case there is a specific layout needed by the user, a template file can be used, which is already available. These files can be spotted with .qst as extension.

Don’t skip this: How to Upgrade or Convert your Company File to a Newer Version in QuickBooks Desktop for Mac?

Miscellaneous File Extensions

QuickBooks for MAC

File Extension	File type	Description
QB2016	Company file	This particular version of the company file is for the QuickBooks 2016 Mac.
Plist	Apple property list files	This file stores the registration and preferences.
QB201	Company file	This file is for the QuickBooks version 2019 of Mac.
DM	Apple disk image file	The DM file is a backup QuickBooks company file saved as an apple disk image by QuickBooks.
MAC.QBB	Backup file	Note that you can use this file to move QuickBooks Mac file over the QuickBooks desktop for windows.

Final Words!

There are numerous file extensions and file types available but it is not necessary to know all of them. But the file types and extensions used in QuickBooks Desktop that are listed above are the most commonly known. QuickBooks Desktop uses these extensions where each one has a significant role in business accounting. This article covers everything that is essential for the users to have an outlook on a variety of file extensions. Once you get a general idea about them you will find that they will make processes smoothen. And further produce a faster workflow and also save you time.

Moreover, you can also get in touch with our 24/7 QuickBooks enterprise support team with the help of our dedicated support line i.e. +1-800-360-4183. Our team will provide you with the most relevant information. And we will ensure that all your queries related to QuickBooks are answered in the best possible way.

 

FAQs Related to File Types and Extensions in QuickBooks

 

Other Resources:

How to Resolve QuickBooks Error Code 15106?

How to transfer QuickBooks from Old Computer to a New Computer?

Solve Unable to Find or Open QuickBooks Desktop 2022?