YNAB can import any of the file formats listed below. For a more details on each of the formats listed please check out our Importing Overview page.
CSV is the file of last resort. It's the only one that lacks an industry standard to go by and as such each bank formats them differently. If at all possible see if your bank can provide you with a different format with which to import.
In order to import a CSV file into YNAB it must follow a specific structure. The 3 line example below outlines exactly how a file might look if it contained only 2 transactions.
01/25/12,Sample Payee,,Sample Memo for an outflow,100.00,
01/26/12,Sample Payee 2,,Sample memo for an inflow,,500.00
To format your file the way YNAB requires, open it in a text editor and make your transactions look like the sample ones above.
You'll notice every field is separated by a comma so it's important that every field is present in each line, even if your transactions don't fill every field. Always include the "Date,Payee,Category,Memo,Outflow,Inflow" line at the very top as it is required.
Any field can be left blank except the date. Valid date formats:
Categories will only import if the category already exists in your budget file with the exact same name. Otherwise the categories will be ignored when importing the file. Also, make sure that the categories are listed with the master category, followed by a colon, then the sub category. For example Everyday Expenses: Groceries
Custom YNAB specific tool → http://halloffame.github.io/ynab-csv/
Instructions on how to use it → https://github.com/halloffame/ynab-csv/blob/gh-pages/README.md
Generic CSV conversion → http://csvconverter.gginternational.net/
Windows - CSVed - Cardware
Mac - XTabulator - $19.99 USD