Tax and GST

Importing a business bank statement and tagging by business category

Import a month's business bank statement, set rules for repeat vendors, tag the leftovers and export a category summary, with a freelancer example.

Editorial illustration for Importing a business bank statement and tagging by business category

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 lineAmountRule or decision
Cloud storage subscription₹650Rule: software subscriptions
Co-working desk₹6,000Rule: co-working
Broadband₹1,299Rule: internet and phone
Cab to client₹850By hand: travel
Transfer to a friend₹2,000By 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

  1. Download the statement the day after month end.
  2. Import it into the right account and review the rows.
  3. Add a rule for any new repeat vendor.
  4. Categorise the leftovers, then check for possible duplicates.
  5. Export the category summary and compare the total to the statement.
SPENDIXAI JOURNAL

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

Explore your reports