Sanitary Sewer - Per Srv (payroll) (ES8120.1)

Bi-weekly payroll allocation for the share of village staff time charged to the sewer fund. Vendor is always 'Payroll Clearing Account'. The interesting question for oversight is whether the per-bi-week amount is consistent with the staffing allocation underlying the FY budget.

Transactions

FY 25-26 to date

Total $ billed

$56,173

vs annual budget $40,000 (140%)

Distinct vendors

top: Payroll Clearing Account

Burn-up + burn-rate vs FY budget

Cumulative $ billed (top) with a fitted regression extrapolated to projected exhaustion. Burn-rate (bottom) shows per-interval rates with area proportional to spend in each interval — a 90-day EWMA trend on top.

Cumulative $ billed (by invoice date)

Monthly-equivalent cost rate ($/mo)

2025-06 3 events · $4,419(1.3× budget)

Date	Vendor	Invoice	LLM classification	Memo	$ amount
Jun 1, 2025	—	PR Acrl MZ 5.31.25R	—	PR Accrual 60% of PP 5.31.25	$1,121
Jun 9, 2025	Payroll Clearing Account	Payroll End 6/5/25	—	Payroll End 6/5/25	$1,868
Jun 23, 2025	Payroll Clearing Account	Payroll End 6/19/25	—	Payroll End 6/19/25	$1,431

2025-07 3 events · $6,030(1.8× budget)

Date	Vendor	Invoice	LLM classification	Memo	$ amount
Jul 7, 2025	Payroll Clearing Account	Pay Ended 7/3/25	—	Pay Ended 7/3/25	$2,314
Jul 21, 2025	Payroll Clearing Account	Pay Ended 7/1725	—	Pay Ended 7/17/25	$1,980
Jul 31, 2025	Payroll Clearing Account	Pay Ended 7/31/25	—	Pay Ended 7/31/25	$1,736

2025-08 1 event · $4,162(1.2× budget)

Date	Vendor	Invoice	LLM classification	Memo	$ amount
Aug 14, 2025	Payroll Clearing Account	Pay ended 8/14/25	—	Pay ended 8/14/25	$4,162

2025-09 2 events · $3,996(1.2× budget)

Date	Vendor	Invoice	LLM classification	Memo	$ amount
Sep 15, 2025	Payroll Clearing Account	Payroll Ended 9/11/25	—	Payroll Ended 9/11/25	$1,294
Sep 29, 2025	Payroll Clearing Account	Payroll ended 9/25/25	—	Payroll ended 9/25/25	$2,702

2025-10 2 events · $6,479(1.9× budget)

Date	Vendor	Invoice	LLM classification	Memo	$ amount
Oct 10, 2025	Payroll Clearing Account	10/9/25 Pay	—	Original 10.9.25 Payroll - later corrected	$2,450
Oct 23, 2025	Payroll Clearing Account	Pay Ended 10/23/25	—	Pay Ended 10/23/25	$4,029

2025-11 2 events · $4,470(1.3× budget)

Date	Vendor	Invoice	LLM classification	Memo	$ amount
Nov 10, 2025	Payroll Clearing Account	Payroll ended 11/6/25	—	Payroll ended 11/6/25	$2,200
Nov 24, 2025	Payroll Clearing Account	Pay ended 11/20/25	—	Payroll ended 11/20/25	$2,270

2025-12 2 events · $6,073(1.8× budget)

Date	Vendor	Invoice	LLM classification	Memo	$ amount
Dec 8, 2025	Payroll Clearing Account	Payroll ended 12/4/25	—	Payroll ended 12/4/25	$1,739
Dec 22, 2025	Payroll Clearing Account	Pay Ended 12/18/25	—	Payroll Ended 12/18/25	$4,335

2026-01 2 events · $5,457(1.6× budget)

Date	Vendor	Invoice	LLM classification	Memo	$ amount
Jan 5, 2026	Payroll Clearing Account	Payroll Ended 1/1/26	—	Payroll Ended 1/1/26	$2,992
Jan 20, 2026	Payroll Clearing Account	Pay ended 1/15/26	—	Pay ended 1/15/26	$2,465

2026-02 2 events · $5,135(1.5× budget)

Date	Vendor	Invoice	LLM classification	Memo	$ amount
Feb 2, 2026	Payroll Clearing Account	Payroll ended 1/29/26	—	Payroll ended 1/29/26	$2,569
Feb 17, 2026	Payroll Clearing Account	Payroll Ended 2.12.26	—	Payroll Ended 2.12.26	$2,566

2026-03 3 events · $5,059(1.5× budget)

Date	Vendor	Invoice	LLM classification	Memo	$ amount
Mar 2, 2026	Payroll Clearing Account	Pay ended 2/26/26	—	Pay ended 2/26/26	$1,032
Mar 17, 2026	Payroll Clearing Account	Payroll ended 3/12/26	—	Payroll ended 3/12/26	$1,964
Mar 30, 2026	Payroll Clearing Account	Pay ended 3/26/25	—	Pay ended 3/26/25	$2,063

2026-04 2 events · $3,714(1.1× budget)

Date	Vendor	Invoice	LLM classification	Memo	$ amount
Apr 13, 2026	Payroll Clearing Account	Pay Ended 4/09/26	—	Pay Ended 4/09/26	$1,935
Apr 27, 2026	Payroll Clearing Account	Pay Ended 4/23/26	—	Pay Ended 4/23/26	$1,778

2026-05 2 events · $1,179

Date	Vendor	Invoice	LLM classification	Memo	$ amount
May 11, 2026	Payroll Clearing Account	Pay Ended 5/7/26	—	Pay Ended 5/7/26	$845
May 26, 2026	Payroll Clearing Account	Pay Ended 5/21/26	—	Pay Ended 5/21/26	$334

Vendors by spend

Vendor	Bills	$ total	First → Last
Payroll Clearing Account	25	$55,052	2025-06-09 → 2026-05-26
unknown	1	$1,121	2025-06-01 → 2025-06-01