To tag business and personal transactions automatically, give every category a default side (business or personal), then write rules that send known merchants into those categories as you import. That way the tag follows the category and you only touch the odd exception. The example below uses US dollars and deals with habits and records only, not with any tax rule.
Start with the categories, not the transactions
Tagging row by row is slow and inconsistent. It is easier to decide, once, that Software, Client travel and Equipment are business categories while Groceries, Rent and Eating out are personal ones. Then every transaction inherits its side from its category, and your rules only have to pick the category.
| Category | Side | Example merchants |
|---|---|---|
| Software and subscriptions | Business | Design tool, website host |
| Client travel | Business | Rail tickets to a client site |
| Equipment | Business | Camera lens, laptop stand |
| Groceries | Personal | Supermarket |
| Eating out | Personal | Weekend restaurants |
A photographer's month, with numbers
Say a freelance photographer buys a lens for $640, pays $29 for photo software, $62.40 for rail tickets to a client shoot, and spends $138.75 on groceries and $54 at a restaurant. Business: $640 + $29 + $62.40 = $731.40. Personal: $138.75 + $54 = $192.75. Everything together is $924.15. If the tracker reads all five rows as personal, the business figure you would hand to an accountant is zero and the month looks like a $924.15 personal spree.
Set it up in five steps
- Create your business categories and mark them as business.
- Create your personal categories.
- Write a rule for each regular business merchant: text contains the merchant's stable name, category set accordingly.
- Write rules for regular personal merchants too, so they cannot drift into business.
- Import a month and review everything the rules did not touch.
What about a card used for both?
The cleanest fix is separate accounts, one for business and one for personal. If you cannot separate them, rely on the category side and be strict about reviewing a mixed card each month. Pick the account before you import, so each transaction remembers where it came from; this gives you a second way to filter later.
- Separate cards or accounts: simplest, fewest errors.
- One mixed card: more rules, more review.
- Cash spends: add them by hand soon after, while you remember what they were.
How do I handle a merchant that is both?
A big retail chain may sell you printer paper for your studio and a birthday card for your sister. Do not write a rule that guesses; leave the merchant for manual review, or set a default and fix the exceptions. A line you review costs seconds, while a line wrongly tagged costs far more when you try to explain it later.
SpendixAI is built around India and INR, so we will not claim it for dollar users; if you ever use an app with category-level settings and rules applied at import, this is the method to follow. In SpendixAI, categories carry settings such as GST rate and tax-deductible flags and your own rules come before history and AI, which is the same idea in a rupee setting.
Why review beats perfection
Do not wait for the rules to be perfect before you start. Tag what you can on day one, review the rest, and improve the rules each month. After three months you will have written perhaps fifteen rules, and the share of rows needing attention will have fallen far enough that the monthly check takes a few minutes.
End-of-month check
- Open the business total and read every line once.
- Open the personal total and scan the five largest items.
- Look at anything uncategorised.
- Save or export the business list for whoever needs it.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


