Most growing companies know exactly what stock they hold, but far fewer can answer a simple audit question: which laptops, vehicles and machines do we own, where are they, and what is their book value today? The fixed asset register often lives in a spreadsheet that finance updates once a year, and depreciation is posted as one manual journal entry at year end.
ERPNext fixed asset management replaces that spreadsheet with a register that is linked to purchases, accounts and locations. Each asset gets its own record, its depreciation schedule is calculated automatically, and every movement, repair, sale or write-off creates the right accounting entry. This guide walks through the setup the way we do it on implementation projects, for companies in India and the GCC. It is based on ERPNext v15 and v16, so field names may differ slightly on older versions.
Key takeaways
- Start with Asset Categories. They hold the fixed asset, accumulated depreciation and depreciation expense accounts, plus default useful life and method.
- Use CWIP accounting for assets that are built or installed over time, then capitalise when they are ready to use.
- Finance books let you run two depreciation schedules on the same asset, for example a Companies Act book and an income-tax book in India.
- Every event posts to accounts: depreciation, value adjustment, sale and scrapping all create GL entries, so the register and the balance sheet stay in step.
Is your fixed asset register still in Excel?
Send us your current register. In a free 30-minute call we will show how it maps to ERPNext asset categories and depreciation schedules.
Review my asset register → WhatsApp us: +91 8089051848
Or email info@nexeves.com
How ERPNext models a fixed asset
In ERPNext an asset is a document of its own, linked to an Item that is marked as a fixed asset. The item tells ERPNext what was bought (for example "Dell Latitude laptop" or "Forklift 3 tonne"); the asset record tells it which specific unit you own, where it is, who holds it and how it is being depreciated.
| Document | What it does |
|---|---|
| Item (Is Fixed Asset = Yes) | The type of asset, linked to an Asset Category. Purchased through normal Purchase Orders and Purchase Receipts or Invoices. |
| Asset Category | Default accounts, depreciation method, useful life and frequency, per company and finance book. |
| Asset | One record per asset (or per group if you choose). Holds purchase date, gross value, location, custodian and the depreciation schedule. |
| Asset Depreciation Schedule | The calculated schedule of depreciation entries. In recent versions it is a separate document that is versioned when values change. |
| Asset Movement | Transfers between locations or employees, and issue or receipt from custodians. |
| Asset Repair / Asset Maintenance | Repair cost, downtime and planned maintenance tasks, with an option to capitalise repair cost. |
| Asset Value Adjustment | Revaluation or impairment that changes the book value and future depreciation. |
| Asset Capitalization | Combines stock items, services and existing assets into a new asset, or moves CWIP into a finished asset. |
Step 1: Prepare the chart of accounts
Before you touch assets, check that the chart of accounts has, for each asset class, a fixed asset account, an accumulated depreciation account and a depreciation expense account. You also need a gain or loss on disposal account and, if you build assets over time, a capital work in progress account. If your chart was imported from Tally or another system, these may exist under different names. Our guide to the ERPNext chart of accounts explains the account types to use.
Then open Company and set the default accounts in the asset section: accumulated depreciation, depreciation expense, gain or loss on disposal, CWIP and the depreciation cost centre. These defaults are used when a category does not override them.
Step 2: Create asset categories that match your policy
Asset categories should mirror the classes in your accounting policy and your auditor's schedule, not the way the purchase team names things. A typical mid-sized company needs between six and twelve:
| Category | Typical method | Notes |
|---|---|---|
| Buildings | Straight line | Land is usually not depreciated, so keep it in its own category without depreciation |
| Plant and machinery | Straight line or WDV | Use component categories if major parts have different lives |
| Furniture and fixtures | Straight line | |
| Computers and IT equipment | Straight line | Short life; consider a capitalisation threshold for low-value items |
| Vehicles | Straight line or WDV | Track registration number and insurance expiry in custom fields |
| Office equipment | Straight line | |
| Leasehold improvements | Straight line over the shorter of lease term and useful life | Common for GCC showrooms and offices |
In each category, set the accounts per company and add one row per finance book with the depreciation method, total number of depreciations and frequency in months. These are only defaults: you can change them on an individual asset.
The methods available are Straight Line, Double Declining Balance, Written Down Value (where you can enter the rate) and Manual. Your accountant decides which method and life apply to which class; ERPNext simply calculates the schedule.
Step 3: Decide whether you need two finance books
A finance book is a separate set of depreciation values for the same asset. You need it when the law or your group requires two views:
- India: companies usually depreciate under Schedule II of the Companies Act in the books, while income tax depreciation is calculated on blocks of assets at prescribed WDV rates. Many companies keep the tax computation outside the ERP. If you prefer to keep it inside, create a second finance book for tax and report it separately. Ask your CA which rates and block rules to apply.
- UAE and Saudi Arabia: books are generally kept under IFRS. A second book is useful when a parent company reports under a different policy or useful life.
- Groups: a management book can use different lives from the statutory book, for internal reporting.
Keep it simple if you can. One book is easier to audit, and you can always add a second later for new assets.
Step 4: Buy and capitalise assets
New assets follow the normal purchase cycle: purchase order, purchase receipt and purchase invoice. When the item is a fixed asset and the category has Auto create assets on purchase enabled, ERPNext creates draft asset records on the receipt or invoice. Finance then reviews each draft, fills in location, custodian and available-for-use date, and submits it.
Two settings change how the purchase posts:
- Without CWIP: the purchase debits the fixed asset account directly. Use this for ready-to-use items like laptops and furniture.
- With CWIP accounting enabled on the category: the purchase debits capital work in progress. When the asset is ready, you submit the asset (or an Asset Capitalization) and ERPNext moves the value from CWIP to the fixed asset account. This suits machinery that needs installation, a new factory line or a fit-out that runs over several months.
Freight, installation and duty that are part of the asset cost can be added with a landed cost voucher or through Asset Capitalization, so the capitalised value is complete.
Tax note. In India, input GST on many capital goods can be claimed, while some items such as certain motor vehicles are blocked. In the UAE and Saudi Arabia, VAT on most business assets is recoverable, with exceptions such as some vehicles and entertainment. The tax template on the purchase invoice controls this. Confirm the treatment with your tax adviser; see our GST setup guide and UAE VAT guide.
Need the asset import template?
We will share the asset category and opening asset import sheet we use on projects, with notes on accumulated depreciation.
Send me the template → WhatsApp us: +91 8089051848
Or email info@nexeves.com
Step 5: Load your existing asset register
Most companies do not start from zero. To migrate existing assets:
- Clean the spreadsheet first: one row per asset, with category, purchase date, gross purchase amount, accumulated depreciation to the cut-off date and remaining life.
- Create assets with Is Existing Asset ticked. Enter the opening accumulated depreciation and the number of depreciations already booked.
- ERPNext then calculates the remaining schedule from the cut-off date. It does not post the past depreciation again.
- Post the opening balances of fixed asset and accumulated depreciation accounts through your opening journal, and check that they equal the register totals.
- Run the Fixed Asset Register report and tie it to the trial balance before you go live.
Use the Data Import tool for anything more than a few dozen assets. Our post on zero-error data migration covers the checks we run.
Step 6: Post depreciation every month
Each submitted asset has a schedule with planned dates and amounts. When Book Asset Depreciation Entry Automatically is enabled in Accounts Settings, a scheduled job posts journal entries for the due rows. You can also post them manually from the schedule. Either way:
- Depreciation is posted to the expense account and cost centre from the category, so branch or department P&L includes its share.
- If a period is closed, entries for it will not post. Run depreciation before you close the month; it is one of the steps in our month-end close checklist.
- Pro-rata depreciation for the first period depends on the available-for-use date and the daily pro-rata setting. Agree the policy with your auditor and set it once.
Step 7: Movement, custody and maintenance
Use Asset Movement when an asset moves between locations or employees, for example a laptop issued to a new joiner or a generator moved from Kochi to Kozhikode. The asset keeps its history, so you can answer "who had this machine in March?". Custom fields for serial number, warranty end date, insurance policy and vehicle registration are easy to add. See custom fields and workflows.
Asset Maintenance lets you plan recurring tasks such as servicing a forklift every 250 hours or calibrating a weighing scale every six months, and assign them to a team. Asset Repair records the cost and downtime of breakdowns; if a repair extends the life or value, it can be capitalised and the schedule recalculated.
Step 8: Revalue, sell or scrap
| Event | How to record it | Accounting effect |
|---|---|---|
| Impairment or revaluation | Asset Value Adjustment | Changes the book value and the remaining schedule |
| Sale | Sales Invoice with the asset selected on the item row | Removes cost and accumulated depreciation, posts gain or loss on disposal, applies output GST or VAT |
| Scrap or write-off | Scrap Asset action on the asset | Removes the asset and books the loss |
| Return to supplier | Purchase return, then cancel or adjust the asset | Reverses the purchase |
ERPNext posts depreciation up to the disposal date before it calculates the gain or loss, so you do not need a separate entry.
Reports auditors ask for
- Fixed Asset Register: every asset with gross value, accumulated depreciation and net book value, filterable by category, location, company and finance book.
- Asset Depreciations and Balances: opening, additions, disposals, depreciation and closing by category, which is close to the schedule notes in the financial statements.
- Asset Depreciation Ledger: each depreciation entry posted.
- General Ledger for the fixed asset and accumulated depreciation accounts, to tie the register to the balance sheet.
Because every change creates a document with a user and timestamp, the trail auditors look for is already there. More on that in how ERPNext keeps audit-ready data.
Common mistakes we fix
- Assets booked as expenses because the item was not marked as a fixed asset. Set the asset category on item groups that are always capital.
- Depreciation posted twice during migration, once in the opening journal and again by the schedule. Use "Is Existing Asset" correctly.
- Unsubmitted draft assets sitting for months after a purchase, so depreciation never starts. Add a weekly report of drafts.
- One asset record for 200 chairs when you need to track them separately, or 200 records when one group would do. Decide per category.
How Nexeves Technologies helps
We set up categories, finance books, CWIP and automatic depreciation, migrate your opening register and reconcile it to the trial balance before go-live. If you are moving off Tally or spreadsheets, this is usually a week of work inside a wider ERPNext implementation.
Frequently asked questions
Does ERPNext support fixed asset management?
Yes. ERPNext has an Assets module with asset categories, depreciation schedules, movement, maintenance, repair, value adjustment, capitalisation, sale and scrapping, all linked to accounts.
Which depreciation methods are available in ERPNext?
Straight Line, Double Declining Balance, Written Down Value with a rate you enter, and Manual. The method is set per asset category and finance book and can be changed on an asset.
Can ERPNext keep separate depreciation for books and income tax?
Yes, with finance books. Each asset can carry a separate schedule per finance book, for example a Companies Act book and a tax book in India. Many companies still calculate tax depreciation outside the ERP, so agree the approach with your CA.
How do I migrate existing assets into ERPNext?
Import them with Is Existing Asset ticked, entering the opening accumulated depreciation and the depreciations already booked. ERPNext then schedules only the remaining depreciation. Reconcile the register to the trial balance before go-live.
What is CWIP accounting in ERPNext?
Capital work in progress accounting records purchases for an asset that is not yet ready to use in a CWIP account. When the asset is ready, it is capitalised and the value moves to the fixed asset account.
Is depreciation posted automatically?
It can be. When automatic depreciation posting is enabled in Accounts Settings, a scheduled job creates journal entries for due schedule rows. You can also post them manually.
Clean asset books before your next audit
Nexeves Technologies configures ERPNext assets, finance books, CWIP and depreciation posting for companies in India and the GCC, and migrates your opening register.
Book a free demo → WhatsApp us: +91 8089051848
Or email info@nexeves.com
Nexeves Technologies serves India & the GCC: UAE (Dubai, Abu Dhabi), Saudi Arabia (Riyadh, Jeddah), Qatar (Doha), Kuwait and Bahrain.
No comments yet. Login to start a new discussion Start a new discussion