Convert an RBL Bank Statement to Excel

RBL Bank statement conversion, including credit card statements which carry no running balance and need a different verification approach.

RBL is worth covering for a specific reason: a large share of RBL statements people need to convert are credit card statements, and credit card statements verify differently from bank accounts.

No running balance means no chain

A savings account statement carries a running balance on every row, and that column is what lets you prove the extraction is correct — each balance must follow arithmetically from the one before it.

Credit card statements have no such column. They print transactions, and then a summary: previous balance, payments, purchases, fees, interest, new balance. There is nothing to chain.

What to check instead

Summary figure	Check against
Total purchases / debits	Sum of your extracted debit rows
Total payments / credits	Sum of your extracted credit rows
Previous balance + debits − credits	Should equal the printed new balance
Transaction count	Row count in your export, where printed

This is weaker than a balance chain — it will not tell you which row is wrong, only that something is — but it still reliably catches a missing page or a misread amount.

Multi-currency card statements

RBL cards used abroad print the foreign amount alongside the rupee amount. Only the rupee figure belongs in the debit column — including both, or picking the wrong one, will make your totals disagree with the statement by exactly the foreign spend.

Card statement analysis

Once a card statement is converted, a few things become answerable that are not from the PDF:

Total interest and fees for the year — convert twelve statements and sum those rows
Spending by merchant — group by merchant, sorted descending
Recurring subscriptions — merchants appearing monthly with consistent amounts
Foreign transaction costs — the markup on overseas spend, which is rarely stated plainly

The last one is worth calculating. Comparing the rupee amount billed against the foreign amount at the prevailing rate shows the effective markup, which is often larger than the headline foreign transaction fee suggests.

Frequently asked questions

Are RBL savings account statements supported?

Yes, and those carry a running balance, so full chain verification applies.

How do I work out what foreign transactions really cost?

Compare the billed rupee amount against the foreign amount at the prevailing rate. The difference is the effective markup, which usually exceeds the stated fee.

How are foreign currency transactions handled?

They come through as RBL printed them: the rupee amount in its column, and the foreign amount wherever RBL prints it. Nothing is moved between columns, so total only the rupee column.

Convert a statement now

Bank Statement PDF to Excel, or see every format. More in the guides.