Get Full Government Meeting Transcripts, Videos, & Alerts Forever!
Get email alerts on the Budget Template topic
No spam. Unsubscribe anytime.
Presenter demonstrates Excel budget template and how it aggregates revenues
Summary
A presenter walked the committee through a proposed Excel template for the FY 2026–27 budget, explaining input cells, 'previous budget' columns, orange totals and percent deviation calculations, and how categories can be added or removed.
The meeting focused most of its discussion on a proposed Excel template intended to make the budget clearer and easier to present. The Presenter explained the sheet: "All that does is I got those items and numbers off of what Billy had and just put the numbers in. ... If you just put them in the boxes, then it just does the math for you." He described yellow input cells, a column labeled 'previous budget' and orange totals columns that show differences and percent deviations to highlight where recommended spending differs from prior-year totals.
Committee members asked for clarifications about which columns represented cash-on-hand versus budgeted revenue. The Presenter and Chair agreed to relabel the confusing column to make it clear it shows prior-year figures, and members suggested adding both a 'last year' column and a 'recommended' column to facilitate year-over-year comparison when the template is used in public presentations.
