How to convert a bank statement to CSV
Turn a spreadsheet, a Web Connect file, or a text PDF into a clean CSV.
- 1
Upload the statement you have
CSV, TSV, and Excel are read as tables. QBO, OFX, and QFX are read as OFX. QIF is read as QIF. A text PDF is read from the page. A scan is refused.
- 2
Map a spreadsheet
Set the date, the description, and the amount or the debit and credit columns. A second sheet in a workbook can be chosen. An OFX or QIF file already has those fields, so there is nothing to map.
- 3
Fix ambiguous dates before you download
If the page says the dates could be month/day or day/month, pick one order. The CSV then uses that reading. Leaving it on Auto keeps the guess, which is month-first when nothing in the column proves otherwise.
- 4
Download CSV
The clean file has Date, Description, Amount, Memo, Check Number, and Type. Amount is signed, in dollars, with money in positive. Open it in Excel or upload it to a bookkeeping tool that asked for CSV.
- Excel is the same rows in a workbook. Choose that download when you do not want to open a CSV and have the spreadsheet guess the dates again.
Questions
Does the CSV include the running balance?
The check uses the balance when the statement has one. The clean CSV is the transactions, not a second copy of the bank's balance column.