Bank statement converter with a lender summary
Upload a PDF statement from a US, UK, Canadian or Australian bank. You get every transaction as a table, checked against the balance printed on the statement, as an Excel or CSV file. The lender summary adds deposits per month, average and lowest balance, days below zero, recurring debits and returned or unpaid items. Free for 3 files a day; we don't keep your file, its text or the rows.
Convert a statement
We don't keep your file, its text or the rows. Text PDFs are read in your browser and only the text is sent on; scans are sent as page images. Where it goes
Example result
A made-up 3-page statement (Maple Street HVAC LLC, Lakeshore Community Bank). Upload yours above to replace it.
71 of 71 rows match the printed balance
Deposits and withdrawals per month
| Month | Deposits | Count | Withdrawals | End balance | Lowest |
|---|---|---|---|---|---|
| Aug 2026 | $7,445.55 | 3 | $5,204.69 | $4,081.08 | -$875.52 |
| Sep 2026 | $7,445.55 | 3 | $7,724.67 | $3,801.96 | $599.51 |
| Oct 2026 | $7,445.55 | 3 | $4,517.23 | $6,730.28 | $1,021.52 |
Partial months show only the days the statement covers.
Recurring debits
- ACH DEBIT FUNDBOX LOAN PMT6 times, twice a month · looks like a loan or finance payment$412.50
- RENT - OAKVIEW PROPERTIES3 times, monthly$2,150.00
- VERIZON WIRELESS6 times, twice a month$147.22
- ADP PAYROLL FEES3 times, monthly$89.00
- SHELL OIL 574423 times, about every 26 days$83.02
Returned or unpaid items
- RETURNED ITEM - CHECK 104310 Sept 2026-$860.00
- NSF RETURNED ITEM FEE10 Sept 2026-$35.00
Largest deposits
- STRIPE TRANSFER ST-8K2L5 Aug 2026$3,120.40
- STRIPE TRANSFER ST-8K2L5 Sept 2026$3,120.40
- STRIPE TRANSFER ST-8K2L5 Oct 2026$3,120.40
- STRIPE TRANSFER ST-9P1Q19 Aug 2026$2,875.15
- STRIPE TRANSFER ST-9P1Q19 Sept 2026$2,875.15
How the converter reads a statement
- Your browser opens the PDF. Statements downloaded from online banking have a text layer, so the page rebuilds each line with its columns and sends only that text. A scan or photo has no text, so each page is turned into a grey image instead.
- One AI call turns it into rows. Date, description, signed amount and the balance printed on each line, in the order they appear. Text goes to Claude Haiku; scanned pages go to Claude or Gemini, which read images.
- Code checks every row. Previous balance plus the amount must equal the printed balance. If only the opposite sign fits, the amount landed in the wrong column and is flipped; anything else is marked "check" in yellow so you can look at it.
- The summary and the files are made in your browser. The lender summary is plain arithmetic on those rows, and the Excel and CSV files are built on your device.
On our test statements (made-up US, UK and Australian layouts, text and scanned, 24 to 71 rows), every date, amount and balance came back right. Real statements have more variety, which is why the balance check is there.
What the lender summary counts
- Deposits per month
- The sum and count of money-in rows in each calendar month, next to withdrawals, the month-end balance and the month's lowest balance.
- Average daily balance
- The end-of-day balance for every calendar day of the statement, carried over days without transactions, then averaged.
- Lowest balance
- The lowest running balance after any transaction, with its date.
- Days below zero
- Calendar days that ended with a negative balance.
- Recurring debits
- The same payee debited for a similar amount (within 10%) on different dates: three times or more, or twice when the two are a month apart or look like a finance payment. Loan, lease, finance and cash-advance repayments are marked, so stacked loans stand out.
- Returned or unpaid items
- Rows whose description says returned, unpaid, NSF, insufficient funds, dishonoured, bounced or chargeback, plus the fees banks charge for them.
Figures are worked out from the statement only. They are not a credit decision or financial advice.
What happens to your file
- The PDF itself never leaves your device when it has text. Only the extracted text is sent. For a scan, page images are sent instead.
- Our server passes that text or those images to one AI model and returns the rows. It doesn't keep or log the file, the text, the images or the rows.
- The models run on paid API plans that don't use your data for training. Text goes to Anthropic's Claude API, which deletes it within 30 days. Scanned pages go to Claude or to Google's Gemini API, which keeps requests up to 55 days for abuse checks.
- To enforce 3 free files a day we store a one-way hash of your IP address and a count, deleted after two days.
- The converter doesn't need your account number, sort code or routing number. Redact them first if you like.
Statements arrive every week? We build the inbox-to-spreadsheet flow in your own accounts.
Clients email their statements; the system reads each one, adds the rows and this summary to your sheet or CRM, and flags returned or unpaid items and stacked loans for a person to review. It runs in your Google or Microsoft account and you own the code. A working version takes about a week, from $1,990.
Book a 30-minute call
57,291 raw companies turned into 14,620 qualified leads; 90% of replies matched to the right contact and sorted automatically; both apps on the client's own accounts in under 3 weeks.
Read the caseAlso on invoices: how AI invoice processing works and what it costs. Or see all case studies.
Questions people ask
How can I convert a PDF bank statement to Excel for free?
Upload the PDF at the top of this page and press Convert. You get every transaction with its date, description, amount and balance, and you download it as an Excel (.xlsx) or CSV file. It's free for 3 files a day, up to 10 pages each, with no sign-up.
How do I convert a scanned bank statement to Excel?
Save the scan or the phone photos as one PDF and upload it. When a PDF has no text layer, the page images go to an AI model that reads the table. Every row is then checked against the running balance printed on the statement, and rows that don't add up are marked so you can fix them before you use the file.
Can ChatGPT convert a PDF bank statement into Excel?
A chat assistant can read a statement and give you a table, but nothing checks the result, so a skipped or misread line looks the same as a correct one. Here every row is checked against the printed balance, the totals and the lender summary are worked out by code, and nothing is kept in a chat history.
Is it safe to upload bank statements online?
This converter doesn't keep your file, its text or the rows. Text PDFs are read in your browser and only the text goes to the AI model; scanned pages go as images. The AI providers' paid APIs don't train on this data and delete it after their abuse-check window (up to 30 days at Anthropic, 55 days at Google). We keep a hashed IP and a counter for the daily limit.
What should I black out on a bank statement before sharing it?
The account number, sort code or routing number, and any card numbers. The converter only needs dates, descriptions, amounts and balances, so removing those doesn't change the result. Use a real redaction tool in your PDF editor: a black box drawn on top can often be moved or copied around.
Why does a lender ask for bank statements?
A lender reads statements for what a profit and loss report smooths over, such as a month when deposits dropped, the days the account sat overdrawn, returned or unpaid items, and another lender already taking repayments. The lender summary on this page puts those figures in one place.
What are red flags on bank statements for a lender?
The ones the summary counts: returned or unpaid items (NSF and bounced payments), days spent below zero, a lowest balance that falls month after month, deposits that drop or swing a lot, and several loan or finance repayments running at once.
Which banks and statement formats does it work with?
Statements in English from US, UK, Canadian and Australian banks that show a date, a description, money in and out (or one signed amount column) and a running balance. We tested layouts with separate debit and credit columns, dates printed once per day, CR/DR markers and a 'D' for overdrawn. Card statements without a balance column convert too, but there is nothing to check the rows against.
Updated 21 Nov 2026 by Mark Shcherbakov.