Bank Reconciliation › Bank statement file

Get your bank statement in Excel or CSV

The steps that work for most banks, what the tool reads from the file, and what to do with a passbook or a PDF.

Get the statement as a file

1. Log in to your bank's net banking on a computer (the mobile app often gives only a PDF).
2. Open the account statement page for the current account or savings account you use for the business.
3. Choose the period: one month is easiest to check, from the 1st to the last day.
4. Download as Excel (.xls or .xlsx) or CSV. If only PDF is offered, look for "Download as XLS" or "Detailed statement"; most banks offer one of these.
5. Open the file here with Open bank statement. It stays in your browser; nothing is uploaded.

What the tool reads

Bank files differ, but almost all have a date, a description (narration), a cheque or reference number, withdrawal and deposit columns (or one amount column with Dr and Cr) and a balance. The tool finds the header row by itself, skips the title lines and the opening balance, and reads dates the way Indian banks print them, day first (05/04/2026 is 5 April). If a column is read wrongly, open Columns of the statement and choose the right one.

No file? Type the lines

For a passbook or a printed statement, press Type a bank line and type each line: the date, details, and the withdrawal or the deposit. A month of a small business is usually twenty or thirty lines.