QuickBooks Desktop File Extensions List (Detailed Guide)

Do you know what is file extensions? Every file extension has a unique name. Now we will discuss in detail how QuickBooks File Extensions are Used in QuickBooks Desktop Editions? In this article, you will get the answers to your all queries. Read the article to know the importance of file extension in QB and learn The QuickBooks file extension in detail for different sections in QB. Still, having a problem contact our QuickBooks ProAdvisor toll-free: +1-844-405-0904

The file extension is used for saving data and each file has its own importance in QuickBooks Desktop.

Different File Extensions for each file are used by different QuickBooks versions like QuickBooks 2016, QuickBooks Enterprise 2017, etc. Therefore, each file type has its own importance to save the data.

QuickBooks Files and Extensions

Importance of File Extensions used in QuickBooks Desktop:

  • It allows the users to quickly identify the nature of a file’s contents.
  • File extension-making searches easy.
  • File extension provides a simple method of keeping all files of the same type together.
  • By file extensions, easy to identify kind of a file a certain is just looking at the file name.
  • Help to identify the type of file.
  • Maintain the security of the file.

■ QuickBooks Extensions for Windows

⇒ QuickBooks Working Files

File ExtensionFile TypesDescription
*.QBWQuickBooks Company filesThe QBW format is associated with the Intuit QuickBooks application. It uses QBW files to store financial information, templates, letters, logos, and images for a company.
*.QBBQuickBooks Backup file formatQBB files are backups of QBW files that save a company financial information like templates, logos, letters, images, etc.
*.QBMQuickBooks Portable fileA compressed version of the QuickBooks company file *.QBM files are ideal for sharing because of the smaller file size.
*.QBIQuickBooks Image fileThe *.QBI file use for transactions that have been written until they are posted to the hard drive
*.QBRQuickBooks Report templateWhen you export the template for a memorized file, QuickBooks saves the file with a.QBR extension.
*.DESLayout designer template export fileQuickBooks provides a variety of templates in which you can use your forms
*.QBOQuickBooks Online Bank Statement FileThis file is used for an electronic bank statement downloaded from a financial institution’s website.
*.INIInitialization fileA config log file for QuickBooks
*.LGBLittle Green BoxRelated to SDK log files for QuickBooks that contain encrypted information about usernames and passwords. It is utilized when an software needs with QuickBooks while it is unattended or closed. The username and password save in this file are utilized to connect with the Sybase server.
*.QWCQuickBooks Web ConnectorQWC file carry encrypted contain about the 3rd party app integrated with QB
*.QBPQuickBooks Print fileThis file stores form settings used by QuickBooks to print the form
*.WPR.INIWindows Print FileThis file store the QuickBooks Printer setting

⇒ Accounting Files

File ExtensionFile TypesDescription
*.AIFAccountant’s Copy import fileThis file is generated when an Accountant’s copy is exported, to be used for importing into a client’s company file
*.QBAQuickBooks Accountant copy working fileFile used for accountant’s review
*.QBA.TLGTransaction log file for the Accountant’s copyWhen you back up an accountant’s review copy, QuickBooks starts a logoff transaction that you’ve entered since the last time you backed up. If you accidentally lose of your company data, the Intuit Technical support team can use your latest backup in conjunction with the transaction log file to recover your data.
*.QBJGeneral Journal EntriesThe .QBJ file can be used to easily incorporate general journal entries created by your accountant into your company file.
*.QBXAccountant’s review copyBackup made for an accountant’s copy of the user’s company file. When an accountant restores this, it is an Accountant’s copy of the file
*.QBYAccountant’s Copy import fileWhen your accountant is finished making changes in an accountant’s copy, he or she provides you with an imported.QB file to your company file.

⇒ Utility and Log File

Logs problems found/situations corrected

File extensionFile typeDescription
*.AVIAudio Video InterleaveA format that contains both audio and video data in a file is called a multimedia file. This is used in QuickBooks for “Show Me” files.
*.IIFIntuit Interchange FormatIt may be created for importing lists and transactions.
*.NDNetwork Data FileA configuration file that allows access to the QuickBooks company file.
*.RTP Used for the auto-patch
*.TLGTransaction log fileKeeps track of changes to the file since the last backup
*.WAVWindows sound formatSound Advice files(used in the CD version of QuickBooks)
*.Qbwin.logQB Windows logA File is created/updated when a user runs verify and rebuild.
*.QB backup.tmpQB Back temp foldersFile created during failed online or scheduled the backup with date and time stamp. Unable to use to restore data.
*.Temp1234.qbt In this File Extensions, a file is generated through pass 1 of a rebuild and deleted automatically when rebuild is done.
*.QBSDK.log This file extension is a use of logs for errors in QuickBooks and other services such as web connectors.
*.QWC.logQB Web connector logThis file extension is used for Logs for Web connector errors and process.
*.SyncManagerLogger.logSync Manager logLogs for Web Connectors errors and process.
*.ECMLEntitlement fileStores installation license, and registration data
qbstbl2.usaUS Tax Table FileIf you use payroll in the QuickBooks Desktop then you’ll need this file so that you can get the latest current tax table. This file contains the latest payroll tax information that will help you in calculating your payroll taxes.
LOGEvent Log FileThere is some important files that QuickBooks stores in the files with the .log extension.
There is two types of files with the .log extension.
1. QBwin.log – It records the issues that are found during the rebuild process.
2. QWC.log – It record the Web Connect Errors.
With the help of the log files, you can troubleshoot these errors.

⇒ Payroll Files(applies to the US only)

File extensionDescription
*.1PAFiles used to create forms 940 and 941(QuickBooks for Windows 4.0 through QuickBooks 2004)
*.TXT & *.SETUsed in QuickPay version 2.0/2.1
Prddesvr.exe, Product.fam, Perwin95.ini, Perval.dllThese files are used for printing 940/941 forms.
Taxbl.usaIntegrated Payroll tax table file

⇒ QuickBooks Statement Writer

File ExtensionFile TypeDescription
*.QSMQSW Statement fileQuickBooks save the information if you use QuickBooks Statement Writer in a file with the .QSM file extensions. These QSM files can also be used in the Excel.
*.QSSQSW Appearance fileThe files with the .qss file extensions contain the information of the statements and reports that are customized using the QuickBooks Statement Writer. These settings will be saved in the QSS files. You can also apply these settings to other reports using the QSS file.
*.QSTQSW Template fileThe files with .qst file extensions are the template files. These template files are already available in QuickBook if you want to use any specific layout.

⇒ Fixed Asset Manager(applies to the US only)

File ExtensionDescription
*.Fx0Compressed FAM data file. Stores asset data
*.Fx1Stores system data
*.Mx0Header file
*.FPxStores report data
*.FXRFAM backup sync log file
*.FIMStores CSV import data headers

Note: QuickBooks will vary based on the version. Example: QuickBooks 14.0=F30

The QuickBooks Fixed Asset Manager has a particular naming convention followed by each version of QuickBooks:

⇨ QuickBooks 14.0=F30

⇨ QuickBooks 15.0=F40

⇨ QuickBooks 16.0=F50

■ QuickBooks Extensions for Mac(applies to the US only)

File ExtensionFile TypeDescription
*.QB2016Company FileQuickBooks 2016 for Mac company file data file
*.QB2015Company FileQuickBooks 2015 for Mac company file data file
*.QB2014Company FileQuickBooks 2014 for Mac company data file
*.QBBBackup FileWindows-compatible QuickBooks for Mac backup file
*.QBMBBackup FileQuickBooks for Mac disk backup file(QuickBooks for Mac 2012 and earlier)
*.DMGApple Disk image fileIn QuickBooks Mac 2013 and later use the Apple disk image to create backups
*.plistApple Property list filePreference files that store registration and any preferences set within QuickBooks

Wrapping Up!

We hope you found this article useful. Furthermore information about it, you can dial our helpline QuickBooks Support Phone Number+1-844-405-0904 to get instant help with the best service.

Call Now