Asset Management Reporting: What to Include and Check

Asset management reporting for physical assets should explain the movement in carrying value and the maintenance cost of keeping those assets in service. Start with the fixed asset register, reconcile it to the ledger and attach a maintenance review using stable asset IDs. The monthly pack should make both the accounting difference and the operating action clear.

Define the physical assets in the pack

Specify the entities, sites, asset classes and reporting month. This review covers owned equipment, vehicles and IT assets at an illustrative US manufacturing company. Investment portfolio communication is a separate job, covered in asset management client reporting.

Ask finance for opening and closing register exports, additions, disposals, depreciation and any impairment or transfer schedules. Ask operations for work-order costs and asset status, then obtain the approved maintenance budget and the ledger detail for the month. Preserve asset ID, posting date, account, site, work-order reference and amount.

Do not use purchase invoice totals as a substitute for approved asset additions. A purchase may contain repairs, parts and capital items. The IRS's tangible property guidance distinguishes repair and maintenance expenses from capital expenditures for tax purposes. Finance should apply the company's book accounting policy to this reporting pack and retain separate tax adjustments where needed.

Reconcile the asset register movements

Use net carrying value consistently. For a simple schedule:

Closing carrying value = Opening carrying value + Additions - Carrying value disposed - Depreciation

Add separate signed columns for impairments, transfers and other approved movements when they occur. This example has none. The disposal column removes the asset's net carrying amount, not the cash received from selling it.

For September, the company's register movements are:

Place these columns in A:F in Excel. Rebuild closing value in F2 and copy down:

=B2+C2-D2-E2

The total proves as $1,000,000 plus $60,000 less $20,000 less $20,000 equals $1,020,000. The increase in carrying value is $20,000, even though capital additions were $60,000. Disposals and depreciation explain the difference.

Keep the closing value from the independent register export in G. Test the reconstructed value against it in H2:

=F2-G2

Every difference should be zero or have a documented reconciling item. Then tie the register's closing total to the net fixed asset ledger balance. At class level, transfers may move value between rows while leaving the company total unchanged; checking only the total would miss a misclassified asset.

Build the maintenance cost review

Use incurred cost for the month, including approved accruals under the company's policy. An open work order is not automatically an expense, and an invoice paid this month may belong to earlier work. The accrual versus cash example explains why payment timing and expense timing differ.

The maintenance export produces this second schedule. These costs are expensed maintenance and exclude the capital additions above.

For detailed Excel rows on a sheet named Costs, put posting dates in A, asset classes in B and maintenance amounts in C. On the review sheet, A2 contains the selected class, J2 the month start and K2 the exclusive end date:

=SUMIFS(Costs!C2:C1000,Costs!B2:B1000,$A2,Costs!A2:A1000,">="&$J$2,Costs!A2:A1000,"<"&$K$2)

Microsoft's SUMIFS documentation explains the multiple-criteria structure. Apply the same class and period boundaries to the budget export. With actual in B2 and budget in C2, the variance is:

=B2-C2

Positive means expense above budget under this convention. The company meets its maintenance budget, but production equipment is $1,000 above plan and vehicles are $1,000 below. Ask whether vehicle work was delayed and whether equipment repairs were recurring failures or an isolated event. A zero total does not settle either question.

Tie the maintenance total to the ledger accounts in scope and explain exclusions. Keep a list of work orders without asset IDs rather than silently dropping them. For a deeper examination of spend drivers, use asset management cost analysis.

Where the monthly pack goes wrong

• Disposal proceeds replace carrying value. Keep sale proceeds separate from the amount removed from the register.
• Capital and maintenance costs overlap. A capitalized cost should not also appear as expensed maintenance in the same comparison.
• Work orders and invoices are both summed. Match references to avoid counting an estimate and its final invoice twice.
• Missing IDs disappear. Show unmatched costs as exceptions and assign an owner to identify the asset.
• Transfers look like company growth. Reconcile both class movements and the company total.

Finance owns the register and ledger ties; operations owns asset status and maintenance explanations. Include the resulting exceptions and actions in the wider monthly management package.

Review your asset files in Covirage

Bring your asset register movements, maintenance export and budget to Covirage, which maps the columns and uses its tools to compute and check the comparisons. The external AI model explains the results with every figure traced to its rows. 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 supporting reporting context. Covirage is not affiliated with Microsoft.