TASK 1 To Be Completed In-Class

1. From the timesheets below, process the manual pays for all employees, for

(a) Fortnight ending 14/06/2020 (paid 15/06/2020)

(b) Fortnight ending 28/06/2020 (paid 29/06/2020)

Case Study - Goanna Creations Pty Ltd On the 1st of the current month, you commenced work as a casual bookkeeper for GoannaCreations Pty Ltd. You work on a Monday and sometimes a Friday working whatever hours are required to complete your bookkeeping tasks. You are responsible for the payroll and general accounts of the company. The manager will approve the payment of wages. In this assessment you will be required to: 1. 2. Calculate manual pays for 3 employees for the 2 fortnights manually. Set up the MYOB company file in accordance with payroll organisational and legislative requirements. 3. 4. Enter payroll data for the 3 employees. Process 2 fortnightly pays in accordance with organisational and legislative requirements in MYOB. 5. Make periodic backups of your data. 6. Reconcile payroll at the end of the month, prepare the business activity statementand make monthly payments to appropriate organisations. 7. Carry out end of payroll year procedures, printing payment summaries. About Goanna Creations Pty Ltd The following tasks are in preparation for processing payroll using MYOB Account Right v202031. The business makes and sells soft furnishings. The building is leased. The manager also runs a design class some Saturday afternoons when sufficient numbers have indicated an interest. Hours of business are 8.30 am to 5.00 pm Monday to Saturday. The business remains closed on public holidays except Show Day. Wages - Staff are employed under the Goanna Creations Pty LtdEnterprise Agreement 2020. At present there are 3 staff members: . Manager (Victoria Jennings) on a salary as a Full-time salesperson also supervises purchasing stockand administration. Salesperson (Hannah West) is a Full-time worker. she in charge of opening and closing of the shop and general organisation in the store and enters all sales and customer payments in MYOB. Casual bookkeeper (you) - you manage all the payroll duties and work only when needed on the general accounts, bank reconciliation and Business Activity Statement. . You commence on the 1st of current month, 2021 as Casual Bookkeeper for Goanna Creations Pty. Your Manager has decided to place you in Payroll for the month of June and you have been learning all about Payroll and now the time has arrived to pay all the staff for June 2021. You have also been requested to process the pays for June 2021, prepare pay advices for each employee and to prepare several reports for management. UNIVERSITY Conditions of Employment Normal Hours: 38 hours per week. Overtime: Hannah West is entitled to 1.5 times overtime for any hours worked in excess of 38 hours/week. Annual Leave: 4 weeks per annum. Loadings of 17.5% paid to replace overtime pays. Any annual leave outstanding at the end of the year carries over to the following year.Part-time employees are entitled to pro rata annual leave. Personal Leave: 10 days per annum. Part-time employees are entitled to personal leave on a pro rata basis. Uniform Allowance: All employees are entitled to a uniform allowance. Superannuation Guarantee: All employees are entitled to superannuation guarantee. Payment: Payment is made electronically to permanent employees and by cheque to casualemployees. Download the MYOB file entitled "Gogane nxex" from the Canvas site. Your Assessor will indicate the folder where this file is contained. Save this file You have also been requested to process the pays for June 2021, prepare pay advices for each employee and to prepare several reports for management. Use the Easy Setup Assistant (Setup, Easy Setup Assistant, Payroll) to load the tax tables dated 31/10/2020, enter general payroll information, and check payroll linked accounts. General payroll information and linked accounts Current Pavroll Year 2021 Full Work Week Hours: Withholding Payer Number: Default Superannuation Fund: Spectrum Super Round Net Pay Down to a Multiple of: O cents Payroll linked accounts Account for Cash Payments 1-1120 Payroll Clearing Account Account for Cheque Payment 1-1110 Cheque Account Account for Electronic Payments 1-1190 Electronic Clearing Account 6-5150 Other Employer Expenses Account for Employer Expenses Account for Wages Paid 6-5130 Wages & Salaries Account for Deductions & Expenses 2-1410 Payroll Accruals Payable Edit or create the Payroll Categories according to the details provided below: Wages (ATO reporting category is "Gross Payments") Base Salary, Base Hourly, Overtime, Bonus, Annual Leave pay, Personal leave pay. Check setups, all taxable. Check the Annual leave pay and personal leave pay to automatically adjust base wages and salaries. 17.5 % Gross wages. Taxable. Annual Leave Loading Superannuation (ATO Reporting is "superannuation Guarantee") Superannuation 9.5% of ordinary time Guarantee earnings when earning reach $450 per month. Allowance, Overtime an leave loading are excluded front he superannuation calculations. Bonus is included. Linked accounts are 6-5120 Superannuation and 2-1365 Superannuation payable. Employee This is a deduction from Net additional Pay. User-entered amount. super Linked account is 2-1365. Superannuation payable. ATO reporting category to be assigned. Entitlements Annual leave- full time Personal leave- full time 4 weeks (152 hours) P.A Print on pay advise 2 weeks per a print on pay advise Pro rata (7.6923% of hours worked). Print on pay advise. Over time, unused leave, Annual leave- part time backpay loading and bonus are exempt from this calculation. Pro rata (3.8461% of hours worked). Print on pay advise. Same exemptions as Annual leave. Personal leave- part time Deductions Health insurance, Red Cross, Union fee. Linked accounts 2-1410 payroll accruals payable. User entered amounted will be entered. ATO reporting category for Union fee is deduction-Union fee; For Red Cross deduction- work place giving; Health insurance not reportable. Linked account 2-1420 PAYG withholding payable. ATO reporting category is PAYG withholding. Taxes PAYG Withholding Create the employee cards from the information below: Employee 1 Name: Job title: Address: Date of birth: Start date: Remuneration: Victoria Jennings Manager (permanent, full-time 38-hour week) 24 Crosby Street, Brunswick, VIC 20/11/1979 1/2/2004 $65,000.00 per year paid fortnightly Plus 9.5% superannuation Annual leave pay, Annual leave loading, PL pay 100 hours Accrued 18 hours AMP Super Member 44124 Accrued holiday leave: Personal leave: Superannuation fund: number: TEN: Tax: Health Insurance: BSB: Account: Name: 123 333 444 Victoria has a HELP debt. Tax free threshold + HELP $80 per pay 014-547 4781247 Victoria Jennings Employee 2 Name: Job title: Hannah West Salesperson (permanent, full-time) Address: Phone: Date of birth Start Date: Classification: Remuneration: UNIVERS 44 Mant Street, Carlton, VIC 0414 785 111 3/10/1980 1/7/06 Sales person $19.80 per hour paid fortnightly 9.5% superannuation Annual leave pay, Annual leave loading, PL pay 76 hours Accrued 14 hours Accrued holiday leave: Personal leave: Super fund: REST Superannuation member No: 46124 TEN: Tax: 936 457 184 Tax Free Threshold 016-241 -($100 each pay) 45781236 BSB: Account: Name: Hanr West BSB: 016-241 - remainder of each pay Account: 1784446 Name: H West Employee 3 You first need to set - up and enter (below) your details in the MYOB Card File, as follows: Employee Name: [your name] Job Title Classification: Assistant Accountant Address: [your address] Date of Birth: [your date of birth] Phone number at work: 9925 1000 Email address at work: [your name @goanna.com.au) Work website address: www.goanna.com.au Start date: 1/6/2021 Remuneration: (as per Enterprise Agreement] Assistant Account paid at $18 per hour Pay frequency: Fortnightly Hours in Monthly Pay Period: (usually work Monday (pay day) and sometimes on Friday) Employment Status: Casual Superannuation fund: SBS SUPERANNUATION FUND Superannuation amount: 9.5% superannuation of gross salary Superannuation member number: YN-20162017-N Tax File Number: 452-897-123 Tax: Tax Free Threshold Bank BSB Number: 000-100 Bank Account Number: 66998877 Case Study - Goanna Creations Pty Ltd On the 1st of the current month, you commenced work as a casual bookkeeper for GoannaCreations Pty Ltd. You work on a Monday and sometimes a Friday working whatever hours are required to complete your bookkeeping tasks. You are responsible for the payroll and general accounts of the company. The manager will approve the payment of wages. In this assessment you will be required to: 1. 2. Calculate manual pays for 3 employees for the 2 fortnights manually. Set up the MYOB company file in accordance with payroll organisational and legislative requirements. 3. 4. Enter payroll data for the 3 employees. Process 2 fortnightly pays in accordance with organisational and legislative requirements in MYOB. 5. Make periodic backups of your data. 6. Reconcile payroll at the end of the month, prepare the business activity statementand make monthly payments to appropriate organisations. 7. Carry out end of payroll year procedures, printing payment summaries. About Goanna Creations Pty Ltd The following tasks are in preparation for processing payroll using MYOB Account Right v202031. The business makes and sells soft furnishings. The building is leased. The manager also runs a design class some Saturday afternoons when sufficient numbers have indicated an interest. Hours of business are 8.30 am to 5.00 pm Monday to Saturday. The business remains closed on public holidays except Show Day. Wages - Staff are employed under the Goanna Creations Pty LtdEnterprise Agreement 2020. At present there are 3 staff members: . Manager (Victoria Jennings) on a salary as a Full-time salesperson also supervises purchasing stockand administration. Salesperson (Hannah West) is a Full-time worker. she in charge of opening and closing of the shop and general organisation in the store and enters all sales and customer payments in MYOB. Casual bookkeeper (you) - you manage all the payroll duties and work only when needed on the general accounts, bank reconciliation and Business Activity Statement. . You commence on the 1st of current month, 2021 as Casual Bookkeeper for Goanna Creations Pty. Your Manager has decided to place you in Payroll for the month of June and you have been learning all about Payroll and now the time has arrived to pay all the staff for June 2021. You have also been requested to process the pays for June 2021, prepare pay advices for each employee and to prepare several reports for management. UNIVERSITY Conditions of Employment Normal Hours: 38 hours per week. Overtime: Hannah West is entitled to 1.5 times overtime for any hours worked in excess of 38 hours/week. Annual Leave: 4 weeks per annum. Loadings of 17.5% paid to replace overtime pays. Any annual leave outstanding at the end of the year carries over to the following year.Part-time employees are entitled to pro rata annual leave. Personal Leave: 10 days per annum. Part-time employees are entitled to personal leave on a pro rata basis. Uniform Allowance: All employees are entitled to a uniform allowance. Superannuation Guarantee: All employees are entitled to superannuation guarantee. Payment: Payment is made electronically to permanent employees and by cheque to casualemployees. Download the MYOB file entitled "Gogane nxex" from the Canvas site. Your Assessor will indicate the folder where this file is contained. Save this file You have also been requested to process the pays for June 2021, prepare pay advices for each employee and to prepare several reports for management. Use the Easy Setup Assistant (Setup, Easy Setup Assistant, Payroll) to load the tax tables dated 31/10/2020, enter general payroll information, and check payroll linked accounts. General payroll information and linked accounts Current Pavroll Year 2021 Full Work Week Hours: Withholding Payer Number: Default Superannuation Fund: Spectrum Super Round Net Pay Down to a Multiple of: O cents Payroll linked accounts Account for Cash Payments 1-1120 Payroll Clearing Account Account for Cheque Payment 1-1110 Cheque Account Account for Electronic Payments 1-1190 Electronic Clearing Account 6-5150 Other Employer Expenses Account for Employer Expenses Account for Wages Paid 6-5130 Wages & Salaries Account for Deductions & Expenses 2-1410 Payroll Accruals Payable Edit or create the Payroll Categories according to the details provided below: Wages (ATO reporting category is "Gross Payments") Base Salary, Base Hourly, Overtime, Bonus, Annual Leave pay, Personal leave pay. Check setups, all taxable. Check the Annual leave pay and personal leave pay to automatically adjust base wages and salaries. 17.5 % Gross wages. Taxable. Annual Leave Loading Superannuation (ATO Reporting is "superannuation Guarantee") Superannuation 9.5% of ordinary time Guarantee earnings when earning reach $450 per month. Allowance, Overtime an leave loading are excluded front he superannuation calculations. Bonus is included. Linked accounts are 6-5120 Superannuation and 2-1365 Superannuation payable. Employee This is a deduction from Net additional Pay. User-entered amount. super Linked account is 2-1365. Superannuation payable. ATO reporting category to be assigned. Entitlements Annual leave- full time Personal leave- full time 4 weeks (152 hours) P.A Print on pay advise 2 weeks per a print on pay advise Pro rata (7.6923% of hours worked). Print on pay advise. Over time, unused leave, Annual leave- part time backpay loading and bonus are exempt from this calculation. Pro rata (3.8461% of hours worked). Print on pay advise. Same exemptions as Annual leave. Personal leave- part time Deductions Health insurance, Red Cross, Union fee. Linked accounts 2-1410 payroll accruals payable. User entered amounted will be entered. ATO reporting category for Union fee is deduction-Union fee; For Red Cross deduction- work place giving; Health insurance not reportable. Linked account 2-1420 PAYG withholding payable. ATO reporting category is PAYG withholding. Taxes PAYG Withholding Create the employee cards from the information below: Employee 1 Name: Job title: Address: Date of birth: Start date: Remuneration: Victoria Jennings Manager (permanent, full-time 38-hour week) 24 Crosby Street, Brunswick, VIC 20/11/1979 1/2/2004 $65,000.00 per year paid fortnightly Plus 9.5% superannuation Annual leave pay, Annual leave loading, PL pay 100 hours Accrued 18 hours AMP Super Member 44124 Accrued holiday leave: Personal leave: Superannuation fund: number: TEN: Tax: Health Insurance: BSB: Account: Name: 123 333 444 Victoria has a HELP debt. Tax free threshold + HELP $80 per pay 014-547 4781247 Victoria Jennings Employee 2 Name: Job title: Hannah West Salesperson (permanent, full-time) Address: Phone: Date of birth Start Date: Classification: Remuneration: UNIVERS 44 Mant Street, Carlton, VIC 0414 785 111 3/10/1980 1/7/06 Sales person $19.80 per hour paid fortnightly 9.5% superannuation Annual leave pay, Annual leave loading, PL pay 76 hours Accrued 14 hours Accrued holiday leave: Personal leave: Super fund: REST Superannuation member No: 46124 TEN: Tax: 936 457 184 Tax Free Threshold 016-241 -($100 each pay) 45781236 BSB: Account: Name: Hanr West BSB: 016-241 - remainder of each pay Account: 1784446 Name: H West Employee 3 You first need to set - up and enter (below) your details in the MYOB Card File, as follows: Employee Name: [your name] Job Title Classification: Assistant Accountant Address: [your address] Date of Birth: [your date of birth] Phone number at work: 9925 1000 Email address at work: [your name @goanna.com.au) Work website address: www.goanna.com.au Start date: 1/6/2021 Remuneration: (as per Enterprise Agreement] Assistant Account paid at $18 per hour Pay frequency: Fortnightly Hours in Monthly Pay Period: (usually work Monday (pay day) and sometimes on Friday) Employment Status: Casual Superannuation fund: SBS SUPERANNUATION FUND Superannuation amount: 9.5% superannuation of gross salary Superannuation member number: YN-20162017-N Tax File Number: 452-897-123 Tax: Tax Free Threshold Bank BSB Number: 000-100 Bank Account Number: 66998877