Give every business purchase one of three tags when you record it: Stock for things you will sell, Expense for things you use up, and Equipment for things you keep and use for years. Two questions get you there: will you resell it, and will it last for years? The tag is a first sort for your own books, and your CA can change it.
What are the two questions?
- Will this item or something made from it be sold to a customer? If yes, it is Stock.
- If not, will it be used for several years in the business? If yes, it is Equipment. If not, it is an Expense.
Most purchases fall out within seconds. The ones that do not are the reason for the fourth tag below.
Example from a small bakery
A neighbourhood bakery buys these items in a week, with invented amounts.
| Purchase | Amount | Resold? | Lasts years? | Tag |
|---|---|---|---|---|
| Flour and sugar | ₹8,400 | Yes, made into products | No | Stock |
| Cleaning supplies | ₹650 | No | No | Expense |
| New oven | ₹52,000 | No | Yes | Equipment |
| Electricity for the week | ₹1,900 | No | No | Expense |
| Boxed biscuits bought for resale | ₹3,200 | Yes | No | Stock |
The week's total is 8,400 plus 650 plus 52,000 plus 1,900 plus 3,200, which is ₹66,150. Tagged, that is ₹11,600 of Stock, ₹2,550 of Expense and ₹52,000 of Equipment. The tags let you see in a second that most of this week's money went on one oven.
Which purchases are in the grey area?
Some items do not fit neatly. Do not force a tag; use a fourth label, Ask CA, and write the question.
- A display shelf or glass case for the shop floor.
- Packaging, such as boxes and bags that go out with the product.
- Hand tools and small utensils that last, but cost little.
- A set of baking trays bought together.
- Signboards and branding material.
- Installation or delivery charges added to a large purchase.
How do you apply the tag at entry?
Tag at the moment of entry, not at the end of the month. A bill from a week ago is harder to classify, because nobody remembers what the item was. Add a column called Tag in your sheet, and use data validation so only the four labels can be chosen.
In a spreadsheet, count and total by tag with these formulas, assuming Amount in column C and Tag in column D, rows 2 to 500: =SUMIFS($C$2:$C$500, $D$2:$D$500, "Stock") and =COUNTIF($D$2:$D$500, "Ask CA"). The second tells you how many items wait for the CA.
Can a tracker apply the tag for you?
Yes, in a way. SpendixAI lets you set up custom categories and sub-categories, such as Stock, Expense and Equipment, and write your own rules so that a regular supplier is put in the right one. Corrections you make become history for later imports, and you can switch the AI off if you prefer to review every unmatched item yourself.
What happens when the tag turns out wrong?
Change it, and leave a note. If the CA moves the glass display case from Expense to Equipment, update the Tag column, add the date and the reason in Notes, and do not delete the old entry. If it happens for a whole type of purchase, add a rule for next time so you are not correcting the same item every month.
A tagging checklist
- Every bill has a tag on the day it is entered.
- Ask CA rows have a question written next to them.
- Totals by tag are looked at monthly.
- The tag list is shared with your CA once a year.
- Any new type of purchase gets a rule or a note.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

