Loading
This thread is archived and the information may not be up-to-date. You can't reply to this thread.
sammywammy(Initiate)Initiate
9 Oct 2023

I am trying to understand the calculation of the SGC Shortfall as I would like to use the spreadsheet tool to bulk report super underpayments. This is for the 22-23 financial year (SG rate 10.5%)


Example 1:

Salary and Wages = $4,000.

OTE = $1,000.

Super paid on time, meeting choice obligations = $0.

Shortfall calculated was $420.

I can see the shortfall was calculated entirely on the salary and wages figure.


Example 2:

Salary and Wages = $4,000.

OTE = $1,000.

Super paid on time, meeting choice obligations = $20

Shortfall calculated was $340.


Example 3:

Salary and Wages = $4,000.

OTE = $1,000.

Super paid on time, meeting choice obligations = $50

Shortfall calculated was $220.


Example 4:

Salary and Wages = $4,000.

OTE = $1,000.

Super paid on time, meeting choice obligations = $80

Shortfall calculated was $100.


Example 5:

Salary and Wages = $4,000.

OTE = $1,000.

Super paid on time, meeting choice obligations = $100

Shortfall calculated was $25.


I am unsure how examples 2-5 are calculated?

553 views
2 replies
553 views
2 replies

Most helpful response

Most helpful reply

sammywammy(Initiate)Initiate
9 Oct 2023

It seems the SGC shortfall payable is based on the percentage of the unpaid OTE super entitlement.


Example 1:

Salary and Wages = $4,000.

OTE = $1,000.

Super paid on time, meeting choice obligations = $0.

Shortfall calculated was $420.

Calculation:

$1,000 OTE x 10.5% = $105 super entitlement on OTE.

$0 super paid on time / $105 super entitlement = 100% OTE super entitlement not paid.

$4,000 SAW x 10.5% = $420 super entitlement on SAW.

$420 x 100% = $420 SGC shortfall.


Example 2:

Salary and Wages = $4,000.

OTE = $1,000.

Super paid on time, meeting choice obligations = $20

Shortfall calculated was $340.

Calculation:

$1,000 OTE x 10.5% = $105 super entitlement on OTE.

$20 super paid on time / $105 super entitlement = 80.95% OTE super entitlement not paid.

$4,000 SAW x 10.5% = $420 super entitlement on SAW.

$420 x 80.95% = $340 SGC shortfall.


Example 3:

Salary and Wages = $4,000.

OTE = $1,000.

Super paid on time, meeting choice obligations = $50

Shortfall calculated was $220.

Calculation:

$1,000 OTE x 10.5% = $105 super entitlement on OTE.

$50 super paid on time / $105 super entitlement = 52.38% OTE super entitlement not paid.

$4,000 SAW x 10.5% = $420 super entitlement on SAW.

$420 x 52.38% = $220 SGC shortfall.


Example 4:

Salary and Wages = $4,000.

OTE = $1,000.

Super paid on time, meeting choice obligations = $80

Shortfall calculated was $100.

Calculation:

$1,000 OTE x 10.5% = $105 super entitlement on OTE.

$80 super paid on time / $105 super entitlement = 23.81% OTE super entitlement not paid.

$4,000 SAW x 10.5% = $420 super entitlement on SAW.

$420 x 23.81% = $100 SGC shortfall.


Example 5:

Salary and Wages = $4,000.

OTE = $1,000.

Super paid on time, meeting choice obligations = $100

Shortfall calculated was $25.

Calculation:

$1,000 OTE x 10.5% = $105 super entitlement on OTE.

$100 super paid on time / $105 super entitlement = 4.76% OTE super entitlement not paid.

$4,000 SAW x 10.5% = $420 super entitlement on SAW.

$420 x 4.76% = $20 SGC shortfall.


Great work, Sammy.

All replies

Most helpful reply

sammywammy(Initiate)Initiate
9 Oct 2023

It seems the SGC shortfall payable is based on the percentage of the unpaid OTE super entitlement.


Example 1:

Salary and Wages = $4,000.

OTE = $1,000.

Super paid on time, meeting choice obligations = $0.

Shortfall calculated was $420.

Calculation:

$1,000 OTE x 10.5% = $105 super entitlement on OTE.

$0 super paid on time / $105 super entitlement = 100% OTE super entitlement not paid.

$4,000 SAW x 10.5% = $420 super entitlement on SAW.

$420 x 100% = $420 SGC shortfall.


Example 2:

Salary and Wages = $4,000.

OTE = $1,000.

Super paid on time, meeting choice obligations = $20

Shortfall calculated was $340.

Calculation:

$1,000 OTE x 10.5% = $105 super entitlement on OTE.

$20 super paid on time / $105 super entitlement = 80.95% OTE super entitlement not paid.

$4,000 SAW x 10.5% = $420 super entitlement on SAW.

$420 x 80.95% = $340 SGC shortfall.


Example 3:

Salary and Wages = $4,000.

OTE = $1,000.

Super paid on time, meeting choice obligations = $50

Shortfall calculated was $220.

Calculation:

$1,000 OTE x 10.5% = $105 super entitlement on OTE.

$50 super paid on time / $105 super entitlement = 52.38% OTE super entitlement not paid.

$4,000 SAW x 10.5% = $420 super entitlement on SAW.

$420 x 52.38% = $220 SGC shortfall.


Example 4:

Salary and Wages = $4,000.

OTE = $1,000.

Super paid on time, meeting choice obligations = $80

Shortfall calculated was $100.

Calculation:

$1,000 OTE x 10.5% = $105 super entitlement on OTE.

$80 super paid on time / $105 super entitlement = 23.81% OTE super entitlement not paid.

$4,000 SAW x 10.5% = $420 super entitlement on SAW.

$420 x 23.81% = $100 SGC shortfall.


Example 5:

Salary and Wages = $4,000.

OTE = $1,000.

Super paid on time, meeting choice obligations = $100

Shortfall calculated was $25.

Calculation:

$1,000 OTE x 10.5% = $105 super entitlement on OTE.

$100 super paid on time / $105 super entitlement = 4.76% OTE super entitlement not paid.

$4,000 SAW x 10.5% = $420 super entitlement on SAW.

$420 x 4.76% = $20 SGC shortfall.


Great work, Sammy.

Loading
Super Guarantee Charge (SGC) Calculation | ATO Community