Superannuation reconciliation for Payday Super
“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”
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.
- FileXero pay run exportCSV export · 16 rows
- FileSuper clearing house contributions exportCSV export · 15 rows
- StepNumber pay run linesStep 1
- StepNumber contribution linesStep 2
- JoinMatch employee paydays15 of 16 paired
- StepFlag short and late paymentsStep 4
- ResultSuper Contribution Checks16 rows · 5 flagged
- ScheduleRuns when you sayProposed
On the sample files, every step runs and the result has 16 rows.
- Download Xero pay run export sample (16 rows)Xero: Reports > Payroll Activity Details > choose the October 2026 pay runs > Export
- Download Super clearing house contributions export sample (15 rows)Your super clearing house or fund portal: download the contributions report with the date each payment was received by the fund
What you get back
The result of that run, the rows to look at first.
| Employee | Employee ID | Payday | Status | Shortfall | Expected super | Due date | Xero super guarantee | Contribution amount | Date received | Fund |
|---|---|---|---|---|---|---|---|---|---|---|
| Fiona Hart | E1006 | 2026-10-16 | Not paid | 420 | 420 | 2026-10-27 | 420 | · | · | · |
| Bianca Ng | E1002 | 2026-10-02 | Paid late | 0 | 375.06 | 2026-10-13 | 375.06 | 375.06 | 2026-10-15 | BlueHarbor Super Fund |
| Gavin Reed | E1007 | 2026-10-16 | Paid late | 0 | 288 | 2026-10-27 | 288 | 288 | 2026-10-29 | BlueHarbor Super Fund |
| Callum Price | E1003 | 2026-10-02 | Short paid | 20 | 237.60 | 2026-10-13 | 237.60 | 217.60 | 2026-10-08 | BlueHarbor Super Fund |
| Ethan Wells | E1005 | 2026-10-16 | Short paid | 16 | 336 | 2026-10-27 | 336 | 320 | 2026-10-26 | BlueHarbor Super Fund |
| Avery Cole | E1001 | 2026-10-02 | Agrees | 0 | 300 | 2026-10-13 | 300 | 300 | 2026-10-06 | BlueHarbor Super Fund |
| Dahlia Ross | E1004 | 2026-10-02 | Agrees | 0 | 492 | 2026-10-13 | 492 | 492 | 2026-10-09 | BlueHarbor Super Fund |
| Ethan Wells | E1005 | 2026-10-02 | Agrees | 0 | 330.03 | 2026-10-13 | 330.03 | 330.03 | 2026-10-13 | BlueHarbor Super Fund |
| Fiona Hart | E1006 | 2026-10-02 | Agrees | 0 | 432 | 2026-10-13 | 432 | 432 | 2026-10-07 | BlueHarbor Super Fund |
| Gavin Reed | E1007 | 2026-10-02 | Agrees | 0 | 264 | 2026-10-13 | 264 | 264 | 2026-10-12 | BlueHarbor Super Fund |
| Holly Tran | E1008 | 2026-10-02 | Agrees | 0 | 478.66 | 2026-10-13 | 478.66 | 478.66 | 2026-10-10 | BlueHarbor Super Fund |
| Avery Cole | E1001 | 2026-10-16 | Agrees | 0 | 312 | 2026-10-27 | 312 | 312 | 2026-10-22 | BlueHarbor Super Fund |
How it works
How to use the Super Contribution Checks workflow
- 1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and working on sample files.
- 2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
- 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?
Which export should you use?
What happens to rows that do not match?
How do you change the rules?
Get early access to this workflow
It opens already built and working on sample files. Swap in your own exports to see your result.
Workflows like this
Bank to ledger, payouts to deposits, returns to books. Every row comes back matched, or flagged with the reason.
- Bank reconciliationEvery line matched, flagged for a date check, or missing from one sideSee the workflow Template
- Payment reconciliationEach payout matched to its bank deposit, flagged for a date check, or missingSee the workflow Template
- Match names to a master listEach record with its master name (and ID), and how it matchedSee the workflow Template
- Cash reconciliationEach day's takings matched to a bank deposit, or flagged as not bankedSee the workflow Template
- Match customer payments to open invoicesMatch bank payments to QuickBooks open invoices by customer and amount, and see what is still unapplied.See the workflow Built by the agent
- Compare two listsCompare two exported spreadsheet lists by email, see matches, and label rows where name and email agree or differ.See the workflow Built by the agent