Skip to the converter
StatementZap

Guides

How to convert a bank statement to CSV

Turn a spreadsheet, a Web Connect file, or a text PDF into a clean CSV.

  1. 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. 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. 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. 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.

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.