{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Emp Details","P8","P8Declaration","P8NilDeclaration","data","list"],"not_rendered":{"charts":0,"images":20,"macros":1,"external_links":0,"defined_names":10,"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":"Emp Details","index":0,"n_rows":39,"n_cols":22,"rows_kept":39,"cut":false,"hidden":false,"merged":[[35,5,37,20],[19,5,19,20],[22,4,22,5],[25,5,25,20],[1,3,2,22],[7,5,7,20],[4,4,4,5],[16,4,16,5],[13,5,13,20],[10,4,10,5]]}
[]
[null,null,null,"Employer Details"]
[]
[]
[null,null,null,null,"1.)",null,"Employer's Name"]
[]
[]
[]
[]
[]
[null,null,null,null,"2.)",null,"Employer's Tax Reference Number"]
[]
[]
[]
[]
[]
[null,null,null,null,"3.)",null,"Employer's PAYE Reference"]
[]
[]
[]
[]
[]
[null,null,null,null,"4.)",null,"P8 Tax Year"]
[]
[]
[null,null,null,null,null,"2022/2023"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,{"$f":"CONCATENATE(\"You are required to make returns in respect of all employees' Emoluments, Tax Deducted and Social Insurance Contributions for the period 1st July \",LEFT(F26,4),\" to 30 June \",RIGHT(F26,4),\" and return to the Income Tax Office by no later than 31st July \",RIGHT(F26,4),\".\")","v":"You are required to make returns in respect of all employees' Emoluments, Tax Deducted and Social Insurance Contributions for the period 1st July 2022 to 30 June 2023 and return to the Income Tax Office by no later than 31st July 2023."}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"P8 v1.4"]

{"sheet":"P8","index":1,"n_rows":8,"n_cols":15,"rows_kept":8,"cut":false,"hidden":true,"merged":[[0,2,0,14],[2,8,4,8],[2,14,4,14],[2,12,4,12],[2,13,4,13],[1,2,1,5],[2,2,4,2],[2,3,4,3],[2,9,4,9],[2,10,4,10],[2,11,4,11],[2,4,4,4],[2,5,4,5],[2,6,4,6],[2,7,4,7]]}
[null,null,{"$f":"CONCATENATE(\"LIST OF EMPLOYEES FOR THE TAX YEAR 1ST JULY \",LEFT('Emp Details'!F26,4),\" TO 30TH JUNE \",RIGHT('Emp Details'!F26,4))","v":"LIST OF EMPLOYEES FOR THE TAX YEAR 1ST JULY 2022 TO 30TH JUNE 2023"}]
[]
[null,null,"Tax Payer Ref","Surname(s)","Forename(s)","Type of     salary","From Week No.","To    Week No.","Contribution                    Class Code                      ","Total weekly contributions ","Total employee contributions ","Total employer contributions","Total employee/ employer contributions","Gross            Salary","Tax             Deducted"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"£","£","£","£","£"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K7<>\"\",K7+L7,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,"TOTAL",{"$f":"SUM(K7:OFFSET(K8,-1,0))","v":0},{"$f":"SUM(L7:OFFSET(L8,-1,0))","v":0},{"$f":"SUM(M7:OFFSET(M8,-1,0))","v":0},{"$f":"SUM(N7:OFFSET(N8,-1,0))","v":0},{"$f":"SUM(O7:OFFSET(O8,-1,0))","v":0}]

{"sheet":"P8Declaration","index":2,"n_rows":77,"n_cols":16,"rows_kept":77,"cut":false,"hidden":true,"merged":[[76,4,76,15],[24,3,24,16],[1,15,2,17],[3,12,3,17],[5,2,5,9],[5,12,5,14],[11,2,11,17],[13,8,13,16],[15,8,15,16],[17,8,17,16],[19,8,19,16],[21,14,21,16],[23,14,23,16],[25,2,25,17],[27,8,27,16],[29,8,29,16],[31,2,31,17],[33,7,33,9],[33,11,33,13],[33,15,33,17],[51,6,51,16],[34,7,34,9],[34,11,34,13],[34,15,34,17],[36,15,36,17],[38,15,38,17],[40,15,40,17],[42,15,42,17],[43,4,43,17],[44,2,44,17],[49,6,49,16],[33,3,34,6],[64,4,64,16],[66,4,66,16],[69,4,69,15],[53,6,53,16],[55,6,55,16],[57,6,57,16],[59,3,59,16],[61,3,61,16],[62,4,62,16]]}
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"000008820192020P8   "]
[]
[null,null,"Employer's Annual Statement, Declaration And Certificate",null,null,null,null,null,null,null,null,null,{"$f":"'Emp Details'!F26","v":"2022/2023"},null,null," FORM P8"]
[]
[null,null,"Employers' Name",null,null,null,null,null,null,null,null,null,null,null,"Employer's Reference"]
[null,null,{"$f":"'Emp Details'!F8","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Emp Details'!F20","v":0}]
[]
[]
[null,null,"Summary of Salaries, Tax Deducted and Tax Paid"]
[]
[null,null,null,"Total emoluments",null,null,null,null,{"$f":"'P8'!N8","v":0}]
[]
[null,null,null,"Total tax deducted",null,null,null,null,{"$f":"'P8'!O8","v":0}]
[]
[null,null,null,"Total tax already paid"]
[]
[null,null,null,"Amount outstanding",null,null,null,null,{"$f":"IFERROR(I16-I18,\"\")","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
[null,null,"Summary of Benefit In Kind and Tax Paid by Employer"]
[]
[null,null,null,"Amount of Benefit"]
[]
[null,null,null,"Total tax already paid"]
[]
[null,null,"Social Insurance Contributions Summary"]
[]
[null,null,null,"Total social insurance deducted",null,null,null,"Employer's Share",null,null,null,"Employee's Share",null,null,null,"Total Contributions"]
[null,null,null,null,null,null,null,{"$f":"'P8'!L8","v":0},null,null,null,{"$f":"'P8'!K8","v":0},null,null,null,{"$f":"H35+L35","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total social insurance already paid "]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Amount outstanding ",{"$f":"P35-P37","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
[null,null,"Contact details and other information"]
[]
[]
[]
[]
[null,null,null,"Name:"]
[]
[null,null,null,"Position:"]
[]
[null,null,null,"Email:"]
[]
[null,null,null,"Tel No:"]
[]
[null,null,null,"Date:",null,null,{"$f":"TEXT(TODAY(),\"dd/mm/yyyy\")","v":"27/06/2023"}]
[]
[null,null,null,"It is important that you carefully consider each of the statements below before you accept and submit this form. If necessary, please take independent legal advice. The consequences for any failure to comply with these statements are serious as you may be found guilty of an offence and therefore liable under Gibraltar law."]
[]
[null,null,null,"DECLARATION"]
[null,null,null,null,"I understand that the provision of any false, inaccurate or misleading information within this declaration is an offence under Gibraltar law."]
[]
[null,null,null,null,"I confirm I am authorised to make this declaration on behalf of this firm or business."]
[]
[null,null,null,null,"I declare and certify that all the particulars required to be entered on this form are in every respect, fully and truly according to the best of my knowledge and belief."]
[]
[]
[null,null,null,null,"Click here to generate the P8 Information file. You are required to upload it to: https://tax.egov.gi/uploads"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Click here to generate the P8 Information file. You are required to upload it to: https://tax.egov.gi/uploads"]

{"sheet":"P8NilDeclaration","index":3,"n_rows":77,"n_cols":16,"rows_kept":77,"cut":false,"hidden":true,"merged":[[66,4,66,16],[62,4,62,16],[37,3,38,16],[64,4,64,16],[51,6,51,16],[53,6,53,16],[55,6,55,16],[57,6,57,16],[59,3,59,16],[61,3,61,16],[49,6,49,16],[29,11,29,13],[29,15,29,17],[30,7,30,9],[30,11,30,13],[30,15,30,17],[30,3,30,6],[32,3,32,6],[34,3,34,6],[36,2,36,17],[32,7,32,9],[32,11,32,13],[32,15,32,17],[34,7,34,9],[34,11,34,13],[34,15,34,17],[69,4,69,15],[76,4,76,15],[25,8,25,16],[1,15,2,17],[3,12,3,17],[5,2,5,9],[5,12,5,14],[11,2,11,17],[13,8,13,16],[15,8,15,16],[17,8,17,16],[19,8,19,16],[21,2,21,17],[23,8,23,16],[27,2,27,17],[29,7,29,9]]}
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"000888820192020P8   "]
[]
[null,null,"Employer's Annual Statement, Declaration And Certificate",null,null,null,null,null,null,null,null,null,{"$f":"'Emp Details'!F26","v":"2022/2023"},null,null," FORM P8"]
[]
[null,null,"Employers' Name",null,null,null,null,null,null,null,null,null,null,null,"Employer's Reference"]
[null,null,{"$f":"'Emp Details'!F8","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Emp Details'!F20","v":0}]
[]
[]
[null,null,"Summary of Salaries, Tax Deducted and Tax Paid"]
[]
[null,null,null,"Total emoluments",null,null,null,null,0]
[]
[null,null,null,"Total tax deducted",null,null,null,null,0]
[]
[null,null,null,"Total tax already paid",null,null,null,null,0]
[]
[null,null,null,"Amount outstanding",null,null,null,null,0]
[]
[null,null,"Summary of Benefit In Kind and Tax Paid by Employer"]
[]
[null,null,null,"Amount of Benefit",null,null,null,null,0]
[]
[null,null,null,"Total tax already paid",null,null,null,null,0]
[]
[null,null,"Social Insurance Contributions Summary"]
[]
[null,null,null,null,null,null,null,"Employer's Share",null,null,null,"Employee's Share",null,null,null,"Total Contributions"]
[null,null,null,"Total social insurance deducted",null,null,null,0,null,null,null,0,null,null,null,0]
[]
[null,null,null,"Total social insurance already paid",null,null,null,0,null,null,null,0,null,null,null,0]
[]
[null,null,null,"Amount outstanding",null,null,null,0,null,null,null,0,null,null,null,0]
[]
[null,null,"Contact details and other information"]
[null,null,null,"I declare and certify that all the particulars required to be entered on this form are in every respect fully and truly stated according to the best of my knowledge and belief."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Name:"]
[]
[null,null,null,"Position:"]
[]
[null,null,null,"Email:"]
[]
[null,null,null,"Tel No:"]
[]
[null,null,null,"Date:",null,null,{"$f":"TEXT(TODAY(),\"dd/mm/yyyy\")","v":"27/06/2023"}]
[]
[null,null,null,"It is important that you carefully consider each of the statements below before you accept and submit this form. If necessary, please take independent legal advice. The consequences for any failure to comply with these statements are serious as you may be found guilty of an offence and therefore liable under Gibraltar law."]
[]
[null,null,null,"DECLARATION"]
[null,null,null,null,"I understand that the provision of any false, inaccurate or misleading information within this declaration is an offence under Gibraltar law."]
[]
[null,null,null,null,"I confirm I am authorised to make this declaration on behalf of this firm or business."]
[]
[null,null,null,null,"I declare and certify that all the particulars required to be entered on this form are in every respect, fully and truly according to the best of my knowledge and belief."]
[]
[]
[null,null,null,null,"Click here to generate the P8 Information file. You are required to upload it to: https://tax.egov.gi/uploads"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Click here to generate the P8 Information file. You are required to upload it to: https://tax.egov.gi/uploads"]

{"sheet":"data","index":4,"n_rows":9,"n_cols":23,"rows_kept":9,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,null,84721,"Man","Olo","Director",1,10,"SE (Self Employed)",10,0,0,0,25.55,20,0,3,0,0,0,0,0,0]
[null,null,84722,"Pitto","Joey","Director",1,10,"5E (Essential Services)",10,200,200,400,200,20,0,1,0,0,0,0,0,0]
[null,null,84722,"Pitto","Joey","Director",25,25,"SE (Self Employed)",1,0,0,0,25,20,0,2,0,0,0,0,0,0]

{"sheet":"list","index":5,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":true,"merged":[]}
["Income","Director","Pensioner","Student","Under_30_Days","Tax_Exempt"]
["ER (Earnings Related)","ER (Earnings Related)","XX (Person in receipt of a Pension)","SW (Students)","ER (Earnings Related)","ER (Earnings Related)"]
["PN (Pensioner)","PN (Pensioner)",null,null,"SE (Self Employed)","PN (Pensioner)"]
["EZ (Exempt)","EZ (Exempt)",null,null,"PN (Pensioner)","EZ (Exempt)"]
["DW (Detached Worker)","DW (Detached Worker)",null,null,"SP (Self Employed Pensioner)","DW (Detached Worker)"]
["SE (Self Employed)","SE (Self Employed)",null,null,"EZ (Exempt)","SE (Self Employed)"]
["SP (Self Employed Pensioner)","SP (Self Employed Pensioner)",null,null,"DW (Detached Worker)","SP (Self Employed Pensioner)"]
["5E (Essential Services)","5E (Essential Services)",null,null,null,"5E (Essential Services)"]
["MC (Maternity Credit)","MC (Maternity Credit)",null,null,null,"MC (Maternity Credit)"]
["MW (Married Woman)","MW (Married Woman)",null,null,null,"MW (Married Woman)"]
["IC (Sick Credits)","IC (Sick Credits)",null,null,null,"IC (Sick Credits)"]
["T2 (Trainee 2nd Employment)",null,null,null,null,"T2 (Trainee 2nd Employment)"]