What does this superannuation contributions tracker do?

It records each contribution by employee and pay period, then shows what is due, what has been paid and what is still outstanding. That gives you a simple working paper for payroll checks and quarterly reconciliation.

Does it calculate super at the current rate?

The template includes a super rate field and calculates super due from gross OTE. In 2026, the superannuation guarantee rate is 11.5%, so a $2,500 ordinary time earnings payment gives $287.50 super due.

Can I use it for multiple employees and pay runs?

Yes. Add one row per contribution, then sort or filter by employee, payment date or status. That works well whether you have 3 employees or 30.

How does this help with ATO compliance?

It helps you keep a clear record of amounts due, amounts paid and any shortfalls, and the ATO expects you to keep records for 5 years. It also gives you a paper trail if you need to check a payment against payroll or STP reporting.

Is this a replacement for payroll software?

No. It is a practical spreadsheet for tracking and checking contributions, not a full payroll system. If you need automated super clearing, leave accruals and STP lodgement in one place, software is the better fit.

How often should I update it?

Update it every pay run, then do a fuller check at the end of each month or quarter. That way, a $22.00 shortfall does not sit unnoticed until the super payment deadline has already passed.

Payroll & HR

Superannuation Contributions Tracker Excel - Free Template

Track super due, super paid and shortfalls by employee, with a summary dashboard and instructions for Australian businesses.

2026-06-23

176 Downloads

4.8/5 Average rating

Download template

Screenshot 1: Contributions Log tab - Excel template superannuation contributions tracker excel template australia

This superannuation contributions tracker Excel template helps you record superannuation due, paid and outstanding for each employee across each pay period. It includes a Contributions Log, a Summary Dashboard and Instructions sheet, so you can keep an eye on cash flow, shortfalls and payment timing in one place.

Use it when you want a simple check against your pay run, especially if you are paying a team manually or reconciling super after each fortnight. The log captures employee name, city, pay period dates, payment date, contribution type, gross OTE, super rate, super due, super paid, status and notes.

The dashboard gives you a quick snapshot of what is due and what has already been paid, while the Instructions sheet helps you set it up without mucking about. It is built for Australian small business bookkeeping, where the big headache is usually not the calculation — it is making sure nothing slips through before the quarterly deadline.

The key benefits of this Excel template

Tracks super due, super paid and shortfalls in one register, so you can see gaps before they turn into a late payment charge.
Stores each contribution by employee and pay period, which makes reconciliation at month-end or quarter-end much easier.
Shows the payment date and status, so you can separate contributions that are paid, outstanding or overpaid.
Uses gross OTE and super rate fields, which keeps the calculation transparent for payroll checks.
Helps you spot a $312 shortfall on a $2,800 pay run before it becomes a bigger problem across the quarter.
Gives you a summary dashboard, so you can review the team’s super position without trawling through every line.
Keeps the setup lightweight enough for a small business that is still managing payroll in Excel before moving to payroll software.

Step-by-step guide

Open the Contributions Log and enter one row for each employee contribution. Use the pay period start and end dates, payment date and contribution type so the record is complete.
Enter the employee’s gross OTE and the super rate being applied. For example, $2,400 at 11.5% gives super due of $276.00.
Record the amount actually paid to the fund and let the shortfall or overpayment field show the difference. That makes it easy to follow up anything that is not right.
Update the status column once the payment is processed or matched. If you are running a weekly payroll, make this part of the same routine as checking timesheets.
Review the Summary Dashboard after each pay run or at the end of the month. Use it to compare total super due, total paid and any outstanding amounts.
Check the Instructions sheet before you start, especially if you are using the file for the first time or handing it to a new office manager or bookkeeper.

Screenshot 2: Summary Dashboard tab - Excel template superannuation contributions tracker excel template australia — Figure 2: Worksheet "Summary Dashboard"

What is included

Contributions Log sheet with fields for contribution ID, employee name, city, pay period dates, payment date and notes.

Built-in tracking for gross OTE, super rate, super due, super paid and shortfall or overpayment.

Status column to mark payments as pending, paid or adjusted, which helps with reconciliation.

Summary Dashboard sheet for a quick read on totals and outstanding contributions.

Instructions sheet to help you use the template consistently across the pay cycle.

Formatted currency, percentage and date fields using standard Excel formats.

Column layout that suits small business payroll records without needing a separate accounting system.

How Australian employers use this super tracker each pay cycle

Sole traders with their first employee, bookkeepers in a Pty Ltd, and office managers at tradie businesses usually reach for a super tracker when the pay run is done and the numbers need checking. It is especially handy in the last week of the quarter, when you are trying to make sure every superannuation payment has been sent to a complying fund before the deadline.

Take a chippy with 4 employees on ordinary time earnings of $1,800, $2,100, $2,400 and $3,000 a fortnight. At 11.5%, the weekly super works out to $207.00, $241.50, $276.00 and $345.00 respectively, so one missed payment shows up fast in the log.

Who actually uses it

A sole trader with a part-time admin assistant can use the sheet to check the employer amount before paying the fund. A small wholesale business with 12 staff can use it to match the payroll journal to actual bank payments, then tick off each row once the contribution clears.

Why Excel suits the job

For small payrolls, Excel is often the quickest way to keep a clean audit trail without jumping straight into payroll software. You can sort by employee, filter by status, and line up the pay period dates against the payment date, which is enough to catch most mistakes before they become a super headache.

Where the dashboard helps

The Summary Dashboard is useful when you want the high-level view: total super due, total paid and the amount still outstanding. That is the kind of snapshot a bookkeeper wants before the BAS prep, or a business owner wants after a $24,000 payroll fortnight.

Screenshot 3: Instructions tab - Excel template superannuation contributions tracker excel template australia — Figure 3: Worksheet "Instructions"

What the ATO and Fair Work expect from your super records

Employers must pay the superannuation guarantee at 11.5% in 2026, and the payment generally has to reach the employee’s fund by the quarterly due date, not just leave your bank account. For most small businesses, that means keeping your internal tracker aligned to the quarter ending 31 March, 30 June, 30 September and 31 December, then checking the actual payment dates against the fund receipts.

The ATO expects you to keep records for 5 years, and that includes payroll records that show how the amount was worked out. If an employee’s ordinary time earnings are $2,800 and you pay super at 11.5%, the contribution should be $322.00; if you only paid $300.00, the $22.00 shortfall needs to be visible straight away.

Tax and payroll record basics

Super sits alongside PAYG withholding and STP reporting, so your payroll records need to tie back to what is reported and paid. The tracker does not replace your BAS or payroll system, but it does give you a clean working paper when you are checking figures before lodgement or payment.

Fund details and references

The ABN / Fund Reference column is there because fund details matter when you are matching payments, especially if you are paying multiple super funds. If you pay 8 employees across 3 funds, a clear reference column saves you from chasing which transfer belongs to which employee at quarter end.

How the rules hit small businesses

Fair Work also sits in the background because payroll compliance is not just about the amount of super, it is about paying people correctly and on time. A payroll that is $500 short on super across 6 employees can turn into a costly fix once you add admin time, follow-up calls and possible penalties.

The super mistakes that create shortfalls and penalties

The most common problem is using the wrong earnings base, especially when overtime, allowances or bonuses are mixed into the pay. If you calculate super on the wrong figure and miss $18.40 per employee over 12 employees, that is $220.80 out the door for a single pay cycle, and it is usually not the only error.

Another common issue is treating the payment date as the due date. If the money lands in the fund after the quarterly cut-off, the employer can still end up with a super guarantee charge, even if the transfer was started on time.

What a missed payment really costs

One missed super payment is rarely just the unpaid amount. You are also dealing with admin time to trace the transfer, reconcile the payroll record, and answer employee questions when someone notices their fund balance is light by $276.00 or $345.00.

Where spreadsheets go wrong

Small errors in the Super Paid column can hide for months if the sheet is not reviewed regularly. A row that says $322.00 due and $320.00 paid looks close enough at a glance, but across 20 employees that kind of drift can leave you $40.00 short for the period and create messy end-of-quarter reconciliation.

Why overpayments matter too

Overpaying super is less painful than underpaying, but it still distorts your books and your profit and loss. If you pay an extra $150.00 to the wrong fund, you may spend an hour or more sorting the reversal instead of getting on with payroll, BAS prep or invoicing.

Those reversals become easier to trace when the payment and invoicing side is already clean, so the ABN invoice template keeps the paper trail aligned with the super entries.

How to make this spreadsheet part of your payroll routine

The easiest way to keep this tracker alive is to link it to an existing task, like the pay run or the monthly reconciliation. If you run payroll every Thursday, make Friday morning the time to update the log, confirm the super amount and mark any unpaid rows.

Simple habits that keep it current

Copy the prior pay period’s row structure so the dates and employee names are already there.
Use filters on Status so you can see only unpaid or shortfall rows at a glance.
Check the Summary Dashboard after each pay run, not just at the quarter end.
Keep the ABN / Fund Reference column current so you are not hunting for fund details later.

For a team of 7 employees, this can be a 10-minute check if the file is kept tidy. For a business with 25 staff and multiple funds, Excel still works for a while, but once you are spending half a day on payroll admin each month, it is usually time to move to proper software like Xero or MYOB.

When to move on

If you need automated STP, award interpretation, leave accruals and super clearing in one place, Excel has probably done its job. Keep the spreadsheet for spot checks and history, then let payroll software handle the heavy lifting once the business outgrows manual tracking.

That same move to payroll software also makes room for more detailed pay planning, including a salary sacrifice calculator for checking net pay and super contributions.

Frequently asked questions about this template

It records each contribution by employee and pay period, then shows what is due, what has been paid and what is still outstanding. That gives you a simple working paper for payroll checks and quarterly reconciliation.
The template includes a super rate field and calculates super due from gross OTE. In 2026, the superannuation guarantee rate is 11.5%, so a $2,500 ordinary time earnings payment gives $287.50 super due.
Yes. Add one row per contribution, then sort or filter by employee, payment date or status. That works well whether you have 3 employees or 30.
It helps you keep a clear record of amounts due, amounts paid and any shortfalls, and the ATO expects you to keep records for 5 years. It also gives you a paper trail if you need to check a payment against payroll or STP reporting.
No. It is a practical spreadsheet for tracking and checking contributions, not a full payroll system. If you need automated super clearing, leave accruals and STP lodgement in one place, software is the better fit.
Update it every pay run, then do a fuller check at the end of each month or quarter. That way, a $22.00 shortfall does not sit unnoticed until the super payment deadline has already passed.