PropoDoc provides self-help document templates and tools. It is not a law firm and does not provide legal advice. Learn more.
Skip to main content
Template
Free

Superannuation Guarantee Calculator Template

Template for Superannuation Guarantee Calculator. Customize this template for your specific needs.

Professional Review Recommended

This document may have legal or financial implications. We recommend having a qualified professional review the final version before use.

Document: Superannuation Guarantee Calculator

Template Preview

Version 1 • Last updated 7/29/2026

Superannuation Guarantee Calculator Template

Business Name: [ENTER BUSINESS NAME] ABN: [ENTER ABN] Calculation Period: From [START DATE] To [END DATE] SG Rate Current: [ENTER PERCENTAGE]%

Instructions

  1. Enter the details of each employee below.
  2. Enter the total Ordinary Time Earnings (OTE) for the period. Do not include overtime unless specified by the relevant award.
  3. The template will calculate the superannuation payable.
  4. Compare the total with the amount you have paid.
Employee NameEmployee IDOTE ($AUD)SG Rate (%)Super Payable ($AUD)Fund NameContribution Reference NumberPayment Status
[ENTER NAME][ENTER ID][ENTER AMOUNT][ENTER RATE][CALCULATED][ENTER FUND][ENTER CRN][PAID / UNPAID]
[ENTER NAME][ENTER ID][ENTER AMOUNT][ENTER RATE][CALCULATED][ENTER FUND][ENTER CRN][PAID / UNPAID]
[ENTER NAME][ENTER ID][ENTER AMOUNT][ENTER RATE][CALCULATED][ENTER FUND][ENTER CRN][PAID / UNPAID]

Totals

Total OTE: [SUM OF COLUMN C] Total Super Payable: [SUM OF COLUMN E] Total Amount Paid: [ENTER ACTUAL PAYMENT AMOUNT] Shortfall (if any): [TOTAL PAYABLE MINUS TOTAL PAID]

Notes

[ADD ANY NOTES ABOUT OVERTIME OR ALLOWANCES INCLUDED]

Declaration: I declare that these calculations are true and correct based on the OTE entered.

Signed: [SIGNATURE] Date: [DATE]

Use in GeneratorView Guide

About this Template

Part of the Superannuation Guarantee Calculator document collection

Document Type

Superannuation Guarantee Calculator

A tool to help Australian employers calculate the correct amount of superannuation to pay employees.

Complexity

simple

Format

spreadsheet