QuickBooks File Extensions and Types

QuickBooks File Types Differences

In this ultimate article, we elaborate on the information related to QuickBooks file types differences and extensions. Also, we explained some backup file extensions as well as the company file extension that applies to all files.

QuickBooks Desktop is one of the widely used software in recent times that is easy to use for managing finances and keeps a better track of your business health. Moreover, it also offers different types of files and extensions to store different types of data. Such as the backup data files (QBB) and the main company file (QBW) are completely different from each file type in QuickBooks Desktop.

What are the QuickBooks File Types Differences

Check out the table containing the QuickBooks file types differences and its extension name along with a brief description.

File Extension nameFile TypeDescription
Temp 1234.qbtrebuild temp fileIt is created by the user during the Pass 1 rebuild process and is immediately removed once the rebuild process has been completed
Qbwin.logQuickBooks Log fileThis file is made or updated when you run the rebuild/verify option. It’s placed in the directory for downloading QuickBooks.
QBInstanceFinderInstance Finder fileYou can delete this file, however, it might come up again in some versions of QuickBooks
QBrestor.TMPThis file was created while restoring the QBB file and was automatically deleted during the restoring processThis file is created while restoring the QBB file and was automatically deleted during the restoring process
QuickBooks Letters Templates folderLetters FolderIt contains templates for Word documents for writing letters function of QuickBooks
DownloadQBXX folderDownload folderIt is created to store the updates that get downloaded when you use the “update QuickBooks” functions
Inet folderInetThis is an earlier used function to store “License information” in QuickBooks
CONNLOG.TXTConnection Log fileIt is the “Online Banking connection log file” that contains the log of each connection for the Online Banking
Images FolderImage folderIt stores “temporary copies” of images that are used by QuickBooks
.TDBQuickBooks Pro Timer filesThere is a “Time tracking data from QuickBooks Timer” in the QBTIMER directory
QBW192.168.X.XXmtaTemporary Database fileIt is a temporary file created by the “Database Manager” while opening the company file
.QBOWeb connect fileIt is commonly known as a web connect online banking download file. You can easily download this file from the bank while using the “web connect method” for the purpose of online banking
.NPCOnline banking file (obsolete)It is an online banking format that is used by former QB versions and was replaced by “OFX” format
.LDBMS Access file for Timer dataIt is an MS Access file that is needed for the “*.TDB file”
.INIConfiguration fileThis file allows you to support “Online Banking”
.DESForm design template fileIt is created while exporting a form design that you can find from the template list.
.BMPWindows Bitmap fileIt stores bitmapped images that are used in QuickBooks
AIFAccountant’s Review copy (the import file)It is made while exporting to the user’s company file of Accountant’s copy
.BPWBusiness planner fileIt is not backed up with the company file, it requires a separate backup copy
.BDBTimer backup fileIt is made when the user is trying to take a backup of time data within QuickBooks Pro Timer

QuickBooks File Extensions for Accountants

Check out here are some of the QuickBooks File extensions that are used for the accountant:

  • QBY extension: This file is created after importing when the accountant completes the modifications before sending it to the client.
  • QBX extension: It is also created after importing when a client is sending the file to their accountant
  • QBA extension: This work file is created on QuickBooks by the Accountant where who reviews the file and makes the required modifications; it is created from the QBX file sent by the client.

QuickBooks File Extensions for Windows

The Below-mentioned are some of the QuickBooks file extensions that are used for Windows different versions:

  • QBB extension: It is a backup file created from QuickBooks
  • QBW extension: It is usually used by users for the company file
  • QBM extension: It is a portable copy of the company file that helps in sending and receiving the files.

QuickBooks File Extension for Payroll Files

Here is the file extension that issued for the Payroll files

  • 1PA: It is the extension used for the 940 and 941 tax form files
  • QPD: QuickPay type of data file created through QuickPay version 3.0
  • TXT & SET: These are QuickBooks version 2.0 and 2.1
  • Qpconvrt.log: This is a log that stores all payroll warning messages
  • Taxtbl.usa: It is the extension for Windows version 3.1

Other QuickBooks Company Files Extension

Check out some more extensions for the Company file extension.

  • Qbwin.log (QuickBooks log file): This file includes a log from the QuickBooks company file for all records generated or changed by the user.
  • .ND (QuickBooks Network Data file): It is a configuration file that keeps a record of the computer network that allows access to other files on the network
  • Temp 1234.qbt (temp rebuild file): This file is created by the user while rebuilding the company file
  • IIF (Intuit Interchange Format file): It lets users import or export transactions and lists from either Bank or other QuickBooks Desktop. Learn how to fix IIF import errors in QuickBooks while importing and exporting data.
  • LMR and .LMX extension files: These files contain information related to the loan that a user tracks in the QuickBooks company file
  • TLG extension: This log file contains all the transactions in QuickBooks. It allows the software to recover old and desired transactions.

So, the ultimate guide ends here with the hope that you find it easy to understand QuickBooks file extensions and QuickBooks file types with differences. However, each type of QuickBooks File has a unique extension. Although QuickBooks file extension type may vary based on which version of QuickBooks you’re using. If you still need assistance or want to explore more information, suggest you connect with a QuickBooks support toll-free help desk number.