Import

Languages Deutsch

Finances supports importing data from CSV files. A CSV file is a comman-separated values file. Finances requires a date and amount column to successfully import a CSV file.

Finances read the following columns from a CSV file.

  • date (required) is the date and time of the transaction, e.g. 2017-03-08.

  • amount (required) is the amount of the transaction, e.g. -10.25.

  • category (optional) is the category of the transaction, e.g. Household. If not available, the transaction is assigned to an Uncategorized account. Learn more

  • account (optional) is the account of the transaction, e.g. Cash. If not available, the transaction is assigned to an Uncategorized account. Learn more

  • counter account (optional) is the counter account of transfer transactions, e.g. Checking. If not available, the transaction is either an income or expense transaction.

  • note (optional) is the description of the transaction, e.g. Buying food.

  • payee (optional) is the payee of the transaction, e.g. Walmart.

  • number (optional) is the transaction number, e.g. 201701.

  • currency (optional) is the currency of the transaction amount, e.g. USD. If not available, the default currency is used.

  • debit (optional) is the debit value of the transaction, e.g. 10.25. If available, the transaction is an expense transaction.

  • credit (optional) is the credit value of the transaction, e.g. 10.25. If available, the transaction is an income transaction.

For example the following CSV file

dateaccountcategoryamount
2017-03-08CashHousehold-5.60

will be imported as

2017-03-08
    Assets:Cash        -$5.60
    Expenses:Household  $5.60

Uncategorized transactions

If a CSV file doesn’t include the account or category of a transaction, then Finances will use the account Uncategorized. After importing data, you should assign uncategorized transactions to an income or expense account. Finances doesn’t do that automatically for you. But Finances for Mac makes that really easy. You can edit multiple transactions at once as described here.

Import Settings

Journal – Transactions can be imported into a new or existing journal. If you choose to import into a new journal, the journal will be named after the imported file.

Finances for Mac also lets you import data into a specific account. This is useful if you’re importing a CSV file which doesn’t include account information – like most CSV files from banks do. To do that you have to open a journal, right-click on an account and choose Import. Finances for Mac will then assign transactions without an account to the specified account.

Presets – When importing CSV files into Finances, you can choose from various presets. A preset defines the date format, text encoding, delimiter and column mapping. There are presets for different banks and apps. If you’re missing a preset for your CSV file, please get in touch.

How to Import?

Do the following steps to import data from a CSV file.

On macOS

  1. Choose File → Import…
  2. Select CSV and click Next
  3. Locate a file and click Choose
  4. Select a preset for your CSV file or configure the date format, text encoding and delimiter
  5. Click Import

On iOS

  1. Open the CSV file in iCloud Drive
  2. Tap and select Import with Finances
  3. Select a preset for your CSV file or configure the date format, text encoding and delimiter
  4. Tap Import

If you have problems importing data from a CSV file, please read the help.

Migrating from Finances 1

If you’re using Finances 1 and want to import the existing transaction into Finances 2, do the following steps.

  1. Export your data from Finances 1 as CSV.
    • Go to App Settings → Export → Export As CSV
  2. Import the data into Finances 2.
    • Open the CSV file in Finances 2
  3. Wait for the import to finish – this may take some time.
  4. Set up the initial account balances – the CSV file doesn’t include the initial account balances.
    1. Create new account called Opening Balances in the Equity group
    2. Create an opening transaction
  5. Update the colors for the Income and Expense accounts – the CSV file doesn’t include the category colors.