LeaveSheet: WH-347 payroll and PTO accrual MCP server

leavesheet-mcp

MCP server (stdio) for two payroll calculations used by LeaveSheet / TableTemplates:

columns 2 and 5-9 for a crew week, fringe paid to each plan, column 6B reconciliation.

• U.S. DOL WH-347 certified payroll form, revised version (Rev. January 2025):

carryover cap, approved and pending requests, holidays and half days.

• PTO accrual: leave balance at a date, with hire date, annual cap, tenure tiers,

The calculations are a line-by-line JavaScript port of the open-source Go packages codeberg.org/tresor2k/tabletemplates-go/wh347, .../pto and the wh347 command (.../cmd/wh347). The test suite checks the output byte for byte against those Go engines on 28 golden cases. No network access, no data stored.

Install

Requires Node.js 22 or later.

{
  "mcpServers": {
    "leavesheet": { "command": "npx", "args": ["-y", "leavesheet-mcp"] }
  }
}

Tools

Inputs

wh347payrolllines and wh347fringereconcile take { "workers": [...] }, one entry per worker-week on one project. Field names follow the CSV columns of the wh347 command: worker, type (J, RA or empty), baserate, fringehealthwelfare, fringepension, fringevacation, fringetraining, sthours and othours (arrays of up to 7 daily values), cashinlieurate, grossallwork (column 7B; omit it to use 7A), fica, federaltax, statetax, otherdeductions. Omitted numbers are 0; negative numbers are rejected. csv_line in the output is the line the worker would have in the equivalent CSV (header = line 1).

ptoaccrual takes policy (period: monthly or annual, rate, annualcap, carryovermax, optional tier1years/tier1bonus, tier2years/tier2bonus), hiredate, asof, carryover, requests (start, end, starthalf, endhalf, status: pending, approved, denied or cancelled), holidays (dates) and usfederalholidaysyears (adds the 11 U.S. federal holidays, observed dates, of the listed years). Dates are YYYY-MM-DD.

Example

wh347payrolllines input:

{ "workers": [{ "worker": "John Mason", "type": "J", "base_rate": 30,
  "fringe_health_welfare": 4, "fringe_pension": 2,
  "st_hours": [8, 8, 8, 8, 8], "ot_hours": [4], "other_deductions": 310 }] }

Output:

Shortened. The full README is on GitHub.