Fixed Asset Register Template
Three documents and four sheets that build every asset's capitalized cost from every invoice billed before it went into service, then check it against your ledger.
Free download · No account needed
Every fixed asset template you can download works the same way: one purchase-cost field, filled from the invoice's sticker price. That undercounts the asset the moment freight or installation shows up as its own invoice from a different vendor, which is routine for anything that has to be delivered and set up rather than shipped in a box. This pack reads every invoice billed before an asset's in-service date, not just the main one, and sums them into the capitalized cost the accounting rules actually require.
Halvern Precision Manufacturing's CNC mill is the case this pack is built around. The invoice price was 185,000.00. Freight to the shop floor added 12,400.00, and rigging and installation added another 8,600.00, both billed and paid before the machine ran its first job, so the capitalized cost is 206,000.00, not 185,000.00. Expensing either add-on instead of capitalizing it understates fixed assets at cost by 21,000.00, and because depreciation runs on that basis, it also understates seven months of depreciation expense by 1,225.00, quietly, on the same invoice.
Ledger Tie-out carries both breaks separately rather than netting them, because a cost-account error and a depreciation-account error do not always move together and a net-only check can hide that a single invoice caused both. Disposal Log runs the same discipline the other direction: a fully depreciated lathe sold for 5,500.00 against a 4,000.00 net book value books a 1,500.00 gain rather than vanishing from the register. Feed it from purchase invoices alongside the close checklist, or prove the resulting balances with account substantiation.
What's in the pack
Asset Register sheet
Every asset in service with its capitalized cost broken into invoice price, freight, and installation, so the full basis is visible, not just the total.
Depreciation Schedule sheet
The month-by-month roll behind every asset's accumulated depreciation and net book value, floored at salvage value.
Disposal Log sheet
Every asset that has left the register, with its gain or loss against net book value and the approval reference behind it.
Ledger Tie-out sheet
The register and the GL, side by side on both the cost and depreciation accounts, with every difference traced to a named cause.
Capitalization Policy
The 2,500.00 threshold and the rule for what counts toward capitalized cost, with the CNC mill's worked numbers behind it.
Disposal Approval Note
A completed sign-off example: the numbers a disposal needs before it is approved, not after.
Tying the Register to the Ledger
How a cost-account break and a depreciation-account break usually trace back to the same invoice, and the two entries that clear both.
How to use it
- 1
Open in River, or download it
Open the pack in River and let the agent read your asset invoices, or download the blank Word and CSV files instantly with no account.
- 2
Send the invoices
Every purchase invoice for an asset in service, plus any separate freight or installation invoice for the same asset, in whatever shape they exist today.
- 3
Let the full cost get built
The agent sums every cost billed before the in-service date into one capitalized cost, checks it against your threshold, and sets up straight-line depreciation.
- 4
Tie it to the ledger every close
Both the cost account and the depreciation account get checked against the GL separately, so a break gets traced to the invoice that caused it.
Frequently asked questions
Is this template free?
Yes. Download the whole pack as Word documents and CSV sheets, with no signup and no credit card. Edit with AI is a separate, optional path for anyone who wants the agent to read invoices and build the register directly. The template library holds the rest of the packs.
Why isn't the invoice price the whole capitalized cost?
Because amounts paid to acquire a unit of property include the invoice price and every cost for work performed before the asset is placed in service, not just the purchase price. On the CNC mill here, freight and installation add 21,000.00 to a 185,000.00 invoice. Miss either one and both fixed assets at cost and future depreciation run understated.
What is the de minimis threshold, and why 2,500.00?
It mirrors the de minimis safe harbor for a business without an applicable financial statement, raised from 500.00 to 2,500.00 per item or invoice starting in 2016. Below it, expense immediately regardless of useful life; above it, the item goes on the register.
Is this the same as tax depreciation?
No. Depreciation Schedule runs book straight-line for financial reporting. Federal tax depreciation uses MACRS recovery periods and its own conventions, reconciled separately. Matching this schedule to whatever the tax return uses would make the book number an artifact of the wrong rules.
What happens when I dispose of an asset?
Get a Disposal Approval Note signed first, then Disposal Log computes the gain or loss against net book value and removes the asset from Asset Register in the same close. A gain or loss posts on its own line; it is never netted against depreciation expense or left off because the amount is small.
What does Edit with AI actually do?
It creates a free River account and installs this exact pack as a private workspace. The agent opens ready to read your open asset invoices, extract every pre-in-service cost, and check the resulting balances against your ledger. Nothing is written until you send something.
Who is this template for?
Controllers and fractional CFOs who want a fixed asset register that survives an audit request, not just a spreadsheet that adds up. Once the register ties, account substantiation is what proves the resulting balances to a lender or an auditor, and the close checklist is where the tie-out step lives every month.
Capitalize the whole invoice, not just the sticker price
Download the blank pack as Word and CSV files, or open this exact pack in River and let the agent build the register from your own asset invoices.
Edit with AI