

If you are unable to open the file this way, it may be because you do not have the correct application associated with the extension to view or edit the CAT file. The best way to open an CAT file is to simply double-click it and let the default assoisated application open the file. If you are aware of any additional file formats that use the CAT extension, please let us know. CAT extension are known as Quicken IntelliCharge Categorization files, however other file types may also use this extension. The QBJ format requires account numbers to be activated in your Quickbooks chart of accounts.Have you found, downloaded or received an CAT file, but don't know which software program is required to open it?īefore attempting to open an CAT file, you'll need to determine what kind of file you are dealing with and whether it is even possible to open or view the file format.Īnswer: Files which are given the. Each line carries an account, optional or mandatory name (depending on the account), class, description, document number. There tools like CSV2QBJ that allow you to create a QBJ file from an Excel spreadsheet.Įach Quickbooks journal entry contains two or lines (debit and credit) that must balance within the entry. Normally, you would need the Accounting edition of Quickbooks to create such files (as an accountant or bookkeeper) and send them to your clients to import. The QBJ format is a new format for Quickbooks that allows import for general journal entries. As IIF is considered a "system-level" format where data are imported directly into Quickbooks data file.įor transactions, IIF format supplies the following details: Intuit developed the IIF format for its QuickBooks products and many software packages support export in this format for transactions, sale receipts, bills, invoices, and other data lists. Once transactions are imported under the Bank Feeds, Quickbooks does matching to vendor records and expense/income accounts. QBO files do not have Categories or expense/income account details. As banks do not have specific accounting details for their clients, the. QBO file have the following transaction details: QBO files have account details like account id, bank id, currency, ending balance, and date.

Quickbooks file extensions to import transactions are:īanks and credit card companies provide QBO files to download transactions. Depending on the source of transactions (online banking download, accounting service export, transfer data between two computers), a specific format should be used for a particular purpose. Quickbooks imports transactions in original formats. Use the Transactions app to convert your transaction files to required by your accounting software file format. Quickbooks File Extensions & Formats To Import Transactions.Quickbooks File Extensions & Formats To Import Transactions
