Mark every row of the statement as Business, Personal or Unsure, answer the Unsure ones by asking whether you would have paid it without the work, then total each tag. One pass through a month's statement is enough to start.
What is the question to ask of each row?
Would I have spent this if I did not do this work? A fuel fill-up for deliveries, a data pack bought for client calls and a platform fee are business. Rent for your home, groceries and a film ticket are personal. Where it is mixed, such as a phone plan used for both, decide a share and write it down so you apply it the same way each month.
What does a tagged statement look like?
Take eight rows from a made-up week.
| Date | Description | Amount | Tag |
|---|---|---|---|
| 2nd | Fuel | ₹1,200 | Business |
| 3rd | Groceries | ₹2,400 | Personal |
| 5th | Platform fee | ₹650 | Business |
| 8th | Phone bill | ₹800 | Unsure |
| 9th | Restaurant | ₹1,100 | Personal |
| 11th | Printing for client | ₹450 | Business |
| 12th | Rent share | ₹9,000 | Personal |
| 14th | Cab to client | ₹520 | Business |
Business rows: 1,200 plus 650 plus 450 plus 520, which is ₹2,820. Personal: 2,400 plus 1,100 plus 9,000, which is ₹12,500. The phone bill of ₹800 is unsure. If you decide half is for work, ₹400 goes to each side.
How do I total them in a sheet?
Put the amount in column C and the tag in column D, rows 2 to 300. Business total:
=SUMIFS($C$2:$C$300, $D$2:$D$300, "Business")
Personal total:
=SUMIFS($C$2:$C$300, $D$2:$D$300, "Personal")
Anything not yet tagged: =SUMIFS($C$2:$C$300, $D$2:$D$300, "Unsure"). Keep the unsure total at zero by the time you finish.
What about mixed items like the phone plan or a laptop?
Pick a share and stay with it. Say you use the phone for work about half the time. Then ₹800 splits into ₹400 and ₹400. A laptop you use for both could be split by hours or by how much of your income depends on it. The number matters less than consistency and a note beside the entry saying how you arrived at it. If the split is likely to be questioned, ask your CA what they would accept before you spend a month applying the wrong one.
One more trap is the cash withdrawal. An ATM row on a statement is neither business nor personal until you know what the cash bought. Tag it Unsure and keep a short list of what you paid in cash that week, then split the withdrawal accordingly.
Who will ask for this?
Your CA at the time of filing, a client who wants a cost breakdown, or a lender who asks how much of your outgo is work-related. Rules about what counts as a business cost are not something to guess; ask the professional, and bring a tagged statement as the starting point.
When does a sheet stop being enough?
When there are several accounts and hundreds of rows a month, tagging by hand is slow. SpendixAI lets you upload statements as PDF, CSV or Excel, review the rows, create your own categories for business and personal spending, and set rules so the same merchant is tagged the same way next time. The Report builder filters and groups, and results export as CSV. It does not give tax advice.
Checklist for the month
- Tag every row before the 10th of the next month.
- Resolve each unsure item.
- Total both sides and compare with last month.
- Keep the bills for the business side.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

