Administration and Finance Focus
 
 

                                                                                                               

August 2010 Clean-Up

Departments should complete the following tasks during August to prepare themselves for the end of the fiscal year:

1. Run queries to identify transactions not fully processed during FY10 (enter dates 09/01/09 to 08/31/10 in the queries):

    � UHS_WF_AP_NOT_POSTED (regular vouchers not posted)
    � UHS_WF_BUD_NOT_POSTED (budget journals not posted)
    � UHS_WF_GL_NOT_POSTED (GL journals not posted)
    � UHS_WF_REQ_NOT_APPROVED (requisitions not approved)
    � UHS_WF_SC_NOT_POSTED (SC vouchers not posted)
Delete all transactions that will not be processed before the FY10 deadline.

2. Run the UHS_OPEN_COMMITMENTS_DETAIL query to identify all PO encumbrances on your cost centers. (Non-PO encumbrances such as payroll, phone, and postage will be released by Finance.)

Release any PO encumbrances that will not be used following the PO Finalize Instructions on the Finance References page (under Cost Center Verification Toolkit).

3. Run the following queries to identify P-Card and Travel Card liability balances on your cost centers (also included in the monthly spreadsheets sent by AP to College/Division Administrators):
    � UHS_PCARD_LIABILITY_BALANCE
    � UHS_TRAVEL_CARD_LIAB_BALANCE
Submit GL journals in period 12 and/or period 998 to make these liability balances zero on each cost center.

4. Run the Payroll Suspense Report and clear any payroll found to the correct cost center.

5. Run the 1060, 1070, or 1016 reports for your cost centers to identify deficit fund equity balances (i.e., positive balances). (Finance also sends a report, subtotaled by fund group and DeptID, to College/Division Administrators.)

Transfer expenses, revenue, or fund equity, where allowed, in period 12 and/or 998 to make the fund equity balances either zero or a negative amount.

The combined fund equity of cost centers in a fund group (1xxx, 2xxx, etc.) for a particular DeptID should be either zero or a negative amount at the end of the fiscal year. The only exception is fund 5 cost centers where the timing of funding creates a temporary deficit balance. Also, individual fund 9 cost centers should never have a deficit (positive) balance at any time during the fiscal year.