Depreciation Schedule Report
This report outputs detailed information in relation to the calculation of depreciation up to the current period end. The report can display either tax or accounting values depending on the Report Parameters selected.
Header Details
- Report process date and time
- Page number
- Period end date
- Sort order
Asset Details
This information displays for each asset (grouped using the selected profile).
This is based
on the Print by Summary option
not being selected.
- Asset Code and Subcode
- Description
- Date Acquired
- Original Cost
- Accumulated Depreciation
- Opening Book Value
- Current Period Additions, Adjustments and Revaluations
- Current Period Disposals and Write-Offs
- Current Period Depreciation Recovered and Adjustment Offset.
- Profit/Loss on Disposals
- Depreciation Rate
- Depreciation Type
- Depreciation Value
- Closing Book Value
Several profiles are available to select before running the report. These determine the sort order of the output which can make it easier to separate the report for distribution to different groups. Options include:
- Sort by Analysis Group
- Sort by Asset Code
- Sort by Location
- Sort by Profit Centre
- Sort by Trees
Sub-Totals display using the selected profile and a grand total displays at the end of the report. If the option to Print by Summary is selected, only totals print on the report.
Parameters
These parameters are available when you run the report:
Asset Code From
Enter the first asset code in the range of asset codes that you want to include in the report.
Asset Code To
Enter the last asset code in the range of asset codes that you want to include in the report.
Leave the Asset Code From field empty and enter zzzzzzzzzzzz in this field to include all asset codes in the report.
Profit Centre From
Enter the code or name of the first profit centre in the range of profit centres you want to include in the report.
Profit Centre To
Enter the code or name of the last profit centre in the range of profit centres you want to include in the report.
Leave the Profit Centre From field empty and enter zzzzzzzzzzzz in this field to include all profit centres in the report.
Analysis Group From
Enter the code of the first analysis group assigned to assets that you want to include in the report.
Analysis Group To
Enter the code of the last analysis group assigned to assets that you want to include in the report.
Leave the Analysis Group From field empty and enter zzzzzz in this field to include all analysis groups in the report.
Location From
Enter the first location in the range of locations that you want to include in the report.
Location To
Enter the last location in the range of locations that you want to include in the report.
Leave the Location From field empty and enter zzzzzz in this field to include all locations in the report.
Exclude Zero Value Rows
Select this option exclude assets that have no opening or current year values, for example assets that were disposed or written off in prior years.
Exclude Prior 0 CBV
Select this option to exclude assets whose book value was reduced to zero in a prior year, for example assets that were disposed, written-off, or fully depreciated in prior years.
Print by Summary
Select this option to only include a grand total of the depreciation values for the period. The report will not include any information about individual assets.
Period End Date
Enter the last day of the period for which you want to generate the report.
Print Taxation
Select this option to include any taxation information in the report.
Custom Heading
Enter text in this field that will print directly under the report header.