Fixed Asset Dashboard: Book Value and Capital Movements

A fixed asset dashboard reconciles asset cost, accumulated depreciation, and net book value from the opening register to the closing register. Group the movements by location and asset class, then show additions, depreciation, and disposals separately. The useful result is an explanation of capital movements that ties to the ledger.

Keep the accounting question clear

This dashboard answers what is on the books, what changed, and which location owns the movement. It supports the controller's monthly review and the finance team's capital discussions. It does not establish the physical condition or market value of equipment.

The SEC's financial statement guide describes fixed assets as property used to operate the business, including trucks and office furniture. For this example, the register covers owned machinery, vehicles, and office equipment. Land, leases, construction in progress, impairment, and foreign currency effects are outside this small illustrative population; a real register should show their applicable movements explicitly.

Use this detail alongside the balance sheet dashboard, where net fixed assets appear as a summarized balance. Keep efficiency definitions in fixed asset management KPI examples and asset intensity in the separate fixed asset ratio discussion.

Prepare the register workbook

Use a stable asset ID to connect the opening register, additions schedule, disposal schedule, and closing register. The workbook needs location, asset class, capitalized cost, accumulated depreciation, current-period book depreciation, acquisition date, in-service date, and disposal date where applicable. Keep proceeds in a separate field from the carrying amount removed.

Preserve the accounting basis. The IRS depreciation publication describes depreciation for income tax purposes and explains tax methods and conventions. Those schedules should not silently replace the book depreciation supporting your financial statements. The figures below are the company's book register amounts, already calculated under its accounting policy.

Choose the same month-end cutoff for the register and ledger. Identify additions from the capitalized additions schedule, rather than treating every equipment invoice as a fixed asset. Repairs, deposits, and assets awaiting capitalization need review according to the company's policy.

A worked monthly dashboard by location

Harbor Components, a US manufacturer, reviews September 2026 using the following location summaries from its register. All amounts in the tables are USD. Accumulated depreciation is displayed as a positive deduction from cost. This month's example has no impairment, transfers, or currency movements.

Closing cost = Opening cost + Capitalized additions − Cost of disposals

For Ohio, $1,200,000 plus $120,000 minus $100,000 equals $1,220,000. The total gross cost increases by $50,000 even though additions are $200,000, because disposed assets remove $150,000 of original cost.

Now reconcile accumulated depreciation using the same locations and cutoff. The removal column carries depreciation previously recorded on the disposed assets, including any current-period depreciation through their disposal date.

Closing accumulated depreciation = Opening accumulated depreciation + Period depreciation − Accumulated depreciation removed

The accumulated balance falls even though depreciation expense is positive. Removing the retired assets' accumulated depreciation explains that result. Reading only the closing balance would miss the expense charged during the month.

Show net book value and prove the movement

Subtract accumulated depreciation from cost at each date. The net carrying amount of a disposal is its original cost less the accumulated depreciation removed with it.

The net movement is $122,000: $200,000 of additions less $48,000 of depreciation less $30,000 of disposed book value. Add that movement to opening net book value of $1,380,000 to reach $1,502,000.

There is an independent closing check. Closing cost of $2,450,000 less accumulated depreciation of $948,000 also equals $1,502,000. Both paths must agree before the dashboard moves into the monthly management report.

The controller should then tie gross cost and accumulated depreciation to their separate ledger accounts. A matching net total alone can conceal equal errors in both balances. Also check each location back to its asset IDs; totals can reconcile while location assignments remain wrong.

Keep disposal proceeds separate

The disposal review uses the amounts already removed from the register and the proceeds recorded for those assets. Assume no selling costs in this example.

Gain equals proceeds minus book value removed: $36,000 minus $30,000 equals $6,000. Proceeds do not reduce the remaining register's net book value. They belong in the disposal accounting and cash review. That distinction stops a dashboard from subtracting the sale amount twice.

A second scenario: additional Texas equipment

Change one input: Texas capitalizes another $30,000 of equipment in September. Assume its stated book policy starts depreciation the following month, so September depreciation is unchanged. This is a scenario assumption, not a general accounting rule.

The revised net movement is $152,000. The additional capitalization raises gross cost and book value together. It says nothing by itself about production capacity, return on investment, or how the purchase was financed.

Where it goes wrong

• Removing cost only. A disposal must also remove its accumulated depreciation. Otherwise the remaining depreciation balance is overstated.
• Using tax and book schedules together. Different bases and conventions can create a convincing-looking total that never ties to the financial ledger.
• Counting transfers as additions. A move between locations changes location balances but does not add an asset to the company total.
• Confusing book value with condition. Fully depreciated equipment may still operate. Ask operations about reliability and replacement needs separately.
• Treating invoice payments as capitalization. Payment timing and recognition timing may differ. Reconcile to the capitalized asset schedule.

Check your asset register in Covirage

Bring your opening and closing asset registers, additions, and disposal schedules in a workbook; Covirage maps the columns, and its tools compute and check the capital and depreciation movements. The external AI model explains the results with every figure traced to its rows. Create a free Covirage account, set up your business, and bring a sample of your own register.

See Covirage for financial planning and reporting.