QuickBooks File Extensions and QuickBooks File Types with Differences

QuickBooks is well-known accounting software that is used by business owners and accountants all over the world in order to manage their small to mid-sized organizations. You may use QuickBooks to handle your invoices, pay bills, measure cash flow, and collaborate with your accounting team. When using QuickBooks, you may come across a number of different file extensions that the computer uses to preserve data.

However, each QuickBooks file type has its own extension. Although the type of QuickBooks file extensions varies depending on which version of QuickBooks you’re using, such as QuickBooks 2016, QuickBooks Enterprise 2017, and so on. In this article, we’ll be talking about QB extension names as they’re used in QuickBooks Desktop. We’ve also covered some QuickBooks File Extensions and QuickBooks File Types with Differences in this article.

What are the Different Types of QuickBooks File Extension & QuickBooks File Types:

These QuickBooks company file extensions apply to all files, such as Accountant, Loan Manager, Payroll, and QuickBooks working files. As a result, different sorts of data are organized into different folders.

Extension NameFile TypeDescription
‘AIF’This is the Accountant’s review copy (the import file)When the Accountant’s copy is exported and imported into the user’s company file, this file is created.
‘.BDB’Timer Back-up fileWhen a user tries to back up time data in QuickBooks Pro Timer, this error occurs.
‘.BMP’Windows Bitmap fileQuickBooks uses “bitmapped pictures,” which are stored in the files.
‘.BPW’Business Planner file.This file is not backed up with the company file and must be added to the backups independently.
‘.DES’Form design template fileThe file is created when a form design is exported from the templates list.
‘.DOC’Word DocumentsThese documents are utilized in the function/action of “writing letters.”
‘.IIF’Intuit Interchange Format fileIt allows you to import and export lists and transactions using text files with the extension ‘. IIF’. To read and write data for QuickBooks and other apps, you should instead utilise the QuickBooks SDK.
‘.INI’Configuration fileSupport for “Online Banking” is enabled with this file.
‘.LDB’MS Access file for Timer dataThis is an MS Access file that must be used with the “*.TDB file.”
‘.LGB’Little Green BoxThe LGB file stores encrypted information about usernames and passwords. When an SDK programme is attached to a business file and has to be opened in an unattended mode, this file is used. To connect to the “Sybase server,” you will need a username and password.
‘.LMR’Loan Manager DataThe “Loan Manager” creates this file, which contains information on loans. This file must be copied to the backups individually.
‘.ND’QuickBooks Network Data FileThis is a configuration file that grants access to the company file in QuickBooks. You must keep this file and make certain that it is not erased.
‘.NPC’Online Banking File (obsolete)It was a former QB version’s online banking format that was supplanted by the “OFX” standard. Financial institutions are no longer willing to help.
‘.QBA’Accountant’s review copy (working copy)Accountant gives a.QBA extension to a QBX file that has been restored.
‘.QBA.TLG’Transaction log file (for the accountant’s review copy)When you back up the accountant’s review copy, QuickBooks creates a transaction log that continues from the last time you backed up. If you lose your data by accident, you can restore it with the aid of this “Transaction log file.”
‘.QBB’QuickBooks backup fileIt’s a backup file for QuickBooks Company. To open the ‘. QBB’ file, go to the File menu and select Restore.
‘.QBI’  QuickBooks image fileTransactions will be stored in the image file until they are transferred to the hard disc. Memory-resident changes to the data file are stored in the file. The “. QBI” file will be automatically removed when you close the company file.
‘.QBM’QuickBooks Portable Company File (2006 v and above)The data is contained in this file, which is smaller than the QBB or QBW files. The database indexing is not saved. Because the data file is smaller than any other file type, it is useful for sending data files over the internet.
‘.QBO’Web Connect fileThe “Web Connect Online Banking download file” is the name of this file. When you use the “Web connect method” for Online Banking, you download this file from the bank.
‘.QBW’QuickBooks for Windows company fileThe QuickBooks Company file’s primary file type.
‘.QBW.TLG’    Transaction log file (for QuickBooks company file)You can use this file to recover lost data from a QuickBooks Company file.
‘.QBW192.168.X.XXmta’Temporary Database FileThis is a temporary file created by the “Database Manager” while the company file was being opened. The temporary file will be erased when you access the original file.
‘.QBX’ Accountant’s review copy (export file)When you create an “accountant’s review copy” of a QuickBooks Company file, QuickBooks creates an accountant’s review copy with the extension “.QBX.”
‘.TDB’QuickBooks Pro Timer filesThere is a file called “Time tracking data from QuickBooks Timer” in the QBTIMER directory.
‘Archive Copy XX/XX/200X ABC.QBW.’     An archive copy of the data fileA separate QBW file with the name “Archive Copy XX/XX/200X followed by the QBW file name” is created. Before condensing, the file is an exact copy of the company file. This file can be used to view information that was present in the original file.
‘CONNLOG.TXT’Connection Log fileThis is the “Online Banking Connection log file,” which contains a log of each Online Banking connection.
‘DownloadQBXX folder.’Download folderQuickBooks created the folder to hold the changes that are downloaded when you utilize the “Update QuickBooks” function.
‘QBInstanceFinder’    Instance Finder fileAlthough you can delete the file, it may reappear in some QuickBooks versions.
‘Images Folder’Images folderIt keeps “temporary copies” of images that QuickBooks uses.
‘QBrestor.TMP’          Temp restore the fileThe file is created while restoring a QBB file that was accidentally destroyed during the restore procedure.
‘Inet Folder’InetPreviously, it was used to store QuickBooks’ “License information.”
‘Qbwin.log’QuickBooks Log fileWhen you choose the verify/rebuild option, the file is created/updated. It aids in the discovery of “Log Problems and Situations Corrected.” It’s kept in the QuickBooks Installation folder.
‘QuickBooks Letters Templates folder.’     Letters FolderThis folder contains “word document templates” for the “write letters” feature in QuickBooks.
‘Temp1234.qbt’          Temp rebuild fileThis file is created while “Pass 1 of the rebuild” and can easily be deleted automatically once the rebuild process completes.

QuickBooks File Extensions for Accountant:

QBA Extension: This working file is created on the Accountant’s QuickBooks, where they analyse the file and make any necessary changes. It is derived from the QBX file that the Client sends.
QBX Extension: When a client sends a file to their accountant, this export file is created.
QBY Extension: When the accountant completes the modifications before submitting the client, this import file is created.

Other QuickBooks Company File Extension:

.ND (QuickBooks Network Data File): It’s a configuration file that maintains track of network computers and provides access to other network files.
Qbwin.log (QuickBooks log file): This file includes a log of all the records that the user has generated or edited in the QB company file.
TLG extension: This is a QuickBooks transaction log file. It assists the application in the recovery of transactions.
Temp1234.qbt (temp rebuild file): This file is created by the user while the company file is being rebuilt.
IIF (Intuit Interchange Format file): This is a file that allows users to export and import transactions and lists from Bank or other QB Desktop programs.
LMR and.LMX extension files: These files hold information on the loan that a user keeps track of in their QuickBooks company file.

Also Read: How to Create Company File & Backup in QuickBooks Desktop

Final Words!

So, here we elaborated information about the different QuickBooks File Extensions that you will come across on your desktop while using QuickBooks and what they are for. Hope, it will be helpful for you in understanding QuickBooks file extensions and QuickBooks file types with differences.

In case you have any doubt regarding QuickBooks software, then you can connect with our QB support team for the instant help. You can connect with them through QuickBooks live chat support 24×7 or email us at support@accountingguide.co .

🔔 Frequently Asked Questions

Q1. What are the QuickBooks file extensions that we use for Windows?

Ans: There mainly three QB file extensions that we usually use for Windows:
QBB extension: It is a backup file created from QuickBooks.
QBW extension: It is a Company File which QB users usually use.
QBM extension: It is a Portable Copy of the Company File which helps to send and receive files.

Q2. What is the importance of file extensions in QuickBooks software?

Ans: Different file extensions have different properties and serve different purposes:
➤ Making it easier for users to figure out what type of content is contained in a particular file.
➤ Users can categories the same type of QuickBooks file extension in order to keep their accounting data organized and avoid data tangles.
➤ Users can quickly identify a file type by looking at the file extension and save valuable time.
➤ Identifying the correct file type can assist the desktop in opening the file in the appropriate application.
➤ QuickBooks file extensions also assist users in verifying the authenticity of data files and securing them.

Q3. What are the different file extensions of QuickBooks Payroll Files?

Ans: The below is the listed few file extensions that are used for QB Payroll files:
QPD: QuickPay version 3.0 introduced a new data file format called QuickPay.
1PA: It’s the extension for tax forms 940 and 941.
TXT & SET: Versions 2.0 and 2.1 of QuickBooks are available.
Taxtbl.usa: It is a Windows 3.1 extension.
Qpconvrt.log: This is a log file that keeps track of all payroll warnings.



Write a complaint
Chat Now