Excel workbook previewMunicipal Budget Template (Fund Accounting)
3 free downloads per account. Just your email and a 6-digit code.
About this template
A municipal budget is the financial plan a town, city or village adopts each year, fund by fund, before it may spend. Councils, auditors and rating analysts look for three things: every fund balances, the General Fund keeps a reserve, and recurring costs are paid from recurring revenues. This workbook gives a finance director a structured place to build the proposed budget and show those three answers on one page.
The workbook follows the fund structure most local governments use: a General Fund, special revenue, debt service and capital projects funds, and an enterprise fund for water and sewer. Revenues and appropriations roll up by formula into a fund summary and a department matrix. The reserve test uses the two month minimum that GFOA recommends, as quoted in public county and city policies, and federal award notes rest on 2 CFR 200.
Who it is for
The finance director of a town or small city who must put the proposed budget in front of the council and needs every fund to balance and the reserve to show.
What is inside
- 8 sheets: How to use, Assumptions, Revenues, Expenditures, Transfers, Fund Summary, Department Summary, Budget Calendar
- Worked budget for an invented town: 12 revenue lines and 19 appropriation lines across 5 funds
- Property tax and personnel lines driven by formulas from the Assumptions sheet
- Fund Summary with beginning balance, revenues, transfers, expenditures, ending balance and months of spending
- General Fund structural balance check: recurring revenues against recurring spending and transfers
- Department by object class matrix for the General Fund, built with SUMIFS
- Budget calendar with 10 steps, days left and overdue highlighting
- Dropdowns, frozen headers, filters and print settings on every table
How to use it
Enter the assessed value, levy rate and personnel increase on the Assumptions sheet, then replace the sample revenue and expenditure lines with your own.
Files
- XLSXmunicipal-budget-template.xlsx25 KB
Opens in Microsoft Word or Excel, Google Docs or Sheets, and LibreOffice. Built on free, official texts that anyone can read: laws, regulations, standards and guidance published by public bodies. A template to adapt, not legal, tax or accounting advice.
Questions about this template
What is fund accounting in a municipal budget?
Fund accounting splits the budget into separate funds, each with its own revenues, spending and balance, because many revenues may only be used for a set purpose. A motor fuel tax distribution, for example, usually goes to a street fund, and water charges go to the water and sewer fund. This workbook budgets each fund on its own and shows transfers between funds separately.
How much fund balance should a town keep?
GFOA recommends, at a minimum, unrestricted General Fund balance of no less than two months of regular operating revenues or expenditures, as quoted in public policies such as Hillsborough County's. Many governments set a higher target for their own risks. The Assumptions sheet holds the target in months, and the Fund Summary tests the General Fund against it.
What is a structurally balanced budget?
A budget is structurally balanced when recurring revenues pay for recurring expenditures, so one-time money such as a grant or a reserve draw is not used for ongoing costs. The Fund Summary sheet compares recurring General Fund revenues with recurring expenditures and recurring transfers out and labels the result as balanced or as a structural gap.




