Review Useful Life for Depreciated Assets

Purpose: The Office of Financial Management (OFM) occasionally changes the Useful Life value for a selected Commodity Code. This export report provides the current Useful Life Value for each asset alongside the current value in the SAAM manual.

Audience: Business office personnel that maintain depreciation records for capital assets.

The State Board will notify Megamation of any updates to the SAAM manual as they occur so the commodity code table will stay current, but any existing DirectLine records will not be automatically altered.

When that happens, the affected asset in DirectLine needs to be updated with the new Useful Life and any adjusting accounting entries made.

 

Navigation: FAE Module / Export Reports / Equipment Inventory - Lifespan

From the DirectLine main menu:

  1. Select FAE Inventory
  2. Select Export Reports
  3. Select Equipment Inventory - Lifespan
  4. Select OK

You have the option of sorting or filtering on a variety of criteria before clicking Export. The results will display in a list like this:

You can apply Excel formulas to compare the "Life Span" and "Useful Life Expected" for any differences.

If you identify assets that need to be updated, navigate to the module for that asset (most likely Equipment Inventory)

  1. Navigate to Eqp Inventory
  2. Select Eqp Inventory
  3. Select Eqp Inventory Info
  4. Select Eqp Inventory Entry
  1. Use information from your extract report to enter the asset ID
  1. Select FAE/Cost tab to display the Commodity Code and Life Span fields

You'll notice the Life Span field is gray and not available to edit. You have to use the Commodity Code field to input your corrections.

  1. Delete any data in the Commodity field and click out of the field
  2. Use the Commodity Code drop-down list and select your item. DO NOT type in the Commodity Code!
  3. You will notice the Life Span field is updated to the current value assigned by OFM in the SAAM manual.

Any changes to the useful life values will change the depreciation calculations.  You'll see a warning message reminding you as much and to run a fresh CR2128 and make note of the entries in the "Differences" columns.

You can keep a copy of the Excel workbook along with the CR2128 as your supporting documents for your year-end adjusting entries.

0 Comments

Add your comment

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.