|
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_2010.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-2010!
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.
- Summary of ALL tax tables (TaxTables_2010)
- coefficients for calculating PAYG withholding amounts (NAT 1004)
- statement of formulae for calculating HECS component (NAT 2335)
- statement of formulae for calculating SFSS component (NAT 3305)
- coefficients for calculating withholding amounts incorporating SFSS component and HECS component (NAT 3539)
- special tables for seasonally employed in the horticultural industry, including statement of formulae (NAT 1013)
- special tables for the shearing industry, including statement of formulae (NAT 1014)
- special tables for actors and other entertainers (NAT 1023)
- special tables for daily rate, including Medicare levy (NAT 1024), and
- special tables for Senior Australians (NAT 4466).
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 Example | Enter as below |
|---|
|
| 1 | No Declaration |
|---|
| Max-Earn | Coeff-A | Coeff-B |
|---|
| $98.00 | 0.1650 | $0.1650 |
| $894.00 | 0.3150 | $14.8765 |
| $1,509.00 | 0.4350 | $122.1842 |
| $9,999.00 | 0.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. |
| Code | 2010 Tax Tables Description |
|---|
| Code | Description |
|---|
| F4 | Foreign No Tax File No |
| H1 | HELP No Declaration |
| H2 | HELP Normal Tax Scale |
| H3 | HELP Non-Residents |
| H5 | HELP Medicare Levy Exempt |
| H6 | HELP Half Medicare Exempt |
| H7 | HELP No Leave Loading |
| N1 | No Declaration |
| N2 | Normal Tax Scale |
| N3 | Non-Residents |
| N4 | No Tax File No Given |
| N5 | Medicare Levy Exempt |
| N6 | Half Medicare Exempt |
| N7 | No Leave Loading |
| W1 | 33% Tax Estimate |
| W2 | No Tax at All |
| W3 | WEA: 19% Tutors |
| W4 | WEA: 24% Tutors |
Top
| F4 | Foreign No Tax File No |
|---|
| Max-Earn | Coeff-A | Coeff-B |
|---|
| $9,999.00 | 0.4500 | 0.0000 |
Top
| H1 | HELP No Declaration |
|---|
| Max-Earn | Coeff-A | Coeff-B |
|---|
| $259.00 | 0.1650 | 0.1650 |
| $394.00 | 0.2204 | 14.3827 |
| $546.00 | 0.3350 | 59.5615 |
| $644.00 | 0.3950 | 59.5615 |
| $743.00 | 0.4000 | 59.5615 |
| $798.00 | 0.4150 | 59.5615 |
| $882.00 | 0.4200 | 59.5615 |
| $980.00 | 0.4250 | 59.5615 |
| $982.00 | 0.4050 | 39.9462 |
| $1,050.00 | 0.4100 | 39.9462 |
| $1,187.00 | 0.4150 | 39.9462 |
| $1,221.00 | 0.4300 | 39.9462 |
| $1,286.00 | 0.5000 | 125.4269 |
| $3,144.00 | 0.5050 | 125.4269 |
| $9,999.00 | 0.5850 | 376.9654 |
Top
| H2 | HELP Normal Tax Scale |
|---|
| Max-Earn | Coeff-A | Coeff-B |
|---|
| $205.00 | 0.0000 | 0.0000 |
| $352.00 | 0.1513 | 31.1538 |
| $414.00 | 0.2522 | 66.7077 |
| $571.00 | 0.1664 | 31.1548 |
| $705.00 | 0.1866 | 42.6933 |
| $863.00 | 0.3350 | 147.3625 |
| $962.00 | 0.3950 | 147.3625 |
| $1,060.00 | 0.4000 | 147.3625 |
| $1,116.00 | 0.4150 | 147.3625 |
| $1,199.00 | 0.4200 | 147.3625 |
| $1,291.00 | 0.4250 | 147.3625 |
| $1,299.00 | 0.4050 | 121.5240 |
| $1,367.00 | 0.4100 | 121.5240 |
| $1,505.00 | 0.4150 | 121.5240 |
| $1,532.00 | 0.4300 | 121.5240 |
| $1,604.00 | 0.5000 | 228.7856 |
| $3,455.00 | 0.5050 | 228.7856 |
| $9,999.00 | 0.5850 | 505.2163 |
Top
| H3 | HELP Non-Residents |
|---|
| Max-Earn | Coeff-A | Coeff-B |
|---|
| $711.00 | 0.2900 | 0.2900 |
| $863.00 | 0.3000 | 7.1154 |
| $962.00 | 0.3600 | 7.1154 |
| $1,060.00 | 0.3650 | 7.1154 |
| $1,116.00 | 0.3800 | 7.1154 |
| $1,199.00 | 0.3850 | 7.1154 |
| $1,299.00 | 0.3900 | 7.1154 |
| $1,367.00 | 0.3950 | 7.1154 |
| $1,505.00 | 0.4000 | 7.1154 |
| $1,538.00 | 0.4150 | 7.1154 |
| $1,604.00 | 0.4850 | 114.8077 |
| $3,461.00 | 0.4900 | 114.8077 |
| $9,999.00 | 0.5700 | 391.7308 |
Top
| H5 | HELP Medicare Levy Exempt |
|---|
| Max-Earn | Coeff-A | Coeff-B |
|---|
| $205.00 | 0.0000 | 0.0000 |
| $571.00 | 0.1513 | 31.1538 |
| $705.00 | 0.1715 | 42.6923 |
| $863.00 | 0.3200 | 147.4538 |
| $962.00 | 0.3800 | 147.4538 |
| $1,060.00 | 0.3850 | 147.4538 |
| $1,116.00 | 0.4000 | 147.4538 |
| $1,199.00 | 0.4050 | 147.4538 |
| $1,291.00 | 0.4100 | 147.4538 |
| $1,299.00 | 0.3900 | 121.6154 |
| $1,367.00 | 0.3950 | 121.6154 |
| $1,505.00 | 0.4000 | 121.6154 |
| $1,532.00 | 0.4150 | 121.6154 |
| $1,604.00 | 0.4850 | 228.8769 |
| $3,455.00 | 0.4900 | 228.8769 |
| $9,999.00 | 0.5700 | 505.3077 |
Top
| H6 | HELP Half Medicare Exempt |
|---|
| Max-Earn | Coeff-A | Coeff-B |
|---|
| $205.00 | 0.0000 | 0.0000 |
| $571.00 | 0.1513 | 31.1538 |
| $594.00 | 0.1715 | 42.6923 |
| $699.00 | 0.2219 | 72.6885 |
| $705.00 | 0.1790 | 42.6925 |
| $863.00 | 0.3275 | 147.4078 |
| $962.00 | 0.3875 | 147.4078 |
| $1,060.00 | 0.3925 | 147.4078 |
| $1,116.00 | 0.4075 | 147.4078 |
| $1,199.00 | 0.4125 | 147.4078 |
| $1,291.00 | 0.4175 | 147.4078 |
| $1,299.00 | 0.3975 | 121.5694 |
| $1,367.00 | 0.4025 | 121.5694 |
| $1,505.00 | 0.4075 | 121.5694 |
| $1,532.00 | 0.4225 | 121.5694 |
| $1,604.00 | 0.4925 | 228.8309 |
| $3,455.00 | 0.4975 | 228.8309 |
| $9,999.00 | 0.5775 | 505.2617 |
Top
| H7 | HELP No Leave Loading |
|---|
| Max-Earn | Coeff-A | Coeff-B |
|---|
| $207.00 | 0.0000 | 0.0000 |
| $355.00 | 0.1500 | 31.1538 |
| $418.00 | 0.2500 | 66.7077 |
| $576.00 | 0.1650 | 31.1548 |
| $711.00 | 0.1850 | 42.6933 |
| $863.00 | 0.3350 | 149.4240 |
| $962.00 | 0.3950 | 149.4240 |
| $1,060.00 | 0.4000 | 149.4240 |
| $1,116.00 | 0.4150 | 149.4240 |
| $1,199.00 | 0.4200 | 149.4240 |
| $1,298.00 | 0.4250 | 149.4240 |
| $1,299.00 | 0.4050 | 123.4625 |
| $1,367.00 | 0.4100 | 123.4625 |
| $1,505.00 | 0.4150 | 123.4625 |
| $1,538.00 | 0.4300 | 123.4625 |
| $1,604.00 | 0.5000 | 231.1548 |
| $3,461.00 | 0.5050 | 231.1548 |
| $9,999.00 | 0.5850 | 508.0779 |
Top
| N1 | No Declaration |
|---|
| Max-Earn | Coeff-A | Coeff-B |
|---|
| $259.00 | 0.1650 | 0.1650 |
| $394.00 | 0.2204 | 14.3827 |
| $980.00 | 0.3350 | 59.5615 |
| $1,221.00 | 0.3150 | 39.9462 |
| $3,144.00 | 0.3850 | 125.4269 |
| $9,999.00 | 0.4650 | 376.9654 |
Top
| N2 | Normal Tax Scale |
|---|
| Max-Earn | Coeff-A | Coeff-B |
|---|
| $205.00 | 0.0000 | 0.0000 |
| $352.00 | 0.1513 | 31.1538 |
| $414.00 | 0.2522 | 66.7077 |
| $571.00 | 0.1664 | 31.1548 |
| $705.00 | 0.1866 | 42.6933 |
| $1,291.00 | 0.3350 | 147.3625 |
| $1,532.00 | 0.3150 | 121.5240 |
| $3,455.00 | 0.3850 | 228.7856 |
| $9,999.00 | 0.4650 | 505.2163 |
Top
| N3 | Non-Residents |
|---|
| Max-Earn | Coeff-A | Coeff-B |
|---|
| $711.00 | 0.2900 | 0.2900 |
| $1,538.00 | 0.3000 | 7.1154 |
| $3,461.00 | 0.3700 | 114.8077 |
| $9,999.00 | 0.4500 | 391.7308 |
Top
| N4 | No Tax File No Given |
|---|
| Max-Earn | Coeff-A | Coeff-B |
|---|
| $9,999.00 | 0.4650 | 0.0000 |
Top
| N5 | Medicare Levy Exempt |
|---|
| Max-Earn | Coeff-A | Coeff-B |
|---|
| $99.00 | 0.0000 | 0.0000 |
| $205.00 | 0.0000 | 0.0000 |
| $571.00 | 0.1513 | 31.1538 |
| $705.00 | 0.1715 | 42.6923 |
| $1,291.00 | 0.3200 | 147.4538 |
| $1,532.00 | 0.3000 | 121.6154 |
| $3,455.00 | 0.3700 | 228.8769 |
| $9,999.00 | 0.4500 | 505.3077 |
Top
| N6 | Half Medicare Exempt |
|---|
| Max-Earn | Coeff-A | Coeff-B |
|---|
| $99.00 | 0.0000 | 0.0000 |
| $205.00 | 0.0000 | 0.0000 |
| $571.00 | 0.1513 | 31.1538 |
| $594.00 | 0.1715 | 42.6923 |
| $699.00 | 0.2219 | 72.6885 |
| $705.00 | 0.1790 | 42.6925 |
| $1,291.00 | 0.3275 | 147.4078 |
| $1,532.00 | 0.3075 | 121.5694 |
| $3,455.00 | 0.3775 | 228.8309 |
| $9,999.00 | 0.4575 | 505.2617 |
Top
| N7 | No Leave Loading |
|---|
| Max-Earn | Coeff-A | Coeff-B |
|---|
| $99.00 | 0.0000 | 0.0000 |
| $207.00 | 0.0000 | 0.0000 |
| $355.00 | 0.1500 | 31.1538 |
| $418.00 | 0.2500 | 66.7077 |
| $576.00 | 0.1650 | 31.1548 |
| $711.00 | 0.1850 | 42.6933 |
| $1,298.00 | 0.3350 | 149.4240 |
| $1,538.00 | 0.3150 | 123.4625 |
| $3,461.00 | 0.3850 | 231.1548 |
| $9,999.00 | 0.4650 | 508.0779 |
Top
| W1 | 33% Tax Estimate |
|---|
| Max-Earn | Coeff-A | Coeff-B |
|---|
| $9,999.00 | 0.3333 | 0.0000 |
Top
| W2 | No Tax at All |
|---|
| Max-Earn | Coeff-A | Coeff-B |
|---|
| $9,999.00 | 0.0000 | 0.0000 |
Top
| W3 | WEA: 19% Tutors |
|---|
| Max-Earn | Coeff-A | Coeff-B |
|---|
| $9,999.00 | 0.1900 | 9.0000 |
Top
| W4 | WEA: 24% Tutors |
|---|
| Max-Earn | Coeff-A | Coeff-B |
|---|
| $9,999.00 | 0.2400 | 0.0000 |
|