Accounting
Asset Management
Financial Management
Fixed Asset Management
Fixed Asset Register: What to Track, With a Template
Last updated: October 9, 2026 · Independent guide · We do not sell rankings or coverage.
A fixed asset register is the subledger that lists every capitalized asset you own, one row per asset, with enough detail to find it, value it and depreciate it. At a minimum it should hold an asset tag, description, location, cost, in-service date, depreciation method, useful life and accumulated depreciation, and its totals should agree with the fixed asset and accumulated depreciation accounts in your general ledger every month. Below is a field-by-field template you can copy into a spreadsheet, a reconciliation layout, and guidance on when the register should move into fixed asset software.
How to use this template
Create one spreadsheet tab for the register, with one column for each field in the table below and one row for each asset or asset component you capitalize. The “Example entry” column shows a complete illustrative row for a single machine, so you can see what a finished record looks like. Add a second tab for the monthly roll-forward shown later in this guide, and lock the formula columns so that only the fixed asset accountant can change them.
Fixed asset register template
The example entry is an illustration. Field names follow common US practice; rename them to match your chart of accounts and ERP.
| Field | What to enter | Example entry (illustrative) | Why you need it |
|---|---|---|---|
| Identification | |||
| Asset tag number | Unique ID printed on the physical label; never reused | FA-000412 | Links the row to the item during physical counts |
| Description | Plain name plus make and model | CNC turning lathe | Lets auditors and counters recognize the asset |
| Serial number | Manufacturer serial or VIN | 3112-55807 | Proves identity when a tag falls off; needed for insurance claims |
| Asset class | Category that maps to one GL cost account | Machinery and equipment | Drives default life, method and GL accounts; register subtotals by class must match the GL |
| Parent asset or component | Parent tag if this row is a component or later addition | None (parent asset) | Keeps upgrades and components tied to the original asset |
| Location and custody | |||
| Entity | Legal entity that owns the asset | Acme Manufacturing LLC | Needed for entity-level ledgers and tax returns |
| Location | Site, building and room or bay | Dayton plant, Bay 4 | Physical verification, insurance and personal property tax filings |
| Department or cost center | Cost center charged with depreciation | 4100 Machining | Posts depreciation to the right P&L line |
| Custodian | Person or role responsible for the asset | Plant maintenance manager | Someone to ask when the asset cannot be found |
| Cost and dates | |||
| Vendor and invoice or PO | Supplier name and document numbers | Midwest Machine Tools, INV 88231, PO 5530 | Audit trail back to the source document |
| Acquisition date | Date you acquired the asset or signed the binding contract | February 2, 2026 | Determines federal bonus depreciation eligibility |
| In-service date | Date the asset was ready and available for its specific use | March 16, 2026 | Starting point for book and tax depreciation |
| Capitalized cost | Purchase price plus freight, installation and setup | $48,600 ($45,000 price, $1,400 freight, $2,200 installation) | Depreciable base; must tie to the GL cost account |
| Salvage value | Expected value at the end of book life | $0 | Reduces the book depreciable base |
| Book depreciation | |||
| Depreciation method | Straight-line, declining balance or units of production | Straight-line | Required to calculate and disclose depreciation |
| Useful life (months) | Book life from your capitalization policy | 84 | Months are easier to audit than years with fractions |
| Depreciation start month | First month charged, per your convention | April 2026 (policy: month after in service) | Makes the convention visible on every row |
| Monthly depreciation | Formula: (cost minus salvage) divided by life | $578.57 | Feeds the monthly journal entry |
| Accumulated depreciation | Total charged to date, as of the period end | $3,471.43 at September 30, 2026 (6 months) | Must tie to the GL contra account |
| Net book value | Formula: cost minus accumulated depreciation and impairment | $45,128.57 | Used for disposal gain or loss and impairment reviews |
| Tax (federal, plus a column per nonconforming state) | |||
| Tax basis | Cost basis for tax, if different from book | $48,600 | Starting point for MACRS |
| MACRS class and convention | Recovery period and convention | 7-year, half-year | Drives Form 4562 calculations |
| Section 179 or bonus taken | Amount and any election made | 100% bonus, $48,600 | Explains the book-tax difference |
| Status and disposal | |||
| Status | Construction in progress, in service, fully depreciated, held for sale or disposed | In service | Stops depreciation at the right time |
| Last verified date | Date of the last physical count that found the asset | September 12, 2026 | Shows existence was tested |
| Disposal date, method and proceeds | Date, sale or scrap or trade-in, and cash received | Blank until disposed | Needed to book the gain or loss and report the sale on Form 4797 |
Walking through each part of the template
Identification fields
The asset tag is the key that joins the register to the physical world, so assign tags from one sequence and never reuse a retired number. Record the serial number as well, because labels fall off and a serial number is the only reliable proof of identity.
Asset class does more work than any other field. Each class should map to exactly one GL cost account and one accumulated depreciation account, and carry a default life and method. If two classes post to the same GL account, keep that mapping in a separate lookup tab so the reconciliation by account still works.
Location and custody
Location supports three separate jobs: physical counts, insurance schedules and business personal property tax returns. Use a controlled list of locations rather than free text, or you will end up with “Dayton,” “Dayton plant” and “DAY-01” for the same building. Record transfers between locations as dated changes so you can show where an asset was on a property tax assessment date.
Cost and dates
Capitalize the purchase price plus the costs needed to get the asset ready for use, such as freight and installation, and record them on the same row or as linked component rows. Then decide what not to capitalize. The IRS de minimis safe harbor lets you expense items up to $2,500 per invoice or item, or $5,000 if you have an applicable financial statement, provided you follow a consistent policy that existed at the start of the tax year and attach the election statement to your return each year (IRS, updated August 4, 2026). Set your register threshold to match that policy.
Keep two dates. IRS Publication 946 says property is placed in service “when it is ready and available for a specific use,” even if it is not yet being used (IRS, Publication 946 (2025), March 13, 2026). PwC’s US guide makes the same point for book purposes: once an asset reaches the in-service stage, depreciation should commence (PwC, Property, plant, equipment and other assets guide, partially updated November 2021). The acquisition date matters separately because 100% federal bonus depreciation applies to qualified property acquired and placed in service after January 19, 2025, and property is not treated as acquired after the date a written binding contract is signed (IRS, Notice 2026-11, January 2026).
Book depreciation fields
Store useful life in months and write your convention (full month, half month or month after in service) into the policy and onto each row. Calculate monthly depreciation and accumulated depreciation with formulas, not typed values, and stop the formula when net book value reaches salvage value. For the illustrative lathe, $48,600 over 84 months gives $578.57 a month, and six months from April through September give $3,471.43 of accumulated depreciation.
Tax fields
Book and tax depreciation almost never match, so keep tax basis, MACRS class, convention, and any Section 179 or bonus amounts in their own columns. Publication 946 lists computers and light trucks as 5-year property and office furniture as 7-year property, and it requires you to keep records showing how and from whom you acquired Section 179 property and when you placed it in service. States that do not follow federal bonus depreciation need their own columns. Our article on depreciation schedule software explains book and tax books, MACRS conventions and state nonconformity in detail.
Status and disposal fields
Assets under construction belong in a construction in progress status and should not depreciate until they are placed in service. When an asset is sold or scrapped, record the date, method and proceeds, remove its cost and accumulated depreciation, and keep the row with a disposed status instead of deleting it. The IRS says to keep records relating to property until the period of limitations expires for the year in which you dispose of it (IRS, last reviewed June 30, 2026).
Reconciling the register to the general ledger
The register is a subledger, so its totals must equal the balances of the related GL accounts at every period end. AccountingTools recommends reconciling at least monthly or quarterly, depending on volume and risk (AccountingTools, no date shown). Use a roll-forward by asset class, with one block for cost and one for accumulated depreciation.
| Machinery and equipment, September 2026 (illustrative) | Register | General ledger | Difference |
|---|---|---|---|
| Cost, beginning balance | $1,250,000 | $1,250,000 | $0 |
| Additions | $85,000 | $91,500 | ($6,500) |
| Disposals | ($40,000) | ($40,000) | $0 |
| Cost, ending balance | $1,295,000 | $1,301,500 | ($6,500) |
| Accumulated depreciation, beginning | $610,000 | $610,000 | $0 |
| Depreciation expense | $14,200 | $14,200 | $0 |
| Disposals | ($36,000) | ($36,000) | $0 |
| Accumulated depreciation, ending | $588,200 | $588,200 | $0 |
In this illustration the cost difference of $6,500 sits entirely in additions, so you would pull the GL detail for the month and match each posting to a register row. A typical cause is an installation invoice coded to the equipment account that nobody added to the asset record. You fix it by adding the cost to the asset and recalculating its depreciation, or by reclassifying the invoice to expense if it falls below your threshold.
Work through these steps each month:
- Lock the register as of period end and export totals by class.
- Run a GL trial balance for each fixed asset, accumulated depreciation and depreciation expense account.
- Fill in the roll-forward for each class and investigate any difference by line, starting with additions.
- Check that depreciation expense in the P&L equals the change in accumulated depreciation, adjusted for disposals.
- Review the construction in progress balance and move completed projects into service.
- Have a reviewer sign and date the reconciliation, and keep the support with the close file.
The same roll-forward gives you the year-end property, plant and equipment schedule your auditors and tax preparer will request. If the reconciliation regularly delays your close, our guide to accounting close automation covers recurring schedules and subledger checks.
Common mistakes
- Typing depreciation instead of calculating it. Hard-coded figures stop updating when a life or cost changes, and the register drifts from the GL.
- Posting directly to the fixed asset GL accounts. Journal entries that bypass the register create unexplained differences. Restrict posting to these accounts or review every manual entry.
- Depreciating from the invoice date. Depreciation starts when the asset is placed in service, which can be weeks after delivery for equipment that needs installation.
- Missing acquisition dates. Without them you cannot support the 100% bonus claim for property acquired after January 19, 2025.
- Deleting disposed assets. Removing the row erases the audit trail and the data you need for Form 4797.
- Never counting. A register that has not been compared with the floor in years usually contains ghost assets that are still being depreciated and taxed.
When to move from a spreadsheet to software
A spreadsheet works while you hold a few hundred assets in one entity, your CPA keeps the tax book, and one person maintains the file. Move to software when you add entities, need separate tax and state books, see recurring reconciliation differences, or cannot show auditors who changed what. The options fall into three groups.
Native modules in accounting software. An Intuit staff member confirmed that the QuickBooks Online fixed asset feature is available only in the Advanced and Accountant versions, builds the depreciation schedule automatically and posts entries monthly (Intuit QuickBooks Community, June 21, 2024). QuickBooks Online Advanced lists at $340 per month (Intuit, no date shown, checked October 9, 2026). Xero says its fixed asset register supports CSV import, adding assets from bills, a choice of depreciation method, and tracking categories such as location, but its US page does not say which plans include the feature (Xero, no date shown). Both are book-focused, so plan on keeping the tax book elsewhere.
ERP fixed asset modules. Microsoft Dynamics 365 Business Central uses fixed asset classes, subclasses, optional location codes and a separate depreciation book for each purpose, such as tax or financial statements (Microsoft Learn, updated October 22, 2025). The Oracle NetSuite Fixed Assets Management SuiteApp can propose or create assets when a purchase bill posts, supports CSV import of mid-life assets with depreciation history, and handles transfers, splits, revaluations and partial disposals (NetSuite Help, no date shown).
Dedicated fixed asset systems. Sage Fixed Assets advertises more than 50 depreciation methods, separate tax, internal, state and ADS books, fixed asset tracking and integration with ERPs including Sage Intacct, Microsoft Dynamics, SAP and Oracle, and does not publish pricing (Sage, no date shown). A dedicated system suits companies with thousands of assets or several nonconforming states, at the cost of maintaining an integration to the GL. Contractors with heavy fleets should also read our guide to construction equipment and fleet accounting in ERP.
How we researched this
We reviewed the pages that rank for “fixed asset register” in October 2026, including AccountingTools, MRI Software, Wikipedia and SuperfastCPA, and noted that none offered a copyable US template with tax fields or a GL reconciliation layout. We took rules from IRS primary sources and PwC’s US accounting guide, and product capabilities from vendor documentation and pricing pages checked on October 9, 2026. All example figures are illustrations.
Related guides
- NetSuite Fixed Assets: FAM Setup, Depreciation and Disposals
- Depreciation Journal Entry: Examples, Book vs Tax (2026)
- NetSuite Lease Accounting: ASC 842 Setup in FAM
Frequently asked questions
What should a fixed asset register include?
At a minimum, include an asset tag, description, asset class, location, capitalized cost, acquisition and in-service dates, depreciation method, useful life, accumulated depreciation and net book value. US companies should add tax basis, MACRS class and any Section 179 or bonus amounts. Add status and disposal fields so retired assets keep their history.
How often should the fixed asset register be reconciled to the general ledger?
Reconcile at least quarterly, and monthly if you add or dispose of assets often. A monthly roll-forward by asset class, covering cost and accumulated depreciation, catches coding errors while the invoices are still easy to find.
What is the difference between a fixed asset register and a depreciation schedule?
The register is the master list of assets with their identifying, location, cost and depreciation data. A depreciation schedule is a calculation drawn from it that shows depreciation by period for one book, such as GAAP or federal tax. One register can feed several schedules.
Can I keep a fixed asset register in Excel?
Yes, if you have a manageable number of assets, one entity and a disciplined monthly reconciliation. Lock formula columns, keep dated copies at each close and log changes. Move to software when you need multiple books, entities or an audit trail of who changed each record.
How long should I keep fixed asset records?
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. For long-lived assets, that can mean decades of records, so never delete disposed rows.
Sources
- IRS, Publication 946 (2025), How To Depreciate Property, March 13, 2026
- IRS, Notice 2026-11, January 2026
- IRS, Tangible Property Final Regulations, updated August 4, 2026
- IRS, How long should I keep records?, last reviewed June 30, 2026
- PwC, Property, plant, equipment and other assets guide, partially updated November 2021
- AccountingTools, Fixed asset register definition, no date shown
- Intuit QuickBooks Community, Depreciation schedule, June 21, 2024
- Intuit, QuickBooks pricing, no date shown, checked October 9, 2026
- Xero (vendor), Manage fixed assets, no date shown
- Microsoft Learn, Set up general fixed assets in Business Central, updated October 22, 2025
- Oracle NetSuite Help, Fixed Assets Management Overview, no date shown
- Sage (vendor), Sage Fixed Assets, no date shown
Sherman Hsieh
Independent analysis of enterprise software — ERP, CRM and more
