File extensions used in QuickBooks Desktop

Here are the lists of common file extensions you may confront as you use QuickBooks Desktop.

QuickBooks for Windows

  • QuickBooks Working Files

File Ext. File type Description
*.QBW QuickBooks Company file QBW format is associated with the Intuit QuickBooks software. It use QBW files to store the financial data, letters, logos, templates, and images for a company.
*.QBB QuickBooks Backup file format QBB files are the backup of QBW files that store a companies financial records, letters templates, logos, and images.
*.QBM QuickBooks Portable file The compressed version of QuickBooks company file. (*.QBM files) are ideal for sharing because of its smaller file size.
*.QBI QuickBooks Image file The *.QBI file ‘holds’ the transactions that have been written until they are posted to your hard drive
*.QBR QuickBooks Report template When you export a template for a memorized report, the QuickBooks will save the file with a .QBR extension.
*.DES Layout designer template export file QuickBooks provides a wide range of templates that you can use for your forms
*.QBO QuickBooks Online Bank Statement File This type of file contains an electronic bank statement that downloaded from a financial institution’s website.
*.INI Initialization File A configuration log file for QuickBooks.
*.LGB Little Green Box It is related to SDK log files for QuickBooks  that contains encrypted information about the user names & passwords. It is utilized when an application is need 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 Third party applications integrated with QuickBooks
*.QBP QuickBooks Print file This file stores form the settings used by QuickBooks to print the form.
*.WPR.INI Windows Print file This file stores the QuickBooks printer settings

 

  • Accountant Files

 

*.AIF Accountant’s copy Import File It is created when Accountant’s copy is exported that need to be used for importing into user’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 backup an accountant’s review copy, then QuickBooks starts a log of transactions that you’ve entered from the last time that you backed up. In case of accidental loss of data, Intuit Technical Support may use your most recent backup in the conjunction with the transaction log file to recover your data
*.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. One your accountant finished making changes in an Accountant’s Copy, then he or she will provide you with a .QBY file to be imported into your company file.

 

  • Utility & Log Files

 

*.AVI Audio Video Interleave A multimedia format contains both audio and video data in a file.
*.IIF Intuit Interchange Format Created for importing lists and/or transactions.
*.ND Network Data File A configuration file allows access to the QuickBooks company file.
*.RTP Used for auto-patch
*.TLG Transaction log file Keeps the track of changes to the file from the last backup.
*.WAV Windows sound format Are sound Advice files (used in CD versions of QuickBooks)
*.Qbwin.log QB Windows log File is created/updated when 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.
*.Temp1234.qbt File created during pass 1 of rebuild, and deleted automatically when rebuild is completed.
*.QBSDK.log Logs for errors in QuickBooks and the other services such as web connectors.
*.QWC.log QB Web Connector log Logs for Web Connector errors & process.
*.SyncManagerLogger.log Sync Manager log Logs for Sync errors & activities.
*.ECML Entitlement file

 

  • Payroll Files

 

*.1PA These files are used to create forms 940 & 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, Perrval.dll These files are used for printing 940 & 941 forms.
Taxtbl.usa Integrated Payroll tax table file

 

  • QuickBooks Statement Writer

 

*.QSM QSW Statement file
*.QSS QSW Appearance file
*.QST QSW Template file

 

  • Fixed Asset Manager

 

*.Fx0 Compressed FAM data file and store asset data
*.Fx1 Stores system data
*.Mx0 Header file
*.FPx Stores report data
*.FXR FAM backup sync the log file
*.FIM Stores CSV import the data headers

 

  • QuickBooks for Mac

 

*.QB2016 QuickBooks 2016 for Mac company data file
*.QB2015 QuickBooks 2015 for Mac company 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 & earlier)
*.DMG QuickBooks for Mac 2013 & later use the Apple disk image to create backups
*.plist Preference files that store registration and any preferences set within the QuickBooks

Move to QuickBooks hosting Start Free. No Credit Card Required

Kristin is a content strategist at Techarex Networks. Kristin follows the B2B technology space closely and loves to write on the latest changes in technology, futuretech and fixes for day to day how to issues. Besides writing Kristin also loves music, moves and skating.

Techarex Networks is a trusted cloud-based QuickBooks Hosting service provider of QuickBooks Pro, QuickBooks Premier, and QuickBooks Enterprise versions. Guaranteed 99.995% uptime and 24X7 free supports enable CPAs, accountants and business owners with anytime, anywhere, multi-device access capabilities.