ODOO AUSTRALIAN PAYROLL

by
Odoo          
v 12.0 Third Party

555.00 €

This module requires Odoo Enterprise Edition.
You bought this module and need support ? Click here !
Technical name australian_payroll
Websitehttp://www.planet-odoo.com/
Read description for v 11.0 v 10.0
Required Apps Project (project)
Invoicing (account)
Task Logs (hr_timesheet)
Employees (hr)
Leaves (hr_holidays)
Timesheets (timesheet_grid)
Technical name australian_payroll
Websitehttp://www.planet-odoo.com/
Read description for v 11.0 v 10.0
Required Apps Project (project)
Invoicing (account)
Task Logs (hr_timesheet)
Employees (hr)
Leaves (hr_holidays)
Timesheets (timesheet_grid)

ODOO AUSTRALIAN PAYROLL

We are also giving one time free set up of ODOO AUSTRALIAN PAYROLL on your Server when you purchase this module.

This is the customization done in AUSTRALIAN PAYROLL

All these new classes have been created
Superannuation

This class will hold the list of bank or forums who deal in Super Annuation.

Payroll > Superannuation > Superannuation


Superannuation Approve

It will create a record on confirmation of payslip.

Payroll > Superannuation > Superannuation Approve


Holiday

Holiday class will have the record of the public holiday.

Leaves > Holidays


Payslip Period

This use to define the period of payslip.

Payroll > Payslip Periods > Payslip Periods


For more information about employee extra fields added in Employee form .

Superannuation Details

Emergency Contact Details

Tax-related Information

Residency Type

Employee Basis

Shift Worker

NOTE: On basis of 'Employee Basis' and 'Shift Worker' you can create multiple types of Employee.

Super Annuation Details

Check Super Annuation Fund to create Super Annuation in payslip. And other fields will store the percentage of Super Annuation and details of Super Annuation.

NOTE: Super Annuation won't apply if basic salary is less than 450.

Emergency Contact Details

One of family member details also there in case of emergency .

Tax related information

Tax file no of employee

Residency Type

Residency type if employee outside of australia or from different state.

Employee Basis

In employee basis we will select what kind of employee is he full time,part time ,casual employee.

Shift Worker

Shift worker is a check box it show if employee is a shift worker or not .

Contract Form

Note : Based on Timesheet Based Payroll checkbox it is differentiate and show different fields And it will show different salary structure.

If False

Scheduled wage - wage of month , fortnightly or weekly and

If Timesheet Based Payroll is True

Wage per hour : in this field will provide wage of 1 hour.

NOTE: Added Timesheet based structure checkbox in salary structure it will affect in contract if in contract timesheet based payroll is true domain will apply on salary structure field

Timesheet Form

Scheduled Pay :select scheduled pay for employee

2 Checkbox are added Work Through Meal Break and Public Holiday

Meal allowance :It will be calculated based on how many "Work Through Meal Break" checkbox are checked in timesheet these meal break will add in payslip if at list one check box is selected

NOTE: For Timesheet based employee when ever timesheet confirm it will allocate annual leave based on timesheet hours except casual employee. For annual leave will provide in hours and calculation for hours is like this If hours are more than 7:36 it will take only 7:36 hours from every line of all the hours and multiply by 0.07692307692. E.g. : working hours = 5 5 * 0.07692307692 = 0.3846 Annual leave hours = 0.3846

Payslip Form :

It is a timesheet based employee it check period if any timesheet is there for that particular period it will it show in payslip hours populated . Salary adjustment checkbox it will show fields amount, add and subtract and it will also create other line of salary adjustment

NOTE: for ordinary/afternoon/night shift if it is more then 7:36 it will show only 7:36 hour in respective field and next 2 hours in overtime field and remaining in double hours.

If employee is fixed employee annual leave allocate on confirmation of payslip. Superannuation record also create on payslip confirmation.

Payslip batch form :

Pay calendar also added in payslip batch if you select pay calendar it will also populate name for batch.

1)for full time work type employee whose pay period is bi-weekely or fortnightly and wages are fixed

Payslip No.

SLIP/970













Employee Name

Phoenix Huang













Period

2018-03-26 - 2018-04-08













Wage

1,759.62






Scheduled Hours

76






Hour wage calculation

wage(1759.62) / scheduled hours (76) = 23.15289474






Scheduled Pay

bi-weekly (fortnight)






Payslip computation







Salary rule

Quantity

Amount

Rate

Total

Calculation


Basic Salary

57

23.15289474

100

1,319.72

57 * 23.15289474 = 1319.72


Payroll Total Tax Month

1

250.3894081

100

250.3894081

total salary(1668.17) * 26 = annual wage(43372.44782) , Medi care = annual wage * 2 /100 = 867.4484







annual wage(43372.42 ) - 37001 = 6371.42 ,







annual tax = (6371.42*32.5/100) + medi care (867.4484) + 3572 = 6510.1599 /26 = 250.390765385


Super Annuation Fund Monthly

1

125.372925

100

125.372925

1319.72*9.5% = 125.372925


Used Annual Leave

6

23.15289474

117.5

163.22791

6*23.15289474 *117.5/100 = 163.22791


Accured Leave

71

0.0769230769

100

5.46154

quantity = scheduled hours (76) - Unpaid leave (5) = 71 * 0.0769230769 = 5.46154


Unpaid Leave

5

1

100

5



Used Sick Leave

8

23.15289474

100

185.22316

8 * 23.15289474 = 185.


Total Salary

1

1,668.17

100

1,668.17

basic salary(1319.72) + used annual leave (163.22791) + used sick (185.22316) = 1668.17


Net

1

1,417.78

100

1,417.78

Total salary (1668.17) - Payroll TAx(250.38940841) = 1417.78


2)Payslip for full time work type employee whose pay period is monthly and wages are fixed

Wage

1,759.62





Scheduled Hours

152





Hour wage calculation

wage(3519.24) / scheduled hours (152) = 23.15289474





Scheduled Pay

monthly





Payslip computation






Salary rule

Quantity

Amount

Rate

Total

Calculation

Basic Salary

127

23.15289474

100

2,940.42

127 * 23.15289474 = 2,940.41763

Payroll Total Tax Month

1

436.80584

100

436.80584

total salary(3,307.97) * 12 = annual wage(39695.64) , Medi care = annual wage(39695.64) * 2 /100 = 793.9128






annual wage(39695.64 ) − 37001 = 2694.64 ,






annual tax = (2694.64 *32.5/100) + medi care (793.9128) + 3572 = 5241.6708 /12 = 436.80584

Super Annuation Fund Monthly

1

279.33968

100

279.33968

2940.42×9.5% = 279.33968

Used Annual Leave

5

23.15289474

117.5

136.02326

5*23.15289474 *117.5/100 = 136.02326

Accured Leave

142

0.0769230769

100

10.92308

quantity = scheduled hours (152) - Unpaid leave (10) = 142 * 0.0769230769 = 10.92308

Unpaid Leave

10

1

100

10


Used Sick Leave

10

23.15289474

100

231.52895

10 * 23.15289474 = 231.52895

Total Salary

1

3,307.97

100

3,307.97

basic salary(2940.41763) + used annual leave (136.02326) + used sick (231.52895) = 3307.97

Net

1

2,871.16

100

2,871.16

Total salary (3307.97) - Payroll TAx(436.80584) = 2871.16

3)Payslip for full time work type employee whose pay period is fortnightly, wages based on timesheet and works on ordinary hours

Payslip No.

SLIP/974











Employee Name

Full Time O. H Fortnightly











Timesheet Period

2018-03-26 - 2018-04-08











Ordinary Hours

38:00:00





Over Time Hours

10:00





Double Hours

10:00











Payslip computation






Salary rule

Quantity

Amount

Rate

Total

Calculation

Ordinary Pay

38

10

100

380

38*10*100/100 = 380

Overtime Pay

10

10

150

150

10*10*150/100 = 150

Double Pay

10

10

200

200

10*10*200/100 = 200

Meal Allowance

2

13.96

100

27.92

2*13.96*100/100 = 27.92000

Ordinary Meal Break Pay

2

7.5

100

15

2*7.5*100/100 = 15

Payroll Total Tax


56.71089231


56.71089231

Medicare tax ((2*(903.42*26)/100) + (19*((903.42*26) - 18201)/100))/26 = 56.17

Used Annual Leave

6

10

117.5

70.5

6*10*117.5/100 = 70.5

Unpaid Leave

6

1

100

6


Used Sick Leave

6

10

100

60

6*10*100/100 = 60

Accured Leave

5.38



5.38

timesheet ordinary hours (76) - unpaid leave (6) = 70 * 0.07692307692 = 5.38

Total Basic


903.42


903.42

380 + 150 + 200 + 27.92 + 70.5 + 60 + 15 = 903.42

Net Income


846.70911


846.70911

903.42 - 56.17 = 846.70911

4)Payslip for Part Time work type employee whose pay period is fortnightly, wages based on timesheet and works on ordinary hours

Payslip No.

SLIP/975











Employee Name

Part Time O. H Fortnightly











Timesheet Period

2018-03-26 - 2018-04-08











Ordinary Hours

45:36:00





Over Time Hours

12:00





Double Hours

12:00











Payslip computation






Salary rule

Quantity

Amount

Rate

Total

Calculation

Ordinary Pay

45.6

10

100

456

45.6*10*100/100 = 456

Overtime Pay

12

10

150

180

12*10*150/100 = 180

Double Pay

12

10

200

240

12*10*200/100 = 240

Meal Allowance

3

13.96

100

41.88

3*13.96*100/100 = 41.88

Ordinary Meal Break Pay

3

7.5

100

22.5

3*7.5*100/100 = 22.5

Payroll Total Tax


92.24499


92.24499

Medicare tax ((2*(1,072.63*26)/100) + (19*((1,072.63*26) - 18201)/100))/26 = 92.24499

Super Annuation Fund


43.32


43.32

ordinary pay (456) * 9.5 /100 = 43.32

Used Annual Leave

7

10

117.5

82.25

7*10*117.5/100 = 82.25

Unpaid Leave

7

1

100

7


Used Sick Leave

5

10

100

50

5*10*100/100 = 50

Accured Leave

2.97



2.97

timesheet ordinary hours (45.6) - unpaid leave (7) = 38.6 * 0.07692307692 = 2.97

Total Basic


1,072.63


1,072.63

456 + 180 + 240 +41.88 + 22.5 +82.25 +50 = 1072.63

Net Income


980.38501


980.38501

1072.63 - 92.44 = 980.38501

5)Payslip for casually work type employee whose pay period is fortnightly, wages based on timesheet and works on ordinary hours

Payslip No.

SLIP/976











Pay Type

Casual O. H Fortnightly











Timesheet Period

2018-03-26 - 2018-04-08











Ordinary Hours

38





Over Time Hours

10





Double Hours

10











Payslip computation






Salary rule

Quantity

Amount

Rate

Total

Calculation

Ordinary Pay

38

10

125

475

38 * 10 *125 /100 = 475

Overtime Pay

10

10

150

150

10*10*150/100 = 150

Double Pay

10

10

200

200

10*10*200/100 = 200

Meal Allowance

3

13.96

100

41.88

3*13.96*100/100 = 41.88

Ordinary Meal Break Pay

3

7.5

100

22.5

3*7.5*100/100 = 22.5

Payroll Total Tax


53.76249231


53.76249231

Medicare tax ((2*(889.38*26)/100) + (19*((889.38*26) - 18201)/100))/26 =53.7624923077

Super Annuation Fund


45.125


45.125

475 *9.5/100 = 45.125

Total Basic


889.38


889.38

475 + 150 + 200 + 22.50 + 41.88 = 889.38

Net Income


835.6175077


835.6175077

889.38 - 45.125 = 835.6175077

6)Payslip for full time work type employee whose pay period is fortnightly, wages are based on timesheet and works on shifts

Note: This payslip is also applicable for full time work type employee whose pay period is monthly, wages are based on timesheet and works on shifts

Payslip No.

SLIP/977











Employee Name

Full Time Shift Fortnightly











Timesheet Period

2018-03-19 - 2018-04-01











Ordinary Hours

0





Over Time Hours

4:00





Double Hours

4:00





Afternoon Shift

7:36





Night Shift

7:36





Saturday Shift

11:36





Sunday Hour

11:36





Public Holiday Hours

11:36











Payslip computation






Salary rule

Quantity

Amount

Rate

Total

Calculation

Ordinary Pay

0

10

100

0

0*10*100/100 = 0

Overtime Pay

4

10

150

60

4*10*150/100 = 60

Double Pay

4

10

200

80

4*10*200/100 = 80

Afternoon Shift

7.6

10

115

87.4

7.6*10*115/100 = 87.4

Night Shift

7.6

10

115

87.4

7.6*10*115/100 = 87.4

Saturday Shift

11.6

10

150

174

11.60*10*150/100 = 174

Sunday Shift

11.6

10

200

232

11.6*10*200/100 = 232

Meal Allowance

5

13.96

100

69.8

5*13.96 = 69.8

Ordinary Meal Break Pay

2

7.5

100

15

2 *(10*150/2) = 15

Afternoon Shift Employee Meal Break

0.5

10

115

5.75

0.50* 1 *115/100 = 5.75

Night Shift Employee Meal Break

1

10

115

11.5

0.50* 2 *115/100 = 11.5

Payroll Total Tax


128.0961923


128.0961923

Medicare tax ((2*(1,243.35*26)/100) + (19*((1,243.35*26) - 18201)/100))/26 =128.0961923

Super Annuation Fund


69.426


69.426

Ordinary pay (0) + Afternoon shift ( 87.4) + NIght shift (87.4) + saturday 7.6 hour(7.6*10*150/100 = 114) +sunday 7.6 hour(7.6*10*200/100 = 152) + public holiday(290) = 730.8 * 9.5/100 = 69.426

Used Annual Leave

6

10

117.5

70.5

6*10*117.5/100 =70.5

Balance leave

5.23



5.23

remaining Annual leaves

Accured Leave

5.38



5.38

timesheet ordinary hours (76) - unpaid leave (6) = 70 * 0.07692307692 = 5.38

Public Holiday

11.6

10.00

250

290.00

11.6*10*250/100 =290

Used Sick Leave

6

10.00


60.00

6*10 = 60

Unpaid Leave

6



6.00


Total Basic


1,243.35


1,243.35

0+60+80+87.4+87.4+174+232+69.8+15+5.75+11.5+70.5+290+60 = 1243.35

Net Income


1,115.25


1,115.25

1243.5 - 128.0961923 = 1115.25

7)Payslip for part time work type employee whose pay period is fortnightly, wages are based on timesheet and works on shifts

Payslip No.

SLIP/978











Employee Name

Part Time Shift Fortnightly











Timesheet Period

2018-03-19 - 2018-04-01











Ordinary Hours

7:36





Over Time Hours

6:00





Double Hours

6:00





Afternoon Shift

7:36





Night Shift

7:36





Saturday Shift

11:36





Sunday Hour

11:36





Public Holiday Hours

11:36











Payslip computation






Salary rule

Quantity

Amount

Rate

Total

Calculation

Ordinary Pay

7.6

10

100

76

7.6*10*100/100 = 76

Overtime Pay

6

10

150

90

6*10*150/100 = 90

Double Pay

6

10

200

120

6*10*200/100 = 120

Afternoon Shift

7.6

10

115

87.4

7.6*10*115/100 = 87.4

Night Shift

7.6

10

115

87.4

7.6*10*115/100 = 87.4

Saturday Shift

11.6

10

150

174

11.60*10*150/100 = 174

Sunday Shift

11.6

10

200

232

11.6*10*200/100 = 232

Meal Allowance

6

13.96

100

83.76

6*13.96 = 83.76

Ordinary Meal Break Pay

2

7.5

100

15

2 *(10*150/2) = 15

Afternoon Shift Employee Meal Break

1

10

115

11.5

0.50* 2 *115/100 = 11.5

Night Shift Employee Meal Break

1

10

115

11.5

0.50* 2 *115/100 = 11.5

Payroll Total Tax


162.89529


162.89529

Medicare tax ((2*(1409.06*26)/100) + (19*((1409.06*26) - 18201)/100))/26 =162.89529

Super Annuation Fund


76.646


76.646

Ordinary pay (76) + Afternoon shift ( 87.4) + NIght shift (87.4) + saturday 7.6 hour(7.6*10*150/100 = 114) +sunday 7.6 hour(7.6*10*200/100 = 152) + public holiday(290) = 730.8 * 9.5/100 = 76.646

Used Annual Leave

6

10

117.5

70.5

6*10*117.5/100 =70.5

Balance leave

5.23



5.23

remaining Annual leaves

Accured Leave

2.74



2.74

timesheet ordinary hours (45) - unpaid leave (10) = 70 * 0.07692307692 = 2.74

Public Holiday

11.6

10.00

250

290.00

11.6*10*250/100 =290

Used Sick Leave

6

10.00


60.00

6*10 = 60

Unpaid Leave

10



10.00


Total Basic


1,409.06


1,409.06

76+60+80+87.4+87.4+174+232+69.8+15+11.5+11.5+70.5+290+60 = 1409.6

Net Income


1,246.16


1,246.16

1,409.06 - 162.89529 = 1246.16

8)Payslip for casual work type employee whose pay period is fortnightly, wages are based on timesheet and works on shifts

Payslip No.

SLIP/979











Pay Type

Casual Shift Fortnightly











Timesheet Period

2018-03-19 - 2018-04-01











Ordinary Hours

0





Over Time Hours

4:00





Double Hours

4:00





Afternoon Shift

7:36





Night Shift

7:36





Saturday Shift

11:36





Sunday Hour






Public Holiday Hours

11:36

















Payslip computation






Salary rule

Quantity

Amount

Rate

Total

Calculation

Ordinary Pay

0

10

100

0

0*10*100/100 = 0

Overtime Pay

4

10

150

60

4*10*150/100 = 60

Double Pay

4

10

200

80

4*10*200/100 = 80

Afternoon Shift

7.6

10

140

106.4

7.6*10*140/100 = 106.4

Night Shift

7.6

10

140

106.4

7.6*10*140/100 = 106.4

Saturday Shift

11.6

10

175

203

11.60*10*175/100 = 174

Sunday Shift

11.6

10

225

261

11.6*10*225/100 = 232

Meal Allowance

6

13.96

100

83.76

6*13.96 = 83.76

Ordinary Meal Break Pay

2

7.5

100

15

2 *(10*150/2) = 15

Afternoon Shift Employee Meal Break

1

10

115

11.5

0.50* 2 *115/100 = 11.5

Night Shift Employee Meal Break

1

10

115

11.5

0.50* 2 *115/100 = 11.5

Payroll Total Tax


131.08029


131.08029

Medicare tax ((2*(1,257.56*26)/100) + (19*((1,257.56*26) - 18201)/100))/26 =131.080209

Super Annuation Fund


79.401


79.401

Ordinary pay (0) + Afternoon shift ( 106.4) + NIght shift (106.4) + saturday 7.6 hour(7.6*10*175/100 = 114) +sunday 7.6 hour(7.6*10*225/100 = 152) + public holiday(319) = 730.8 * 9.5/100 = 69.426

Public Holiday

11.6

10.00

275

319.00

11.6*10*275/100 =319

Total Basic


1,257.56


1,257.56

0+60+80+106.4+106.4+203+261+83.76+15+11.5+11.5+319 = 1257.56

Net Income


1,126.48


1,126.48

1257.56 - 131.08029 = 1126.48

Complimentary Support

You will get 90 days free support for any doubt, queries, and bug fixing (excluding data recovery) or any type of issue related to this module.

Help & Support

Odoo support services is available to help you.

Please log in to comment on this module