/5afb6bea-1c9b-4684-9dd9-b180061c01e6.png)
Inventory tracking spreadsheet
How do I create a fixed asset register in Excel? Download this Inventory tracking spreadsheet or Fixed Assets Record template directly to your hard drive.
Review Rating Score
Overview
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:
- 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.
Is the content above helpfull?
Thanks for letting us know!
Reviews
Isabell Thompson(3/20/2021) - USA
I wan tto express my gratitude
Last modified
Our Latest Blog
- Writing a Great Resume: Tips from a Professional Resume Writer
- How to build accurate and compliant documents faster
- How to Create Halloween Party Invitations? 2023
- Document Editing and Creating in 2022
Related keywords
Need help?
We are standing by to assist you. Please keep in mind we are not licensed attorneys and cannot address any legal related questions.
-
Chat
Online - Email
Send a message
You May Also Like

Bank Account Closure Confirmation from Bank
Profit and Loss template

Revocation Power Of Attorney
Financial statement template

Balance Sheet Template

Accounting Spreadsheet

Charts of accounts template excel

General Ledger Excel Template

Cash Disbursement Journal
Kakeibo template

Bookkeeping template for self employed

Accounting ledger template
Auto Repair Estimate
Crypto Trading Journal Template

Diversity Statement Sample

Gift Receipt