Bank Statement to Excel Converter: Turn a PDF Bank Statement into an Excel Spreadsheet

How to convert a bank statement to Excel

1. 1

   Download the statement PDF from your bank

   Sign in to online banking and download the statement period as a PDF. A downloaded PDF has a text layer; a scan or phone photo does not.

2. 2

   Upload the PDF to the converter

   Drop the PDF on the converter above or tap to choose it (up to 12 MB). You can also load a sample Chase, Barclays or Revolut statement to see the output first.

3. 3

   Review the preview and the balance check

   Every extracted transaction is listed with date, description, debit, credit and balance. The balance panel shows whether opening balance plus the transactions equals the closing balance printed on the statement.

4. 4

   Pick a layout and download Excel

   Choose Standard, QuickBooks or Xero columns, then click the Excel button to save an .xlsx workbook, or the CSV button for a CSV file.

PDF bank statement to Excel: what the workbook contains

The .xlsx file has two sheets. Transactions holds one row per transaction in the layout you picked. Statement records the bank name, currency, number of pages and the opening and closing balances found on the PDF, so the workbook carries its own audit trail.

Amounts are real numbers, not text, so SUM, filters and pivot tables work straight away. Dates are written in ISO format (YYYY-MM-DD), so there is no day/month mix-up between US and UK settings.

• Standard: Date, Description, Debit, Credit, Balance
• QuickBooks: Date, Description, Amount
• Xero: Date, Amount, Payee, Description, Reference

Bank statement PDF to Excel without retyping

Copying rows out of a PDF viewer usually merges columns or splits descriptions across lines, and retyping a month of transactions is slow and error-prone. The converter reads the statement's text, finds each dated transaction line, and separates money in, money out and the running balance.

It works on text-based PDFs downloaded from online banking. Scanned or photographed statements are flagged rather than guessed at.

Convert a PDF bank statement to Excel and prove it balances

Before you download, the opening balance plus every money-in row minus every money-out row is compared with the closing balance on the statement, within 0.02. If the numbers do not meet, the panel shows the difference so you can look for a missed row before the file goes into the books.

If the statement does not print an opening or closing balance, the check is marked incomplete instead of passing silently.

Convert a bank statement to Excel for QuickBooks or Xero

Pick the QuickBooks preset for Date, Description and a signed Amount (money in positive, money out negative), or the Xero preset for Date, Amount, Payee, Description and Reference. Both download as Excel or CSV.

QuickBooks and Xero presets are Excel column layouts, not .QBO or OFX files. Nothing is sent to QuickBooks or Xero for you; our QuickBooks and Xero import guides walk through the upload screens.

UK bank statements to Excel: GBP and UK dates

Barclays, HSBC and NatWest statements are recognised automatically, and their dates are read the way they are printed: written months such as "2 Aug", "02 Aug 24" or "24 AUG", and numeric dates day-first (DD/MM/YYYY or DD-MM-YY), so 02/08/2025 becomes 2 August, not 8 February. When a row has no year, the year comes from the statement period printed on the statement. Amounts printed with a £ sign are read correctly, the currency is shown as GBP in the preview, and "balance brought forward", "balance carried forward" and Barclays' "Start balance" and "End balance" are picked up as the opening and closing balances.

Revolut statements print dates like "1 Jun 2024". An amount with a minus sign is money out, and an unsigned amount takes its direction from the running balance. For other UK banks one date order is used for the whole statement: a date like 25/08/2025 proves day-first, and a statement with a £ sign, a sort code or a UK bank name is read day-first by default. A date that cannot exist, such as 31/02, is kept as printed and flagged so you can check it. Barclays, HSBC and NatWest print the date only on the first transaction of each day; the rows after it take that date, and a description that runs over several lines is read as one row.

A bank statement to Excel converter built for bookkeepers

BankSheet (getbanksheet.com) is for freelance bookkeepers and small firms who turn client statements into workpapers every month: the same columns for every client, a balance check on every file, and uploads that are not kept (retention is about 60 seconds).

The first 10 pages are free and need no account. After that, Starter is $29/month for about 200 pages and Pro is $79/month for 1,000 pages.

Frequently asked questions

More free bank statement tools

• Bank statement balance checker — Drop a bank CSV and see the exact row where the running balance stops adding up, plus likely missing or duplicate transactions.
• Bank CSV to QuickBooks & Xero format — Turn any bank CSV export into the QuickBooks Online 3- or 4-column layout or the Xero bank statement template, with dates and signs fixed.
• Duplicate transaction finder — Find duplicate transactions in a bank CSV, or merge overlapping exports and download one clean file without the double-counted rows.
• OFX to CSV converter — Open an OFX, QFX or QBO bank download as a CSV: dates, signed amounts, payee, memo, check number and FITID, ready for Excel.
• All free tools

Related guides

• Bank statement CSV formats (US & UK)
• PDF bank statement to CSV
• How BankSheet checks balances
• Import bank CSV to QuickBooks
• Import bank CSV to Xero
• BankSheet vs DocuClipper
• Pricing
• Privacy

Bank-specific pages

• Chase
• Bank of America
• Wells Fargo
• Citi
• Capital One
• American Express
• Barclays
• HSBC
• NatWest
• Revolut