AssetManager Pro Depreciation by Asset Group Report
Asset Depreciation by Asset Group Report
Depreciation Reports
Product:
AssetManager Pro
Version:
2017 (v6)
MYOB Upgrade Info
NEW formatted MS Excel output
NEW Additions, Adjustments and Disposals Columns on Level 1, Level 2 and Level 3
UPDATED Level 2 and NEW Level 3 options (as a result of additional columns)
ENHANCED outputs that EXCLUDE assets NOT acquired in YTD Period of Report
NEW Asset Group Level Disposal Adjustments and Sub Totals (Provides Asset at Cost, Prior Dep and YTD Dep adjustments)
Overview
Asset Depreciation by Asset Group report The Asset Depreciation by Asset Group report displays your asset values and depreciation according to your asset groups. It includes the ability to do that a Group Summary level or at an Asset detailed level. You can filter this report Book or Tax, for all groups or for a selected asset group. You can also filter for a range of assets.
Report Access
For information on how to access reports via the Index to Reports or via the AssetManager Pro Analyst click here.
Output Options
- Screen
- Print
- MS Excel
Filter Options
- Selected Asset Range (Select by Asset ID or Name)
- Selected Asset Group (Select by Group Name)
- Report Period (YTD Monthly Selection)
- Report Level (1 - Summary, 2 - Detailed Asset Name Only, 3 - Detailed inc Asset ID and Depreciation Settings)
- Report on Book or Tax
- Order by Asset ID or Asset Name
- Filter on Depreciation Type (All Methods, Full Depreciation on Purchase and Prime Cost and Diminishing Value Depreciation)
Report Level/Grouping Options
- Level 1 - Summary per Asset Group
- Level 2 - Detailed Asset by Asset Group (Asset Name Only)
- Level 3 - Detailed by Asset by Asset Group (inc Asset ID and Depreciation Method, Life/Rate and Calculated details)
Report Totals
- Group Totals
- Group Totals for Disposed Assets (Less Disposed Assets)
- Group Totals less Disposed Assets (After Disposed Assets)
- Grand Totals
- Grand Totals for Disposed Assets (Less Disposed Assets)
- Grand Totals less Disposed Assets (After Disposed Assets)
Level 1 Report - Summary per Asset Group
Sample Output - Level 1 Summary
Report Columns/Data - Level 1 Summary
Data/Column | Populated with | Calculation Info |
Asset Group | Name of Asset Group | |
Acquisition Cost | Total Acquisition Cost Value for Asset Group | |
Prior Depreciation | Total Amount of Prior Depreciation for Asset Group up until the START of the Current Financial Year per Asset Group | |
Opening Value | Total Amount of Opening Written Down Value of the Asset at the START of the Current Financial Year per Asset Group | Opening Value = Total Acq Cost less Prior Depreciation +/- Prior Adjustments |
Additions Value | The total cost any Assets Acquired during the YTD reporting period per Asset Group | |
Adjustments | Total Cost Adjustments or Revaluations during the YTD reporting period per Asset Group | |
Depreciation | Total of CURRENT YEAR Depreciation during the YTD reporting period per Asset Group | |
Disposals | Total value of any Disposals (inc Write-Offs) during the YTD reporting period per Asset Group | |
Closing Value | Total Closing Vale of the Asset as at the END of the YTD reporting period | Closing Value = Total Opening Value plus Additions Value +/- Adjustments less Depreciation less Disposal Value |
Group Totals | Totals of all the values above per Asset Group | |
Group Totals - Disposals | Totals for the value of any Disposals during the YTD reporting period per Asset Group | |
Group Totals - After Disposals | Totals for the values above less any disposals per Asset Group | |
Group Totals | Totals of all the values above for ALL Asset Groups | |
Group Totals - Disposals | Totals for the value of any Disposals during the YTD reporting period for ALL Asset Groups | |
Group Totals - After Disposals | Totals for the values above less any disposals for ALL Asset Group |
Excel Output - Level 1 Summary
Supported via Excel output which includes the following outputs which differ from display/printed report
- Asset Group Header shown as value in Column
- Additional Reductions Column which shows ?
- Additional Decline After Reductions Column which shows ?
Level 2 Report - Detailed Asset by Asset Group (Asset Name Only)
Sample Output - Level 2 Detailed Asset by Asset Group (Asset Name Only)
Report Columns/Data - Level 2 Detailed Asset by Asset Group (Asset Name Only)
Reports displays following key columns/data and is populated with
Data/Column | Populated with | Calculation Info |
Asset Group Header | Header showing Asset Group related to detailed Assets shown below it | |
Asset Name | Name of Asset | |
Depreciation Start Date | Date of when Asset Depreciation starts (Acquisition Date) | |
Acquisition Cost | Original Acquisition Cost of Asset | |
Prior Depreciation | Amount of Prior Depreciation up until the START of the Current Financial Year | |
Opening Value | The Opening Written Down Value of the Asset at the START of the Current Financial Year (Does NOT include Assets Acquired during the year) | Opening Value = Total Acq Cost less Prior Depreciation +/- Prior Adjustments |
Additions Value | The cost of the Assets Acquired during the YTD reporting period | |
Adjustments | Any Cost Adjustments or Revaluations during the YTD reporting period for that specific Asset | |
Depreciation | Any CURRENT YEAR Depreciation during the YTD reporting period for that specific Asset | |
Disposals | Value of any Disposals (inc Write-Offs) during the YTD reporting period for that specific Asset | |
Closing Value | The Closing Vale of the Asset as at the END of the YTD reporting period for that specific Asset | Closing Value = Total Opening Value plus Additions Value +/- Adjustments less Depreciation less Disposal Value |
Group Totals | Totals of all the values above per Asset Group | |
Group Totals - Disposals | Totals for the value of any Disposals during the YTD reporting period per Asset Group | |
Group Totals - After Disposals | Totals for the values above less any disposals per Asset Group | |
Group Totals | Totals of all the values above for ALL Asset Groups | |
Group Totals - Disposals | Totals for the value of any Disposals during the YTD reporting period for ALL Asset Groups | |
Group Totals - After Disposals | Totals for the values above less any disposals for ALL Asset Group |
Excel Output - Level 2 Detailed Asset by Asset Group (Asset Name Only)
Supported via Excel output which includes the following outputs which differ from display/printed report
- Asset Group header shown as Column Value
- Disposal Date
- Additional Reductions Column which shows ?
- Additional Decline After Reductions Column which shows ?
Level 3 Report - Detailed Asset by Asset Group (Includes Asset ID and Depreciation Details)
Sample Output - Level 3 - Detailed Asset by Asset Group (Includes Asset ID and Depreciation Details)
Report Columns/Data - Level 3 - Detailed Asset by Asset Group (Includes Asset ID and Depreciation Details)
Reports displays following key columns/data and is populated with
Data/Column | Populated with | Calculation Info |
Asset Group Header | A header line showing Asset Group related to detailed Assets assigned to that Asset Group | |
Asset Details Header | A header line showing specific details of the Asset including Asset ID, Depreciation Method, Depreciation Rate/Life and Calculation Basis for the specific Asset listed below it | |
Asset Name | Name of Asset | |
Depreciation Start Date | Date of when Asset Depreciation starts (Acquisition Date) | |
Acquisition Cost | Original Acquisition Cost of Asset | |
Prior Depreciation | Amount of Prior Depreciation up until the START of the Current Financial Year | |
Opening Value | The Opening Written Down Value of the Asset at the START of the Current Financial Year (Does NOT include Assets Acquired during the year) | Opening Value = Total Acq Cost less Prior Depreciation +/- Prior Adjustments |
Additions Value | The cost of the Assets Acquired during the YTD reporting period | |
Adjustments | Any Cost Adjustments or Revaluations during the YTD reporting period for that specific Asset | |
Depreciation | Any CURRENT YEAR Depreciation during the YTD reporting period for that specific Asset | |
Disposals | Value of any Disposals (inc Write-Offs) during the YTD reporting period for that specific Asset | |
Closing Value | The Closing Vale of the Asset as at the END of the YTD reporting period for that specific Asset | Closing Value = Total Opening Value plus Additions Value +/- Adjustments less Depreciation less Disposal Value |
Group Totals | Totals of all the values above per Asset Group | |
Group Totals - Disposals | Totals for the value of any Disposals during the YTD reporting period per Asset Group | |
Group Totals - After Disposals | Totals for the values above less any disposals per Asset Group | |
Group Totals | Totals of all the values above for ALL Asset Groups | |
Group Totals - Disposals | Totals for the value of any Disposals during the YTD reporting period for ALL Asset Groups | |
Group Totals - After Disposals | Totals for the values above less any disposals for ALL Asset Group |
Excel Output - Level 3 - Detailed Asset by Asset Group (Includes Asset ID and Depreciation Details)
Supported via Excel output which includes the following outputs which differ from display/printed report
- Asset Group header shown as Column Value
- Disposal Date
- Additional Reductions Column which shows ?
- Additional Decline After Reductions Column which shows ?
Related Articles
Setting up Asset Groups
Each asset group, , will be set up to include default accounts, depreciation methods, and the basis of depreciation calculations. By default, an asset will use the properties that are associated with the asset group to which it is assigned. As such, ...Using MYOB AccoutRight Classic and Live with AssetManager Pro - Depreciation Journals (v4 or later)
Overview AssetManager Pro has been designed to integrate into a range of popular Accounting systems including MYOB AccountRight, Reckon Accounts, Intuit QuickBooks Online and Xero. The following article provides an overview of integrating with the ...Disposing of an Asset
Disposing of an Asset Disposing of an asset usually refers to the sale of an asset. When you dispose of an asset you need to create an asset transaction to record the details of the disposal. There a number of rules governing the disposal of assets ...AssetManager Pro 2018 v7 Release Info
Overview Information on the GRAGA AssetManager Pro 2018 (v7) upgrade. AssetManager Pro 2018 Upgrading from MYOB AssetManager Pro? If you are a current MYOB AssetManager or MYOB AssetManager Pro user you will find a lot has changed with AssetManager ...AssetManager Pro 2019 v8 Release Info
Overview Information on the AssetManager Pro 2019 (v8) Release. AssetManager Pro 2019 Upgrading from MYOB AssetManager Pro? If you are a current MYOB AssetManager or MYOB AssetManager Pro user you will find a lot has changed with AssetManager Pro! ...