> f2ɀ\pIBIS2 Ba==x<Sa(28X@"1jCalibri1jCalibri1jCalibri1jCalibri1 jGaramond1 jGaramond1 jGaramond1 @jGaramond1 @jGaramond1 @jGaramond1 jGaramond1 jGaramond1jCalibri1 jCalibri1jCalibri14jCalibri1 jCalibri1jCalibri1jCalibri1,8jCalibri18jCalibri18jCalibri1>jCalibri14jCalibri1<jCalibri1?jCalibri1h8jCambria1jCalibri1
jCalibri1 jGaramond1 jGaramond1@jCalibri1 @jGaramond1 jGaramond1 8jGaramond1 @jGaramond1 @jGaramond1 jGaramond1 8jGaramond1 +jGaramond"$"#,##0;\-"$"#,##0"$"#,##0;[Red]\-"$"#,##0"$"#,##0.00;\-"$"#,##0.00#"$"#,##0.00;[Red]\-"$"#,##0.005*0_-"$"* #,##0_-;\-"$"* #,##0_-;_-"$"* "-"_-;_-@_-,)'_-* #,##0_-;\-* #,##0_-;_-* "-"_-;_-@_-=,8_-"$"* #,##0.00_-;\-"$"* #,##0.00_-;_-"$"* "-"??_-;_-@_-4+/_-* #,##0.00_-;\-* #,##0.00_-;_-* "-"??_-;_-@_-![$-C09]dddd\,\ d\ mmmm\ yyyy
d/m/yyyy;@?:_-"$"* #,##0.000_-;\-"$"* #,##0.000_-;_-"$"* "-"??_-;_-@_-A<_-"$"* #,##0.0000_-;\-"$"* #,##0.0000_-;_-"$"* "-"??_-;_-@_-0.0"Yes";"Yes";"No""True";"True";"False""On";"On";"Off"],[$ -2]\ #,##0.00_);[Red]\([$ -2]\ #,##0.00\)"$"#,##0.00
ff
+
)
,
* P P `
a> * h (x ! ! !( ! ! " #X $X !X $ H H ! !X %X $X $#X (x x x x x x &x x 'x (X P P P | &X X | %X % X #X $X 1X $1\ 1| '1| 1P 1| 1*| P P &x ||x_e}-}
00_)}-}
00_)}-}
00_)}-}
00_)}-}
00_)}-}
00_)}-}
00_)}-}
00_)}-}
00_)}-}
00_)}-}
00_)}-}
00_)}-}
00_)}-}
00_)}-}
00_)}-}
00_)}A}
00_)ef[$ -}A}
00_)ef[$ -}A}
00_)ef[$ -}A}
00_)ef[$ -}A}
00_)ef[$ -}A}
00_)ef [$ -}A}
00_)L[$ -}A}
00_)L[$ -}A}
00_)L[$ -}A}
00_)L[$ -}A}
00_)L[$ -}A}
00_)L [$ -}A}
00_)23[$ -}A}
00_)23[$ -}A}
00_)23[$ -}A}
00_)23[$ -}A}
00_)23[$ -}A}!
00_)23 [$ -}A}"
00_)[$ -}A}#
00_)[$ -}A}$
00_)[$ -}A}%
00_)[$ -}A}&
00_)[$ -}A}'
00_) [$ -}A}(
00_)[$ -}})
}00_)[$ -##0.
}}*
00_)[$ -???##0.??? ???
???}-}+
00_)}-},
00_)}-}-
00_)}-}.
00_)}-}/
00_)}A}0
a00_)[$ -}A}1
00_)[$ -}A}2
00_)?[$ -}A}3
00_)23[$ -}-}4
00_)}}5
??v00_)̙[$ -##0.
}A}6
}00_)[$ -}A}7
e00_)[$ -}}8
00_)[$ -##0.
}}9
???00_)[$ -???##0.??? ???
???}-}:
00_)}-};
00_)}U}<
00_)[$ -##0.}-}=
00_)}(}>
00_)}(}?
00_)}(}@
00_)}(}C
00_)}(}D
00_)}(}E
00_)}-}F
00_)}(}G
00_)}}H
00_)[$##??? ???
???}}I
00_)[$##??? ???
???}}J
00_)[$##??? ???
???}}K
00_)[$##??? ???
???}}L
00_)[$##??? ???
???}}M
00_)[$##??? ???
???}<}N
00_)[$}<}O
00_)[$}<}P
00_)[$}<}Q
00_)[$}A}R
00_)[$}(}S
00_)}<}T
00_)[$}<}U
00_)[$}<}V
00_)[$}<}W
00_)[$}(}X00_)}(}^
00_)}(}`
00_)}(}a
00_)}}b
??v00_)̙[$##
}}c
??v00_)̙[$##
}}d
??v00_)̙[$##
}<}e
00_)L̙[$}(}f
00_)}(}g
00_)}<}j
00_)̙[$}<}k
00_)̙[$}<}l
00_)̙[$}<}m
00_)̙[$}}n
??v00_)̙[$##
}<}o
00_)̙[$}(}q
00_)}}r
??v00_)̙[$##
}}u
??v00_)̙[$##
}}v
??v00_)̙[$##
}(}w
00_)
20% - Accent1M
20% - Accent1ef%
20% - Accent2M"
20% - Accent2ef%
20% - Accent3M&
20% - Accent3ef%
20% - Accent4M*
20% - Accent4ef%
20% - Accent5M.
20% - Accent5ef%
20% - Accent6M2
20% - Accent6 ef%
40% - Accent1M
40% - Accent1L%
40% - Accent2M#
40% - Accent2L渷%
40% - Accent3M'
40% - Accent3L%
40% - Accent4M+
40% - Accent4L%
40% - Accent5M/
40% - Accent5L%
40% - Accent6M3
40% - Accent6 Lմ%
60% - Accent1M
60% - Accent123%
60% - Accent2M$
60% - Accent223ږ%
60% - Accent3M(
60% - Accent323כ%
60% - Accent4M,
60% - Accent423%
60% - Accent5M0
60% - Accent523%!
60% - Accent6M4
60% - Accent6 23%"Accent1AAccent1O%#Accent2A!Accent2PM%$Accent3A%Accent3Y%%Accent4A)Accent4d%&Accent5A-Accent5K%'Accent6A1Accent6 F%(Bad9Bad%)CalculationCalculation}% *
Check Cell
Check Cell%????????? ???+ Comma,( Comma [0]-&Currency..Currency [0]/Explanatory TextG5Explanatory Text% 0Good;Gooda%1 Heading 1G Heading 1I}%O2 Heading 2G Heading 2I}%?3 Heading 3G Heading 3I}%234 Heading 49 Heading 4I}%
5InputuInput̙??v% 6Linked CellKLinked Cell}%7NeutralANeutrale%3Normal% 8Noteb
Note 9OutputwOutput???%????????? ???:$Percent
;Title1TitleI}%
<TotalMTotal%OO=Warning Text?Warning Text%XTableStyleMedium2PivotStyleLight16`hInstructionsDeclarationAssessments Submission=#
_Toc302989777<#
_Toc302989778<#
_Toc303855368:#
_Toc303855369:%#
_Toc303855370:*#
_Toc303855371:3#
_Toc303855372::#
_Toc303855373:=#
_Toc303855376<#
_Toc303855377<#
_Toc303855378<#
_Toc303855379<#
_Toc303855380<#
_Toc303855381<#
_Toc303855382<#
_Toc303855383<#
_Toc303855384<#
_Toc303855385<#
_Toc303855386<#
_Toc303855387<#
_Toc303855388<#
_Toc303855389<#
_Toc303855390<#
_Toc303855391<#
_Toc303855392<#
_Toc303855393<#
_Toc303855394<#
_Toc303855395<#
_Toc303855396<#
_Toc303855397<#
_Toc303855398<#
_Toc303855399<#
_Toc303855400<#
_Toc303855401<#
_Toc303855402<#
_Toc303855403<#
_Toc303855404<#
_Toc303855405<#
_Toc303855406<8 oMODULEASSESSMENT TASKMODULE 1 MODULE 2 MODULE 3 MODULE 4 MODULE 5 MODULE 6 MODULE 7 Student DeclarationStudent SignatureDatePlease give a clear file name to EACH document that you submit in the format: Student Name - Student ID - Course Unit - Document Title - Date - Version No.NAssessment Workbook6There are three worksheets in this Assessment WorkbookJ 1. Instructions worksheet named Instructions (which is this worksheet)$0 6 2. Student Declaration worksheet named Declaration+D 3. Assessments Submission worksteet named Assessments Submission.ZE.g. Tom Burton - 0425BUR - Cash Accounting - Assessment Workbook - 16June2011 - Version 1X E.g. Tom Burton - 0425BUR - Cash Accounting Assessment Task 6 - 16June2011 - Version 1H1) Please complete the Student Declaration in the Declaration worksheet.
2= `2) Please enter your responses to the assessment tasks, in the Assessments Submission worksheet.
?U V3) Please submit the completed assessment workbook by email to bookkeeping@ibi.edu.au
3; ?
4) Some assessment tasks require you to provide downloads of documents, electronic printouts, reports, etc. Please submit them as attachments to your email submission. Student Name I also declare that by inserting my name and date at the top of each page of this Assessment Workbook I am affirming that all assessment submissions to the Investment Banking Institute are a result of my own work .
Student ID| I affirm that all work submitted within this Assessment workbook is my true and original work unless otherwise credited. I also affirm that any documents submitted as electronic files or attachments to my assessment submissions are also a result of my true and original work unless otherwise credited. -Please type your Name here in CAPITAL LETTERSAssessments SubmissionRESPONSEQUESTIONLearning Manual VersionTASK ID,When did Fairwork Australia begin operating?Key features of Fair Work are:_What are the minimum conditions for employees in the national workplace relations system (NES)?ZWhat is the maximum number of ordinary hours set at that an employee may work in one week?Working parents have the right to request flexible working hours or additional parent leave. What must the employee have to be eligible for this?]All employees except casuals are entitled to how many days personal or carers leave per year?AEmployees are entitled to how many paid public holidays per year? What is a Greenfields agreement?.Who is NOT generally covered by modern awards?:What must an employee provide an employer upon employment?,What are some flexible working arrangements?)What are some obligations as an employer?ZUnder relevant Commonwealth workplace laws employers who engage employees are required to:+How long must employee records be kept for?-What must general employment records contain?PPay slips must be issued to an employee within how many working days of pay day?What does FBT stand for??How much super must employers pay their employees at a minimum?5An employee may file a claim for unfair dismissal if:3What is the current national minimum wage per hour?What is a penalty rate?What is casual loading?What is Part Time Loading?ZIn what circumstances may an employee be entitled to an extra payment called an allowance?WIn what circumstances is an employer allowed to make a deduction from an employees pay?NWhich workers are NOT paid for public holidays and only paid for hours worked?<All employees except ______ employees get paid annual leave?TAn employee is entitled to how many weeks annual leave for each 12months of service?What is long service leave?Payroll information needs to be secured for a variety of reasons, most important of which is related to compliance with which act?9Which of the following components are payroll categories?2Which of the following are entitlement categories?9Which of the following would not be a deduction category?gWhat form needs to be supplied to the employee by the employer who are eligible to choose a super fund?5Which command centre are the employee cards found in?VWhat details are found under the Payroll Details tab in the Employee Card Information?uWhat details need to be entered about the employee in the Personal Details section of the employee s payroll details?SWhat report should you print to best check the employment details you have entered?qWhat details are needed to set up a business s bank account details & Electronic Payment Details in AccountRight?HWhat following steps need to be undertaken to process an employee s pay?OIf you find an error in an individual s pay, call up the transaction using the:DThe contents of an Electronic Payment File ( ABA File) will contain?;What totals should be included on an employee s time sheet?8What does the Payroll Activity [Summary] Report tell us?You can view details about total wages, taxes, deductions and employer expences on the Payroll Summary Reports for what period?VWhen reconciling payroll for the month, what are the three main components of Payroll?What is the cut-off date for the 1st quarter (1st July 30 September) for the employer to pay the superannuation payable for each eligible employee?;What is the best method to use to pay Superannuation owing?CEmployers report and pay amounts withheld to the ATO by completing:IWhat date is the deadline to Forward PAYG Payment Summaries to employees?gWhat date is the deadline to Forward copies of Payment Summaries and supporting information to the ATO?\What date is the deadline for any outstanding superannuation liability for the payroll year?DWhat information is not needed on the end of year payroll checklist?yWhen completing pay cheques for the current year what should you ensure have been processed for the current payroll year?nPayment summaries should be prepared and printed after payroll has been reconciled for the year on which date?GWhat company information is required when completing a Payroll Summary?Which is a payroll Category?=When sending an EMPDUPE file where do you need to send it to?What does RESC stand for?#What is the tax amount assessed on?=In Victoria what is the current payable rate for payroll tax?RWhat categories are taken into consideration when conducting a payroll tax report?JSalary sacrificing can be sacrificed into a variety of benefits including:?Which of these statements are bout long service leave are true?wAll afternoon and non-permanent night shift workers are paid an additional what percentage of the ordinary hourly rate?|What is the current rate per kilometre with a maximum payment up to 400 kilometres per week an allowan< ce for motor vehicles?2What can an Employment Termination Payment include7What does an Employment Termination Payment not include\What is the Account Number of the account to be used for expenses related to car allowances?^What is the Account Number of the account to be used for liabilities related to child support?bThe employer s default superannuation fund is Savvy Super. What is the Employer Membership Number?*What password did you create for the User?4What password did you created for the Administrator?What is the W1 amount?What is the W2 amount?7Which of the following accounts have non-zero balances?*What is the ABN of Wreck-A-Mended Pty Ltd?After the update (if required) what is Number of Hours in a Full-Time Working Week that shows in the General Payroll Information?mAfter the update (if required) what is Tax Table Revision Date that shows in the General Payroll Information?CWhat is the Account Number of the Default Employer Expense Account?@What is the Account Number of the Default Wages Expense Account?AWhat is the Account Number of the Default Tax/Deductions Account?1Assessment Task 10. Report Accounts List Summary[Generate the Accounts List Summary Report. Submit an electronic copy with your assessments.tIn the Accounts List Summary Report, do all the following Accounts exist? If not, ensure they do, before proceeding.8What Fixed Hourly Rate did you set up for Car Allowance?=Which employee(s) did you link the Car Allowance category to?EWhich employee(s) did you link the Child Support Payable category to?aGenerate the Employee Employment Details Report. Submit an electronic copy with your assessments.7What is the Annual Salary amount showing for Alf Aromo?<What is the Annual Salary amount showing for Fuli Automatix?6What is the Hourly Rate amount showing for Penny Wise?6What is the Total Number of Hours worked by Alf Aromo?;What is the Total Number of Hours worked by Fuli Automatix?8What is the Net Wages (Before Tax) amount for Alf Aromo?=What is the Net Wages (Before Tax) amount for Fuli Automatix?9What is the Net Wages (Before Tax) amount for Penny Wise?1What is the Super Guarantee amount for Alf Aromo?6What is the Super Guarantee amount for Fuli Automatix?2What is the Super Guarantee amount for Penny Wise?NGenerate the Payroll Journal. Submit an electronic copy with your assessments.DWhat is the amount in the Electronic Clearing Account for Alf Aromo?IWhat is the amount in the Electronic Clearing Account for Fuli Automatix?EWhat is the amount in the Electronic Clearing Account for Penny Wise?|Prepare the Electronic Payment and generate the Bank File. Submit an electronic copy of the Bank File with your assessments.8Assessment Task 35. Report Electronic Payments Register\Generate the Electronic Payments Register . Submit an electronic copy with your assessments.8Assessment Task 36. Report Electronic Payments RegisterEWhat is the Payment Total amount in the Electronic Payments Register?-Assessment Task 37. Process Payroll PayslipshPrepare the Payslips for all employees. Submit an electronic copy of the Payslips with your assessments.6Assessment Task 38. Report Payroll Register [Summary]`Generate the Payroll Register [Summary] Report. Submit an electronic copy with your assessments.6Assessment Task 39. Report Payroll Register [Summary])What is the Net Pay amount for Alf Aromo?6Assessment Task 40. Report Payroll Register [Summary].What is the Net Pay amount for Fuli Automatix?6Assessment Task 41. Report Payroll Register [Summary]*What is the Net Pay amount for Penny Wise?6Assessment Task 42. Report Payroll Register [Summary].What is the Net Expenses amount for Alf Aromo?6Assessment Task 43. Report Payroll Register [Summary]3What is the Net Expenses amount for Fuli Automatix?6Assessment Task 44. Report Payroll Register [Summary]/What is the Net Expenses amount for Penny Wise?2Assessment Task 45. Electronic Payments Bank File8Assessment Task 46. Report Electronic Payments RegistermGenerate the Electronic Payments Register . Submit an electronic copy of the Bank File with your assessments.8Assessment Task 47. Report Electronic Payments Register3Assessment Task 48. Report Profit & Loss StatementkGenerate the Profit & Loss [Accrual] Report for the month. Submit an electronic copy with your assessments.2Assessment Task 49. Report Standard Balance SheetwGenerate the Standard Balance Sheet Report as on the end of the month. Submit an electronic copy with your assessments.7Assessment Task 50. Payroll Reconciliation Gross Wages;What is the Gross Wages amount as per the Payroll Register?=Assessment Task 51. Payroll Reconciliation Payroll Expenses=What is the Payroll Expenses amount as per the Profit & Loss?:Assessment Task 52. Payroll Reconciliation Superannuation>What is the Superannuation amount as per the Payroll Register?;Assessment Task 53. Payroll Reconciliation Superannuation;What is the Superannuation amount as per the Profit & Loss?;Assessment Task 54. Payroll Reconciliation Superannuation;What is the Superannuation amount as per the Balance Sheet?3Assessment Task 55. Report Profit & Loss Statement|Generate the Superannuation Accrual by Fund [Summary] Report for the month. Submit an electronic copy with your assessments.8Assessment Task 56. Payroll Liabilities Superannuation.What is the Total Payment made to Savvy Super?8Assessment Task 57. Payroll Liabilities Superannuation-What is the Total Payment made to Star Super?>Assessment Task 58. Payroll Liabilities Child Support Agency;What is the Total Payment made to the Child Support Agency?3Assessment Task 59. Payroll Liabilities red cross,What is the Total Payment made to Red Cross?5Assessment Task 60. BAS Reporting PAYG Tax Withheld5Assessment Task 61. BAS Reporting PAYG Tax Withheld?Assessment Task 62. BAS Reporting Business Activity StatementhGenerate the Business Activity Statement for the month. Submit an electronic copy with your assessments.3Assessment Task 63. BAS Reporting BAS Transaction\Generate the BAS Transaction for the month. Submit an electronic copy with your assessments.3Assessment Task 64. BAS Reporting BAS Transaction:What is the Total Allocated amount in the BAS Transaction?2Assessment Task 65. Report Standard Balance SheetGenerate the Standard Balance Sheet Report (use the Finishing tab to include $0.00 balances) as on 1/9/2011. Submit an electronic copy with your assessments.2Assessment Task 66. Report Standard Balance Sheet+Assessment Task 67. File Management BackuppMake a Backup of the Data File and add Before YE 2011 to its name. Submit the Backup file with your assessments.:Assessment Task 68. End-of-Payroll-Year Payment SummariesGenerate one copy of the Payment Summaries for each employee as on 30 June 2012. Submit an electronic copy with your assessments.AAssessment Task 69. Report Payment Summaries Verification ReportdGenerate the Payment Summaries Verification Report. Submit an electronic copy with your assessments.2Assessment Task 70. Report Payment Summary ReportUGenerate the Payment Summary Report. Submit an electronic copy with your assessments.6Assessment Task 71. Payment Summaries Reconciliation=What is the Total Wages amount in the Payment Summary Report?6Assessment Task 72. Payment Summaries ReconciliationOWhat is the Gross Payments amount in the Payment Summaries Verification Report?6Assessment Task 73. Payment Summaries Reconciliation;What is the Total Tax amount in the Payment Summary Report?6Assessment Task 74. Payment Summaries ReconciliationJWhat is the Total Tax amount in the Payment Summaries Verification Report?3Assessment Task 75. Payment Summaries EMPDUPE FileKGenerate the EMPDUPE File. Submit an electronic copy with your assessments.3Assessment Task 76. Payment Summaries EMPDUPE File^Generate the Magnetic Media Information Form. Submit an electronic copy with your assess<ments.+Assessment Task 77. File Management BackuprMake a Backup of the Data File and add Payroll End 2011 to its name. Submit the Backup file with your assessments.Part II : Case StudyFNSBKG405A Payroll Management6Assessment Task 1. reulations & legislation fair work/Assessment Task 2. fair work Australia Features!Assessment Task 3. NES conditions+Assessment Task 4. fair work ordinary hours+Assessment Task 5. fair work flexible hours!Assessment Task 6. employee leave+Assessment Task 7. employee public holidays1Assessment Task 8. employee greenfields agreement)Assessment Task 9. employee modern awards$Assessment Task 10. employee details1Assessment Task 11. employee working arrangements(Assessment Task 12. employer obligationsEAssessment Task 13. commonwealth workplace laws employer requirements$Assessment Task 14. employee records$Assessment Task 15. employee records%Assessment Task 16. employer payslipsAssessment Task 17. tax FBT+Assessment Task 18. employer superannuation-Assessment Task 19. employee unfair dismissal&Assessment Task 20. wages minimum wage'Assessment Task 21. rates penalty rates(Assessment Task 22. rates casual loading+Assessment Task 23. rates part time loading&Assessment Task 24. employee allowance&Assessment Task 25. employer deduction,Assessment Task 26. employee public holidays)Assessment Task 27. employee annual leave)Assessment Task 28. employee annual leave,Assessment Task 29. leave long service leave0Assessment Task 30. payroll information security1Assessment Task 31. payroll categories components3Assessment Task 32. payroll categories entitlements0Assessment Task 33. payroll categories deduction+Assessment Task 34. employer superannuation1Assessment Task 35. employee employee information8Assessment Task 36. employee information payroll details4Assessment Task 37. payroll details personal details.Assessment Task 38. employment details reports9Assessment Task 39. business details bank account details4Assessment Task 40. processing pays steps to process1Assessment Task 41. payment errors finding errors0Assessment Task 42. electronic payments contents'Assessment Task 43. employee time sheet#Assessment Task 44. payroll reports0Assessment Task 45. payroll reports time periods*Assessment Task 46. payroll reconciliation9Assessment Task 47. superannuation superannuation payable9Assessment Task 48. superannuation superannuation payable)Assessment Task 49. employer ATO payments*Assessment Task 50. PAYG payment summaries*Assessment Task 51. PAYG Payment summaries,Assessment Task 52. superannuation deadlines'Assessment Task 53. payroll end-of-year&Assessment Task 54. payroll processing-Assessment Task 55. payroll payment summaries-Assessment Task 56. payroll payroll summaries.Assessment Task 57. payroll payroll categories!Assessment Task 58. files empdupe'Assessment Task 59. superannuation RESC Assessment Task 60. tax assessed%Assessment Task 61. rates payroll tax&Assessment Task 62. payroll tax report-Assessment Task 63. benefits salary sacrifice,Assessment Task 64. leave long service leave%Assessment Task 65. rates night shift'Assessment Task 66. rates car allowance0Assessment Task 67. employee termination payment0Assessment Task 68. employee termination payment,Assessment Task 1. Setup Company Information:Assessment Task 2. Setup Hours in A Full Time Working Week4Assessment Task 3. Setup General Payroll Information2Assessment Task 4. Expenses Accounts Car Allowance=Assessment Task 5. Payroll Liabilities AccountsChild Support-Assessment Task 6. Setup Superannuation FundsKAssessment Task 7. Payroll Linked Accounts Default Employer Expense AccountHAssessment Task 8. Payroll Linked Accounts Default Wages Expense AccountIAssessment Task 9. Payroll Linked Accounts Default Tax/Deductions AccountDAssessment Task 11. Accounts List Summary Payroll Liability AccountsCAssessment Task 12. Accounts List Summary Payroll Expenses Accounts2Assessment Task 13. Payroll Security User Password;Assessment Task 14. Payroll Security Administrator Password,Assessment Task 15. Payroll Categories Wages,Assessment Task 16. Task Title Task Subtitle,Assessment Task 17. Task Title Task Subtitle6Assessment Task 18. Report Employee Employment Details6Assessment Task 19. Report Employee Employment Details6Assessment Task 20. Report Employee Employment Details6Assessment Task 21. Report Employee Employment Details-Assessment Task 22. Timesheet Calculate Hours0Assessment Task 23. Timesheet Manual Calculation0Assessment Task 24. Paycheque Manual Calculation0Assessment Task 25. Paycheque Manual Calculation0Assessment Task 26. Paycheque Manual Calculation0Assessment Task 27. Paycheque Manual Calculation0Assessment Task 28. Paycheque Manual Calculation0Assessment Task 29. Paycheque Manual Calculation*Assessment Task 30. Report Payroll Journal*Assessment Task 31. Report Payroll Journal*Assessment Task 32. Report Payroll Journal*Assessment Task 33. Report Payroll Journal1Assessment Task 34. Electronic Payments Bank File7Assessment Task 35. Report Electronic Payments Register7Assessment Task 36. Report Electronic Payments Register,Assessment Task 37. Process Payroll Payslips5Assessment Task 38. Report Payroll Register [Summary]5Assessment Task 39. Report Payroll Register [Summary]5Assessment Task 40. Report Payroll Register [Summary]5Assessment Task 41. Report Payroll Register [Summary]5Assessment Task 42. Report Payroll Register [Summary]5Assessment Task 43. Report Payroll Register [Summary]5Assessment Task 44. Report Payroll Register [Summary]1Assessment Task 45. Electronic Payments Bank File7Assessment Task 46. Report Electronic Payments Register7Assessment Task 47. Report Electronic Payments Register2Assessment Task 48. Report Profit & Loss Statement1Assessment Task 49. Report Standard Balance Sheet6Assessment Task 50. Payroll Reconciliation Gross Wages;Assessment Task 51. Payroll Reconciliation Payroll Expenses9Assessment Task 52. Payroll Reconciliation Superannuation:Assessment Task 53. Payroll Reconciliation Superannuation9Assessment Task 54. Payroll Reconciliation Superannuation2Assessment Task 55. Report Profit & Loss Statement6Assessment Task 56. Payroll Liabilities Superannuation6Assessment Task 57. Payroll Liabilities Superannuation<Assessment Task 58. Payroll Liabilities Child Support Agency1Assessment Task 59. Payroll Liabilities red cross3Assessment Task 60. BAS Reporting PAYG Tax Withheld3Assessment Task 61. BAS Reporting PAYG Tax Withheld=Assessment Task 62. BAS Reporting Business Activity Statement1Assessment Task 63. BAS Reporting BAS Transaction1Assessment Task 64. BAS Reporting BAS Transaction1Assessment Task 65. Report Standard Balance Sheet1Assessment Task 66. Report Standard Balance Sheet*Assessment Task 67. File Management Backup9Assessment Task 68. End-of-Payroll-Year Payment Summaries@Assessment Task 69. Report Payment Summaries Verification Report1Assessment Task 70. Report Payment Summary Report4Assessment Task 71. Payment Summaries Reconciliation4Assessment Task 72. Payment Summaries Reconciliation4Assessment Task 73. Payment Summaries Reconciliation4Assessment Task 74. Payment Summaries Reconciliation2Assessment Task 75. Payment Summaries EMPDUPE File1Assessment Task 76. Payment SummariesEMPDUPE File*Assessment Task 77. File Management BackuprKuLNfQ7V
XcYP[]`dgEj]lnqsu xIzO{1~g#Y+a,blGEpҏ.@`r TfEWZl
#5v&8ccB
f2ɀ
dMbP?_*+%&ffffff?'ffffff?(?)?"B333333?333333?le&<3cU}F}F
N
OP
H
H
H
HI
J
J
J
JK
L
M
MMG(PT
>@gg
f2ɀڰ
dMbP?_*+%;&ffffff?'ffffff?(?)?";333333?333333?&<3cU}EC}I9E}C}CSSSSS;SS ;S
sSSS
S;S;
l
llm Z FNSBKG405A Payroll Management
mmQQR
W
bR
W
bRQQR
j
jjUUU
j
jj UUU
k
kkRRT
V
cT
V
dTTRT$,S&R>@*
}%Please enter in the format dd/mm/yyyy.Please enter the date in the format dd/mm/yyyyEnq1
gg@h4h
Range2h4hRange1
f2ɀ0Xd
dMbP?_*+%;&ffffff?'ffffff?(?)?MaApeosPort-IV C5580 4dXXA4DINU"D?c SMTJFX ApeosPort-IV C5580 PCL 6InputBinFORMSOURCERESDLLUniresDLLPaperSizeA4ResolutionDPI600ColorModeColorCollateONDuplexNONEMediaTypeNoneOrientationPORTRAIT?FPXFd?FPXFd4A4d9.5dd............................ " dXX333333?333333?&<3U}IA}@B}LB}m
t}>}>} >}>@E;EDDEE@;E @
@@@
@@@@@@@@@@@@@@@@@@@
lllllm Z FNSBKG405A Payroll ManagementmmmmOOOoO
WbXoO
WbXoO
WbXoOWWXoO
_
Z
Z
p
a"
_Z
`!~
q?
]
[
\#
r?
Y
[
\$
r?Y
[
\%
r?Y
[
\&
r?
Y
[
\'
r?Y
[
\(
r?Y
[
\)
r?Y
[
\*
r?Y
[
\+r
Y
[
\,rY
[
\-rY
[
\.rY
[
\/rY
[
\0rY
[
\1rY
[
\2r[
[
\3rY
[
\4rY
[
\5r
Y
[
\6rY
[
\7rY
[
\8rY
[
\9rDkl W F*8444444404000000000400 @!@"@#@$@%@&@'@(@)@*@+@,@-@.@/@0@1t@2@3@4@5@6@7@8@9@:@;@<f@=@>@?@ Y
[
\: r!Y
![
!\;!r"Y
"[
"\<"r#Y
#[
#\=#r$Y
$[
$\>$r%[
%[
%\?%r
&Y
&[
&\@&r'Y
'[
'\A'r(Y
([
(\B(r)Y
)[
)\C)r*[
*[
*\D*r+Y
+[
+\E+r,Y
,[
,\F,r-Y
-[
-\G-r.Y
.[
.\H.r/Y
/[
/\I/r
0Y
0[
0\J0r1Y
1[
1\K1r2Y
2[
2\L2r3[
3[
3\M3r4Y
4[
4\N4r5Y
5[
5\O5r6Y
6[
6\P6r7Y
7[
7\Q7r8Y
8[
8\R8r9Y
9[
9\S9r
:[
:[
:\T:r;Y
;[
;\U;r<Y
<[
<\V<r=[
=[
=\W=r>Y
>[
>\X>r?]
?[
?\Y?rDl0000004000000000400000000040000@@A@B@C@D@E@F@G@H@I@J@K@L@M@N@O@P@QERESETEUEVEWEXEYEZE[E\E]E^E_E@]
@[
@\Z@rA]
A[
A\[ArB]
B[
B\\BrC]
C[
C\]CrC@
D]
D[
D\^DrE]
E[
E\_ErF]
F[
F\`FrG]
G[
G\aGrH]
H[
H\bHrI]
I[
I\cIrJ]
J[
J\dJrK]
K[!
K\eKrL]
L["
L\fLr
M]
M[#
M\oMrN]
N[$
N\pNrO]
O[%
O\qOrP]
P[&
P\gPnQ]
Q['
Q\h
QrfR]
R[(
R\i
RrfS]
S[)
S\r
SrfT]
T[*
T\s
TrfU]
U[+
U\t
UrfV]
V[u
V\v
VrfW]
W[,
W\w
WrfX]
X[-
X\w
XrfY]
Y[.
Y\j
YrfZ]
Z[/
Z\k
Zrf[]
[[0
[\x~
[u[f\]
\[1
\\y
\rf]]
][2
]\z
]rf^]
^[3
^\{
^rf_]
_[4
_\|~
_v_fDl000:40000000040004444444444>444`EaEbEcEdEeEfEgEhEiEjEkElEmEnEoEpEqErEsEtEuEvEwExEyEzE{E|E}E~EE`]
`[5
`\}~
`v`fa]
a[6
a\~~
avafb]
b[7
b\
brfc]
c[8
c\
crfd]
d[9
d\~
dvdfe]
e[:
e\~
eveff]
f[;
f\~
fvffg]
g[<
g\~
gvgfh]
h[=
h\~
hvhfi]
i[>
i\~
ivifj]
j[?
j\
jrfk]
k^@
k\~
kvkfl]
l^A
l\~
lvlfm]
m^B
m\~
mvmfn]
n^C
n\
nrfo]
o^D
o\
orfp]
p^E
p\~
pvpfq]
q^F
q\
qrfr]
r^G
r\
rrfs]
s^H
s\~
svsft]
t^I
t\~
tvtfu]
u^J
u\~
uvufv]
v^K
v\~
vvvfw]
wwL
w\~
wvwfx]
x^M
x\~
xvxfy]
y^N
y\
yrfz]
z^O
z\
zrf{]
{^P
{\~
{v{f|]
|^Q
|\
|rf}]
}^R
}\
}rf~]
~^S
~\~
~v~f]
^T
\~
vfD l>>44>>>>>>4>>>44>44>>>>>>44>44>EEEEEEEEEEEEEEEEEEEEEEEEEE;v ; v v ; ]
^U
\~
vf]
^V
\~
vf]
^W
\~
vf]
^X
\
rf]
^Y
\~
vf]
^Z
\~
vf]
^[
\~
vf]
^\
\~
vf]
^]
\l~
vf]
^^
\m~
vf]
^_
\
rf]
^`
\
rf]
^a
\~
vf]
^b
\
rf]
^c
\n
rf]
^d
\
rf]
^e
\
rf]
^f
\
rf]
^g
\
rf]
^h
\~
vf]
^i
\~
vf]
^j
\~
vf]
^k
\~
vf]
^l
\
rf]
^m
\
rf]
^n
\
rf]gh~
i@e]
^
\
sf]
^
\
sf]
^
\
sf]
^
\
sf]
^
\
sfD l>>>4>>>>>>44>444444>>>>444(4444; ; ; ; ; v v ; v v ; ; ; ; ; v ; ; ; ; ; ; v v ; ; v v v v ; ]
^
\
sf]
^
\
sf]
^
\
sf]
^
\
sf]
^
\
sf]
^
\
sf]
^
\
sf]
^
\
sf]
^
\
sf]
^
\
sf]
^
\
sf]
^
\
sf]
^
\
sf]
^
\
sf]
^
\
sf]
^
\
sf]
^
\
sf]
^
\
sf]
^
\
sf]
^
\
sf]
^
\l
sf]
^
\m
sf]
^
\
sf]
^
\
sf]
^
\
sf]
^
\
sf]
^
\n
sf]
^
\
sf]
^
\
sf]
^
\
sf]
^
\
sf]
^
\
sfD l4444444444444444444444444444444v ; ; ; v v ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ]
^
\
sf]
^
\
sf]
^
\
sf]
^
\
sf]
^
\
sf]
^
\
sfDl444444; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; 8
f>@dfbA
4@A,B,C,D,E,F, Invalid ResponsePlease enter A,B,C,D,E or F
Please enter A,B,C,D,E or FABCDEFabcdef L\]Instruction/Please enter Dollar Value upto 2 decimals only
.Please enter Dollar Value upto 2 decimals only e eA[[_adikmppsx{{~Invalid ResponseBPlease enter Y if you are submitting the required electronic file
Please enter Y or N only
YNynVX^^jjnoqryz|}<poPYYOUbcgg@h4h Range2h4hRange1qq
rMr@f2Table221MODULE8,Garamondh]u #\_uH q[) 4= = 2au,= 2ASSESSMENT TASK8,Garamondh]u #\_uH q[) 4= = 2au,=
3QUESTION8,Garamondh]u #\_uH q[) 4= = 2au,= 4RESPONSE0.Garamond]u #\_uH q[) 4= = 2au,= 6TASK ID7Garamond]u #\_uH q[) 4= = 2au,=
ww8,Garamond w)wDTableStyleMedium25wwTable2
Oh+'0@HXh
IBIS2IBIS2Microsoft Excel@{Bw@hyk՜.+,0HPX`hp
x
InstructionsDeclarationAssessments Submission''Assessments Submission'!_Toc303855368''Assessments Submission'!_Toc303855369''Assessments Submission'!_Toc303855370''Assessments Submission'!_Toc303855371''Assessments Submission'!_Toc303855372''Assessments Submission'!_Toc303855373Worksheets
Named Ranges
!"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~Root Entry F@,`WorkbookSummaryInformation(DocumentSummaryInformation8