{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Levy return form"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":4,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Levy return form","index":0,"n_rows":112,"n_cols":39,"rows_kept":112,"cut":false,"hidden":false,"merged":[[8,3,8,6],[11,0,11,3],[69,4,69,7],[69,8,69,11],[13,9,13,10],[14,9,14,10],[13,1,13,3],[12,1,12,3],[10,6,11,7],[14,1,14,3],[13,7,13,8],[14,7,14,8],[19,7,19,8],[20,7,20,9],[113,0,113,9],[111,0,112,9],[110,0,110,9],[15,1,15,3],[16,1,16,3],[20,1,20,3],[27,4,27,7],[67,0,67,7],[107,3,107,5],[105,0,105,1],[7,0,7,14],[106,0,106,1],[107,0,107,1],[108,0,108,1],[109,0,109,1],[104,0,104,4],[18,0,18,3],[19,1,19,3],[17,7,17,8],[18,7,18,8],[23,0,24,0],[23,1,24,1],[23,2,24,6],[22,1,22,3],[21,1,21,3],[8,0,8,2]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date Levy Received",null,null,"DIR ISSUES",null,null,null,null,null,null,null,null,null,null,"Checked","F","F","January",2005,"01","L","F","NSW",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date Levies Paid",null,null,"LEVY TYPE","ELECTRONIC",null,null,null,null,null,null,null,null,null,"Not checked","M","P","February",2006,"02","W","P","QLD",2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date Payment Receipted",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C","March",2007,"03",null,"C","WA",3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Receipt Amount",null,null,"Check Prev Levy Posted in BD ",null,null,null,null,null,null,null,null,null,null,null,null,null,"April",2008,"04",null,"L","VIC",4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ready to be Allocated",null,null,"Data Integrity' Report, Check Prev & Save to Spreadsheet",null,null,null,null,null,null,null,null,null,null,null,null,null,"May",2009,"05",null,"W","NT",4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date Posted",null,null,"New Entrants - Bluedoor Search Prior to Uploading",null,null,null,null,null,null,null,null,null,null,null,null,null,"June",2010,"06",null,null,"TAS",5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Processor",null,null,"Balance Levy to Entitlement Report",null,null,null,null,null,null,null,null,null,null,null,null,null,"July",2011,null,null,null,"SA",6]
["ADJUSTMENT LEVY ADVICE FORM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Drivers Licence Attached",null,null,"; from T2, all the way down to last employee",null,null,null,null,null,null,null,null,null,null,null,null,null,"August",2012,null,null,null,"ACT"]
["Please email completed forms to: ",null,null,"levy@coallsl.com.au",null,null,null,null,null,null,"1930-01-01",null,null,null,null,null,null,null,"Capital H in A1",null,null,null,null,null,null,null,null,null,null,null,null,null,"September",2013,null,null,null,"Other"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"K11-31","v":"2009-12-01"},null,null,null,null,null,null,null,"Payroll period END DATE in B1",null,null,null,null,null,null,null,null,null,null,null,null,null,"October",2014]
[null,null,null,null,null,null,"LEVY FOR THE ",null,"MONTH","January",{"$f":"DATEVALUE(CONCATENATE(\"01\",\"/\",J11,\"/\",J12))","v":"2010-01-01"},null,null,null,null,null,null,null,"AUTO SUM 'eligible wages' & 'total levy paid', ensure they match the levy",null,null,null,null,null,null,null,null,null,null,null,null,null,"November",2015]
["Employer details",null,null,null,null,null,null,null,"YEAR",2010,{"$f":"K11+31","v":"2010-02-01"},null,null,null,null,null,null,null,"Type Total Wages into D1, and expand cells",null,null,null,null,null,null,null,null,null,null,null,null,null,"December",2016]
["Employer ID:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Type total levy into E1, and expand cells",null,null,null,null,null,null,null,null,null,null,null,null,null,null,2017]
["Company name:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Type total number of employee into C1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,2018]
["ABN:",null,null,null,{"$f":"LEN(SUBSTITUTE(B15,\" \",\"\"))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"D, from A2 all the way down to last employee",null,null,null,null,null,null,null,null,null,null,null,null,null,null,2019]
["Contact name:",null,null,null,null,null,"ff",null,null,null,null,null,null,null,null,null,null,null,"Removed Work status from first employee",null,null,null,null,null,null,null,null,null,null,null,null,null,null,2020]
["Contact no:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Delete a few hundred line from the bottom, ensuring AUTO SUM is deleted",null,null,null,null,null,null,null,null,null,null,null,null,null,null,2021]
[null,null,null,null,null,null,null,"Total eligible wages:",null,{"$f":"ROUND(SUM(Table1[Correct Eligible wages $])-SUM(Table1[Original Eligible wages $ ]),2)","v":0},{"$f":"IF($K$11>=DATEVALUE(\"2018/07/01\"),ROUND(($J$18*2)/100,2),ROUND(($J$18*2.7)/100,2))","v":0},null,null,null,null,null,null,null,"Upload to Bluedoor /Check Payroll Date /Check Receipt Total",null,null,null,null,null,null,null,null,null,null,null,null,null,null,2022]
["Authorised officer",null,null,null,null,null,null,"Total levy payable:",null,{"$f":"ROUND(SUM(Table1[Correct Levy to be paid])-SUM(Table1[Original Levy paid $]),2)","v":0},null,null,null,null,null,null,null,null,"Copy Case Notes to Spreadsheet - SAVE - CHECK Case Notes and make notes against them"]
["Name:",null,null,null,null,null,null,"Levy amount to pay:",null,{"$f":"ROUND($M$102,2)","v":0},null,null,null,null,null,null,null,null,"Full Time - Check Correct Start Dates in the Grid"]
["Position held:",null,null,null,null,null,null,{"$f":"IF($J$19=$K$18,\"\",IF(OR($J$19-$K$18>2,$J$19-$K$18<-2), \"Incorrect levy payable amount\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,"Amend Employee Details in the Grid - All Green - PRINT LETTERS PRIOR TO POSTING LEVY"]
["Email address:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Casual - If Start Date in the Prior Month - Amend Service History & Hours After Posting the Levy"]
["Contact no:",null,null,null,false,null,null,null,null,null,null,null,null,null,null,null,null,null,"Process Terminations via Grid/Manual & Check End Date"]
[null,null,"I certify that the details shown below are correct for each of the eligible employees listed.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Email to Employer for any Other Info & Save to Employer ID"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Add Notes - LWOP /Mat Leave /Worker Comp "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total checked",{"$f":"COUNTIF(T4:T25,\"Checked\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total not checked",{"$f":"COUNTIF(T4:T25,\"Not Checked\")","v":0}]
["ENTRANTS",null,null,null,"Employee Postal Address"]
["LSL number","Surname","Given name(s)","Gender","Street","Suburb","State","Postcode","Work status F/P/C","Date of birth (dd/mm/yyyy)","Start date","Reason for submitting adjustment"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["EXITS"]
[]
["LSL number","Surname","Given name(s)","Date of birth (dd/mm/yyyy)","Cessation date","Cessation code","Reason for submitting adjustment"]
[]
[]
[]
[]
[]
[]
["Cessation Codes","01 – Retirement","02 –Ill health/ Incapacity","03 – Death","04 – Redundancy","05 – Resignation/ End of contract","06 – Dismissal"]
[]
["PERIODS OF UNAUTHORISED ABSENCE OR PERIODS OF UNPAID LEAVE (L) AND PERIODS OF WORKERS COMPENSATION LEAVE (W)"]
[]
["LSL number","Surname","Given name(s)","Date of birth (dd/mm/yyyy)","Type of leave                           (L or W)","Date leave commenced","Date leave concluded ","Reason for submitting adjustment"]
[]
[]
[]
[]
[]
[]
["EMPLOYEE DETAILS"]
[]
[null,null,null,null,"Details originally supplied on levy",null,null,null,"New details or details to be adjusted"]
["LSL number","Surname","Given name(s)","Date of birth (dd/mm/yyyy)","Original Work Status                         ( F / P / C / L / W)","Original Hours worked                    (if P or C)","Original Eligible wages $ ","Original Levy paid $","Correct Work Status                         ( F / P / C / L / W)","Correct Hours worked                    (if P or C)","Correct Eligible wages $","Correct Levy to be paid","Difference Eligible wages $","Levy amount to pay","Reason for submitting adjustment","Comments"]
[null,null,null,null,null,null,0,0,null,null,null,null,{"$f":"Table1[[#This Row],[Correct Eligible wages $]]-Table1[[#This Row],[Original Eligible wages $ ]]","v":0},{"$f":"Table1[[#This Row],[Correct Levy to be paid]]-Table1[[#This Row],[Original Levy paid $]]","v":0}]
[null,null,null,null,null,null,0,0,null,null,null,null,{"$f":"Table1[[#This Row],[Correct Eligible wages $]]-Table1[[#This Row],[Original Eligible wages $ ]]","v":0},{"$f":"Table1[[#This Row],[Correct Levy to be paid]]-Table1[[#This Row],[Original Levy paid $]]","v":0}]
[null,null,null,null,null,null,0,0,null,null,null,null,{"$f":"Table1[[#This Row],[Correct Eligible wages $]]-Table1[[#This Row],[Original Eligible wages $ ]]","v":0},{"$f":"Table1[[#This Row],[Correct Levy to be paid]]-Table1[[#This Row],[Original Levy paid $]]","v":0}]
[null,null,null,null,null,null,0,0,null,null,null,null,{"$f":"Table1[[#This Row],[Correct Eligible wages $]]-Table1[[#This Row],[Original Eligible wages $ ]]","v":0},{"$f":"Table1[[#This Row],[Correct Levy to be paid]]-Table1[[#This Row],[Original Levy paid $]]","v":0}]
[null,null,null,null,null,null,0,0,null,null,null,null,{"$f":"Table1[[#This Row],[Correct Eligible wages $]]-Table1[[#This Row],[Original Eligible wages $ ]]","v":0},{"$f":"Table1[[#This Row],[Correct Levy to be paid]]-Table1[[#This Row],[Original Levy paid $]]","v":0}]
[null,null,null,null,null,null,0,0,null,null,null,null,{"$f":"Table1[[#This Row],[Correct Eligible wages $]]-Table1[[#This Row],[Original Eligible wages $ ]]","v":0},{"$f":"Table1[[#This Row],[Correct Levy to be paid]]-Table1[[#This Row],[Original Levy paid $]]","v":0}]
[null,null,null,null,null,null,0,0,null,null,null,null,{"$f":"Table1[[#This Row],[Correct Eligible wages $]]-Table1[[#This Row],[Original Eligible wages $ ]]","v":0},{"$f":"Table1[[#This Row],[Correct Levy to be paid]]-Table1[[#This Row],[Original Levy paid $]]","v":0}]
[null,null,null,null,null,null,0,0,null,null,null,null,{"$f":"Table1[[#This Row],[Correct Eligible wages $]]-Table1[[#This Row],[Original Eligible wages $ ]]","v":0},{"$f":"Table1[[#This Row],[Correct Levy to be paid]]-Table1[[#This Row],[Original Levy paid $]]","v":0}]
[null,null,null,null,null,null,0,0,null,null,null,null,{"$f":"Table1[[#This Row],[Correct Eligible wages $]]-Table1[[#This Row],[Original Eligible wages $ ]]","v":0},{"$f":"Table1[[#This Row],[Correct Levy to be paid]]-Table1[[#This Row],[Original Levy paid $]]","v":0}]
[null,null,null,null,null,null,0,0,null,null,null,null,{"$f":"Table1[[#This Row],[Correct Eligible wages $]]-Table1[[#This Row],[Original Eligible wages $ ]]","v":0},{"$f":"Table1[[#This Row],[Correct Levy to be paid]]-Table1[[#This Row],[Original Levy paid $]]","v":0}]
[null,null,null,null,null,null,0,0,null,null,null,null,{"$f":"Table1[[#This Row],[Correct Eligible wages $]]-Table1[[#This Row],[Original Eligible wages $ ]]","v":0},{"$f":"Table1[[#This Row],[Correct Levy to be paid]]-Table1[[#This Row],[Original Levy paid $]]","v":0}]
[null,null,null,null,null,null,0,0,null,null,null,null,{"$f":"Table1[[#This Row],[Correct Eligible wages $]]-Table1[[#This Row],[Original Eligible wages $ ]]","v":0},{"$f":"Table1[[#This Row],[Correct Levy to be paid]]-Table1[[#This Row],[Original Levy paid $]]","v":0}]
[null,null,null,null,null,null,0,0,null,null,null,null,{"$f":"Table1[[#This Row],[Correct Eligible wages $]]-Table1[[#This Row],[Original Eligible wages $ ]]","v":0},{"$f":"Table1[[#This Row],[Correct Levy to be paid]]-Table1[[#This Row],[Original Levy paid $]]","v":0}]
[null,null,null,null,null,null,0,0,null,null,null,null,{"$f":"Table1[[#This Row],[Correct Eligible wages $]]-Table1[[#This Row],[Original Eligible wages $ ]]","v":0},{"$f":"Table1[[#This Row],[Correct Levy to be paid]]-Table1[[#This Row],[Original Levy paid $]]","v":0}]
[null,null,null,null,null,null,0,0,null,null,null,null,{"$f":"Table1[[#This Row],[Correct Eligible wages $]]-Table1[[#This Row],[Original Eligible wages $ ]]","v":0},{"$f":"Table1[[#This Row],[Correct Levy to be paid]]-Table1[[#This Row],[Original Levy paid $]]","v":0}]
[null,null,null,null,null,null,0,0,null,null,null,null,{"$f":"Table1[[#This Row],[Correct Eligible wages $]]-Table1[[#This Row],[Original Eligible wages $ ]]","v":0},{"$f":"Table1[[#This Row],[Correct Levy to be paid]]-Table1[[#This Row],[Original Levy paid $]]","v":0}]
[null,null,null,null,null,null,0,0,null,null,null,null,{"$f":"Table1[[#This Row],[Correct Eligible wages $]]-Table1[[#This Row],[Original Eligible wages $ ]]","v":0},{"$f":"Table1[[#This Row],[Correct Levy to be paid]]-Table1[[#This Row],[Original Levy paid $]]","v":0}]
[null,null,null,null,null,null,0,0,null,null,null,null,{"$f":"Table1[[#This Row],[Correct Eligible wages $]]-Table1[[#This Row],[Original Eligible wages $ ]]","v":0},{"$f":"Table1[[#This Row],[Correct Levy to be paid]]-Table1[[#This Row],[Original Levy paid $]]","v":0}]
[null,null,null,null,null,null,0,0,null,null,null,null,{"$f":"Table1[[#This Row],[Correct Eligible wages $]]-Table1[[#This Row],[Original Eligible wages $ ]]","v":0},{"$f":"Table1[[#This Row],[Correct Levy to be paid]]-Table1[[#This Row],[Original Levy paid $]]","v":0}]
[null,null,null,null,null,null,0,0,null,null,null,null,{"$f":"Table1[[#This Row],[Correct Eligible wages $]]-Table1[[#This Row],[Original Eligible wages $ ]]","v":0},{"$f":"Table1[[#This Row],[Correct Levy to be paid]]-Table1[[#This Row],[Original Levy paid $]]","v":0}]
[null,null,null,null,null,null,0,0,null,null,null,null,{"$f":"Table1[[#This Row],[Correct Eligible wages $]]-Table1[[#This Row],[Original Eligible wages $ ]]","v":0},{"$f":"Table1[[#This Row],[Correct Levy to be paid]]-Table1[[#This Row],[Original Levy paid $]]","v":0}]
[null,null,null,null,null,null,0,0,null,null,null,null,{"$f":"Table1[[#This Row],[Correct Eligible wages $]]-Table1[[#This Row],[Original Eligible wages $ ]]","v":0},{"$f":"Table1[[#This Row],[Correct Levy to be paid]]-Table1[[#This Row],[Original Levy paid $]]","v":0}]
[null,null,null,null,null,null,0,0,null,null,null,null,{"$f":"Table1[[#This Row],[Correct Eligible wages $]]-Table1[[#This Row],[Original Eligible wages $ ]]","v":0},{"$f":"Table1[[#This Row],[Correct Levy to be paid]]-Table1[[#This Row],[Original Levy paid $]]","v":0}]
[null,null,null,null,null,null,0,0,null,null,null,null,{"$f":"Table1[[#This Row],[Correct Eligible wages $]]-Table1[[#This Row],[Original Eligible wages $ ]]","v":0},{"$f":"Table1[[#This Row],[Correct Levy to be paid]]-Table1[[#This Row],[Original Levy paid $]]","v":0}]
[null,null,null,null,null,null,0,0,null,null,null,null,{"$f":"Table1[[#This Row],[Correct Eligible wages $]]-Table1[[#This Row],[Original Eligible wages $ ]]","v":0},{"$f":"Table1[[#This Row],[Correct Levy to be paid]]-Table1[[#This Row],[Original Levy paid $]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Table1[[#This Row],[Correct Eligible wages $]]-Table1[[#This Row],[Original Eligible wages $ ]]","v":0},{"$f":"Table1[[#This Row],[Correct Levy to be paid]]-Table1[[#This Row],[Original Levy paid $]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Table1[[#This Row],[Correct Eligible wages $]]-Table1[[#This Row],[Original Eligible wages $ ]]","v":0},{"$f":"Table1[[#This Row],[Correct Levy to be paid]]-Table1[[#This Row],[Original Levy paid $]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Table1[[#This Row],[Correct Eligible wages $]]-Table1[[#This Row],[Original Eligible wages $ ]]","v":0},{"$f":"Table1[[#This Row],[Correct Levy to be paid]]-Table1[[#This Row],[Original Levy paid $]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Table1[[#This Row],[Correct Eligible wages $]]-Table1[[#This Row],[Original Eligible wages $ ]]","v":0},{"$f":"Table1[[#This Row],[Correct Levy to be paid]]-Table1[[#This Row],[Original Levy paid $]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Table1[[#This Row],[Correct Eligible wages $]]-Table1[[#This Row],[Original Eligible wages $ ]]","v":0},{"$f":"Table1[[#This Row],[Correct Levy to be paid]]-Table1[[#This Row],[Original Levy paid $]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM($N$72:$N$101),2)","v":0}]
[]
["Please note: ","All data supplied must be complete and accurate to avoid processing delays. "]
["HOW TO MAKE YOUR PAYMENT"]
["EFT PAYMENTS TO:",null,"Commonwealth Bank - Brisbane"]
["Account Name:",null,"Coal Mining Industry (LSL Funding) Corp. – Levy Account"]
["BSB:",null,"064-000"]
["Account Number:",null,10753332]
["Reference:",null,"EMPLOYER ID MUST BE QUOTED AS REFERENCE WHEN MAKING THE PAYMENT"]
["Privacy Statement "]
["Personal information collected by Coal LSL is protected by the Privacy Act 1988. Our Privacy Policy is available at www.coallsl.com.au and sets out the primary purposes for which Coal LSL collects, uses and discloses your personal information. Coal LSL will not use or disclose your personal information for other purposes unless you consent or it is permitted to do so by the Privacy Act 1988."]