Upload CSV

You can import transactions in to Monarch using the CSV format. Many banks and other finance apps such as Mint, Personal Capital or YNAB allow you to export transactions in the CSV format. CSV import is only supported for banking and credit card transactions. Account balance history, investment transactions, budgets, or summarized cash flow can not be imported but many of them are derived from the underlying transactions when imported.

Once transactions are imported they are added to the cash flow reports and budgets just like transactions in a sync'd account. Account balances in manual accounts are calculated by the sum of all transactions in the account so importing transactions into a manual account will change the balance for that account. However sync'd account balances are not impacted by imported transactions since the balance is updated live from the bank and not derived from transactions.

There are two ways to import a CSV:

  1. Single Account - on each account page there is an option to "Upload a CSV" in the Summary section to the right of the transactions.
  2. Multiple Accounts - using the "add account" button similar to linking a new account at the top right of the accounts section.

Importing a Single Account

You can upload a CSV for a single account on the account details page using the edit button in the top right:

mceclip0.png

This same button has an option to Download a CSV which is a great way to see the format required to import a CSV. The CSV format for importing and exporting is 7 columns:

  1. Date
  2. Merchant
  3. Category
  4. Account
  5. Original Statement
  6. Notes
  7. Amount **

** Note that the format for Amount uses positive numbers to represent debits (not credits). This means that if you have a negative number it will show up as a credit (positive) number. Some CSV exports represent debits as negative numbers (ie -$100), others use parenthesis (ie ($100) ). Monarch uses just positive numbers (ie $100) to represent debits. 

Importing Multiple Accounts

If you have more than 1 account you would like to import or you are importing from Mint we recommend using the multi-account importer. It can be found in the "add account" screen:

mint-csv.gif

The format for the multi-account import is 9 columns (Mint field -> Monarch field)

  1. Date -> Date
  2. Description -> Merchant
  3. Original Description -> Original Statement
  4. Amount -> Amount
  5. Transaction Type -> ignored since amounts are used instead to determine credit/debit
  6. Category -> Category
  7. Account Name -> Used to map the multiple accounts
  8. Labels -> Tags
  9. Notes -> Notes

All 9 of these columns must be in the file even if they are blank for the import to be successful.

Importing from Mint

Monarch will import the default CSV file that Mint exports at the bottom of the transaction page shown in the screen shot below (export all 6702 transactions). There is no need to open or edit the Mint file once you download it before you import it into Monarch.

mint-export.png

If you are new to Monarch or just getting started, we recommend you import your Mint CSV first to set up your accounts in Monarch which will also walk you through syncing them after the CSV import. This also will make sure that you keep all your Mint history and then append new transactions after the import. You may notice that Mint account names are very generic - multiple credit cards may all have the same name "Credit Card" so it may be best to rename accounts in Mint before exporting the CSV so you can easily map them in Monarch.

Categories

All of the default Mint categories are mapped to a corresponding default category in Monarch. If you disabled a category or changed/created new categories in Mint they will either show up as Uncategorized (if importing as a single account) or with a generic white dot emoji (if importing multiple accounts):

mceclip0.png

Once the CSV file is processed you will be asked to map the accounts found in the CSV to a Monarch account. If you do not have your accounts setup in Monarch yet you may choose to add a new manual or sync'd account when importing or ignore an account from the CSV entirely:

mceclip1.png

 

Caution
It is not possible to undo a CSV import so it may be helpful to practice the import on a blank manual account first. You can however delete transactions that are imported (just not ones that are sync'd).

Was this article helpful?
4 out of 11 found this helpful