How to Import a Bank CSV into YNAB
File-Based Import lets you add transactions to YNAB without linking the account. CSV is YNAB's recommended file type.
Steps
- Make sure the CSV has a header row with columns YNAB can match: Date, Payee, Memo, Outflow and Inflow (or a single signed amount).
- Open YNAB in a web browser or on an iPad. File-Based Import isn't available on phones.
- Drag the CSV anywhere into YNAB. The Import Transactions window opens.
- Check the account at the top and confirm each column is matched to the right field. Fix any match with the dropdown.
- Set the options if needed (No header row, Swap Inflow and Outflow, Remember setting for this account), then import.
Good to know
- If the file has transactions dated before the account's start date, YNAB lets you include or exclude them.
- Categories and split transactions can't be imported from a file. Assign categories after importing.
- RowSmith's free Ynab layout uses Date, Payee, Memo, Outflow and Inflow with MM/DD/YYYY dates. RowSmith is not affiliated with YNAB.
Starting from a PDF statement?
Converts text-based PDF bank statements to CSV or Excel in your browser. Your file is never uploaded. Always review the output before using it. Scanned PDFs aren't supported. Convert a statement PDF
Questions
Why are my inflows showing as outflows?
Some files, especially credit card ones, use the opposite sign. Check Swap Inflow and Outflow in the import window.
Will importing create duplicates of transactions I typed in?
YNAB tries to match imported transactions with ones you entered by hand. Review the matches before approving.
RowSmith is an independent tool and is not affiliated with any bank or software company named on this page.
Converting is free. RowSmith Pro ($9/month or $59/year) adds suggested Schedule C categories, saved cleanup rules and monthly category totals.