15.05 Reconciliation of FIS Activity, Chancellor's Office Business Policies & Procedures

Purpose:

To establish policies and procedures associated with reconciliation of FIS activity.

Policy:

Business Processing Staff reconciles FIS accounts at minimum of quarterly and provides Department Heads with corrective action necessary.

Procedures:

1. Periodically (at a minimum of quarterly), for each index, Business Processing Staff compares transactions in FIS to supporting documentation and researches and resolves any discrepancies. This reconciliation should include all transactions, including personal services. The two reports that staff find most useful are FWRFOAP (for personal services) and FWRODTH (for all other transactions). See additional information below about these Banner Reports.
2. Business Processing Staff informs the Department Head when the reconciliation is complete. This notification includes any unresolved discrepancies as well as corrective action necessary.

Banner Query Forms:

FWIFOAN - Employee Within FOAP

Used to query personal services expenses for a specified fiscal period (sorted by employee or account code) NOTE: Be sure to complete the parameter for the Index or Organization Code to query only your department's budget status.

Banner Reports:

FGRODTH - Organization Detail History

NOTE: Be sure to complete the parameter for the Index or Organization Code (from and to) to print only your department's budget status

FWRODTH - Transaction Detail History

Similar to FGRODTH, with the following differences:

• It can be generated across the fiscal year
• It includes ALL transactions before and after a change that occur in the defaults of the index
• The output can be in the form of a printed report or downloaded into a spreadsheet
• It does not have the budgetary error inherent in FGRODTH

Note: Be sure to complete the parameter for the Index or Organization Code (from and to) to print only your department's transaction detail.

FWRFOAP - Payroll Detail by Organization

Used to show all personal expenses (salaries, wages, overtime, OPE, etc.) for employees paid by index.

• This report can be generated for a specified fiscal period or the entire fiscal year (if the fiscal period field is left blank).

Note: Be sure to complete the parameter for Index to print only your department's salaries

Last Updated: 01/30/04