Skip to content
Workflow · Match two lists · Opening soon

Superannuation reconciliation for Payday Super

Export your Xero pay run file, along with the contribution file from the super fund or clearing house, then upload them to Mammoth. Mammoth matches each employee’s super guarantee for every payday, checks the 7 business day due date, and flags short paid, late paid, and unpaid rows.

Early access opens shortly. Check back soon.

Someone typed

“match each employee's super guarantee for every payday in my xero pay runs to the contributions received by their super fund, at 12% of qualifying earnings, due within 7 business days after payday, and show who was short paid, paid late or not paid at all”

The agent read it as

Match each employee's super guarantee for every payday in my Xero pay run export to the contributions received by their super fund, at 12% of qualifying earnings, due within 7 business days after payday, and show who was short paid, paid late or not paid at all, counting weekends only as non-business days.

What the agent built

4 steps, each one an ordinary Mammoth step you can open and change.

  1. File
    Xero pay run export
    CSV export · 16 rows
  2. File
    Super clearing house contributions export
    CSV export · 15 rows
  3. Step
    Number pay run lines
    Step 1
  4. Step
    Number contribution lines
    Step 2
  5. Join
    Match employee paydays
    15 of 16 paired
  6. Step
    Flag short and late payments
    Step 4
  7. Result
    Super Contribution Checks
    16 rows · 5 flagged
  8. Schedule
    Runs when you say
    Proposed

On the sample files, every step runs and the result has 16 rows.

What you get back

The result of that run, the rows to look at first.

Super Contribution ChecksSample data16 rows
11 agrees2 paid late2 short paid1 not paid
EmployeeEmployee IDPaydayStatusShortfallExpected superDue dateXero super guaranteeContribution amountDate receivedFund
Fiona HartE10062026-10-16Not paid4204202026-10-27420···
Bianca NgE10022026-10-02Paid late0375.062026-10-13375.06375.062026-10-15BlueHarbor Super Fund
Gavin ReedE10072026-10-16Paid late02882026-10-272882882026-10-29BlueHarbor Super Fund
Callum PriceE10032026-10-02Short paid20237.602026-10-13237.60217.602026-10-08BlueHarbor Super Fund
Ethan WellsE10052026-10-16Short paid163362026-10-273363202026-10-26BlueHarbor Super Fund
Avery ColeE10012026-10-02Agrees03002026-10-133003002026-10-06BlueHarbor Super Fund
Dahlia RossE10042026-10-02Agrees04922026-10-134924922026-10-09BlueHarbor Super Fund
Ethan WellsE10052026-10-02Agrees0330.032026-10-13330.03330.032026-10-13BlueHarbor Super Fund
Fiona HartE10062026-10-02Agrees04322026-10-134324322026-10-07BlueHarbor Super Fund
Gavin ReedE10072026-10-02Agrees02642026-10-132642642026-10-12BlueHarbor Super Fund
Holly TranE10082026-10-02Agrees0478.662026-10-13478.66478.662026-10-10BlueHarbor Super Fund
Avery ColeE10012026-10-16Agrees03122026-10-273123122026-10-22BlueHarbor Super Fund
16 rows in the result · 12 shown, problems first. Sample data: illustrative figures, not business results.

How it works

How to use the Super Contribution Checks workflow

  1. 1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and working on sample files.
  2. 2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
  3. 3Change it in words, then turn it onSay what to change and see the new result before anything saves. Then choose when it runs.

Super Contribution Checks: questions

How do you reconcile superannuation for Payday Super?
Export your Xero pay run file, along with the contribution file from the super fund or clearing house, then upload them to Mammoth. Mammoth matches each employee’s super guarantee for every payday, checks the 7 business day due date, and flags short paid, late paid, and unpaid rows. Super guarantee is 12% of qualifying earnings, paid within 7 business days of payday (Payday Super, from 1 July 2026).
Which export should you use?
Use the pay run export from Xero, plus the contribution export that shows when each super payment was received by the fund or clearing house.
What happens to rows that do not match?
Rows that do not match are left out of the matched result and are shown as unmatched, so you can review them separately.
How do you change the rules?
Change the rules in words, for example the matching fields, the due date window, or how short paid and late paid are defined, then run the workflow again.

Get early access to this workflow

It opens already built and working on sample files. Swap in your own exports to see your result.

Early access opens shortly. Check back soon.