Written by Bryant Gan, Founder, Niagawan · Last updated 22 September 2026
A fixed asset register is one running list of the big things your business owns and uses to operate — vehicles, equipment, fittings, computers — showing what each item cost, how much value it has lost, and what it is worth today. It is the difference between knowing exactly what you own and guessing.
You probably went looking for this the week you spent real money on something. A delivery van, a set of POS terminals, a coffee machine, kitchen gear — an item too big to treat as a normal expense and too valuable to forget about. Then year-end arrives, or an auditor asks, or you want to claim it against tax, or a machine breaks and you need to know what it is worth: suddenly you need a proper record, not a memory.
Most guides stop at the definition. This one gives you the artifact first — a free fixed asset register template you can download and fill in today — then a worked Malaysian example in RM, and how the whole thing fits Malaysian record-keeping, capital allowances and reporting standards. 👉 Just need the file? Jump to the free template.
01. Why a growing business needs a fixed asset register
When the business is small, you carry it all in your head: the van is yours, the two laptops are yours, that is about it. The moment you buy a third laptop, add a branch, or hire someone who also buys equipment, the list stops fitting in your head — and that is when things quietly go missing or get claimed twice.
A register earns its keep at exactly the moments that cost you money. At year-end, your accountant needs to know what you own and how much value it has lost, so depreciation lands on the books correctly. For an insurance claim after a break-in or a flood, a dated list of what you owned and what it cost is your evidence. When you sell or scrap old equipment, the register tells you the value to remove. And when LHDN or a lender wants proof, you have it in one place.
Think of it as the source of truth for everything your business owns and uses to trade. Everything else — depreciation, your balance sheet, a capital allowance claim — reads from this one list.
02. What a fixed asset register is
A fixed asset register is a structured list of your fixed assets: the items you buy to use in the business over several years, not to resell. A van, an oven, shelving, a laptop, office renovation — all fixed assets. The stock you buy to sell is not; that is inventory, and it belongs on a different list.
Each row is one asset. Each column records one fact about it — what it is, when you bought it, what it cost, where it lives, how fast it loses value, and what it is worth now. Keep those rows current and you can answer almost any question about what you own in seconds.
03. What goes in a fixed asset register — every column explained
You do not need dozens of columns. A working register for a Malaysian SME needs enough to identify each asset, cost it, and track its falling value. Here is the core set, in plain terms.
| Field | What it records | Example |
|---|---|---|
| Asset ID / tag | A unique code you stick or write on the item | VAN-01 |
| Description | What it is, plainly | Toyota Hiace delivery van |
| Purchase date | When you bought it | 05 Jan 2026 |
| Supplier | Who you bought it from | UMW Toyota |
| Original cost (RM) | What you paid, before it lost any value | 60,000 |
| Location / department | Where it is, or who uses it | KL warehouse |
| Useful life | How many years you expect to use it | 5 years |
| Depreciation method | How you spread the cost (straight-line or reducing balance) | Straight-line |
| Accumulated depreciation (RM) | Total value lost so far | 12,000 |
| Net book value (RM) | Cost minus value lost = worth today | 48,000 |
| Status | In use, disposed, or written off | In use |
Give every asset a tag (VAN-01, POS-03) and write it on the item itself. When you do a physical count later, matching tags to rows takes minutes instead of an afternoon.
04. Download the free fixed asset register template
You do not have to build the columns from scratch. Download the ready-made template, fill in your assets, and you have a working register the same day — no sign-up.
- ✅ Excel version — formulas already set up for depreciation and net book value
- ✅ Word version — for a simple printed or shared register
- ✅ PDF version — clean, ready to print or attach to an audit file
- ✅ A filled example (PDF) — the Malaysian register below, worked out for you
The Excel sheet does the arithmetic for you: enter the cost, the useful life and the method, and it works out each year's depreciation and the net book value. Everything else is just typing in what you own.
05. A filled Malaysian example, in RM
Numbers make it click. Say a small distribution business buys three assets in the same year: a delivery van, a laptop for the office, and a coffee machine for the pantry. Here is how the register looks at the end of the first year (all figures are an illustrative example, using straight-line depreciation and useful lives the business chose).
| Asset | Original cost (RM) | Net book value after 1 year (RM) |
|---|---|---|
| Delivery van | 60,000 | 48,000 |
| Office laptop | 4,000 | 3,000 |
| Coffee machine | 9,000 | 7,500 |
Here is the working behind each row, so you can copy the pattern:
- Delivery van — cost RM60,000, expected to last 5 years. Straight-line means it loses the same slice each year: RM60,000 ÷ 5 = RM12,000 a year. After one year, RM12,000 is gone, so the net book value is RM48,000.
- Office laptop — cost RM4,000, expected to last 4 years. That is RM4,000 ÷ 4 = RM1,000 a year. After one year the laptop is worth RM3,000 on the books.
- Coffee machine — cost RM9,000, expected to last 6 years. That is RM9,000 ÷ 6 = RM1,500 a year, so its net book value after one year is RM7,500.
Do the same for every asset and the register always tells you the total value of what you own — RM58,500 in this example — without you having to add it up in your head.
06. How to build and maintain your register, step by step
Starting one is a single afternoon of work, and keeping it current is a few minutes a month.
- List what you already own. Walk through the business and note every item worth keeping track of — anything you use for more than a year and paid a meaningful amount for.
- Fill in the cost and dates. Pull the figures from the purchase invoice for each item. The invoice is where the original cost and purchase date come from.
- Pick a useful life and method. Decide how many years each asset will realistically serve and whether you will use straight-line or reducing balance (more on that next).
- Tag each asset. Give it an ID, write the tag on the item, and record where it lives.
- Update it when something changes. Add new purchases as they happen, run depreciation at year-end, and mark anything sold, scrapped or lost as disposed.
- Count the assets once a year. Walk the list against the real items — a "stock-take of assets." It catches the equipment that quietly walked out the door.
A register you never update is worse than none — it gives false comfort. Set a recurring reminder to add new assets and remove disposed ones, or it drifts out of date within months.
07. Depreciation and net book value — how the numbers move each year
Most fixed assets lose value as they age and get used — a five-year-old van is worth less than a new one. Depreciation is simply how you record that fall in value, spread across the years you use the asset instead of all at once. Net book value is what is left: the original cost minus all the depreciation to date.
There are two common methods. Straight-line takes the same amount off every year — easy to plan, and what the example above uses. Reducing balance takes a percentage of the remaining value each year, so it falls faster early and slower later. Pick one per asset and stay consistent; your accountant can advise which fits each type of asset. Depreciation is also where the register meets your accounts: it shows up as an expense on your profit and loss statement, and the net book value is what appears on your balance sheet.
08. Is a fixed asset register required in Malaysia?
There is no single law that says "thou shalt keep a spreadsheet called a fixed asset register." But the obligations behind it are real, which is why nearly every organised business keeps one.
Under the Companies Act 2016, companies must keep proper accounting records — and you cannot show the value of what you own, or the depreciation on it, without tracking your assets somewhere. SSM (the Companies Commission of Malaysia) oversees that record-keeping duty. Separately, LHDN (the Inland Revenue Board) allows capital allowances on qualifying plant and machinery — the tax relief you claim as assets are used — and a clean register is your evidence for what you bought and when. And MPERS (the Malaysian Private Entities Reporting Standard), set by the MASB, is the framework that governs how property, plant and equipment and their depreciation are reported. A register is what feeds all three.
A practical rule of thumb: if you would struggle to prove what you own and what it is worth in an audit or a claim, you need a register — regardless of your size.
09. Fixed asset register vs a plain asset list vs stock
These three get mixed up, and mixing them up leads to double-counting. A plain asset list is just names — "van, laptop, coffee machine." A fixed asset register is that list plus the money: cost, value lost, and worth today, so it can drive your accounts. Stock (inventory) is different again: goods you bought to sell, not to use. A café's coffee machine is a fixed asset; the coffee beans it brews are stock, and they belong in your inventory records, not here.
One more thing that sends people searching: big platforms like SAP and Xero have a fixed-asset module built in. That is the same idea as the register in this article, just inside their software — you still record the same fields. If you are not on one of those, the free template does the job just as well.
Record the purchase once, see it everywhere
- Record an asset purchase straight from its purchase invoice
- Set up fixed-asset accounts in your chart of accounts
- See your assets flow through to reports and the balance sheet
10. Keeping your register and your accounts in sync with Niagawan
The register above lives happily in a spreadsheet. The place it connects to is your books — because every asset started as a purchase, and every year of depreciation is an entry in your accounts. Keeping the two in sync by hand is where errors creep in.
With Niagawan — cloud accounting built for Malaysian SMEs — you record the asset purchase straight from the purchase invoice or expense, set up dedicated fixed-asset accounts in your chart of accounts, and then see those assets flow through to your financial reports and balance sheet. Post your depreciation entries each year and the value on your accounts stays honest. Because it is cloud, you can pull up what you own from any device — the warehouse, a supplier's office, or home. Keep the detailed register in the free template, and let Niagawan carry the purchases and the accounting entries that go with it.
For teams ready to move off spreadsheets entirely, Niagawan Plus is RM 497 / year and includes financial reports, AR/AP aging, digital invoicing and bank reconciliation. It is the same system trusted by 40,000+ Malaysian businesses since 2016 — a decade of building for local SMEs, rated 4.7★ across 500+ reviews. Your fixed asset register is one small part of running clean books; Niagawan is where the rest of them live. See how Niagawan works for SMEs.
Frequently asked questions
What is in a fixed asset register?
It lists each asset you own with a unique tag, a description, the purchase date and supplier, the original cost, its location, the depreciation method and useful life, the value lost so far, and its net book value today. One row per asset, one fact per column.
How do I create a fixed asset register?
List everything you own that lasts more than a year, pull each item's cost and date from its purchase invoice, give it a tag, choose a useful life and depreciation method, then update it whenever you buy, sell or scrap an asset. The free Excel template gives you every column ready to fill in.
Is a fixed asset register mandatory in Malaysia?
No single rule names it, but the Companies Act 2016 requires companies to keep proper accounting records, LHDN expects evidence for capital allowance claims, and MPERS governs how assets and depreciation are reported — all of which a register supports. In practice, any organised business keeps one.
What is the difference between a fixed asset register and an asset list?
An asset list is just the names of what you own. A fixed asset register adds the money — cost, depreciation and net book value — so it can feed your accounts, your balance sheet and a capital allowance claim.
Can I keep a fixed asset register in Excel?
Yes. Excel is the most common way small businesses run one, and the free template here comes with the depreciation and net book value formulas already set up. You only type in what you own.
What is net book value?
Net book value is what an asset is worth on your books today: its original cost minus all the depreciation recorded against it so far. A RM60,000 van that has lost RM12,000 in value has a net book value of RM48,000.
How often should I update my fixed asset register?
Add new purchases as they happen, run depreciation at least once a year at year-end, and mark disposals immediately. A quick monthly check keeps it from drifting out of date, and a yearly physical count confirms the items still exist.
Do I still need a register if my assets are in my accounting software?
The register and your accounts answer different questions — the register tracks each physical item and its worth, while the accounts summarise the totals. Keeping the detailed register alongside your books, and recording the purchases and depreciation entries in software like Niagawan, gives you both.