SmartFusion Modules > Accounting > Fixed Assets > Reports > Depreciation Schedule

Recent Changes: 
6.217 - Fixed an issue where the cost of asset was doubled when transferred out from a location/department and then transferred back in to the same location/Department at another point of time and the beginning date the report is run for is the same as the transfer date for the asset.

6.206 - "Asset Class" was added as a selection in the second report sequence.
- "Second report sequence" will be available now for selection when we select Asset Group/ Asset Class from first report sequence.

6.200 - "Building" was added as a selection in the first report sequence; When "Department" is selected as the first report sequence, "Building" was added as a selection in the second report sequence

6.177 - Enabled Grid reporting.Added an option to 'Show acquisition date and cost' when run for output option as 'Detail'

6.164 - Reverted the fix for 6.153 because it was found that the logic was needed when assets were depreciated monthly  

6.153 - Fixed an issue where the depreciation for a transferred asset could be included twice in the calculation for "Current Period Depreciation"  

6.150 - Added a new "Consolidated" report type

Refer to bottom of page for changes prior to version 6.150

Introduction

This report will show changes in value of asset acquisition and accumulated depreciation information within the selected time period.

Explanation

Accumulated depreciation will only show values if calculate depreciation records have been created.

Select report type - Original (default) or Consolidated
Select report sequence #1

  • Asset Class
  • Asset Group
  • Building
  • Department
  • Location

Run by department or location to see transfer information.

Select report sequence #2

  • Asset Class (for Asset Group, Building, Department, Location as 1st report sequence)
  • Asset Group (for Asset Class, Building, Department, Location as 1st report sequence)
  • Building (for Asset Group, Asset Class, Department, Location as 1st report sequence)
  • Department (for Asset Group, Asset Class, Building, Location as 1st report sequence)
  • Location (for Asset Group, Asset Class, Building, Department as 1st report sequence)

Select output - Detail (default) or Summary
Date Range
Funds to include
Include cost detail subtotals - Will include cost subtotals as part of detail section on the report.
Include fully disposed assets
Depreciable assets only
Include inactives
Show acquisition date and cost - Visible only for output option as Detail. When checked will show the acquisition date and cost for each asset.

Data Selections - Filter based on the following criteria:

  • Asset class
  • Asset groups
  • Asset numbers
  • Buildings
  • Departments
  • Locations

There are five type of records on the report when running by location / department sequences.

  • Acquisition - This is rolled into the starting date value column section on the asset line for existing assets. A separate line item shows that it was an added acquisition.
  • Depreciation - Denoted by DEP. This is specifically for showing depreciation certain values in the accumulated depreciation section.
  • Disposal - This is a disposal line item.
  • Transfer In - This line item is depicting that a transfer occurred and was transferred into the department / location the line item is a part of.
  • Transfer Out - This line item is depicting that a transfer occurred and was transferred out of the department / location the line item is a part of.

Reference

Calculate Depreciation

Changes Prior to Version 6.150

6.144 - Fixed an issue where the report when run by Asset Group/Asset class report sequences was not looking at transfers.

6.104 - Fixed an issue where for disposed assets with a disposal date in the period the report is being run the current period depreciation was not getting pulled correctly.

6.103 - Fixed an issue where the depreciation was not being pulled for assets that had an account change but no transfers. This only occurred when the Department report sequence was selected when tracking by Department or when the Location report sequence was selected when tracking by Location.

6.82 - Changed data pull to look at base depreciation amount instead of the acquisition cost for "As of" values.  

6.64 - Fixed issue where the accumulated depreciation on Partially disposed assets varied from FY Ending balance to Beginning balance.  

6.63 - Fixed issue where you couldn't save a filter

6.53 - Fix an issue where acquisitions was pulling from the acquired department rather than its origin, so the calculations were coming out incorrect.

6.49 - Ensuring balance is displayed in the "as of date" column for acquisitions or disposals.

6.31 - Fixed an issue where the report was run for a single department and if a transfer happened from a department not included in the range,  The report would not display the entire amount of the asset.

6.25 - Added support for adding acquisitions after transferring and corrected depreciation schedule from including an extra record when printing by department / location. 
    - Adjustment to report to fix multiple transfer problem scenarios so that the starting year values are allocated correctly and to the right department / location.