Accountant Payroll and Super Reconciliations: Use case and AI Confidentiality
Payroll reconciliations are a natural job for AI: compare the payroll report with what was sent to the ATO, recalculate the super and flag the gaps. The workbook that holds this is a list of a client’s employees against what each was paid, what tax was withheld, what super reached their fund and the preparer’s remarks about each person. Pasted into ChatGPT or Claude, it hands an AI company a payroll. This page marks every item in a realistic reconciliation for the first quarter of Payday Super that APES 110 and the TPB Code bear on, shows which heading is only a public rate, and shows how the same check runs on Ermos inside the practice.
The payroll and super reconciliation
Prepared after the September quarter and before the BAS is finalised. From 1 July 2026 under Payday Super, the ATO says super must be received by the employee’s fund within seven business days of each payday, and Single Touch Payroll reports each employee’s qualifying earnings and super liability.
Payroll and super reconciliation
Marchetti Dental Pty Ltd, trading as Northside Smile Studio1 · quarter ended 30 September 2026 · six fortnightly pay dates
| A | B | C | D | E | F | G | H | I | |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Employee and role | Gross wages ($)3 | PAYG withheld ($)4 | Super at 12% ($)5 | Super paid ($) | Shortfall ($) | STP gross ($) | STP variance ($) | Note |
| 2 | Hannah Farrugia, practice manager2 | 27,300.00 | 5,700.00 | 3,276.00 | 3,276.00 | 0.00 | 27,300.00 | 0.00 | |
| 3 | Ellie Gunawardena, dental hygienist2 | 31,200.00 | 6,980.00 | 3,744.00 | 3,744.00 | 0.00 | 31,200.00 | 0.00 | |
| 4 | Hugo Fenech, dental assistant2 | 17,550.00 | 2,410.00 | 2,106.00 | 2,106.00 | 0.00 | 17,550.00 | 0.00 | Pay of 18 Sep reached the fund on 6 Oct, after the seven business days allowed9 |
| 5 | Grace Hollingworth, dental assistant2 | 12,480.00 | 1,060.00 | 1,497.60 | 1,497.60 | 0.00 | 12,480.00 | 0.00 | Paid personal leave 3 to 14 Aug for knee surgery8 |
| 6 | Eamon Fogarty, reception2 | 16,800.00 | 2,260.00 | 2,016.00 | 2,016.00 | 0.00 | 16,800.00 | 0.00 | |
| 7 | Fiona Grech, treatment coordinator2 | 21,450.00 | 3,610.00 | 2,574.00 | 2,574.00 | 0.00 | 21,450.00 | 0.00 | |
| 8 | Hamish Galloway, reception2 | 9,360.00 | 460.00 | 1,123.20 | 1,123.20 | 0.00 | 9,360.00 | 0.00 | |
| 9 | Eva Heffernan, dental assistant2 | 18,720.00 | 2,770.00 | 2,246.40 | 2,246.40 | 0.00 | 18,135.00 | (585.00) | $585 loading keyed on 25 Sep after the pay event was sent. Not yet in STP7 |
| 10 | Gareth Elmore, apprentice2 | 7,800.00 | 220.00 | 936.00 | 936.00 | 0.00 | 7,800.00 | 0.00 | |
| 11 | Ruth Finlayson, sterilisation nurse2 | 13,650.00 | 1,560.00 | 1,638.00 | 1,569.75 | 68.25 | 13,650.00 | 0.00 | Payroll rate field still 11.5%. Fund received 1,569.756 |
| 12 | Total | 176,310.00 | 27,030.00 | 21,157.20 | 21,088.95 | 68.2510 | 175,725.00 | (585.00)10 | Prepared J. Whitlam. Reviewed S. Lindqvist10 |
An invented reconciliation. The employees are invented and PAYG amounts are illustrative. Hover or tap any highlighted cell for the analysis; the full list is below.
Payroll and super reconciler
An Agent+ that builds the reconciliation from the client's own source documents. It sets pay, tax withheld and super paid against what was reported, in your workbook layout, and lists each difference with the records behind it.
What it does
- Reads payroll summaries, super payment records and reports
- Builds the reconciliation in your workbook layout
- Flags differences and missing records for the preparer
What stays with your people. A senior preparer or manager reviews each flagged item and resolves it. The agent builds and flags; it does not adjust anything.
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 firm
- 1The client and the quarter
Names the business behind every figure. A workbook also carries author and last-saved-by fields and any hidden tabs or columns when it is shared as a file. Confidential client information under APES 110 R114.2. APES 110 confidentiality 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 Payroll and super reconciler. Builds the quarter's reconciliation workbook from payroll, payment and reporting records, flagging each difference between pay, tax withheld and super for the preparer. See the use case - 2The employees, by name and role
Ten named people who are not the practice’s clients, with their jobs. Personal information about individuals, tied to pay in the same row. Privacy Act guide.
Frontier Models (ChatGPT, Claude) Ten employees’ names and jobs 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 Payroll and super reconciler. Builds the quarter's reconciliation workbook from payroll, payment and reporting records, flagging each difference between pay, tax withheld and super for the preparer. See the use case - 3What each person was paid
A pay figure against a name. Financial information about named people, and a payroll a competitor would value. Confidential to the client under APES 110 R114.2 and Code item 6. APES 110 confidentiality guide.
Frontier Models (ChatGPT, Claude) A payroll 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 Payroll and super reconciler. Builds the quarter's reconciliation workbook from payroll, payment and reporting records, flagging each difference between pay, tax withheld and super for the preparer. See the use case - 4The tax withheld from each person
PAYG withheld against a name. It shows each employee’s tax position, and the PAYG amounts feed the client’s BAS. A column of figures the client has not had checked. Privacy Act guide.
Frontier Models (ChatGPT, Claude) Each employee’s tax position 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 Payroll and super reconciler. Builds the quarter's reconciliation workbook from payroll, payment and reporting records, flagging each difference between pay, tax withheld and super for the preparer. See the use case - 5The 12% heading
The super guarantee rate for 2026-27 is 12% of qualifying earnings, which the ATO states has not changed, and the formula is =ROUND(B2*0.12,2). A public rate and a formula with no client data in the label.
Frontier Models (ChatGPT, Claude) A public rate and a formula with no client data Ermos Edge Nothing to protect in a public rate Ermos Dominion Nothing to protect in a public rate Use case Payroll and super reconciler. Builds the quarter's reconciliation workbook from payroll, payment and reporting records, flagging each difference between pay, tax withheld and super for the preparer. See the use case - 6A shortfall from the wrong rate
One employee’s super was calculated at 11.5% because the payroll rate field was never updated, leaving a shortfall of $68.25. A compliance exposure for the client. The employer owes the super guarantee, and the shortfall figure is arithmetic that a person has to check. Checking AI output guide.
Frontier Models (ChatGPT, Claude) A client’s super shortfall transmitted Ermos Edge Stays in Australia, but the AI can still miscalculate the shortfall Ermos Dominion Stays on the unit, but the AI can still miscalculate the shortfall Use case Payroll and super reconciler. Builds the quarter's reconciliation workbook from payroll, payment and reporting records, flagging each difference between pay, tax withheld and super for the preparer. See the use case - 7A difference between payroll and STP
A $585 adjustment keyed after the pay event that has not reached Single Touch Payroll, so the ATO’s data differs from the payroll. From 1 July 2026 STP reports year-to-date qualifying earnings and super liability for each employee, so the gap matters to the ATO as well as to the client. TPB Code guide.
Frontier Models (ChatGPT, Claude) A gap between payroll and the ATO’s data 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 Payroll and super reconciler. Builds the quarter's reconciliation workbook from payroll, payment and reporting records, flagging each difference between pay, tax withheld and super for the preparer. See the use case - 8A remark about surgery
Paid personal leave for a named employee’s knee surgery. Health information about a person who is not the practice’s client. It is sensitive information under the Privacy Act where the Act applies to the holder. Patient data guide.
Frontier Models (ChatGPT, Claude) A health remark about a named employee 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 Payroll and super reconciler. Builds the quarter's reconciliation workbook from payroll, payment and reporting records, flagging each difference between pay, tax withheld and super for the preparer. See the use case - 9A payment that reached the fund late
Under Payday Super the ATO says super must be received by the fund within seven business days after payday to avoid the super guarantee charge. A late payment is the client’s exposure and the preparer’s finding. TPB Code guide.
Frontier Models (ChatGPT, Claude) A late payment, and the client’s exposure, 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 Payroll and super reconciler. Builds the quarter's reconciliation workbook from payroll, payment and reporting records, flagging each difference between pay, tax withheld and super for the preparer. See the use case - 10The totals, the variance and the sign-off
The shortfall and variance totals and the names of the preparer and the reviewer. The sums are arithmetic that a person has to check against the payroll report and the ATO, and the names make any leak traceable to the practice. Checking AI output guide.
Frontier Models (ChatGPT, Claude) Transmitted, and the leak is traceable to you Ermos Edge Stays in Australia, but the totals still need a person to check them against the payroll report Ermos Dominion Stays on the unit, but the totals still need a person to check them against the payroll report Use case Payroll and super reconciler. Builds the quarter's reconciliation workbook from payroll, payment and reporting records, flagging each difference between pay, tax withheld and super for the preparer. 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 firm 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 client 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 accounting firms. See how this works in practice: Workpaper review on Ermos.
Common questions
Do ChatGPT and Claude use the information in a payroll and super reconciliation?
Is it safe to paste a payroll and super reconciliation into ChatGPT or Claude?
Can ChatGPT or Claude be trusted to prepare a payroll and super reconciliation?
How can an accounting firm use AI for a payroll and super reconciliation without sending it to ChatGPT or Claude?
What is the super guarantee rate for 2026-27?
What changed with Payday Super on 1 July 2026?
Why reconcile Single Touch Payroll to the payroll report?
See Dominion answering from your own documents.
A demonstration takes 30 minutes, uses no client data, and comes with no obligation.
Book a demo