Run the Depreciation Schedule report (New)
Run the Depreciation Schedule to display your organisation's depreciation and fixed asset value.
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.
- 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.
- Go to Reports, then click All Reports.
- Under Fixed Assets, click ... to expand the section if the report is hidden.
- Click Depreciation Schedule (New).
- Select a date range, then click Update to view your report.
Refine your report's settings
Click Report Settings to view the options for refining your report.
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
- Cost Account
- Cost Limit
- Effective Life
- For a taxable purpose
- To produce exempt income
- To produce non-assessable exempt income
- Expense Account
- Residual Value
Asset types entered in your assets' details. Not account numbers (in your chart of accounts).
Accounts (in your chart of accounts) you've coded your assets to.
If you've set a ceiling value on any high value (luxury) items for the purposes of depreciation claims.
How long (in years) a depreciating asset can be used:
Accounts (in your chart of accounts) you've coded your assets' depreciation expense to.
Purchase dates entered in your asset details.
Assets purchased during your selected date range.
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.
Salvageable value at the end of the effective depreciation period. This value will limit the minimum book value amount for depreciation.
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
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.
Click Update to run and view
After you've made your choices, click Update to close Report Settings and view your report.
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.