As a QuickBooks accounting software user for your small and medium-sized business, you will come across different types of files and their extensions. Sometimes you would want to know the details and usages of all these file types and their extensions used by QuickBooks software. So, through this article, we would try to satiate your curiosity on this topic.
List of Common QuickBooks Files
|File Types||Extension||When are These Extensions Created?|
|QuickBooks company file||QBW||This extension is created when you create a company file for your business in QuickBooks software.|
|QuickBooks Back up file||QBB||Whenever you create the backup for your company file, it will be created with the Extension (.QBB).|
|Portable QuickBooks file||QBM||For emailing or moving purposes a compressed version of the company file is created with the extension (.QBM).|
|Bank statement QuickBooks File||QBO||The transactions file that you download from your online banking website, will be downloaded with the extension (.QBO).|
QuickBooks Additional Files & Accountant Files etc.
|File Types||Extension||When are these Extensions Created?|
|Layout Designer template file||DES||This extension is created when the customized form template is exported for using in the company file and sharing with others.|
|Report Template files for QuickBooks||QBR||The extension is created by QuickBooks when a memorized template is exported for sharing within company files or others.|
|Web connector file for QuickBooks||QWC||The web connector file is used for opening other apps, when a web connector file is created by a third-party app, it is created with a QWC extension.|
|Review copy or transfer file||QBX||The backup of the company file created specifically for sharing with your accountant is created with the extension QBX.|
|Accountant’s copy file||QBA||when a QBX file is opened by the accountant and sent for review, QuickBooks creates it with the extension QBA.|
|Accountant’s copy import file||QBY||Once the accountant reviews the company file, they send it back to the client for applying the changes, this file is created with the extension QBY.|
|General journal entries files||QBJ||When your accountant sends you the General journal entries file, it is created and sent with the extension QBJ.|
Which Database is used by the QuickBooks Desktop?
An industry-standard SQL database is used by QuickBooks enterprise, which is a relational database that uses client-server technology in multi-user mode to coordinate and manage access to the company file.
What is the Process of Connecting the Database in QuickBooks?
You need to click on connections or add new connections > and switch to the machine data source tab and choose QuickBooks data DSN and click on OK.
How can I Retrieve the Data from QuickBooks?
First of all, open the company file saved in the QB test folder, use your account register to verify the transactions, click on files > utilities and verify data for checking the integrity of the retrieved file.
How can I Export the Class List from QBDT to Excel?
Click on Reports > Account list > click on export icon and then click on export to excel.