Skip to content
Toolspike

Bank statement to Excel

Copying a statement out of a PDF by hand is slow, and pasting it usually leaves dates as text and amounts that will not add up. This converter reads the PDF, checks each row against the balance the bank printed, and gives you an Excel workbook you can sort, filter and total straight away.

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.

What the workbook contains

  • A Transactions sheet: date, value date, description, reference, debit, credit, balance, payee and category
  • Dates stored as dates and amounts as numbers, so formulas work
  • A filter on the header row
  • A Reconciliation sheet with the opening, total credits, total debits and closing
  • A Source sheet giving the page each row came from
  • An Insights sheet: money by category, recurring payments, returned items and the average daily balance
  • Indian lakh and crore grouping for rupee statements

Why the balance check matters

A converter that only copies text can drop a row that runs across a page break, or read 8,184.78 as a credit when it was a withdrawal. Here every row has to take the previous balance to the balance printed on that row. If one does not, it is marked in the table and in the Reconciliation sheet, so you know where to look before the numbers go anywhere.

Newest-first statements

Some banks list the latest transaction at the top. The converter notices this from the dates and turns the rows round, so the workbook always runs from the oldest transaction to the newest and the balance column reads in order.

Questions

Will the dates sort properly in Excel?

Yes. Dates are written as real Excel dates, shown as MM/DD/YYYY by default for US and Canadian dollar statements and DD/MM/YYYY for most others, so sorting, filters and date formulas work without any cleaning. You can pick another style, such as YYYY-MM-DD, before downloading.

Can I put a whole year of statements in one workbook?

Add up to 12 monthly statements at once and download a single workbook. Rows are merged oldest first, a transaction that appears in two overlapping statements is kept once, and each statement gets its own line on the Reconciliation sheet.

What if a row is wrong?

Choose the row in the table to see it outlined on the original page. You can correct the date, description or amounts, add a row that was missed, or delete one, and the balance check runs again straight away.

Does it work with scanned statements?

Yes. A scan or a photo has no text to read, so choose to read its pages with AI: each page counts as 2 pages, and the rows go through the same balance check. A statement downloaded from online banking as a PDF has text and is read in your browser instead.