Recruiter Temp Timesheet and Margin Spreadsheets: Use case and AI Confidentiality
Every week a recruiter’s payroll coordinator reconciles what the agency pays its temps against what it bills the hosts, in a spreadsheet. Staff upload the sheet to ChatGPT or Claude to check the arithmetic, explain a variance or draft a note to a host. The sheet puts eight named workers beside their pay, the 12 per cent superannuation, the host’s charge rate and the agency’s margin, with a notes column for union activity, an injury claim, a visa limit and new bank details. This page marks what the sheet exposes under the Privacy Act and the Fair Work Act, and shows how it is worked on Ermos inside the agency.
The temp timesheet and margin spreadsheet
Built each week from the host timesheets and the payroll run, reconciled before invoices go out and before super is paid. The notes column is the coordinator’s working memory, which is why it ends up in the sheet that gets pasted.
| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Worker | Host | Hours | Pay/hr | Charge/hr | Gross pay | Super 12% | Billed | Margin | Note |
| 2 | Vijay Uppal1 | Northgate Freight2 | 38 | $34.503 | $47.005 | $1,311.003 | $157.324 | $1,786.005 | $317.685 | Union delegate at the host. Host wants him moved.6 |
| 3 | Viktor Ulyanov1 | Northgate Freight2 | 40 | $36.003 | $49.505 | $1,440.003 | $172.804 | $1,980.005 | $367.205 | New bank details by email 2 Nov: BSB 000-000, account 0000 0000. Not yet confirmed by phone.9 |
| 4 | Vittoria Urbano1 | Ulverston Print2 | 35 | $32.003 | $44.005 | $1,120.003 | $134.404 | $1,540.005 | $285.605 | Workers compensation claim lodged 20 Oct. Back on light duties.7 |
| 5 | Ugo Varga1 | Ulverston Print2 | 38 | $31.503 | $43.005 | $1,197.003 | $143.644 | $1,634.005 | $293.365 | Says he can get $34 elsewhere. |
| 6 | Veronika Vickery1 | Northgate Freight2 | 24 | $38.003 | $52.005 | $912.003 | $109.444 | $1,248.005 | $226.565 | Short weeks while she cares for her mother.7 |
| 7 | Uzoma Vasquez1 | Ulverston Print2 | 40 | $33.003 | $45.505 | $1,320.003 | $158.404 | $1,820.005 | $341.605 | Offered a permanent role at the host in December. |
| 8 | Valmai Voight1 | Northgate Freight2 | 30 | $35.503 | $48.505 | $1,065.003 | $127.804 | $1,455.005 | $262.205 | Reliable. First choice for the December backfill. |
| 9 | Vanh Uthaiwan1 | Ulverston Print2 | 22 | $30.003 | $41.505 | $660.003 | $79.204 | $913.005 | $173.805 | Student visa. 21 hours last week, 22 this week.8 |
| 10 | Total | 267 | $9,025.003 | $1,083.004 | $12,376.005 | $2,268.005 |
An invented spreadsheet. The workers and the hosts are fictional; the bank details are placeholders. Hover or tap any highlighted item for the analysis; the full list is below.
Timesheet and margin reconciler
An Agent+ that builds the weekly margin spreadsheet from the host timesheets and the payroll run. It reconciles time worked, pay, super and billing for each temp, flags anything that does not match, and keeps the coordinator's notes on a separate tab so the shared sheet holds figures only.
What it does
- Reads the host timesheets and the payroll run
- Reconciles time worked, pay and billing for each temp
- Flags differences and moves notes to a separate tab
What stays with your people. A coordinator resolves each difference and the accounts team runs invoicing. The agent reconciles and flags; people handle payroll.
An Agent+ is built once and anyone in the practice can run it. It works from your own documents and runs on Ermos Dominion, the AI unit in your office, or on Ermos Edge, your own instance in an Australian data centre.
What leaves the agency
- 1Eight named workers
Eight people identified by name, on a sheet that also holds their pay, hours and private circumstances. Personal information. Section 7B(3) of the Privacy Act exempts an employer’s act or practice only if it is directly related to a current or former employment relationship and to an employee record the employer holds, and the Act’s definition of employee record includes hours, wages, superannuation and banking affairs and trade union membership. Whether that reaches an agency’s records of temps it employs, or what is done with them in an AI tool, is a legal question to put to a lawyer before relying on it. Privacy Act guide.
Frontier Models (ChatGPT, Claude) Transmitted to the provider, generally offshore on personal plans Ermos Edge Stays on your instance in Australia; leaves only inside a permitted excerpt, per question, to the named provider Ermos Dominion Stays on the unit in your office Use case Timesheet and margin reconciler. Reconciles host timesheets against the payroll run and builds the weekly margin sheet, flagging differences and keeping coordinator notes on a separate tab. See the use case - 2Which host each worker is with
The client each worker is placed with. Reveals the agency’s client list and where each worker spends the week.
Frontier Models (ChatGPT, Claude) Your client list and each worker’s placement transmitted Ermos Edge Stays on your instance in Australia; leaves only inside a permitted excerpt, per question, to the named provider Ermos Dominion Stays on the unit in your office Use case Timesheet and margin reconciler. Reconciles host timesheets against the payroll run and builds the weekly margin sheet, flagging differences and keeping coordinator notes on a separate tab. See the use case - 3Pay rates and gross pay
What each named worker earns an hour and for the week. Personal information, and the number the host would like to know. The gross column is hours times rate: 38 times $34.50 is $1,311.00, and the column totals $9,025.00. Privacy Act guide.
Frontier Models (ChatGPT, Claude) A pay column is arithmetic the AI can mis-add; the figures are also transmitted Ermos Edge Ermos keeps the text in, but the AI can still draft or add up wrongly; a person checks it Ermos Dominion Ermos keeps the text in, but the AI can still draft or add up wrongly; a person checks it Use case Timesheet and margin reconciler. Reconciles host timesheets against the payroll run and builds the weekly margin sheet, flagging differences and keeping coordinator notes on a separate tab. See the use case - 4The super column and its total
Superannuation at 12 per cent of gross, which matches the charge percentage in s 17A(2) of the Superannuation Guarantee (Administration) Act 1992. The column totals $1,083.00. Since the Payday Superannuation amendments (commencing 1 July 2026) a contribution counts against the superannuation guarantee amount for a payment of qualifying earnings if the fund receives it within the Act’s “usual period”, which ends on the seventh business day after the day the payment is made (s 18C; longer periods apply in some cases). The sheet applies 12 per cent to gross pay, which is the sheet’s own calculation and may not match qualifying earnings for every payment. Privacy Act guide.
Frontier Models (ChatGPT, Claude) The rate is a public rule; each person’s amount is transmitted Ermos Edge Ermos keeps the text in, but the AI can still draft or add up wrongly; a person checks it Ermos Dominion Ermos keeps the text in, but the AI can still draft or add up wrongly; a person checks it Use case Timesheet and margin reconciler. Reconciles host timesheets against the payroll run and builds the weekly margin sheet, flagging differences and keeping coordinator notes on a separate tab. See the use case - 5Charge rates, billed amounts and margin
What the host is charged, what each placement bills and what the agency keeps: $12,376.00 billed less $9,025.00 gross pay and $1,083.00 super leaves $2,268.00 before other costs. The agency’s most guarded numbers, and a pricing sheet for any competitor or host who sees it.
Frontier Models (ChatGPT, Claude) Your charge rates and margin transmitted Ermos Edge Stays on your instance in Australia; leaves only inside a permitted excerpt, per question, to the named provider Ermos Dominion Stays on the unit in your office Use case Timesheet and margin reconciler. Reconciles host timesheets against the payroll run and builds the weekly margin sheet, flagging differences and keeping coordinator notes on a separate tab. See the use case - 6A note about a union delegate
A worker identified as a delegate, with the host wanting him moved. Membership of a trade union is sensitive information under the Privacy Act. Section 346 of the Fair Work Act says a person must not take adverse action against another because the other is or is not an officer or member of an industrial association, or engages or does not engage in industrial activity. Privacy Act guide.
Frontier Models (ChatGPT, Claude) Sensitive information transmitted; on consumer tiers it can train future models Ermos Edge Stays on your instance in Australia; leaves only inside a permitted excerpt, per question, to the named provider Ermos Dominion Stays on the unit in your office Use case Timesheet and margin reconciler. Reconciles host timesheets against the payroll run and builds the weekly margin sheet, flagging differences and keeping coordinator notes on a separate tab. See the use case - 7A workers compensation claim and a carer note
An injury claim and a worker’s care for her mother. Health information is sensitive information, and family or carer’s responsibilities and physical or mental disability are attributes in s 351(1) of the Fair Work Act. Written down, they invite the question of whether they influenced a decision about her hours. Patient data guide.
Frontier Models (ChatGPT, Claude) Sensitive information transmitted; on consumer tiers it can train future models Ermos Edge Stays on your instance in Australia; leaves only inside a permitted excerpt, per question, to the named provider Ermos Dominion Stays on the unit in your office Use case Timesheet and margin reconciler. Reconciles host timesheets against the payroll run and builds the weekly margin sheet, flagging differences and keeping coordinator notes on a separate tab. See the use case - 8A student visa hours note
A visa status and weekly hours. 21 plus 22 is 43 hours across the two weeks, within the 48 hour fortnightly limit Study Australia gives for student visa holders while the course is in session. A tool given only this line cannot know what else the worker does; the agency does the checking. Privacy Act guide.
Frontier Models (ChatGPT, Claude) A visa status and weekly hours transmitted Ermos Edge Only the permitted excerpt reaches the provider, but a tool cannot see the second job; you do the check Ermos Dominion Stays on the unit, but a tool cannot see the second job; you do the check Use case Timesheet and margin reconciler. Reconciles host timesheets against the payroll run and builds the weekly margin sheet, flagging differences and keeping coordinator notes on a separate tab. See the use case - 9New bank details
Replacement account details received by email and not confirmed by phone. This is the pattern of a payroll diversion scam. APP 11.1 expects reasonable steps to protect personal information from misuse and unauthorised access, and the details sit in a file that is pasted into an outside tool. Privacy Act guide.
Frontier Models (ChatGPT, Claude) Bank details transmitted to a provider outside your control Ermos Edge Stays on your instance in Australia; leaves only inside a permitted excerpt, per question, to the named provider Ermos Dominion Stays on the unit in your office Use case Timesheet and margin reconciler. Reconciles host timesheets against the payroll run and builds the weekly margin sheet, flagging differences and keeping coordinator notes on a separate tab. See the use case - 10The margin formula
Billed less gross pay less super. A formula with no personal data in it, and the sheet is where the data sits.
Frontier Models (ChatGPT, Claude) A formula with no personal data in it Ermos Edge Not about where data goes Ermos Dominion Not about where data goes Use case Timesheet and margin reconciler. Reconciles host timesheets against the payroll run and builds the weekly margin sheet, flagging differences and keeping coordinator notes on a separate tab. See the use case
What happens in Frontier Models (ChatGPT, Claude)
- The whole document is transmitted to the provider’s servers. On personal plans the user cannot choose where it is stored or processed, and for the major providers that has generally meant outside Australia, under that country’s legal process. Some business plans offer storage in Australia, but the provider still receives the content.
- On consumer tiers, prompts can be retained and used to train future models.
- The provider’s staff and systems can reach the content under the provider’s own policies.
- Once sent, the agency no longer controls it. Retention and deletion happen on the provider’s terms.
The same document on Ermos
Ermos Dominion
The document is drafted on a unit in your office, from your own templates and the candidate file. Every marked item stays on the unit, which keeps working with the internet switched off. Nothing in it is transmitted to an AI provider, so there is no disclosure to analyse: the confidentiality work is the same as for your file server.
Ermos Edge
Your documents, the index and your access boundaries stay on your own instance in an Australian data centre. When a staff member asks for this draft, only their question and the excerpts they are permitted to see go to a named Australian provider, who is contractually barred from keeping the content or training any model on it. Nothing is processed outside Australia.
| Frontier Models (ChatGPT, Claude) | Ermos Edge | Ermos Dominion | |
|---|---|---|---|
| Where the document is processed | Provider servers, generally offshore on personal plans | Your instance in an Australian data centre; answers generated in Australia | The unit in your office |
| Who can read it | Provider staff and systems, under policy | Your staff, within the boundaries you set. The named Australian provider processes only permitted excerpts, under contract, and keeps nothing | Your staff only |
| Is it kept | On the provider’s terms | Kept on your instance; the provider is barred from retaining it | Stays on the unit |
| Can it train a model | On consumer tiers, yes | No, by contract | Only your own unit learns from it, on your hardware |
Part of Use cases in recruitment agencies.
Common questions
Do ChatGPT and Claude use the information in a temp timesheet and margin spreadsheet?
Can we use ChatGPT or Claude for a temp timesheet and margin spreadsheet if we remove the names?
Can I upload a temp timesheet and margin spreadsheet to ChatGPT or Claude instead of pasting it?
How can a recruitment agency use AI for a temp timesheet and margin spreadsheet without sending it to ChatGPT or Claude?
How much superannuation must an agency pay on a temp's wages?
Is union activity protected under the Fair Work Act?
Why is a margin spreadsheet sensitive to upload?
See Dominion answering from your own documents.
A demonstration takes 30 minutes, uses no client data, and comes with no obligation.
Book a demo