File Extensions Used In QuickBooks Desktop

QuickBooks is a robust accounting software which is efficient to provide you an all in one accounting solution. QuickBooks is developed under a complex algorithm and because of its large size, it requires various files and components to run properly. Each file in QuickBooks are important to run software because even if a single file gets damaged or missing, you may face several issues in your QuickBooks Desktop software. If you are using QuickBooks to manage your business, you should have a proper knowledge about the file extensions of QuickBooks. This article will provide you a complete information about the File Extensions Used In QuickBooks Desktop.

Knowing about the file extensions of QuickBooks Desktop can be very helpful for you in resolving various errors in QuickBooks specially from the 6000 error series. You can know more about the file extensions used in QuickBooks Desktop by dialing the QuickBooks Customer Service Phone Number +1888-396-0208 toll-free.

QuickBooks For Windows

QuickBooks Working Files

File extension File type Description
*.QBW QuickBooks Company file The QBW format is the company file of QuickBooks. This file stores all the financial data, templates, letters, logos and images of your company.
*.QBB QuickBooks Backup file format Backup files of .QBW file use the .QBB extension.
*.QBM QuickBooks Portable file It is a compressed version of QuickBooks company file. It is very useful while sharing because of its smaller size.
*.QBI QuickBooks Image file The *.QBI file contains transactions that have been written until they are posted to the hard drive
*.QBR QuickBooks Report template When you export the template for a memorized report, QuickBooks saves the file with a .QBR extension.
*.DES Layout designer template export file QuickBooks provides a variety of templates that you can use for your forms
*.QBO QuickBooks Online Bank Statement File This file type stores an electronic bank statement downloaded from a financial institution’s website.
*.INI Initialization File A config log file for QuickBooks.
*.LGB Little Green Box This file is related to SDK log files for QuickBooks that stores encrypted information about user credentials. It is utilized when an application needs to communicate and connect with QuickBooks (like QuickBooks Point of Sale) while it is unattended or closed. The user name and password stored in this file is utilized to connect with the Sybase server.
*.QWC QuickBooks Web Connector This file contains encrypted information about 3rd party applications integrated with QuickBooks
*.QBP QuickBooks Print file This file stores form settings used by QuickBooks to print the form.
*.WPR.INI Windows Print file This file stores QuickBooks printer settings

Accountant Files

File extension File type Description
*.AIF Accountant’s copy Import File This file gets created automatically when the Accountant’s copy is exported.
*.QBA QuickBooks Accountant copy working file File used for accountant’s review
*.QBA.TLG Transaction log file for the Accountant’s copy When you back up an accountant’s review copy, QuickBooks starts a log of transactions that you’ve entered since the last time you backed up. In case of accidental loss of data, Intuit Technical Support can use your most recent backup in conjunction with the transaction log file to recover your data
*.QBJ General Journal Entries The .QBJ file is used to incorporate general journal entries created by your accountant into your company file.
*.QBX Accountant’s review copy (export file) Backup made for Accountant’s copy of user’s company file. When Accountant restores this, it is an Accountant’s Copy of the file.
*.QBY Accountant’s copy import file. Your accountant provides you with a .QBY file to be imported into your company file when he or she is finished making changed in an Accountant’s copy.

Utility & Log Files

File extension File type Description
*.AVI Audio Video Interleave It is a multimedia format that stores both audio and video data in a file. This is used in QuickBooks for “Show Me” files
*.IIF Intuit Interchange Format May be created for importing lists and/or transactions.
*.ND Network Data File A configuration file that allows access to the QuickBooks company file.
*.RTP Used for auto-patch
*.TLG Transaction log file This file type tracks the changes to the file since the last backup.
*.WAV Windows sound format Sound Advice files (used in CD versions of QuickBooks)
*.Qbwin.log QB Windows log This log file gets created or updated id a user runs verify and/or rebuild. Logs problems found/situations corrected
*.QBBackup.tmp QB Back temp folders File created during failed online or scheduled backup with date and time stamp. Cannot be used to restore data.
*.Temp1234.qbt File created during pass 1 of rebuild, and deleted automatically when rebuild is completed.
*.QBSDK.log Logs for errors in QuickBooks and other services such as web connectors.
*.QWC.log QB Web Connector log Logs for Web Connector errors and process.
*.SyncManagerLogger.log  Sync Manager log Logs for Sync errors and activities.
*.ECML  Entitlement file Stores installation license, and registration data

Payroll Files

File extension Description
*.1PA Files used to create forms 940 and 941 (QuickBooks for Windows 4.0 through QuickBooks 2004)
*.TXT & *.SET This file is used in QuickPay version 2.0/2.1
Prddesvr.exe, Product.fam, Perwin95.ini, Perrval.dll These files are used for printing 940/941 forms.
Taxtbl.usa Integrated Payroll tax table file

QuickBooks Statement Writer

 

File extension File type
*.QSM QSW Statement file
*.QSS QSW Appearance file
*.QST QSW Template file

Fixed Asset Manager

File extension Description
*.Fx0 Compressed FAM data file. Stores asset data
*.Fx1 Stores system data
*.Mx0 Header file
*.FPx Stores report data
*.FXR FAM backup sync log file
*.FIM Stores CSV import data headers

Fixed Asset Manager (FAM) Data files comes with particular naming convention according to the version of QuickBooks:

  • QuickBooks 16.0 = F50
  • QuickBooks 17.0 = F60
  • QuickBooks 18.0 = F70

QuickBooks for Mac

File extension File Type/Description
*.QB2016 QuickBooks 2016 for Mac company data file
*.QBB Windows compatible QuickBooks for Mac backup file
*.QBMB QuickBooks for Mac disk backup file (QuickBooks for Mac 2012 and earlier)
*.DMG QuickBooks for Mac 2013 and later use the Apple disk image to create backups
*.plist Preference files that store registration and any preferences set within QuickBooks

QuickBooks Technical Support For Data Damage Issues

Hopefully, you find this article helpful and you should have complete information about the file extensions of QuickBooks. These files get automatically created when you install and activate QuickBooks on your system. If any of the file is having any kind of issue, renaming these files can help you in resolving the issue. You just need to add the word OLD at the end of the file name. Doing this will automatically create a new file of same extension and your issue may get resolved. Make sure that any of the file don’t get deleted from your system because it may cause permanent damage to your data. If you are facing issue with your company file, you can connect with the Intuit support department. For this, you just need to dial the toll-free QuickBooks Support Phone Number +1888-396-0208 to get instant support for your QuickBooks issues.