To categorise Federal Bank transactions, begin with the lines that repeat every month, because they are the easiest to sort and cover the largest share of your money: salary in, rent or society maintenance out, a standing instruction or two, and bill payments. After those, the UPI and card lines are mostly one rule per merchant. Whatever stays unmatched is a short list you can read by eye.
Which lines repeat every month?
Narrations below are invented illustrations, not copied from Federal Bank, so rely on your own statement for the real wording.
| Recurring item | Illustrative narration | Category | Question to ask each month |
|---|---|---|---|
| Salary | NEFT-EMPLOYER PVT LTD-SALARY | Income, Salary | Did the amount match the payslip? |
| Rent | NEFT-OWNER NAME-RENT | Housing, Rent | Has the amount changed? |
| Society maintenance | SI/APARTMENT ASSN | Housing, Maintenance | Was an extra charge added? |
| Insurance premium | ECS/INSURER-PREMIUM | Insurance | Is it due yearly or monthly? |
| Phone and broadband | UPI/PHONE-BROADBAND | Utilities | Did the plan or bill change? |
| Interest credit | INT CREDIT | Income, Interest | Does it look reasonable for the balance? |
Why should a salary credit not be treated like spending?
Credits and debits answer different questions. A salary credit belongs under Income, and the same goes for interest and refunds. Keep them out of the expense categories, otherwise a refund of ₹1,200 from an online order quietly shrinks your Shopping total and you never see what you actually spent. If you want to link a refund to the original purchase, do it in the description.
How do standing instructions differ from auto-debits?
In general, a standing instruction is something you set up with your bank to pay a fixed amount on a schedule, while an auto-debit or mandate is something a merchant or lender pulls from your account, often for a variable amount. On the statement they can look alike. Check your own statement to see how your bank labels each. The tracking habit is the same: record the amount, note the date and compare it with last month. A fixed instruction that suddenly shows a different amount, or a mandate you do not remember agreeing to, should send you to your bank, not to a category list.
What about lines that are only a code?
Some narrations are mostly a reference string with a short name tucked inside. Search the line for the name and write a rule on that part only. If there is no name at all, check the date and amount in your UPI app or card statement, or look for an email or SMS receipt. Where you still cannot place it, use a holding sub-category and revisit it later.
A worked example of recurring costs
Say a month has these fixed debits: rent ₹16,000, society maintenance ₹2,200, an insurance premium of ₹1,850, phone and broadband ₹1,150. The total is 16,000 + 2,200 + 1,850 + 1,150 = ₹21,200. If your salary credit is ₹52,000, then ₹21,200 is about 41 per cent of it (21,200 ÷ 52,000 = 0.4077), leaving ₹30,800 for everything else. Those numbers are made up, but the exercise is useful with your own: fixed costs first, then you can see how much room the variable items really have.
How do you make the next statement sort itself?
- Write rules for each recurring item above, matching the name part of the narration.
- Write rules for your five most frequent UPI merchants.
- Add a rule for the interest line and for any recurring bank charge.
- Keep Person payments, to review as a holding category for transfers to individuals.
In SpendixAI, you can import the Federal Bank statement from a PDF, CSV or Excel file after choosing the account, review each row, and let your rules and history categorise the rest. Rows that nothing can place stay for you to decide, and the app does not ask for your net-banking login.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

