A fixed asset register is a simple list of the lasting things your business owns, such as a laptop, a phone or a camera, with the facts you would need later: what it is, when you bought it, what it cost, who sold it and what became of it. For a freelancer it can be one sheet with seven columns, filled in the day you buy something.
What is a fixed asset register, and who needs one?
Anyone who buys equipment for work benefits from one. The register answers questions that otherwise cost an afternoon: when did I buy that camera, which bill is it, where is the serial number, did I sell the old laptop and for how much. It also gives your CA a clean list at year end instead of a stack of scattered bills.
Which columns should the sheet have?
- Item: what it is, in words you will recognise later.
- Purchase date: the date on the bill.
- Cost: the amount you paid for it.
- Serial number: copied from the device or the box.
- Vendor: who you bought it from.
- Location: where it normally lives, useful when you have more than one workplace.
- Disposal date: blank until you sell, scrap or give it away.
What does it look like when it is filled in?
The entries below are invented, only to show the shape of the sheet.
| Item | Purchase date | Cost (₹) | Serial number | Vendor | Location | Disposal date |
|---|---|---|---|---|---|---|
| Laptop | 12 April 2025 | 60,000 | LT-48213 | Electronics shop, Pune | Home desk | - |
| Phone for work | 3 August 2025 | 30,000 | PH-90871 | Online store | Carried | - |
| Camera body | 20 October 2025 | 85,000 | CM-30456 | Camera dealer, Mumbai | Studio shelf | - |
To total the cost column you only need =SUM(C2:C4), which gives 1,75,000 for the three rows above. As you add items, extend the range or use a range that reaches well below the last row.
Which purchases belong in the register?
Not everything. A pack of pens does not belong, and a laptop does. The line in between is something you set for yourself, since small businesses draw it in different places. A simple way to do it is to choose a cost below which you treat a purchase as an ordinary expense, write that cost at the top of the sheet, and apply it the same way every time. If you are unsure where the line should sit for tax purposes, that is a question for your CA, because rules and limits change.
What do you do when you sell or scrap something?
Do not delete the row. Fill in the disposal date and add two notes: what you received, if anything, and where the money went. A row that stays in the sheet with a date at the end is a complete history. A row that disappears is a mystery next year.
One more column is worth considering once you have several items: a free-text note. It is the place for a warranty end date, an insurance reference or the fact that the charger was replaced. Notes cost nothing and answer the odd questions a stranger, or you in two years, will ask.
How do you keep it up to date?
- Add the row on the day you buy, while the bill is still in your hand.
- Save the bill as a PDF named with the item and date, and note its file name in the sheet if you like.
- Once a year, walk through the list and tick off every item you can physically find.
- Fill disposal dates for anything that has gone.
If you also import your bank statement into SpendixAI, the purchase shows up there as a transaction, and you can keep the receipt with it. The register stays your own sheet, which holds the facts that a statement line does not carry.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


