{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Instructions","Employee_Onboard","Revision detail"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":1,"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":"Instructions","index":0,"n_rows":32,"n_cols":11,"rows_kept":32,"cut":false,"hidden":false,"merged":[[1,1,1,19],[31,3,31,9]]}
[]
[null,"Welcome to the Employee Data Loadsheets"]
[]
[null,"This loadsheet enables a client to upload employee data into Ascender Pay with a minimum of effort. All the relevant data checking and validation is done within the load process."]
[]
[null,"These loadsheets work as follows:"]
[null,"1) The employee data is entered into the Employee_Onboard sheet"]
[null,"2) The loadsheet is saved as a CSV file into the Target Folder (as specified on the Instructions tab) via the Create button on the loadsheet"]
[null,"3) In Ascender Pay Express on the Onboarding screen, use the 'Load Csv Data' button to load the data from the file into the application."]
[null,"4) Validate the data and submit to Ascender Pay when the data is verified."]
[null,"5) Once loaded, all data should be \"spot checked\" within  Ascender Pay for accuracy"]
[]
[null,"Note to User:"]
[null,"The User should double-check their data sheets for format and accuracy prior to creating the CSV for uploading into Ascender Pay."]
[]
[null,"Data Components:"]
[null,"The data in the loadsheet contains data across multiple components within Ascender Pay. These can be identified as follows:"]
[null,"Component",null,null,null,null,"Mandatory/Optional",null,null,null,"All mandatory columns in the loadsheet can be identified by Italics headings"]
[null,"Employee Data",null,null,null,null,"Mandatory"]
[null,"Equal Opportunity (EEO) details",null,null,null,null,"Optional"]
[null,"Passport/Visa details",null,null,null,null,"Optional"]
[null,"Bank details (single entry only)",null,null,null,null,"Optional",null,null,null,"Please Note: For bank details, if pay method is B then the BSB and account fields are mandatory."]
[null,"Tax details",null,null,null,null,"Optional"]
[null,"Australian Tax File Number Declaration details",null,null,null,null,"Optional"]
[null,"Emergency Contact details (single entry only)",null,null,null,null,"Optional"]
[null,"Position hiring into details (single entry only)",null,null,null,null,"Mandatory"]
[null,"Superannuation details (single entry only)",null,null,null,null,"Optional"]
[null,"Australian Superannuation details",null,null,null,null,"Optional"]
[]
[]
[null,"Output Files"]
[null,null,"Target Folder  ","C:\\temp"]

{"sheet":"Employee_Onboard","index":1,"n_rows":3,"n_cols":115,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["EmployeeID","Surname","First_Name","Second_Name","Third_Name","Preferred_Name","Title","Previous_Surname","Date_Of_Birth (DD/MM/YYYY)","Gender","First_Commencement_Date (DD/MM/YYYY)","Aboriginal_Descent","Citizenship","Country_Of_Origin","Cultural_Background","Disability","Disability_Type","Disability_Work_Modifications","Disability_Assistance","Ethnicity","IWI","Language_Background","Language_First","Language_Home","Marital_Status","Residency_Status","Tax_Organisation_ID","Reference_Emp","Address_1","Address_2","Town_Suburb","Country","State_Code","Post_Code","Address_1_Post","Address_2_Post","Town_Suburb_Post","Country_Post","State_Code_Post","Post_Code_Post","Home_Phone","Work_Phone","Mobile_Phone","Work_Mobile_Phone","Other_Phone","Email_Address_Personal","Email_Address_Work","Passport_ID","Expiry_Date (DD/MM/YYYY)","Passport_Issued_Location","Passport_Country","Passport_Sighted","Visa_ID","Visa_From_Date (DD/MM/YYYY)","Visa_To_Date (DD/MM/YYYY)","Visa_Type","Pay_Method","Branch_BSB_ID","Account_Name","Account_Number","Reference_Bank","Currency","Surname_Emer","First_Name_Emer","Title_Emer","Relationship_Emer","Address_Emer","Phone_Home_Emer","Phone_Work_Emer","Phone_Mobile_Emer","Email_Emer","Tax_Code","Tax_Scale","Start_Date (DD/MM/YYYY)","End_Date (DD/MM/YYYY)","Reference_Tax","TFN_Entry_Date (DD/MM/YYYY)","No_TFN","TFN_Exempt_Under_18","TFN_Exempt_Pensioner","Basis_Of_Payment","Surname_Changed","Australian_Resident","Tax_Free_Threshold","Family_Tax_Benefit","Help_Debt","Financial_Supplement_Debt","Super_Pension_Rebate","Trade_Support_Loan","Payee_Signature_Present","Payee_Signature_Date (DD/MM/YYYY)","Position_ID","Commence_Date (DD/MM/YYYY)","Position_Title","Occup_End_Date","Super_Code","Employer_Amount","Employer_Percent","Employee_Amount","Employee_Percent","Reference_Super","Policy_Number","SGC_Scheme","Aust_Fund_ID","SMSF_Fund_Name","SMSF_Address_1","SMSF_Address_2","SMSF_Town_Suburb","SMSF_State_Code","SMSF_Post_Code","SMSF_Phone_Number","SMSF_Service_Address","SMSF_Branch_BSB_ID","SMSF_Account_Number","SMSF_Account_Name"]
["Insert Employee Onboard records below. Please read the Instruction on First Tab  before use."]
["ONBOARD","Watson","Joanne","May",null,"Jo","Mrs","Johnson","1996-06-29","F","2015-05-23","N","AUST","ENG","Y",6,3,"N","SS",1,"A","ESB",1,"ENG","MAR","Y",123456789,"Barry Smith","21 Main St",null,"Newtown","Australia","NSW",2121,"21 Main St",null,"Newtown","Australia","NSW",2122,5234533,231232331,400111222,35345252323,"1212123","jowatson@email.com","jowatson@work.com","M342874","2023-09-27","Australia","AU","Y","AUPR32453","2020-02-02","2023-08-27","EMP","B","016000","Jo and John Watson",456545,null,"AUD","Watson","John","Mr","Husband",null,456767445,987767653,9876765432,"johnwatson@email.com","TAX","2B","2022-12-12","2023-12-11",null,"2022-12-12","Y","N","N","F","Y","Y","Y","N","N","N","N","N","Y","2020-08-22","SAL001","2020-08-22","HR Manager","2055-08-22","CHOIP",null,"10",null,null,"Super Ref",321321321,"A","PTC0133AU","A","A","A","A","A","A",123,"AA","AA",123,"AA"]

{"sheet":"Revision detail","index":2,"n_rows":4,"n_cols":5,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Revision","Date","Author","WO#","Details"]
["1.0","2020-12-18","Gokul","Express 1.8","Initial Version"]
[1.1000000000000001,"2021-04-12","S.Rockman","Express 1.9","Modified instructions, loadsheet headings and dummy record"]
[1.1200000000000001,"2022-05-24","Gokul","Express 1.12","Added occup end date"]