Business and personal spending stay apart when you give them separate categories, for example Fuel for work and Fuel personal, and then write rules so the usual payees land in the right one on import. Rules cannot know your intent, so keep a short monthly review for the mixed rows.
Start by splitting the categories, not the rows
A tag on each transaction means you have to remember to set it. A category per purpose is easier to report on and easier to explain to an accountant. Create a work version of each cost that matters: vehicle fuel, phone and data, parking and tolls, equipment, software and platform fees.
A worked example with made-up numbers
Say you drive for a ride platform and use one bank account for everything. In a month, the fuel pump rows add up to ₹9,000. By your trip log, about two thirds of the distance was work. You decide to treat ₹6,000 as business fuel and ₹3,000 as personal. Your phone bill is ₹800, of which you treat ₹500 as work.
| Cost | Total in rupees | Work share in rupees | Personal share in rupees |
|---|---|---|---|
| Fuel | 9,000 | 6,000 | 3,000 |
| Phone and data | 800 | 500 | 300 |
| Tolls and parking | 1,200 | 1,200 | 0 |
The phone row shows why the split needs care: 500 + 300 is 800, so the two shares match the total. Note that this is a bookkeeping split for your own records. How much of any cost counts for tax is for your CA to decide.
Which rules work well?
- A fixed payee that is always work, such as a platform's payout fee or a toll operator.
- A fixed payee that is always personal, such as a streaming service.
- A mixed payee such as a fuel pump: do not rule it blindly. Use a default and correct the exceptions.
- Your own bank transfers to a personal account: mark as transfers, not spending.
How do I handle a payee that is both?
Pick the more common use as the default and fix the exceptions by hand. For fuel, you might default to Work fuel and, at month end, move the rows from weekend trips to Personal fuel. If you always keep notes of trips, use the log to decide, and keep it with your receipts.
What SpendixAI offers for this
SpendixAI lets you create custom categories and sub-categories, with settings for GST rate, ITC-eligible and tax-deductible, plus an accounting code. Your rules assign rows to a category during import. Reports estimate the GST inside spending; treat these as estimates and confirm them with invoices and a CA. A business and a personal category pair gives you the split without any extra tagging step.
Records that make a split easier to explain
Whatever split you choose, a few records make it defensible to yourself and your accountant. Keep a simple trip log or a monthly note of the work share of vehicle use. Attach receipts to larger work costs. Keep the platform's earnings statement alongside the bank statement so income and costs can be read together. If a cost is shared, write down the reason for the share you chose. Your CA will tell you what they need and how the figures are used; your job is to make the underlying record clear.
Monthly review in ten minutes
- Filter the month for rows in the mixed categories.
- Move any that belong to the other side.
- Check that receipts are attached to larger work costs.
- Add a rule if the same exception happened twice.
- Download the work categories as a CSV for your accountant if they want one.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


