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
· quarter ended 30 September 2026 · six fortnightly pay dates

fx=ROUND(B2*0.12,2)
ABCDEFGHI
1Employee and roleSuper paid ($)Shortfall ($)STP gross ($)STP variance ($)Note
227,300.005,700.003,276.003,276.000.0027,300.000.00
331,200.006,980.003,744.003,744.000.0031,200.000.00
417,550.002,410.002,106.002,106.000.0017,550.000.00
512,480.001,060.001,497.601,497.600.0012,480.000.00
616,800.002,260.002,016.002,016.000.0016,800.000.00
721,450.003,610.002,574.002,574.000.0021,450.000.00
89,360.00460.001,123.201,123.200.009,360.000.00
918,720.002,770.002,246.402,246.400.0018,135.00(585.00)
107,800.00220.00936.00936.000.007,800.000.00
1113,650.001,560.001,638.001,569.7568.2513,650.000.00
12Total176,310.0027,030.0021,157.2021,088.95175,725.00
Q1 FY27Super paidSTPNotes

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

  1. Reads payroll summaries, super payment records and reports
  2. Builds the reconciliation in your workbook layout
  3. 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

  1. 1
    The 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.

  2. 2
    The 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.

  3. 3
    What 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.

  4. 4
    The 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.

  5. 5
    The 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.

  6. 6
    A 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.

  7. 7
    A 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.

  8. 8
    A 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.

  9. 9
    A 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.

  10. 10
    The 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.

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 EdgeErmos Dominion
Where the document is processedProvider servers, generally offshore on personal plansYour instance in an Australian data centre; answers generated in AustraliaThe unit in your office
Who can read itProvider staff and systems, under policyYour staff, within the boundaries you set. The named Australian provider processes only permitted excerpts, under contract, and keeps nothingYour staff only
Is it keptOn the provider’s termsKept on your instance; the provider is barred from retaining itStays on the unit
Can it train a modelOn consumer tiers, yesNo, by contractOnly 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?
Whatever is pasted in is sent to the AI company's servers and processed there to produce a reply. As at October 2026, whether a conversation on a personal plan (ChatGPT Free, Plus or Pro; Claude Free, Pro or Max) can be used to train the models depends on a setting each user controls. Business plans (ChatGPT Business and Enterprise, Claude Team and Enterprise) and the developer APIs sit under commercial terms, and OpenAI and Anthropic each say they do not train on that content by default (OpenAI, Anthropic). On either product, the thumbs up and thumbs down buttons can send a whole conversation back for training. This workbook carries ten Northside Smile Studio employees by name against gross pay, PAYG withheld and super paid, with a note about one employee's knee surgery.
Is it safe to paste a payroll and super reconciliation into ChatGPT or Claude?
No, because the workbook is a payroll, and its ten employees are individuals who are not the firm's clients. The Office of the Australian Information Commissioner (OAIC) recommends in its guidance on commercially available AI products that organisations do not enter personal information, and particularly sensitive information, into publicly available generative AI tools, because of the significant and complex privacy risks. Each name sits in a row with a role, a pay figure and a tax figure, and the notes record a late super payment, a shortfall of $68.25 and a $585 gap between payroll and Single Touch Payroll.
Can ChatGPT or Claude be trusted to prepare a payroll and super reconciliation?
Language models can produce fluent text with details that are not in the source, wrong figures or dates, and references that look real but are not. A qualified person must check every figure. In this workbook the errors that would do most harm are a super formula using the wrong rate, a mis-copied row, a total that does not add up, and a shortfall or Single Touch Payroll variance that is missed or given the wrong sign.
How can an accounting firm use AI for a payroll and super reconciliation without sending it to ChatGPT or Claude?
Ermos is built so the document stays under your control. On the Dominion AI unit it is drafted inside your office and none of it is sent to an AI provider. On Ermos Edge your documents and index stay on your own instance in an Australian data centre, and only the question and the excerpts the user is permitted to see go to a named Australian provider that is contractually barred from keeping them or training any model on them. The reconciliation is prepared from the client's payroll report and the firm's own reconciliation template. A qualified person recalculates the super and checks every total before it is signed off.
What is the super guarantee rate for 2026-27?
The ATO states that the super guarantee rate is 12 percent of an employee's qualifying earnings, and that the rate has not changed with the start of Payday Super on 1 July 2026. Qualifying earnings is the new base, which includes ordinary time earnings and other amounts counted for super guarantee purposes. An award or agreement can require a higher rate.
What changed with Payday Super on 1 July 2026?
The ATO says employers must pay super so that it is received by the employee's fund, with enough information to allocate it, within seven business days after each payday. Payment through the Small Business Superannuation Clearing House is no longer available. The super guarantee charge applies where the deadline is missed, and the ATO assesses it.
Why reconcile Single Touch Payroll to the payroll report?
Single Touch Payroll is what the ATO sees. From 1 July 2026 it carries each employee's year-to-date qualifying earnings and super liability, so a pay adjustment that never reached STP leaves the ATO with a different figure from the payroll. A quarterly comparison finds those gaps before the BAS and the employees' end-of-year statements.

See Dominion answering from your own documents.

A demonstration takes 30 minutes, uses no client data, and comes with no obligation.

Book a demo