Month·End·Close
← Month-End Close

Tools

Fixed asset roll-forward: monthly depreciation, tied to the trial balance

Paste your fixed asset register and pick the month you're closing. You get each asset's straight-line book depreciation, the cost and accumulated depreciation roll-forward from beginning to ending, the gain or loss on anything disposed of, the entries, and a check against the balances on your trial balance.

A fixed asset roll-forward answers one question at every close: does the register still explain what's on the balance sheet? Beginning balance, plus additions, less disposals, gives the ending balance, for cost and for accumulated depreciation separately. This builds both from the register, so the numbers come from the assets rather than from last month's spreadsheet.

Runs entirely in your browser. Nothing you paste is uploaded or stored; it stays in your browser.

Settings

Asset register

One row per asset, tab or comma separated: asset, class, cost, in-service date, life in months, and optionally salvage, disposal date, proceeds. Class groups the entries (Machinery, Vehicles…). Dates can be 2026-09-08, 9/8/2026 or just 2026-09, with a four-digit year; only the month matters. Life is in months: 5 years is 60. A header row is fine.

How it's calculated

StepRule
DepreciationStraight line: cost less salvage, spread evenly over the life in months. The running total is rounded to the cent each month and the month's depreciation is the difference, so every asset ends exactly at cost less salvage, with no plug in the last month.
Cost roll-forwardAssets in service at the end of last month, plus assets placed in service this month, less assets disposed of this month, gives cost at the end of this month.
Accumulated depreciation roll-forwardLast month's ending balance, plus this month's depreciation, less the accumulated depreciation on assets disposed of, gives this month's ending balance.
DisposalsGain or loss is proceeds less net book value (cost less accumulated depreciation at disposal). The entry removes the cost and the accumulated depreciation and records the cash.
Tie-outEnding cost and accumulated depreciation against the figures you enter from the trial balance, in dollars.

Which month depreciation starts

Three conventions, because companies differ. Full month takes a full month of depreciation in the month the asset is placed in service, whatever the day, and none in the month it's disposed of. Start the month after takes nothing in the first month. Mid-month takes half a month in the month placed in service and half in the month of disposal. Over the asset's life they all add up to the same amount; they only move it between months. Pick the one your policy says, and use it every month. An asset placed in service and disposed of in the same month isn't depreciated under any of them.

When the roll-forward doesn't tie

Enter cost and accumulated depreciation from your trial balance and the tool shows the difference for each. A difference in cost almost always means an asset that's on one and not the other: an addition coded to the account but not added to the register, a disposal recorded in one place only, or an item that should have been expensed. A difference only in accumulated depreciation usually means last month's entry posted a different amount, or the ledger uses a different life, salvage value or convention for something. A difference that matches one asset's monthly depreciation is usually a missed or doubled month.

Fully depreciated and not yet in service

An asset that's fully depreciated and still in use stays on the roll-forward at cost, with accumulated depreciation equal to cost less salvage, and takes no more depreciation. It comes off only when it's disposed of. An asset with an in-service date after the month you're closing is left out and named, because it isn't depreciating yet; it often sits in construction in progress until then.

What it doesn't do

It's book depreciation, straight line only: no tax lives, MACRS or bonus depreciation, no declining balance, no half-year convention, no impairment, and no partial disposals of a single asset. It doesn't decide lives, salvage values or what gets capitalized; those are your policy. Changes in estimate (a new life or salvage value) aren't supported: the tool depreciates every asset from its original in-service date, so after a change it will differ from your ledger for that asset. It doesn't post anything: it gives you the entries to book.

The company and figures in the worked example 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, step by step, with the worked example explained; the prepaid amortization schedule, the same roll-forward for prepaids; balance sheet flux analysis; and the bank reconciliation calculator.

Found something wrong or missing? Tell me here — anonymous, thirty seconds.