Month-End Close
Fixed asset roll forward: what it is, with a worked example
A fixed asset roll-forward shows how last period's fixed asset balances became this period's: what was added, what was disposed of, and how much depreciation was taken. It's two small reconciliations, one for cost and one for accumulated depreciation, and the point of both is to prove the asset register still explains what's on the balance sheet.
Cost: beginning cost + additions − disposals = ending cost.
Accumulated depreciation: beginning balance + depreciation − accumulated depreciation on disposals = ending balance.
The check: both ending balances should equal the trial balance, and ending cost less ending accumulated depreciation is net book value.
Why it's two roll-forwards, not one
Cost and accumulated depreciation move for different reasons, so each gets its own roll-forward. Cost changes only when an asset arrives or leaves. Accumulated depreciation changes every month as depreciation is taken, and drops when an asset leaves, by whatever had built up against that asset. Netting them into a single net book value roll-forward hides the one question a reviewer usually has: did the disposal come off both lines?
A common roll-forward error, and one I've seen in files I've reviewed, is a disposal that removed the asset's cost but left its accumulated depreciation behind. Net book value then comes out too low, the gain or loss on disposal is wrong, and a single net figure won't show you why. Two roll-forwards will.
A worked example: one month, nine assets
A fictional packaging company closing September 2026. The register has nine assets in five classes. In September, a shrink-wrap machine is placed in service, a box truck is sold, and an office file server has been bought but won't be in service until October. Depreciation is straight line, with a full month in the month an asset is placed in service.
| Beginning cost, August 31 | 797,850.00 |
| Additions: shrink-wrap machine | 46,800.00 |
| Disposals: box truck | (61,000.00) |
| Ending cost, September 30 | 783,650.00 |
| Beginning balance, August 31 | 291,688.10 |
| Depreciation for September | 8,281.77 |
| Disposals: box truck | (47,700.00) |
| Ending balance, September 30 | 252,269.87 |
Net book value at September 30 is 783,650.00 − 252,269.87 = 531,380.13. If the trial balance shows 783,650.00 of fixed assets and 252,269.87 of accumulated depreciation, the register ties.
The file server isn't in either roll-forward. An asset bought but not yet in service isn't depreciating; it usually sits in construction in progress or a similar account until it is. The roll-forward should name it rather than leave it out silently, because it's the first thing that explains a difference against a fixed asset account that includes it.
The entries behind it
Two entries move the balances in this example: the month's depreciation, by asset class, and the disposal.
| Account | Debit | Credit |
|---|---|---|
| Depreciation expense – Machinery | 4,946.67 | |
| Depreciation expense – Leasehold improvements | 2,000.00 | |
| Depreciation expense – Vehicles | 666.66 | |
| Depreciation expense – Computers | 516.66 | |
| Depreciation expense – Furniture | 151.78 | |
| Accumulated depreciation (by class) | 8,281.77 |
The box truck cost 61,000.00, with an expected salvage value of 8,000.00 and a five-year life starting March 2022. By the end of August 2026 it had 54 of its 60 months behind it: (61,000 − 8,000) × 54 ÷ 60 = 47,700.00 of accumulated depreciation, so its net book value was 13,300.00. It sold for 24,500.00.
| Account | Debit | Credit |
|---|---|---|
| Cash | 24,500.00 | |
| Accumulated depreciation – Vehicles | 47,700.00 | |
| Fixed assets – Vehicles | 61,000.00 | |
| Gain on disposal of fixed assets | 11,200.00 |
The gain is proceeds less net book value: 24,500.00 − 13,300.00 = 11,200.00. The disposal entry is where the two roll-forwards meet: the 61,000.00 credit is the cost roll-forward's disposal line, and the 47,700.00 debit is the accumulated depreciation roll-forward's.
Monthly depreciation, and the first and last month
Straight-line monthly depreciation is cost less salvage value, divided by the life in months. The shrink-wrap machine cost 46,800.00 with no salvage and a five-year life: 46,800 ÷ 60 = 780.00 a month.
The month an asset arrives or leaves is where companies differ, and the roll-forward has to follow whatever the policy says. Three conventions are common for book depreciation:
| Convention | Month placed in service | Month of disposal | Shrink-wrap machine, September |
|---|---|---|---|
| Full month | A full month, whatever the day | None | 780.00 |
| Start the month after | None | None | 0.00 |
| Mid-month | Half a month | Half a month | 390.00 |
Over the life of the asset all three add up to the same total; they only move depreciation between months. That's why the choice matters for a roll-forward: a register on one convention and a ledger on another will disagree in every month an asset arrives or leaves, and agree everywhere else. Tax depreciation has its own conventions set by tax rules (half-year, mid-quarter, and mid-month for real property under MACRS); a book roll-forward doesn't use them.
Amounts that don't divide evenly need a rounding rule. Laptops costing 18,600.00 over 36 months are 516.666… a month. Rounding each month on its own leaves a few cents over or short at the end of the life. Rounding the running total instead, and booking each month as the difference from the month before, gives 516.66 or 516.67 a month and lands exactly on cost less salvage, with no plug in the last month. That's the 516.66 in the September entry above.
Fully depreciated assets stay on the roll-forward
The company's forklift was placed in service in June 2019 on a five-year life. It's fully depreciated: cost 28,500.00, accumulated depreciation 25,500.00, which is cost less its 3,000.00 salvage value. It's still in use, so it stays in both roll-forwards at those amounts and takes no more depreciation. It comes off only when it's sold or scrapped, and then the disposal removes both lines, just as with the box truck.
Writing a fully depreciated asset off the register while it's still in use makes the register smaller than the ledger, and the difference shows up as an unexplained cost and accumulated depreciation gap that nets to the salvage value.
When it doesn't tie to the trial balance
A difference between the roll-forward and the trial balance says the register and the ledger disagree. Where the difference sits tells you what to look for:
- Cost differs: an asset that's on one and not the other. Usually an addition coded to a fixed asset account but never added to the register, an invoice that should have been expensed, a disposal recorded in only one place, or construction in progress sitting in the same account.
- Only accumulated depreciation differs: the depreciation entry posted a different amount from the register, or the ledger uses a different life, salvage value or convention for something.
- The difference equals one asset's monthly depreciation: usually a missed or doubled month.
- Cost and accumulated depreciation differ by amounts that net to an asset's net book value: a disposal recorded on one side only.
Monthly or annual
The structure is the same for a month or a year: start from the closing balances of the earlier period, add the activity, and land on this period's balances. A monthly roll-forward catches errors while they're one month old. An annual one, from the prior year-end balances, is the version auditors commonly ask for at year end, and it's much easier to produce if twelve monthly ones already tie.
Rolling forward any balance sheet account
The same check, beginning balance plus activity equals ending balance, works for almost every balance sheet account. A prepaid roll-forward adds new prepaids and subtracts amortization; deferred revenue adds billings and subtracts revenue recognized. The free prepaid amortization schedule and deferred revenue schedule build those roll-forwards from a register the same way. And once a balance ties, balance sheet flux is the next question: not whether the balance is right, but why it moved.
The company, assets and figures on this page are synthetic.
Once the balance sheet ties, the next question is what moved and why. The free flux template flags which balances moved enough to explain. The CloseOps Flux & Variance System ($79) starts from your trial balance instead: confirm each account's classification and it builds the income statement and balance sheet flux statements, then ranks what to investigate.
Related: the fixed asset roll-forward tool, which builds this from your register; the prepaid amortization schedule; balance sheet flux analysis; and what to check when the GL doesn’t match the trial balance.
Found something wrong or missing? Tell me here — anonymous, thirty seconds.