File-Based Import
Looking for a way to import transactions that isn't Direct Import? Live outside the U.S. or Canada? Try File-Based Importing in the web app!
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 (only if the above formats aren't available)
Worried about duplicates?
If you enter transactions on the go and then want to import (which is great!), any duplicates will be matched automatically, nothing to worry about there!
Starting Your Import
After logging in to your online banking account, look for the option to download or export transactions. Once you have your file (or files—you can import multiple at once!), you're ready to start the import process in one of three ways:
- Drag and drop your file or files onto YNAB. Anywhere in YNAB—like magic!
- Click the Import button in All Accounts.
- Click the Import button in any unlinked account.
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.
If your bank sends transactions with dates formatted in such a way that causes them to appear off by one day when imported into YNAB, the Adjust to local time option will convert the transaction dates to your local timezone. You’ll be able to see a preview of the effect on the transactions prior to importing when selecting this option, so you can see if it will help fix this “off-by-a-day” annoyance.