Run the Depreciation Schedule report (New)

Run the Depreciation Schedule to display your organisation's book 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 financial year date range.

Customise your report

Click Report Settings to customise your report.

Image showing report settings selected

The number of display options included in your report determines whether your report prints in portrait format or landscape format.

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 book 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 organisation.

    Set up tracking categories to monitor different areas of your business