How do I import transactions from a QMTF, QFX, OFX, QIF, or CSV file?

To jump to the section about importing on your iPhone or iPad Click Here, otherwise you can continue on from here for the MacOS information.

If you are just getting started with Banktivity and want to begin by using the transactions you have stored in a file, create a new Banktivity ledger, choose the option to "Import from Other Software," and follow the prompts to choose the file you want to use to set up your accounts. If you have already set up your accounts in Banktivity and want to add some transactions from a file, choose File > Import Transactions, click "Import File," and select the file you want to import.

Assign column labels (CSV only)

If you choose a CSV file, Banktivity will prompt you to assign labels to each column of data contained in the file. Banktivity will now remember which columns you assigned based on the account that was selected when you went to File > Import Transactions:

Click and drag the edges of the window to make it large enough to see all the columns. Click the heading above each column and choose a label for the data contained in that column. Any columns that are not assigned a label will not be imported. Note that some CSV files use two columns for transaction amounts - in this case, be sure to assign the "Withdrawal" and "Deposit" labels appropriately. For CSV files that only use one column for transaction amounts, assign the "Amount" label to that column. Once you have assigned labels to all relevant columns, click "OK" to continue.

Banktivity can only import standard transactions from CSV files; split transactions cannot be imported from this file type. CSV files that use commas or semicolons as delimiters are accepted.

Clarify transaction dates (QIF/QMTF/CSV only)

If the file you are importing uses the QIF, QMTF, or CSV format, and the dates in the file are ambiguous, Banktivity will prompt you to choose the correct date format before proceeding.

Choose destination account(s)

If the import file only contains transactions from one account, you will be shown a popup menu button to let you choose which Banktivity account the transactions should be saved to. If the file contains more than one account, you will be shown a list of all the available accounts:

For each account shown in the list, click the popup button next to its name and choose which Banktivity account its transactions should be saved to. If you don't want to save transactions from a particular account, set its destination to "Do Not Import." Click "Continue" to proceed. Banktivity will import the transactions and save them in the account(s) you specified.

During the import, Banktivity will automatically screen out any duplicate transactions, mark all transactions "cleared" that were either imported or matched to incoming transactions, and apply import rules to clean and categorize the incoming transactions. It will also match transfers between accounts automatically, but you can disable this feature by choosing Banktivity > Settings and unchecking "Automatically match transfers between accounts."

A number will appear next to each account in the sidebar to show you how many transactions were imported. To review the results of the import, see Using the Resolve View.

Merge duplicate transactions

To merge transactions from two different sources (for example, combining an imported transaction with one that was posted from a scheduled transaction), simply drag and drop one transaction onto the other. The resulting merged transaction will contain the details of the latter transaction (onto which the former was dropped). To view the details of a transaction as they were originally imported prior to matching, import rule processing, and manual merging, double-click the transaction and click the 'i' button between the date and payee.

Set file associations (optional)

The Finder has the ability to associate certain types of files with specific applications. If you want Banktivity to automatically recognize the files you download from your bank's website (or bring in from another source), you can tell the Finder to associate them with Banktivity:

  1. In the Finder, select a QIF, OFX, QFX, QMTF, or CSV file and choose File > Get Info.
  2. In the window that appears, click the small disclosure triangle next to "Open With" to view the options in that section.
  3. Click the pop-up button and select Banktivity from the list to set it as the default application for that file.
  4. Click "Change All" to associate all files of that type with Banktivity.

From that point forward, any time you double-click a file with that type, it will automatically open Banktivity and begin an import.

After associating the file type using the steps above, you can set your web browser to automatically open files of that type after they are downloaded. This will allow you to download and begin importing new transactions into Banktivity with one click from your bank's website! Of course, this is not necessary if you use Banktivity's built-in web browser.

Importing files on iOS

Banktivity supports importing QIF, QFX, OFX, and CSV files on iOS as well.

If the file is accessible in the Files app, either on your device’s local filesystem or in iCloud Drive the Files app can send the file directly to Banktivity. You can also tap an import file in the Mail app and choose to open it with Banktivity.

Either Banktivity will activate immediately, or you can tap the Share button (the box with an upward arrow) to send the file to Banktivity. Which behavior occurs depends on whether other installed apps are registered to handle those file types. If Banktivity is the only app configured for that format, it will activate right away.

After the import file is sent, Banktivity activates in one of two ways:

  1. If an open ledger is active: Banktivity will prompt you to choose which account you want to import the data into.
  2. If Banktivity’s Organizer is active: You will see an alert notifying you that there are no open ledgers and offering you an option to create a new one or cancel.

If you choose a CSV file, Banktivity will prompt you to assign labels to each column of data contained in the file.