Convert bank statements to Excel, with the balance checked

Turn PDF bank and credit card statements into clean .xlsx spreadsheets with real dates and numbers. Nothing is uploaded.

Try a sample statement first, nothing to upload and no pages used:

Sample data: the US checking sample from Summit National Bank. Try it with the US checking (PDF) button.

Balanced Opening $5,234.10 + transactions = closing $14,670.88, the closing balance on the statement.

Opening
$5,234.10
Money in
$12,978.51
Money out
$3,541.73
Closing (statement)
$14,670.88
Closing (computed)
$14,670.88
Difference
$0.00

Real Excel dates and numbers

RowBalance writes a native .xlsx workbook: dates are Excel dates, amounts are numbers, and money in, money out and running balance get separate columns. A second sheet lists the balance check for each statement, so the reconciliation goes into the file with the data.

Why not copy and paste?

Copying from a PDF splits rows, merges columns and drops minus signs. RowBalance reads the text positions on the page to rebuild the table, joins descriptions that wrap onto two lines, and confirms the result: opening balance plus every transaction must equal the closing balance.

How to do it

  1. Drop one or more PDF statements above.
  2. Check the balance badge. A green "Balanced" means opening + transactions = closing.
  3. Download Excel (.xlsx). It is free for up to 5 pages a day.

Excel and CSV are free for up to 5 pages a day, or 10 with a free account. QuickBooks, Xero and OFX files and batch conversion are on paid plans, from a $9 one-off pass: see pricing or go back to the converter.

Questions

Is it free to convert a bank statement to Excel?

Yes. The free plan converts up to 5 pages a day to Excel or CSV, with no signup. Paid plans add QuickBooks, Xero and OFX exports and batch conversion.

Does it work with scanned statements?

Not yet. RowBalance reads text-based PDFs, which is what online banking downloads normally are. Selectable text in your PDF viewer is needed, but some layouts are not read yet, so try one statement free first.

Which banks are supported?

Many text-based statements from US, UK and other banks. The parser does not use bank templates: it finds the date, description, amount and balance columns from the text positions on the page. Some layouts are not read yet or need corrections in the editor, so check the balance result and the rows before you import.

Related guides