Skip to content
The title slide and first slides of the Fixed Asset Register template

Fixed Asset Register

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
5
Difficulty
Beginner
Updated
November 16, 2026

Every slide (5)

Overview

Equipment, vehicles and furniture stay on the books for years, and each one needs a cost, an in-service date and a method for spreading that cost. The Assets tab is the register: tag, name, category, in-service date, cost, location and status. The Depreciation tab takes a salvage value and a life in years for each tag, pulls the cost and date from the register, and calculates the charge per month, the months used, the amount depreciated and the book value left.

The Summary tab charts cost, depreciation and book value category by category. Nine sample assets show a small print shop's van, printers, furniture, computers and a lobby upgrade, plus one old cutter marked sold. Months used count from today's date, so figures move forward on their own. You choose the lives and salvage values, and no tax schedule is applied.

Useful for

  • Keep an asset list for a small company's year-end
  • Show an accountant cost and book value for each category
  • Plan when a van or printer will be fully depreciated

What's included

  • 4 tabs: Assets, Depreciation, Summary, How to use
  • Assets: a table
  • Depreciation: a table with 4 summary figures
  • Summary: a dashboard with 4 summary figures
  • 1 chart that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Assets tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

How do you calculate straight-line depreciation?

Subtract the salvage value from the cost, then divide by the useful life. This register divides by the life in months and multiplies by the months the asset has been in use.

What is book value of an asset?

It is the original cost minus the depreciation recorded so far. It is an accounting figure and may differ from what the asset would sell for.

Which useful life should I use?

Use the life your accountant recommends. Tax rules often prescribe different periods from the ones used in your own books, so check IRS or CRA guidance.

  • #bookkeeping
  • #fixed-asset-register
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More bookkeeping templates

See all 6

Also in Finance

All finance templates
Get this template

Preparing your template…