{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["InputSheet"],"not_rendered":{"charts":0,"images":0,"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":"InputSheet","index":0,"n_rows":53,"n_cols":27,"rows_kept":53,"cut":false,"hidden":false,"merged":[[1,1,1,6],[39,14,43,18]]}
[]
[null,"HOLIDAY PAY ACCRUAL CALCULATOR"]
[]
[null,"(Note:  An accrual may also be needed for sick "]
[null,"leave and medical & life insurance if not prepaid.)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[]
[null,"What is your business's financial year end:"]
[]
[]
[]
[null,"When does your holiday year end:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[]
[]
[null,"Are employees permitted to \"carry over\"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,"any untaken holidays into the following "]
[null,"holiday year?"]
[]
[null,{"$f":"IF(AND(T5=T11,T14=2),\"Based on your input, you do not need to accrue for holiday pay\",\"Accrual needed\")","v":"Accrual needed"},null,null,null,null,null,null,null,{"$f":"IF(B18=\"Accrual needed\",1,0)","v":1}]
[]
[null,"Do you want to calculate the accrual for ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,"holiday pay?"]
[]
[]
[null,"What's your best estimate of profit before"]
[null,"tax for the financial year in question?",null,null,null,null,null,10000]
[null,"Employee name or number",null,null,null,"Untaken holidays brought forward from previous year",null,"Holiday days NOT taken at your business's year end",null,"Total entitlement to untaken holiday days",null,"Annual salary",null,"Accrual required"]
[null,"If an employee starts and / or leaves during a holiday year, check their entitlement",null,null,null,null,null,null,null,null,null,null,null,"£"]
[null,"Joes Bloggs",null,null,null,3,null,5,null,{"$f":"IF($T$14=2,H28,F28+H28)","v":8},null,20000,null,{"$f":"J28*L28/365*$J$18","v":438.35616438356163}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF($T$14=2,H29,F29+H29)","v":0},null,null,null,{"$f":"J29*L29/365","v":0}]
[null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,"No"]
[null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,"Your total holiday pay accrual is:",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N28:N39)","v":438.35616438356163},{"$f":"IF(H25*0.1<N40,\"You need to make a provision for holiday pay\",\"You may not need a provision because it may be immaterial.  You should discuss with your accountant.\")","v":"You may not need a provision because it may be immaterial.  You should discuss with your accountant."}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-01-31"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-02-28"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-03-31"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-04-30"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-05-31"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-06-30"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-07-31"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-08-31"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-09-30"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-10-31"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-11-30"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-12-31"]