Convert a PDF bank statement to Excel
Turn a bank statement PDF into a clean Excel workbook: real dates, real numbers, one row per transaction, and a summary sheet that proves the totals match the statement.
Several statements? Combine monthly PDFs into one workbook.
Kit Rx keeps no copy of your file. Anthropic, the AI provider that reads it, receives the PDF and may keep API inputs for a limited period under its own policy. How your file is handled.
Why not copy and paste?
Copying from a PDF breaks columns apart, merges descriptions, and turns numbers into text. Templates built for one bank break when the layout changes. The converter reads each page the way a person would, then checks its own work against the statement's balances.
What the Excel file contains
A Transactions sheet (date, description, amount, money in, money out, running balance, page, and a check column) with filters and a frozen header, and a Summary sheet with formulas for money in, money out, net change, expected closing balance, and the difference from the printed closing balance.
Questions
Will Excel see real dates and numbers?
Yes. Dates are stored as Excel dates and amounts as numbers, so sorting, filtering, SUM, and pivot tables work straight away. There is no Text to Columns step.
Can I fix a row before downloading?
Yes. Click any cell in the results table to correct it. The balance check reruns as you edit, and the download includes your changes.
Does the workbook use macros?
No. The summary sheet uses ordinary formulas (SUMIF, IF, ROUND, COUNTA), so it opens in Excel, Numbers, LibreOffice, and Google Sheets.
Is my statement stored?
Not by Kit Rx. Your PDF is held in memory only while it is being read and is dropped when the request finishes; we never write the file, its text, or your transactions to a database, file storage, or logs. To read it, the PDF is sent to our AI provider, Anthropic, which may keep API inputs for a limited period under its own policy. Details are on the privacy page.
Statements from popular banks
- Chase
- Chase credit card
- Bank of America
- Bank of America credit card
- Wells Fargo
- Wells Fargo credit card
- Capital One
- Capital One credit card
- American Express
- U.S. Bank
- Citi
- Citi credit card
- Discover
- Discover credit card
- PNC
- Truist
- TD Bank
- Navy Federal
- USAA
- Ally
- Regions
- M&T
- Synchrony
- Barclays
- SoFi
- Mercury
- Citizens
- Fifth Third
- Huntington
- KeyBank
- Schwab
- Apple Card
- PayPal
- Chime
- Bluevine
- Novo
- Relay
- BECU
- Santander Bank
- Varo Bank
- Axos Bank
- Credit One Bank
- Ramp