Workplace Invoice
The Workplace Invoice is an Excel export from an Organization’s edit page that shows what the workplace-as-an-entity owes the federation. It is scoped to institutional commitments only — payroll deductions the workplace is on the hook to remit on behalf of its employees, plus any direct corporate-level pledge the workplace made.
Individual employee pledges paid by other methods (credit card, check, cash, external, or genuinely-billable BillMe) are out of scope for this invoice — those are billed to the individual employee through BillMe statements, not against the workplace.
Generating the Invoice
- Open an Organization edit page for the workplace.
- On the right-hand-side tasks panel, click Generate Workplace Invoice.
- The Excel workbook downloads automatically.
What’s in the Output
The workbook has five columns and a row per (campaign year, category) tuple:
| Column | Description |
|---|---|
| Campaign Year | The campaign year, or blank for the grand-total footer |
| Category | One of “Employee pledges (payroll)”, “Corporate-level pledge”, “Subtotal <year>”, or “GRAND TOTAL” |
| Pledged | Total pledged for that category in that year |
| Paid to Date | Total paid for that category, up to the current date |
| Outstanding | Pledged − Paid to Date |
Categories
Two in-scope categories per year are reported (zero-amount categories are suppressed):
- Employee pledges (payroll) — Aggregated employee
PLEDGEtotals for the workplace where the payment method isPayrollPaymentMethodOR a legacyBillMePaymentMethodwhose name contains “payroll”. Paid-to-date pairs against the workplace’s aggregate remittance checks (contact IS NULL+ payroll method). - Corporate-level pledge — Non-payroll
PLEDGErecords withcontact = nullandorganization = workplace. This is the workplace itself making a direct corporate gift, distinct from its employees’ payroll pledges. Paid-to-date pairs againstcontact IS NULLnon-payroll PAYMENT records.
Subtotals and Totals
- A Subtotal <year> row is written after each year’s category rows, but only if at least one in-scope category for that year had non-zero activity. Years with only out-of-scope activity (e.g., a year where only individual employees paid by CC) are suppressed entirely.
- The final GRAND TOTAL row sums across all years.
Reconciling with Payouts
The “Outstanding” column reconciles with what the payout engine sees as Received: both use the same aggregated-payroll predicate (PayrollPaymentMethod OR legacy BillMe-with-“payroll”-in-name) for partitioning, so a workplace’s invoice and the payout calculations stay in lockstep.
If a payroll-aggregate cycle came in short by $1,500 (attrition, opt-outs, paycheck timing), the workplace invoice shows $1,500 outstanding for the payroll line until the workplace catches up or finance closes the books on that campaign year.
Permissions
The link is rendered only for users with the Organization:X permission. The export uses the standard MyExcelExporter download wiring (<p:fileDownload value="#{myExcelExporter.file}" /> paired with ajax="false" on the action link).