Axis Bank Statement to CSV: Handling Both Layouts

The reason you need this is rarely interesting: an ITR filing, a loan file where the lender wants six months of transactions, a bookkeeping catch-up, or an account you closed and now have to reconstruct. The reason it is harder than it should be is more specific. Axis Bank does not print its statements in one shape, and the two shapes it does print behave very differently when a machine reads them.

Sometimes Axis will give you a download you can open directly. Often you have a PDF — an emailed e-statement, a period outside the online window, a statement a client forwarded. This guide covers the export route, the conversion route, and the one Axis-specific detail that turns a plausible-looking CSV into a useless one.

Quick answer

1. Use Axis Bank's own statement download. With internet banking or the mobile app you can open the statements area, choose an account and a period, and download it. How far back the online statement history reaches is not something Axis publishes, so check what your own date picker offers before assuming a period is available.
2. Convert the PDF. For e-statements, periods beyond that window, closed accounts and third-party statements, the PDF is the only copy. Upload it to a converter like BankStatementKit, which reads the transaction table and balance-checks the output against the statement's own printed figures.

Rule of thumb: if your date picker still offers the period and you have a working login, take the bank's download. Outside that, or without a login, convert the PDF. There is more on the layouts themselves on the Axis Bank statement converter page.

Convert an Axis PDF into a verified CSV

Option 1: Axis Bank's built-in statement download

1. Log in to Axis Bank internet banking, or open the mobile app.
2. Go to the statements area and select the account.
3. Choose the period you want.
4. Download the statement and open it.

You can also register for monthly e-statements delivered by email, which Axis offers from within internet banking under its account services.

Where the built-in download stops

• The online window runs out. Older periods mean a branch visit, and what a branch issues is a document rather than data.
• You need a live login. Closed accounts, accounts you have stopped operating, and any statement belonging to someone else are all out of reach.
• Emailed e-statements are PDFs. Registering for e-statements gets you a monthly PDF in your inbox, not a spreadsheet.
• Exports still need cleaning. Bank downloads typically carry header blocks, footer disclaimers and text-typed numbers that have to be stripped before anything will import them.
• Accountants almost never have the login. In practice the client sends a PDF and that is the whole conversation.

Option 2: Convert the Axis PDF statement to CSV

1. Open the statement PDF. An emailed e-statement will ask for a password.
2. Upload it and supply the password if prompted — the file is decrypted in memory and never written to disk.
3. The transactions are read into seven standard columns: Date, Narration, Reference, Value Date, Debit, Credit, Balance. If your statement uses the Amount plus DR/CR form, the flag decides which of Debit and Credit each figure goes into.
4. Read the verification label, then download the CSV.

Convert an Axis Bank statement

The password rule for an emailed Axis statement is stated in the covering email, and account statements and card statements do not necessarily share a format. Read the email rather than a general guide.

Why Axis PDFs trip up generic converters

The DR/CR flag is the big one. On the Axis layout that prints a single Amount(INR) column, the amount is unsigned — whether it was money in or money out lives in a separate two-character DR/CR column. A converter built around the assumption that Indian statements have separate withdrawal and deposit columns simply does not look at that column. What comes out is a CSV in which every transaction reads as positive, the balance chain fails immediately, and the numbers are individually correct while the file as a whole is worthless. It is the most consequential single-column mistake in Indian bank statement extraction, because unlike a missing row it is not visible by eye.

Two layouts, one bank. The other Axis layout does use separate Debit and Credit columns, alongside Tran Date, Chq No and Particulars. A converter that hard-codes one Axis shape gets the other one wrong. The way out is to key on the layout actually present in the file rather than on the bank's name.

A branch column sits next to the money. Both layouts carry a branch identifier — Init.Br in one, a branch name in the other — near the amount columns. Where it is a numeric code, position-based extraction can read it as an amount or shift the row sideways. Where it is a name, it can be swept into the particulars.

Particulars wrap. Axis transaction particulars carry UPI handles, NEFT references and counterparty text, and they overflow onto second lines that have no date and no amount. Read line by line, one transaction becomes a real row plus one or two fragments.

Prove the CSV matches the statement

Axis prints a running balance on every row in both layouts, and on this bank that check earns its keep more than usual.

1. The balance chain. Previous balance minus debit plus credit must equal the printed balance, row after row. On an Axis statement this is also the DR/CR test: if the flag was misread on even one row, that row's arithmetic fails and every row after it stays wrong. A converter that ignored the flag entirely fails at the first transaction, which is exactly the loud failure you want.
2. Opening and closing balances. The first balance plus total credits minus total debits must equal the last. This catches whole missing blocks — a page that never parsed — which a per-row chain cannot see if the rows are simply absent from both sides.

Doing this by hand takes ten to fifteen minutes per statement. BankStatementKit runs both checks on every conversion and labels the result VERIFIED, DISCREPANCY or FAILED, with a discrepancy pointing at the first row where the numbers stop reconciling.

FAQ

The bottom line

Inside Axis's three-year online window, take the bank's own download. Outside it, or without a login, convert the PDF — and check the result rather than eyeballing it, because the DR/CR flag produces the one kind of error that looks completely normal in a spreadsheet and is completely wrong.