Contact information for feeder system (sub-system) journal IDs and other regularly posted journals to the General Ledger.
Instructions for subscribing to GL DSS and CumComp DSS listservs. Receive accounting, GL reporting and CumComp reporting news and information as released by the Accounting & Financial Reporting department.
GL Chartfield Elements, WhoKey & Master File Key (MFK) Resources
- Account (WhoKey) Closure Guidance – Steps to complete to close an account (WhoKey)
- MFK Validation Tool – Online application to validate a single or multiple Master File Keys to determine if the MFK is valid before attempting to post a transaction to it.
- Request for General Ledger Chartfields & WhoKeys Application - Request new Chartfield values and WhoKeys in the General Ledger for the following: Department, Subdepartment, Grant/Programs that start with '3' (Cost Share), '5' (Other - Org Unit/Departmental Programs) or '8' (Gifts), new WhoKeys for Cost Share, Salary Cap (Grant/Program 31111111), Gifts and Other (Grant/Program 00000000 or starts with '5'), and Cost Centers limited to the faculty range of 1000-8999.
- Request for General Ledger Chartfields & WhoKey Application User Manual (pdf)
- GL Chartfield and WhoKey Maintenance Request Guidelines - Guidelines for the necessary information needed by campus to request new GL Chartfields (Department, Subdepartment, Grant/Program and Cost Center) and WhoKeys to be set up or to modify existing values’ descriptions.
- Healthcare IO ( UI Healthcare IO Account Listing.xls) – Valid combinations of IACT/OACT that journal entries can be posted to the General Ledger for Org Units 03, 17, 65-89 & 93-94.
Financial Systems, User Guides & Forms
AFR Financial Systems, Online Applications & Tables List – All systems and tables that AFR is the business owner for, along with a description of the purpose, where to access and the method to gain security access to each system and table.
Cumulative Compensation DSS tables - Query data warehouse CUMCOMP schema tables for cumulative compensation salary and fringe data.
Electronic Financial Reports (EFR) Online Portal – Self Service portal designed to help meet standard financial reporting needs. Houses data & information related to Account Maintenance; Transaction Reports and related Reconciliation Status Report, Unassigned Roles Report and Alternate Reconciliation permission; Summary Reports; Grant Reports; and Dashboards for Org, Departmental and Subdepartmental Administrators.
- EFR & related information FAQ's – General information, WhoKey assignments, TDR and Dashboards information.
- EFR Summary Reports – Access Roles
- EFR Summary Reports User Manual (pdf)
- IACT_EFR_minorcat.xlsx – Institutional Accounts (balance forward, fund balance, expense and revenue) and the EFR Minor Report category that each IACT maps to, which is used for categorizing transactions and balances in various Summary Reports.
- Dashboard User Manual (pdf)
Financial Systems Tools – Self Service search tool application to find details for journal transactions posted through WebCV, PayCV and GLJE.
General Ledger Journal Entry (GLJE) – Post new (“original”), transfer and accrual journal entries to the General Ledger.
- GLJE Access Request Form (Workflow)
- GLJE User Guide for Journals (pdf)
- GLJE User_Guide for Templates (pdf)
- GLJE Training
PayCV – Post correcting salary and fringe expense journal entries to the General Ledger for MFK errors.
- PayCV Access Request Form (Workflow)
- PayCV User Guide (pdf)
- PayCV Guidelines (pdf)
- PayCV Retroactive Cost Transfer Justification > 90 days - Non-Grant Account Form (pdf)
- PayCV Training
Transfer accounting transactions between Agency and University funds
Agency to University Funds Transfer Request Form.docx - requests for transferring amounts with IACTs 3502-3596 Transfer-In and 7502-7596 Transfer-Out between Agency and University Funds (Grant Funds 500 or 510 are handled differently- see next bulleted item) must be approved by the WhoKey Owners of the impacted accounts, and the Director of Accounting and Financial Reporting.
- Using Transfer-in or Out IACTs on Grant Funds 500 or 510 are not normally allowed. WebCV should be used to move expenses. If you are not able to complete the WebCV yourself because the expenses occurred in a prior Fiscal Year or you have a question about whether a transfer is allowed, please contact your Grant Accounting contact for assistance: http://gao.fo.uiowa.edu/contact-us.
WebCV – Post correcting revenue and non-payroll expense journal entries to the General Ledger for MFK errors.
GL DSS & CumComp DSS Online Reporting Security Granted through Secondary Security
- Secondary Security Administrator's Guide (pdf) – Intended only for assisting those administrators needing to use the Secondary Security online application in Self Service to assign security to users for accessing GL DSS and CumComp DSS online reports and the Cash Handling site.