Run the Depreciation Schedule report (New)

Run the Depreciation Schedule to display your organisation'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

  • Choose which information you display in your report:
    • Choose your date range.
    • Group information, for example, group by asset type.
    • Choose additional display information, for example, add accumulated depreciation details.

Run the Depreciation Schedule

  1. Go to Reports, then click 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 user selecting the financial year date range and clicking Update.

Refine your report's settings

Click Report Settings to view the options for refining 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.

Show or hide decimals

Numbers will show to 2 decimal places by default.

To show only round numbers, click to clear the Show decimals checkbox.

Group data and select columns to display on the report

Select an option from Layout to group and subtotal information on the report. Select Standard for no groups.

Select checkboxes for columns you wish to show on the report. Clear a checkbox to hide a column.

Column display options explained

  • 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 organisation.
    Set up tracking categories to monitor different areas of your business

Apply filters

Click Add a filter and select a column to filter by, then enter or select details.

As you add more filters, the report displays results based on all your filters combined.

When you update the report, the filters show at the top in a text block you can edit or delete.

Edit, move or delete text blocks

Click Update to run and view

After you've made your choices, click Update to close Report Settings and view your report.

Sort and reorder columns

Once you've run your report and refined your results, you can:

  • Sort the report in ascending or descending order of the data in any column by clicking on the column heading.
  • Reorder the columns by dragging and dropping them into a different order.

You might also be interested in