Expense categories

Auto-categorise UPI rows when client and personal money share one account

Freelancers who run client payments and daily spending through one UPI account can sort rows with merchant rules, keeping work, personal and tax money apart.

Editorial illustration for Auto-categorise UPI rows when client and personal money share one account

If client payments and your chai money pass through the same account, write rules in two passes: first for the recurring work merchants, such as software and tools, then for the household ones. Whatever is left is usually a one-off client or a friend, and those rows deserve your own eyes.

What makes a freelancer's UPI statement harder?

A salaried person has one big credit and many small debits. You have credits from several clients on unpredictable days, debits for tools, a coworking seat, travel and groceries, and the occasional refund. Some payments come from a client's company name, others from an individual's UPI handle, and a few are advances that you may have to return.

Because the credits matter as much as the debits, categorisation here has to cover both sides.

Which two passes should you make?

First pass, work: software subscriptions, domain and hosting renewals, coworking, courier, printing, travel for client meetings. Second pass, household: groceries, rent, utilities, school fees, medical, eating out. A third bucket holds money moves, like a transfer to your savings or a tax set-aside.

PassTypical fragmentCategory
WorkDesign software nameSoftware and tools
WorkDomain registrar nameHosting and domains
WorkCoworking deskWorkspace
HouseholdKirana store nameGroceries
HouseholdLandlord's monthly transferRent
Money movesOwn savings accountTransfer, not spending

How do rules treat client income?

Write a rule for each client's regular payer text and assign an income category, such as Client payments. Keep refunds separate, because a refund from a shop is not income for your work. If a client sends an advance for a project that might be cancelled, tag it with a note so you can see it was an advance.

In SpendixAI, rules go first, then merchant defaults and your own history, then AI if it is on. Your corrections become history, so the second client invoice with the same payer text needs no work. The import handles credits, refunds and failed rows, and the review step lets you check them before they are saved.

A worked month

Say your account shows ₹1,45,000 of client credits in a month, from three clients: ₹70,000, ₹50,000 and ₹25,000. That is ₹70,000 + ₹50,000 + ₹25,000 = ₹1,45,000. Rules put ₹9,800 under Software and tools, ₹6,000 under Workspace and ₹4,200 under Travel for clients, together ₹20,000 of work costs. After you also set aside ₹15,000 to your tax pot, ₹1,45,000 − ₹20,000 − ₹15,000 leaves ₹1,10,000 for the household. That is a number you can plan against.

Whether any of those costs counts as a business deduction is for your CA to say.

A checklist before you trust the report

  • Credits equal the client invoices you issued, plus any refunds.
  • Work costs and household costs add up to total debits minus transfers.
  • No row sits under uncategorised with a large amount.
  • Any cash expense, such as a courier, is added by hand against the right category.

If one of those fails, find the single row responsible before you adjust the rest.

What if income is lumpy and costs are not?

Rules sort the past; they do not smooth the future. Once a few months are categorised, look at the household total each month and keep a buffer equal to the thinnest month you have seen. If the lowest month of household spending was ₹31,000, a buffer of two months is ₹62,000, a target to build in the good months. That is a planning habit, not advice on where to keep the money.

SPENDIXAI JOURNAL

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

Explore your reports