A useful bank statement analyzer answers six plain questions: how much came in, how much went out, where it went, what repeats, what looks unusual and whether the numbers reconcile with your statement. If a tool gives you charts but cannot answer those, it is decoration. This page shows you how to analyse a month by hand once, so you can judge any tool against it.
What are the six questions?
- Total money in and total money out.
- Spending grouped by category.
- The biggest individual payments.
- Recurring payments, such as rent, subscriptions and EMIs.
- Odd items: duplicates, unfamiliar merchants, large cash withdrawals.
- Opening plus in minus out equals closing.
How does a hand analysis work?
Take a made-up month. Opening balance ₹30,000. Money in: salary ₹55,000 and a refund of ₹1,200. Money out: ₹16,000 rent, ₹7,800 EMI, ₹9,400 food, ₹4,100 transport, ₹3,300 subscriptions and shopping, and ₹10,000 transferred to savings.
| Line | Amount |
|---|---|
| Opening balance | ₹30,000 |
| Money in | ₹56,200 |
| Money out | ₹50,600 |
| Expected closing | ₹35,600 |
Money out: 16,000 plus 7,800 plus 9,400 plus 4,100 plus 3,300 plus 10,000 equals ₹50,600. Closing is 30,000 plus 56,200 minus 50,600, which is ₹35,600. If your statement shows a different closing figure, something is missing or double counted.
Which numbers does the analyzer sometimes get wrong?
- Transfers between your own accounts counted as spending, which inflates outgoings.
- Card bill payments counted on top of the card's own purchases.
- Refunds treated as income.
- Cash withdrawals left as one lump with no category.
In the example, the ₹10,000 transfer to savings is not spending. Put it in its own line, so that "spending" is ₹40,600.
How do you test a tool?
Feed it one statement you have already analysed by hand. Compare the totals line by line. Check that it flags the same recurring items and that a transfer is not shown as a cost. Any gap is a test result about the tool, not about you.
What does SpendixAI offer for this?
SpendixAI lets you upload statements as PDF, CSV or Excel and review rows before saving. It has an overview, 25 ready-made reports grouped by question, a Report builder to filter and group, and a Possible duplicate charges report for the same amount to the same merchant within two days. It does not connect to your bank, so the numbers are only as complete as the statements you give it.
How often should you run an analysis?
Monthly is enough for most households, with a deeper look once a quarter and once a year. The monthly pass answers whether you stayed within your plan. The quarterly pass looks for creeping subscriptions and rising bills. The annual pass is for records: totals by category, big purchases and proof for anything you may need to show later.
Keep the same categories from month to month. Changing them mid-year makes comparison impossible, and a long run of consistent months is worth more than a perfect set of categories you keep rewriting.
What should you do with the findings?
Pick one finding per month and act on it. It might be cancelling a subscription you found, moving a transfer to the day after salary lands, or querying a charge you do not recognise. A report that produces no action is just reading. Write the action and the date next to the report, and check it next month.
- Unrecognised charge: ask your bank or the merchant before assuming fraud.
- Repeated fee: look at the account terms or call the bank for an explanation.
Next step
Run the six-question check on your last statement today. It takes twenty minutes, and the result is your yardstick for every tool you try afterwards.
Useful ideas start with a clearer picture of your own spending.
Explore your reports
