Attachment E - FY2019 Review Checklist

 

Each division must submit this to BFA by COB, Monday May 21st along with their tracking sheets and any other relevant supporting documentation.  BFA will verify that the divisional or college-level business officer has certified this form and will also conduct budget checks.   

 

 

Division Name:                                        #: ____ Division Certifier:  ______________________________________ Signature:  ________________________________________

 

(IMPORTANT REQUIREMENT:  The divisional or college-level business officer MUST CERTIFY that he or she has performed these checks and has confirmed that the proposed salaries are correct and in agreement with UMCP’s salary instructions.  To certify this checklist, the business officer should directly e-mail this form to BFA or sign a copy and send the hard-copy to BFA.)

 

Review Item

Documents to Send to BFA with this Checklist

Division Comments, as needed

Done?

Salary Checks:  (To Be Updated Once USM Salary Guidelines Are Received)                          (Applies to All Funds, All Ledgers)

1.   Verify the Vice President/President have approved the salary increases that are required by the salary guidelines. The “Salary Adjustments – FY 2019” report and the “Salary Summary by Employee-All Positions-% Increase> 15%” report should help identify the employees who may need further approvals.

 

 

 

2.   Review the “Salary Details by Employee – All Accounts” report for reasonableness, completeness and accuracy as to amounts and funding.  

 

 

 

Budget Checks:                                                                                                                       

(Applies to all Budgetable Accounts)

1.     Using the “Subcode Summary” report (all sources of funding),

·         Verify object codes 9926 and 9931 – NM Transfers within division and NM Transfers within department nets to zero for your college/division (all sources of funding).

 

 

 

2.     Using the “Subcode Summary” report (all sources of funding),

·         Verify turnover (object code 2999) is between 2%- 4% of the division’s itemized salary and wages budget plus social security, retirement and unemployment  (subcodes 1011 – 1020 and 2705, 2715–2760, 2766, 2769- 2771).  If  not between 2% to 4%, adjust your budget.

 

 

 

3.     Using “Salary Variance by Position”, for unrestricted funds-Major Fund Source 40,

·         Review position budgets (dollar and FTE) to actuals for reasonableness. 

·   Are all filled positions budgeted both in dollars and FTE in reasonable amounts?

·   Are vacant positions reasonably budgeted?

 

 

 

4.     Using the  Detailed Budget” Report  (all sources of funding),

·         Review the accounts budgeted  for completeness and reasonableness;  Checks should include:

·                           Are the amounts budgeted reasonable compared to actuals and expected? 

·                           Are positions budgeted for both dollars and FTE in reasonable amounts? 

·         Are the amounts budgeted in the object codes where the actuals will be recorded?

 

 

 

5.     Using the “BPM FTE > 1” Report,

·         Verify positions have budgeted FTE of 1 or less.  If a position shows up on this report, adjust BPM FTE on the position by moving BPM FTE to another position within your department or another department.

 

 

 

6.     Using the “Subcode Summary” report, verify that budgets in these transfer object codes have been eliminated:

·         9922 – MN Transfer Grad School Support

·         9928 – DRIF Funds

·         9929 – Campus Fund Bal Reversion

·         9932 – UGRAD Diff Pricing

·         9939, 40, 41 – Summer, Winter, Freshmen Connection Term Revenue Allocation

·         9953 – NM Transfer Operating Equipment

·         9954 – NM Transfer IDC Fac Renewal

·         9955 – NM Transfer F/C to Plant

·         9957 – NM Transfer Category 2 Fees

·         9959 – Transfer Sustain Award

·         9960 – NM Transfer Capital Set Aside

·         9962 – NM Transfer SFLP Funds

 

 

 

7.     Using the “Working Budget Changes Summary” Report,

·         Verify the aggregate sum of the funds budgeted expenditures and revenues net to zero.  If it does not balance to zero, narrow the support indicator to “1-State Support, then “2-Self-Support”, then “3-Designated”, then “4-Non-Budgeted” to identify the source and then run the “Detailed Budget” report to identify the account(s).

 

 

 

(Applies to State Accounts; i.e., Run all Reports with Support Indicator = 1 – State Support)

8.     Using the “Working Budget Changes Summary” report,

·         Agree each column in the row ‘FY19 Final State Base Budget” on your division’s Attachment F – Working Budget Tracking Sheet to this” report (dollars and FTE) for your division’s state-supported operations. Provide an explanation for any changes made to the tracking sheet after send-out.

·         Verify revenue object codes (0XXX) agree with expense totals. Each account total should equal zero. This will reflect a balanced budget (revenue equals expense).

Working Budget Tracking Sheet

(Attachment F)

 

 

9.     Using the “Subcode Summary” and “Detailed Budget” Report,

·         Verify tuition and fee revenues (including the entrepreneurial programs) have been budgeted as well as the related expenditures.  The budgeted revenue should be approximately the most recent year’s actuals (per KFS) plus the tuition percentage increase for the program.  Please explain any significant variation.

·         For entrepreneurial tuition programs, verify the amount budgeted in object code 9936 – Adm O/H Entrprn Prms has been updated to reflect the updated tuition budget and that the adjustment is reflected on your tracking sheet.

 

 

 

 

(Applies to All Non-State, i.e., Run all Reports with Support Indicator = Non State)

10.   Using the “Subcode Summary” and “Detailed Budget” Report,

·         Are the accounts budgeted in reasonable amounts given past history (KFS actuals) and known plans?  

·         Does each account’s budget net to zero (with the exception of DRIF if your college elects balance at the college rather than the account level)?

 

 

 

11.   Using the “Subcode Summary” Report,

·         Verify that object code 0417–DRIF Allocation balances to zero for your college/division by running the “Subcode Summary” Report.

 

 

 

(Applies to Self-Supports Only --- Accounts that Begin with 28, 3 and the Division of Extended Studies)

12.   Using the “Working Budget Changes Summary” Report:

·         Agree your division’s Attachment G - Self-Support Tracking Sheet(s) to this report both in terms of (dollars and FTE) for your division’s self-supported operations. Provide an explanation for any changes made to the tracking sheet after send-out, such as increased volume of activity. 

Self-Support Tracking Spreadsheet

(Attachment G)

 

 

13.   Using the “Subcode Summary” Report,

·         Verify that object code 9934 – Admin Overhead has been updated.