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.
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)
LLM 3/3 verifiedThree payroll invoices posted in June 2025 [tc_fa00ba94db] totaling $4,419.23. Two are standard bi-weekly postings with explicit memo dates (6/5/25 and 6/19/25); one is a 60% accrual of a prior-month payroll period (5/31/25). The 4-row window through 2025-07-14 [tc_c3d0c0da85] adds a July-dated posting ($2,314.22) for pay ended 7/3/25, bringing the extended window to $6,733.45. No sewer-specific operational events are flagged in the mayor's June report [tc_cb36f8a797].
- ⚑ Accrual entry (PR Acrl MZ 5.31.25R) represents 60% of a prior-month payroll period; attribution to May 2025 is appropriate.
- ⚑ Two standard bi-weekly postings (6/5/25 and 6/19/25) fall within typical range (~$1,500–$3,000).
- ⚑ Mayor's report mentions sewer projects but provides no detail on staffing or operational changes in June.
| Date | Vendor | Invoice | LLM classification | Memo | $ amount |
|---|---|---|---|---|---|
| Jun 1, 2025 | — | PR Acrl MZ 5.31.25R | adjustment ●→ 2025-05Memo explicitly states 'PR Accrual 60% of PP 5.31.25' [tc_fa00ba94db], indicating this is an accrual/true-up for a payroll period ending 5/31/25. Although posted on 2025-06-01, the event belongs to May 2025. evidence: tc_fa00ba94db | PR Accrual 60% of PP 5.31.25 | $1,121 |
| Jun 9, 2025 | Payroll Clearing Account | Payroll End 6/5/25 | routine ●Standard bi-weekly payroll posting with explicit memo date 2025-06-05 [tc_fa00ba94db]. Amount $1,867.66 falls within typical bi-weekly range (~$1,500–$3,000). Invoice dated 2025-06-09 is 4 days after the payroll period end, consistent with normal billing lag. evidence: tc_fa00ba94db | Payroll End 6/5/25 | $1,868 |
| Jun 23, 2025 | Payroll Clearing Account | Payroll End 6/19/25 | routine ●Standard bi-weekly payroll posting with explicit memo date 2025-06-19 [tc_fa00ba94db]. Amount $1,430.97 falls within typical bi-weekly range. Invoice dated 2025-06-23 is 4 days after the payroll period end, consistent with normal billing lag. evidence: tc_fa00ba94db | Payroll End 6/19/25 | $1,431 |
2025-07 3 events · $6,030(1.8× budget)
LLM 4/4 verifiedThree payroll postings in July 2025 [tc_b586797d54] totaling $6,029.97 within the month, plus one August posting of $4,161.97 within the 14-day billing window [tc_c1b8670a1b]. All three July postings are routine bi-weekly amounts with explicit memo dates. No mayor's report coverage for July [tc_36a20ffb75].
- ⚑ No mayor's report for July 2025 — no contextual signal on sewer operations or staffing changes.
- ⚑ August 14 posting ($4,161.97) is materially elevated and falls outside the month; likely represents end-of-month true-up or overtime.
| Date | Vendor | Invoice | LLM classification | Memo | $ amount |
|---|---|---|---|---|---|
| Jul 7, 2025 | Payroll Clearing Account | Pay Ended 7/3/25 | routine ●Memo explicitly states 'Pay Ended 7/3/25' [tc_b586797d54]. Amount $2,314.22 falls within typical bi-weekly range (~$1,500–$3,000). Invoice dated 2025-07-07, four days after pay-end date, consistent with standard 1-week billing lag. evidence: tc_b586797d54 | Pay Ended 7/3/25 | $2,314 |
| Jul 21, 2025 | Payroll Clearing Account | Pay Ended 7/1725 | routine ●Memo explicitly states 'Pay Ended 7/17/25' [tc_b586797d54]. Amount $1,979.85 is within typical bi-weekly range. Invoice dated 2025-07-21, four days after pay-end, consistent with standard lag. evidence: tc_b586797d54 | Pay Ended 7/17/25 | $1,980 |
| Jul 31, 2025 | Payroll Clearing Account | Pay Ended 7/31/25 | routine ●Memo explicitly states 'Pay Ended 7/31/25' [tc_b586797d54]. Amount $1,735.90 is within typical bi-weekly range. Invoice dated same day as pay-end, consistent with month-end processing. evidence: tc_b586797d54 | Pay Ended 7/31/25 | $1,736 |
2025-08 1 event · $4,162(1.2× budget)
LLM 1/1 verifiedOne payroll posting dated 2025-08-14 for $4,161.97 [tc_21b6a4d10b]. The amount is elevated relative to the typical bi-weekly range (~$1,500–$3,000), suggesting overtime or end-of-month true-up. Memo explicitly states 'Pay ended 8/14/25', providing high-confidence attribution to August 2025.
- ⚑ Elevated payroll posting ($4,161.97) suggests overtime or true-up activity in mid-August
- ⚑ DEC noncompliance report dated 2025-08-01 [tc_ea4b4cade1] may correlate with operational demands
- ⚑ Mayor's report for August [tc_831b75475c] focuses on sewer expansion projects and SKWC testing; no mention of emergency operations or staffing surge
| Date | Vendor | Invoice | LLM classification | Memo | $ amount |
|---|---|---|---|---|---|
| Aug 14, 2025 | Payroll Clearing Account | Pay ended 8/14/25 | elevated ●Memo explicitly states 'Pay ended 8/14/25' [tc_3794493013]. Amount $4,161.97 is materially larger than typical bi-weekly posting (~$1,500–$3,000), suggesting overtime, end-of-month true-up, or accrual adjustment. Falls outside July; included in 14-day window [tc_c1b8670a1b] but belongs to August. evidence: tc_3794493013, tc_c1b8670a1b | Pay ended 8/14/25 | $4,162 |
2025-09 2 events · $3,996(1.2× budget)
LLM 2/2 verifiedTwo payroll invoices dated in September 2025 [tc_e00c2decbf], totaling $3,995.93 within the month. A third invoice dated 2025-10-10 ($2,449.89) falls within the 14-day billing window [tc_1a345a0fe7] but belongs to October payroll. Both September invoices are routine bi-weekly postings with explicit memo dates.
- ⚑ Both September invoices have explicit memo dates matching invoice dates; high attribution confidence.
- ⚑ September total ($3,995.93) is within expected bi-weekly range; no elevated or adjustment signals.
- ⚑ Mayor's report for September [tc_ab8ac3c298] focuses on WWTP discharge violations and sewer expansion grants; no payroll-specific commentary.
| Date | Vendor | Invoice | LLM classification | Memo | $ amount |
|---|---|---|---|---|---|
| Sep 15, 2025 | Payroll Clearing Account | Payroll Ended 9/11/25 | routine ●Invoice dated 2025-09-15 with explicit memo 'Payroll Ended 9/11/25' [tc_e00c2decbf]. Amount $1,294.03 is within typical bi-weekly range (~$1,500–$3,000). Memo event date 2025-09-11 is stale=false, confirming the payroll period ended in September. Attributed to 2025-09. evidence: tc_e00c2decbf | Payroll Ended 9/11/25 | $1,294 |
| Sep 29, 2025 | Payroll Clearing Account | Payroll ended 9/25/25 | routine ●Invoice dated 2025-09-29 with explicit memo 'Payroll ended 9/25/25' [tc_e00c2decbf]. Amount $2,701.90 is within typical bi-weekly range. Memo event date 2025-09-25 is stale=false, confirming the payroll period ended in September. Attributed to 2025-09. evidence: tc_e00c2decbf | Payroll ended 9/25/25 | $2,702 |
2025-10 2 events · $6,479(1.9× budget)
LLM 2/2 verifiedTwo payroll invoices posted in October 2025 totaling $6,478.73 [tc_19d02235fb]. The first posting (10/10) is marked as 'later corrected' with no explicit event date; the second (10/23) has a clear memo date and elevated amount. No sewer-related mayor's report content for October [tc_7fb9723e71], and no DEC compliance events in the Sept–Oct window [tc_74514d8318].
- ⚑ First invoice marked 'later corrected' — suggests a prior-month correction or adjustment
- ⚑ Second invoice amount ($4,028.84) exceeds typical bi-weekly range (~$1,500–$3,000), indicating elevated payroll or true-up
- ⚑ Mayor's October report contains no sewer excerpts [tc_7fb9723e71], limiting contextual signal
| Date | Vendor | Invoice | LLM classification | Memo | $ amount |
|---|---|---|---|---|---|
| Oct 10, 2025 | Payroll Clearing Account | 10/9/25 Pay | adjustment ●→ 2025-09Memo explicitly states 'Original 10.9.25 Payroll - later corrected' [tc_19d02235fb], indicating this is a correction or restatement of a prior payroll event. The 'later corrected' language and lack of explicit event date suggest this posting belongs to the pay period ending ~10/9, which would typically be processed in late September or early October. Given the correction flag and invoice date in the first third of October, attribution to 2025-09 is more likely than current month. evidence: tc_19d02235fb | Original 10.9.25 Payroll - later corrected | $2,450 |
| Oct 23, 2025 | Payroll Clearing Account | Pay Ended 10/23/25 | elevated ●Memo contains explicit event date 'Pay Ended 10/23/25' [tc_19d02235fb], establishing high-confidence attribution to October 2025. Amount of $4,028.84 [tc_19d02235fb] materially exceeds the typical bi-weekly range (~$1,500–$3,000), indicating overtime, end-of-month true-up, or multi-week accrual. This is classified as elevated rather than routine. evidence: tc_19d02235fb | Pay Ended 10/23/25 | $4,029 |
2025-11 2 events · $4,470(1.3× budget)
LLM 2/2 verifiedTwo routine bi-weekly payroll postings in November 2025 totaling $4,469.86 [tc_176a3acd10]. Both invoices carry explicit memo dates (11/6/25 and 11/20/25) and fall within the typical bi-weekly payroll range (~$1,500–$3,000). No elevated or adjustment-type postings detected.
- ⚑ Mayor's report for November mentions septic-system replacement funding but contains no sewer-operations or staffing commentary [tc_6002bcb0ff].
- ⚑ DEC operating data shows normal November flow (mean 0.033 MGD) with minimal precipitation (0.04 in) [tc_9d3ea24d1a]; no operational anomalies signaling overtime or emergency staffing.
| Date | Vendor | Invoice | LLM classification | Memo | $ amount |
|---|---|---|---|---|---|
| Nov 10, 2025 | Payroll Clearing Account | Payroll ended 11/6/25 | routine ●Invoice dated 2025-11-10 with explicit memo date 2025-11-06 [tc_176a3acd10]. Amount $2,199.56 falls within typical bi-weekly range. Memo format 'Payroll ended MM/DD/YY' is standard. Attributed to November based on memo event date. evidence: tc_176a3acd10 | Payroll ended 11/6/25 | $2,200 |
| Nov 24, 2025 | Payroll Clearing Account | Pay ended 11/20/25 | routine ●Invoice dated 2025-11-24 with explicit memo date 2025-11-20 [tc_176a3acd10]. Amount $2,270.30 falls within typical bi-weekly range. Memo format 'Payroll ended MM/DD/YY' is standard. Attributed to November based on memo event date. evidence: tc_176a3acd10 | Payroll ended 11/20/25 | $2,270 |
2025-12 2 events · $6,073(1.8× budget)
LLM 2/2 verifiedTwo payroll invoices posted in December 2025 [tc_2ead1e0319]: a routine bi-weekly posting of $1,738.64 (12/8, memo 12/4/25) and an elevated posting of $4,334.80 (12/22, memo 12/18/25). The second posting is materially larger than typical bi-weekly amounts and likely includes year-end true-up or overtime. Mayor's report [tc_112430524f] contains no sewer-specific commentary for December.
- ⚑ Second posting ($4,334.80) is 2.5× typical bi-weekly amount; likely includes end-of-year accrual or overtime.
- ⚑ Mayor's report [tc_112430524f] has n=0 sewer excerpts for December—no operational context from budget holder.
- ⚑ DEC ops data [tc_5b48f93dda] shows normal winter flow (mean 0.028 mgd); no WAS data available for December.
| Date | Vendor | Invoice | LLM classification | Memo | $ amount |
|---|---|---|---|---|---|
| Dec 8, 2025 | Payroll Clearing Account | Payroll ended 12/4/25 | routine ●Memo explicitly states 'Payroll ended 12/4/25' [tc_2ead1e0319], placing the event in early December. Amount $1,738.64 [tc_2ead1e0319] falls within typical bi-weekly range (~$1,500–$3,000). Invoice dated 2025-12-08, 4 days after memo event date, consistent with standard 1–2 week billing lag. evidence: tc_2ead1e0319 | Payroll ended 12/4/25 | $1,739 |
| Dec 22, 2025 | Payroll Clearing Account | Pay Ended 12/18/25 | elevated ●Memo explicitly states 'Payroll Ended 12/18/25' [tc_2ead1e0319], placing the event in mid-December. Amount $4,334.80 [tc_2ead1e0319] is materially larger than typical bi-weekly posting (~$1,500–$3,000), suggesting end-of-year true-up, accrual catch-up, or overtime. Invoice dated 2025-12-22, 4 days after memo event date, consistent with standard lag. This is the second posting in the month and the elevated amount is characteristic of year-end payroll adjustments. evidence: tc_2ead1e0319 | Payroll Ended 12/18/25 | $4,335 |
2026-01 2 events · $5,457(1.6× budget)
LLM 3/3 verifiedThree payroll postings totaling $8,025.56 [tc_be70cdf2e3] across the month and 14-day billing window. Two invoices dated in January (2026-01-05 and 2026-01-20) with explicit memo dates; one dated 2026-02-02 with memo date 2026-01-29. All three fall within the routine bi-weekly range ($2,464–$2,992). Mayor's report contains no sewer-related commentary for January [tc_26f51c9e35].
- ⚑ No mayor's report sewer commentary for 2026-01 [tc_26f51c9e35]
- ⚑ Third payroll posting (2026-02-02 invoice) belongs to January per memo date [tc_be70cdf2e3]
- ⚑ All three postings within routine bi-weekly range; no elevated or adjustment signals
| Date | Vendor | Invoice | LLM classification | Memo | $ amount |
|---|---|---|---|---|---|
| Jan 5, 2026 | Payroll Clearing Account | Payroll Ended 1/1/26 | routine ●Invoice dated 2026-01-05 with explicit memo 'Payroll Ended 1/1/26' [tc_0502fab603]. Memo event date 2026-01-01 is unambiguous. Amount $2,992.18 [tc_0502fab603] falls within routine bi-weekly range ($1,500–$3,000). Standard payroll posting format. evidence: tc_0502fab603 | Payroll Ended 1/1/26 | $2,992 |
| Jan 20, 2026 | Payroll Clearing Account | Pay ended 1/15/26 | routine ●Invoice dated 2026-01-20 with explicit memo 'Pay ended 1/15/26' [tc_0502fab603]. Memo event date 2026-01-15 is unambiguous. Amount $2,464.58 [tc_0502fab603] falls within routine bi-weekly range. Standard payroll posting format. evidence: tc_0502fab603 | Pay ended 1/15/26 | $2,465 |
2026-02 2 events · $5,135(1.5× budget)
LLM 3/3 verifiedTwo payroll invoices dated in February 2026 [tc_4e97dd7301]: one for payroll ended 1/29/26 ($2,568.80) and one for payroll ended 2/12/26 ($2,566.47). Both are routine bi-weekly postings within the typical $1,500–$3,000 range. A third invoice dated 2026-03-02 for payroll ended 2/26/26 ($1,032.22) falls within the 14-day billing window and belongs to February's payroll cycle. Total for the month with billing lag: $6,167.49 [tc_90b90efe1a].
- ⚑ NYSDEC NOV issued 2026-02-26 [tc_8e7291afa7]; no sewer-operational disruption evident in mayor's report [tc_05e3e60a73]
- ⚑ Mayor's February report focuses on fiber-optic infrastructure and database development; no mention of staffing changes or operational incidents
| Date | Vendor | Invoice | LLM classification | Memo | $ amount |
|---|---|---|---|---|---|
| Feb 2, 2026 | Payroll Clearing Account | Payroll ended 1/29/26 | routine ●→ 2026-01Invoice dated 2026-02-02 (outside January) but memo 'Payroll ended 1/29/26' [tc_be70cdf2e3] explicitly states event date 2026-01-29, placing the payroll period in January. Amount $2,568.80 [tc_be70cdf2e3] falls within routine bi-weekly range. Standard payroll posting with typical 4-day billing lag. evidence: tc_be70cdf2e3 | Payroll ended 1/29/26 | $2,569 |
| Feb 17, 2026 | Payroll Clearing Account | Payroll Ended 2.12.26 | routine ●Memo states 'Payroll Ended 2.12.26' [tc_4e97dd7301], indicating payroll period ending 2/12/26. Invoice dated 2026-02-17 is 5 days after period end, consistent with standard billing lag. Amount $2,566.47 is routine bi-weekly. Memo date is ambiguous (could parse as 2/12 or 12/2), but context of February invoice and typical bi-weekly cycle supports February attribution. evidence: tc_4e97dd7301 | Payroll Ended 2.12.26 | $2,566 |
2026-03 2 events · $2,997
LLM 2/2 verifiedTwo routine bi-weekly payroll postings totaling $2,996.54 [tc_d855348bc4]. Both invoices carry explicit memo dates: the first (2026-03-02) covers the pay period ended 2026-02-26 and belongs to February; the second (2026-03-17) covers the pay period ended 2026-03-12 and belongs to March. No mayor's report or DEC operational data available for March [tc_a06588ab8d, tc_db68efa2bb].
- ⚑ No mayor's report for 2026-03 (n=0)
- ⚑ No DEC operational data available for 2026-03
- ⚑ First invoice is a carryover from prior month (pay period ended 2026-02-26)
| Date | Vendor | Invoice | LLM classification | Memo | $ amount |
|---|---|---|---|---|---|
| Mar 2, 2026 | Payroll Clearing Account | Pay ended 2/26/26 | routine ●→ 2026-02Memo explicitly states 'Pay ended 2/26/26' [tc_90b90efe1a], placing the payroll event in February. Invoice dated 2026-03-02 reflects standard 4-day billing lag. Amount $1,032.22 is lower than typical bi-weekly ($1,500–$3,000), suggesting a partial-period or holiday-adjusted posting, but remains routine in character. Falls within 14-day billing window for February reconciliation. evidence: tc_90b90efe1a | Pay ended 2/26/26 | $1,032 |
| Mar 17, 2026 | Payroll Clearing Account | Payroll ended 3/12/26 | routine ●Invoice dated 2026-03-17 with explicit memo date 2026-03-12 [tc_5fb2147bb0]. Amount $1,964.32 is within typical bi-weekly range (~$1,500–$3,000). Memo 'Payroll ended 3/12/26' clearly indicates the pay period ended in March, so this posting belongs to 2026-03. Standard 5-day billing lag. evidence: tc_5fb2147bb0 | Payroll ended 3/12/26 | $1,964 |
Vendors by spend
| Vendor | Bills | $ total | First → Last |
|---|---|---|---|
| Payroll Clearing Account | 20 | $48,097 | 2025-06-09 → 2026-03-17 |
| unknown | 1 | $1,121 | 2025-06-01 → 2025-06-01 |