Asset inventory report: fields and reconciliation

An asset inventory report reconciles physical business assets with the register that records their identity, location, cost, and book value. It should show both what the company recorded and what the count team observed, with each difference assigned to an owner. The useful result is a supported exception list and a register that ties to the ledger.

This report covers equipment, vehicles, machinery, and furniture used by a business. Goods held for sale belong in a merchandise inventory reconciliation instead. Keep the scope explicit so a reader knows which assets and locations the report actually covers.

Start with the records, then add observations

Use the asset register at the reporting cutoff as the starting population. Keep its export unchanged and add count evidence in separate columns. This preserves the difference between a recorded fact and a proposed correction.

The IRS's business recordkeeping guidance identifies acquisition details, purchase price, improvements, depreciation deductions, and disposal details as information that asset records should support. Those are tax recordkeeping requirements; a management report also needs operational fields such as custody and location. Use book accounting balances for a book-value report, rather than substituting tax deductions.

The depreciation glossary explains the accounting allocation. The asset inventory report uses the resulting balances; it does not recalculate the company's depreciation policy from a physical count.

A worked report for an Ohio distributor

A distributor counts equipment at its Columbus and Cleveland locations on September 30, 2026. The register contains the following assets. All amounts are USD; this example assumes no separate impairment balances. Net book value is cost minus accumulated depreciation, with dollars shown without rounding.

The first check is 190,000 minus 87,000 equals 103,000. Match gross cost and accumulated depreciation separately to the corresponding ledger accounts. Matching the net alone could hide offsetting errors.

Four assets were physically observed from the original six-asset population. Count verification coverage is 4 / 6 = 66.7%, rounded to one decimal place. That is a measure of observations against the original register, not proof that the remaining assets were lost.

Resolve the exceptions without erasing them

The compressor has a location difference, not a valuation difference. Operations confirms an authorized transfer to Columbus; the Production cost center remains responsible. Update the location after approval, retaining both the original location and transfer evidence.

The van has documentation confirming disposal before the reporting cutoff. Finance approves removal of its $40,000 cost and $16,000 accumulated depreciation. The $24,000 difference is the book value removed; gain or loss requires disposal proceeds and expenses, which are outside this example.

The scrubber remains unresolved. Its $4,000 book value stays in the register while the warehouse manager checks repair vendors, temporary storage, and transfer records. An empty observed-location field is not a disposal approval.

The location correction changes none of these company totals. After posting the approved disposal, the adjusted register must agree with the adjusted ledger. Keep the approved posting reference beside the exception so the reviewer can follow the change.

Compare locations and cost centers on the corrected basis

Apply the approved transfer and removal before comparing sites. Retain the unresolved scrubber in Columbus, clearly flagged.

The observed assets have combined book value of $75,000: $15,000 + $54,000 + $6,000 + $0. Add the unresolved scrubber's $4,000 and the total is $79,000, matching the adjusted register. This makes the open exposure visible without implying it has already been written off.

The controller owns the ledger tie and accounting approvals. Site managers own location and custody evidence. Department heads use the cost-center view to investigate idle or misplaced equipment; finance can separately assess utilization through the fixed asset turnover ratio. The report's net balance also feeds the relevant balance sheet accounts.

Where asset inventory reports go wrong

• Counting only assets with book value. The furniture remains physically relevant despite its zero net value. IRS Publication 946 explains depreciation as recovery of property cost over its use; that accounting allocation is different from observing custody and condition.
• Joining by description. Similar equipment names can attach the same count to several register rows. Match stable IDs and investigate missing tags.
• Treating every mismatch as a loss. The compressor was transferred. Its location needed correction, while its company book value did not.
• Mixing dates or accounting bases. A count after cutoff, a later disposal, or tax depreciation paired with book cost can create a false reconciliation.
• Reporting a clean total without open exceptions. Show unresolved items, their owners, and the evidence still needed even when ledger balances agree.

Reconcile your asset files in Covirage

Bring your asset register, count results, and ledger export with a common reporting date to Covirage, which maps the columns; its tools compute location and cost-center comparisons and check the supplied totals. The external AI model explains the results with every figure traced to its rows, while your team investigates physical exceptions and approves accounting changes. Create a free Covirage account and bring a sample of your own data; creating the account takes about a minute.

See Covirage for finance teams for the wider reporting context.