Rounding Robin

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.

Download the Excel template

Free. Excel .xlsx format, no macros, no registration.

Contents

TabPurpose
InstructionsPurpose, steps, a guide to each tab, the colour key and a list of every built-in check with its result.
InputsCompany details, dates and the source data. All entry cells are shaded.
ScheduleDepreciation 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 EntryThe entry produced from the schedule, with a check that debits equal credits.
ReconciliationSchedule balances compared with the general ledger, with differences flagged.
ListsAccount mappings and dropdown values, editable to match your chart of accounts.

Features

Instructions

  1. On the Lists tab, set the asset classes, their general ledger accounts and the two disposal accounts.
  2. On the Inputs tab, enter the period end date and fiscal year start date, and choose when depreciation starts.
  3. Enter one row per asset. Each row should show OK in the Data check column.
  4. For an asset sold or scrapped, enter the disposal date and proceeds on its row.
  5. Review the Schedule tab and the roll-forward by class.
  6. Post the entries on the Journal Entry tab.
  7. 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

More accounting templates

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.