Spreadsheets

Pull bank charges and interest lines into their own category

Flag fee, charge, GST-on-charge and interest lines with a keyword list and a helper column in Excel, so bank charges get their own monthly total.

Editorial illustration for Pull bank charges and interest lines into their own category

Give bank charges their own category by checking each narration against a short keyword list in a helper column, label the matches "Bank charges", and total that label by month. Fee lines, the small GST lines beside them and interest entries are tiny and frequent, so unless something catches them they dissolve into "Other" and you never see what they add up to.

Which statement lines count as bank charges?

Anything the bank adds to your account by itself, rather than a payment you made to someone. The wording differs from bank to bank, so open your last three statements and note the exact words printed beside the small debits. Do not copy keywords from a blog post, including this one; copy them from your own file.

  • Fee lines: alert charges, card fees, cheque-book charges, penalty lines for a low balance, charges for a cash deposit or an extra transfer.
  • GST on those fees: usually a separate line right next to the fee, often mentioning GST in its narration.
  • Interest credited: a credit entry, which is not income from work and should not sit in your salary or income bucket.
  • Interest debited: relevant if you have an overdraft or a loan account, and worth its own label too.

How do you build the keyword list?

Make a sheet called Rules and type one keyword per cell in H2:H12. No blank cells inside the list, because an empty keyword matches every row. Put a space on both sides of short words so they only match as whole words.

Keyword as typedCatchesWhat to watch
FEEANNUAL FEE FOR CARDDoes not match COFFEE DAY, because the spaces anchor the word
CHGSMS ALERT CHGCheck that no merchant name on your statement contains it
GST ONGST ON ALERT CHGKeep only if your bank prints such a line
SMS ALERTSMS ALERT CHARGESNarrow enough to stay safe
INTERESTINTEREST CREDITED, INTEREST DEBITEDNeeds the credit or debit test in the formula below

What formula assigns the category?

Say column A holds the date, B the narration, C the debit, D the credit, E the category and F the month. In E2, enter this:

=IF(AND(D2>0,ISNUMBER(SEARCH("interest",B2))),"Interest credited",IF(SUMPRODUCT(($H$2:$H$12<>"")*ISNUMBER(SEARCH($H$2:$H$12," "&B2&" ")))>0,"Bank charges","Other"))

SEARCH ignores capitals, and the added spaces around B2 let the whole-word keywords work even at the very start or end of a narration. The SUMPRODUCT part counts how many keywords hit; anything above zero is a charge. Fill the formula down the whole list.

How do you get a monthly total of bank charges?

  1. In F2 enter =TEXT(A2,"yyyy-mm") and fill down, giving labels such as 2025-07.
  2. Anywhere on a summary sheet, enter =SUMIFS($C$2:$C$500,$E$2:$E$500,"Bank charges",$F$2:$F$500,"2025-07").
  3. Change the month label per row of the summary to get one line per month.

A worked example with made-up numbers: say July shows an alert charge of ₹15 with a ₹3 GST line, and a card fee of ₹60 with a ₹10 GST line. The month's total is 15 + 3 + 60 + 10 = ₹88. If every month looked like that, the year would come to 88 × 12 = ₹1,056. That is invented arithmetic, not a typical figure, but it shows the point: nobody notices ₹3 at a time, and the total is worth knowing.

Does interest credited belong with income?

Usually it is better to keep it apart. Interest on a savings balance is a result of money sitting still, while income is what you earn. Giving it its own category means your monthly income total reflects pay and other earnings, and you can still see the interest line. Whether interest is taxable or how to report it is a question for your CA or the official source, since rules change.

A short checklist before you rely on the totals

  • Keywords copied from your own statements, with no blank cells in the list.
  • Short words wrapped in spaces so they do not match inside merchant names.
  • The Other filter reviewed for stray fee lines.
  • Interest credited and interest debited kept as separate labels.
  • Month totals compared against a hand count for one month.

When a sheet stops being enough, SpendixAI lets you set your own categorisation rules and corrections become history for similar merchants, after you upload a PDF, CSV or Excel statement and review the rows before saving.

SPENDIXAI JOURNAL

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

Explore your reports