ctcLink Reference Center9.2 Finance9.2 FIN - Asset ManagementResourcesAsset Management Checklist & Process Steps Guide

Asset Management Checklist & Process Steps Guide

Purpose:  Use this document as a reference to assist in the standard or end-to-end processes in chronological order for a specific Finance Module.

Audience:  Finance Staff

The following spreadsheet below provides the standard key processes to Asset Management, such as: Express Add, AP PO checklist, Asset Management roles, and Queries/Reports.

Asset Management Checklist and Process Steps Guide

Or for better accessibility, use the following drop-down checklist style for the Asset Management Checklist & Process Steps Guide:

Adding an Asset by 'Express Add' Checklist

To view inserted information, select the down facing arrow on the right of the checklist title.   

This is entering an asset for the first time.  The payment may have been made in AP and the PO may have been made in purchasing; but by entering it in an express add you are manually entering into the AM module and not pulling it from AP or purchasing. If you wish to pull from AP and/or PO do not use this process - go to the tab "PO AP add checklist".

The asset information includes profile id, description, location and tag number if applicable.  Note the asset id will say "next"..leave this alone (unless your college policy is to number your own).  On transaction date this is the date the asset was put in place.  The acctg date is generally the date you processed this; which would be today's date (one exception might be end of year where you might want it to be 6/30/20xx.  Leave the Transcode blank).

The asset cost information will by default populate the book name as WACTC and quantity as 1 - if it's more than 1 quantity you can change this.  Enter cost, category and cost type.  Cost type is very important and will determine whether the asset will be treated as a governmental or proprietary fund. Remember that state funds are 997.

Once you have entered an asset by an express add it is only partially processed.  The next step is to run the depreciation calculation.  This is a bit of a misnomer, as the process is necessary regardless of whether an asset is going to have depreciation or not (example: land is not depreciated, but it would still need to be run as part of the process).

In this step you are creating the accounting entries. This is prepping the accounting lines to be picked up by the General Ledger.  It also creates the journal generate to report accounting to the general ledger, also called JGEN. NOTE:  step 4 and 5 don't have to be entered after each express add is created; if you had 10 express adds to enter you can create all 10 and THEN do steps 4 and 5.

NOTE:  Assets are now  in Asset Management and in the GL (except for monthly depreciation)

This is only done at the end of the months after ALL edits, adds, retirements, and adjustments are run.  This can be confusing; step 4 does NOT create the depreciation to be recorded in the general ledger (it only records in the asset management)- The reason this step 6 is important is because the system does not know when you want to record your monthly depreciation in the general ledger - this step tells it you are ready. DO NOT CLOSE THE ACCOUNTING PERIOD this is referring to the QRG in which it explains accounting periods; if you do close it by mistake it's a big deal.  You will have to have IT do a sql to fix.  So don't do it (unless specifically instructed by SBCTC Accounting - which is rare).

END

Adding an Asset by 'PO/AP Interface' Checklist

To view inserted information, select the down facing arrow on the right of the checklist title.   

NOTE:  SBCTC recommends adding Assets by Express Add

In order to utilize the AP/PO process the voucher or PO must have been marked as assets in either the voucher or po - and for the PO to be pulled into the AM module it must have a receiver. This first step originates in the AP side and it is the business decision of the college as to which module should initiate the the first step, the AP side or Asset side.

It is of course recommended that you review your data - but this step is an optional step that will not stop the process if you do not navigate to it. This is one of two points at which data can be edited before sending to the AM module.

In this step you are pulling data from the AP/PO side into another staging  table within Asset Management.  It is not yet actually in the module but a staging table.

In this step you have the second opportunity to review data and make corrections.  It is optional.

Optional.  At this point the data still is not in the AM module thus you can make some changes.  Consolidation is used when assets need to be COMBINED.  For example; if you had two assets come across and one is a component of the first you can consolidate them together as one asset.

Like consolidating, Unitizing is optional.  Unitizing is used when assets come across combined and they are separate assets.  For instance; if you bought two servers at the same time you might want to unitize (split apart) so you have two separate assets.

This is the final process to load data into the Asset Management system.  After this point the data will be edited by going into the area that needs to be fixed (access through "find an asset" and not the staging tables).  Even though your data is now in the AM module, it is not in the General ledger.  To get your newly entered assets  into the General Ledger do the next two steps (depreciation Calculation and Accounting Entries).  After this point the system/process mirrors that of the Express Add checklist in which the depreciation calculation and Accounting entries need to be done.

Once you have entered an asset by the AP PO process (as stated above) it is only partially processed. It is at this point that the steps are exactly the same as the Express Add.  The next step is to run the depreciation calculation.  This is a bit of a misnormer, as the process is necessary regardless of whether an asset is going to have depreciation or not (example: land is not depreciated, but it would still need to be run as part of the process).  Another thing that might be confusing; is that depreciation is calculated for the SCHEDULE within the  AM module; but no monthly depreciation is sent to the general ledger.  That is done at the end of the month.

This is the step in which you are creating the accounting entries. This is prepping the accounting lines to be picked up by the General Ledger.  It also creates the journal generate to report accounting to the general ledger, also called JGEN. (remember, this is only reporting adjustments,  retirements,  and adds to the general ledger the depreciation is sent to the general ledger in different process - the next process)

This is only done at the end of the months after ALL edits, adds, and adjustments are run.  This can be confusing; step 8 does NOT create the depreciation to be recorded in the general ledger (it only records the schedule in the asset management)- The reason this step 10 is important is because the system does not know when you want to record your monthly depreciation in the general ledger - this step tells it you are ready. Note:  be sure you run the depreciation calculation and accounting etries process before you close for the month - in other words, all edits, retirements, and adds need to be in and run to completion before running the Depreciation Close.    DO NOT CLOSE THE ACCOUNTING PERIOD this is referring to the QRG in which it explains accounting periods; if you do close it by mistake it's a big deal.  You will have to have IT do a sql to fix.  (So don't do it unless specifically instructed by SBCTC Accounting - which is rare).

END

Asset Management Roles

Role:  ZZ AM Interface Processing - Access to retrieve info from AP/PO, Consolidate Assets, Unitize Assets and Load in Asset Management

Role:  ZZ AM Local Configuration - Access to InterUnit Pair, InterUnit Pair Mass Maintenance, InterUnit and IntraUnit Template, Location, Period Allocation, Setup Validation, System Transaction Definition, System Transaction Mapy, Transaction Code

Role:  ZZ AM Period End - Access to Close Accounting Period for Asset Management

Role:  ZZ AM Physical Inventory - Access to Create Schedules, Define Criteria, Define Inventory Occurrence, Load/Match/Reconcile PI Info, Physical Inventory Control, Process CSV Files, Review Matching Result, Scan Options, Verify Duplicate Serial ID, Verify Duplicate Tags, Verify Scanned Data

Role:  ZZ Asset Entry - Access to Basic Add, Copy existing assets, Create parent/child assets, Express Add assets, View Asset Depreciation

Role:  ZZ Asset Processing - Access to Change/Delete Pending Transactions, Adjust, Transfer, Re-Categorize Assets, Retire Assets, Update/Review Non-Capitalized Costs

Role:  ZZ Depreciation Processing - Access to Perform Depreciation Processing, View Depreciaton

Role:  ZZ Asset Management Reporting - Access to AM Facilities Data Report, AM/Billing Transaction Status, AM/GL and NBV, AP/AM Payment Reconciliation, Account Activity Summary, Account Entry, Acquisitions, Advanced Depreciation, Asset Component Hierarchy Move, Asset Net Book Value, Asset Reclassifications, Transfers, Auto-Retired Assets, Business Tax, By Location, Cost Activity, Create Accounting Entries, Depreciation Activity, Depreciation by Fiscal Year, by Period, Extended Depreciation, Footnote Disclosure, Gain/Loss, Group Member Estimated NBV, Hazardous Assets by Location, History, Lease Expiration, License Information, Process Allocation, Reconciliation AP/AM, Retirement Activity and Information, Run Physical Inventory Reports, Summary or Detail

Queries and Reports

The needs for assets vary.  You can use the reports available by navigating to Asset Management > Financial  Reports > Asset Details > Acquisitions.

There are also queries.  By going to the Query Viewer: Navigation:  Reporting Tools > Query > Query Viewer.

  1. Select Advanced Search hyperlink.  Do a contained search on the Folder Name by entering Asset.  (Presently, there are 22 to search from).
Query Viewer Search Screen
  1. The result is a list of some of the available queries for you to utilize.  Presently, there are 20.  If these do not meet your needs, consult the Metalink list.
Image of common queries

END

You are done. Great job!

0 Comments

Add your comment

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