Inventory tracking spreadsheet
- .xls (0.03 MB)
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
- Physical Location
- Asset Number
- Serial Number
- Acquisition Date
- Acquisition Cost
- Depreciation Method
- Useful Life (Years)
- Salvage Value
- Previous Depreciation
- First Year %
Depreciation Method descriptions:
- Straight-line depreciation: Calculates straight-line depreciation based on the asset's cost, salvage value, and estimated economic life.
- "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.
- "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.
The Content is for informational purposes only, you should not construe any such information or other material as legal, tax, investment, financial, or other advice. Nothing contained on our Site constitutes a solicitation, recommendation, endorsement, or offer by Bizzlibrary or any third party service provider to buy or sell any securities or other financial instruments in this or in in any other jurisdiction in which such solicitation or offer would be unlawful under the securities laws of such jurisdiction.
Isabell Thompson - USA
I wan tto express my gratitude
Is your organisation GDPR proof? Demonstrate your efforts in order to become compliant with the GDPR with this set of mandatory compliance document templates.
Learn More About GDPR Documents