ABE/AcceleGrants Budget Guidance

Accessing the Budget Sections:

The budget pagescan be accessed through a link on the Funding Application Sections page. Clicking these links will bring the applicant to the Budget Home page for each funding source or local match.

Figure 1 – Funding Application Sections page excerpt

Budget Home Page:

The Budget Home page is the main entry point for viewing and updating Budget data. It contains a table which lists the object codes used by the Budget, a description of the object codes, and the total amount that has been budgeted against each of these object codes. The last line shows you the difference or balance between your adjusted allocation (available funds) and what you have submitted through the process of completing the budgets. The following is a list of object categories and a brief description of each.

51000 = Personnel Services - Compensation – Used for positions and associated compensation for employees of the district. Payment for consultants and contractors should not be included in this section.

52000 = Personnel Services - Employee Benefits – This is used for all benefits costs relating to positions and salaries budgeted in the 51000 series.

53000 = Purchased Professional & Technical Services – Items budgeted in this section include: Payments for the purchase of temporary administrative and office personnel; Professional Educational Services such as Diagnosticians, Occupational Therapists and Interpreters; Purchased Training and Professional Development Services; Conference Registration Fees, Catering or Reimbursement for Refreshments at Trainings or Meetings, Other Purchased Professional Services such as Legal, Compliance, Physicians; and Other Purchased Services such as Data Processing and Testing. Please see guidance below concerning software.

54000 = Purchased Property Services – This budget section includes Cleaning, Repairs, Utilities, Rentals, andTelephone and Wireless Communications.

55000 = Other Purchased Services – Included in this section are budget items for Transportation, Insurance, Advertising, Printing, Tuition, Travel &Hotel expenses related to attendance at trainings, Training,and Interagency Services such as services purchased from another school district or educational services agency (collaborative).

56000 = Supplies and Materials – Items budgeted in this section include General Supplies, Energy, Maintenance Supplies, Books and Periodicals, andTechnology related Supplies. Please see guidance below concerning software and equipment.

57000= Property and Equipment – This section includes budgeted expenditures for Buildings, Vehicles, Furniture, Technology – Hardware and Software, and Other Equipment. Please see guidance below concerning software and equipment.

58000 =Miscellaneous – This series is used to budget for Dues & Fees.

60000 = Indirect Cost – Indirect Cost Recovery within approved rate.

Decision Matrix

Object / Object / Tangible / Web-based / Instruction / Operations / Technology
Number / Name / Software / Software / Related / Related / Supplies
53221 / Virtual Classrooms / X / X
53222 / Web-based Supplemental Instructional Programs / X / X
53502 / Other Technical Services / X / X
56407 / Web-based Software and Databases - Library / X / X
56501 / Technology-Related Supplies / X / X / X / X
57311 / Technology Software / X / X / X

Guidance -- Equipment vs Supply

The UCOA Capitalization Policy addresses the threshold values for accounting for purchases of software, hardware, and other tangible assets.

UCOA Capitalization Policy: RIDE’s Capitalization Policy requires that tangible, nonexpendable, personal property that has a useful life of more than one year and an acquisition cost of $5,000 or more must be tagged for tracking and inventory purposes. Further, computer equipment (defined as devises or equipment that can receive, store and transmit data) with a useful life of more than one year and an acquisition cost of $500 or more must be tagged for tracking and inventory purposes. RIDE also allows for lower thresholds to be used by Districts and Charter Schools, at their discretion. The UCOA accepts and follows these guidelines for capitalization of assets on the Balance Sheet.

UCOA Tangible Personal Property Policy: For Object Expenditure purposes, the following criteria will apply: Tangible, nonexpendable, personal property that has a useful life of more than one year shall be recorded in specific Object accounts in the 57000 (Property) series. Tangible, expendable, personal property, irrespective of the length of the economic life is recorded in the Object 56000 (Supplies) series.

Examples of items in each category are noted below:

Classified with Property / Classified with Supplies
Computers, Laptops, Notebook computers, PDA’s I-Pads / Adding machines, calculators
Monitors, Printers, Projectors, Copiers, Scanners / Computer cables, mouse devices, flash-drive storage devices, monitor stands, mouse pads
Desks, File Cabinets, Credenzas / Desktop File Holders, diskettes, keyboards, drive storage devices
Software media such as Microsoft Office, Software for management systems such as Library and Operations / Certain Web-based software and databases for Library use
Athletic equipment such as goal posts, tennis court nets, whirlpools, medical equipment / Athletic supplies such as baseballs, uniforms, medical supplies
Refrigerators, Freezers, Ovens / Food service uniforms and wearing apparel, serving utensils
DVD Players, Televisions, DVR’s / Music CD’s, DVD’s, movies
Machinery such as drill presses, grinders, floor polishers, snow removal equipment, microscopes, typewriters, telephone systems / Small tools, such as hammers, screwdrivers, pliers, wrenches, rakes, shovels

Below the table are links which navigate to the Budget Summary and Budget Matrix. To view or enter data, click the object code. This will take you to the Budget Details page.

Figure 2 - Budget Home page

Budget Details Page

The Budget Details page shows all of the line items that have been entered to date for the selected object code.

Figure 3 - Budget Details page

From this page, there are several actions an applicant can take:

  1. Clicking the Edit icon navigates to the Edit Budget Details Line page and pre-fills that page with data for the corresponding line item.
  1. Clicking the Delete icon will delete the corresponding line item.
  1. Clicking the Copy icon will create a copy of the corresponding line item and navigate to the Edit Budget Details Line page for the copy that was just created allowing you to change all or part of the item to create a new line items without having to re-enter all the information on a blank screen.
  1. When there are multiple line items, clicking on the column headings (Loc-Bldg, Ftn, Prg, Subj, etc.) sorts all of the line items up or down in ascending or descending order based upon the column clicked on.
  1. Clicking the “Add Line” link displays the Edit Budget Details Line page shown below which provides a blank screen.
  1. Clicking the “Return to Budget” button displays the Budget Home page.

Create Budget Details Line Page:

The Create Budget Details Line page allows you to perform a variety of actions. When you are taken to this page, you can create a new budget line item, editan existing line item or copy an existing line item. Once you’ve created the new line, you also have the option of creating a new line from the one you just created and saved by simply changing just those items that need to be changed rather than re-entering all of the lines from the blank screen. The budget detail displayed on this page includes the following:

1)Uniform Chart of Account (UCOA) NUMBER:

The UCOA sequence is as follows:

Location – Function – Program – Subject – Object – Job Code

Location: School or Department

Function: Activity (Teaching, Leadership, PD)

Program: Broad Objective (Regular Ed, Spec. Ed.)

Subject: Curriculum (Math, Science, Athletics)

Object: Budget Item (Salaries, Purchased Services, Supplies)

Job Code: Superintendents, Teachers, Aides, Custodians, etc.

In order to facilitate the budget development, each cell within the UCOA sequence has been prefilled with zeros, except for the first two digits of the Function and Object codes. RIDE anticipates that the LEA’s program and finance staff will need to collaborate in order to complete the budget detail section. With the account number zero-filled, the system will allow program staff to enter information in the description, reserve, cost basis, justification and amount fields prior to finance completingthe actual account numbers during their review. This feature enhances the speed and flexibility of entry at the user level.

Drop down selections are provided for the Function and Object codes since the coding of these numbers will determine the placement of these budgeted amounts within the budget matrix. Please refer to the UCOA Coding Guide for the description and code number of each of the fields in the UCOA sequence. The numbers displayed in the UCOA Coding Guide for each field within the sequence represent the minimum acceptable level of coding for each budgeted line item.

2)DESCRIPTION: Indicate the position to be funded, services to be provided, or the item(s) to be purchased.

Examples:

Description: Reading Teacher

Description: Consultant – Professional Development

Description:Math Textbooks

3)RESERVE: Budgeted line items must be identified as part of a specific required reserve.

Reserve typesfor Match Budgets are as follows:

  • Cash
  • In-Kind

Reserve types for the ABE, EL Civics, JDF, and General Revenue Budgets are as follows:

  • Administration
  • Unspecified

4)COST BASIS: Here you will describe in more detail the position, service or purchase. This is a free-type field that will allow you to enter Hours, Rates, Units, Prices, etc. in order to provide more specifics concerning your line item.

Examples:

Cost Basis: 100 hrs x $150/yr, Consultant Services

Cost Basis:250 Trigonometry Texts @ $75/each

Cost Basis: 1 Yr service contract to provide 25 (2.5hr) training sessions

5)FTE:Enter the number of “Full Time Equivalent” employee positions funded. This field must be completed in both the salary (51000) and benefit (52000) object codes for all employees. System will validate that the total # salary FTE’s equals the total # benefit FTE’s.

Example: One Reading Teacher working on a grant program for 17.5 hours a week of a full time 35 hr/wk schedule equals 0.50 FTE funded by the grant.

6)JUSITIFICATION: Additional descriptive information can be provided here to link your line item request more specifically to the grant.

Examples:

Justification: Focused efforts toward improving literacy

Justification: Prof Dev – Improving literacy across the curriculum

Justification: Improvement of Math proficiency

7)PRIORITY:Used in conjunction with the planning tool, grantees will be able to associate budgeted expenditures with priorities identified in the agencies strategic plan to better understand how it is using its resources to meet its objectives.

8)AMOUNT: Enter here the budget amount associated with this line item. This field, along with all of the other fields, can be edited if changes are necessary.

Figure 4 - Budget Details Line Page (Create, Edit, or Copy Function)

Completing Line Item Entry:

  1. A set of option buttons determine the behavior of the page when the “Save” button is clicked.
  1. Add New (default): When this option is selected, clicking the “Save” button will save the data and reload this page. The form fields will be cleared and ready to receive data for another entry. In other words, this page will behave as if you had just clicked the “Add Line” link on the Budget Details page.
  1. Create Copy: Clicking the “Save” button with this option selected will save the data and reload this page. When the page reloads, the form fields will contain a copy of the data that had been entered previously. This allows the user to quickly enter an item that is similar to the original item. Rather than re-typing data in all of the fields, the user can just change the appropriate field(s) and click the “Save” button again.

Note: When using this option, be sure that the object code has been changed to reflect the appropriate series, i.e. Salary, Benefits, etc. Failure to do so will result in the data being incorrectly classified on the Budget Summary and Budget Grid.

  1. Return to Budget Details: This option will save the data and then navigate to the Budget Details page for the object code that was originally selected on the Budget Home page.
  1. Return to Budget: This option will save the data and navigate to the Budget Home page.

Copy Function - Entire Prior Year Approved Budget (By Funding Source):

Accelegrants has the capability to copy the last approved budget from the prior year into the new fiscal year budget. The copy function is located on the budget page. The copy function is not available in FY 2017 for all Adult Education budgets. Caution: Use of the copy function will zero out any previously entered budget data.

Hints on organizing your budget for entry into the AcceleGrants System:

  1. Grant Funding - Accelegrants is organized by the type of grant, i.e. Title I, IDEA, etc. Organizing your budget by grant as a first step will assist with entry of your information.
  1. Salaries & Benefits – There are two ways to enter this information. The first is to enter all of your salaries for the particular grant first and then by copying the salary lines and changing the object code from 51000 to 52000 to represent the benefits,you can save time and errors by modifying only those sections necessary such as the amount.

Another way to do this is to enter a salary line and then immediately “save and create a copy” to modify as the benefit line.

  1. All Other Series – Enter budget lines by object series to minimize data entry.
  1. Indirect Cost is a user value ($) input on the budget details page and is system validated to insure that the amount is within a calculated limit.
  1. Please use the following UCOA code when budgeting indirect:

00000-530-00-2500-60000-0000

Guidance for Budgeting Salary & Fringe Benefits:

If you are planning to budget a salary against a grant, you must budget any corresponding benefits for that position against the grant at the same level (FTE) of support. If there are insufficient funds to budget both the full salary and benefit costs against the grant, then they must be reduced proportionately.

For every compensation budget line (51000) created, a fringe benefits line (52000) must also be created. Combine the net benefits cost (ex: health, retirement, taxes) for each compensation line in the budget so that if there are 12 compensation lines in a program budget there should also be a total of 12 fringe benefit lines. If there are no benefit costs associated with a compensation line, still create a benefit line in the budget with a cost of zero ($0.00) and insert “no benefit costs incurred” so that budget reviewer can determine that the benefits line was not unintentionally omitted.

When creating any budget line for compensation or fringe benefits, an appropriate jobs code must be entered into the UCOA jobs field. A jobs code entry of 0000 is not correct of any budgeted lone item in compensation or fringe benefits.

Additionally, to avoid supplanting local funds with federal funds, the percentage of total compensation on each position supported with federal funds next year should not exceed the total percentage supported this year.

For Example:

In the Current Fiscal Year, ABE supports 100% (1.0 FTE) of a Teacher’s salary totaling $75,000.00 and local funds support 100% of that Teacher’s fringe benefits totaling $25,000.00. Restated, ABE supports $75,000 or 75% (0.75 FTE) of this teacher’s total cost of compensation ($75,000. + $25,000 = $100,000.) When budgeting the salary and fringe benefits for this year (as now required), the total FTE supporting both salary and benefits should not exceed 75% (0.75 FTE).

Budget Summary & Grid Pages:

The Budget Summary & Grid Pages are view only screens. These pages serve to further delineate the program budget and provide users with additional details of the intended use of funds. The Grid Page is organized and aligned to the IN$ITE financial reporting categories. The Summary Page includes information on the use of funds for specific reserves.

System Error Validation:

The AcceleGrants system performs a number of budget and program validations before the application can be advanced for approval. System errors are issues that must be resolved while system warnings will not stop the application from being advanced in the approval path.

Printing:

When the Print icon is clicked on in the Sections page, the Budget Summary, Budget Detail, and all Application Detail pages will be included in the generated PDF document.

Budget Export:

AcceleGrants has the ability to export each program budget into an excel spreadsheet.

Page 1 of 12 / May13, 2016