LedgerRowsBank statement to Excel
Turn a PDF bank statement into an Excel sheet, checked against its own balances.
No sign-up to try · PDFs never stored
How to convert a bank statement to Excel
- 1
Upload the PDF statement
Drop in a statement downloaded from your bank's website: checking, savings or credit card. Cover, disclaimer and ad pages are skipped and never billed.
- 2
Check the balance
LedgerRows adds every transaction to the opening balance and compares the total with the closing balance on the statement. You see Balanced, or the row that doesn't add up.
- 3
Download the .xlsx
Open it in Excel, Google Sheets or Numbers: one sheet per account, with Date, Description, Amount and Balance columns.
A spreadsheet that opens right
Dates are dates
Real date cells, so sorting and filtering work, and no computer swaps the day and the month.
Amounts are numbers
Money in is positive and money out negative, with two decimals, ready for SUM and pivot tables. Card purchases come out negative too.
Descriptions stay intact
Long reference numbers stay text, so leading zeros survive and nothing turns into 6.1E+11.
Many statements at once
Convert up to 20 statements in one go, then tick them in your history and export them together.
Why the balance check matters
Any converter can misread a row: a line lost at a page break, a withdrawal read as a deposit, a 6 read as an 8. Nothing looks wrong until the books won't reconcile.
Opening + transactions = closing
Every statement prints its own opening and closing balances. If the rows don't add up to them, you're told before you export, not after you import.
The row, not just a warning
Where the statement prints a running balance, each row is checked against it, so a mismatch points at the line that caused it. Fix the cell right in the table.
Doesn't balance, isn't billed
A statement that fails the check costs nothing. If a balanced file still has a mistake, report it and the pages come back.
Questions
Can I convert a credit card statement to Excel?
Yes, the same way. Amounts are from your side of the card: purchases are negative and payments positive.
Should I pick Excel or CSV?
Excel if you'll work in the spreadsheet, because every cell keeps its type. CSV if another program will read the file. Both are in the export menu, and exporting again is free.
Which banks does it work with?
Any bank. LedgerRows reads the statement itself instead of a template made for one bank's layout, so there's no setup and no waiting for your bank to be added. Credit card statements work too.
Does it work with scanned or password-protected PDFs?
Not yet. It reads PDFs downloaded from your bank's website, the kind where you can select the text; scans and phone photos aren't supported. For a password-protected PDF, open it, save a copy without the password, and upload the copy.
Is my statement safe?
Your PDF is read once and never stored. The transactions are encrypted and kept for 30 days so you can export again, and you can delete them at any time. Your statements are never used to train AI models.