Skip to content
Toolspike

Bank statement to CSV

CSV is the format almost every accounting program, budgeting app and spreadsheet can read. Pick the column layout the program expects, and the converter writes the statement in that shape after checking every row against the running balance.

No sign-up to read and check a statement, and 5 pages a day download free with a free account. A PDF with text is read in your browser and not uploaded; scans and photos go to AI only if you choose.

5 statement pages free every day with a free account, and every row and the balance check to see first. A Statement Pass covers bigger jobs, paid once.

  • Stays on your deviceA PDF with text is read in this browser and never uploaded. A scan is sent to our AI provider only if you choose.
  • Checked against the balanceEvery row has to land on the running balance the bank printed, so a misread figure shows up before it reaches your books.
  • Nothing keptNo statement or download is stored on our servers, and a password only opens the file.

See it before you upload

From PDF lines to rows your books accept

The first rows of the made-up sample statement, as printed and as you download them. Press “Try a sample statement” above to open all of it.

What the statement prints

  1. 08/01POS PURCHASE BLUE DOOR COFFEE #12 SEATTLE WA5.45Withdrawals
  2. 08/02CHECK 10451,200.00Withdrawals
  3. 08/03ACH DEPOSIT NORTHWIND LLC PAYROLL2,500.00Deposits
  4. 08/05WIRELESS BILL AUTOPAY89.99Withdrawals
  5. 08/08POS PURCHASE BLUE DOOR COFFEE #12 SEATTLE WA6.10Withdrawals

What you download

  1. Blue Door Coffee SeattleRestaurants and takeaway−$5.45Aug 1
  2. Check 1045Uncategorized−$1,200.00Aug 2
  3. Northwind LLC PayrollPayroll and wages+$2,500.00Aug 3
  4. Wireless Bill AutopayPhone and internet−$89.99Aug 5
  5. Blue Door Coffee SeattleRestaurants and takeaway−$6.10Aug 8

Reconciled: every running balance matches

Opens in the software you use

  • QuickBooks OnlineQBO or CSV
  • QuickBooks DesktopQBO or IIF
  • XeroOFX or CSV
  • QuickenQFX
  • SageCSV
  • WaveCSV
  • FreeAgentCSV
  • MYOBOFX or QIF
  • Zoho BooksCSV, OFX or QIF
  • GnuCashOFX or QIF
  • Excel and Google SheetsXLSX or CSV
  • TallyXML

Product names belong to their owners; Toolspike is not connected with them. Each file is one that program’s own import reads.

Insights on every statement

Average daily balance
$7,103.26
Biggest spending category
Rent and mortgage, $2,000.00
Recurring payment found
Blue Door Coffee Seattle, weekly, about $5.45
Returned, NSF or overdraft rows
1

Figures from the made-up sample. Your own statements get the same panel, and the full lists in the Insights sheet of the Excel download.

Column layouts for each program

  • Debit and credit: date, value date, description, reference, debit, credit, balance
  • Signed amount: date, description, and one amount with money out as a minus
  • Full detail: the debit and credit columns plus a payee and a category
  • QuickBooks Online, Sage and Wave: date, description, amount, with each one’s date style
  • Xero: date, amount, payee, description, reference
  • FreeAgent: date, amount and description with no header row
  • QuickBooks Online with four columns: date, description, credit and debit
  • YNAB: date, payee, memo, outflow and inflow
  • Your own layout: the fields, their order, the separator and the decimal mark you choose
  • Descriptions starting with =, +, - or @ are made safe from formulas

Importing into Xero

Choose the Xero layout and download. In Xero, open the bank account, choose Manage account and then Import a statement, and pick the file. Xero reads the date and signed amount, and uses the payee and reference to help match rows with invoices and bills.

Which date format to pick

Programs read dates in the order they expect, and 03/04 means March in one and April in another. Pick the order your program uses before downloading; YYYY-MM-DD is the safest when you are not sure, because no program reads it the wrong way round.

Questions

Which layout should I choose?

Use the layout named after your program: QuickBooks Online, Xero, Sage, Wave, FreeAgent or YNAB. For spreadsheets, debit and credit columns or full detail with payee and category work best; most budgeting apps read one signed amount, and your own layout covers any other program.

Why do descriptions sometimes start with an apostrophe?

A cell that begins with =, +, - or @ is run as a formula when the file is opened in a spreadsheet. The apostrophe keeps such a description as plain text. Amounts are never changed this way.

Can I convert several statements into one CSV?

Yes. Add up to 12 statements and one CSV is made with every row, oldest first. A row printed in two overlapping statements appears once, so the file does not double count.

Does the CSV include the running balance?

The debit and credit layout and the full detail layout include the balance column as printed on the statement. The others leave it out, because the programs that use them work the balance out themselves; you can add it to your own layout.