Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesFinanceAccounting & BookkeepingFixed Asset Register with Depreciation

SpreadsheetAccounting & BookkeepingFree

Fixed Asset Register with Depreciation

Every asset with cost, useful life, straight-line depreciation to date and net book value.

Shown with sample data

Colour

Fixed Asset Register with Depreciation

Every asset with cost, useful life, straight-line depreciation to date and net book value.

Cost of assets in use
$98,700
Net book value
$50,956
Depreciation this year
$12,417
Fully depreciated
1
Net book value by category
  • Machinery$20,467
  • Vehicles$16,389
  • Leasehold improvements$9,900
  • Furniture$3,267
  • Computers$933
Share of net book value by category
  • Machinery$20,46740%
  • Vehicles$16,38932%
  • Leasehold improvements$9,90019%
  • Furniture$3,2676%
  • Computers$9332%

How to use it

  1. 1Add each asset with its cost and the date it went into use.
  2. 2Set a useful life in years and a salvage value (often zero).
  3. 3Mark assets Disposed when sold or scrapped.
  4. 4Use the totals by category for your accounts.

In this workbook

  • About
  • What’s included
  • How to use
  • Questions
  • Related resources

About this template

Know what the business owns and what it is worth on the books. Record each asset’s cost, purchase date, useful life and salvage value; the register calculates annual and accumulated straight-line depreciation and the net book value today, and flags assets that are fully depreciated or disposed of.

Who it’s for

  • Year-end accounts and audits
  • Insurance schedules
  • Planning replacements

What’s included

  • Assets sheet: One row per asset.
  • Summary by Category sheet: Net book value and Cost and the number of entries for each category, calculated from the Assets sheet.

How to use it

  1. 1Add each asset with its cost and the date it went into use.
  2. 2Set a useful life in years and a salvage value (often zero).
  3. 3Mark assets Disposed when sold or scrapped.
  4. 4Use the totals by category for your accounts.

Questions

Which method is used?

Straight line: (cost − salvage) ÷ useful life, charged for each full month in use.

Related searchesfixed asset registerdepreciation schedulestraight line depreciationnet book valueasset tracking

Details

Format
Spreadsheet
Category
Accounting & Bookkeeping
Sheets
2
Setup
10 min
Level
Beginner
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetAccounting & BookkeepingFree

Fixed Asset Register with Depreciation

Every asset with cost, useful life, straight-line depreciation to date and net book value.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Accounting & Bookkeeping
Sheets
2
Setup
10 min
Level
Beginner
Price
Free

Your copy is private to you.

More accounting & bookkeeping templates

View all
General Ledger2 sheets

Total debits

$19,020

Total credits

$19,020

Out of balance

$0

ABCD
1Entry no.DateAccountDescription
2J-001Nov 1BankOwner investment
3J-001Nov 1Owner equityOwner investment
4J-002Nov 2EquipmentLaptop and printer
5J-002Nov 2BankLaptop and printer
Journal
SpreadsheetBookkeeping

General Ledger

A double-entry journal with account totals, a running check that debits equal credits and balances by account type.

10 min setupPreview
Invoice Tracker2 sheets

Outstanding

$9,940

Overdue

$8,690

Average days to pay

15

ABCD
1InvoiceClientSentDue
21001Harbor LogisticsSep 15Sep 29
31002Northwind StudioSep 22Oct 6
41003BluepeakSep 30Oct 14
51004Juniper & CoOct 8Oct 22
Invoices
SpreadsheetBilling & Receivables

Invoice Tracker

Every invoice you have sent with due dates, payments received, days late and who to chase.

10 min setupPreview
Accounts Receivable Aging Report2 sheets

Total outstanding

$47,805

Overdue

$31,455

Over 60 days

$12,680

Balance by age
$17k
$16k
$11k
$2,150
$1,980
1-30Current61-9031-6090+
SpreadsheetAccounting & Bookkeeping

Accounts Receivable Aging Report

Open invoices aged into current, 1-30, 31-60, 61-90 and 90+ days, with collection priority and next steps.

10 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ