Make bank and credit transactions files compatible with your accounting software with the Transactions app

Need to import bank or credit card transactions in a CSV/XLS/XLSX/TXT, PDF, QFX, OFX, QBO, QIF/QMTF, MT940/STA file into your accounting or personal finance software but cannot seem to make it work?

The Solution: try the Transactions app. It can convert your transactions into a format that your accounting/personal finance software can import.

Import Into QuickBooks

For QuickBooks desktop, convert to QBO (web connect) format or IIF format if you have QuickBooks Desktop 2018-2021, QuickBooks Enterprise 18-21, QuickBooks Desktop for Mac 2018-2021 or QuickBooks online.

For older QuickBooks versions, convert to the IIF format.

QBO (web connect) transaction files are imported the same way as transactions downloaded directly from your bank. After import, open imported statement under Bank Feeds, match vendor records and assign expense/income accounts and add transactions to the register.

IIF transaction files are imported directly into the register and require exact vendor names and expense/income accounts. The Transactions app provides interface to map payee names to vendor names and assign categories (expense/income accounts) based on payee names or direct edit.

Import into Quicken

For Quicken for Windows, convert to the QIF or QFX format if you have Quicken 2018-2021.

For Quicken for Mac, convert to the QFX format is you have Quicken 2018-2021.

For older Quicken for Windows versions, convert to the QIF format.

For older Quicken for mac versions, convert to the CSV Mint format.

QIF transaction files are easily imported by Quicken (please make sure to your QIF target accordingly) and allow to supply categories and tags for each transaction. The Transactions app provide easy to use mapping interface to assign categories based on payee names or manually during the conversion.

For QFX transactions, Quicken uses the renaming rules to assign categories during import.

Import into Other Desktop Accounting or Personal Finance software (Microsoft Money and others)

Your accounting or personal finance software (like Banktivity, MYOB, Sage 50, Sage 300, NetSuite) should import transactions using one of the following files formats: CSV, OFX/QFX/QBOO, QIF. The Transactions app converts to all these listed formats.

For example, MS Money imports QIF and OFX (and QFX and QBO).

Import into Online Accounting Software (Xero, FreeAgent, Sage, others)

Online accounting services like Xero, FreeAgent, LessAccounting, MYOB, Wave, and others, usually imports OFX or QFX or QBO files and optionally CSV files. Search your accounting software documentation for things like "how to import a bank statement in [Xero, FreeAgent, etc]" to confirm which file format these services import.

review qbo transactions imported in quickbooks
imported qif file in quicken successfully
review qfx transactions imported in quicken
review qfx transactions imported in quicken mac
review ofx transactions imported in xero
review iif transactions imported in quickbooks
imported csv file in excel successfully