File-Based Import

Looking for a way to import transactions that isn't Direct Import? Live outside the U.S. or Canada? File-Based Importing 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!)

Worried about duplicates?

If you enter transactions in the go and then want to import (which is great!), any duplicates will be matched automatically, nothing to worry about there!

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.

Still need help? Contact Us Contact Us