File-based Importing

Looking for a way to import transactions that isn’t Direct Import? Live outside the U.S. or Canada? File-based Importing is here, and it is just for you.

File Formats

If Direct Import isn’t available for your financial institution, or you simply prefer to import bank files yourself, YNAB’s File-based Importing feature makes that easy. You can import these file formats into YNAB:

  • QFX and OFX (recommended)
  • QIF
  • CSV (last resort!)

Starting Your Import

In order to import transactions in these files, you’ve got to go to your bank’s website and get the file first. Once you have your file (or files, you can import multiple files at once!), you can start the import process in one of three ways:

  • Click the Import button in any account that does not have Direct Import enabled.
  • Click the Import button in “All Accounts”
  • Or, drag and drop your file or files onto YNAB. Anywhere onto YNAB – like magic!

Customizing

Once you’ve done this, you’re just steps away. You’ve now got a few options and settings to make sure your transactions are coming in just the way you want them.

  1. Select the account you want the transactions imported into.
  2. If your file includes transactions dated before your account start date, you’ll see an option to include or exclude those.
  3. Check the box to import the memo field with your transactions, or …
  4. If your bank tends to put the payee in the memo field, check the Swap with Payees box to reverse those fields.

If you’re importing multiple files at once, you will be shown this set of options for each file. For each, adjust your settings, and choose to either Skip that file, or save the settings for that file and move onto the next.