Do you know what is file extensions?
The file extension is used for saving data and each file has own importance in QuickBooks Desktop.
Every file extension has the unique name. Now we will discuss in details about how QuickBooks File Extensions are Used in QuickBooks Desktop Editions?
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.
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 file.
■ QuickBooks Extensions for Windows
⇒ QuickBooks Working Files
|File Extension||File Types||Description|
|*.QBW||QuickBooks Company files||The 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.|
|*.QBB||QuickBooks Backup file format||QBB files are backups of QBW files which save a company financial information like as templates, logos, letters, images etc.|
|*.QBM||QuickBooks Portable file||Compressed version of the QuickBooks company file *.QBM files are ideal for sharing because of the smaller file size.|
|*.QBI||QuickBooks Image file||The *.QBI file use for 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 file, QuickBooks saves the file with a.QBR extension.|
|*.DES||Layout designer template export file||QuickBooks provides a variety of templates in which you can use your forms|
|*.QBO||QuickBooks Online Bank Statement File||This file is used for an electronic bank statement downloaded from a financial institution’s website.|
|*.INI||Initialization file||A config log file for QuickBooks|
|*.LGB||Little Green Box||Related to SDK log files for QuickBooks that contains 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.|
|*.QWC||QuickBooks Web Connector||QWC file carry encrypted contain about the 3rd party app integrated with QB|
|*.QBP||QuickBooks Print file||This file stores form settings used by QuickBooks to print the form|
|*.WPR.INI||Windows Print File||This file store QuickBooks Printer setting|
⇒ Accounting Files
|File Extension||File Types||Description|
|*.AIF||Accountant’s copy import file||This file generated when an Accountant’s copy is exported, to be used for importing into a client’s company file|
|*.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 logoff transaction that you’ve entered since the last time you backed up. If you accidental loss 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.|
|*.QBJ||General Journal Entries||The .QBJ file can be used to easily incorporate general journal entries created by your accountant into your company file.|
|*.QBX||Accountant’s review copy||Backup made for an accountant’s copy if the user’s company file. When accountant restores this, it is an Accountant’s copy of the file|
|*.QBY||Accountant’s copy import file||When your accountant is finished making changes in an accountant’s copy, he or she provides you with an imported.QBY file to your company file.|
⇒ Utility and Log Files
Logs problems found/situations corrected
|File extension||File type||Description|
|*.AVI||Audio Video Interleave||A 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.|
|*.IIF||Intuit Interchange Format||May be created for importing lists and transactions.|
|*.ND||Network Data File||A configuration file that allows access to the QuickBooks company file.|
|*.RTP||Used for the auto-patch|
|*.TLG||Transaction log file||Keeps track of changes to the file since the last backup|
|*.WAV||Windows sound format||Sound Advice files(used in the CD version of QuickBooks)|
|*.Qbwin.log||QB Windows log||A File is created/updated when a user runs verify and rebuild.|
|*.QB backup.tmp||QB Back temp folders||File 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.log||QB Web connector log||This file extension is used for Logs for Web connector errors and process.|
|*.SyncManagerLogger.log||Sync Manager log||Logs for Web Connectors errors and process.|
|*.ECML||Entitlement file||Stores installation license, and registration data|
⇒ Payroll Files(applies to the US only)
|*.1PA||Files used to create forms 940 and 941(QuickBooks for Windows 4.0 through QuickBooks 2004)|
|*.TXT & *.SET||Used in QuickPay version 2.0/2.1|
|Prddesvr.exe, Product.fam, Perwin95.ini, Perval.dll||These files are used for printing 940/941 forms.|
|Taxbl.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(applies to the US only)
|*.Fx0||Compressed FAM data file. Stores asset data|
|*.Fx1||Stores system data|
|*.FPx||Stores report data|
|*.FXR||FAM backup sync log file|
|*.FIM||Stores 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 Extension||File Type/Description|
|*.QB2016||QuickBooks 2016 for Mac company file data file|
|*.QB2015||QuickBooks 2015 for Mac company file data file|
|*.QB2014||QuickBooks 2014 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||In QuickBooks Mac 2013 and later use the Apple disk image to create backups|
|*.plist||Preference files that store registration and any preferences set within QuickBooks|
I hope you found this article useful. Furthermore information about it, you can dial our helpline QuickBooks Support Phone Number +1-855-441-4417 to get instant help with best service.
- QuickBooks Desktop Security Updates & Information
- Configure Firewall & Internet Security of the QuickBooks Desktop
- QuickBooks Desktop 2018 – What’s New & Improved Features in it