Inventory tracking spreadsheet

In many SME's, a Fixed Assets Record is kept as per companies act required, for annual reporting, auditing and accounting purposes.

How do I create a fixed asset register in Excel?

Add the following columns in Excel for your Fixed asset register format:

• Asset Name
• Asset Class
• Description
• Physical Location
• Asset Number 
• Serial Number
• Acquisition Date
• Acquisition Cost
• Depreciation Method
• Useful Life (Years)  
• Salvage Value
• Previous Depreciation
• First Year %
• Depreciation 
• Period

Depreciation Method descriptions:

1. Straight-line depreciation: Calculates straight-line depreciation based on the asset's cost, salvage value, and estimated economic life.
2. "150% declining balance depreciation" Calculates 150% declining balance depreciation based on the asset's cost, salvage value, and estimated economic life. It switches to straight-line depreciation at the point when straight-line depreciation exceeds declining balance depreciation.
3. "200% declining balance depreciation" Calculates 200% declining balance depreciation based on the asset's cost, salvage value, and estimated economic life. It switches to straight-line depreciation at the point when straight-line depreciation exceeds declining balance depreciation.

We provide this Fixed Asset template in Excel format for your reference. Our accounting templates are regularly screened and used by bookkeeping and finance professionals. 

Download this Inventory tracking spreadsheet or Fixed Assets Record template directly to your hard drive.