Asset Register

About this template

When to use it

An asset register with a summary page in front. Three sheets — Dashboard, Input data, Usage guide — and only Input data takes typing.

What the dashboard holds

Every figure on the Dashboard is a formula. The top block, “Key metrics — summed automatically from the ‘Input data’ sheet”, holds four cells in B7:E7 — Rows entered, Total acquisition cost, Average acquisition cost, Highest acquisition cost — and they update the moment you type. Below it, Summary by department (rows 12–16) breaks the same data down by the five department names sitting in column B, and Trend over time (rows 20–25) is hand-typed book values with a total and an average under them.

Filling order

1. Rows 2–21 of Input data take Asset No., Asset name, Acquired on, Department, Location, Acquisition cost, Status, Notes in columns A–H. Six sample rows ship filled in; the rest are blank.
2. Column F must contain numbers only. The count, total, average and maximum read that column alone; anything typed as “KRW 1,680,000” is text and drops out of every one of them.
3. Keep the Status wording to the four values in note 6 of the Usage guide — In use, Under repair, Idle, Disposed.
4. The department names in B12:B16 of the Dashboard (Corporate Planning Team, General Affairs Team, Infrastructure Team, R&D Center, Sales Team) are matched as text against column D. Rename a department and you must change it in both places, or its row reports zero.
5. Replace the trend rows B20:C23 (Book value 2023–2026, 148 · 132 · 119 · 103) with your own figures, and rename the C19 header to state the unit.

How the formulas calculate

• Rows entered =COUNT(‘Input data’!$F$2:$F$21) — numeric cells only.
• Total =SUM(‘Input data’!$F$2:$F$21), average =IFERROR(AVERAGE(‘Input data’!$F$2:$F$21),0), maximum =IFERROR(MAX(‘Input data’!$F$2:$F$21),0) over the same range.
• Each department row pairs =COUNTIF(‘Input data’!$D$2:$D$21,$B12) with SUMIF and AVERAGEIF over the cost column, and a share of =IFERROR(C12/COUNT(‘Input data’!$F$2:$F$21),0) — note that the share is a share of the row count, not of the money.
• Under the trend table, =SUM(C20:C23) and =AVERAGE(C20:C23) — 502 and 125.5 with the shipped values.
• The ranges stop at row 21, so row 22 onwards is invisible to every formula. Past 20 assets, copy the last row down and widen the $F$21 and $D$21 references on the Dashboard.

Examples

• Row 2 — A-2026-001 · Laptop, 14-inch · 2026-01-12 · Corporate Planning Team · HQ 3F · 1680000 · In use · Lease ends 2029-01.
• Twenty assets totalling KRW 420m make the key metrics read 20, 420,000,000 and an average of 21,000,000.
• Leaving 148 → 132 → 119 → 103 in the trend table reads as four years of depreciation.

Common mistakes

• Typing units or commas into the Acquisition cost column so COUNT and SUM ignore it.
• Mixing two spellings of a Status value and breaking later filters.
• Leaving a department in B12:B16 that no longer appears in column D, so its row quietly shows zero.
• Typing over B7:E7 and destroying the formulas — note 3 on the Usage guide sheet forbids exactly this.