What are different types QuickBooks File Extensions?

QuickBooks Error 6190, -816
How to Resolve QuickBooks Error 6190, -816
November 2, 2018
features of QuickBooks Enterprise
What are the Benefits of Advanced features in QuickBooks Enterprise?
November 3, 2018
QuickBooks File Extensions

QuickBooks is popular software that makes life easy and comfortable for all the accounting and bookkeeping needs. You perform several transactions every day in your QuickBooks related to various tasks. Juggling from one file to another is a common and usual activity that one carries out every day. Do you remember all the QuickBooks Files on your computer and know exactly why you require them? This is an important question to answer.

The article will educate you on QuickBooks Backup files and QuickBooks Working Files. It is essential to know the QuickBooks Files and their functioning to utilize QuickBooks’ abilities fully.

Mainly three files are used on a regular basis. These files are “.qbw,” “.qbb” and “.qbm” files – these are QuickBooks Working files, QuickBooks Backup files, and QuickBooks Portable Company files. Several other file extensions or file types are also there that come in use from time to time. The below table enlists the various QB file extensions.

 

EXTENSION NAME

THE FILE TYPE

 DESCRIPTION

‘AIF’ This is the Accountant’s review copy (the import file) The file is created when the Accountant’s copy is exported to import it to the user’s company file.
‘. BDB’ The Timer Back-up file This is the backup file created when the user backs up time-data in ‘QuickBooks Pro Timer.’
‘.BMP’ The windows Bitemap file The files store/contain “bitemapped images” used by QuickBooks
‘. BPW’ The Business Planner file. This file is not backed-up with the company file, thus needs to be separately copied to the backups.
‘. DES’ The Form design template file The file is made while exporting a form design from the templates list.
‘. DOC’ The Word Documents These documents are used to “write letters” function/action.
‘. IIF’ The Intuit Interchange Format file It lets you import & export lists/transactions via text files with an ‘. IIF’ ext.  Using the ‘. IIF’ files is not recommended. Instead, QuickBooks SDK should be used to read and write data for QB and other apps.
‘. INI’ The Configuration file This file lets you support “Online Banking.”
‘. LDB’ The MS Access file for Timer data. This is an MS Access file required for the “*. TDB file”.
‘. LGB’ The Little Green Box The 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 user name and password to open the connection with the “Sybase server.”
‘. LMR’ The Loan Manager Data The file is made by the “Loan Manager” and stores info related to loans. You have to separately copy this file to the backups, as it is not backed up with the company file.
‘. ND’ QuickBooks Network Data File This is a configuration file that allows access to QuickBooks company file. You have to keep this file and ensure that it does not gets deleted.
‘. NPC’ The Online Banking File (obsolete) The file is an online banking format used by former QB versions and was superseded by “OFX” format. Financial institutions no longer support it.
‘. QBA’ The Accountant’s review copy (working copy) The accountant restores a QBX file, and the file is given a.QBA extension.
‘. QBA.TLG’ The 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 accidently, you might loose your data it can be recovered with the help of this “Transaction log file.”
‘. QBB’ The QuickBooks backup file It is QuickBooks Company backup file. If you want to open the ‘. QBB’ file -navigate to File menu & click Restore.
‘. QBI’ The QuickBooks image file The image file will hold transactions till the time you transfer them to the hard drive. The file stores the memory- resident changes to the data file. Once you close the company file, the “. 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 the QBI file when the QBW file is open in QuickBooks.
‘. QBM’ The QuickBooks Portable Company File (2006 v and above). This file is smaller than QBW or QBB file and contains all the data. It doesn’t store the database indexing. The file is useful for transferring the data file via the internet as the data size is smaller than any other file type.
‘. QBO’ The Web Connect file. The file is known as “Web Connect Online Banking download file.” You download this file from the bank while using the “Web connect method” for Online Banking.
‘. QBW’ QuickBooks for Windows company file The primary file type for QuickBooks Company file.
‘. QBW.TLG’ The 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’ The 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’ The 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.
‘. TDB’ QuickBooks Pro Timer files. In QBTIMER directory,  there is a “Time tracking data from QuickBooks Timer.
‘Archive Copy XX/XX/200X ABC.QBW.’ The Archive copy of the data file The file is made when you condense a data file in QB. 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’ The Connection Log file This is the “Online Banking Connection log file” that has a log of each connection for the Online Banking.
‘DownloadQBXX folder.’ The Download folder The folder is made by QuickBooks to store the updates that get downloaded when you use the “Update QuickBooks” function.
‘Images Folder’ The Images folder It stores “ temporary copies’ of images used by QuickBooks.
‘Inet Folder’  The Inet It is no longer used. Earlier was used to store “License information” for QB.
‘QBInstanceFinder’ The Instance Finder file The file is no longer used by QB. You can delete the file, though it might again come up in some versions of QB.
‘QBrestor.TMP’ The Temp restore file. The file is made while restoring the QBB file that was deleted automatically during the restore process.
‘Qbwin.log’ The 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 QB Installation directory.
‘QuickBooks Letters Templates folder.’ The Letters Folder The folder contains the ‘word document templates” for QuickBooks ‘ write letters function.
‘Temp1234.qbt’ The Temp rebuild file. It is created during “Pass 1 of the rebuild” & is deleted automatically when the rebuild is finished.

 

The above article gives a good insight into various QuickBooks File extensions and their purposes. For efficient and full utilization of the software, it is essential to know the variety of file types that are available. If you face difficulty in understanding and using any of the above extensions, it is advisable to seek technical help at QuickBooks Error Help number +1-877-263-2742.

Further, if you ever feel the need of taking advice from your fellow business owners that happened to be our existing subscribers, you can visit our thriving QuickBooks Community.

Leave a Reply

Your email address will not be published. Required fields are marked *

1-877-263-2742