How to Convert an Airtel Payments Bank Statement to Excel

If you bank with Airtel Payments Bank, you already know the statement arrives as a PDF — usually password protected, packed with UPI transactions, and formatted for reading rather than for a spreadsheet. Getting that data into Excel so you can total your spending, file GST, or hand it to Tally is exactly the kind of task that eats an evening if you do it by hand. This guide shows how to convert an Airtel Payments Bank statement to Excel properly, so every transaction lands in the right column and the totals actually reconcile.

Why Airtel statements are tricky to copy-paste

Airtel Payments Bank statements have a layout that defeats naive copy-paste and most generic PDF-to-Excel tools:

• Password protection. The PDF is encrypted, so you have to unlock it before anything can read it. Airtel typically uses your account/registered mobile number as the password — check the covering email for the exact rule.
• Wrapped narrations. A single UPI transaction — PAYMENT MADE VIA UPI TO VPA …@PTY AGAINST RRN … — wraps across three or four lines. Line-by-line extraction turns one transaction into several rows.
• A "-" for the empty side. Each row shows either a debit or a credit; the other side is printed as a literal dash. Tools that read positionally often glue that dash, or the amount itself, into the description.
• Right-aligned amounts. The Debit and Credit figures are right-aligned and drift out of their columns, so amounts end up attached to the narration text.

The result, with a generic converter, is a spreadsheet that looks roughly right and is quietly wrong — the worst outcome for anything you'll file or reconcile.

The reliable way: use the running balance

Every Airtel statement prints a running balance in the last column after each transaction. That column is the one signal that is always correct, and it is the key to a trustworthy conversion. The magnitude and direction of each transaction can be recovered from the change in balance from one row to the next: if the balance falls, it was a debit; if it rises, a credit; and the difference is the amount. Cross-checked against the printed figure and the "PAYMENT MADE" / "PAYMENT RECEIVED" wording, this reconstructs the ledger exactly — even when the columns are mangled.

That is precisely how [Statemently](/) reads Airtel statements: it detects the Airtel Payments Bank profile from the statement's own issuer markers (the AIRP IFSC code, the airtelbank.com domain), then rebuilds each transaction from the balance chain. The check that matters — opening balance + total credits − total debits = closing balance — comes out to the paisa.

Step by step

1. Download the statement PDF from the Airtel Thanks app or your registered email.
2. Have the password ready. It is usually your account or registered mobile number; the covering email states the exact format.
3. Upload it to [the converter](/convert). When prompted, enter the PDF password — it is used only in memory to open the document and is never stored.
4. Let it extract. Every UPI payment, mandate, interest credit and maintenance charge is pulled out with its date, transaction ID, narration, debit or credit, and running balance.
5. Review the totals. Confirm the money-in, money-out and closing balance match the last page of your statement.
6. Export to Excel, CSV, or your accounting format. For Indian businesses that means a Tally-ready file — see [converting a bank statement to Tally](/blog/convert-bank-statement-to-tally).

What clean output looks like

One row per transaction, with Date, Transaction ID, Description, Debit, Credit, Balance and the currency in place — opening and closing balance lines kept separate as statement metadata, not counted as transactions. That is a file you can sort, pivot, total for GST, or import into accounting software without a second pass of cleanup.

A note on password-protected PDFs

Never email an unlocked bank statement or paste one into an untrusted web form. A good converter accepts the password over an encrypted connection, uses it only to open the file, and never logs or stores it. If you want the detail, read [working with password-protected bank statements](/blog/password-protected-bank-statements).

The bottom line

An Airtel Payments Bank statement is one of the harder consumer statements to convert cleanly — encrypted, UPI-heavy, and awkwardly laid out. But because it prints a running balance on every line, a converter that reconstructs from the balance chain rather than from column positions can turn it into verified Excel data in seconds, with the totals reconciling exactly. Upload it, unlock it, check the closing balance, and export.