Overview:
- This document outlines the Budget Development Process for schools, other than charters, and departments.
- Please follow the directions below to complete and submit your budget.
- Contact the Budget department if you have any questions or have problems with this process. It is our goal to assist as needed.
- You should only enter information in the Requested Budget 2025 and Row_Comment columns.
NOTE: If you have question please contact the Budget Department at (907) 746-9248, (907) 746-9201, or email MSBSDBudget@matsuk12.us for help.
Update Gravity Template Views
Note: If your view does not look like the first screen start at step 2
Gravity Template
Department Non-personnel
- Click and drag the grey ‘pills’ (Fund, Location, Functions, Type, Union, Object, Project) into the blue row directly underneath the grey pills. Leave Account Type and Program where they are

- In the bottom of the screen in purple font is a listing of the current filters as applied to the template. Click on “Clear” in the bottom right corner to remove all filters.

- Select the Column Chooser Icon at the far right of the screen, just above the blue header row.

- In the pop-up box, uncheck Fund, Location, and Type, as well as Preliminary Budget 2025, Preliminary Adopted Budget 2025, Proposed Totals 2025, Adopted Total 2025, 2025 vs 2024, Projected 2026, Projected 2027, Projected 2028, Projected 2029. The templates are already filtered by these, so they are not needed in this instance. If project is not selected, please check the box next to it to have it included in your blue header row.

- Uncheck any of the other columns that you do not need or want to see. This is a personal preference, and columns can always be pulled back in with the use of the Column Chooser icon and pop-up.
- Close the Column Chooser pop-up by clicking on the X in the upper right corner of the pop-up
- Using the Filter icons (not all selections will be available for all schools):
- Project select 00000. There is a separate template for any ###OB projects.
- Programs should only include 000x, 0000, and any program your department manages under project 00000. Please remember you may have programs that start the budget process or fiscal year at the department level and then the amounts you allocate here are distributed to schools at a later date in the budget process. These accounts need to be fully budgeted for the year.
- Functions select all.
- Union (if appreciation payments will not be allocated) check 0 – Non-Personnel, and x-N/A. Leave as is, or select all if appreciation payments need to be budgeted for FY25.
- Select the hamburger next to Main Template on the far left of the screen just above the Account Type pill, then select Save View As…

- Title the view as “Preliminary Budget”, check the Default box, and select save.
- Please note that you can create as many views as you would like. Only one can be set to default, and you cannot share views, they are individual user based.
Gravity Template
School
- Click and drag the grey ‘pills’ (Fund, Location, Functions, Type, Union, Object, Project) into the blue row directly underneath the grey pills. Leave Account Type and Program where they are.

- In the bottom of the screen in purple font is a listing of the current filters as applied to the template. Click on the Clear in the bottom right corner to remove all filters.
- Select the Column Chooser Icon at the far right of the screen, just above the blue header row.

- In the pop-up box, uncheck Fund, Location, and Type, as well as Preliminary Budget 2025, Preliminary Adopted Budget 2025, Proposed Totals 2025, Adopted Total 2025, 2025 vs 2024, Projected 2026, Projected 2027, Projected 2028, Projected 2029. The templates are already filtered by these, so they are not needed in this instance. If project is not selected, please check the box next to it to have it included in your blue header row.

- Select any of the other columns that you do not need or want to see. This is a personal preference, and columns can always be pulled back in with the use of the Column Chooser icon and pop-up.
- Close the Column Chooser pop-up by clicking on the X in the upper right corner of the pop-up.
- Using the Filter icons (not all selections will be available for all schools):
- Programs should only include 000x, 0000, 0629, 0633, 3300
- Functions choose select all, and uncheck function 700 (those amounts will be allocated to schools at a later date in the budget process).
- Union (if appreciation payments will not be allocated) check 0 – Non-Personnel. Leave as is if appreciation payments need to be budgeted for FY25.
- Project choose select all, and then uncheck any ###OB (503OB, 505OB, 506OB, etc.) options
- Select the hamburger next to Main Template on the far left of the screen just above the Account Type pill, then select Save View As…

- Title the view as “Preliminary Budget”, check the Default box, and select save.
- a.Please note that you can create as many views as you would like. Only one can be set to default, and you cannot share views, they are individual user based.
Gravity Template
Department On-Behalf View
- Click and drag the grey ‘pills’ (Fund, Location, Functions, Type, Union, Object, Project) into the blue row directly underneath the grey pills. Leave Account Type and Program where they are.

- In the bottom of the screen in purple font is a listing of the current filters as applied to the template. Click on “Clear” in the bottom right corner to remove all filters.
- Select the Column Chooser Icon at the far right of the screen, just above the blue header row.

- In the pop-up box, uncheck Fund, Location, Type, and ADM Projection 2025, as well as Preliminary Budget 2025, Preliminary Adopted Budget 2025, Proposed Totals 2025, Adopted Total 2025, 2025 vs 2024, Projected 2026, Projected 2027, Projected 2028, Projected 2029 (everything between Requested Check & Row_Comment). The templates are already filtered by these, so they are not needed in this instance.
- If project is not selected, please check the box next to it to have it included in your blue header row.

- Uncheck any of the other columns that you do not need or want to see. This is a personal preference, and columns can always be pulled back in with the use of the Column Chooser icon and pop-up.
- Close the Column Chooser pop-up by clicking on the X in the upper right corner of the pop-up.
- Using the Filter icon for Project, select your locations On-Behalf project (for example, Finance uses 609OB) There is a separate template for each ###OB project.
- Depending on how you want to order your view, you can drag and drop each section in the blue header to sort. Putting the Program in front of location and function will sort the accounts by Program-Location-Function, rather than Location-Function-Program order.
- If you would like to create a subtotal by an account segment, pull that segment from the blue header row back into a ‘pill’ (reverse of step 1).
- Select the hamburger next to Main Template on the far left of the screen just above the Account Type pill, then select Save View As…

- 9. Title the view as “Preliminary Budget”, check the Default box, and select save.
- Please note that you can create as many views as you would like. Only one can be set to default, and you cannot share views, they are individual user based.
Video and Helpful Notes
Helpful Notes:
- Workbooks can be exported to google sheets by selecting the XLSX icon in the top right corner above the row comment column

- The scroll bar at the bottom for scrolling across the page is hidden unless hovering over the exact area where it should be (above bottom total row). It will not appear if everything is visible on the screen. This is also true for the scroll bar to the right of the page to scroll up or down.
- Google sheets save automatically.
- The balance check at the bottom will remain at zero (-) until the first amount has been allocated.
