Bank Statement Converter
Convert PDF bank statements to Excel or CSV.
Server processing: When you run this tool, your statement and any password you enter are uploaded through OneClickUse to its external processing service. Selecting a file does not upload it.
Written by Anil Gautam · Updated
What happens to your statement during conversion?
Conversion runs on a server. Choosing a file sends nothing; pressing the Convert button sends the PDF, the output format and any password you typed through OneClickUse to an external conversion service, and the finished file comes back to your browser. One non-empty PDF of up to 10 MB is accepted at a time. Excel (.xlsx) is the default output and CSV is the other choice. For a protected statement, type its password in the optional box; you do not need to remove the password first with the Bank Statement Password Remover.
Before anything is saved, your browser checks what came back. A CSV must open with a header that has a date column (Date, Txn Date, Transaction Date, Value Date, Posting Date or Book Date) and at least one money column such as Debit, Credit, Amount, Balance, Withdrawal or Deposit. Every row needs as many cells as the header and a readable number in one of the money columns. Amounts written as 1,25,000.00 Cr, ₹2,500 or (450.00) all count, the last as a negative. A reply that fails these checks produces an error message, and nothing is downloaded.
Should you choose Excel or CSV output?
CSV gets the stricter check, and the message after a CSV download states how many transaction rows the file holds. If that number is 0, the page asks you to confirm you uploaded the right statement or to try Excel output. For Excel, the browser confirms that a real workbook with at least one worksheet arrived but does not count its rows, so the message asks you to review the file before you rely on it.
Excel opens straight into a sheet you can sort and total. CSV is plain text that accounting and spreadsheet programs can import, and it is the output to pick when you want the row count confirmed before you start.
How do you check the converted transactions?
Reconcile the file with the PDF before using it for accounts or tax. Add up the credit column and the debit column, then apply both totals to the opening balance printed on the statement. With an opening balance of ₹48,250.00, credits of ₹1,12,000.00 and debits of ₹97,430.50, the closing balance has to be ₹62,819.50. Any other result means a row is missing, repeated or misread.
Compare the rows at the top and bottom of each PDF page with the original, along with transactions whose narration wraps onto a second line. Keep the PDF next to the spreadsheet, because the PDF is the bank's own record if a figure is ever questioned.