Fixed assets are assets that a business buys for long-term use. They are unlikely to be converted into cash soon. They include things such as land, buildings and equipment. A company or an individual must monitor their fixed assets and know how their value changes over time. This helps you manage the assets and know when they are no longer useful.
A fixed asset register can help here. This document records the physical or fixed assets of a business, along with details about them, such as their quantity, value, location and status.
Fixed Asset Register Template
Keep a record of the fixed assets of your business in three steps. Enter the name of the business, its contact details and the period that the register covers, then add each asset with its quantity, cost, date of purchase, location, serial number, depreciation method and depreciation rate. The tool works out the total cost of each line, the depreciation up to the end of the period and the net book value. Check the live preview, then print the register or save it as a PDF, or download it as an Excel or Word file. Your entries stay in your browser and are not sent anywhere.
Business and Period
The depreciation is worked out from the date of purchase up to the end of the period, month by month.
Fixed Assets
Enter the cost of one item. The tool multiplies it by the quantity. For straight-line depreciation, the yearly cost is the total cost multiplied by the rate. For reducing balance, the rate is applied to the value that is left each year. Land is usually not depreciated, so choose None.
Columns and Print Settings
A fixed asset register is important because it gives a company key details about its fixed assets. The company knows how many fixed assets it owns and what they are worth. It can also work out the depreciation over time, so it can plan effectively when to dispose of an asset. When a company knows these details, it can make the most of each fixed asset.
The register lists each fixed asset and notes its quantity and cost. It records the date on which the asset was bought and the location of the asset. In general, all the relevant details about the fixed asset are included.
Benefits of a Fixed Asset Register
The following are some advantages of a fixed asset register.
- When you maintain the register, you have all the important details about your fixed assets in one place, such as their location, usage, maintenance expenses and life cycle.
- When you know the details of the fixed assets, you can make informed decisions about how to use them.
- You will know when it is time to dispose of a fixed asset.
- The security of the fixed assets improves, because you know where they are and whether they are working.
- You can see when the asset was bought and how long it has worked. This gives you an idea of how well it performs. You can also estimate its expected life cycle, which helps you predict future maintenance expenses.
- You can keep proper track of depreciation, because you can work out the real value of the asset.
Points to Keep in Mind
- Some people may find it time-consuming and hectic to record details in the register in real time. Practice makes this easier.
- Any error, such as a human error, can make the register useless, so pay attention when you enter data.
How to Make a Fixed Asset Register
The following points can help you make a fixed asset register.
Format of the register
This professional document needs to be simple to use. The heading can be “Fixed Asset Register”. You can add the name of the business and its contact details. You can also note the period that the register covers. Add the details of the fixed assets in a table.
Make a table
Include a column for the item, with the name of the fixed asset, and a column for the quantity. Add a column for the cost of the asset and a column for the date of purchase.
Include a column for the location of the asset. If applicable, add a column for the serial number. You can also add a column for the depreciation method, another for the depreciation rate, and a column for notes.
Avoid extra details
Add only what is important, so that the fixed asset register is easy to fill in and people actually use it.
A fixed asset register helps you keep a detailed and understandable record of the fixed assets of your company, so that you can manage them properly.
See the Excel template below.
