GMART InstructionsInstructions and guidance for LEAs using the SIG online system to submit, view, and modify budget and expenditure data.
The Grant Management and Reporting Tool (GMART) is a system that allows local educational agencies (LEAs) to submit, view, and modify budget reports, expenditure reports, and budget revisions.
Currently, the GMART allows grant recipients to manage fiscal requirements for the School Improvement Grant (SIG). However, future updates to the GMART may allow recipients to view LEA payment data and connect other grants managed by the School Turnaround Office (STO) to the system. It is recommended that this page be reviewed prior to logging into the GMART.
GMART is best viewed with:
Chrome 56.0 or higher
Internet Explorer 11.0 or higher
Mozilla Firefox 51.0 or higher
Safari 5.1.7 or higher
When submitting a budget revision through the GMART, the LEA should first contact their assigned Education Programs Consultant (EPC) to discuss proposed changes. The EPC may require that the LEA submit additional documentation including a revised implementation chart.
Narrative remarks are required for all budget revision requests. Briefly describe and justify each requested change in the remarks textbox (maximum of 1500 characters). For narrative remarks greater than 1500 characters, please submit a cover letter to the assigned EPC by e-mail.
For example: Object Code 1000 was reduced by $25,000 because a reading specialist was not hired until later in the school year (Q2); Object Code 2000 was increased by $25,000 to hire two additional part-time tutors for the after school program to address increased student enrollment.
The GMART is designed to use the latest available Indirect Cost Rate (ICR) and estimate the indirect cost of the remaining years of the grant.
For example: If the ICR for fiscal year (FY) 2017–18 is 5.38%, the same rate will be used to estimate the indirect cost for the 2018–19, 2019–20, and 2020–21 FYs. Once the ICR for the 2018–19 FY is available, for example 4.75%, then the rate to estimate the indirect cost for the 2019–20 and 2020–21 FYs will change to 4.75%.
Generally, the LEA is not permitted to modify prior year budgets and expenditures, or transfer funds from one entity to another. If such modifications are being considered, a compelling case must be submitted by the LEA to its assigned SIG Fiscal Analyst. While each request will be considered on a case-by-case basis, the California Department of Education (CDE) cannot guarantee approval.
If there are errors in the budget, expenditure, or budget revision data, the LEA will not be able to submit the report. All error messages must be addressed in order to submit the report to the CDE.
The session in GMART will timeout after 20 minutes of inactivity and the user will need to login again to continue. Please note that while data in tables will be stored, certain text may be lost due to the timeout and may need to be re-entered.
Use the menu within the GMART to navigate within the system and to return to the GMART Home Page. Please do not use the forward or back options of the browser.
To print a page, use the print function in the browser. This is usually found in the File menu. The GMART application does not contain a print option.
Budgets and Quarterly Expenditure Reports
Expenditure Reports in "Approved" status for the current year cannot be modified online. If either type of report has already been approved and needs to be modified, contact your SIG Fiscal Analyst and be prepared to provide reasons as to why the report(s) should be made available for modifications. A staff member will review the request and, if approved, the report(s) will be made available for editing.
Expenditure and budget fields require data entry and cannot be left blank. Enter “0” as the amount where there are no actual expenditures or no budget allocations. If “0” is not entered in the appropriate field, an error message will appear and the LEA will not be able to submit the report.
The dollar amounts on all pages can be entered numerically with a decimal point depicting cents, as well as with symbols such as dollar signs ($) and commas (,) when entered in the correct position.
The following are acceptable formats for an amount:
The GMART Pages
User names and passwords have been e-mailed to program coordinators as of July 1, 2017. Passwords are case sensitive. The LEA cannot reset or change the password. If more than five attempts to login have been made within one hour, the GMART will lock the user out of the system. If the LEA has forgotten the password, or has been locked out of the system, please contact the CDE STO at 916-319-0833.
GMART Home Page (Select LEA)
The GMART Home Page displays a table of SIG funding for the LEA including all of its school sites being served. Select a school site from the displayed list to access the budget, budget revision, and expenditure information.
LEA Contact Information
Upon site selection, the user will be directed to the LEA Contact Information Page. This page displays self-reported coordinator data and must be updated by the LEA in the GMART. This data will be used to send updates and notifications pertaining to the SIG program. The LEA should not send update requests to its SIG STO contacts. The LEA Contact Information Page requires the following information for the LEA SIG Coordinator and Budget Analyst:
CDE Contact Information
The LEA may view this page to find its SIG STO contacts. The assigned SIG Education Programs Consultant and SIG Fiscal Analyst name, phone number, and e-mail address are displayed here.
The New Budget Page is available to create the five-year budget for each site. A budget must be submitted for each site even if the funding amount is zero for that site. The New Budget Page shows the LEA name, site name, and the budget status at the top of the page.
Below are the various possible budget status options:
Initial Budget: the budget has not been submitted. Line items can be added, edited, or deleted, if desired.
Proposed Budget Pending CDE Review: the budget has been submitted and the CDE is reviewing the request.
Approved Budget: the budget has been submitted, reviewed by the CDE, and approved.
Object codes can be selected from the drop-down menu to add a new line item. The system will ask for details for the line item to be entered. Once the item is saved, it will be displayed in the table below. Items can be edited or deleted from the table as necessary. The following fields are included in the budget table:
Field Name Notes Model Component Code Model component number in plain text format (max 25 characters allowed): e.g. "SD 01" Object Code Major object codes must be selected when adding budget items. Object codes cannot be edited Minor Sub Code Minor sub codes can be a number ranging between its corresponding major object code and the next major object code (For example: Minor Sub Code for Object Code 3000 can be between 3001 and 3999) Budget Item Description Item description in plain text (max 1000 characters allowed) Budget Year 2016-17 Budget amount for year 2016-17 Budget Year 2017-18 Budget amount for year 2017-18 Budget Year 2018-19 Budget amount for year 2018-19 Budget Year 2019-20 Budget amount for year 2019-20 Budget Year 2020-21 Budget amount for year 2020-21
The budget table will show error messages if the grand total does not match the funding amount for the given year. The funding details (Implementation Type, Funding Amount, Carryover, Available Funds, Expenditures-to-date, and Remaining Funds) for all five years are displayed on this page.
When the budget table is free of errors, a “Remarks” textbox and an option to submit the budget to the CDE will become available. The remarks textbox cannot be left blank. Once the budget has been submitted, line items cannot be edited or deleted.
The Indirect Cost line item value will change dynamically as the budget amount in the budget table is entered, deleted, or edited. Indirect costs less than the maximum allowed may be entered. However, if an indirect cost higher than the maximum allowable amount is entered, the system will revert the amount to the maximum allowable indirect cost.
The remarks history table can be displayed by selecting the "Show Remarks History" option. The budget table can be exported to a Microsoft Excel spreadsheet by selecting the "Export Budget to Excel" option. When selected, a file called "BudgetDataExport.xls" will be downloaded. This file can be opened to view or save for future reference.
Once the budget is approved, the "New Budget" option in the menu is replaced with a "Budget History" page.
The Expenditure Reports Page displays the LEA name, site name, and expenditure status at the top of the page. In addition, it shows the school year and the quarter for which the expenditure report needs to be submitted. Different statuses that indicate the current phase of the expenditure report are described below:
Current Quarter: the expenditure report can be reported for this quarter.
Locked Quarter: an expenditure report cannot be submitted for this quarter.
Submitted Quarter: the expenditure report has been submitted and is being reviewed by the SIG Fiscal Analysts at the CDE.
Approved Quarter: the expenditure report has been approved for this quarter.
The school year can be selected from the drop-down list if needed. The expenditure table displays line items corresponding with each budget item. The following fields are included in the expenditure table:
Field Name Notes Model Component Code Model component number in plain text format (max 25 characters allowed). e.g. "SD 01"; cannot be edited Object Code Major object codes cannot be edited Minor Sub Code Minor sub code cannot be edited Budget Item Description Item description in plain text (max 1000 characters allowed); cannot be edited Year 20xx-xx Budget Budget amount for year 20xx–xx; cannot be edited Quarter 1 Expenditure Quarter 1 expenditure amount Quarter 2 Expenditure Quarter 2 expenditure amount Quarter 3 Expenditure Quarter 3 expenditure amount Quarter 4 Expenditure Quarter 4 expenditure amount Expenditures-to-date To-date total expenditure for the year 20xx-xx Remaining Amount Remaining funds available for the year 20xx-xx
New line items cannot be entered on the Expenditure Reports Page and only expenditure amounts for the current quarter may be edited. When the “Edit” option is selected, a textbox will open for all four quarters; however, only the data for the current quarter may be entered (shown by a green background of the textbox).
Quarterly expenditures and budget revisions cannot be entered at the same time. If the quarterly status shows the open quarter, but the system is not allowing for expenditures to be entered, the user should check the status of the Budget Revision Page. It must show as "Approved Budget.” Selecting the option to "Cancel Budget Revision" may be necessary to open the Expenditure Reports Page. For more information, refer to the details on the Budget Revision Page.
Dollar amounts of up to 110 percent of the budget amount may be entered for a given line item. Please note that the total year-to-date quarterly expenditures may not exceed the total budget amount.
The expenditure table displays error messages if the conditions listed above are not met. In case of errors, the expenditure report cannot be submitted to the CDE.
Once the quarterly expenditure report has been submitted to the CDE, it cannot be modified. When the expenditure report for a given quarter is approved, the GMART locks that quarter and opens the next available quarter. If the 4th quarter for a given year is approved, the GMART opens the 1st quarter for the following school year.
It is permissible to submit a quarterly expenditure report with a total expenditure amount of zero.
The Budget Revision Page displays the LEA name, site name, and budget revision status at the top. There are two options in which the LEA can view the Budget Revision Page:
Five-year view: the five-year view displays the model component code, object code, minor object code, budget item description, and budget for all five years. New budget line items may be added in this view.
One-year view: in this view, modifications may be made to the model component code, budget item description, or budget amount for the line item in the given year. This table also displays the difference in the revised budget amount and year-to-date expenditures for referencing.
There are three different indicators that let the LEA know the current status of its budget revision:
Approved Budget: the budget has been submitted, reviewed by the CDE, and is approved.
Budget Revision Edit: an edit has been made to the budget for the first time in the one-year view.
Proposed Budget Revision Pending CDE Review: a budget revision has been submitted and the CDE is reviewing the request.
The funding details are displayed in both the five-year view and the one-year view. When the "Show Sub-total Details" option is selected, the page displays the budget’s sub-total details based on the object codes.
For each line item revision, the LEA must revise the line item description which pertains to the activity that is changing. New line item descriptions will erase descriptions which were entered previously. The LEA must ensure that a complete and accurate description is entered when submitting the revised line item.
Please note that an explanation and justification for the proposed change must be entered into the comment box. The LEA cannot submit the budget revision until a complete and thorough explanation is provided and the LEA justifies how the proposed change continues to meet its identified needs and directly aligns to its improvement goals and planned intervention and/or activities.
For example: If the LEA is completing a budget revision to reduce the number of full-time science teachers from two science teachers to one science teacher, the line item description being revised, which states “two full-time science teachers,” should be replaced with a new line item description stating “one full-time science teacher.” The comments section should explain why the change was made and justify how the LEA will continue to meet the need described in the LEA needs assessment.
The "Show Remarks History" option displays the history of all budget revision status changes.
The "Export Budget to Excel" option downloads the data in Microsoft Excel file format. The file can be opened to view or save for future reference. The file name in the one-year view is "BudgetRevisionOneYrDataExport.xls" and the file name in the five-year view is "BudgetRevisionFiveYrDataExport.xls."
Object codes from the drop-down list can be selected to add a new line item. The system will ask for details such as Model Component Code, Minor Sub Code, Budget Item Description, and Budget for the five years to be entered. Once the item is saved, it will be displayed in the table on the Budget Revision Page in the GMART. The items from the table may be edited as necessary.
Quarterly expenditures and budget revisions cannot be entered at the same time. If the quarterly status shows the open quarter, but the system is not allowing for expenditures to be entered, check the status of the Budget Revision Page. It must show as "Approved Budget.” Selecting the option to "Cancel Budget Revision" may be necessary to open the Expenditure Reports Page.
The budget table will show error messages if the grand total does not match the funding amount for a given year. The details of funding (Implementation Type, Funding Amount, Carryover, Available Funds, Expenditures-to-Date, and Remaining Funds) for all five years are displayed on this page.
When the budget table is free of errors, a “Remarks” textbox will appear as well as an option to submit the budget to the CDE. The remarks textbox cannot be left blank. Once the budget is submitted, line items cannot be edited or deleted.
The Indirect Cost line item value will change dynamically as edits are made to the budget amount in the budget table. While indirect costs less than the maximum allowable amount may be entered, indirect costs higher than the maximum allowable amount will revert to the maximum allowable indirect cost.
The Budget History Page displays all past budgets that have been approved. This includes the initial approved budget as well as all subsequent approved budget revisions.
At the top of the page the LEA name and site name are displayed. Also, funding details are displayed on this page.
Different versions of the budget can be selected from the drop down menu found on the Budget History Page. Each version has an associated date of approval.
The budget history can be exported to a Microsoft Excel file by selecting on the "Export Budget to Excel" option. It will download a file called "BudgetDataExport.xls" on to your computer.
The entire history of the approval cycle can be viewed by selecting the "Show Remarks History" option.