QuickBooks has been one of the most popular software in recent times owing to the ease of use it provides for keeping the accounts and managing finances of generally small and medium-sized businesses. Thus we offer you simple self-help articles to see your business economy boost with Quickbooks. Here We elaborate information about the different QuickBooks File Extensions that you will come across on your desktop while using Quickbooks and what they are for.
In other words, each type of QuickBooks File has a unique extension. Although QuickBooks file extensions type may vary based on which version of QuickBooks you are using, be it Quickbook 2016, Quickbook Enterprise 2017, etc. in this particular article, we will be referring to QuickBooks extension names as used in QuickBooks Desktop. Also, in this article, we have explained some QuickBooks backup file extension. These QuickBooks company file extension explained are applicable to all files, for example, Accountant files, Loan Manager Files Payroll files or QuickBooks working files. Consequently, different types of data separated by different folders.
What are the Types of QuickBooks Company File Extension?
|‘AIF’||This is the Accountant’s review copy (the import file)||This file is created when the Accountant’s copy is exported to import it to the user’s company file.|
|‘.BDB’||Timer Back-up file||This creates when a user is attempting to back up time data in ‘QuickBooks Pro Timer.|
|‘.BMP’||Windows Bitmap file||The files store/contain “bitmapped images” used by QuickBooks|
|‘.BPW’||Business Planner file.||This file is not backed up with the company file, this needs to be separately copied to the backups.|
|‘. DES’||Form design template file||The file is made while exporting a form design from the templates list.|
|‘.DOC’||Word Documents||These documents are used to “write letters” function/action.|
|Intuit Interchange Format file||It lets you import & export lists/transactions via text files with an ‘. IIF’ ext. Instead, the QuickBooks SDK should be used to read and write data for QuickBooks and other apps.|
|‘. INI’||Configuration file||This file lets you support “Online Banking.”|
|‘.LDB‘||MS Access file for Timer data.||This is an MS Access file required for the “*.TDB file”.|
|‘.LGB’||Little Green Box||LGB file contains encrypted info related to user-names & passwords. The file is used when an SDK app is connected to a company file and has to be opened in an unattended mode. You require a username and password to open the connection with the “Sybase server.”|
|Loan Manager Data||This file is made by the “Loan Manager” and stores info related to loans. You have to separately copy this file to the backups.|
|‘.ND’||QuickBooks Network Data File||This is a configuration file that allows access to the QuickBooks company file. You have to keep this file and ensure that it does not gets deleted.|
|‘.NPC’||Online Banking File (obsolete)||It’s an online banking format used by former QB versions and was superseded by “OFX” format. Financial institutions no longer support it.|
|‘.QBA’||Accountant’s review copy (working copy)||Accountant restores a QBX file, and the file is given a.QBA extension.|
|‘.QBA.TLG’||Transaction log file (for the accountant’s review copy)||When you back-up the accountant’s review copy, QuickBooks initiates a log of transactions that continues form the last time you did a back-up. If accidentally, you might lose your data it can be recovered with the help of this “Transaction log file.”|
|QuickBooks backup file||It is a QuickBooks Company backup file. If you want to open the ‘. QBB’ file -navigate to File menu & click Restore.|
|‘.QBI’||QuickBooks image file||The image file will hold transactions until the time you transfer them to the hard drive. File stores memory-resident changes to the data file. Once you close the company file, “. QBI” file will be automatically deleted. If you encounter a QBI file when QuickBooks is not running, it probably means that QB crashed when you had a file open. Do not remove and keep QBI file when QBW file is open in QuickBooks.|
|‘.QBM’||QuickBooks Portable Company File (2006 v and above).||This file is smaller than the QBB or QBW file and contains all the data. It doesn’t store the database indexing. It is useful for transferring the data file via the internet as the data size is smaller than any other file type.|
|Web Connect file.||This file is known as “Web Connect Online Banking download file.” You download this file from the bank while using “Web connect method” for Online Banking.|
|‘.QBW’||QuickBooks for Windows company file||Primary file type for the QuickBooks Company file.|
|‘.QBW.TLG’||Transaction log file (for QuickBooks company file)||With the help of this file, you can retrieve lost data for QuickBooks Company file.|
|‘.QBW192.168.X.XXmta’||Temporary Database File||This is a temporary file made by the “Database Manager” while opening the company file. The time you open the main file, the temporary file will be deleted.|
|‘.QBX’||Accountant’s review copy (export file)||When you generate an “accountant’s review copy” of QuickBooks Company file, QB generates an accountant’s review copy with a ‘.QBX’ extension.|
|QuickBooks Pro Timer files.||In QBTIMER directory, there is a “Time tracking data from QuickBooks Timer.|
|‘Archive Copy XX/XX/200X ABC.QBW.’||An archive copy of the data file||A separate QBW file is made with the name “Archive Copy XX/XX/200X followed by the QBW file name. The file is an exact copy of the company file before condensing. You can use this file to view info that was present in the unmodified file.|
|‘CONNLOG.TXT’||Connection Log file||This is the “Online Banking Connection log file” that has a log of each connection for the Online Banking.|
|‘DownloadQBXX folder.’||Download folder||The folder is made by QuickBooks to store the updates that get downloaded when you use “Update QuickBooks” function.|
|Images folder||It stores “ temporary copies’ of images used by QuickBooks.|
|‘Inet Folder’||Inet||Earlier was used to store “License information” for QuickBooks.|
|‘QBInstanceFinder’||Instance Finder file||You can delete the file, though it might again come up in some QuickBooks versions.|
|‘QBrestor.TMP’||Temp restore the file.||The file is made while restoring the QBB file that was deleted automatically during the restore process.|
|QuickBooks Log file.||The file is created/ updated when you run verify/ rebuild option. It helps to find “Log Problems and situations corrected.” It is stored in QuickBooks Installation directory.|
|‘QuickBooks Letters Templates folder.’||Letters Folder||This folder contains ‘word document templates” for QuickBooks ‘ write letters function.|
|‘Temp1234.qbt’||Temp rebuild file.||It is created during “Pass 1 of the rebuild” & is deleted automatically when the rebuild is finished.|
QuickBooks File Extensions for Windows
- QBW extension: It is a Company File which users normally use
- QBB extension: It’s a backup file created from QuickBooks
- QBM extension: It is a Portable Copy of the Company file. Which helps to send and receive files.
Also Read: Resolving QuickBooks Desktop Error 9999
QuickBooks File Extensions for Accountant
- QBX extension: This export file is created when a client is sending the file to their accountant
- QBY extension: This import file which is created when the accountant completes the amendments before client submission.
- QBA extension: This working file is created on the Accountant’s QuickBooks where they review the file and make the required amendments, it is created from the QBX file which is sent by the Client.
QuickBooks File Extension for Payroll Files
- QPD: QuickPay data file type created by QuickPay version 3.0
- 1PA: It is the extension for the 940 and 941 tax form files
- TXT & SET: These are QuickBooks version 2.0 and 2.1
- Taxtbl.usa: It is the extension for Windows version 3.1
- Qpconvrt.log: This is a log file that stores all payroll warning messages
Other QuickBooks Company File extension
- Temp1234.qbt (temp rebuild file): The user creates this file while rebuilding the company file.
- Qbwin.log (QuickBooks log file): This file contains a log for all the records, created or updated by the user in QuickBooks company file.
- IIF (Intuit Interchange Format file): This is a file which allows users to export or import of transactions and lists from either Bank or other QuickBooks Desktop
- .ND (QuickBooks Network Data File): It is a configuration file that keeps a record of the network computers that allows access to other files on the network.
- TLG extension: This is a log file of all the transactions in QuickBooks. It helps the application while trying to recover transactions.
- LMR and.LMX extension files: These files contain information about the loan a user tracks in QuickBooks company file.