Bank statement to Excel
Convert a bank statement PDF to Excel, with every running balance checked, without uploading it.
Your statement is opened and read on this device: it's never uploaded, and its password is used once and not saved. Every row's running balance is checked, so anything that doesn't add up is shaded for you to look at.
Choose a bank statement
The PDF from net banking or email (password-protected is fine)
Opened on your device. Never uploaded.
Frequently asked questions
Is my bank statement uploaded?
+
No. The PDF is opened and read inside your browser, and the Excel file is made there too. Your transactions, balances and account number never reach DocuVera.
My statement has a password. What do I do?
+
Choose the file and type its password when asked. The password is used once to open the statement on your device; it isn't saved or sent anywhere. Banks give the format with the statement, often part of your name with your date of birth, or your customer ID.
What goes into the Excel file?
+
A Summary sheet (period, opening and closing balance, total debits and credits, rows to check), then one sheet per account with every transaction: date, value date, narration, mode, cheque or reference number, debit, credit, balance and a Check column. Amounts are real numbers and dates real dates, so you can filter, sort and add up. A CSV of each account is there too, for Tally and other importers.
How do I know nothing was missed or misread?
+
Every row's running balance is checked: the previous balance, plus the credit, minus the debit, must give the balance printed on that row. A row that doesn't add up is shaded, and you can correct its amounts before downloading. When the statement prints its own totals, they're compared with the rows too.
Which banks does it read?
+
Statements whose transaction table has the usual columns (Date, Narration or Particulars or Description, Withdrawal or Debit, Deposit or Credit, Balance), which covers SBI, HDFC, ICICI, Axis, Kotak, Bank of Baroda, PNB, Canara and most other Indian banks. Narrations that wrap over several lines are joined, a statement with several accounts gets a sheet for each, and statements listed newest first are recognised.
Does it work with scanned statements?
+
Scanned pages are read with text recognition (OCR) on your device, which can misread a digit; the balance check shades the rows where that happened. The PDF downloaded from net banking is read exactly, so use that when you can.
Is it free?
+
Yes. Converting a statement counts once against the daily free limit. Pro has no daily limit.