To import a bank statement into YNAB when Direct Import fails, download a CSV, OFX, QFX or QIF file from your bank and drag it anywhere onto YNAB. Check the account and fields in the Import Transactions window, then confirm. YNAB matches lines to ones you typed when amounts are equal and dates fall within ten days.
Which bank statement file to download for YNAB
YNAB reads four bank file types, and it prefers CSV. YNAB's guide to File-Based Import says CSV is the recommended format because YNAB checks the file after upload and adjusts its preview to fit. QFX and OFX are also accepted, often labelled Quicken or Money files at the bank, and so is QIF.
The options in the import window differ by type. The table summarises them from the same guide.
| File type | Fields YNAB lets you set | Extra options | Notes |
|---|---|---|---|
| CSV | Date, Payee, Memo, Outflow, Inflow, each from a dropdown | No header row; swap inflow and outflow; remember settings | Recommended by YNAB |
| OFX or QFX | Fixed by the file | Import memos; swap payee and memo; swap inflow and outflow | Several files can go in at once |
| QIF | Fixed by the file | Import memos; swap payee and memo; swap inflow and outflow | Older format |
Pick CSV if your bank offers it and the columns look sensible. Pick QFX or OFX if the CSV is messy, since those files carry their own field tags. Any other file, such as a PDF or a spreadsheet workbook, triggers an Invalid File warning.
The bank's direct link failing is a common reason to reach for a file at all. Quicken users face the same choice between a live connection and a downloaded file, set out in Quicken Web Connect versus Express Web Connect.
Dropping a statement file into YNAB step by step
A file import into YNAB takes a download and a drag. You fetch the file from online banking, open YNAB on a computer and drop the file anywhere in the app. The Import Transactions window then opens, and that window is where every choice is made.
The steps from YNAB's guide:
- Log in to online banking and look for a Download or Export option.
- Choose CSV, QFX, OFX or QIF and the dates you need.
- Open YNAB and drag the file onto it.
- In the Import Transactions window, check the account at the top.
- For a CSV, check each field mapping and fix any with its dropdown.
- Decide whether to include lines dated before the account's start date.
- Set the extra options if needed, then confirm.
The account check in step 4 is the one to slow down on. YNAB fills it in, and a file from savings can land in checking if the guess is wrong.
On an iPad, the guide describes a Split View method using the YNAB website in Safari, with QFX, QIF or OFX files.
How does YNAB match imported transactions to ones you typed?
YNAB matches an imported line to one you entered by hand when the amounts are exactly the same and the dates are within ten days of each other. YNAB's guide describes this rule, and it rewards the habit of typing purchases as you make them and importing the bank file later.
A worked example, with made-up figures:
| You typed | Bank file says | Result |
|---|---|---|
| March 3, Grocer, $54.20 | March 5, GROCER #118, $54.20 | Matched: same amount, two days apart |
| March 4, Fuel, $40.00 | March 16, FUEL STOP, $40.00 | Not matched: twelve days apart |
| March 8, Pharmacy, $18.75 | March 9, PHARMACY, $18.57 | Not matched: amounts differ |
The second and third rows become duplicates unless you fix them. Once the bank's line is in, delete your typed entry and keep the imported one, since re-importing the same file would only skip lines YNAB has already seen.
The guide also says payee names in the file are cleaned before they appear, and imported lines are auto-categorised from the payee's usual category. Both can be edited afterwards but cannot be switched off.
Why does YNAB skip or double transactions from a file import?
YNAB skips imported lines that have the exact same date and amount as transactions already imported, which stops most duplicates. Duplicates still appear when the dates in a new file differ from those already in the account. YNAB's guide also says it skips lines dated more than three days before the last reconciled transaction.
That second rule is the cure the guide recommends. Delete the duplicates, then reconcile the account. Future imports then ignore anything older than the reconciled point, which limits repeats from overlapping downloads.
A rule that catches people out: once you import transactions and then delete them, YNAB will not import those same transactions into that account again. A re-import shows them as skipped. The guide's fix is to enter them by hand or create a new account, move the history across and delete the old one.
A "No Transactions" warning has its own causes in the guide's FAQ. Every line may have been skipped, the file may hold no rows with both a date and a non-zero amount, or the bank's file may be malformed.
YNAB file imports with one amount column or year-old history
Two awkward files come up often in YNAB file imports. A CSV with one signed Amount column works if you select that same column for both Inflow and Outflow; YNAB reads positive and negative values from it. History older than a year is the other case, and YNAB's guide advises against importing that far back.
More edge cases from the guide's FAQ:
- Reversed signs. If money in shows as money out, tick Swap Inflow and Outflow.
- Header row missing. If column names appear as a transaction, tick No header row.
- Stray quotation marks. A "CSV File Error" can mean extra characters in the file. Download it again or remove them in a text editor.
- Zero-amount rows. The import no longer skips them, so delete padding or note rows first.
Date formats deserve a glance even though YNAB maps the fields for you. A file with day-first dates read as month-first could place lines in the wrong month, the same problem described for another product in the Xero CSV date error.
If you run a business on another platform alongside your YNAB budget, importing a bank statement into Odoo covers that system's file import.
SimpleBankConvert is aimed at QuickBooks and Xero users with PDF statements; it is not built for YNAB. If that is your setup, see how it works.