Bank statements

AU Small Finance Bank statement PDF to Excel: convert and tidy it

AU Small Finance Bank statement PDF to Excel: clear repeated page headers and prove every row with a running-balance check formula.

Editorial illustration for AU Small Finance Bank statement PDF to Excel: convert and tidy it

To convert an AU Small Finance Bank statement from PDF to Excel, bring the table into a sheet, delete the headings and totals repeated on every page, make dates and amounts real values, and then prove the result row by row with a running-balance check. That last step is the one that tells you whether a row went missing in the conversion.

What does a PDF conversion leave behind?

A multi-page statement carries furniture on each page: column headings, page numbers, a bank address, sometimes a page subtotal. After conversion these become rows in the middle of your data. We cannot say how your own statement is arranged, so scroll down the whole table once and note what repeats.

  • Column headings repeated at the top of each page.
  • Lines such as Page 2 of 5 or a continued-from-previous-page note.
  • A closing summary or totals line at the end.
  • Blank rows between pages.

How do you remove those rows safely?

  1. Add a column at the end and type =IF(ISNUMBER(A2), "keep", "drop"), assuming real dates sit in column A. Fill it down.
  2. If your dates are still text, test the shape instead: =IF(AND(LEN(A2)=10, MID(A2,3,1)="/"), "keep", "drop").
  3. Filter that column for drop, look at the rows once, then delete them.
  4. Remove the filter and the helper column.

Filtering first means you see what you are about to delete, which is safer than hunting for headings by eye.

Which formulas fix dates and amounts?

For a date stored as text such as 03/11/2025 in A2: =DATE(RIGHT(A2,4), MID(A2,4,2), LEFT(A2,2)). For an amount like 1,05,000.00 stored as text in D2: =VALUE(SUBSTITUTE(D2, ",", "")). Paste the results back as values and apply a date format to column A.

How does a running-balance check work?

Most statements print a balance after each transaction. If the balance is in F, debit in D and credit in E, then each row's balance should equal the previous balance minus its debit plus its credit. In G3 put:

  • =ROUND(F3-(F2-D3+E3), 2)
  • Fill it down. A zero means that row is consistent with the one above.
  • Blank debit or credit cells count as zero, so they cause no trouble in Excel or Sheets.

The first non-zero value marks the exact place where a row is missing, doubled or misread. Everything after it will usually also be off by the same amount, so you only need to fix the first one. If the statement shows balances in a different order of columns, change the letters to suit.

What if there is no balance column?

Then verify at the totals level. Say the statement opens at ₹7,250 and closes at ₹10,900, with credits of ₹26,000 in E. Debits should be 7,250 plus 26,000 minus 10,900, which is ₹22,350. In an empty cell put =SUM($D$2:$D$500) and see whether it equals 22,350. If it does, the table is complete even without row-level proof.

What about password-locked files?

If the PDF asks for a password, read the note that came with the statement for how it is set, and open it in your own viewer. Avoid sites that remove locks for you, since they receive your statement.

Is the sheet the best place for this?

It is for one-off questions. If you rebuild it every month, uploading the PDF, CSV or Excel file to SpendixAI and reviewing the rows there saves the clean-up, and possible duplicate imports are flagged if you load the same period twice.

Wrap-up

  • Keep the raw PDF.
  • Save the cleaned sheet with the period in its name.
  • Record the check that passed, whether row-level or totals.
SPENDIXAI JOURNAL

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

Explore your reports