Expense categories

Auto-categorise UPI rows when two people pay from different accounts

Couples paying household bills from two accounts can import both statements and write shared merchant rules so groceries, rent and outings sort the same way.

Editorial illustration for Auto-categorise UPI rows when two people pay from different accounts

When two people pay for one household, the same shop shows up on both statements under different UPI handles, and each of you has been sorting it your own way. Import both accounts, write one shared set of rules for the repeat merchants, and settle the few shared-or-personal rows together once a month.

What is different when two statements feed one household?

Say she pays the maid, the milkman and the grocer from her account, and he pays the rent, the broadband and the cab rides from his. The grocer may also take payments from him on a weekend. If each statement is categorised separately, the same grocer can appear as Groceries in one and Provisions in the other, and the household total is wrong in both.

How should the shared rules be set?

Write the rules once, using the shared category list, and apply them to both accounts. Start with the merchants that appear on both statements, then add the ones that appear on one.

  • Grocer, milkman and vegetable seller: Groceries
  • Maid and cook: Domestic help
  • Broadband and electricity: Utilities
  • Cab and metro: Transport
  • Landlord's monthly transfer: Rent

In SpendixAI, rules run first, then merchant defaults and your own history, then AI if you switch it on. Pick the account for each import so the rows stay tied to it, and the same categories apply across accounts.

What about money moved between the two of you?

When one pays the other back for a shared expense, the transfer appears as a debit on one statement and a credit on the other. Left alone, it looks like spending on one side and income on the other. Agree on a category called Between us and put both sides there, so it nets to zero.

Take an example: he pays the ₹28,000 rent and she transfers her half, ₹14,000, to him. His rent line is ₹28,000, her transfer is ₹14,000. The real cost of rent to him is ₹28,000 − ₹14,000 = ₹14,000. If you tag her transfer as Between us, and treat his rent as joint spending, your reports show ₹28,000 of joint rent and ₹14,000 moved between you. That is the right picture.

RowAccountCategory
Rent to landlord ₹28,000His accountRent
Her half ₹14,000, creditHis accountBetween us
Her half ₹14,000, debitHer accountBetween us

Where do arguments hide?

In the personal rows. Decide which categories each of you can keep private, such as hobbies or clothes, and do not look at each other's unless asked. The tracker exists to show the household, not to audit a partner's coffee.

Monthly checklist for two

  1. Import both statements, one account at a time.
  2. Run the shared rules and see what is left.
  3. Sit down for ten minutes with the leftover rows only.
  4. Clear Between us so it matches on both sides.
  5. Write a new rule for anything you both paid twice.

What if a shop is used by both of you for different things?

A big general store may supply the kitchen on one visit and a gift on the next. Keep the rule for the common case, such as Groceries, and fix the exception by hand. If you notice you keep editing the same shop, split the rule by usage: for example, one rule for the shop on weekday mornings if that is when you buy milk, and manual edits for the rest. The aim is fewer edits, not perfection.

SPENDIXAI JOURNAL

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

Explore your reports