Depreciation schedule
Straight-line, declining balance or SYD, with the convention that decides the first period.
- Runs
- In this tab
- Data sent
- None
- Rounding
- Once, at the end
- Also in
- The Chrome extension
Depreciation schedule, worked
Showing a worked example — type over it
Result
How the depreciation schedule works.
Straight-line, double-declining and sum-of-the-years'-digits depreciation — accelerated methods computed per asset-year (DDB at factor ÷ life in years on net book value, salvage only a floor, switching to straight-line when that gives more; SYD over whole years) and each year's charge spread evenly over its months — with mid-month, mid-quarter (10.5/7.5/4.5/1.5 months by in-service quarter) and half-year (six months of the first year's charge in the first calendar year, the rest after the life ends) conventions.
Quoted from the toolbelt spec, the document this tool was built against.
Where these numbers come from.
Negatives are parenthesised because that is what a statement does. The rest is four promises.
Minor units, never floats
Amounts are integers in the currency's smallest unit, end to end. A float never touches a cent.
Rounded once
Rounded once, at the end — never per operand, which is how a split stops summing to the whole.
Unit tested
The arithmetic lives in one unit-tested module, shared without reimplementation with the extension.
No network
There is no request to make. What you type stays in this tab and is gone when you close it.
More in schedules that tie
- Prepaid & deferred releaseA premium paid on the 17th does not release in twelve equal slices. Day-weighted, or even — your call.
- Loan amortisationLevel payment solved, then walked in minor units so the last payment clears the balance exactly.
- Lease — ASC 842 / IFRS 16PV of the payments at your IBR, the liability unwind and the ROU asset — straight-line for a finance lease, the plug to a level cost for an operating one.
Read it in context
- Founder guide · 4 minWhy startups should close their books every monthA monthly close turns a bank balance into numbers an investor, an auditor or a 409A firm will accept. What it is, and why it gets expensive to skip.
- Founder guide · 4 minAudit-ready books before your Series AInvestors, lenders and auditors ask for the same things: accrual statements, reconciled accounts and support for every balance. How to be ready first.
- Founder guide · 5 minForm 1120: what to give your tax preparer, and whenWhat a startup hands its tax preparer for Form 1120: closed books, a balance sheet that ties to Schedule L, book-to-tax items, ownership and 1099s.
The same number, elsewhere.
A calculator answers the question once. These carry the answer into a product, name what it computed, and argue the method.
- ComponentDepreciationScheduleBook and tax in parallel. In-service date, not purchase date.
- ComponentScheduleTableOne shell, seven presets. Prepaids through debt.
- ComponentRollForwardOpening → movements → closing → tie. The universal shape.
- TermRoll-forwardOpening → movements → closing, proven
- TermAdjusting entryA close entry to apply accrual accounting
- TermDepreciationSpreading the cost of a fixed asset over the periods it serves
- DocSchedules, accruals & roll-forwardsThe supporting evidence layer. Every balance sheet account needs a schedule behind it, and the schedule must tie.
- EntryJournal entry for an equipment purchaseWhen equipment is bought, debit the fixed asset account for its full cost — price plus delivery and installation — and credit Cash or Accounts payable. Nothing is expensed on the day of purchase; the cost reaches the P&L as depreciation.
- EntryJournal entry for depreciationEach period, debit Depreciation expense and credit Accumulated depreciation for the period's charge. The asset account keeps its original cost; accumulated depreciation, a contra-asset, grows until net book value reaches salvage value.
- EntryJournal entry for the sale of a fixed assetWhen a fixed asset is sold, debit Cash for the proceeds and Accumulated depreciation for its balance, credit the asset for its original cost, and book the difference as a gain (credit) or a loss (debit) on sale.
- DocCurrency decimal placesHow many decimals each ISO 4217 code is stored at — JPY 0, USD 2, KWD 3.