Recording Asset Disposals Correctly (and Why Excel Misses Them)

By Gregg Hopfeldt · 2025-05-20

Disposals are where fixed asset accounting breaks. The math is simple. The control problem is not.

Every year, finance teams lose audit trails, distort depreciation expense, and misstate gains or losses—not because they can't calculate, but because spreadsheets don't enforce the structure that accounting standards require.

The core problem

When you dispose of an asset, you must record four things simultaneously:

• Remove the asset's original cost from your register
• Remove accumulated depreciation to the disposal date
• Record the proceeds (or $0 for scrap or abandonment)
• Recognize the gain or loss

Miss any element, and your register no longer reconciles. Miss the timing, and you've distorted two financial periods at once.

Where spreadsheets fail

Excel handles arithmetic well. It handles accounting structure poorly. Three specific failure modes show up repeatedly in disposal tracking:

• Ghost assets. When you delete a row, the asset disappears—but dependent formulas don't. Depreciation continues calculating on assets that no longer exist.
• Lost history. Deleting a row erases the accumulated depreciation record. Auditors cannot verify the calculation path because the evidence is gone.
• Timing errors. Spreadsheets don't enforce period boundaries. A disposal entered in July but backdated to March distorts both the current-year depreciation expense and the gain or loss recognition.

The book accounting math

Step 1: Bring depreciation current

Before recording any disposal, accumulated depreciation must be calculated through the exact disposal date—not the year-end, not the last depreciation run, but the day the asset left service.

Step 2: Calculate book value

Book Value (Carrying Amount) = Cost − Accumulated Depreciation to Disposal Date

Step 3: Calculate gain or loss

Gain/Loss on Disposal = Sale Proceeds − Book Value at Disposal

A positive result is a gain. A negative result is a loss. If the asset was abandoned or scrapped with no proceeds, the full book value becomes a loss.

Worked example

An equipment asset with:

• Original cost: $50,000
• Accumulated depreciation through disposal date: $32,000
• Sale price: $22,000

Book value = $50,000 − $32,000 = $18,000

Gain = $22,000 − $18,000 = $4,000

The journal entry

The Simple Fixed Assets workflow

Simple Fixed Assets enforces the disposal structure that spreadsheets miss:

1. Open the Fixed Asset Register.
2. Navigate to Assets → Trade / Dispose (or click the Dispose button while in the Assets → Add / Edit screen).
3. Choose the asset to dispose and enter the disposal date and sale price (enter $0 for scrap or abandonment).
4. Review the calculated values: depreciation through disposal date, accumulated depreciation, book value at disposal, and profit or loss.
5. Select Confirm Disposal.

The outcome

A successful disposal produces an audit-ready register:

• The asset is marked Disposed and remains visible for historical tracking
• Accumulated depreciation is locked at the disposal date
• Future depreciation stops automatically—no ghost assets
• Gain or loss is calculated and preserved
• Register totals update correctly
• The reconciliation formula holds: Opening + Additions − Disposals − Depreciation = Closing

Common issues

• Disposed the wrong asset: Export the audit trail before correcting.
• Wrong disposal date: Adjust the date to match the correct financial year before closing the period.
• Disposed too early: If the asset remained in service beyond the recorded disposal date, export your records and consult your auditor.

For the practical steps, see our help guide on disposing of an asset.

Stay Depreciated,

Gregg