Create a Fixed Asset Register

By Gregg Hopfeldt · 2025-05-20

A properly configured fixed asset register produces defensible records that support audit trails, depreciation calculations, and year-end reporting without manual correction.

If you are moving an existing asset list from a spreadsheet, see From Spreadsheet to Defensible Asset Register for a complete migration workflow.

The Purpose

Setting up a fixed asset register establishes a stable foundation for tracking asset values, calculating depreciation, and maintaining a consistent, audit-ready ledger that reduces risk during review.

The Logic

The register depends on three verified inputs: your financial year start date, depreciation rates by category, and asset cost prices. The opening asset balance is calculated from these inputs. The calculation logic applies the configured rate and method—either Straight Line or Diminishing/Reducing Balance—to each asset based on its category. This prevents formula drift because depreciation is derived from central settings rather than entered manually per row. Once configured, the register remains consistent across all entries, exports, and year-end rollovers. The result is a linen-clean ledger where every value traces back to a verified configuration point.

Before you start: have your financial year start date, asset list with cost prices, and depreciation rates ready. If you are importing data, prepare a CSV with headers that match your spreadsheet columns.

The Steps

Create the register

  1. Log in.
  2. Click + New Tool if you do not yet have a fixed asset register. Select the Fixed Asset Register option and select Use Tool, following our step-by-step setup guide as you go.
  3. Enter a name, and description if you want, and then click Create Tool.

Configure depreciation settings

You are now in Depreciation Tracker Setup.

  1. Enter your Start of the Financial Year. This date anchors all depreciation calculations.
  2. Set Depreciation Settings by Category for each asset type. The Rate (%) controls how much depreciation is applied. The Method lets you choose Straight Line or Diminishing/Reducing Balance.
  3. Select Save Configuration to lock in the settings.

Add your assets

Choose one of the following entry paths:

  • Smart Entry: A guided, question-based flow that ensures all required fields are completed before saving. Use this for manual entry or when you have a small number of assets to add.
  • Import CSV: A bulk-entry path for existing spreadsheets or data from another system. Use this when you have many assets with consistent columns.

Both paths write to the same Fixed Asset Register. The difference is how the data enters the system.

Verify and maintain

  1. From the home page, review the register. Apply filters to isolate categories, group rows for summary views.
  2. Use Export to create backups or external copies.
  3. Generate an audit report when you need a defensible output for review.

Close the year

At the end of the financial year, use Rollover to New Year to move into the next period. If you have disposals to record, complete those before rollover.

Common issues

  • Missing depreciation settings: Set category rates before entering assets, or depreciation may not calculate as expected.
  • Wrong financial year start date: Fix the start date in Settings before continuing. Incorrect dates affect all depreciation calculations from that point.
  • Incomplete asset cost prices: When importing historical assets, ensure purchase cost is filled in for each row. Partial rows create gaps in the register.
  • Category mismatch: Each asset inherits depreciation settings from its category. Choose the correct category during entry to apply the right rate and method.

The Outcome

A stable, verified fixed asset register with all required fields completed, depreciation calculated from consistent settings, and no ghost assets or partial rows. The ledger is quietly confident—clear, defensible, and ready for audit without last-minute correction.

For a closer look at building a register in Excel and where it tends to fail, see What's the Simplest Way to Build a Fixed Asset Register in Excel — and Where Does It Usually Break Down?.