1 / 10

UNFUNDED MANDATES REPORT

UNFUNDED MANDATES REPORT. Deriving the Payroll Related Expenditure Amounts. The instructions that follow show how Salary & Benefits by GL Report can be configured to get the numbers needed for producing the Unfunded Mandates Report each district has recently been asked to produce.

hoang
Download Presentation

UNFUNDED MANDATES REPORT

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. UNFUNDED MANDATES REPORT Deriving the Payroll Related Expenditure Amounts

  2. The instructions that follow show how Salary & Benefits by GL Report can be configured to get the numbers needed for producing the Unfunded Mandates Report each district has recently been asked to produce. It is recommended that you save the report settings so that the data can be easily extracted for this report if/when requested again at a future time. Procedures for setting up the report and for saving report defaults are illustrated below.

  3. Using the Salary & Benefits by GL Report will allow you to quickly derived the payroll related numbers needed to meet the requirements of the Unfunded Mandates Report. • MENU LOCATION • Payroll • PR Check Processing • Regular Checks • Computed Reports • Salary & Benefits by GL Report

  4. Salary & Benefits by GL Report 1. Select Check Date 2. Enter Fiscal Year Date Range 4. Check the Include Gross Amount box; other boxes should be unchecked. 3. With column 1 selected, choose Employer and check all matching deductions 5. Enter component selection as shown; note the sort order should be set to zero. Setting the report for “NC Instructional Support Personnel (101-109; 210-250)

  5. Click “Enter” to run the report. Sample output is shown below. MCAI SCHOOL DISTRICT The total in the far right-hand side reflects the total of all salary and benefits paid during the 2008 fiscal year for object codes 101-109 and funding sources 1110, 6001-6690, and 6810-6981. After running the report, follow the instructions on the next page to save the report criteria.

  6. 1. Click the Save button to store the report settings as a saved report SAVING REPORT/QUERY SELECTION CRITERIA 2. Enter a name for the saved report. A suggested name is “UNFUNDED MANDATE 101-109”. 3. Click “Save” to store the report definition

  7. After running and saving the report to get the total for the first value, change the object code range to 110-179. Click “Enter” to run the report and get the total of all salary and benefits paid during the 2008 fiscal year for object codes 110-179 and funding sources 1110, 6001-6690, and 6810-6981. Setting the report for “NC Instructional Support Personnel (110-179; 210-250)

  8. After running the report for object code range 110-179, save the report criteria. As before, after clicking the Save button, you will be prompted to enter a name for this save d report. A suggested name for this iteration is “UNFUNDED MANDATE 110-179”. For the final number need in the upper section of this report, change the object code range to have a value of 180-180. Run the report to get the total of all salary and benefits paid during the 2008 fiscal year for object code 180 and funding sources 1110, 6001-6690, and 6810-6981. Save the report as “UNFUNDATED MANDATE 180”. Please note that the NON PERSONNEL COST section of the report will need to be determined by running reports from the General Ledger. A trial balance report run through the 12th fiscal period of 2008 for the specified account components as defined on the report should provide the needed information for this section of the report.

  9. Due to the fact that there is some leeway in coding expenditures in the accounting system that correspond to the requested values in the bottom section of the report, we are not giving specific examples for producing this section. However, you will use the same technique to derive the needed values. For example, if your technology coordinator is paid from funding source 1221 only, you will delete all of the specified components previously entered on the GL Component screen and enter Source of Funds 1221-1221 with a sort order of zero (0) on the GL Component screen. If your district charges the technology coordinator to another account combination, you will need to specify the value(s) on the GL Component Selection screen to uniquely identify this position. In doing the bottom section of this report, you may wish to check the boxes to Print Employee Detail and Print GL Account Detail so that you can see exactly who is being reported based on the account code component values you have entered.

  10. As with the previous sections, you should define the GL component criteria needed to derive the number for each line, Run the report to get the dollar amount, and Save the report values for later use. Once you have defined and saved the values for each line on the report, you will need to run each of the saved reports for the other two fiscal years. This is done by clicking the Default button, selecting the report name, clicking “OK”, changing the check date range and clicking Enter to run the report.

More Related