The Lunenburg Budget Project·The money →
Lunenburg Budget Project · Data architecture

Town Money Flow

The whole town — every dollar in, every dollar out

FY2026. The same model built for the schools, applied to all of Lunenburg: who sets each dollar coming in, who decides how it goes out, and what is sitting still.

Every dollar into the town
$56,858,248
General fund, enterprise funds and special revenue funds. Mixed bases — see below.
Every dollar out
$55,043,604
The omnibus budget, the enterprise funds and the special revenue funds.
Sitting in accounts, unspent
$1,592,572
Held across the special revenue funds at 31 March. Not income, not spending: money that arrived and stopped.
The general fund’s share of it all
92%
The one system Town Meeting debates — and the only one where a dollar’s origin cannot be followed.
MONEY IN — every source POOLS MONEY OUT — every department and fund GENERAL FUND 0100$52,187,832 Every source on the left flows in here and loses its identity. No record ties a source to a department, so no line crosses this box — the diagonal edge does not exist. Orange lines out are the school; the rest is everything else the town does. Property tax levy$35,111,996 State aid$11,153,368 Local receipts$3,335,624 One-time money$2,209,993 Transfers in$376,851 Sewer Enterprise Fund$1,454,671 Solid Waste/Recycling En$1,000,000 Sewer Betterments$436,667 Peg Access Enterprise Fu$225,927 2200 School Lunch Revolvi$572,231 2640 Special Ed Circuit B$325,970 1312 Extended Day Revolvi$192,943 1301 Chapter 658 Revolvin$160,164 1305 After School Activit$111,376 1308 School Choice Revolv$83,116 2672 Fy26 Family & Commun$48,558 1311 School Gift Fund$22,486 1306 School Facilities Us$18,670 2681 Comp School Health S$10,775 1302 Adult Education Revo$4,000 1300 Lost Books/Tech Rev $2,860 300 School Department$26,247,474 914 Insurance — school retiree health$1,521,536 914 Insurance — town$2,191,984 210 Police Departmen — school resource stipend$6,800 210 Police Department — town$2,399,372 820 Wrrs Assessment — MIXED$2,392,572 220 Fire Department$1,717,588 710 Principal Serial Loans$1,506,369 310 Monty Tech Assessment$1,334,521 993 Transfer To Capital Proj$1,052,500 751 Interest Serial Loans$1,039,840 825 State Assessments$1,028,529 193 Facilities & Grounds$711,606 421 Highway Administration$644,443 411 Highway Construction & M$634,850 610 Lunenburg Public Library$632,037 155 Information Technology D$491,311 433 Recycling Program$470,000 170 Land Use$440,157 423 Snow Removal$355,571 135 Town Accountant$323,244 228 Radio Watch$310,764 126 Town Manager$305,325 141 Assessor'S Administratio$297,308 541 Council On Aging$261,182 945 Liability Insurance$239,189 996 Transfer To Trust Funds$232,500 192 Public Buildings$221,357 133 Salary Reserve$210,000 132 Reserve Fund$185,000 122 Select Board$180,280 429 Vehicle Maintenance$179,750 912 Workers Compensation$145,000 161 Town Clerk'S Administrat$143,602 650 Parks & Recreation$134,434 146 Tax Collector'S Administ$130,718 491 Cemetery Department$125,339 145 Treasurer'S Administrati$118,966 199 Central Purchasing$91,500 543 Veteran'S Services$90,699 512 General Health Expense$56,631 521 Nashoba Health$47,815 292 Animal Control$46,125 301 School Non-Recurring Exp$40,000 294 Tree Removal$38,500 158 Tax Title Redemp/Foreclo$30,500 425 Traffic Signs & Devices$28,500 522 Nashoba Nursing$21,915 163 Registration & Census$20,950 213 Police Lock Up$20,600 223 Fire Hydrant Expense$17,000 162 Elections$11,100 227 Mtc Of Town Radios$10,000 913 Unemployment Compensatio$10,000 195 Town Reports$7,000 291 Emergency Management$7,000 693 Band Concerts$6,000 244 Inspector Of Wghts & Mea$4,600 841 Montachusett Planning Co$4,478 214 Injury Leave$4,000 524 Police/Fire Medical$4,000 525 Physicals$3,500 131 Finance Committee$1,800 754 Loan Administrative Fees$1,230 691 Historical Commission$1,000 178 Architectural Preservati$500 136 Annual Audit$0 175 Planning Board$0 241 Building Inspection$0 Sewer Enterprise Fund — spent$1,706,419 Sewer Betterments — spent$184,920 Peg Access Enterprise Fu — spent$225,928 2200 School Lunch Revolvi — spent$739,586 2640 Special Ed Circuit B — spent$4,005 1312 Extended Day Revolvi — spent$233,350 2813 Fy25 #240 — spent$229,398 2814 Fy26 #240 — spent$179,637 1301 Chapter 658 Revolvin — spent$100,467 1305 After School Activit — spent$95,196 1308 School Choice Revolv — spent$30,558 2778 Fy25 117 Soa Evidenc — spent$68,647 2672 Fy26 Family & Commun — spent$13,372 1311 School Gift Fund — spent$2,911 1306 School Facilities Us — spent$12,354 2681 Comp School Health S — spent$5,120 2832 Fy25 #274 020520250 — spent$5,427 1302 Adult Education Revo — spent$2,880 2690 Fy26 #309 Title Iv P — spent$3,240 2728 Fy24 Title 11 Part A — spent$3,217 1300 Lost Books/Tech Rev — spent$661 2622 Fy25 Family & Commun — spent$2,477 2800 Fy25 140 080524093 — spent$2,208 2758 Fy23 240 — spent$1,666 MONEY IN WE CANNOT SEE SPENDING WE CANNOT SPLIT Bus feescharged by published policy · no destination found in any ledger Trust fund incomescholarships, cemetery, stabilisation · extract is check-failed Student activity accountsheld by the school under its own authority · not in the town’s books at all Grants received in earlier yearsspent now, booked then · nine funds, no FY26 revenue School share of the pensioninside WRRS · town and school staff together, no published split Debt service by projecttwo accounts for ALL town borrowing · school buildings cannot be separated What the capital transfers boughttwo transfer lines · no project detail What any special revenue fund boughtno expense report exists for these funds · purpose is presumed, never observed
school money — every box and line in orangemixed — town and school together, no published splittracedbypasses the general fund entirely — rate-funded and ring-fencedthe fund spent it; purpose not observed

Nothing on this page is aggregated

Every one of the 67 departments and every one of the 21 active funds has its own box. That is why the diagram is tall — it is the honest shape of a town with that many of each, and a shorter picture would be a shorter picture of something else.

School money is orange, everywhere. That is the point of the town view: once anything is combined you can no longer see what goes to the school and what does not. Scroll the right column and the schools are visible as a colour rather than as a number you have to trust.

Every special revenue fund the town has is a school fund, so the entire lower half of both columns is orange. The general fund half is where the town’s other 64 departments live.

Can this page say “here is every way money comes in, itemised”?

Not quite, and the difference matters. It is classified, not itemised. Each box on the left is a group: the five general-fund classes stand for 79 revenue accounts that carry money, and 113 more that carry none. On the right, ten departments are named and 57 are collapsed into one box. Inside each department are the 635 accounts the ledger actually holds.

So the honest claim is: every dollar the town’s ledger records is on this page somewhere, at the grain a page can hold. What it is not is a list you could audit a cheque against.

And eight things are not on it at all, because the town’s records cannot answer them. They are drawn at the foot of each column, at the same size as everything else, so the picture does not read as complete when it is not. Four are money coming in that cannot be seen; four are spending that cannot be split. Every one of them is a real quantity — none is a rounding difference or a missing file.

The largest single unknown is the school share of the pension. The largest lumped one is debt service: two accounts for all town borrowing, with school buildings inside and no way to separate them.

Every dollar of special revenue in this town is school money

The single box marked “Special revenue funds — $1,553,151” on the left is not a town-wide category with a school share inside it. It is entirely school money. Twelve funds carry revenue in FY2026 — school lunch, the special education circuit breaker, extended day, Chapter 658 athletics, after school, school choice, family and community engagement, the school gift fund, facilities use, comprehensive school health, adult education, and lost books — and no other town department runs one at all.

Which is why the school page itemises these and this page does not: same money, finer grain, and the school page is where the grain belongs. The one thing this page does not carry that the school page does is the grant funds’ spending — nine funds that spent money in FY2026 while booking no revenue, so a revenue-side box cannot show them. They appear here only in the gaps.

What is inside the special revenue box, itemised

The diagram carries these as one box on each side because there are 21 of them and a box each would swamp the picture. Nothing is excluded from the totals — every fund below is inside the $1,736,376, and each of these is school money.

fundinspentheld 31 Mar
2200School Lunch Revolving$572,231$739,586$287,771
1312Extended Day Revolving Fund$192,943$233,350$54,161
2813Fy25 #240$0$229,398$-88,503
2814Fy26 #240$0$179,637$-179,637
1301Chapter 658 Revolving Fund$160,164$100,467$169,945
1305After School Activities Fund$111,376$95,196$148,578
2778Fy25 117 Soa Evidence Base$0$68,647$-91,220
1308School Choice Revolving$83,116$30,558$299,461
2672Fy26 Family & Community 237$48,558$13,372$35,186
1306School Facilities Use Revolv$18,670$12,354$71,559
2832Fy25 #274 0205202509302025$0$5,427$0
2681Comp School Health Serv Grant$10,775$5,120$5,655
2640Special Ed Circuit Breaker$325,970$4,005$615,301
2690Fy26 #309 Title Iv Part A$0$3,240$-3,240
2728Fy24 Title 11 Part A #140$0$3,217$5,108
1311School Gift Fund$22,486$2,911$109,398
1302Adult Education Revolving Fund$4,000$2,880$12,744
2622Fy25 Family & Community$0$2,477$70,800
2800Fy25 140 080524093026$0$2,208$0
2758Fy23 240$0$1,666$-8,167
1300Lost Books/Tech Rev Fund$2,860$661$16,665
total$1,553,151$1,736,376$1,592,572

School choice, for example, took in $83,116, spent $30,558 and holds $299,461 — all three inside the single box on the diagram.

The town runs four money systems that do not mix

This is the thing the school view cannot show, because the schools live in only two of them.

systeminoutcan a dollar be followed?
General fund67 departments, one pot$52,187,832$51,189,961No. Every source lands in fund 0100 and loses its identity. This is 92% of the money and the only system with this problem
Enterprise fundssewer, water, PEG, solid waste$3,117,265$2,117,267Yes. Rate-funded and self-contained: the people who pay are the people served, and the accounts are separate end to end
Special revenue funds61 of them, and every one that carries money is a school fund$1,553,151$1,736,376Half. The source is known exactly, the use is not observed at all — no expense report exists for them
Trust fundsscholarships, cemetery, stabilisationNot held. The annual-report extract is check failed on ordinal columns and cannot be aggregated

The asymmetry is the finding. The system nobody argues about — the enterprise funds — is fully traceable, because it is rate-funded and ring-fenced. The system every Town Meeting argues about is the one where no dollar can be followed from where it came from to what it bought. That is not an accident of record-keeping; it is what a general fund IS.

Money in

Who sets each dollar. The general fund, by class.
Property tax levySet by the town, inside the Proposition 2½ cap
$35,111,996
State aidSet by the Legislature. No local say at all
$11,153,368
Local receiptsFees, permits, excise, fines. A residual
$3,335,624
One-time moneyFree cash and proceeds. Spendable once
$2,209,993
Transfers inFrom the town’s own other funds. Not new money
$376,851

Outside the general fund

Sewer Enterprise Fundfund 6000
$1,454,671
Solid Waste/Recycling Enterprifund 7900
$1,000,000
Sewer Bettermentsfund 5000
$436,667
Peg Access Enterprise Fundfund 6200
$225,927
Special revenue funds61 funds · holding $1,592,572 at 31 March
$1,553,151

Money out

Where it actually lands. The omnibus budget, by department.
School Departmentdept 300 · 51.3% of the omnibus
$26,247,474
Insurancedept 914 · 7.3% of the omnibus
$3,713,520
Police Departmentdept 210 · 4.7% of the omnibus
$2,406,172
Wrrs Assessmentdept 820 · 4.7% of the omnibus
$2,392,572
Fire Departmentdept 220 · 3.4% of the omnibus
$1,717,588
Principal Serial Loansdept 710 · 2.9% of the omnibus
$1,506,369
Monty Tech Assessmentdept 310 · 2.6% of the omnibus
$1,334,521
Transfer To Capital Project Fddept 993 · 2.1% of the omnibus
$1,052,500
Interest Serial Loansdept 751 · 2.0% of the omnibus
$1,039,840
State Assessmentsdept 825 · 2.0% of the omnibus
$1,028,529
Facilities & Groundsdept 193 · 1.4% of the omnibus
$711,606
Highway Administrationdept 421 · 1.3% of the omnibus
$644,443
The other 55 departmentsevery one under $634,850
$7,394,827

Outside the general fund

Sewer Enterprise Fundfund 6000
$1,706,419
Sewer Bettermentsfund 5000
$184,920
Peg Access Enterprise Fundfund 6200
$225,928
Special revenue fundsspent $1,736,376 against $1,553,151 received
$1,736,376

The two columns do not balance, and should not. Money in is $56,858,248 and money out is $55,043,604. A fund is a tank, not a pipe: the special revenue funds alone spent $183,225 more than they took in, drawing down balances built in earlier years. And the bases are mixed — the general fund and enterprise figures are budgets as voted, the special revenue funds are nine months of actual, because the town publishes no twelve-month fund report.

What the town view shows that the school view cannot

The schools, in the same model

Reproduced from school-money-flow.html unchanged, so the two can be read against each other. The school system is one of the four above and lives in two of them: the general fund appropriation, and the special revenue funds it runs itself.

Open the school diagram →

Where this page comes from

Every document behind the figures above. This list is recorded while the page is built — SQLite reports each table the render actually reads, and the documents come off doc_id on the rows themselves, so it cannot drift away from what the page does. All 16 were traced that way.

documentfeedshow we knowsha256
data/money-assumptions.csvread directly by the scripttraced620c2b74ce21d327…
data/money-classification.csvread directly by the scripttraced2ece30bf2f0347a9…
data/money-edges.csvread directly by the scripttraced0b05cefe4369e8d6…
data/money-gaps.csvread directly by the scripttraced730e24a9b811a365…
town-ledgers/expenses/glytdbud-expense-fy2026-p09-ef-peg-access.txtaccount, fund, ledger_snapshottraced6e2ada913f7457f2…
town-ledgers/expenses/glytdbud-expense-fy2026-p09-ef-sewer.txtaccount, fund, ledger_snapshottracedf67d785fd5ba15dc…
town-ledgers/expenses/glytdbud-expense-fy2026-p09-ef-solid-waste.txtaccount, fund, ledger_snapshottracedbe236a99caa7e8cb…
town-ledgers/expenses/glytdbud-expense-fy2026-p09-ef-water.txtaccount, fund, ledger_snapshottraced58fa38d6d654d647…
town-ledgers/expenses/glytdbud-expense-fy2026-p09-gf-all.txtaccount, fund, ledger_snapshottraced449853bc842b2494…
town-ledgers/expenses/glytdbud-expense-fy2026-p12-gf-all.xlsxaccount, fund, ledger_snapshottraced215dd64f597f1f2d…
town-ledgers/fund-balances/special-revenue-fy2026-p09.xlsxfund_activitytraced4b9777d83c747c1c…
town-ledgers/revenue/glytdbud-revenue-fy2026-p09-ef-peg-access.txtaccount, fund, ledger_snapshottraced668868e19fc24fa6…
town-ledgers/revenue/glytdbud-revenue-fy2026-p09-ef-sewer.txtaccount, fund, ledger_snapshottracedccaa743215e8fea4…
town-ledgers/revenue/glytdbud-revenue-fy2026-p09-ef-solid-waste.txtaccount, fund, ledger_snapshottraced78a0f82a9b06f54a…
town-ledgers/revenue/glytdbud-revenue-fy2026-p09-ef-water.txtaccount, fund, ledger_snapshottracedf4647f445bf824ec…
town-ledgers/revenue/glytdbud-revenue-fy2026-p09-gf-all.txtaccount, fund, ledger_snapshottraced7e0f22acb4934c57…

Addresses resolve on the published site; the archive is also mirrored on GitHub. A sha256 is here because a file can be replaced at the same URL — see rule 12.

Generated by scripts/build_town_flow.py from sources/data/lunenburg.db. Every figure is computed; --check fails if this file stops reproducing.