To categorise a business bank statement, import the month's file, set rules for vendors that repeat, categorise whatever is left by hand, and then export a summary by category. The first month takes the longest. From the second month, your rules do most of the sorting and you only review the exceptions.
What do you need before you start?
- The statement for one account and one month, as a PDF, CSV or Excel file downloaded from your bank. Use your own statement's download route and check what formats it offers.
- A list of your business categories, kept short.
- A decision on which account this is, because each transaction keeps the account it came from.
Do not share net-banking details with anyone. SpendixAI works from the statement file and does not ask for bank logins or connect to your bank.
Step 1: import and review
Choose the account, then upload the file. You can upload several files in a batch and see an import history with a status for each. Review the rows before saving: dates, amounts and descriptions should match what you see on your statement. Layouts vary, so a PDF may not read perfectly; fix or drop the rows that look wrong. If you upload the same period twice, possible duplicates are flagged.
Step 2: set rules for repeat vendors
Say a freelancer's statement has 38 rows for the month (hypothetical). Many are the same payees: a cloud storage charge, a co-working payment, a broadband debit. For each one, create a rule: this payee goes to this category. Rules run first, so those rows are sorted automatically from now on.
| Statement line | Amount | Rule or decision |
|---|---|---|
| Cloud storage subscription | ₹650 | Rule: software subscriptions |
| Co-working desk | ₹6,000 | Rule: co-working |
| Broadband | ₹1,299 | Rule: internet and phone |
| Cab to client | ₹850 | By hand: travel |
| Transfer to a friend | ₹2,000 | By hand: not business, or an owner drawing |
Step 3: tag what is left
The remaining rows are one-offs. Categorise them yourself, or let the AI step suggest categories if you have it switched on. It works in stages: your rules first, then your history and similar merchants, then an AI model only for what is still unmatched. You can switch AI off for this, set a monthly budget for it, or turn it off completely, in which case unmatched rows are held for your review. Your corrections become history for next time.
Step 4: export a category summary
Once everything is categorised, open the reports and group the month by category. The report builder lets you filter and group, and you can download a CSV to hand to your CA or open in a sheet. Check that the total of your categories equals the total of debits on your statement, to the rupee.
What if a row will not categorise cleanly?
Some rows are puzzles: a UPI transfer to an individual, a cash withdrawal, a lump payment with no name. Do not force them into a business head. Mark them as unreviewed, ask the person or check your own records, and decide within the month. A transfer of ₹5,000 to a friend might be a repaid loan, a team payment or a personal item, and the right answer changes your totals. Leaving a short note on the entry saves you from guessing next quarter.
A monthly routine
- Download the statement the day after month end.
- Import it into the right account and review the rows.
- Add a rule for any new repeat vendor.
- Categorise the leftovers, then check for possible duplicates.
- Export the category summary and compare the total to the statement.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


