/5afb6bea-1c9b-4684-9dd9-b180061c01e6.png)
Inventory tracking spreadsheet
Review Rating Score
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 template content above helpful?
Thanks for letting us know!
Reviews
Isabell Thompson(3/20/2021) - USA
I wan tto express my gratitude
Last modified
Our Latest Blog
- The Importance of Vehicle Inspections in Rent-to-Own Car Agreements
- Setting Up Your E-mail Marketing for Your Business: The Blueprint to Skyrocketing Engagement and Sales
- The Power of Document Templates: Enhancing Efficiency and Streamlining Workflows
- Writing a Great Resume: Tips from a Professional Resume Writer
Template Tags
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

Business Sheet: Manage Your Business's Total Liabilities, Assets, and Owners

Profit and Loss Statement: Bank, Business, Taxes, Total Income

Company And Financial Accounts

Journal Ledger Trial Balance Sheet

Manufacturing Company Income Statement: Operations, Income, Comprehensive Gains

Trial Balance Sheet Example

Construction Business Balance Sheet Template - Schedule, Amount, Particulars in Rupees

Net Income Trial Balance Sheet - Accounts, Office Expenses, Balance Sheet

Multi Step Income Statement For Manufacturing Company

Company Trial Balance Sheet

Simple Income Statement For Company

Multi Step Income Statement For Service Company

Net Income Trial Balance Sheet

Personal Accounts Fee Schedule

Free Household Budget Template Excel Format

Provisional Balance Sheet Format | Total Liabilities, Assets, Loans