For Missouri school districts and charters
Your district's yearly workbooks, as web tools.
Yellow Cells rebuilds the Missouri DESE, State Auditor and USDA workbooks a school district fills in every year as web tools that do the arithmetic and check the rules.
$1,000 a year per district. Every user, every tool. Full refund within 30 days.
One price for the district
$1,000 a year covers every user and every tool. Invite as many colleagues as you need by email. Charters pay the same.
Student files stay on your computer
A file you import into a tool is read in your browser. No student-level file is ever uploaded to our servers.
Try three tools first
Three tools are free and need no account. There is no free trial of the rest, and there is a 30-day full refund.
Made for the people who fill these in
Each tool names the people who fill in the workbook it replaces. Four of those roles, with some of the tools that name them:
Bookkeepers
Estimated ADA and Membership Impact, Prop C Rollback Calculation, FSMC Indirect Cost Calculator and 6 more.
Board secretaries
Fund 1 to Fund 4 Transfer Calculator, 2025 Revision of Prior Year Tax Rate Calculator (Single Rate), Fund Balance Analysis & Financial Stress Test and 3 more.
Superintendents
ACC Secondary Student Fee Guide, 2025 Revision of Prior Year Tax Rate Calculator (Single Rate), Calendar and Weather Make-up Calculator and 18 more.
Food service directors
Buy American Exceptions Tracker, CEP Monthly Reimbursement Estimator, Error-Prone Application Chart and Calculator and 6 more.
41 tools in 11 categories
Each tool follows a published workbook or rule, named under its title. Open a title to see what the tool does.
Finance & Formula 8
-
ACC Secondary Student Fee Guide
The DESE worksheet a community college serving as an Area Career Center uses to work out the cost per high school pupil and the fee it charges each sending district.
Follows: Missouri DESE Office of College & Career Readiness, Guide for Computing Fees for Secondary Students Enrolled in Community Colleges Designated as Area Career Centers (ACC)
-
Basic Formula Projection Tool (SB 727)
A district's state Basic Formula payment for 2023-24 through 2029-30 with the SB 727 WAM and WADA phase-in, hold harmless, Classroom Trust Fund, State Monies, Prop C and the Small Schools Grant.
Follows: Missouri DESE School Finance, Basic Formula Projection Tool (SB 727 changes)
-
Charter School Basic Formula Projection
A charter's WADA and WAM, the SB 727 phase-in to FWAM/FWADA, the resident district's Basic Formula, and the charter and district payment per FWADA with the sponsor fee.
Follows: Missouri DESE School Finance, Charter School Formula Projection Tool (SB 727 changes)
-
Estimated ADA and Membership Impact
Will estimating FY2027 ADA and average membership beat the best of the last two years' combined WAM/WADA? Pick the district, enter the counts, and get a YES or NO with the numbers to send School Finance.
Follows: Missouri DESE School Finance, Estimated ADA and Membership Calculation (Impact of Estimating for FY2027)
-
Fund 1 to Fund 4 Transfer Calculator
The most your district may move from the Incidental Fund to the Capital Projects Fund: the 7% x SAT x WADA transfer, the 5% / 2005-06 designated levy alternative, and the transportation transfer, checked against DESE's printed figures.
Follows: Missouri DESE School Finance, Fund Transfers (7%, 5% and Transportation Fund Transfer lists, 2026-2027 Preliminary and 2024-2025 Final)
-
Fund Balance Analysis & Financial Stress Test
The July-January cash-flow chart that sets the minimum June 30 General and Special Revenue balance, plus the 3% test and the financial-stress criteria for districts and charter schools.
Follows: Missouri DESE School Finance, Fund Balance Analysis and Financial Stressed, SY 2027
-
Summer School Estimated Revenue
Estimate what summer school will earn the district: summer ADA from enrollment and hours, the Basic Formula difference, and Proposition C revenue, added into one budget figure.
Follows: Missouri DESE School Finance, Summer School Estimated Revenue Calculation Tool (version 11-24-08)
-
Tuition Calculation by Grade Level Grouping
The basic tuition per ADA a receiving district charges for each building or grade span, from ASBR expenditures less specific-purpose revenue, with an ADA-share allocation helper.
Follows: Missouri DESE School Finance, Suggested Worksheet for Determination of Basic Tuition Charge (Tuition Calculation by Grade Level Grouping)
Budget & Accounting 1
-
Mileage and Expense Voucher
The employee expense voucher: in-district mileage between buildings from the district's distance table, and out-of-district travel with miles, meals and other costs, each totalled to an allowance with signature lines.
Follows: School District Of Washington, Missouri, Mileage and Expense Voucher (v041125)
Tax & Levy 7
-
2025 Revision of Prior Year Tax Rate Calculator (Single Rate)
Re-run last year's tax rate ceiling and rate to levy with corrected 2025 valuations or state-assessed revenue, so the revised ceiling can be carried into this year's calculator.
Follows: Missouri State Auditor, 2025 Revision of Prior Year Tax Rate Calculator, School Districts (Single Rate)
-
Bonding Capacity & Debt Service Levy
The 15% constitutional debt limit, remaining capacity after outstanding series, the debt service levy the coming year needs, and a what-if for a new issue with a payment schedule.
Follows: Mo. Const. art. VI §26(b), §26(f); RSMo 164.121, Debt limit and levy rules (Mo. Const. art. VI §26)
-
Estimate of Required Local Taxes
The one-page form you send each county clerk by September 1: each fund's levy in dollars and cents, the unadjusted levy before Prop C, and the property tax the county should raise.
Follows: Missouri DESE, Division of Administrative and Financial Services, Estimate of Required Local Taxes (MO 500-0059, Rev. 06/06)
-
Prop C Rollback Calculation
How much the district's tax rate must roll back per $100 of assessed valuation because of Prop C sales tax, after the collection fee and the railroad and utility share.
Follows: Missouri DESE School Finance, District Tax Reduction Worksheet (Prop C Rollback)
-
School District Tax Rate Calculator (Multi Rate)
Your St. Louis County district's tax rate ceiling and the rate to levy for 2026 on each subclass of property (residential, agricultural, commercial, personal property), with the Summary Page, Forms A, B and C and the DESE Screen 6 blended rates.
Follows: Missouri State Auditor, CY 2026 School District Tax Rate Calculator, Multi Rate (St. Louis County)
-
School District Tax Rate Calculator (Single Rate)
Your district's tax rate ceiling and the rate to levy for 2026 under Hancock and the 5% / CPI growth limit, with the voter-approved increase and debt service levy, as working copies of the Summary Page and Forms A, B and C to check before keying the figures into the State Auditor's online tax rate system.
Follows: Missouri State Auditor, CY 2026 School District Tax Rate Calculator (Single Rate)
-
State Assessed Railroad and Utility Calculation Program
Splits a county's state-assessed railroad and utility (SARRU) tax money among its school districts by School Purposes, Debt Service and Capital Projects, with the Calculation Results page for each district.
Follows: Missouri DESE School Finance, State Assessed Railroad and Utility Calculation Program (SARRU)
Calendar & Attendance 2
-
Calendar and Weather Make-up Calculator Free
Track AMI days, weather cancellations and make-up days against the 1,044-hour minimum, with the hours forgiven, the make-up still owed and the Core Data Screen 10 figures.
Follows: Missouri DESE School Finance, Calendar and Weather Make-up Calculator (2-7-2025), with the Short Version
-
Standard Day Length Calculator Free
Turns each building's bell times, lunch and uncountable passing time into the Standard Day Length in minutes and the hours figure keyed on Core Data Screen 10.
Follows: Missouri DESE School Finance, Standard Day Length Calculation Tool
Transportation 1
-
Transportation Aid Calculator
Projects the district's annual state pupil-transportation aid: ridership ADT, allowable costs, the cost-efficiency reduction, the 75% rate and the appropriation adjustment.
Follows: Missouri DESE, School Transportation, Calculation of State Transportation Aid - Simulation (TransCalcProgram)
Food & Nutrition 9
-
Buy American Exceptions Tracker
Log every non-domestic food bought under a Buy American exception, total the cost, and see the percentage of commercial food costs against the 10%, 8% and 5% caps.
Follows: USDA Food and Nutrition Service, Exceptions Tracking Standard Form (SP 23-2024, attachment a)
-
CEP Monthly Reimbursement Estimator
Turn the identified student percentage into the free and paid meal split, then estimate the monthly Federal lunch and breakfast reimbursement under the Community Eligibility Provision, with a comparison to what you collect today.
Follows: USDA FNS, posted by Missouri DESE, CEP Monthly Federal Reimbursement Estimator (FNS-CEPestimator.xlsx)
-
Error-Prone Application Chart and Calculator
Tells you whether a free or reduced-price meal application is error-prone for verification, with the full chart of income ranges by household size and pay frequency.
Follows: Missouri DESE Food & Nutrition Services, Error-Prone Application Chart and Calculator SY 2026-27
-
FSMC Indirect Cost Calculator
The indirect costs a district with a food service management company contract may charge to its nonprofit food service account: the modified direct cost base times the DESE-approved rate.
Follows: Missouri DESE Food and Nutrition Services, FSMC Indirect Cost Calculator (2025-26 SY)
-
Meals Per Labor Hour Worksheet
Turns a month of breakfast, lunch and nonprogram sales counts into daily meal equivalents and divides by each kitchen's labor hours, with the DESE staffing reference table.
Follows: Missouri DESE Food and Nutrition Services, Meals Per Labor Hour Analysis (LaborHoursSpreadsheet.xls)
-
Paid Lunch Equity (PLE) Tool, SY 2026-27 Free
The 2026-27 paid lunch price requirement for your weighted average price, the price raise or non-Federal revenue needed under the 10-cent cap, and the shortfall or credit to carry into next year.
Follows: USDA FNS, posted by Missouri DESE Food & Nutrition Services, Paid Lunch Equity (PLE) Tool SY 2026-27
-
Provision 2 Base Year Calculator
Each building's Free, Reduced and Paid breakfast percentages for every month of the Provision 2 base year, the figures later years' claims are built on.
Follows: Missouri DESE Food and Nutrition Services, Base Year Calculator for Schools Operating Provision 2 (BaseYearCalculator.xls)
-
Recipe Crediting Converter (M/MA, Grains, Vegetables)
Works out the meat/meat alternate, grain and vegetable credit in one portion of a standardized school recipe, with the whole grain-rich check and the SP 30-2012 grain item converter.
Follows: Missouri DESE Food and Nutrition Services, Standardized Recipe Contribution Converter (2016), with the SP 30-2012 grain converters
-
USDA Foods vs. Commercial Cost Comparison
Per-serving cost of each Direct Delivery (Brown Box) USDA Food and each Fee For Service product against the commercial equivalent, with annual savings by item and in total.
Follows: Missouri DESE Food and Nutrition Services, USDA Food Cost Comparison Tool (Feb 2025 file)
Special Education 4
-
ECSE Facility Lease Reimbursement Calculator
The most an ECSE facility lease can be reimbursed in a fiscal year: standard square footage per pupil and per FTE times DESE's cost per square foot for the county.
Follows: Missouri DESE Special Education Finance, ECSE Lease Reimbursement Calculator (rates July 1, 2020 through June 30, 2021)
-
ECSE FTE, Salary and Caseload Calculator
The three ECSE FER helper calculators: a staff member's ECSE FTE from caseload minutes, the ECSE share of salary, and the Met / Not Met caseload check.
Follows: Missouri DESE Special Education Finance, ECSE FER Formulas and Calculators
-
MOE Reduction and CEIS Worksheet
The most an LEA may cut local maintenance of effort after a Section 611 increase, the most it may reserve for CEIS, and the combined cap when it does both.
Follows: IDEA Data Center (Westat), MOE Reduction Eligibility Worksheet for LEAs/ESA (September 2016)
-
Proportionate Share Worksheet
This year's IDEA Part B 611 proportionate share for private and home schooled children, the carryover to release or reserve, and the monthly services log that charges salary, benefits and mileage to it.
Follows: Missouri DESE Special Education Finance, Proportionate Share Worksheet, Calculator and Services Log
Federal Programs 4
-
Class Size Reduction Worksheet (Title II.A)
The worksheet that shows local effort already meets the MSIP class sizes by grade before Title II.A pays a class size reduction teacher, with the ratios worked out for you.
Follows: Missouri DESE, Office of Quality Schools - Federal Programs, Class Size Reduction Worksheet 2026-2027 School Year
-
ESEA Maintenance of Effort Worksheet
Check whether the district spent at least 90% of the year before in state and local funds, in total or per pupil, from the ASBR expenditure and revenue lines.
Follows: Missouri DESE, ESEA Maintenance of Effort (MOE) Worksheet (MOE-Worksheet.xlsx)
-
Grant Tracking Tool
A ledger for one federal grant that shows what is left to budget, spend and request, flags over-budget entries, and tracks the three DESE deadlines.
Follows: Missouri DESE School Finance, Grant Tracking Tool (3-26-2026)
-
Personnel Activity Report (PAR)
The monthly day-by-day hours record for staff paid from federal funds, with program, leave and grand totals worked out and a signature page ready to print.
Follows: Missouri DESE, Personnel Activity Report (PAR) workbook
HR & Salary 3
-
Certificated Salary Compliance Estimate
Whether the district placed enough Basic Formula and Prop C money in the Teachers Fund and spent enough on certificated pay to meet Section 163.031.6, with the estimated penalty for each year.
Follows: Missouri DESE School Finance, Certificated Salary Compliance Worksheet (Section 163.031.6, RSMo)
-
Counselor Time-Task Analysis
A school counselor's five sample days logged in half-hour blocks across the five counseling-program components, with daily and weekly minutes, percent of time and a pie chart ready to print for the evaluation file.
Follows: Missouri DESE, MCSCP Time-Task Analysis (counselor evaluation materials)
-
Teacher Salary Schedule Builder
Build the board-approved teacher salary schedule (base times index, or typed dollars), cost it against your staff counts, run the Missouri minimum salary check and cost a raise or step movement.
Follows: Missouri district practice (no state template); RSMo 163.172, Teacher salary schedule (Columbia Public Schools 2025-2026, 187 days) and the minimum teacher salary statute
Data & Reporting 1
-
MO-CSCPE School Counseling Program Evaluation
Score the 66 elements of your school counseling program and get section totals, averages, the percentage of implementation, an implementation level and a list of possible action items.
Follows: Missouri DESE College and Career Readiness / School Counseling, Missouri K-12 Comprehensive School Counseling Program Evaluation (MO-CSCPE), Accessible March 2026
Early Childhood 1
-
Parent Education (PAT) Reimbursement Calculator
Total Parents as Teachers reimbursement for the year from the Final Invoice counts, with an optional start-of-year plan and a month-by-month tracker.
Follows: Missouri DESE, FY 2026 MO Parent Education Total Reimbursement Calculation Tool
Three tools are free
No account and no card. Try them before you decide on the rest.
Calendar and Weather Make-up Calculator
Track AMI days, weather cancellations and make-up days against the 1,044-hour minimum, with the hours forgiven, the make-up still owed and the Core Data Screen 10 figures.
Standard Day Length Calculator
Turns each building's bell times, lunch and uncountable passing time into the Standard Day Length in minutes and the hours figure keyed on Core Data Screen 10.
Paid Lunch Equity (PLE) Tool, SY 2026-27
The 2026-27 paid lunch price requirement for your weighted average price, the price raise or non-Federal revenue needed under the 10-cent cap, and the shortfall or credit to carry into next year.
What we store
We do not store student data. When you import a file into a tool, your browser reads it and nothing is uploaded, so no student-level file ever reaches our servers. What you type stays in your browser until you save it to a file on your computer.
We do store your users' names and email addresses, your district's name and your billing records. Your card number goes to Stripe and never touches our servers. Read the privacy policy.
$1,000 a year per district
Every user. Every tool.
- All the tools and the yearly updates.
- Unlimited users, invited by email.
- Pay by card, or by invoice: net 30, by ACH or check.
- 12 months from purchase, renewing until you cancel.
- Full refund within 30 days.
Check your figures before you file
Yellow Cells is not published or endorsed by the Missouri Department of Elementary and Secondary Education, the Missouri State Auditor, USDA or the State of Missouri. The tools follow published workbooks and rules. Check every figure against the official form before you file.