Spreadsheet: 669910d1585666362-payrol-time-help-v2-payslip
Sheet: NAT1005 Lookup

QUICK SEARCH: Enter weekly earnings in the green cell (A5) to display the amount to withhold With tax-free threshold and No tax-free threshold in the yellow fields (B5 and C5).
Weekly earnings 1 $ | With tax-free threshold 2 $ | No tax-free threshold 3 $
LOOKUP TABLES |  |  |  | LOOKUP TABLES |  |  |  | LOOKUP TABLES
SCALE 1 |  |  |  | SCALE 5 |  |  |  | SCALE 8 |  | Single
$ | a | b |  | $ | a | b |  | $ | a | b
0 | 0.19 | 0.19 |  | 0 | 0 | 0 |  | 0 | 0 | 0
72 | 0.2342 | 3.213 |  | 355 | 0.19 | 67.4635 |  | 580 | 0.19 | 110.3481
361 | 0.3477 | 44.2476 |  | 711 | 0.3277 | 165.4423 |  | 620 | 0.315 | 187.9418
932 | 0.345 | 41.7311 |  | 1282 | 0.325 | 161.9808 |  | 668 | 0.415 | 254.7841
1380 | 0.39 | 103.8657 |  | 1730 | 0.37 | 239.8654 |  | 711 | 0.5527 | 352.763
3111 | 0.47 | 352.7888 |  | 3461 | 0.45 | 516.7885 |  | 835 | 0.4727 | 285.9214
 |  |  |  |  |  |  |  | 963 | 0.3477 | 165.4431
 |  |  |  |  |  |  |  | 1282 | 0.345 | 161.9808
 |  |  |  |  |  |  |  | 1730 | 0.39 | 239.8654
 |  |  |  |  |  |  |  | 3461 | 0.47 | 516.7885
LOOKUP TABLES |  |  |  | LOOKUP TABLES |  |  |  | LOOKUP TABLES
SCALE 2 |  |  |  | SCALE 6 |  |  |  | SCALE 9 |  | Illness
$ | a | b |  | $ | a | b |  | $ | a | b
0 | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 0 | 0
355 | 0.19 | 67.4635 |  | 355 | 0.19 | 67.4635 |  | 561 | 0.19 | 106.6942
422 | 0.29 | 109.7327 |  | 711 | 0.3277 | 165.4423 |  | 601 | 0.315 | 181.8841
528 | 0.21 | 67.4635 |  | 713 | 0.3777 | 201.1048 |  | 668 | 0.415 | 248.7264
711 | 0.3477 | 165.4423 |  | 891 | 0.3377 | 165.4425 |  | 711 | 0.5527 | 346.7053
1282 | 0.345 | 161.9808 |  | 1282 | 0.335 | 161.981 |  | 835 | 0.4727 | 279.8638
1730 | 0.39 | 239.8654 |  | 1730 | 0.38 | 239.8656 |  | 915 | 0.3477 | 165.4431
3461 | 0.47 | 516.7885 |  | 3461 | 0.46 | 516.7887 |  | 1282 | 0.345 | 161.9808
 |  |  |  |  |  |  |  | 1730 | 0.39 | 239.8654
 |  |  |  |  |  |  |  | 3461 | 0.47 | 516.7885
LOOKUP TABLES |  |  |  |  |  |  |  | LOOKUP TABLES |  |  |  | LOOKUP TABLES
SCALE 3 |  |  |  |  |  |  |  | SCALE 10 |  | Couple |  | SCALE Actors |  | Actors
$ | a | b |  |  |  |  |  | $ | a | b |  | $ | a | b
0 | 0.325 | 0.325 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0
1730 | 0.37 | 77.8846 |  |  |  |  |  | 517 | 0.19 | 98.2712 |  | 443 | 0.152 | 67.4635
3461 | 0.45 | 354.8077 |  |  |  |  |  | 557 | 0.315 | 167.9202 |  | 528 | 0.232 | 109.7327
 |  |  |  |  |  |  |  | 668 | 0.415 | 234.7625 |  | 660 | 0.168 | 67.4635
 |  |  |  |  |  |  |  | 711 | 0.5527 | 332.7413 |  | 889 | 0.2782 | 165.4423
 |  |  |  |  |  |  |  | 803 | 0.4277 | 232.2846 |  | 1602 | 0.276 | 161.9808
 |  |  |  |  |  |  |  | 835 | 0.3477 | 165.4431 |  | 2163 | 0.312 | 239.8654
 |  |  |  |  |  |  |  | 1282 | 0.345 | 161.9808 |  | 4326 | 0.376 | 516.7885
 |  |  |  |  |  |  |  | 1730 | 0.39 | 239.8654
 |  |  |  |  |  |  |  | 3461 | 0.47 | 516.7885
ML Adjustment S2 |  |  |  |  | ML Adjustment S6
Weekly earnings threshold |  |  | 422 |  | Weekly earnings threshold |  |  | 713
Weekly earnings shade-in threshold |  |  | 528 |  | Weekly earnings shade-in threshold |  |  | 891
Medicare levy family threshold |  |  | 37089 |  | Medicare levy family threshold |  |  | 37089
Weekly [NAME] divisor |  |  | 52 |  | Weekly [NAME] divisor |  |  | 52
Additional child |  |  | 3406 |  | Additional child |  |  | 3406
Shading Out Point multiplier |  |  | 0.1 |  | Shading Out Point multiplier |  |  | 0.05
Shading Out Point divisor |  |  | 0.08 |  | Shading Out Point divisor |  |  | 0.04
Weekly Levy Adjustment factor |  |  | 422.69 |  | Weekly Levy Adjustment factor |  |  | 713.25
Medicare levy |  |  | 0.02 |  | Medicare levy |  |  | 0.01
Number of Children |  | Threshold | Reduction |  | Number of Children |  | Threshold | Reduction
0 |  | 891 | 713.25 |  | 0 |  | 891 | 713.25
1 |  | 973 | 778.75 |  | 1 |  | 973 | 778.75
2 |  | 1055 | 844.25 |  | 2 |  | 1055 | 844.25
3 |  | 1137 | 909.75 |  | 3 |  | 1137 | 909.75
4 |  | 1219 | 975.25 |  | 4 |  | 1219 | 975.25
5 |  | 1300 | 1040.75 |  | 5 |  | 1300 | 1040.75
6 |  | 1382 | 1106.25 |  | 6 |  | 1382 | 1106.25
7 |  | 1464 | 1171.75 |  | 7 |  | 1464 | 1171.75
8 |  | 1546 | 1237.25 |  | 8 |  | 1546 | 1237.25
9 |  | 1628 | 1302.75 |  | 9 |  | 1628 | 1302.75
10 |  | 1710 | 1368.25 |  | 10 |  | 1710 | 1368.25
Additional |  | 82 | 65.5 |  | Additional |  | 82 | 65.5
[NAME] |  |  |  | [NAME] |  |  |  | SCALE FS TFTR |  |  |  | SCALE FS NTFT
$ | a | b |  | $ | a | b |  | $ | a | b |  | $ | a | b
0 | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 0 | 0
865 | 0.01 | 0 |  | 515 | 0.01 | 0 |  | 1110 | 0.02 | 0 |  | 760 | 0.02 | 0
999 | 0.02 | 0 |  | 649 | 0.02 | 0 |  | 1363 | 0.03 | 0 |  | 1013 | 0.03 | 0
1059 | 0.025 | 0 |  | 709 | 0.025 | 0 |  | 1934 | 0.04 | 0 |  | 1584 | 0.04 | 0
1122 | 0.03 | 0 |  | 772 | 0.03 | 0
1190 | 0.035 | 0 |  | 840 | 0.035 | 0
1261 | 0.04 | 0 |  | 911 | 0.04 | 0
1337 | 0.045 | 0 |  | 987 | 0.045 | 0
1417 | 0.05 | 0 |  | 1067 | 0.05 | 0
1502 | 0.055 | 0 |  | 1152 | 0.055 | 0
1592 | 0.06 | 0 |  | 1242 | 0.06 | 0
1688 | 0.065 | 0 |  | 1338 | 0.065 | 0
1789 | 0.07 | 0 |  | 1439 | 0.07 | 0
1896 | 0.075 | 0 |  | 1546 | 0.075 | 0
2010 | 0.08 | 0 |  | 1660 | 0.08 | 0
2131 | 0.085 | 0 |  | 1781 | 0.085 | 0
2259 | 0.09 | 0 |  | 1909 | 0.09 | 0
2394 | 0.095 | 0 |  | 2044 | 0.095 | 0
2538 | 0.1 | 0 |  | 2188 | 0.1 | 0
SCALE NTFN |  |  |  | SCALE TFN
$ | a | b |  | $ | a | b
Resident | 0.47 | 0 |  | Resident | 0.13 | 0
Foreign resident | 0.45 | 0 |  | Foreign resident | 0.325 | 0