Formatting a CSV File
File-Based Importing works best with a few standardized formats that are specifically for transferring financial data. If CSV is your only option, you will need to properly format the file before you can import your transactions.
In This Article
A fellow YNABer created this (unofficial) CSV converter which may help convert your CSV file from your bank into the format above. Check out these instructions to learn more. You're welcome to give it a try, though we aren't able to support it if it doesn't work for your bank's particular format.
Formatting in a Spreadsheet
The most reliable way to get your CSV file in the right format is to open it in a spreadsheet editor like Google Sheets, Excel, or Numbers. Once you've opened your CSV you'll want to edit the file so it looks like one of the two options below, where there's a column header for Date, Payee, Memo, and Amount(s).
Your spreadsheet editor may look slightly different from the screenshots above, but you can download and open this sample CSV to see exactly how a properly formatted file appears in your editor. Once you have your file in one of these configurations, save it back to CSV format (usually found in the File menu, under 'Save As' or 'Export').
Formatting in a Text Editor
If you don't have access to a spreadsheet editor, you can open your CSV file in a text editor and make the necessary changes.
In the example below, the first line is the header, the second line is an example outflow, and the last line is an example inflow.
Each 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 "Date,Payee,Memo,Outflow,Inflow" header line at the very top. Any field can be left blank except the date.
This format has one small variation—the amount is one field instead of two. Outflows are identified by a negative sign in the Amount field.
Once your transaction data is formatted correctly, you're ready to import the file!