IPAddr

To update the Group Tax Tables in The Payroll Wizard (windows version) you need to go to the EDIT menu then OTHER files then TAX TABLES. Select the table that you want to change from the drop down combo box. Enter the table details from the relevant table shown below. Note that generally it is easier to delete the whole table and add the new table in if any of the Max Earn amounts have changed from prior tables.

In the Download page of our web site you can download a CSV format copy of the tax tables that you can import into our Windows Payroll System Databases. If you have more than one database then you need to import it into ALL copies of your databases. You access the file by double clicking on the taxtable_2012.exe file which will self install.

To import the downloaded tax tables first install it to your C:\Payroll folder and then go to the IMPORT/EXPORT DATA on the DATABASE menu. Choose to IMPORT (ADD NEW RECORDS) for data file name GROUP TAX TABLES and make sure that the ERASE EXISTING DATA BEFORE IMPORT box is TICKED. Enter GRTATABL.CSV as the name of the file to import.

Before you import the tax tables make sure that you haven't defined your tax table codes differently to those on your list. If you have then you may have to change the tax scale on some employees master files.

Also, to import these tax tables you MUST have installed a payroll program update dated on or after 01-Jul-2011!

You can check which employees are on which tax scale by going to the HTML QUERIES option on the DATABASE menu and double clicking on the report for EMPLOYEES BY TAX SCALE. If you don't have this option then you'll need to download and install a payroll program update.

Also make sure that the descriptions for each tax scale match the descriptions on this list.

Note that to find these tax tables on the ATO web site (www.ato.gov.au you will need to go to that site and type in one of the following numbers into the SEARCH box. Note that you type ONLY the number (eg 1004, 2335, 3305, 3539 etc) and not the NAT as well. For your convenience we have also included a link to the two documents available from the ATO Web Site which we have stored locally on our own web site. However you SHOULD check the ATO web site to see if they have a later copy. We've put them on our web site because they can be hard to find on the ATO web site.


If we haven't put the latest tax tables up on this web site and you need the information urgently - you can do it yourself. Just go to the ATO web site (See the links above) and download their PDF files showing the calculation formulae. Note that you don't want the tax TABLES you want the statement of formulae. Then go into the Payroll program and click on the EDIT menu and then OTHER MASTER FILES and then TAX TABLES and enter the information as per the example below.

ATO Tax Table ExampleEnter as below
1No Declaration
Max-EarnCoeff-ACoeff-B
$980.1650$0.1650
$8940.3150$14.8765
$1,5090.4350$122.1842
$9,9990.4850$197.7750
Note that you enter the last entry in each table (eg 1509 and over) as $9,9999
If you have anyone who earns more than $9,999 per week the system will still calculate their tax correctly.

CodeDescription
B1HELP/SFSS No Declaration
B2HELP/SFSS Normal Tax Scale
B3HELP/SFSS Non-Residents
B5HELP/SFSS Medicare Levy Exempt
B6HELP/SFSS Half Medicare Exempt
C2Casual/Daily Normal Tax Scale
H1HELP No Declaration
H2HELP Normal Tax Scale
H3HELP Non-Residents
H5HELP Medicare Levy Exempt
H6HELP Half Medicare Exempt
N1No Declaration
N2Normal Tax Scale
N3Non-Residents
N4No Tax File No Given
N5Medicare Levy Exempt
N6Half Medicare Exempt
N7No Leave Loading
S1SFSS No Declaration
S2SFSS Normal Tax Scale
S3SFSS Non-Residents
S5SFSS Medicare Levy Exempt
S6SFSS Half Medicare Exempt
W133% Tax Estimate
W2No Tax at All
W3WEA: 19% Tutors
W4WEA: 24% Tutors

Top
B1HELP/SFSS No Declaration
Max-EarnCoeff-ACoeff-B
$45.000.19000.1900
$361.000.22161.4232
$594.000.342745.2055
$701.000.402745.2055
$809.000.407745.2055
$870.000.422745.2055
$932.000.427745.2055
$961.000.425042.6890
$1,070.000.430042.6890
$1,145.000.435042.6890
$1,188.000.440042.6890
$1,295.000.485096.1698
$1,403.000.500096.1698
$3,111.000.505096.1698
$9,999.000.5850345.0928

Top
B2HELP/SFSS Normal Tax Scale
Max-EarnCoeff-ACoeff-B
$355.000.00000.0000
$395.000.190067.4635
$464.000.2900106.9673
$711.000.205067.4636
$944.000.3427165.4424
$1,051.000.4027165.4424
$1,159.000.4077165.4424
$1,220.000.4227165.4424
$1,282.000.4277165.4424
$1,311.000.4250161.9809
$1,420.000.4300161.9809
$1,495.000.4350161.9809
$1,538.000.4400161.9809
$1,645.000.4850231.2116
$1,753.000.5000231.2116
$3,461.000.5050231.2116
$9,999.000.5850508.1347

Top
B3HELP/SFSS Non-Residents
Max-EarnCoeff-ACoeff-B
$944.000.32500.3250
$1,051.000.38500.3250
$1,159.000.39000.3250
$1,220.000.40500.3250
$1,311.000.41000.3250
$1,420.000.41500.3250
$1,495.000.42000.3250
$1,538.000.42500.3250
$1,645.000.470069.2308
$1,753.000.485069.2308
$3,461.000.490069.2308
$9,999.000.5700346.1538

Top
B5HELP/SFSS Medicare Levy Exempt
Max-EarnCoeff-ACoeff-B
$355.000.00000.0000
$711.000.190067.4635
$944.000.3277165.4423
$1,051.000.3877165.4423
$1,159.000.3927165.4423
$1,220.000.4077165.4423
$1,282.000.4127165.4423
$1,311.000.4100161.9808
$1,420.000.4150161.9808
$1,495.000.4200161.9808
$1,538.000.4250161.9808
$1,645.000.4700231.2115
$1,753.000.4850231.2115
$3,461.000.4900231.2115
$9,999.000.5700508.1346

Top
B6HELP/SFSS Half Medicare Exempt
Max-EarnCoeff-ACoeff-B
$355.000.00000.0000
$629.000.190067.4635
$711.000.240098.9471
$740.000.3777196.9260
$944.000.3352165.4425
$1,051.000.3952165.4425
$1,159.000.4002165.4425
$1,220.000.4152165.4425
$1,282.000.4202165.4425
$1,311.000.4175161.9809
$1,420.000.4225161.9809
$1,495.000.4275161.9809
$1,538.000.4325161.9809
$1,645.000.4775231.2117
$1,753.000.4925231.2117
$3,461.000.4975231.2117
$9,999.000.5775508.1348

Top
C2Casual/Daily Normal Tax Scale
Max-EarnCoeff-ACoeff-B
$355.000.00000.0000
$395.000.190067.4635
$464.000.2900106.9673
$711.000.205067.4636
$1,282.000.3427165.4424
$1,538.000.3400161.9809
$3,461.000.3850231.2116
$9,999.000.4650508.1347

Top
H1HELP No Declaration
Max-EarnCoeff-ACoeff-B
$45.000.19000.1900
$361.000.22161.4232
$594.000.342745.2055
$701.000.382745.2055
$809.000.387745.2055
$870.000.392745.2055
$932.000.397745.2055
$961.000.395042.6890
$1,070.000.400042.6890
$1,145.000.405042.6890
$1,188.000.410042.6890
$1,295.000.455096.1698
$1,403.000.460096.1698
$3,111.000.465096.1698
$9,999.000.5450345.0928

Top
H2HELP Normal Tax Scale
Max-EarnCoeff-ACoeff-B
$355.000.00000.0000
$395.000.190067.4635
$464.000.2900106.9673
$711.000.205067.4636
$944.000.3427165.4424
$1,051.000.3827165.4424
$1,159.000.3877165.4424
$1,220.000.3927165.4424
$1,282.000.3977165.4424
$1,311.000.3950161.9809
$1,420.000.4000161.9809
$1,495.000.4050161.9809
$1,538.000.4100161.9809
$1,645.000.4550231.2116
$1,753.000.4600231.2116
$3,461.000.4650231.2116
$9,999.000.5450508.1347

Top
H3HELP Non-Residents
Max-EarnCoeff-ACoeff-B
$944.000.32500.3250
$1,051.000.36500.3250
$1,159.000.37000.3250
$1,220.000.37500.3250
$1,311.000.38000.3250
$1,420.000.38500.3250
$1,495.000.39000.3250
$1,538.000.39500.3250
$1,645.000.440069.2308
$1,753.000.445069.2308
$3,461.000.450069.2308
$9,999.000.5300346.1538

Top
H5HELP Medicare Levy Exempt
Max-EarnCoeff-ACoeff-B
$355.000.00000.0000
$711.000.190067.4635
$944.000.3277165.4423
$1,051.000.3677165.4423
$1,159.000.3727165.4423
$1,220.000.3777165.4423
$1,282.000.3827165.4423
$1,311.000.3800161.9808
$1,420.000.3850161.9808
$1,495.000.3900161.9808
$1,538.000.3950161.9808
$1,645.000.4400231.2115
$1,753.000.4450231.2115
$3,461.000.4500231.2115
$9,999.000.5300508.1346

Top
H6HELP Half Medicare Exempt
Max-EarnCoeff-ACoeff-B
$355.000.00000.0000
$629.000.190067.4635
$711.000.240098.9471
$740.000.3777196.9260
$944.000.3352165.4425
$1,051.000.3752165.4425
$1,159.000.3802165.4425
$1,220.000.3852165.4425
$1,282.000.3902165.4425
$1,311.000.3875161.9809
$1,420.000.3925161.9809
$1,495.000.3975161.9809
$1,538.000.4025161.9809
$1,645.000.4475231.2117
$1,753.000.4525231.2117
$3,461.000.4575231.2117
$9,999.000.5375508.1348

Top
N1No Declaration
Max-EarnCoeff-ACoeff-B
$45.000.19000.1900
$361.000.22161.4232
$932.000.342745.2055
$1,188.000.340042.6890
$3,111.000.385096.1698
$9,999.000.4650345.0928

Top
N2Normal Tax Scale
Max-EarnCoeff-ACoeff-B
$355.000.00000.0000
$395.000.190067.4635
$464.000.2900106.9673
$711.000.205067.4636
$1,282.000.3427165.4424
$1,538.000.3400161.9809
$3,461.000.3850231.2116
$9,999.000.4650508.1347

Top
N3Non-Residents
Max-EarnCoeff-ACoeff-B
$1,538.000.32500.3250
$3,461.000.370069.2308
$9,999.000.4500346.1538

Top
N4No Tax File No Given
Max-EarnCoeff-ACoeff-B
$9,999.000.46500.0000

Top
N5Medicare Levy Exempt
Max-EarnCoeff-ACoeff-B
$355.000.00000.0000
$711.000.190067.4635
$1,282.000.3277165.4423
$1,538.000.3250161.9808
$3,461.000.3700231.2115
$9,999.000.4500508.1346

Top
N6Half Medicare Exempt
Max-EarnCoeff-ACoeff-B
$355.000.00000.0000
$629.000.190067.4635
$711.000.240098.9471
$740.000.3777196.9260
$1,282.000.3352165.4425
$1,538.000.3325161.9809
$3,461.000.3775231.2117
$9,999.000.4575508.1348

Top
N7No Leave Loading
Max-EarnCoeff-ACoeff-B
$9,999.000.45000.0000

Top
S1SFSS No Declaration
Max-EarnCoeff-ACoeff-B
$45.000.19000.1900
$361.000.22161.4232
$594.000.342745.2055
$809.000.362745.2055
$932.000.372745.2055
$1,188.000.370042.6890
$1,295.000.415096.1698
$3,111.000.425096.1698
$9,999.000.5050345.0928

Top
S2SFSS Normal Tax Scale
Max-EarnCoeff-ACoeff-B
$355.000.00000.0000
$395.000.190067.4635
$464.000.2900106.9673
$711.000.205067.4636
$944.000.3427165.4424
$1,159.000.3627165.4424
$1,282.000.3727165.4424
$1,538.000.3700161.9809
$1,645.000.4150231.2116
$3,461.000.4250231.2116
$9,999.000.5050508.1347

Top
S3SFSS Non-Residents
Max-EarnCoeff-ACoeff-B
$944.000.32500.3250
$1,159.000.34500.3250
$1,538.000.35500.3250
$1,645.000.400069.2308
$3,461.000.410069.2308
$9,999.000.4900346.1538

Top
S5SFSS Medicare Levy Exempt
Max-EarnCoeff-ACoeff-B
$355.000.00000.0000
$711.000.190067.4635
$944.000.3277165.4423
$1,159.000.3477165.4423
$1,282.000.3577165.4423
$1,538.000.3550161.9808
$1,645.000.4000231.2115
$3,461.000.4100231.2115
$9,999.000.4900508.1346

Top
S6SFSS Half Medicare Exempt
Max-EarnCoeff-ACoeff-B
$355.000.00000.0000
$629.000.190067.4635
$711.000.240098.9471
$740.000.3777196.9260
$944.000.3352165.4425
$1,159.000.3552165.4425
$1,282.000.3652165.4425
$1,538.000.3625161.9809
$1,645.000.4075231.2117
$3,461.000.4175231.2117
$9,999.000.4975508.1348

Top
W133% Tax Estimate
Max-EarnCoeff-ACoeff-B
$9,999.000.33330.0000

Top
W2No Tax at All
Max-EarnCoeff-ACoeff-B
$9,999.000.00000.0000

Top
W3WEA: 19% Tutors
Max-EarnCoeff-ACoeff-B
$9,999.000.19000.0000

Top
W4WEA: 24% Tutors
Max-EarnCoeff-ACoeff-B
$9,999.000.24000.0000