Bank statements

IndusInd Bank statement PDF to Excel: convert and tidy it

IndusInd Bank statement PDF to Excel: join narrations that wrap onto extra rows with a simple formula, and confirm the transaction count and closing balance.

Editorial illustration for IndusInd Bank statement PDF to Excel: convert and tidy it

A frequent snag when an IndusInd Bank statement goes from PDF to Excel is that a long narration wraps onto one or two extra rows, each with no date and no amount. Fold those lines back into the transaction above them with a helper formula, delete the leftovers, and confirm with the closing balance. Column positions below are examples; yours may differ.

What do wrapped narrations look like?

In the spreadsheet you will see a row with a date, an amount and the first half of a narration, followed by one or two rows holding only text in the narration column. If you sort or filter before joining them, those fragments become orphan rows with no meaning.

RowA: DateB: NarrationD: Amount
203/06/2026UPI payment to a local450
3–stationery shop ref 1234–
404/06/2026Cash withdrawal5,000

The table is made up to show the pattern, not copied from any bank.

How do I join the pieces with a formula?

Put this in C2 and copy it down to the last row of data:

=IF(AND(A3="",D3=""),TRIM(B2&" "&C3),B2)

Read it as: if the next row has neither a date nor an amount, this row's narration is its own text plus the combined text of the row below; otherwise it is just its own text. Because each cell refers to the row beneath it, the first row of a wrapped group collects all the fragments. In the sample, C2 becomes the full narration of the UPI payment and C4 stays as it is.

How do I get rid of the leftover rows?

  1. Copy column C and paste as values over itself.
  2. Add a helper in column E: =IF(AND(A2="",D2=""),"delete","keep").
  3. Filter for delete, select the visible rows, remove them, clear the filter.
  4. Delete column B and rename C to Narration.

Do the paste as values before deleting anything. Otherwise the formulas lose their rows and show errors.

What if a row has an amount but no date?

Some layouts show the date once and leave it blank for later transactions on the same day. Those rows are real transactions, not wrapped text, which is why the formulas above join a row only when both the date and the amount are blank.

To give those rows their date, add a column F and enter, from row 2 downwards:

=IF(A2="",F1,A2)

Here F1 is the heading, which is never used because A2 holds a date. Each row then carries either its own date or the one above it. Paste as values and use column F for sorting and monthly totals.

How do I check nothing was lost?

Count transactions before and after. Before cleaning, count rows with a date: =COUNT($A$2:$A$500) once dates are real. After cleaning, the count should be the same, because you removed fragments, not transactions. Then run the money test. Say opening ₹14,000, credits ₹33,500, debits ₹29,850. Expected closing: 14,000 + 33,500 − 29,850 = ₹17,650.

What about a protected PDF?

If the PDF will not open without a password, use the one the bank gives you for e-statements; check the message that came with it. Skip websites that offer to remove protection, since they read the whole file.

When to stop using formulas

Joining wrapped lines is a one-off fix per statement. Over twelve months it becomes a chore, and that is where an importer that reads PDF, CSV or Excel and shows rows for review, like SpendixAI, earns its place.

There is no shame in either route. A formula-based clean-up is a good way to learn how your own statement is built, and that knowledge makes you a better reviewer of any importer's output.

SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports