1. The company runs payroll on the first working day every month for the previous month. Calculate all payment details on excel spreadsheet (Monthly Payroll Run - Approval Sheet) for July - Sep 2019 on the monthly basis. The monthly PAYG tax table is provided:
   1. Karen Forsyth receives $10k bonus in July pay run;
   2. Karen Forsyth receives $2k travel allowance for her August business trip to Queensland. The payment is made on 02/09/19.
   3. Karen Forsyth takes 1-day annual leave in on 30/08/19;
   4. Janet Woo's base salary is increased to $60k pro-rata from 01/09/19 after the August review.
   5. Crimson Saarskard works 12hrs in August and 45hrs in September in accordance with the timesheet.

Present the payroll approval sheet with the detailed calculation for financial controller to approve in excel:

Transcribed Image Text:

Employee Name Total B Pmt Period Payment Date D Base Salary $ E Bonus $ F Allowance $ Total Gross Pmt $ H PAYG $ - I Net Amt $ Annal Leave ($) $ Sick Leave ($) $ Annal Leave (days) M Sick Leave (days) N Superannuation $ Employee Name Total B Pmt Period Payment Date D Base Salary $ E Bonus $ F Allowance $ Total Gross Pmt $ H PAYG $ - I Net Amt $ Annal Leave ($) $ Sick Leave ($) $ Annal Leave (days) M Sick Leave (days) N Superannuation $

Answer rating: 100% (QA)

From the given information and images we need to construct a payroll approval sheet for the months of July August and September 2019 which will includ... View the full answer