Union Pay Rate CSV Upload
There's no self-service bulk rate upload — how union rates actually get set and where to look them up
Greenroom has no self-service upload for union pay rates. This page explains how union rates get set, and where to look them up.
How union rates actually get set
Union pay rates, minimums, dues, and fringe benefit rules are maintained by Greenroom from the source agreement or rate sheet, through configured rate data and the staff-only Union Studio editor. Production staff cannot upload or edit those rate values through the app. There's no "upload a CSV to update rates" workflow, and no "Cost Code Configuration" settings screen.
A rule can carry more than a single figure: a percentage of a basis, an exact fraction of one, or the greater of two formulas, each on the weekly salary, a weekly minimum or another agreement's minimum, which is how IATSE Pink's Holiday pay, the greater of 1/6 of the actual weekly salary or 1.5 × 1/6 of the minimum scale, is now held as data rather than as a note beside a zero. Where a rule is a comparison like that, the run's Add menu shows the arithmetic next to the figure — see Adding Employees. For a single-formula rule priced on the weekly minimum, if the Minimums table has no amount for the payee's job title, the note says the payee's own salary was used instead and shows the result. A greater-of rule needs both bases to be computable; it does not silently substitute a salary fallback for a missing minimum.
If a rate looks wrong, or a union contract has just changed and the new numbers aren't reflected yet, contact your Greenroom account contact rather than looking for an upload option — there isn't a version of this you can fix yourself.
Other spreadsheet imports exist, but they aren't this
Admins have two spreadsheet imports in Settings, both for the chart of accounts: Import CSV / XLSX on the Chart of accounts tab loads your GL codes, and Upload CoA (.csv / .xlsx) on the QuickBooks tab fills in account names for the QuickBooks mapping. See Payroll, Chart of Accounts & QuickBooks Settings. Neither has anything to do with union pay rates; don't confuse them with a rate upload if you spot one.
Where to actually look up rates
Three places show you real, current rate information:
| Where | What it shows |
|---|---|
| Union Studio (left nav) | The published minimums, fringes, and dues for each union contract your production declared in Company Setup, opening on the version in force today. Anyone on your team can read it; it is marked Read-only. Greenroom staff see every union, plus each union's Destinations tab showing where every fund's cheque is posted, and only they can publish new rule versions or change a destination. How versions are drafted, validated and published, and which version a given pay period uses, is on Union Studio Versions and Publishing. |
| Union Rate Reference | A plain-language account of where each rate comes from (the agreement, memo or rate sheet behind it) and the corrections made to them. |
| Union rates | Every union agreement Greenroom prices, with each rate set's minimums, premiums, contributions and dues, exported from Greenroom's live rate tables. |
None of these is an upload feature; all three are read-only for your team.
What you do control
An Admin uses Union Setup to choose the unions your production runs under and the contract for each. Once that's set, their rates apply automatically wherever a payee is assigned that union and agreement — you don't separately configure the rate values yourself. Those same contracts are what Union Studio shows you.
Source citations for new rule versions
When Greenroom publishes a new version of a union's rules, the person doing it has to name the source — the CBA, memorandum, or exhibit the rates come from, in the form "SDC/OBL MOA Art XI, executed 5/6/2025". It isn't optional and it isn't prefilled from the previous version: a rate change is a money change, and a new version can't be started without it.
That citation is recorded against every rate in that version, so if a number on a payee's pay ever looks wrong, there's a specific document behind it to check rather than an unattributed edit.
The citation is shown on the draft itself — a Source document line above the rules, reading either the citation or a No citation recorded warning when that version has no citation recorded. A typo in it can be corrected in place on the draft, without discarding the draft and re-entering its rates; once the version is published the citation is frozen with the rates, since the document backing a live rate must not change after the fact. Every rate edit on a draft, and the publish itself, records the citation as it stood at that moment in the audit trail.
When a suitable sample payee is available, Greenroom previews a draft's impact before publishing — current rules against the draft — as one table per engagement shape the edited rules price differently: a full eight-performance week, a part week, an hourly engagement, a daily engagement, and a day reporting no performances or hours, each stating how it was constructed. If no suitable sample payee exists, the publish screen explains that it is publishing without an impact preview. A shape that moves no money says so rather than being dropped, because "this edit changes nothing on an hourly engagement" is an answer and a missing table is not.
Common issues
I need to update a rate for a new contract period
This isn't self-service. Contact your Greenroom account contact with the new contract details — Greenroom updates the rate configuration on your behalf.
A rate on a payee's pay doesn't match what I expect
Check Union Studio in the nav, the Union rates pages and the Union Rate Reference page first to confirm what the current configured rate actually is (rates can change on an effective date you may not be tracking). If it still looks wrong after that, contact support rather than assuming you can correct it yourself.
Next steps
Return to Union Setup for how to select unions for your production, see Union Rate Reference for where each rate comes from, or Union Studio Versions and Publishing for how a new rate version gets from draft to live and what to do when a rate looks wrong.