Beta
Bank statement to Excel
Turn a PDF bank statement into rows you can review and export to Excel. Check whether the opening and closing balances tie out before you download.
A made-up example
These rows are invented to show the layout. They did not come from a real statement or a real conversion.
Opening balance: 1,200.00
| Description | Credits | Debits |
|---|---|---|
| Payment received | 450.00 | 0.00 |
| Supplies | 0.00 | 125.00 |
| Utilities | 0.00 | 80.00 |
| Refund received | 55.00 | 0.00 |
Closing balance: 1,500.00
Opening balance + credits - debits = calculated closing balance.
1,200.00 + 505.00 - 205.00 = 1,500.00. The balances tie out.
What it checks
- The balance equation: opening balance + credits - debits = calculated closing balance.
- Whether the calculated closing balance matches the closing balance you confirm from the PDF.
- Rows you can review and edit after choosing the statement’s date and amount mapping.
What it does not check
- Only unencrypted PDFs are supported. Text PDF mode skips scanned pages.
- AI-inferred balances stay unconfirmed until you check them against the PDF.
- No transaction is added or changed to force a balance match. Review every row and the balances yourself.
How it works
1. Choose how to read the PDF
Text PDFs are read on your device with no AI and no advanced action. Scanned pages are skipped in that mode.
2. Review conversion limits
Limits are shown before conversion. Only clicking Extract sends the PDF to the server. Formula Genius does not store the statement or account details. Each server conversion attempt uses an advanced action.
3. Review rows and balances
Choose the date and amount mapping, review and edit every row, check the balances against the PDF, then download to Excel.
Frequently asked questions
When does the PDF leave my device?
Only clicking Extract sends the PDF to the server. Formula Genius does not store the statement or account details. Each attempt uses an advanced action; the limits are shown before you convert.
Can I read a text PDF without AI?
Yes. Text PDFs are read on your device with no AI and no advanced action. Scanned pages are skipped in that mode.
Does a matching balance confirm every row?
Review every row against the PDF. No transaction is added or changed to force a match, and AI-inferred balances remain unconfirmed until you check them.
Can I use invoices or receipts?
PDF or image invoices and receipts can also be turned into a ledger.
Bring your statement into rows
Review the transactions and confirm the balances against your PDF before exporting.