inventory tracking spreadsheet template

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.

FORMAT:
bizzlibrary template file type image
CATEGORY:
Accounts
DEPARTMENT:
Accounting
LANGUAGE:
English
TYPE & SIZE:
.xls (0.03 MB)

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:

  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 this 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 any other jurisdiction in which such solicitation or offer would be unlawful under the securities laws of such jurisdiction.


Reviews

Isabell Thompson(3/20/2021) - USA

I wan tto express my gratitude


Last modified

Our Latest Blog

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.