Fixed Asset Register: Template, Fields and What to Record

Quick answer: A fixed asset register is a list of every long-term asset your business owns, with its ID, description, cost, purchase and in-service dates, location, depreciation method, useful life, accumulated depreciation and net book value. Update it when assets are bought, moved or sold, and reconcile its totals to your balance sheet at each close.

If you have ever struggled to answer "what equipment do we actually own, and what is it worth?", a fixed asset register solves that problem. It is one of the simplest accounting records to set up and one of the most useful at tax time, during an insurance claim or when you sell the business. The supplier invoices you receive are the raw material for it, and the invoices you issue when you sell an asset close each entry out. If you invoice clients for your own work, our free invoice generator handles that side; this guide covers the asset side.

Below you will find what to record, a ready-to-copy fixed asset register template layout, a step-by-step setup process, a fully worked example with depreciation and a disposal, and the common mistakes that make registers drift away from the books.

What is a fixed asset register?

A fixed asset register (sometimes called an asset ledger or capital asset register) is a detailed schedule of the tangible, long-lived assets a business uses to earn income: computers, machinery, vehicles, furniture, tools, fit-outs and similar items expected to last more than a year. It sits behind the single "property, plant and equipment" line on your small business balance sheet.

The register does three jobs:

• Proof of ownership and cost. Each row ties back to a purchase invoice, so you can show what you paid and when.
• Depreciation engine. It is where annual or monthly depreciation is calculated, which then flows into your profit and loss statement and reduces operating income.
• Control. It tells you where each asset is and who is responsible, which reduces loss, theft and duplicate purchases.

The register's total cost and total accumulated depreciation should always agree with the matching accounts in your general ledger. If they do not, one of the two records is wrong.

What to record in a fixed asset register

Top-ranking templates agree on a core set of fields. The table below lists them, why each one matters and an example entry.

Field	Why it matters	Example
Asset ID	Unique reference for tags, audits and journals	FA-003
Description and category	Groups assets for depreciation and reporting	Delivery van, vehicles
Serial number, make, model	Identifies the exact item for insurance and theft reports	VIN or serial
Supplier and invoice number	Links the asset to its source document	Invoice 55120
Purchase date and in-service date	Depreciation usually starts when the asset is ready and available for use	2026-06-20 / 2026-07-01
Cost (capitalized amount)	Price plus delivery, installation and setup needed to get it working	$28,000
Location and custodian	Physical control and accountability	Warehouse, J. Ortiz
Depreciation method, useful life, salvage value	Drive the depreciation calculation	Straight-line, 5 years, $4,000
Accumulated depreciation	Total depreciation charged to date	$2,400
Net book value	Cost minus accumulated depreciation	$25,600
Condition and last check date	Flags impairment, repairs and replacement planning	Good, checked 2026-12-31
Disposal date, proceeds, gain or loss	Closes the asset out correctly	Blank until sold

What counts as cost

Capitalize the purchase price plus costs needed to get the asset ready for use: delivery, installation, non-refundable taxes and professional setup. Ongoing costs such as repairs, servicing and insurance are normally expensed, not added to the asset. If a supplier's invoice mixes the two, split the lines when you enter it. The purchase invoice is your evidence of cost, so keep a copy with the register.

Capitalization threshold

Not every purchase belongs in the register. Set a written capitalization threshold and stick to it. In the US, many small businesses use the de minimis safe harbor in the tangible property regulations: as of 2026, a business without an applicable financial statement can elect to expense items costing up to $2,500 per invoice or item, and a business with one can use up to $5,000, per the IRS tangible property regulations guidance. The election is made each year with the return. Items under your threshold are expensed and usually stay off the register.

Fixed asset register template layout

A spreadsheet is enough for most small businesses. Use one row per asset and these columns, in this order:

Asset ID | Description | Category | Serial no. | Supplier | Invoice no. | Purchase date | In-service date | Cost | Salvage value | Useful life (years) | Method | Annual depreciation | Accumulated depreciation | Net book value | Location | Custodian | Condition | Disposal date | Proceeds | Gain/(loss)

Three formulas do most of the work:

• Annual depreciation (straight-line) = (Cost minus Salvage value) divided by Useful life.
• Accumulated depreciation = Annual depreciation multiplied by years (or months divided by 12) in service to date.
• Net book value = Cost minus Accumulated depreciation.

Keep a separate tab per year, or add a column per year for depreciation, so you can see how each asset's value moved over time. If you want help choosing a depreciation method, our guide on how to calculate depreciation compares straight-line, declining balance and units of production.

How to set up a fixed asset register in 7 steps

1. Gather source documents. Pull purchase invoices, receipts, lease agreements and last year's balance sheet. Your expense tracking system is the fastest place to find them.
2. Do a physical walk-through. List every item you can see that costs more than your threshold. Note serial numbers and locations.
3. Match items to invoices. Each asset should have one source document. Items with no invoice need a note explaining how the cost was established.
4. Assign asset IDs and tag items. Use a simple sequence such as FA-001, FA-002. A printed label or engraved tag on the asset makes audits quick.
5. Set depreciation policies by category. Decide the method, useful life and salvage value for each category (for example, computers 3 years, furniture 7 years) and apply them consistently.
6. Calculate depreciation to date. For existing assets, work out accumulated depreciation from the in-service date to today.
7. Reconcile to the ledger. Total cost and accumulated depreciation in the register must match the fixed asset and accumulated depreciation accounts in your chart of accounts. Investigate any difference before you rely on the register.

Worked example: a three-asset register for one year

A small video production studio uses straight-line book depreciation with a monthly convention (depreciation starts in the month the asset is placed in service). In 2026 it acquires three assets.

ID	Asset	In service	Cost	Salvage	Life	Annual dep.	Months in 2026	2026 dep.	NBV 31 Dec 2026
FA-001	Camera kit	1 Mar 2026	$6,000	$600	5 yrs	$1,080	10	$900	$5,100
FA-002	Office furniture	1 Jan 2026	$4,200	$0	7 yrs	$600	12	$600	$3,600
FA-003	Delivery van	1 Jul 2026	$28,000	$4,000	5 yrs	$4,800	6	$2,400	$25,600
	Total		$38,200					$3,900	$34,300

Check the arithmetic:

• Camera kit: ($6,000 minus $600) divided by 5 = $1,080 a year, or $90 a month. Ten months = $900. NBV = $6,000 minus $900 = $5,100.
• Furniture: $4,200 divided by 7 = $600 a year. Twelve months = $600. NBV = $3,600.
• Van: ($28,000 minus $4,000) divided by 5 = $4,800 a year, or $400 a month. Six months = $2,400. NBV = $25,600.
• Totals: $38,200 cost minus $3,900 depreciation = $34,300 net book value, which matches the sum of the three NBVs ($5,100 + $3,600 + $25,600).

That $3,900 is a non-cash expense that lowers profit, which matters when you calculate net income. The year-end journal is a $3,900 debit to depreciation expense and a $3,900 credit to accumulated depreciation, following normal double-entry bookkeeping rules.

Recording a disposal

Suppose the studio sells the camera kit on 28 February 2028 for $3,000. Accumulated depreciation by then is $900 (2026) + $1,080 (2027) + $180 (two months of 2028) = $2,160. Net book value is $6,000 minus $2,160 = $3,840. Proceeds of $3,000 are $840 below book value, so the register records a loss on disposal of $840. The row stays in the register, marked "disposed 2028-02-28", with the proceeds and the reference to the sales invoice you issued to the buyer. If you need to bill the buyer, the US invoice generator creates a clean sale invoice in a minute.

Book depreciation vs tax depreciation

The example above uses book depreciation, which spreads cost over the asset's useful life for your financial statements. Tax depreciation can be very different. In the US, IRS Publication 946 sets out MACRS recovery periods, and as of 2026 it gives a Section 179 deduction limit of $2,560,000, reduced once qualifying property placed in service in the year exceeds $4,090,000 (see IRS Publication 946, How to Depreciate Property). Bonus depreciation can also accelerate deductions.

Because the two numbers often diverge, either keep separate book and tax columns in your register or let your accountant maintain a tax depreciation schedule alongside it. Our comparison of Section 179 vs bonus depreciation explains the tax options in more depth. This article is general information, not tax or legal advice.

Keeping the register accurate

Registers rarely fail on day one. They drift. These habits keep yours reliable:

• Add assets when the invoice is approved, not at year-end. Build it into your accounts payable process: any invoice coded to a fixed asset account triggers a new register row.
• Post depreciation at every close. Monthly is ideal if you produce monthly accounts; it is a standard item on any month-end close checklist.
• Record transfers and upgrades. If an upgrade extends an asset's life or capacity, capitalize it as a separate line or adjust the asset's cost and remaining life.
• Count once a year. A physical check finds "ghost assets" that were scrapped or stolen but are still on the books.
• Never delete rows. Mark disposals and keep them. Deleted rows break the audit trail.

How long to keep fixed asset records

Asset records outlive most other paperwork. The IRS says to keep records relating to property until the period of limitations expires for the year in which you dispose of the property, because you need them to calculate depreciation and the gain or loss on sale (see the IRS guidance on how long to keep records). In practice, that means keeping the purchase invoice and register history for the entire life of the asset plus several years. Other countries set their own retention periods, so check the rules where you file.

Common fixed asset register mistakes

• Capitalizing repairs. Routine servicing is an expense. Only improvements that extend life or add capacity belong in the register.
• Forgetting delivery and installation. These are part of cost; leaving them out understates the asset and overstates expenses.
• Starting depreciation on the purchase date when the asset was not usable until weeks later. Use the in-service date.
• No link to the invoice. Without the supplier and invoice number, you cannot prove cost in an audit or insurance claim.
• Mixing intangible and tangible assets. Software licences, patents and similar items are amortized; keep them on a separate tab. See amortization vs depreciation for the differences.

Spreadsheet or software?

A spreadsheet works well up to a few dozen assets, as long as one person owns it and the formulas are locked. Once you have hundreds of assets, several locations or both book and tax depreciation to maintain, the fixed asset module in your accounting software, or a dedicated asset tool, saves time: it posts depreciation automatically, keeps disposal history and produces reports your accountant can use. Whichever you choose, the fields in the template above stay the same, so you can start in a spreadsheet and import it later.

Fixed asset register checklist for small businesses

Before you close your books for the year, confirm that every asset purchased this year has a row, every disposal is marked with proceeds and gain or loss, depreciation is posted to the last month, the register totals match the ledger, and a physical check has been done. Pair this with a year-end invoicing checklist so that both sides of your books are clean.

Create your sale invoice when an asset goes. When you sell equipment, issue a proper invoice so the disposal in your fixed asset register has a source document. Use our free invoice generator to add the asset as a line item, apply tax if required, and download a PDF, or pick a clean layout from our corporate invoice template.