FREE
FREE

Inventory tracking spreadsheet

Free Download

Reviews

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.
format:
Category: Accounts
language:
  • English
Type & size:
  • .xls (0.03 MB)

Overview

No ad for you

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.


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.


Reviews

Isabell Thompson - USA

I wan tto express my gratitude

No ad for you

GDPR Documents

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
No ad for you

Our Latest Blog