Reconciliation of Converted Data as of April 30, 2014

1. Reconciliation of Converted Data as of April 30, 2014 Version Date: 8/2014

2. Verifying your revenue and expense balances at conversion • An initial step in any conversion is to verify that your departmental revenues and expenses converted in full • Accounting Services and Grants and Contracts Financial Services verified 100% of revenue and expenses as of the conversion date • We did not verify the budget, department, fund • Departments should be able to go to their Budget Overview and also review their cost center/projects and feel comfortable that all of their data migrated • Need to reconcile your revenue and expenses

3. Reconciliation of Converted Data • The Budget Overview is your best source for reviewing the individual data • We recommend that you view your data with ledger inquiry set OPE_OPR • Provides a snapshot of the expenses side by side with revenue

4. Other Information to note • In DEFINE, if you had a balance forward amount, that came into PS as your Budget • If you have a budgeted amount, plus a balance forward amount, you need to add that together to come to your PS Budget • If you do not have budgeted revenue, but collect revenue during the year, this revenue will need to be associated with your expenses (example 2) – this is only revenue collected, not revenue that may have been a balance forward • In DEFINE your budget groups could have multiple NACUBO codes. In PS, this is split into individual cost centers. You will have to add these together in order to reconcile back to DEFINE (example 3) • Encumbrances had to be keyed into PS manually. Your PS encumbrance amount may not match what is in DEFINE

5. Budget Overview - Create the Inquiry Main Menu >> Commitment Control >> Review Budget Activities >> Budget Overview 1 Navigate to the Budget Overview page Select the tab Add a New Value 2 Enter a name in the Inquiry Name field Select the Add button 3 4

6. Budget Overview – Initial Inquiry Setup 5 Enter a Description Leave the default Business Unit (UTSA1) Choose Ledger Inquiry Set from the Ledger Group/Set dropdown list Enter OPE_OPR in Ledger Group field 6 8 7

7. Budget Overview – Initial Inquiry Setup(cont.) From the *Type of Calendar dropdown, select Detail Accounting Period Change the From Period for OPE and OPR rows(1 = September) Change the To Period for OPE and OPR to rows (8 = April) 9 11 10 Leave checkbox defaults as shown (Including Adjustment Period(s) checked and Include Closing Adjustments unchecked)

8. Budget Overview – Initial Inquiry Setup(cont.) In Section C the Chartfield value column enter the Cost Center 12 In Section D select the Search Button (at the top of the page) 13

9. Budget Overview–Inquiry Results(OPE/OPR Shown from September to April 2014) (+) (+) (-) (-) (-)

10. Budget Overview–Inquiry Results(Associated Revenue Cost Center Example) Associated &Recognized Revenue will appear as shown

11. Other Miscellaneous information regarding the Budget Overview • In reviewing your data, it may be helpful to understand the document labels • Converted data is labeled CNV, with a few exceptions • Post conversion: • Payroll journals are labeled as HPY • Treasury journals that feed from Banner (formerly VC2’s) are labeled as UTZ