FNSTPB402 Finance Assessment :
For solution: +610482078788
+61482073403
+61482072848
Assessment cover sheet
Unit Code / Title | |
Qualification Code / Title: | |
Due Date : |
Student Must Fill this Section | ||||
Student Name: | ||||
Student ID: | Term: | Year: | ||
Privacy Release Clause: | “I give my permission for my assessment material to be used in the auditing, assessment validation & moderation Process”. | |||
Authenticity Declaration: | “I declare that: The material I have submitted is my own work;I have given references for all sources of information that are not my own, including the words, ideas and images of others”. | |||
Student Signature: | Date: | |||
Assessment Outcome | |||||||||||
Assessor Name: | |||||||||||
Attempt and Tasks | Satisfactory | Not Yet Satisfactory | Date | Assessor Signature | |||||||
Initial attempt | | | |||||||||
Re- attempt/Re-assessment | | | |||||||||
Task 1 | | | |||||||||
Task 2 | | | |||||||||
Task 3 | | | |||||||||
Assessor Feedback to Students
Assessment Outcome: | Competent | Not yet Competent | ||
Assessor Name: | ||||
Assessor Signature: |
Information for Student: |
This assessment is to be completed according to the instructions given below in this document.Should you not answer the tasks correctly, you will be given feedback on the results and gaps in knowledge. You will be entitled to one (1) resubmit in showing your competence with this unit.If you are not sure about any aspect of this assessment, please ask for clarification from your assessor. Please refer to the College re-submission and re-sit policy for more information. If you have questions and other concerns that may affect your performance in the Assessment, please inform the assessor immediately.This is an Open book assessment which you will do in your own time but complete in the time designated by your assessor. Remember, that it must be your own work and if you use other sources then you must reference these appropriately.This is Individual Assessments. Once you have completed the assessment, please upload the softcopy of the Assessment into TKL Moodle. |
Re-assessment of Result & Academic Appeal procedures: |
If a student is not happy with his/ her results, that student may appeal against their grade via a written letter, clearly stating the grounds of appeal to the Chief Executive Officer. This should be submitted after completion of the subject and within fourteen days of commencement of the new term. Re-assessment Process: An appeal in writing is made to the Academic Manager providing reasons for re-assessment /appeal. Academic Manager will delegate another member to review the assessment. The student will be advised of the review result done by another assessor. If the student is still not satisfied and further challenges the decision, then a review panel is formed comprising the lecturer/trainer in charge and the Academic Manager or if need be an external assessor. The Institute will advise the student within 14 days from the submission date of the appeal. The decision of the panel will be deemed to be final. If the student is still not satisfied with the result, he / she has the right to seek independent advice or follow external mediation option with nominated mediation agency. Any student who fails a compulsory subject or appeals unsuccessfully will be required to re-enrol in that subject. The cost of reassessment will be borne by the Institute. The external assessor will base his/her judgement based on principles of assessment. These principles require assessment to be reliable, fair, practical and valid. Academic Appeals: If you are dissatisfied with the outcome of the re-evaluation process, you have a right to appeal through academic appeals handling protocol. To appeal a decision, the person is required to complete the TKL- Request for Appeal of a Decision form with all other supporting documents, if any. This form is available via our website. The completed Request for Appeal form is to be submitted to the Student Support Officer either in hard copy or electronically via the following contact details: Student Support Officer, TKL College Suite 707, Level 7 159-175 Church Street, Westfield Shopping Centre, Parramatta, NSW 2150 , Email: [email protected] The notice of appeal should be in writing addressed to the Chief Executive Officer and submitted within seven days of notification of the outcome of the re-evaluation process. If the appeal is not lodged in the specified time, the result will stand and you must re-enrol in the unit. In emergency circumstances, such as in cases of serious illness or injury, you must forward a medical certificate in support of a deferred appeal. The notice of appeal must be made within three working days of the concluding date shown on the medical certificate. The decision of Chief Executive Officer will be final. Student would then have the right to pursue the claim through an independent external body as detailed in the students’ complaint / grievance policy. |
Plagiarism: Plagiarism means to take and use another person’s ideas and or manner of expressing them and to pass them off as your own by failing to give appropriate acknowledgement. This includes material sourced from the internet, RTO staff, other students, and from published and unpublished work. Plagiarism occurs when you fail to acknowledge that the ideas or work of others are being used, which includes: Paraphrasing and presenting work or ideas without a referenceCopying work either in whole or in partPresenting designs, codes or images as your own workUsing phrases and passages verbatim without quotation marks or referencing the author or web pageReproducing lecture notes without proper acknowledgement. Collusion: Collusion means unauthorised collaboration on assessable work (written, oral or practical) with other people. This occurs when a student presents group work as their own or as the work of someone else. Collusion may be with another RTO student or with individuals or student’s external to the RTO. This applies to work assessed by any educational and training body in Australia or overseas. Collusion occurs when you work without the authorisation of the teaching staff to: Work with one or more people to prepare and produce workAllow others to copy your work or share your answer to an assessment taskAllow someone else to write or edit your work (without rto approval)Write or edit work for another studentOffer to complete work or seek payment for completing academic work for other students. Both collusion and plagiarism can occur in group work. For examples of plagiarism, collusion and academic misconduct in group work please refer to the RTO’s policy on Academic integrity, plagiarism and collusion. Plagiarism and collusion constitute cheating. Disciplinary action will be taken against students who engage in plagiarism and collusion as outlined in RTO’s policy. Proven involvement in plagiarism or collusion may be recorded on students’ academic file and could lead to disciplinary |
Assessment Requirements
You are required to complete and pass every task in the assessment in order to be deemed competent.
Assessment Schedule
Task | Due Date | Student Signature | Trainer Signature | Comments |
Task 1- 3 | Week 3 |
Assessment information
The assessment tasks for FNSTPB402 Establish and maintain payroll systems are included in this Student Assessment Tasks booklet and outlined in the assessment plan below.
To be assessed as competent for this unit, you must complete all of the assessment tasks satisfactorily.
Assessment plan
Assessment Task | Overview |
Written questions | You must correctly answer all questions. |
Establish and maintain payroll project | You must set up and maintain a payroll system for Oz Office Supplies. |
Payroll Role-plays | You must participate in two payroll role-plays. |
Assessment preparation
Please read through this assessment thoroughly before beginning any tasks. Ask your assessor for clarification if you have any questions.
When you have read and understood this unit’s assessment tasks, print out the Student Assessment Agreement. Fill it out, sign it and hand it to your assessor, who will countersign it and keep it on file.
Keep a copy of all of your work, as the work submitted to your assessor will not be returned to you.
Each assessment task in this booklet consists of the following:
Assessment task information
This gives you:
- a summary of the assessment task
- information on the resources to be used
- submission requirements
- resubmission opportunities if required.
Assessment task instructions
This includes questions you will need to answer or tasks that you need to complete.
Your answers must be typed using software as indicated in the assessment task Instructions.
Copy and paste each task’s instructions into a new document and use this as the basis for your assessment task submission. Include this document’s header and footer.
If you are submitting electronically, give the document a file name that includes the information as indicated in the section called ‘Naming electronic documents’ (see below).
Additional resources
You will be provided with the following resources before you begin each assessment task.
Assessment Task 2:
- Company Information
- Employee Information
- Payroll Preparation Report Template
- Timesheet Summaries
- Payroll Checklist
- Payroll Policy and Procedures.
Assessment Task 3:
- Timesheet.
Checklist
This will be used by your assessor to mark your assessment. Read through this checklist as part of your preparation before beginning the assessment task. It will give you a good idea of what your assessor will be looking for when marking your responses or observing your performance.
Assessment Task 1: Written questions
Task summary
This is an open-book Assessment to be completed within the given time frame. You need to answer all of the written questions correctly. Your answers must be word processed and Submit in Moodle.
Required
- Access to textbooks and other learning materials.
- Computer with Microsoft Office and internet access.
Timing
Your assessor will advise you of the due date of this assessment.
Submit
- Answers to all questions.
Assessment criteria
All questions must be answered correctly in order for you to be assessed as having completed the task satisfactorily.
Resubmission opportunities
You will be provided feedback on your performance by the assessor. The feedback will indicate if you have satisfactorily addressed the requirements of each part of this task.
If any parts of the task are not satisfactorily completed, the assessor will explain why, and provide you with written feedback along with guidance on what you must undertake to demonstrate satisfactory performance. Reassessment attempt(s) will be arranged at a later time and date.
You have the right to appeal the outcome of assessment decisions if you feel you have been dealt with unfairly or have other appropriate grounds for an appeal.
You are encouraged to consult with the assessor prior to attempting this task if you do not understand any part of this task or if you have any learning issues or needs that may hinder you when attempting any part of the assessment.
Written answer question guidance
The following written questions use a range of “instructional words” such as “identify” or “explain”, which tell you how you should answer the question. Use the definitions below to assist you to provide the type of response expected.
Note that the following guidance is the minimum level of response required.
Analyse: when a question asks you to analyse something, you should do so in detail, and identify important points and key features. Generally, you are expected to write a response one or two paragraphs long. Compare: when a question asks you to compare something, you will need to show how two or more things are similar, ensuring that you also indicate the relevance of the consequences. Generally, you are expected to write a response one or two paragraphs long. Contrast: when a question asks you to contrast something, you will need to show how two or more things are different, ensuring you indicate the relevance or the consequences. Generally, you are expected to write a response one or two paragraphs long. Describe: when a question asks you to describe something, you should state the most noticeable qualities or features. Generally, you are expected to write a response two or three sentences long. Discuss: when a question asks you to discuss something, you are required to point out important issues or features and express some form of critical judgement. Generally, you are expected to write a response one or two paragraphs long. Evaluate: when a question asks you to evaluate something, you should put forward arguments for and against something. Generally, you are expected to write a response one or two paragraphs long. Examine: when a question asks you to examine something, this is similar to “analyse”, where you should provide a detailed response with key points and features and provide critical analysis. Generally, you are expected to write a response one or two paragraphs long. Explain: when a question asks you to explain something, you should make clear how or why something happened or the way it is. Generally, you are expected to write a response two or three sentences long. Identify: when a question asks you to identify something, this means that you are asked to briefly describe the required information. Generally, you are expected to write a response two or three sentences long. List: when a question asks you to list something, this means that you are asked to briefly state information in a list format. Outline: when a question asks you to outline something, this means giving only the main points, Generally, you are expected to write a response a few sentences long. Summarise: when a question asks you to summarise something, this means (like “outline”) only giving the main points. Generally, you are expected to write a response a few sentences long. |
Assessment Task 1 Instructions as provided to students
Provide answers to all of the questions below:
- List a useful source of information for keeping up to date with Modern Award changes to ensure that your payroll is correctly maintained.
- Bee Enterprises has an enterprise agreement with staff. Assume that in the role of the new payroll officer, you are reviewing employee payments and discover that wage rates are now less than the current award rates, which changed recently. Explain if this is allowed under the Fair Work Act 2009 and give a reason for your answer.
No, it is not permitted by the Fair Work Act since the registered agreement’s base pay rate cannot be less than the award’s base pay rate, yet the award is not applicable if the bee company has a registered workplace agreement.
- Outline the payroll category in MYOB that can be adjusted based on an employee’s award or agreement.
Leave entitlements: Employees’ accrued leave under the provisions of their employment agreements is recorded using entitlement categories, similar to yearly and personal leave (but paid out using wage categories).
- Explain why is important for organisations to have confidentiality/privacy policies and procedures in place and what a payroll officer needs to be aware of when dealing with personal information?
- Give at least two payroll actions that a payroll officer would need to get authorisation for.
- Explain the term “structure of authority’ as used in organisations in relation to payroll functions within an organisation.
- Outline two instances in which a payroll service provider does not need to register as a tax agent or BAS agent, as set out in the Payroll Service Providers Information Sheet issued by the Tax Practitioners Board according to the Tax Agent Services Act 2009.
- Assume that a client of yours is trying to decide whether to continue using their manual payroll system or to upgrade to a computerised system. To help them make the choice, explain the differences between manual and computerised payroll system, including at least two features and two advantages and disadvantages of each type of system.
Computerised | Manual | |
Features | ||
Advantages | ||
Disadvantages |
- Explain why it is important for a payroll officer to understand the Fair Work Act 2009 and the National Employment Standards.
- Under the Fair Work Act, how much annual leave is an employee entitled to.
- Explain the superannuation guarantee scheme, including employee eligibility for superannuation under the Superannuation Guarantee Act.
- What allowances are there for employees with regard to voluntary contributions for superannuation?
- What tax benefits does payment of voluntary superannuation provide?
- Explain the circumstances in which an employer must pay a super guarantee charge.
- According to the Corporations Act, how long should business records be retained? What happens if a business does not retain required records?
- Explain the purpose of workplace/occupational health and safety legislation. Give an example of a safe work practice for a payroll officer needs to implement.
- Explain workers’ compensation and give an example of an adjustment that may need to be made to a payroll system if an employee is entitled to worker’s compensation.
- Explain why businesses have to pay payroll tax and identify thresholds and rates for businesses for the state or territory in which you are living.
- How long does the ATO require small businesses to keep records for? Give two examples of records that must be kept.
- Explain the importance of keeping payroll information confidential.
- Outline three areas that an organisation must address in regard to procedures around collection of personal information of employees to ensure it complies with the Australian Privacy principles.
- Outline the ATO requirements in relation to repayments of a higher education loan program (HELP).
- Explain the purpose of the Medicare levy and identify the rate at which it is levied.
- Explain the purpose of modern awards within the national workplace relations system and give an example of a modern award.
- Explain the purpose of enterprise bargaining and give an example of an enterprise agreement.
- Explain whether an employment contract can provide for less than the legal minimum under the NES.
- Under the Fair Work Act 2009, how much sick leave are employees entitled to.
- Explain the minimum legal requirements for long service leave.
- Outline the four main items that must be recorded against an employee’s payroll record when they commence employment with a company to ensure they receive their correct salary and entitlements and their details are reported correctly to the ATO.
- Explain the purpose of the Australian Bureau of Statistics (ABS) Act and briefly explain how statistics produced by the ABS can be used by a business.
- List three entities who are entitled to an ABN
- Explain an employer’s obligation regarding PAYG withholding tax and outline when PAYG withholding amounts must be paid for small withholders (individual or business that withholds $25,000 or less a year), for a medium withholder (individual or business that withholds amounts of $25,0001 to $1 million a year) and large withholders (individual or business that withheld amounts totalling more than $1 million in a previous financial year).
- Who is responsible for paying fringe benefits tax, and what is the FBT Rate for the financial year ending March 2017 and the financial years ending 2018,2019,2020 and 2021.
- What is fringe benefit in tax terms and two examples of fringe benefits and two examples of items used for work that would not be classified as fringe benefits.
- Give three examples of information that is reported on an Instalment Activity Statement (IAS)?
- In your own words, explain each principle of the TPB Code of Professional Conduct (Code) for all registered tax agents, BAS agents and tax (financial) advisers.
- What is an Employment Termination Payment and when must it be made to be considered as an Employment Termination Payment?
- How are Employment Termination Payment made outside the permitted period taxed?
- Explain the concept of salary packaging and give two examples of common items that can be salary packaged.
Student’s name: | |||
Did the student provide a sufficient and clear answer that addresses the suggested answer for the following? | Completed successfully? | Comments | |
Yes | No | ||
Question 1 | |||
Question 2 | |||
Question 3 | |||
Question 4 | |||
Question 5 | |||
Question 6 | |||
Question 7 | |||
Question 8 | |||
Question 9 | |||
Question 10 | |||
Question 11 | |||
Question 12 | |||
Question 13 | |||
Question 14 | |||
Question 15 | |||
Question 16 | |||
Question 17 | |||
Question 18 | |||
Question 19 | |||
Question 20 | |||
Question 21 | |||
Question 22 | |||
Question 23 | |||
Question 24 | |||
Question 25 | |||
Question 26 | |||
Question 27 | |||
Question 28 | |||
Question 29 | |||
Question 30 | |||
Question 31 | |||
Question 32 | |||
Question 33 | |||
Question 34 | |||
Question 35 | |||
Question 36 | |||
Question 37 | |||
Question 38 | |||
Question 39 | |||
Assessor feedback | |||
Assessor name: | |||
Assessor signature and Date: |
Assessment Task 2: Establish and maintain payroll system project
Task summary
This task requires you, in the role of Payroll Officer for Oz Office Supplies, to set and maintain a payroll system using up a computerised payroll system for the company (MYOB or similar).
You will be required to produce a number of payroll reports as outlined in the assessment.
The assessor will observe you setting up the system and will use the assessment task checklist to record your performance.
This assessment is to be completed in the simulated work environment in the RTO.
Required
- Access to textbooks and other learning materials
- Computer with Microsoft Office and internet access
- Employee Information
- Payroll Preparation Report Template
- Payroll Policy and Procedures
- Time Sheet Summary
- Timesheet
- Printer.
Timing
Your assessor will advise you of the due date of these submissions.
Submit
- Email with payroll preparation report attached
- Email requesting approval for processing the payroll
- Printed pay slips for Alice Brown, Ben Clark and Chris Cox for four weeks
- Email requesting approval for altering the payroll
- Email with the following attachments:
- Payroll summary report for June 2019
- Payroll register report for June 2019
- Payroll activity (summary) report for June 2019
- Profit and Loss Statement for June 2019
- Balance Sheet as at 30 June 2019
- Entitlement Balance (summary) report for June 2019
- Superannuation accrual by fund (summary) report for June 2019.
- Email with the following attachments:
- Payroll register (summary) report for year ended June 2019
- Payroll activity (summary) report for year ended June 2019
- Profit and Loss Statement for year ended June 2019
- Payroll Summary report for year ended June 2019
- Print the Entitlement Balance (summary) for the year ended 30 June 2019
- Print the balance sheet for year ended 30 June 2019
- Payment summaries for the 30 June 2019 financial year for each employee.
- Email giving data to be included in the IAS and BAS.
Assessment criteria
For your performance to be deemed satisfactory in this assessment task, you must satisfactorily address all of the assessment criteria. If part of this task is not satisfactorily completed, you will be asked to complete further assessment to demonstrate competence.
Resubmission opportunities
You will be provided feedback on your performance by the assessor. The feedback will indicate if you have satisfactorily addressed the requirements of each part of this task.
If any parts of the task are not satisfactorily completed, the assessor will explain why, and provide you with written feedback along with guidance on what you must undertake to demonstrate satisfactory performance. Reassessment attempt(s) will be arranged at a later time and date.
You have the right to appeal the outcome of assessment decisions if you feel that you have been dealt with unfairly or have other appropriate grounds for an appeal.
You are encouraged to consult with the assessor prior to attempting this task if you do not understand any part of this task or if you have any learning issues or needs that may hinder you when attempting any part of the assessment.
Assessment Task 2 Instructions as provided to students
Complete the following activities:
- Payroll system preparation.
Review Company Information and Employee Information so that you are familiar with the information you need to establish and maintain the payroll system. Review the Oz Office Supplies Payroll Policy and Procedures too, as you will need to follow these throughout this assessment. Conduct research to identify the following: Scope of services Describe the scope of payroll services that a BAS Agent can provide. Also find out how the services provided by a bookkeeper differs to that of a registered BAS Agent. Experts Locate, and record the details of, at least two local experts who could help if assistance was required with payroll services. Give the name of the individuals or companies, their contact details, and the services they provide. Termination Name and outline the legislation that covers notice of termination and final pay for Australian workers. Use the Fair Work Ombudsman website below to help you identify how much notice Oz Office Supplies’ employees must be given if their employment is to be terminated. List also the company’s payroll obligations to the terminated employee if Oz Office Supplies decides to pay an employee out rather than let them work out their notice period. Write a short (about a page) report that includes the information that you have collected on the above. Use the Payroll Preparation Report Template to guide your work. |
- Draft an email to your assessor.
The text of the email should be in grammatically correct English, written in an appropriate (polite, business-like) style. It should introduce and summarise the contents of the attachment. Attach your Payroll Preparation Report to the email. |
- Set up payroll system.
Using the Company Information and Employee Information for Oz Office Supplies, set up the payroll system for the company as outlined below. Before you start this task, find out about annual leave entitlements as set out in the National Employment Standards, based on the employment status of each employee. You will need to use this information when setting up the payroll system and when you are required to explain entitlements to your assessor. Your assessor will observe you entering all of the information into the payroll system to check that you can do this correctly. Complete all of the following tasks: Click on the Load Tax Tables button to check that the latest tax tables have been included. Show your assessor how to use the system to check for updates. Set up payroll information as per the company information provided to you.Assign linked payroll accounts. Review payroll categories included in MYOB and enter the information provided to you. In some cases, MYOB automatically includes the information and you will need to check this. Build the employee list by using the Employee Information provided to you. As you are entering the information about annual leave, explain to your assessor standard employment entitlement for annual leave according to the National Employment Standards.One of the employees, Alice Brown has a salary sacrifice arrangement in place whereby he pays an additional 2% of his salary into superannuation. Enter this amount into MYOB under superannuation. Explain to your assessor what salary sacrifice (sometimes also known as salary packaging) is. Give at least three examples of salary sacrificed benefits and three important considerations for a salary sacrifice arrangement. You should also explain Fringe Benefits. Your assessor will make notes on your verbal explanation in the checklist. As stated in the information provided to you, one of the employees is covered by an Award. Ask your assessor about their entitlements in relation to Rostered Days Off. Your assessor will provide these to you. Enter this information into MYOB to allow for rostered days off. If you do not know how to enter rostered days off into MYOB, use the help function to assist you to enter this information or research this information on the Internet. When you have completed entering all of the employee information, open the cards for each employee and check the information you have entered into MYOB for each employee against the employee information provided to you to make sure it is all correct. Edit any errors. Ensure that ensure the security of your MYOB company file according to the Oz Office Supplies Payroll Policy and Procedures. You should also explain to your assessor who may access records according to the policy, how often passwords must be changed and why. |
- Prepare and process payroll.
You are required to process payroll according to the time frame identified in the Oz Office Supplies Payroll Policy and Procedures and according to the Time Sheet Summary Assume that you are provided the time sheet summaries each week, as set out in the Payroll Policy and Procedures. Complete all of the actions that are required by the Payroll Policy and Procedures to process the payroll for the week ending 7 June 2019, noting that this will also include payment of superannuation (payroll liabilities). |
- Draft an email to the Finance Manager (your assessor).
The text of the email should be in grammatically correct English, written in an appropriate (polite, business-like) style. It should state that the payroll details have been entered into MYOB and seek their approval to process the pays as set out in the Payroll Policy and Procedures. Your assessor, in the role of the Finance Manager, will give their approval, or ask you to make any necessary alterations, verbally. From : [email protected] To : The Finance Manager Date : 08/11/2022 Subject : Payroll Approval Respected Sir, I have posted the payroll details into MYOB and I wanted to ask you for your approval of the payrolls so that I can proceed with the pays. Thank you |
- Process the payroll.
You are required to process the pay and print the pay slips for Alice Brown, Ben Clark and Chris Cox and prepare electronic payments for the week ending 7/6/19. Your assessor will check these to make sure you have entered all of the information accurately. PAYSLIP : ALICE BROWN Oz Office Supplies Pty Ltd 7 Holden Street, Camperdown, NSW, 2482 ABN: 222 333 444 Pay Slip For: Brown, Alice Reference Number: 111 Classification: Manager Payment Date: 8-6-2018 Annual Salary: $60,000 Hourly Rate: $30.7692 Pay Period From: 1-6-2018 To:7-6-2018 GROSS PAY: $1,153.85 Superannuation fund: AMP Life NET PAY: $858.78 Memo/pay slip message: Pay Employee DESCRIPTION HOURS CALC.RATE AMOUNT YTD TYPE Base Salary $1,153.85 $51,361.85 Wages Personal Leave Pay $0.00 $425.00 Wages Annual Leave Loading $0.00 $457.00 Wages Annual Leave Pay $0.00 $2,500.00 Wages Union Fee ($10.00) ($490.00) Deduction Health Insurance($65/w) ($65.00) ($3,185.00) Deduction Salary Sacrifice ($23.08) ($23.08) Superannuation Deductions PAYG Withholding ($197.02) ($11,497.02) Tax Personal Leave Accrual Salary 1.44 44.44 Entitlements Annual Leave Accrual Salary 2.89 168.89 Entitlements Superannuation (AMP LIFE) $109.62 $5,151.62 Superannuation Expenses Oz Office Supplies Pty Ltd 7 Holden Street, Camperdown, NSW, 2482 ABN: 222 333 444 PAYSLIP : BEN CLARK Pay Slip For: Clark, Ben Reference Number: 333 Classification: Office Admin Payment Date: 8-6-2018 Annual Salary: $45,000 Hourly Rate: $23.0769 Pay Period From: 1-6-2018 To:7-6-2018 GROSS PAY: $895.67 Superannuation fund: AMP Life NET PAY: $701.65 Memo/pay slip message: Pay Employee DESCRIPTION HOURS CALC.RATE AMOUNT YTD TYPE Base Salary $519.22 $42,344.22 Wages Annual Leave Loading 7.50 $4.04 $30.29 $168.29 Wages Annual Leave Pay 7.50 $23.08 $173.08 $965.08 Wages Personal Leave Pay 7.50 $23.08 $173.08 $806.08 Wages Health Insurance($38/w) ($38.00) ($1,862.00) Deduction Union Fee ($10.00) ($490.00) Deduction PAYG Withholding ($146.02) ($10,746.02) Tax Personal Leave Accrual Salary 1.44 3.94 Entitlements Annual Leave Accrual Salary 2.89 104.39 Entitlements Superannuation (AMP LIFE) $85.09 $4,163.09 Superannuation Expenses PAYSLIP : CHRIS DEAN Oz Office Supplies Pty Ltd 7 Holden Street, Camperdown, NSW, 2482 ABN: 222 333 444 Pay Slip For: Dean, Chris Reference Number: 444 Classification: Sales Representative Payment Date: 8-6-2018 Annual Salary: $23,999.98 Hourly Rate: $22.95 Pay Period From: 1-6-2018 To:7-6-2018 GROSS PAY: $706.27 Superannuation fund: AMP Life NET PAY: $504.25 Memo/pay slip message: Chris Dean Wages DESCRIPTION HOURS CALC.RATE AMOUNT YTD TYPE Commission $175.50 $175.50 Wages Base hourly 23.00 $22.95 $530.77 $530.77 Wages PAYG Withholding ($202.02) ($202.02) Tax Annual Leave Accrual Hourly 1.77 1.77 Entitlements Personal Leave Accrual Hourly 0.89 0.89 Entitlements Superannuation (AMP LIFE) $67.10 $67.10 Superannuation Expenses |
- Process further payroll periods.
Repeat this process that you carried out in activity 4 for weeks ending 14/6/19, 21/6/19 and 28/6/19 using the information provided to you. It is not necessary for you to email the Finance Manager for their approval for these weeks. Print off the payslips for the three employees and give these to your assessor. Oz Office Supplies Pty Ltd 7 Holden Street, Camperdown, NSW, 2482 ABN: 222 333 444 Pay Slip For: Brown, Alice Reference Number: 223 Classification: Manager Payment Date: 15-6-2018 Annual Salary: $60,000 Hourly Rate: $30.7692 Pay Period From: 8-6-2018 To:14-6-2018 GROSS PAY: $1,153.85 Superannuation fund: AMP Life NET PAY: $858.78 Memo/pay slip message: Pay Employee DESCRIPTION HOURS CALC.RATE AMOUNT YTD TYPE Base Salary $923.08 $52,284.93 Wages Personal Leave Pay 7.50 30.77 $230.77 $655.77 Wages Annual Leave Loading $0.00 $457.00 Wages Annual Leave Pay $0.00 $2,500.00 Wages Union Fee ($10.00) ($500.00) Deduction Health Insurance($65/w) ($65.00) ($3,250.00) Deduction Salary Sacrifice ($23.07) ($46.15) Superannuation Deductions PAYG Withholding ($197.03) ($11,694.05) Tax Personal Leave Accrual Salary 1.44 38.38 Entitlements Annual Leave Accrual Salary 2.89 171.77 Entitlements Superannuation (AMP LIFE) $109.61 $5,261.33 Superannuation Expenses Oz Office Supplies Pty Ltd 7 Holden Street, Camperdown, NSW, 2482 ABN: 222 333 444 Pay Slip For: Brown, Alice Reference Number: 224 Classification: Manager Payment Date: 12-6-2018 Annual Salary: $60,000 Hourly Rate: $30.7692 Pay Period From: 15-6-2018 To:21-6-2018 GROSS PAY: $1,153.85 Superannuation fund: AMP Life NET PAY: $858.78 Memo/pay slip message: Pay Employee DESCRIPTION HOURS CALC.RATE AMOUNT YTD TYPE Base Salary $692.31 $52,977.24 Wages Annual Leave Pay 15.00 30.77 $461.44 $2,961.54 Wages Annual Leave Loading 15.00 $5.38 $80.77 $537.77 Wages Personal Leave Pay $0.00 $655.77 Wages Union Fee ($10.00) ($510.00) Deduction Health Insurance($65/w) ($65.00) ($3,315.00) Deduction Salary Sacrifice ($24.70) ($70.85) Superannuation Deductions PAYG Withholding ($224.02) ($11,918.07) Tax Personal Leave Accrual Salary 1.44 39.83 Entitlements Annual Leave Accrual Salary 2.89 159.66 Entitlements Superannuation (AMP LIFE) $117.29 $5,378.52 Superannuation Expenses Oz Office Supplies Pty Ltd 7 Holden Street, Camperdown, NSW, 2482 ABN: 222 333 444 Pay Slip For: Brown, Alice Reference Number:444 Classification: Manager Payment Date: 29-6-2018 Annual Salary: $60,000 Hourly Rate: $30.7692 Pay Period From: 22-6-2018 To:28-6-2018 GROSS PAY: $1,153.85 Superannuation fund: AMP Life NET PAY: $858.78 Memo/pay slip message: Pay Employee DESCRIPTION HOURS CALC.RATE AMOUNT YTD TYPE Base Salary $1,153.85 $54,131.09 Wages Personal Leave Pay $0.00 $655.77 Wages Annual Leave Loading $0.00 $537.77 Wages Annual Leave Pay $0.00 $2,961.54 Wages Union Fee ($10.00) ($520.00) Deduction Health Insurance($65/w) ($65.00) ($3,380.00) Deduction Salary Sacrifice ($23.07) ($93.92) Superannuation Deductions PAYG Withholding ($197.03) ($12,115.10) Tax Personal Leave Accrual Salary 1.44 41.27 Entitlements Annual Leave Accrual Salary 2.89 162.54 Entitlements Superannuation (AMP LIFE) $109.62 $5,488.14 Superannuation Expenses Oz Office Supplies Pty Ltd 7 Holden Street, Camperdown, NSW, 2482 ABN: 222 333 444 Pay Slip For: Clark, Ben Reference Number: 332 Classification: Office Admin Payment Date: 22-6-2018 Annual Salary: $45,000 Hourly Rate: $23.0769 Pay Period From: 15-6-2018 To:21-6-2018 GROSS PAY: $865.38 Superannuation fund: AMP Life NET PAY: $681.35 Memo/pay slip message: Pay Employee DESCRIPTION HOURS CALC.RATE AMOUNT YTD TYPE Base Salary $865.38 $43,994.21 Wages Personal Leave Pay $0.00 $806.08 Wages Annual Leave Loading $0.00 $182.42 Wages Annual Leave Pay $0.00 $1045.85 Wages Health Insurance($38/w) ($38.00) ($1,938.00) Deduction Union Fee ($10.00) ($510.00) Deduction PAYG Withholding ($136.03) ($10,023.06) Tax Personal Leave Accrual Salary 1.44 6.83 Entitlements Annual Leave Accrual Salary 2.89 106.66 Entitlements Superannuation (AMP LIFE) $82.21 $4,328.85 Superannuation Expenses Oz Office Supplies Pty Ltd 7 Holden Street, Camperdown, NSW, 2482 ABN: 222 333 444 Pay Slip For: Clark, Ben Reference Number: 333 Classification: Office Admin Payment Date: 29-6-2018 Annual Salary: $45,000 Hourly Rate: $23.0769 Pay Period From: 22-6-2018 To:28-6-2018 GROSS PAY: $928.68 Superannuation fund: AMP Life NET PAY: $722.65 Memo/pay slip message: Pay Employee DESCRIPTION HOURS CALC.RATE AMOUNT YTD TYPE Base Salary $346.15 $44,340.36 Wages Annual Leave Loading 15.67 $4.04 $63.30 $245.72 Wages Annual Leave Pay 15.67 $23.08 $361.71 $1,407.56 Wages Personal Leave Pay 6.83 $23.08 $157.52 $963.60 Wages Health Insurance($38/w) ($38.00) ($1,976.00) Deduction Union Fee ($10.00) ($520.00) Deduction PAYG Withholding ($158.03) ($11,181.09) Tax Personal Leave Accrual Salary 1.44 1.44 Entitlements Annual Leave Accrual Salary 2.89 93.87 Entitlements Superannuation (AMP LIFE) $88.23 $4,417.08 Superannuation Expenses Oz Office Supplies Pty Ltd 7 Holden Street, Camperdown, NSW, 2482 ABN: 222 333 444 Pay Slip For: Dean, Chris Reference Number: 441 Classification: Sales Representative Payment Date: 15-6-2018 Annual Salary: $23,999.98 Hourly Rate: $22.95 Pay Period From: 8-6-2018 To:14-6-2018 GROSS PAY: $720.11 Superannuation fund: AMP Life NET PAY: $513.10 Memo/pay slip message: Chris Dean Wages DESCRIPTION HOURS CALC.RATE AMOUNT YTD TYPE Commission $235.50 $411.00 Wages Base hourly 21.00 $22.95 $484.61 $1,015.38 Wages PAYG Withholding ($207.01) ($409.03) Tax Annual Leave Accrual Hourly 1.62 3.38 Entitlements Personal Leave Accrual Hourly 0.81 1.69 Entitlements Superannuation (AMP LIFE) $68.41 $135.51 Superannuation Expenses Oz Office Supplies Pty Ltd 7 Holden Street, Camperdown, NSW, 2482 ABN: 222 333 444 Pay Slip For: Dean, Chris Reference Number: 442 Classification: Sales Representative Payment Date: 22-6-2018 Annual Salary: $23,999.98 Hourly Rate: $22.95 DESCRIPTION HOURS CALC.RATE AMOUNT YTD TYPE Commission $82.50 $493.50 Wages Base hourly 26.00 $22.95 $600.00 $1,615.38 Wages PAYG Withholding ($193.00) ($602.03) Tax Annual Leave Accrual Hourly 2.00 5.38 Entitlements Personal Leave Accrual Hourly 1.00 2.69 Entitlements Superannuation (AMP LIFE) $64.83 $200.34 Superannuation Expenses Pay Period From: 15-6-2018 To:21-6-2018 GROSS PAY: $682.50 Superannuation fund: AMP Life NET PAY: $489.50 Memo/pay slip message: Chris Dean Wages Oz Office Supplies Pty Ltd 7 Holden Street, Camperdown, NSW, 2482 ABN: 222 333 444 Pay Slip For: Dean, Chris Reference Number: 443 Classification: Sales Representative Payment Date: 29-6-2018 Annual Salary: $23,999.98 Hourly Rate: $22.95 Pay Period From: 22-6-2018 To:28-6-2018 GROSS PAY: $603.09 Superannuation fund: AMP Life NET PAY: $437.05 Memo/pay slip message: Chris Dean Wages DESCRIPTION HOURS CALC.RATE AMOUNT YTD TYPE Commission $150.50 $644.00 Wages Base hourly 15.50 $22.95 $357.69 $1,973.07 Wages Annual Leave Pay 3.50 $22.95 $80.77 $80.77 Wages Annual Leave Loading 3.50 $4.04 $14.13 $14.13 Wages PAYG Withholding ($166.04) ($768.07) Tax Annual Leave Accrual Hourly 1.73 3.62 Entitlements Personal Leave Accrual Hourly 0.87 3.56 Entitlements Superannuation (AMP LIFE) $57.30 $257.64 Superannuation Expenses |
- Handle discrepancies.
Assume you have received the following email from Chris, one of the employees. Dear Payroll Officer I have just received my pay slip for the week. I have only been paid for 21 hours, whereas in fact I worked 23hours. Can you please update this, so I can be paid the correct amount? Thanks Chris Review the Payroll Policy and Procedures and follow the correct procedure for handling discrepancies. Assume that your assessor is the Administration Manager. Once you receive approval, you should also demonstrate to your assessor how to make the relevant change in MYOB. From: [email protected] To: The Administration Manager Date: 08/11/2022 Subject: Adjustment of Chris Pay Dear Sir, I just got letters that Chris sent. He was complaining that his money had not been distributed in accordance with his working hours. He claims that he was only compensated for 12 hours rather than the required 21. So that I may pay him the right amount, could you kindly check and inform me of his working hours? Kinds regards, Student |
- Produce payroll records.
The Oz Office Supplies Payroll Policy and Procedures state that when you have completed the tasks above, you are required to print off the following end of month reports: a.Payroll summary report for June 2019 Oz Office Supplies Pty Ltd 7 Holden Street, Camperdown, NSW, 2482 ABN: 222 333 444 Employee Employment Details Name: Chris Cox Status: Active Card ID: CO100 Gender: Male Address 1: 5 Kite Street Sydney NSW 2000 Date Of Birth: 20/06/1992 Tax File Number: 741852963 Start Date: 1/06/2014 Employment Classification: Sale Representative Payment Method: Electronic Employment Basis: Individual Pay Frequency: Weekly Employment Category: Permanent Hours in pay period: 20.000 Employment Status: Part Time Hourly Rate: $22.95 Pay Basis: Hourly Annual Salary: $23,999.98 Tax Scale: No Tax-Free Threshold Extra Tax: $0.00 Total Rebates: $0.00 Superannuation Fund: AMP Life Employee Membership #: 741 Oz Office Supplies Pty Ltd 7 Holden Street, Camperdown, NSW, 2482 ABN: 222 333 444 Employee Employment Details Name: Ben Clark Status: Active Card ID: AO200 Gender: Male Address 1: 5 Sydney Way Sydney NSW 2000 Date Of Birth: 25/06/1971 Tax File Number: 159753852 Start Date: 15/01/2006 Employment Classification: Manager Payment Method: Electronic Employment Basis: Individual Pay Frequency: Weekly Employment Category: Permanent Hours in pay period: 37.500 Employment Status: Full Time Hourly Rate: $30.77 Pay Basis: Salary Annual Salary: $60,000.00 Tax Scale: Tax Free Threshold Extra Tax: $0.00 Total Rebates: $1,655.00 Superannuation Fund: AMP Life Employee Membership #: 852 Oz Office Supplies Pty Ltd 7 Holden Street, Camperdown, NSW, 2482 ABN: 222 333 444 Employee Employment Details Name: Chris Dean Status: Active Card ID: BO300 Gender: Male Address 1: 2 Yarrawonga Street Sydney NSW 2000 Date Of Birth: 11/05/1981 Tax File Number: 987654321 Start Date: 17/08/2014 Employment Classification: Office Admin Payment Method: Electronic Employment Basis: Individual Pay Frequency: Weekly Employment Category: Permanent Hours in pay period: 37.500 Employment Status: Full Time Hourly Rate: $23.08 Pay Basis: Salary Annual Salary: $45,000.00 Tax Scale: Tax Free Threshold + HELP Extra Tax: $0.00 Total Rebates: $0.00 Superannuation Fund: AMP Life Employee Membership #: 963 Oz Office Supplies Pty Ltd 7 Holden Street, Camperdown, NSW, 2482 ABN: 222 333 444 Payroll Summary June 2018 Category June Wages Annual Leave Loading $202.62 Hours 45.174 Annual Leave Pay $1,157.87 Hours 45.174 Base Hourly $1,973.07 Hours 85.5 Personal Leave Pay $561.37 Hours 21.826 Base Salary $6,438.45 Commission $644.00 Total: $10,977.38 Deductions Health Insurance($38/w) $152.00 Health Insurance($65/w) $260.00 Union Fee $80.00 Total: $492.00 Superannuation Deductions Before Tax Salary Sacrifice $93.92 Total: $93.92 Taxes PAYG Withholding $2,164.26 Total: $2,164.26 Superannuation Expenses Superannuation (AMP LIFE) $1,042.86 Total: $1,042.86 Entitlements Annual Leave Accrual Hourly Hours 3.615 Annual Leave Accrual Salary Hours -18.594 Personal Leave Accrual Hourly Hours 3.558 Personal Leave Accrual Salary -10.29 Hours Total: -21.711 Payroll register report for June 2019 Oz Office Supplies Pty Ltd 7 Holden Street, Camperdown, NSW, 2482 ABN: 222 333 444 June 2018 Employee Wages Deductions Taxes Net Pay Expenses Cox, Chris $4,696.17 $393.92 $815.10 $3,487.15 $446.14 Clark, Ben $3,569.24 $192.00 $581.09 $2,796.15 $339.08 Dean, Chris $2,711.97 $0.00 $768.07 $1,943.90 $257.64 Total: $10,977.38 $585.92 $2,164.26 $8,227.20 $1,042.8 6 c.Payroll activity (summary) report for June 2019 Oz Office Supplies Pty Ltd 7 Holden Street, Camperdown, NSW, 2482 ABN: 222 333 444 Payroll Activity [Summary] 01-Jun-18 To 30-Jun-18 Employee Wages Deductions Taxes Net Pay Expenses Cox, Chris $4,696.17 $393.92 $815.10 $3,487.15 $446.14 Clark, Ben $3,569.24 $192.00 $581.09 $2,796.15 $339.08 Dean, Chris $2,711.97 $0.00 $768.07 $1,943.90 $257.64 Total: $10,977.38 $585.92 $2,164.2 $8,227.20 $1,042.8 6 6 Profit and Loss Statement for June 2019 Oz Office Supplies Pty Ltd 7 Holden Street, Camperdown, NSW, 2482 ABN: 222 333 444 Profit & Loss Statement June 2018 Total Income $0.00 Total Cost of Sales $0.00 Gross Profit $0.00 Expenses Employment Expenses Superannuation $1,042.86 Total Employment Expenses $1,042.86 Wages & Salaries Expenses $10,333.38 Other Payroll Expenses $644.00 Total Expenses $12,020.24 Operating Profit ($12,020.24 ) Total Other Income $0.00 Total Other Expenses $0.00 Net Profit/(Loss) ($12,020.24 ) Balance Sheet as at 30 June 2019 Oz Office Supplies Pty Ltd 7 Holden Street, Camperdown, NSW, 2482 ABN: 222 333 444 Balance Sheet As of June 2018, Assets Current Assets Electronic Clearing Account ($8,227.20) Total Current Assets ($8,227.20) Total Assets ($8,227.20) Liabilities Current Liabilities Payroll Liabilities Payroll Accruals Payable $80.00 Superannuation Liability $1,136.78 Other Payroll Liabilities $2,164.26 Total Payroll Liabilities $3,381.04 Total Current Liabilities $3,381.04 Medical Benefit $412.00 Total Liabilities $3,793.04 Net Assets ($12,020.24 ) Equity Current Year Earnings ($12,020.24) Total Equity ($12,020.24 ) Entitlement Balance (summary) report for June 2019 Oz Office Supplies Pty Ltd 7 Holden Street, Camperdown, NSW, 2482 ABN: 222 333 444 Balance Sheet As of June 2018, Assets Current Assets Electronic Clearing Account ($8,227.20) Total Current Assets ($8,227.20) Total Assets ($8,227.20) Liabilities Current Liabilities Payroll Liabilities Payroll Accruals Payable $80.00 Superannuation Liability $1,136.78 Other Payroll Liabilities $2,164.26 Total Payroll Liabilities $3,381.04 Total Current Liabilities $3,381.04 Medical Benefit $412.00 Total Liabilities $3,793.04 Net Assets ($12,020.24 ) Equity Current Year Earnings ($12,020.24) Total Equity ($12,020.24 ) Superannuation accrual by fund (summary) report for June 2019 Oz Office Supplies Pty Ltd 7 Holden Street, Camperdown, NSW, 2482 ABN: 222 333 444 Superannuation Accrual by Fund June 2018 Superannuation Category Amount Superannuation Fund: AMP Life Employer Membership No.: Anderson, Alex Employee Membership No.: 233 Salary Sacrifice $93.92 Superannuation (AMP LIFE) $446.14 Employee Total: $540.06 Brown, Ben Employee Membership No.: 333 Superannuation (AMP LIFE) $339.08 Employee Total: $339.08 Cox, Chris Employee Membership No.: 444 Superannuation (AMP LIFE) $257.64 Employee Total: $257.64 Fund Total: $1,136.78 Grand Total: $1,136.78 Create a folder and save all of the summary reports you have generated as pdf files. Follow the Oz Office Supplies policy on storage of electronic files to store all end of month reports under Payroll summary reports for the month in question. Your assessor will observe you filing the documents. | |
- Draft an email to your assessor.
The text of the email should be in grammatically correct English, written in an appropriate (polite, business-like) style. It should introduce and summarise the contents of the attachments. Attach the payroll records that you created in activity 9 to the email. From: [email protected] To: [email protected] Date: 22/09/2021 Dear Teacher, Subject: Payroll records The payroll records are attached below: a. Payroll summary report for June 2018 b. Payroll register report for June 2018 c. Payroll activity (summary) report for June 208 d. Profit and Loss Statement for June 2018 e. Balance Sheet as at 30 June 2018 f. Entitlement Balance (summary) report for June 2018 g. Superannuation accrual by fund (summary) report for June 2018 Please let me know if you there is any changes needed. Thanking You Student |
- Complete checks and balances.
This part of the assessment requires you to complete checks and balances as follows: Check that the payroll activity report and the payroll register report match and that the subsidiary ledger agrees with the control accounts. Oz Office Supplies Pty Ltd 7 Holden Street, Camperdown, NSW, 2482 ABN: 222 333 444 Payroll Register (Summary) July 2017 To June 2018 Employee Wages Deductions Taxes Net Pay Expenses Cox, Chris $58,286.17 $3,993.92 $12,115.10 $42,177.15 $5,488.14 Clark, Ben $46,957.24 $2,496.00 $11,181.09 $33,280.15 $4,417.08 Dean, Chris $2,711.97 $0.00 $768.07 $1,943.90 $257.64 Total: $107,955.38 $6,489.92 $24,064.26 $77,401.20 $10,162.8 6 Complete the reconciliations of payroll on the June Payroll Checklist as provided. Oz Office Supplies Pty Ltd 7 Holden Street, Camperdown, NSW, 2482 ABN: 222 333 444 Payroll Activity [Summary] 01-Jul-17 To 30-Jun-18 Employee Wages Deductions Taxes Net Pay Expenses Cox, Chris $4,696.17 $393.92 $815.10 $3,487.15 $446.14 Clark, Ben $3,569.24 $192.00 $581.09 $2,796.15 $339.08 Dean, Chris $2,711.97 $0.00 $768.07 $1,943.90 $257.64 Total: $10,977.38 $585.92 $2,164.26 $8,227.20 $1,042.86 Reconcile the PAYG withholding. Oz Office Supplies Pty Ltd 7 Holden Street, Camperdown, NSW, 2482 ABN: 222 333 444 Profit & Loss Statement July 2017 To June 2018 Total Income $0.00 Total Cost of Sales $0.00 Gross Profit $0.00 Expenses Employment Expenses Superannuation $1,042.86 Total Employment Expenses $1,042.86 Wages & Salaries Expenses $10,333.38 Other Payroll Expenses $644.00 Total Expenses $12,020.24 Operating Profit ($12,020.24 ) Total Other Income $0.00 Total Other Expenses $0.00 Net Profit/(Loss) ($12,020.24 ) Pay payroll liabilities including Health Insurance, Union Fees, Superannuation and PAYG withholding to the ATO. Oz Office Supplies Pty Ltd 7 Holden Street, Camperdown, NSW, 2482 ABN: 222 333 444 Payroll Summary July 2017 To June 2018 Category 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter YTD Total Wages Annual Leave Loading $595.00 $0.00 $0.00 $202.62 $797.62 Hours 0 0 0 45.174 45.174 Annual Leave Pay $3,292.00 $0.00 $0.00 $1,157.87 $4,449.87 Hours 0 0 0 45.174 45.174 Base Hourly $0.00 $0.00 $0.00 $1,973.07 $1,973.07 Hours 0 0 0 85.5 85.5 Personal Leave Pay $1,058.00 $0.00 $0.00 $561.37 $1,619.37 Hours 0 0 0 21.826 21.826 Base Salary $92,033.00 $0.00 $0.00 $6,438.45 $98,471.45 Commission $0.00 $0.00 $0.00 $644.00 $644.00 Total: $96,978.00 $0.00 $0.00 $10,977.38 $107,955.38 Deductions Health Insurance($38/w) $1,824.00 $0.00 $0.00 $152.00 $1,976.00 Health Insurance($65/w) $3,120.00 $0.00 $0.00 $260.00 $3,380.00 Union Fee $960.00 $0.00 $0.00 $80.00 $1,040.00 Total: $5,904.00 $0.00 $0.00 $492.00 $6,396.00 Superannuation Deductions Salary Sacrifice $0.00 $0.00 $0.00 $93.92 $93.92 Total: $0.00 $0.00 $0.00 $93.92 $93.92 Taxes PAYG Withholding $21,900.00 $0.00 $0.00 $2,164.26 $24,064.26 Total: $21,900.00 $0.00 $0.00 $2,164.26 $24,064.26 Superannuation Expenses Superannuation (AMP LIFE) $9,120.00 $0.00 $0.00 $1,042.86 $10,162.86 Total: $9,120.00 $0.00 $0.00 $1,042.86 $10,162.86 Entitlements Annual Leave Accrual Hourly Hours 0 0 0 3.615 3.615 Annual Leave Accrual Salary Hours 170 0 0 -18.594 151.406 Personal Leave Accrual Hourly Hours 0 0 0 3.558 3.558 Personal Leave Accrual Salary Hours 53 0 0 -10.29 42.71 Total: 223 0 0 -21.711 201.289 Check the balance sheet as at 30-06-2019 to confirm all payroll liabilities have been paid. Oz Office Supplies Pty Ltd 7 Holden Street, Camperdown, NSW, 2482 ABN: 222 333 444 Entitlement Balance July 2017 To June 2018 Entitlement Opening Hours Hours Accrued Hours Taken Available Hours Value Chris, Cox AO100 Annual Leave Accrual Salary 105.00 133.54 15.00 223.54 $6,878.1 5 Personal Leave Accrual Salary 0.00 91.77 7.50 84.27 $2,592.8 6 Total: 105.00 225.31 22.50 307.81 $9,471.0 1 Clark, Ben AO200 Annual Leave Accrual Salary 0.00 229.54 26.67 202.87 $4,681.5 2 Personal Leave Accrual Salary 0.00 25.77 14.33 11.44 $264.05 Total: 0.00 255.31 41.00 214.31 $4,945.5 6 Dean, Chris AO300 Annual Leave Accrual Hourly 0.00 7.12 3.50 3.62 $83.42 Personal Leave Accrual Hourly 0.00 3.56 0.00 3.56 $82.11 Total: 0.00 10.67 3.50 7.17 $165.53 Create and save a copy of each of these reports: Payroll register (summary) report for year ended June 2019Payroll activity (summary) report for year ended June 2019Profit and Loss Statement for year ended June 2019Payroll Summary report for year ended June 2019Print the Entitlement Balance (summary) for the year ended 30 June 2019Print the balance sheet for year ended 30 June 2019As you need to reconcile gross wages and superannuation for the 2018/19 financial year, prepare the payment summaries for the 30 June 2019 financial year for each employee. Oz Office Supplies Pty Ltd 7 Holden Street, Camperdown, NSW, 2482 ABN: 222 333 444 Balance Sheet As of June 2018 Assets Current Assets Electronic Clearing Account ($8,227.20) Total Current Assets ($8,227.20) Total Assets ($8,227.20) Liabilities Current Liabilities Payroll Liabilities Payroll Accruals Payable $80.00 Superannuation Liability $1,136.78 Other Payroll Liabilities $2,164.26 Total Payroll Liabilities $3,381.04 Total Current Liabilities $3,381.04 Medical Benefit $412.00 Total Liabilities $3,793.04 Net Assets ($12,020.24 ) Equity Current Year Earnings ($12,020.24) Total Equity ($12,020.24 ) |
- Draft an email to your assessor.
The text of the email should be in grammatically correct English, written in an appropriate (polite, business-like) style. It should introduce and summarise the contents of the attachments and advise them of the payroll information from the reports that are to be included in the IAS and BAS. The email text should also explain to your assessor at least one cause why reports might not reconcile and how to rectify this. Attach the six reports and the payment summary for each employee from activity 11 to the email. From: [email protected] To: [email protected] Date: 22/09/2021 Dear Sir, Subject: Summarise attachment Here is the payment summary: • Payroll register (summary) report for year ended June 2018 • Payroll activity (summary) report for year ended June 2018 • Profit and Loss Statement for year ended June 2018 • Payroll Summary report for year ended June 2018 • Print the Entitlement Balance (summary) for the year ended 30 June 2018 • Print the balance sheet for year ended 30 June 2018 • As you need to reconcile gross wages and superannuation for the 2017/18 financial year, prepare the payment summaries for the 30 June 2018 financial year for each employee. Thank you |
- Update records.
Assume that Alex Anderson has recently had a salary review and his salary has been increased to $59,500. Update his records. Show your assessor that you know how to do this in MYOB. |
- Establish a backup and disaster recovery system.
Assume that you have been tasked to ensure that there is a strong back up and disaster recovery system in place. Research how to do this for MYOB and then write a simple procedure for back up and disaster recovery. Create a new Word document and write the procedure in this. Show this to your assessor. Create a backup file and store it as set out in your procedure. Your assessor will observe you doing this. |
Student’s name: | |||||
Did the student: | Completed successfully? | Comments | |||
Yes | No | ||||
Correctly identify and report on the scope of payroll services that a BAS agent can provide? | |||||
Correctly identify and report on situations relating to payroll for which an expert may be required? | |||||
Identify and report on at least two relevant experts and the services they provide as well as their contact details? | |||||
Correctly set up the payroll function within Student MYOB software using the company and employee data provided and including: Confirming year for tax tablesConfirming payroll yearAssigning linked payroll accountsEntering and reviewing payroll categories | |||||
Correctly enter all employee information into MYOB according to the source data provided (Oz Office Supplies company and employee data)? | |||||
Correctly advise of annual leave entitlements as set out in the National Employment Standards? | |||||
Correctly set up salary packaging arrangements in MYOB for the employee Alice Brown? | |||||
Correctly explain salary sacrifice and outline three examples of salary sacrificed benefits? | |||||
Ask assessor about details to be set up within payroll system for Ben Clark with regard to award requirements for RDOs and correctly enter into MYOB? | |||||
Check employee information included in MYOB within each employee card against source data and make adjustments as required? | |||||
According to the payroll procedures, correctly process payroll, print pay slips and prepare electronic payment for all employees for each week specified? | |||||
Send an email to the Finance Manager to request approval to process payments as set out in the Payroll Policy and Procedures? | |||||
Correctly explain payroll discrepancy in writing via email according to Oz Office Supplies procedures? | |||||
Correctly update payroll data for employee in MYOB according to information received from the Administration Manager? | |||||
Correctly produce and reconcile month-end and year-end checklists? Payroll summary report for June 2019Payroll register report for June 2019Payroll activity (summary) report for June 2019Profit and Loss Statement for June 2019Balance Sheet as at 30 June 2019Entitlement Balance (summary) report for June 2019Superannuation accrual by fund (summary) report for June 2019Payroll register (summary) report for year ended June 2019Payroll activity (summary) report for year ended June 2019Profit and Loss Statement for year ended June 2019Payroll Summary report for year ended June 2019Entitlement Balance (summary) for the year ended 30 June 2019Balance sheet for year ended 30 June 2019 | |||||
Correctly reconcile Gross Wages and Superannuation including: Checking that the payroll activity report and the payroll register report match and that the subsidiary ledger agrees with the control accounts. Completing the reconciliations of payroll on the June Payroll Checklist as provided.Reconciling the PAYG withholding.Paying payroll liabilities including Health Insurance, Union Fees, Superannuation and PAYG withholding to the ATO.Checking the balance sheet as at 30-06-2019 to confirm all payroll liabilities have been paid? | |||||
Provide correct and accurate data via email to the Finance Manager (assessor) for BAS and IAS reporting? | |||||
Correctly update payroll records for Alice Brown salary updates? | |||||
Develop a simple backup and recovery procedure for Oz Office Supplies based on research? | |||||
Make a backup copy and store as set out in the backup and recovery procedure developed? | |||||
Assessor feedback | |||||
Assessor name: | |||||
Assessor signature and Date: | |||||
Assessment Task 3: Payroll role-plays
Task summary
For this assessment task, you required to complete two role-plays. You will undertake the role-plays with your assessor.
You will play the role of the payroll officer of a company called LPO Consulting and the assessor will play the other roles of the employee in each scenario.
This assessment is to be completed in the simulated work environment in the RTO.
Required
- Access to textbooks and other learning materials
- Computer with Microsoft Office and internet access
- Timesheet.
Timing
Your assessor will advise you of the due date of these submissions.
Submit
- Corrected timesheet.
Assessment criteria
For your performance to be deemed satisfactory in this assessment task, you must satisfactorily address all of the assessment criteria. If part of this task is not satisfactorily completed, you will be asked to complete further assessment to demonstrate competence.
Resubmission opportunities
You will be provided feedback on your performance by the assessor. The feedback will indicate if you have satisfactorily addressed the requirements of each part of this task.
If any parts of the task are not satisfactorily completed, the assessor will explain why, and provide you written feedback along with guidance on what you must undertake to demonstrate satisfactory performance. Reassessment attempt(s) will be arranged at a later time and date.
You have the right to appeal the outcome of assessment decisions if you feel that you have been dealt with unfairly or have other appropriate grounds for an appeal.
You are encouraged to consult with the assessor prior to attempting this task if you do not understand any part of this task or if you have any learning issues or needs that may hinder you when attempting any part of the assessment.
Assessment Task 3 Instructions as provided to students
Complete the following activities:
Role-play 1
LPO Consulting is a small company that writes educational materials for workplaces to purchase. Staff complete their timesheets on hard copy templates that have been printed out from a Word document. The payroll process is completed using MYOB. It is part of your job to check the time sheets to ensure that the hours worked have been added up correctly.
While looking at an employee Harrison Ewbank’s Timesheet, you realise that some things do not make sense. Print out the timesheet and highlight any errors or inconsistencies you find. Then meet with Harrison (role played by your assessor) at the time and date advised.
This role-play requires you to:
- Liaise with Harrison and ask him to clarify the errors
- Check that your review of the time sheet matches with what Harrison is advising
- Demonstrate effective communication skills by speaking clearly and concisely
- Listen carefully to ensure you get all the information you need
- Use active listening techniques to confirm understanding
- Ask questions if you are unsure about anything.
You will then need to make adjustments to the timesheet based on the information that Harrison gives you. You will need to do this within five minutes.
Submit the corrected timesheet as part of your assessment.
You will be assessed on all of the above.
Role-play 2
Review the following excerpts from the LPO Payroll procedures:
Designated bank accounts Payroll procedures for LPO is that money is always transferred into the bank account specified in the employee details within the payroll system. Payment can be split between multiple accounts but unless employees advise the payroll officer of these details, payment will always go to the nominated account. Where employees do advise of multiple accounts, this needs to be in writing and at least 10 days’ notice must be given. Changes to salary arrangements Where an employee requests an increase in their salary, this is a formal process to be referred to the human resources department as salary increases occur as a result of performance reviews. Where an employee requests a salary increase, inform the employee of this information and advise them to contact the human resources department. |
It is 20 November and Amali, one of your colleagues, comes into your office.
She is upset as she has recently done some overtime but says the money has not been put into her account.
She was counting on the overtime to pay a credit card payment. This payment has now defaulted because the overtime money was not put into her account on time. Amali has now been hit with overdue fees.
Amali says she wanted the overtime amount to go directly into her credit card account and is blaming you for the problem. She says that she wrote to you via email 2 days ago with the change of details.
Payroll procedures for LPO is that money is always transferred into the bank account specified in the employee details within the payroll system.
Payment can be split between multiple accounts but, unless employees advise the payroll officer of these details, payment will always go to the nominated account.
Where employees do advise of multiple accounts, this needs to be in writing and at least 10 days’ notice must be given.
Your assessor will play the role of Amali and will advise you of the date and time for the role-play.
At the role-play you will need to advise Amali of company procedures to explain why the payment was not directed to the account she required.
Assume that Amali also advises you at the same meeting that she would like a pay increase. Follow this up as set out in the company procedures and explain this procedure to Amali.
Student’s name: | |||
Did the student: | Completed successfully? | Comments | |
Yes | No | ||
Role-play 1 | |||
Correctly identify errors within the timesheet provided? | |||
Discuss the errors in the timesheet with the employee? | |||
Ask the employee to clarify what the errors should be changed to? | |||
Update the timesheet with the revised information provided by the employee? | |||
Fill out timesheet within the designated timeframe provided? | |||
Role-play 2 | |||
Correctly advise the employee of payroll procedures as per company policy? | |||
Explain to the employee that the enquiry is outside of own responsibility and refer to human resources? | |||
Both Role-plays | |||
Use effective communication skills including: Speaking clearly and conciselyAsking questionsActive listening techniques to confirm understanding? |
Task outcome: | Satisfactory | Not satisfactory | ||
Assessor feedback | ||||
Assessor name: | ||||
Assessor signature and Date: | ||||
Visit:https://auspali.info/
Also visit:https://www.notesnepal.com/archives/767
For solution: +610482078788
+61482073403
+61482072848
YOUR COMMENT