Home › Templates › Depreciation Schedule Template
Depreciation Schedule Template
A fixed asset register for up to 200 assets. It calculates depreciation for the month and year to date, handles disposals, rolls cost and accumulated depreciation forward by class, and produces the journal entries.
Free. Excel .xlsx format, no macros, no registration.
Contents
| Tab | Purpose |
|---|---|
| Instructions | Purpose, steps, a guide to each tab, the colour key and a list of every built-in check with its result. |
| Inputs | Company details, dates and the source data. All entry cells are shaded. |
| Schedule | Depreciation by asset: accumulated depreciation at the start of the year and at period end, expense for the month and year to date, and net book value, with a summary by asset class. |
| Journal Entry | The entry produced from the schedule, with a check that debits equal credits. |
| Reconciliation | Schedule balances compared with the general ledger, with differences flagged. |
| Lists | Account mappings and dropdown values, editable to match your chart of accounts. |
Features
- Four methods per asset: straight-line, double declining balance, 150% declining balance and sum-of-the-years-digits.
- Disposals: enter a disposal date and proceeds, and the workbook stops depreciation, removes the asset and calculates the gain or loss.
- Roll-forward of cost and accumulated depreciation by class: opening, additions, depreciation, disposals and closing.
- Journal entries for monthly depreciation and for disposals, listing only the lines that have an amount.
- Each asset class maps to its own cost, accumulated depreciation and expense accounts.
- A data check on every register row identifies missing or inconsistent entries.
- Reconciliation of cost, accumulated depreciation and expense to the general ledger.
Instructions
- On the Lists tab, set the asset classes, their general ledger accounts and the two disposal accounts.
- On the Inputs tab, enter the period end date and fiscal year start date, and choose when depreciation starts.
- Enter one row per asset. Each row should show OK in the Data check column.
- For an asset sold or scrapped, enter the disposal date and proceeds on its row.
- Review the Schedule tab and the roll-forward by class.
- Post the entries on the Journal Entry tab.
- Enter general ledger balances on the Reconciliation tab and resolve any difference.
Notes
Book depreciation only. Depreciation starts in the month an asset is placed in service, or the following month if selected, and stops at the end of the month before disposal. US tax depreciation follows MACRS, which the MACRS calculator covers.
Related calculators
- Depreciation Schedule CalculatorBuild a depreciation schedule by straight-line, double declining, 150% declining or sum-of-the-years-digits, with a partial first year.
- MACRS Depreciation CalculatorBuild a MACRS schedule for 3 to 39-year property with half-year, mid-quarter or mid-month conventions, Section 179 and bonus depreciation.
- Straight-Line Depreciation CalculatorCalculate annual and monthly straight-line depreciation with a year-by-year schedule, including a partial first year.
- Depreciation Method Comparison CalculatorCompare straight-line, double declining, 150% declining and sum-of-the-years-digits depreciation side by side, year by year.
- Double Declining Balance Depreciation CalculatorBuild a double declining balance schedule with an optional switch to straight-line and a partial first year, never below salvage value.
- Sum-of-the-Years-Digits Depreciation CalculatorBuild a sum-of-the-years-digits depreciation schedule with expense and book value for each year, including a partial first year.
- Units of Production Depreciation CalculatorCalculate depreciation based on usage: the rate per unit and the expense for a period from units produced or hours used.
- Rental Property Depreciation CalculatorBuild a rental property depreciation schedule over 27.5 or 39 years with the mid-month convention, after removing land value.
More accounting templates
- Loan Amortization Schedule TemplatePayment-by-payment amortization with extra principal, journal entries for payment, accrued interest and the current portion, and a lender reconciliation.
- Bank Reconciliation TemplateTwo-sided bank reconciliation with outstanding items, book adjustments and the adjusting journal entry.
- Month-End Close Checklist TemplateClose checklist with owners, business-day due dates and status, a recurring entry register and an account reconciliation tracker.
- Accounts Receivable Aging TemplateInvoice-level aging with customer totals, allowance calculation, journal entry and control account reconciliation.
- Prepaid Expense and Accrual Schedule TemplatePrepaid amortization and accrued expense schedules with both journal entries and ledger reconciliations.
- 13-Week Cash Flow Forecast TemplateWeekly receipts and disbursements for one quarter, with closing cash, minimum balance alerts and forecast-to-actual tracking.
Need a version built for your process? Request a custom template quote.
To report an error or request a calculator or template, send feedback.
Templates are provided for general information. They are not accounting, tax or legal advice. Review the formulas and results before relying on them.