Run the Depreciation Schedule report (New)

Run the Depreciation Schedule to display your organization's depreciation and fixed asset value.

Image showing the depreciation schedule

About the Depreciation Schedule

  • The Depreciation Schedule is an improved report. It replaces the previous Depreciation Schedule, which you can still run.
  • Although you can run this report from any date, we recommend you run it from a date on or after you started depreciating fixed assets in Xero. If you run it from a date earlier than this, the figures may not be correct.

  • The Depreciation Schedule displays data from registered items in your fixed assets register. It's good practice to first update your fixed asset register and run depreciation before you run the Depreciation Schedule.

    Maintain the fixed asset register

    Run depreciation on registered fixed assets

  • You can choose how the report groups transactions, and what extra details it displays.

Run the Depreciation Schedule

  1. In the Reports menu, select All Reports.
  2. Under Fixed Assets, click ... to expand the section if the report is hidden.
  3. Click Depreciation Schedule (New).
  4. Select a date range, then click Update to view your report.

Image showing someone selecting the fiscal year, called 'This Financial Year', and clicking Update.

Customize your report

Click Report Settings to customize your report.

Image showing report settings selected

The number of display options included in your report determines the orientation of the report, when exported to PDF. Xero will first look at the minimum width required for the date and numerical columns. Any remaining space will then be equally split across text columns.

We'd recommend keeping all text columns together on the left of the report, so that the format of the report is kept tidy.

Column display options

  • Asset Type

    • Asset types entered in your assets' details. Not account numbers (in your chart of accounts).

  • Cost Account

    • Accounts (in your chart of accounts) you've coded your assets to.

  • Cost Limit

    • If you've set a ceiling value on any high value (luxury) items for the purposes of depreciation claims.

  • Effective Life

    • How long (in years) a depreciating asset can be used:

    • For a taxable purpose
    • To produce exempt income
    • To produce non-assessable exempt income
  • Expense Account

    • Accounts (in your chart of accounts) you've coded your assets' depreciation expense to.

  • Purchased

    • Purchase dates entered in your asset details.

  • Purchases

    • Assets purchased during your selected date range.

  • Rate

    • The depreciation rate you've set for the asset.

    If you've set an effective life value for an asset, no rate will display. You can't have a rate and an effective life.

  • Residual Value

    • Salvageable value at the end of the effective depreciation period. This value will limit the minimum book value amount for depreciation.

  • Tracking

    • Tracking categories you've coded your assets to. This option appears only if you have set up tracking in your organization.

    Set up tracking categories to monitor different areas of your business

You might also be interested in