Bank statement PDF to Excel
Turn a bank statement PDF into an Excel sheet of transactions.
Drop your PDF hereAdd your PDF
PDF, up to 50 MB. You can paste with Ctrl or ⌘ and V.
Files stay on your device. How Merji keeps them private
Convert a bank statement PDF to Excel without sending it anywhere. Merji reads each transaction into a sheet with date, description, debit, credit and balance, then checks every balance adds up. It runs in your browser, so the statement, a document full of private details, never leaves your device.
How to do it
- Download your statement from your bank's website or app as a PDF. A statement saved from net banking works; a photo or scan of a paper statement doesn't yet.
- Drop the PDF here. If it's password-protected, type the password the bank gave you; it's used on your device and not kept.
- Check the result. Merji tells you how many rows add up and marks any that don't.
- Download the Excel file, or choose CSV if you want to import it elsewhere.
What usually goes wrong
The file is a scan, not a downloaded statement
A scan is a picture of text, so there is nothing for Merji to read yet. Download the statement again from net banking as a PDF and use that file.
The statement is locked with a password
Banks often lock statement PDFs. Type the password when Merji asks. If you don't know it, the email or message that came with the statement usually explains how your bank builds it.
Some rows don't add up
This usually means a line wrapped across two rows or a page break split a transaction. Merji marks those rows in the sheet so you can fix them by hand instead of trusting a wrong total.
Your bank isn't one of the five Merji is set up for
Merji is set up for HDFC, SBI, ICICI, Axis and Kotak, and reads other banks from their column headings: date, narration, withdrawal, deposit and balance. If a statement has unusual headings, fewer rows may add up, and Merji tells you how many did so you know what to check.
Dates or amounts show as text in Excel
Merji writes real Excel dates and numbers. If you chose CSV and opened it in Excel, the import settings can change them; use the Excel download instead.