You are using an unsupported browser. Please update your browser to the latest version on or before July 31, 2020.
close
You are viewing the article in preview mode. It is not live at the moment.
Home > Citywide > Assets > Reports > Financial > Financial Exceptions
Financial Exceptions
print icon

This report can be used as part of a data gap analysis on the Inventory list. It provides a summary of Amortization Methods, Estimated Useful Lives, Units of Measure in use, and shows Missing Data (e.g., number of assets that are missing a Historical Cost). If something looks out of place, drill down into the asset to verify or edit the data.

For a comprehensive overview or working with Asset Reports in general, see Working with Citywide Asset Reports: A Comprehensive Overview. For an overview of Financial Asset Reports, see Financial Reports (An Overview).

Run a Financial Exceptions Report

Report Types include:

  • Amortization Method – summarizes how Inventory assets are being amortized
  • Estimated Useful Life – lists the EUL values and total number of assets for each
  • Units of Measure – lists units of measure and total number of assets for each
  • Missing/Incorrect Data – searches across several asset fields and returns a total for missing/mismatched data for each field
  • All – summarizes all the above types in a single report

How to use this report:

Review each section, looking for unusual entries. For example, an asset with a 2-month EUL might require a little scrutiny. Click  to expand the segment and drill down to the asset level. The Asset ID field is linked, allowing you to navigate to the asset view and make any adjustments.

  1. Navigate to the Valuation menu screen to update Historical Cost, In-Service Date, Estimated Useful Life, and Unit of Measure.
  2. Navigate to the Amortization screen to adjust the Amortization Method.

If a Year-End Lock has been applied, the Valuation and Amortization information will be read-only. Temporarily disable the year-end lock to make any necessary changes. Please note that changes to Valuation and Amortization will apply retroactive changes to the TCA values, and is not always advisable.

scroll to top icon