USAS Profile Review and Cleanup Procedures –
Correction of Incorrect General Ledger and Comptroller Object Relationships
Reports and Procedures
Report PCU133 – Non-Expenditure Objects with Expenditure Accounts
Type | Exception |
---|---|
Source | GL table |
Purpose | The report identifies all non-expenditure objects and their current balances in expenditure accounts for activity in the CY. |
Procedures
See Review Procedures below.
Report PCU132B – Non-Revenue Objects with Revenue Accounts
Type | Exception |
---|---|
Source | GL table |
Purpose | The report identifies all non-revenue objects and their current balances in revenue accounts. |
Procedures
See Review Procedures below.
Report PCU134 – Non Other Sources and Uses Objects with Other Sources and Uses Accounts
Type | Exception |
---|---|
Source | GL table |
Purpose | The report identifies all non-other sources and uses objects and their current balances in other sources and uses accounts. |
Review Procedures
- Verify whether the GL account (GL) balances in these reports offset:
- For report PCU132B, GL accounts 5000, 5001 and 5100 must offset.
- For report PCU133, GL accounts 5500, 5501 and 5600 must offset.
If the GLs offset, no correction is needed.
If the GLs do not offset proceed with step 2.
- Analyze the report information to determine whether the comptroller object or GL account is incorrect.
- Determine the transaction code needed for correction.
- Enter the correcting transactions in USAS. In general, transactions entered with the wrong GL account or with the wrong comptroller object must be reversed and re-entered with the correct element.
- Verify the results.
Notes:- Comptroller object 3972: This comptroller object should be used with T-codes 403/404. If the object appears on report 132B, in GL 5000 or 5001, it was not used correctly (T-codes 403/404 post to operating transfer GLs).
- 3971/7971 roll up as revenue and thus will not be seen on these reports when used with T-codes 405/406.
- Object code 3986, UB Cash Bal Forward-Operating Trans In, is used to UB balances resulting from operating transfers.
- A commonly seen exception on report 132B is comptroller object 3750–Sale of Furniture and Equipment with T-code 195, which posts to a Revenue GL account. For GAAP purposes, this activity should be reported as Other Financing Sources/Uses. Therefore, the sale of furniture and equipment should instead be recorded using T-code 191, which includes recording the sales of fixed assets and posts to Other Financing Sources (GL 6035). Since T-code 191 also posts to Cash in State Treasury (GL 0045), entries after Aug 31 cannot be backdated. For correcting entries made after Aug 31 that need to be back-dated, use T-code 657, which posts to GL 6035.
Examples
Please note that the following are included as examples of corrections and may not be proper for your agency. Each transaction listed on the report must be thoroughly analyzed to determine the necessary adjustment.
Example I:
GL account must be corrected. This example illustrates a revenue transfer (405/406) that should have been recorded as a cash operating transfer (403/404).
Report Element | Original Entry | Reversal Entry | Correcting Entry |
---|---|---|---|
Amount | $1,000 | $1,000 | $1,000 |
T-code | 405/406 | 405/406 | 403/404 |
GL Account | 5000/5000 | 5000/5000 | 6010/6050 |
PCA | 12345 | 12345 | 12345 |
Appropriation | 12345 | 12345 | 12345 |
Agency Fund | 0001 | 0001 | 0001 |
Comptroller Object | 3970 | 3970 | 3972/7972 |
Object Group* | 30 | 30 | 32/33 |
Reverse Indicator | R |
*Object Groups
30 = Revenue 32 = Transfer In 33 = Transfer Out
Example II:
Comptroller object must be corrected. This example illustrates comptroller object 3972 that should have been entered as comptroller object 3004.
Report Element | Original Entry | Reversal Entry | Correcting Entry |
---|---|---|---|
Amount | $1,000 | $1,000 | $1,000 |
T-code | 405 | 405 | 405 |
GL Account | 5000 | 5000 | 5000 |
PCA | 12345 | 12345 | 12345 |
Appropriation | 12345 | 12345 | 12345 |
Agency Fund | 0001 | 0001 | 0001 |
Comptroller Object | 3972 | 3972 | 3004 |
Object Group* | 32 | 32 | 30 |
Reverse Indicator | R |
*Object Group
30 = Revenue