{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["HOME PAGE","RM FINANCE NEW - VAT ANALYSIS","RM FINANCE NEW - REC TO BANK","FMS","RM ACCOUNTS","VAT RETURN","System Admin"],"not_rendered":{"charts":0,"images":10,"macros":1,"external_links":3,"defined_names":69,"comments":3,"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":"HOME PAGE","index":0,"n_rows":41,"n_cols":16,"rows_kept":41,"cut":false,"hidden":false,"merged":[[18,11,18,14],[20,6,20,10],[28,4,28,5]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"2009-09-01"]
[]
[null,null,null,null,"SCHOOL NAME:",null,"Enfield",null,null,null,null,null,"ED NUMBER:",null,{"$f":"VLOOKUP(G21,Schoolnames,2,FALSE)","v":"0000"}]
[]
[null,null,null,"Instructions",null,null,null,null,null,null,null,null,"2022-04-01"]
[null,null,null,"Enter your school name from the drop down menu in cell G21"]
[null,null,null,"The school name and ED number will now appear on all the returns. (Please do not over-type these cells)."]
[null,null,null,"Completion of Returns"]
[null,null,null,"Please refer to the \"VAT - Instructions on completing and submitting the Monthly Returns\" for more detailed guidance and examples. "]
[]
[null,null,null,"VAT","All schools",null,"Cream tab",null,null,null,null,null,null,"VAT Return",null,"Due by"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"April",null,"22nd May"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"May",null,"22nd June"]
[null,null,null,"E-mail the completed workbook to: ",null,null,null,"schoolvatreturns@enfield.gov.uk",null,null,null,null,null,"June",null,"22nd July"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"July",null,"22nd August"]
[null,null,null,"Contacts",null,null,null,null,null,null,null,null,null,"August",null,"22nd September"]
[null,null,null,"Mahfuza Khanum",null,"mahfuza.khanum@enfield.gov.uk",null,null,null,"0208 132 1275",null,null,null,"September",null,"22nd October"]
[null,null,null,"Louise McNamara",null,"louise.mcnamara@enfield.gov.uk",null,null,null,"0208 132 1272",null,null,null,"October",null,"22nd November"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"November",null,"22nd December"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"December",null,"22nd January"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"January",null,"22nd February"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"February",null,"22nd March"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"March",null,"With closedown returns"]

{"sheet":"RM FINANCE NEW - VAT ANALYSIS","index":1,"n_rows":153,"n_cols":18,"rows_kept":153,"cut":false,"hidden":false,"merged":[[131,20,133,22],[135,17,136,20],[135,21,136,23],[125,17,125,20],[125,21,125,23],[126,17,128,20],[126,21,128,23],[131,23,133,24],[132,1,132,2],[132,3,132,8],[132,9,132,12],[132,13,132,16],[133,1,134,2],[133,3,134,8],[134,20,134,22],[134,23,134,24],[133,9,134,12],[133,13,134,16],[134,17,134,19],[130,1,131,2],[130,3,131,8],[130,9,131,12],[130,13,131,16],[130,17,130,19],[130,20,130,22],[130,23,130,24],[131,17,133,19],[129,21,129,23],[119,17,120,19],[119,20,120,22],[119,23,120,24],[120,1,121,2],[120,3,121,7],[120,8,121,14],[120,15,121,16],[121,17,122,19],[121,20,122,22],[126,24,128,24],[127,1,127,2],[127,3,127,9],[127,10,127,14],[127,15,127,16],[128,1,129,2],[128,3,129,9],[128,10,129,14],[128,15,129,16],[129,17,129,20],[125,1,126,2],[125,3,126,9],[125,10,126,14],[125,15,126,16],[124,15,124,16],[111,23,112,24],[112,1,113,2],[112,3,113,7],[112,8,113,14],[112,15,113,16],[113,17,114,19],[113,20,114,22],[113,23,114,24],[114,1,115,2],[121,23,122,24],[122,1,123,2],[122,3,123,14],[122,15,123,16],[123,17,124,19],[123,20,124,22],[123,23,124,24],[124,1,124,2],[124,3,124,7],[124,8,124,14],[117,20,118,22],[117,23,118,24],[118,1,119,2],[118,3,119,14],[118,15,119,16],[115,23,116,24],[116,1,117,2],[116,15,117,16],[117,17,118,19],[114,3,115,14],[114,15,115,16],[115,17,116,19],[115,20,116,22],[116,3,117,7],[116,8,117,14],[103,17,104,19],[103,20,104,22],[111,20,112,22],[105,23,106,24],[106,1,107,2],[106,3,107,14],[106,15,107,16],[107,17,108,19],[108,1,109,2],[108,3,109,7],[108,8,109,14],[104,3,105,7],[104,8,105,14],[104,15,105,16],[105,17,106,19],[105,20,106,22],[108,15,109,16],[109,17,110,19],[110,1,111,2],[110,3,111,14],[110,15,111,16],[111,17,112,19],[109,20,110,22],[109,23,110,24],[107,20,108,22],[107,23,108,24],[103,23,104,24],[104,1,105,2],[100,1,101,2],[100,3,101,7],[102,1,103,2],[102,3,103,14],[102,15,103,16],[97,23,98,24],[98,1,99,2],[101,20,102,22],[96,15,97,16],[97,17,98,19],[97,20,98,22],[101,23,102,24],[98,3,99,14],[98,15,99,16],[99,17,100,19],[99,20,100,22],[99,23,100,24],[100,8,101,14],[96,1,97,2],[96,3,97,7],[100,15,101,16],[101,17,102,19],[94,3,95,14],[94,15,95,16],[95,17,96,19],[95,20,96,22],[95,23,96,24],[96,8,97,14],[91,20,92,22],[91,23,92,24],[92,1,93,2],[92,3,93,7],[92,8,93,14],[92,15,93,16],[93,17,94,19],[93,20,94,22],[93,23,94,24],[94,1,95,2],[90,1,91,2],[90,3,91,14],[90,15,91,16],[91,17,92,19],[86,1,87,2],[86,3,87,14],[86,15,87,16],[87,17,88,19],[87,20,88,22],[87,23,88,24],[88,1,89,2],[89,20,90,22],[83,23,84,24],[84,1,85,2],[84,3,85,7],[84,8,85,14],[84,15,85,16],[89,23,90,24],[77,23,78,24],[79,20,80,22],[79,23,80,24],[81,23,82,24],[88,3,89,7],[88,8,89,14],[88,15,89,16],[89,17,90,19],[74,15,75,16],[75,17,76,19],[85,17,86,19],[82,3,83,14],[82,15,83,16],[83,17,84,19],[85,20,86,22],[85,23,86,24],[80,1,81,2],[80,3,81,7],[80,8,81,14],[80,15,81,16],[81,17,82,19],[81,20,82,22],[82,1,83,2],[83,20,84,22],[76,1,77,2],[76,3,77,7],[76,8,77,14],[76,15,77,16],[77,17,78,19],[77,20,78,22],[78,1,79,2],[78,3,79,14],[78,15,79,16],[79,17,80,19],[75,20,76,22],[71,23,72,24],[72,1,73,2],[72,3,73,7],[72,8,73,14],[72,15,73,16],[73,17,74,19],[73,20,74,22],[73,23,74,24],[74,1,75,2],[74,3,75,14],[70,1,71,2],[70,3,71,14],[70,15,71,16],[71,17,72,19],[71,20,72,22],[75,23,76,24],[63,15,63,16],[64,1,65,2],[64,3,65,7],[64,8,65,14],[64,15,65,16],[65,17,66,19],[62,17,64,19],[61,1,61,16],[61,17,61,24],[62,1,62,2],[62,3,62,7],[62,8,62,14],[62,15,62,16],[62,23,64,24],[63,1,63,2],[63,3,63,7],[63,8,63,14],[65,20,66,22],[65,23,66,24],[66,1,67,2],[66,3,67,14],[66,15,67,16],[67,17,68,19],[67,20,68,22],[67,23,68,24],[68,1,69,2],[68,3,69,7],[68,8,69,14],[68,15,69,16],[69,17,70,19],[69,20,70,22],[69,23,70,24],[57,1,59,16],[57,17,57,18],[57,19,57,21],[57,22,57,24],[58,17,58,18],[58,19,58,21],[58,22,58,24],[59,17,59,18],[59,19,59,21],[59,22,59,24],[55,17,56,18],[55,19,56,19],[55,20,56,20],[55,21,56,21],[55,22,56,22],[55,23,56,23],[55,24,56,24],[62,20,64,22],[54,17,54,18],[54,19,54,21],[53,1,53,2],[53,3,53,7],[53,8,53,14],[53,15,53,16],[56,1,56,2],[56,3,56,7],[56,8,56,14],[56,15,56,16],[54,1,55,2],[54,3,55,14],[54,15,55,16],[51,1,52,2],[51,3,52,14],[51,15,52,16],[51,17,51,18],[51,19,51,21],[52,17,53,18],[52,19,53,19],[52,20,53,20],[52,21,53,21],[52,22,53,22],[52,23,53,23],[52,24,53,24],[49,17,50,18],[49,19,50,19],[49,20,50,20],[49,21,50,21],[49,22,50,22],[49,23,50,23],[49,24,50,24],[46,22,47,22],[46,23,47,23],[46,24,47,24],[47,1,47,2],[47,3,47,7],[47,8,47,14],[47,15,47,16],[46,21,47,21],[50,1,50,2],[50,3,50,7],[50,8,50,14],[50,15,50,16],[48,1,49,2],[48,3,49,14],[48,15,49,16],[48,17,48,18],[48,19,48,21],[45,1,46,2],[45,3,46,14],[45,15,46,16],[45,17,45,18],[45,19,45,21],[46,17,47,18],[46,19,47,19],[46,20,47,20],[37,23,38,23],[37,24,38,24],[38,1,38,2],[38,3,38,7],[38,8,38,14],[38,15,38,16],[39,1,40,2],[39,3,40,14],[42,1,43,2],[42,3,43,14],[42,15,43,16],[42,17,42,18],[42,20,42,22],[43,17,44,18],[43,19,44,19],[43,20,44,20],[43,21,44,21],[43,22,44,22],[36,17,36,18],[36,20,36,22],[37,17,38,18],[37,19,38,19],[37,20,38,20],[37,21,38,21],[37,22,38,22],[36,1,37,2],[36,3,37,14],[36,15,37,16],[29,15,29,16],[28,23,29,23],[26,1,26,2],[26,3,26,7],[26,8,26,14],[26,15,26,16],[25,20,26,20],[25,21,26,21],[25,22,26,22],[25,23,26,23],[27,17,27,18],[27,21,27,23],[28,17,29,18],[28,19,29,19],[28,20,29,20],[28,21,29,21],[28,22,29,22],[27,1,28,2],[27,3,28,14],[27,15,28,16],[29,1,29,2],[29,3,29,7],[29,8,29,14],[24,1,25,2],[24,3,25,14],[24,15,25,16],[24,17,24,18],[24,21,24,23],[21,1,22,2],[21,3,22,14],[21,15,22,16],[22,23,23,23],[25,19,26,19],[23,1,23,2],[23,3,23,7],[23,8,23,14],[23,15,23,16],[17,1,17,2],[17,3,17,7],[17,8,17,14],[17,15,17,16],[18,1,19,2],[15,1,16,2],[15,3,16,14],[15,15,16,16],[20,1,20,2],[20,3,20,7],[20,8,20,14],[20,15,20,16],[16,23,17,23],[14,1,14,2],[14,3,14,7],[14,8,14,14],[14,15,14,16],[15,17,15,18],[18,3,19,14],[18,15,19,16],[18,17,18,18],[18,21,18,23],[19,17,20,18],[19,19,20,19],[19,20,20,20],[19,21,20,21],[19,22,20,22],[19,23,20,23],[0,14,0,24],[2,1,2,24],[4,1,4,5],[4,6,4,24],[6,1,6,11],[8,1,8,16],[8,17,8,24],[12,1,13,2],[12,3,13,14],[12,15,13,16],[11,1,11,2],[11,3,11,7],[11,8,11,14],[10,1,10,2],[10,3,10,7],[10,8,10,14],[10,15,10,16],[9,1,9,2],[9,3,9,7],[9,8,9,14],[43,23,44,23],[43,24,44,24],[44,1,44,2],[44,3,44,7],[40,23,41,23],[40,24,41,24],[41,1,41,2],[41,3,41,7],[41,8,41,14],[41,15,41,16],[39,15,40,16],[39,17,39,18],[39,20,39,22],[40,17,41,18],[40,19,41,19],[40,20,41,20],[40,21,41,21],[40,22,41,22],[44,8,44,14],[44,15,44,16],[34,24,35,24],[31,24,32,24],[30,1,31,2],[30,3,31,14],[30,15,31,16],[30,17,30,18],[30,21,30,23],[31,17,32,18],[31,19,32,19],[35,1,35,2],[35,3,35,7],[35,8,35,14],[35,15,35,16],[33,1,34,2],[33,3,34,14],[33,15,34,16],[33,20,33,22],[34,17,35,18],[34,19,35,19],[34,20,35,20],[34,21,35,21],[34,22,35,22],[33,17,33,18],[31,20,32,20],[31,21,32,21],[31,22,32,22],[31,23,32,23],[32,1,32,2],[32,3,32,7],[32,8,32,14],[32,15,32,16],[34,23,35,23],[28,24,29,24],[22,17,23,18],[22,19,23,19],[19,24,20,24],[21,17,21,18],[21,21,21,23],[22,20,23,20],[22,21,23,21],[22,22,23,22],[25,17,26,18],[22,24,23,24],[25,24,26,24],[16,24,17,24],[11,15,11,16],[9,21,11,21],[9,22,11,22],[9,15,9,16],[9,23,11,23],[9,24,11,24],[13,24,14,24],[12,17,12,18],[9,17,11,18],[9,19,11,19],[9,20,11,20],[12,21,12,23],[13,17,14,18],[13,19,14,19],[13,20,14,20],[13,21,14,21],[13,22,14,22],[13,23,14,23],[15,21,15,23],[16,17,17,18],[16,19,17,19],[16,20,17,20],[16,21,17,21],[16,22,17,22],[138,1,139,2],[138,3,139,14],[138,15,139,16],[139,17,140,20],[139,21,140,23],[139,24,140,24],[140,1,141,2],[136,3,136,7],[136,8,136,14],[136,15,136,16],[137,1,137,2],[137,3,137,7],[137,8,137,14],[137,15,137,16],[135,24,136,24],[136,1,136,2],[135,1,135,2],[135,3,135,7],[135,8,135,14],[135,15,135,16],[140,3,141,7],[140,8,141,14],[140,15,141,16],[141,17,142,20],[141,21,142,23],[141,24,142,24],[137,17,138,20],[137,21,138,23],[137,24,138,24],[145,24,146,24],[146,1,147,2],[146,3,147,7],[146,8,147,14],[146,15,147,16],[147,17,148,20],[147,21,148,23],[147,24,148,24],[142,1,143,2],[142,3,143,14],[142,15,143,16],[143,17,144,20],[143,21,144,23],[143,24,144,24],[144,1,145,2],[144,3,145,7],[144,8,145,14],[144,15,145,16],[148,1,148,2],[148,3,148,7],[148,8,148,14],[148,15,148,16],[150,2,152,3],[150,17,152,17],[152,7,153,10],[145,17,146,20],[145,21,146,23]]}
[]
[]
[null,"MONTHLY RETURN TO DIRECTOR OF FINANCE & CORPORATE RESOURCES FOR VAT"]
[]
[null,"SCHOOL :"]
[]
[null,"RETURN FOR :"]
[]
[null,"DETAILS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AMOUNTS"]
[]
[null,null,null,"EXPENDITURE"]
[]
[null,null,null,"1.   Total of 20.00% rate expenditure\n      excluding VAT (VAT Code 5)"]
[]
[]
[null,null,null,"2.   Total of VAT paid on the 20.00% rate expenditure\n      (VAT Code 5)"]
[]
[]
[null,null,null,"3.   Total of 17.50% rate expenditure\n      excluding VAT (VAT Code 1)"]
[]
[]
[null,null,null,"4.   Total of VAT paid on the 17.50% rate expenditure\n      (VAT Code 1) "]
[]
[]
[null,null,null,"5.   Total of 15.00% rate expenditure\n      excluding VAT (VAT Code 2)"]
[]
[]
[null,null,null,"6.   Total of VAT paid on the 15.00% rate expenditure\n      (VAT Code 2)"]
[]
[]
[null,null,null,"7.   Total of 5.00% rate expenditure\n      excluding VAT (VAT Code 4)  "]
[]
[]
[null,null,null,"8.   Total of VAT paid on the 5.00% rate expenditure \n      (VAT Code 4)"]
[]
[]
[null,null,null,"9.   Total of 12.50% rate expenditure\n      excluding VAT (VAT Code 6)  "]
[]
[]
[null,null,null,"10.   Total of VAT paid on the 12.50% rate expenditure \n      (VAT Code 6)"]
[]
[]
[null,null,null,"11.  Total of VAT Code 7 expenditure \n      excluding VAT"]
[]
[]
[null,null,null,"12.  Total of VAT paid on VAT code 7"]
[]
[]
[null,null,null,"13.  Total of exempt expenditure\n       (VAT Code 8)"]
[]
[]
[null,null,null,"14.  Total of zero rated expenditure\n      (VAT Code 0)"]
[]
[]
[null,null,null,"15.  Total of outside the scope expenditure\n      (VAT Code 3)"]
[]
[]
[null,"TOTAL EXPENDITURE  IN PERIOD"]
[]
[]
[]
[null,"DETAILS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AMOUNTS"]
[]
[null,null,null,"INCOME"]
[]
[]
[null,null,null,"16.  Total of 20.00% rate income\n      excluding VAT (VAT Code 5)"]
[]
[]
[]
[null,null,null,"17.  Total of VAT paid on the 20.00% rate income\n      (VAT Code 5)"]
[]
[]
[]
[null,null,null,"18.  Total of 17.50% rate income\n      excluding VAT (VAT Code 1)"]
[]
[]
[]
[null,null,null,"19.  Total of VAT paid on the 17.50% rate income\n      (VAT Code 1) "]
[]
[]
[]
[null,null,null,"20.  Total of 15.00% rate income\n      excluding VAT (VAT Code 2)"]
[]
[]
[]
[null,null,null,"21.  Total of VAT paid on the 15.00% rate income\n      (VAT Code 2)"]
[]
[]
[]
[null,null,null,"22.  Total of 5.00% rate income\n      excluding VAT (VAT Code 4)  "]
[]
[]
[]
[null,null,null,"23.  Total of VAT paid on the 5.00% rate income\n      (VAT Code 4)"]
[]
[]
[]
[null,null,null,"24.  Total of 12.50% rate income\n      excluding VAT (VAT Code 6)  "]
[]
[]
[]
[null,null,null,"25.  Total of VAT paid on the 12.50% rate income\n      (VAT Code 6)"]
[]
[]
[]
[null,null,null,"26.  Total of VAT Code 7 income\n      excluding VAT"]
[]
[]
[]
[null,null,null,"27.  Total of VAT paid on VAT code 7"]
[]
[]
[]
[null,null,null,"28.  Total of exempt income (VAT Code 8)"]
[]
[]
[]
[null,null,null,"29.  Total of zero rated income (VAT Code 0)"]
[]
[]
[]
[null,null,null,"30.  Total of outside the scope income (VAT Code 3)"]
[]
[]
[]
[]
[null,null,null,"TOTAL INCOME NOT VATABLE",null,null,null,null,null,null,"(Lines 28 + 29 + 30)"]
[]
[]
[]
[]
[null,null,null,"TOTAL ALL INCOME ",null,null,null,null,null,"(Lines 16 to 30)"]
[]
[]
[]
[null,null,null,"TAX"]
[]
[null,null,null,"VAT on Expenditure (Line 2+4+6+8+10+12)"]
[]
[]
[]
[null,null,null,"VAT on income (Line 17+19+21+23+25+27)"]
[]
[]
[]
[null,null,null,"TAX DUE"]
[]
[]
[]
[null,null,"Signed:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date:"]
[]
[null,null,null,null,null,null,null,"Authorised Officer"]

{"sheet":"RM FINANCE NEW - REC TO BANK","index":2,"n_rows":52,"n_cols":37,"rows_kept":52,"cut":false,"hidden":false,"merged":[[27,3,27,5],[39,3,39,5],[41,3,41,5],[29,3,29,5],[29,8,29,17],[31,3,31,5],[33,3,33,5],[35,3,35,5],[35,8,35,16],[19,4,19,6],[23,3,23,5],[25,3,25,5],[23,8,23,16],[23,28,23,32],[15,3,15,5],[17,4,17,6],[15,15,15,16],[15,30,15,32],[11,3,11,5],[13,2,13,4],[13,16,13,17],[13,30,13,32],[7,3,7,5],[9,3,9,5],[9,16,9,17],[1,21,1,37],[3,14,3,25],[5,4,5,10],[5,11,5,22],[5,25,5,30],[5,31,5,36],[7,8,7,14],[19,8,19,11],[19,13,19,17],[19,30,19,32],[19,35,19,39],[7,16,7,17],[7,30,7,32],[7,35,7,39],[9,30,9,32],[9,35,9,39],[11,16,11,17],[11,30,11,32],[11,35,11,39],[13,35,13,39],[15,35,15,39],[17,8,17,16],[17,30,17,32],[17,35,17,39],[23,35,23,39],[25,8,25,17],[25,28,25,32],[25,35,25,39],[27,8,27,16],[27,28,27,32],[27,35,27,39],[39,8,39,16],[39,28,39,32],[39,35,39,39],[37,3,37,5],[29,35,29,39],[31,8,31,16],[31,28,31,32],[31,35,31,39],[33,8,33,17],[33,28,33,32],[33,35,33,39],[29,28,29,32],[35,21,35,26],[35,35,35,39],[37,8,37,17],[37,21,37,26],[37,35,37,39],[47,24,49,31],[41,8,41,17],[41,28,41,32],[41,35,41,39],[51,2,53,9],[43,4,43,6],[43,9,43,18],[43,29,43,33],[43,36,43,40],[45,1,45,38],[47,2,49,9]]}
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RECONCILIATION TO BANK STATEMENT"]
[]
[null,null,null,null,"SCHOOL :",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Month Ending:"]
[]
[null,null,null,"1a",null,null,null,null,"Balance as per bank statement",null,null,null,null,null,null,null,"- Bank A/c 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1a"]
[]
[null,null,null,"1b",null,null,null,null,null,null,null,null,null,null,null,null,"- Bank A/c 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1b"]
[]
[null,null,null,"1c",null,null,null,null,null,null,null,null,null,null,null,null,"- Bank A/c 3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1c"]
[]
[null,null,"1d",null,null,null,null,null,null,null,null,null,null,null,null,null,"- Bank A/c 4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1d"]
[]
[null,null,null,"1e",null,null,null,null,null,null,null,null,null,null,null,"Cash in hand",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1e"]
[]
[null,null,null,null,2,null,null,null,"Unpresented Bank Transactions",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,2]
[]
[null,null,null,null,3,null,null,null,"Total Cash Balance",null,null,null,null,"(1a+1b+1c+1d+1e-2)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[]
[]
[]
[null,null,null,"4a",null,null,null,null,"Balance b/f from previous Year",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,"4a"]
[]
[null,null,null,"4b",null,null,null,null,"VAT Adjustment - Previous Year",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,"4b"]
[]
[null,null,null,5,null,null,null,null,"Total Income Received (Net of VAT)",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,5]
[]
[null,null,null,6,null,null,null,null,"Sub Total (4a+4b+5)",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,6]
[]
[null,null,null,7,null,null,null,null,"Total Expenditure financial period to date (net of VAT)",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,7]
[]
[null,null,null,8,null,null,null,null,"Current balance net of VAT (6 - 7)",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,8]
[]
[null,null,null,9,null,null,null,null,"VAT Costs to date – Current Year",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,9]
[]
[null,null,null,10,null,null,null,null,"VAT Advanced to date – Current Year",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,10]
[]
[null,null,null,11,null,null,null,null,"VAT Adjustment (9-10)",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,11]
[]
[null,null,null,12,null,null,null,null,"Unpaid Sales Invoice",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,12]
[]
[null,null,null,null,13,null,null,null,null,"Total Cash Balance (Including VAT) (8 - 11 - 12)",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,13]
[]
[null,"BOX 13 MUST AGREE TO BOX 3"]
[]
[null,null,"Signed",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Responsible Officer"]
[]
[]
[]
[null,null,"Date"]

{"sheet":"FMS","index":3,"n_rows":104,"n_cols":17,"rows_kept":104,"cut":false,"hidden":false,"merged":[]}
["FMS VAT SUBMITTAL"]
[null,"DETAILS",null,null,null,null,null,null,"AMOUNTS"]
[]
[null,"EXPENDITURE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O25","v":0}]
[]
[null,1,"Total of 20% rate expenditure  ",null,null,null,null,null,0]
[null,null,"Excluding VAT "]
[]
[null,2,"Total Of VAT paid on the 20% rate expenditure",null,null,null,null,null,0]
[]
[]
[null,3,"Total Of 17.5% rate expenditure ",null,null,null,null,null,0,null,null,null,null,"Month","Net VAT claimed"]
[null,null,"excluding VAT ",null,null,null,null,null,null,null,null,null,null,"2022-04-01",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-05-01",0]
[null,4,"Total of VAT paid on the 17.5% rate expenditure",null,null,null,null,null,0,null,null,null,null,"2022-06-01",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-07-01",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-08-01",0]
[null,5,"Total of 15% rate expenditure ",null,null,null,null,null,0,null,null,null,null,"2022-09-01",0]
[null,null,"excluding VAT ",null,null,null,null,null,null,null,null,null,null,"2022-10-01",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-11-01",0]
[null,6,"Total of VAT paid on the 15% rate expenditure",null,null,null,null,null,0,null,null,null,null,"2022-12-01",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-01-01",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-02-01",0]
[null,7,"Total of 5% rate expenditure ",null,null,null,null,null,0,null,null,null,null,"2023-03-01",0]
[null,null,"excluding VAT",null,null,null,null,null,null,null,null,null,null,"Cumulative VAT costs to date:",{"$f":"SUM(O13:O24)","v":0}]
[]
[null,8,"Total of VAT paid on the 5% rate expenditure",null,null,null,null,null,0]
[]
[]
[null,9,"Total of 12.5% rate expenditure ",null,null,null,null,null,0]
[null,null,"excluding VAT"]
[]
[null,10,"Total of VAT paid on the 12.5% rate expenditure",null,null,null,null,null,0]
[]
[null,11,"Total of VAT Code 7 expenditure",null,null,null,null,null,0]
[null,null,"excluding VAT"]
[]
[null,12,"Total of VAT paid on VAT code 7",null,null,null,null,null,0]
[]
[null,13,"Total of excempt expenditure",null,null,null,null,null,0]
[]
[]
[null,14,"Total of zero rated expenditure",null,null,null,null,null,0]
[]
[]
[null,15,"Total of outside the scope expenditure",null,null,null,null,null,0]
[null,null,"(VAT Code 3)"]
[]
[null,"TOTAL EXPENDITURE IN PERIOD",null,null,null,null,null,null,{"$f":"SUM(I6+I9+I12+I15+I18+I21+I24+I27+I30+I33+I35+I38+I40+I43+I46)","v":0}]
[]
[]
[null,"INCOME"]
[]
[null,16,"Total of 20% rate income",null,null,null,null,null,0,null,null,"Please note: the income cells must be entered as a minus"]
[null,null,"excluding VAT "]
[]
[null,17,"Total of VAT paid on the 20% rate income",null,null,null,null,null,0]
[]
[]
[null,18,"Total of 17.5% rate income",null,null,null,null,null,0]
[null,null,"excluding VAT"]
[]
[null,19,"Total of VAT paid on the 17.5% rate income",null,null,null,null,null,0]
[]
[]
[null,20,"Total of 15% rate income",null,null,null,null,null,0]
[null,null,"excluding VAT"]
[]
[null,21,"Total of VAT paid on the 15% rate income",null,null,null,null,null,0]
[]
[]
[null,22,"Total of 5% rate income",null,null,null,null,null,0]
[null,null,"excluding VAT"]
[]
[null,23,"Total of VAT paid on the 5% rate income",null,null,null,null,null,0]
[]
[]
[null,24,"Total of 12.5% rate income",null,null,null,null,null,0]
[null,null,"excluding VAT"]
[]
[null,25,"Total of VAT paid on the 12.5% rate income",null,null,null,null,null,0]
[]
[null,26,"Total of VAT Code 7 income",null,null,null,null,null,0]
[null,null,"excluding VAT"]
[]
[null,27,"Total of VAT paid on Vat code 7",null,null,null,null,null,0]
[]
[null,28,"Total of exempt income",null,null,null,null,null,0]
[]
[null,29,"Total of zero rated income",null,null,null,null,null,0]
[]
[null,30,"Total of outside scope income ",null,null,null,null,null,0]
[]
[null,"TOTAL INCOME NOT VATABLE",null,null,null,null,null,null,0]
[]
[null,"TOTAL ALL INCOME",null,null,null,null,null,null,{"$f":"SUM(I54+I57+I60+I63+I66+I69+I72+I75+I78+I81+I83+I86+I88+I90+I92)","v":0}]
[]
[null,"TAX"]
[null,"Vat on Expenditure ",null,null,null,null,null,null,{"$f":"SUM(I9+I15+I21+I27+I33+I38)","v":0}]
[]
[null,"Vat on Income",null,null,null,null,null,null,{"$f":"SUM(I57+I63+I69+I75+I81+I86)","v":0}]
[]
[]
[null,"TAX DUE",null,null,null,null,null,null,{"$f":"SUM(I99:I101)","v":0}]

{"sheet":"RM ACCOUNTS","index":4,"n_rows":109,"n_cols":9,"rows_kept":109,"cut":false,"hidden":true,"merged":[]}
["Description","Amounts",null,null,null,null,null,"Paste Bank Rec Return Here","Actuals"]
["EXPENDITURE",null,null,null,null,null,null,"School Name"]
["1. Total of 20% rate expenditure",0,null,null,null,null,null,"Balance as per Bank Statement"]
["    excluding VAT (VAT Code 5)",null,null,null,null,null,null,"1a - Bank A/c 1"]
[null,null,null,null,null,null,null,"1b - Bank A/c 2"]
["2. Total of VAT paid on the 20% rate expenditure",0,null,null,null,null,null,"1c - Bank A/c 3"]
["    (VAT Code 5)",null,null,null,null,null,null,"1d - Bank A/c 4"]
[null,null,null,null,null,null,null,"1e - Cash in Hand",0]
["3. Total of 17.5% rate expenditure",0,null,null,null,null,null,"2   - Unpresented Bank Transactions"]
["    excluding VAT (VAT Code 1)"]
[null,null,null,null,null,null,null,"3   - Total Cash Balances (1a + 1b + 1c + 1d + 1e + 2a - 2b)"]
["4. Total of VAT paid on the 17.5% rate expenditure",0]
["    (VAT Code 1)",null,null,null,null,null,null,"4a - Balance b/f from previous Year",0]
[null,null,null,null,null,null,null,"4b - VAT Adjustment - Previous Year",0]
["5. Total of 15% rate expenditure",0,null,null,null,null,null,"5   - Total Income Received (Net of VAT)",0]
["    excluding VAT (VAT Code 2)",null,null,null,null,null,null,"6   - Sub Total (4a + 4b + 5)",0]
[null,null,null,null,null,null,null,"7   - Tot Expenditure financial period to date (net of VAT)",0]
["6. Total of VAT paid on the 15% rate expenditure",0,null,null,null,null,null,"8   - Current balance net of VAT (6 - 7)",0]
["    (VAT Code 2)"]
[null,null,null,null,null,null,null,"9   - VAT Costs to date - Current Year",0]
["7. Total of 5% rate expenditure",0,null,null,null,null,null,"10 - VAT Advanced to date - Current Year",0]
["    excluding VAT (VAT Code 4)",null,null,null,null,null,null,"11 - VAT Adjustment (9 - 10)",0]
[null,null,null,null,null,null,null,"12 - Sub Total (including VAT) (8 - 11)",0]
["8. Total of VAT paid on the 5% rate expenditure",0,null,null,null,null,null,null,0]
["    (VAT Code 4)",null,null,null,null,null,null,"13 - Purchase Invoices Not Yet Paid",0]
[null,null,null,null,null,null,null,"14 - Income from Sales Invoices Not Yet Received",0]
["9. Total of 12.5% rate expenditure",0,null,null,null,null,null,"15 - Total Cash Balance (including VAT) (12 - 13 -14)",0]
["    excluding VAT (VAT Code 6)",null,null,null,null,null,null,"BOX 15 MUST AGREE TO BOX 3"]
[]
["10. Total of VAT paid on the 12.5% rate expenditure",0]
["    (VAT Code 6)",null,null,null,null,null,null,"Prepared By................................................."]
[]
["11. Total of VAT Code 7 expenditure",0]
["      excluding VAT (VAT Code 7)",null,null,null,null,null,null,"Date........................................................"]
[]
["12. Total of VAT paid on VAT Code 7",0]
[null,null,null,null,null,null,null,"Authorised By..............................................."]
["13. Total of exempt expenditure",0]
["      excluding VAT (VAT Code 8)"]
[null,null,null,null,null,null,null,"Date........................................................"]
["14. Total of zero rated expenditure (VAT Code 0)",0]
["       (VAT Code 0)"]
[]
["15. Total beyond scope expenditure",0]
["       (VAT Code 3)"]
[]
["TOTAL EXPENDITURE IN PERIOD",0]
[]
[]
["INCOME"]
["16. Total of 20% rate income",0]
["      excluding VAT (VAT Code 5)"]
[]
["17. Total of VAT paid on the 20% rate income",0]
["       (VAT Code 5)"]
[]
["18. Total of 17.5% rate income",0]
["      excluding VAT (VAT Code 1)"]
[]
["19. Total of VAT paid on the 17.5% rate income",0]
["       (VAT Code 1)"]
[]
["20. Total of 15% rate income",0]
["      excluding VAT (VAT Code 2)"]
[]
["21. Total of VAT paid on the 15% rate income",0]
["       (VAT Code 2)"]
[]
["22. Total of 5% rate income",0]
["      excluding VAT (VAT Code 4)"]
[]
["23. Total VAT paid on the 5% rate income",0]
["      (VAT Code 4)"]
[]
["24. Total of 12.5% rate income",0]
["      excluding VAT (VAT Code 6)"]
[]
["25. Total VAT paid on the 12.5% rate income",0]
["      (VAT Code 6)"]
[]
["26. Total of VAT Code 7 income",0]
["      excluding VAT (VAT Code 7)"]
[]
["27. Total of VAT paid on VAT Code 7 income",0]
[]
["28. Total of excempt income (VAT Code 8)",0]
[]
["29 Total of zero rated income (VAT Code 0)",0]
[]
["30 Total beyond scope income VAT Code 3)",0]
[]
["TOTAL INCOME NOT VATABLE (Lines 28+29+30+",0]
[]
["TOTAL ALL INCOME (Lines 16-30",0]
[]
["TAX "]
["VAT on Expenditure (Lines 2+4+6+8+10+12)",0]
[]
["VAT on Income (Lines 17+19+21+23+25+27)",0]
[]
["TAX DUE",0]
[]
[]
["Prepared by…………………………………….. "]
[]
["Signed By..................................................."]
[]
[]
["Date........................................................"]

{"sheet":"VAT RETURN","index":5,"n_rows":49,"n_cols":59,"rows_kept":49,"cut":false,"hidden":false,"merged":[[0,3,0,12],[1,2,1,5],[16,2,16,8],[17,2,17,8],[18,2,18,8]]}
[null,null,null,"Monthly VAT Return",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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CELL(\"filename\")","v":"https://enfield365.sharepoint.com/sites/edms-fbp/Shared Documents/People_Schools/VAT/VAT 2022-23/Admin 2223/[VAT Master Template 2223.xlsm]HOME PAGE"}]
[null,"Name of School:",{"$f":"'HOME PAGE'!G21","v":"Enfield"},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,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,{"$f":"FIND(\"[\",BC1)","v":109}]
[null,"ED Code: ",{"$f":"'HOME PAGE'!O21","v":"0000"},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,null,null,null,"Cumulative VAT to date",null,{"$f":"ROUND(SUM(AN50:AN51),2)","v":0},"VAT Costs to date",null,{"$f":"ROUND(AO8,2)","v":0},"Variance",{"$f":"AI3-AL3","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"FIND(\"]\",BC1)","v":139},{"$f":"BC3-BC2","v":30}]
[null,"Month",1,{"$f":"VLOOKUP(Quarterrtn,fullmonth,2)","v":"April"},"2022/23",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,null,null,null,null,null,null,null,null,null,"From Reconciliation",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C3","v":"0000"}]
[null,null,null,"Date of Return","Total of 20% Rate Exp","Total of Vat Paid on 20%rate exp","Total of 17.5% Rate Exp","Total of Vat Paid 17.5% exp","Total of 15% Rate Exp","Total of Vat Paid on 15% exp","Total of 5% Rate Exp","Total of Vat Paid 5% exp","Total of 12.5% Rate Exp","Total of Vat Paid 12.5% exp","Total of Vat Paid code 7 exp","Total of Vat on code 7 Exp","Total of Exempt expenditure","Total of zero rated expenditure","Total of outside the scope expenditure","Total Expenditure in period","Total of 20% Rate Income","Total of Vat Paid on 20%rate Income","Total of 17.5% Rate Income","Total of Vat Paid 17.5% Income","Total of 15% Rate  Income","Total of Vat Paid on 15%  Income","Total of 5% Rate Income","Total of Vat Paid 5% income","Total of 12.5% Rate Income","Total of Vat Paid 12.5% income","Total of Vat Paid code 7 Income","Total of Vat on code 7  Income","Total of Exempt  Income","Total of zero rated Income","Total of outside the scope  Income","Total  Income Not Vatable","Total all Income","VAT on Expenditure","VAT on Income","Tax due","VAT Costs to date - Current Year",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LEFT(BC1,BC2-1)","v":"https://enfield365.sharepoint.com/sites/edms-fbp/Shared Documents/People_Schools/VAT/VAT 2022-23/Admin 2223/"}]
["line ID","Line from return ",null,7,1,2,3,4,5,null,null,null,null,null,null,null,7,8,null,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,12,null,13,14,7]
["Row location",null,null,{"$f":"MATCH(D6,'[3]Place Data in here'!$A$1:$A$65536,0)-1","v":20},{"$f":"MATCH(E6,'[3]Place Data in here'!$A$1:$A$65536,0)-1","v":7},{"$f":"MATCH(F6,'[3]Place Data in here'!$A$1:$A$65536,0)-1","v":10},{"$f":"MATCH(G6,'[3]Place Data in here'!$A$1:$A$65536,0)-1","v":12},{"$f":"MATCH(H6,'[3]Place Data in here'!$A$1:$A$65536,0)-1","v":14},{"$f":"MATCH(I6,'[3]Place Data in here'!$A$1:$A$65536,0)-1","v":16},null,null,null,null,null,null,null,{"$f":"MATCH(Q6,'[3]Place Data in here'!$A$1:$A$65536,0)-1","v":20},{"$f":"MATCH(R6,'[3]Place Data in here'!$A$1:$A$65536,0)-1","v":22},null,{"$f":"MATCH(T6,'[3]Place Data in here'!$A$1:$A$65536,0)-1","v":27},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MATCH(AJ6,'[3]Place Data in here'!$A$1:$A$65536,0)-1","v":30},{"$f":"MATCH(AK6,'[3]Place Data in here'!$A$1:$A$65536,0)-1","v":34},null,{"$f":"MATCH(AM6,'[3]Place Data in here'!$A$1:$A$65536,0)-1","v":36},{"$f":"MATCH(AN6,'[3]Place Data in here'!$A$1:$A$65536,0)-1","v":38},{"$f":"MATCH(AO6,'[3]Place Data in here'!$A$1:$A$65536,0)-1","v":20},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'HOME PAGE'!G21","v":"Enfield"}]
[{"$f":"$C$2","v":"Enfield"},{"$f":"VLOOKUP(Quarterrtn,fullmonth,2)","v":"April"},{"$f":"Quarterrtn","v":1},null,{"$f":"E9+E10+E11+E12","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C4","v":1},{"$f":"\"VAT v1\"&\" \"&BC4","v":"VAT v1 0000"},{"$f":"TODAY()","v":"2022-08-10"},{"$f":"MONTH(BE8)","v":8},{"$f":"YEAR(BE8)","v":2022}]
[{"$f":"$C$2","v":"Enfield"},"RM FINANCE",null,null,{"$f":"'RM FINANCE NEW - VAT ANALYSIS'!$V$13","v":0},{"$f":"'RM FINANCE NEW - VAT ANALYSIS'!$V$16","v":0},{"$f":"'RM FINANCE NEW - VAT ANALYSIS'!$V$19","v":0},{"$f":"'RM FINANCE NEW - VAT ANALYSIS'!$V$22","v":0},{"$f":"'RM FINANCE NEW - VAT ANALYSIS'!$V$25","v":0},{"$f":"'RM FINANCE NEW - VAT ANALYSIS'!$V$28","v":0},{"$f":"'RM FINANCE NEW - VAT ANALYSIS'!$V$31","v":0},{"$f":"'RM FINANCE NEW - VAT ANALYSIS'!$U$34","v":0},{"$f":"'RM FINANCE NEW - VAT ANALYSIS'!$U$37","v":0},{"$f":"'RM FINANCE NEW - VAT ANALYSIS'!$U$40","v":0},{"$f":"'RM FINANCE NEW - VAT ANALYSIS'!$U$43","v":0},{"$f":"'RM FINANCE NEW - VAT ANALYSIS'!$T$46","v":0},{"$f":"'RM FINANCE NEW - VAT ANALYSIS'!$T$49","v":0},{"$f":"'RM FINANCE NEW - VAT ANALYSIS'!$T$52","v":0},{"$f":"'RM FINANCE NEW - VAT ANALYSIS'!$T$55","v":0},{"$f":"'RM FINANCE NEW - VAT ANALYSIS'!$T$59","v":0},{"$f":"'RM FINANCE NEW - VAT ANALYSIS'!$U$66","v":0},{"$f":"'RM FINANCE NEW - VAT ANALYSIS'!$U$70","v":0},{"$f":"'RM FINANCE NEW - VAT ANALYSIS'!$U$74","v":0},{"$f":"'RM FINANCE NEW - VAT ANALYSIS'!$U$78","v":0},{"$f":"'RM FINANCE NEW - VAT ANALYSIS'!$U$82","v":0},{"$f":"'RM FINANCE NEW - VAT ANALYSIS'!$U$86","v":0},{"$f":"'RM FINANCE NEW - VAT ANALYSIS'!$U$90","v":0},{"$f":"'RM FINANCE NEW - VAT ANALYSIS'!$U$94","v":0},{"$f":"'RM FINANCE NEW - VAT ANALYSIS'!$U$98","v":0},{"$f":"'RM FINANCE NEW - VAT ANALYSIS'!$U$102","v":0},{"$f":"'RM FINANCE NEW - VAT ANALYSIS'!$U$106","v":0},{"$f":"'RM FINANCE NEW - VAT ANALYSIS'!$U$110","v":0},{"$f":"'RM FINANCE NEW - VAT ANALYSIS'!$U$114","v":0},{"$f":"'RM FINANCE NEW - VAT ANALYSIS'!$U$118","v":0},{"$f":"'RM FINANCE NEW - VAT ANALYSIS'!$U$122","v":0},{"$f":"'RM FINANCE NEW - VAT ANALYSIS'!$V$127","v":0},{"$f":"'RM FINANCE NEW - VAT ANALYSIS'!$U$132","v":0},{"$f":"'RM FINANCE NEW - VAT ANALYSIS'!$V$138","v":0},{"$f":"'RM FINANCE NEW - VAT ANALYSIS'!$V$142","v":0},{"$f":"'RM FINANCE NEW - VAT ANALYSIS'!$V$146","v":0},{"$f":"'RM FINANCE NEW - REC TO BANK'!$V$36","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,".xls"]
[{"$f":"$C$2","v":"Enfield"},"FMS",null,null,{"$f":"OFFSET(FMS!$B$1,5,7)","v":0},{"$f":"OFFSET(FMS!$B$1,8,7)","v":0},{"$f":"OFFSET(FMS!$B$1,11,7)","v":0},{"$f":"OFFSET(FMS!$B$1,14,7)","v":0},{"$f":"OFFSET(FMS!$B$1,17,7)","v":0},{"$f":"OFFSET(FMS!$B$1,20,7)","v":0},{"$f":"OFFSET(FMS!$B$1,23,7)","v":0},{"$f":"OFFSET(FMS!$B$1,26,7)","v":0},{"$f":"OFFSET(FMS!$B$1,29,7)","v":0},{"$f":"OFFSET(FMS!$B$1,32,7)","v":0},{"$f":"OFFSET(FMS!$B$1,34,7)","v":0},{"$f":"OFFSET(FMS!$B$1,37,7)","v":0},{"$f":"OFFSET(FMS!$B$1,39,7)","v":0},{"$f":"OFFSET(FMS!$B$1,42,7)","v":0},{"$f":"OFFSET(FMS!$B$1,45,7)","v":0},{"$f":"OFFSET(FMS!$B$1,48,7)","v":0},{"$f":"OFFSET(FMS!$B$1,53,7)","v":0},{"$f":"OFFSET(FMS!$B$1,56,7)","v":0},{"$f":"OFFSET(FMS!$B$1,59,7)","v":0},{"$f":"OFFSET(FMS!$B$1,62,7)","v":0},{"$f":"OFFSET(FMS!$B$1,65,7)","v":0},{"$f":"OFFSET(FMS!$B$1,68,7)","v":0},{"$f":"OFFSET(FMS!$B$1,71,7)","v":0},{"$f":"OFFSET(FMS!$B$1,74,7)","v":0},{"$f":"OFFSET(FMS!$B$1,77,7)","v":0},{"$f":"OFFSET(FMS!$B$1,80,7)","v":0},{"$f":"OFFSET(FMS!$B$1,82,7)","v":0},{"$f":"OFFSET(FMS!$B$1,85,7)","v":0},{"$f":"OFFSET(FMS!$B$1,87,7)","v":0},{"$f":"OFFSET(FMS!$B$1,89,7)","v":0},{"$f":"OFFSET(FMS!$B$1,91,7)","v":0},{"$f":"OFFSET(FMS!$B$1,93,7)","v":0},{"$f":"OFFSET(FMS!$B$1,95,7)","v":0},{"$f":"OFFSET(FMS!$B$1,98,7)","v":0},{"$f":"OFFSET(FMS!$B$1,100,7)","v":0},{"$f":"OFFSET(FMS!$B$1,103,7)","v":0},{"$f":"FMS!O25","v":0}]
[{"$f":"$C$2","v":"Enfield"},"RM ACCOUNTS",null,null,{"$f":"OFFSET('RM ACCOUNTS'!$B$1,2,0)","v":0},{"$f":"OFFSET('RM ACCOUNTS'!$B$1,5,0)","v":0},{"$f":"OFFSET('RM ACCOUNTS'!$B$1,8,0)","v":0},{"$f":"OFFSET('RM ACCOUNTS'!$B$1,11,0)","v":0},{"$f":"OFFSET('RM ACCOUNTS'!$B$1,14,0)","v":0},{"$f":"OFFSET('RM ACCOUNTS'!$B$1,17,0)","v":0},{"$f":"OFFSET('RM ACCOUNTS'!$B$1,20,0)","v":0},{"$f":"OFFSET('RM ACCOUNTS'!$B$1,23,0)","v":0},{"$f":"OFFSET('RM ACCOUNTS'!$B$1,26,0)","v":0},{"$f":"OFFSET('RM ACCOUNTS'!$B$1,29,0)","v":0},{"$f":"OFFSET('RM ACCOUNTS'!$B$1,31,0)","v":0},{"$f":"OFFSET('RM ACCOUNTS'!$B$1,34,0)","v":0},{"$f":"OFFSET('RM ACCOUNTS'!$B$1,36,0)","v":0},{"$f":"OFFSET('RM ACCOUNTS'!$B$1,39,0)","v":0},{"$f":"OFFSET('RM ACCOUNTS'!$B$1,42,0)","v":0},{"$f":"OFFSET('RM ACCOUNTS'!$B$1,45,0)","v":0},{"$f":"OFFSET('RM ACCOUNTS'!$B$1,49,0)","v":0},{"$f":"OFFSET('RM ACCOUNTS'!$B$1,52,0)","v":0},{"$f":"OFFSET('RM ACCOUNTS'!$B$1,55,0)","v":0},{"$f":"OFFSET('RM ACCOUNTS'!$B$1,58,0)","v":0},{"$f":"OFFSET('RM ACCOUNTS'!$B$1,61,0)","v":0},{"$f":"OFFSET('RM ACCOUNTS'!$B$1,64,0)","v":0},{"$f":"OFFSET('RM ACCOUNTS'!$B$1,67,0)","v":0},{"$f":"OFFSET('RM ACCOUNTS'!$B$1,70,0)","v":0},{"$f":"OFFSET('RM ACCOUNTS'!$B$1,73,0)","v":0},{"$f":"OFFSET('RM ACCOUNTS'!$B$1,76,0)","v":0},{"$f":"OFFSET('RM ACCOUNTS'!$B$1,78,0)","v":0},{"$f":"OFFSET('RM ACCOUNTS'!$B$1,81,0)","v":0},{"$f":"OFFSET('RM ACCOUNTS'!$B$1,83,0)","v":0},{"$f":"OFFSET('RM ACCOUNTS'!$B$1,85,0)","v":0},{"$f":"OFFSET('RM ACCOUNTS'!$B$1,87,0)","v":0},{"$f":"OFFSET('RM ACCOUNTS'!$B$1,89,0)","v":0},{"$f":"OFFSET('RM ACCOUNTS'!$B$1,91,0)","v":0},{"$f":"OFFSET('RM ACCOUNTS'!$B$1,94,0)","v":0},{"$f":"OFFSET('RM ACCOUNTS'!$B$1,96,0)","v":0},{"$f":"OFFSET('RM ACCOUNTS'!$B$1,98,0)","v":0},{"$f":"OFFSET('RM ACCOUNTS'!$B$1,19,7)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BC5&BC7&\" \"&BD8&\" \"&BC8&\" \"&BG8&BC9","v":"https://enfield365.sharepoint.com/sites/edms-fbp/Shared Documents/People_Schools/VAT/VAT 2022-23/Admin 2223/Enfield VAT v1 0000 1 2022.xls"}]
[{"$f":"$C$2","v":"Enfield"},"Insert figures manually",null,null,0,0]
[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,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,null,null,{"$f":"FIND(\"[\",BC1)","v":109}]
[null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40]
[]
[]
[null,"Name:       "]
[null,"Position:  "]
[null,"Date:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Date of Return","Total of 20% Rate Exp","Total of Vat Paid on 20%rate exp","Total of 17.5% Rate Exp","Total of Vat Paid 17.5% exp","Total of 15% Rate Exp","Total of Vat Paid on 15% exp","Total of 5% Rate Exp","Total of Vat Paid 5% exp","Total of 12.5% Rate Exp","Total of Vat Paid 12.5% exp","Total of Vat Paid code 7 exp","Total of Vat on code 7 Exp","Total of Exempt expenditure","Total of zero rated expenditure","Total of outside the scope expenditure","Total Expenditure in period","Total of 20% Rate Income","Total of Vat Paid on 20%rate Income","Total of 17.5% Rate Income","Total of Vat Paid 17.5% Income","Total of 15% Rate  Income","Total of Vat Paid on 15%  Income","Total of 5% Rate Income","Total of Vat Paid 5% income","Total of 12.5% Rate Income","Total of Vat Paid 12.5% income","Total of Vat Paid code 7 Income","Total of Vat on code 7  Income","Total of Exempt  Income","Total of zero rated Income","Total of outside the scope  Income","Total  Income Not Vatable","Total all Income","VAT on Expenditure","VAT on Income","Tax due","VAT Costs to date - Current Year"]

{"sheet":"System Admin","index":6,"n_rows":94,"n_cols":20,"rows_kept":94,"cut":false,"hidden":true,"merged":[]}
[null,"Record count",null,null,null,null,null,"Record Rows",null,null,"SKIP"]
[null,9,null,null,14,null,3,null,null,null,null,null,null,null,null,null,9,1]
[null,1,null,"'Year Summary'!$C$10:$C$10",null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$error":"#N/A"}]
[null,3,3,null,null,null,null,"$2:$3"]
[null,"Month from home page",null,null,"month offset for month",null,null,null,"Pastearea!c2:c"]
[null,"No of pay numbers",null,"Lookup range for pay numbers"]
[null,"on Summary report",0]
[]
[null,14,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,"Pastearea!B2:B3",null,"No of Pay numbers"]
[null,null,null,null,null,null,3,null,1,null,1]
[null,null,0,null,0,null,3,null,null,null,"Pastearea!B2:D2"]
[null,null,1]
[null,null,null,null,0,null,"$C$2:$C$",null,1]
[null,"all staff",1,null,null,null,null,null,"No of new pay numbers"]
[null,"new staff",1,null,"Pastearea!B2:B2",null,null,null,"C11"]
[]
[null,null,null,null,0]
[]
[null,null,null,null,"A10:A10",null,11,13,"A11:A13",null,null,"L10:L11"]
[null,null,null,null,"D10:D10",null,null,null,"D11:D13"]
[null,null,null,null,"V10:V10",null,null,null,null,null,11,12]
[]
[null,1,10,null,null,null,1,"April"]
[null,2,11,null,null,null,2,"May "]
[null,3,12,null,null,null,3,"June"]
[null,4,1,null,null,null,4,"July"]
[null,5,2,null,null,null,5,"August"]
[null,6,3,null,null,null,6,"September"]
[null,7,4,null,null,null,7,"October"]
[null,8,5,null,null,null,8,"November"]
[null,9,6,null,null,null,9,"December"]
[null,10,7,null,null,null,10,"January"]
[null,11,8,null,null,null,11,"February"]
[null,12,9,null,null,null,12,"March"]
[]
[]
[null,null,null,null,null,0]
[null,null,null,null,null,"Enfield","0000"]
[null,null,null,null,5,"BUSH HILL PARK","ED0006",null,""]
[null,null,null,null,6,"CAPEL MANOR PRIMARY","ED0007",null,""]
[null,null,null,null,7,"CARTERHATCH INF","ED0008",null,""]
[null,null,null,null,9,"CHASE SIDE PRIMARY","ED0010"]
[null,null,null,null,12,"DE BOHUN PRIMARY","ED0015"]
[null,null,null,null,14,"ELDON PRIMARY ","ED0017"]
[null,null,null,null,16,"EVERSLEY PRIMARY","ED0019"]
[null,null,null,null,17,"FIRS FARM PRIMARY","ED0020"]
[null,null,null,null,19,"FORTY HILL PRIMARY","ED0022"]
[null,null,null,null,20,"FREEZYWATER ST GEORG","ED0023"]
[null,null,null,null,22,"GARFIELD PRIMARY","ED0025"]
[null,null,null,null,23,"GEORGE SPICER PRIMARY","ED0026"]
[null,null,null,null,25,"HADLEY WOOD PRIMARY","ED0028"]
[null,null,null,null,28,"HAZELWOOD SCHOOLS","ED0032"]
[null,null,null,null,29,"HIGHFIELD PRIMARY","ED0033"]
[null,null,null,null,30,"HONILANDS PRIMARY","ED0034"]
[null,null,null,null,31,"LATYMER ALL SAINTS","ED0036"]
[null,null,null,null,33,"MERRYHILLS PRIMARY","ED0038"]
[null,null,null,null,34,"OAKTHORPE PRIMARY","ED0039"]
[null,null,null,null,35,"OUR LADY OF LOURDES","ED0040"]
[null,null,null,null,36,"PRINCE OF WALES PRIM","ED0041"]
[null,null,null,null,37,"THE RAGLAN SCHOOLS","ED0043"]
[null,null,null,null,39,"SOUTHBURY PRIMARY","ED0045"]
[null,null,null,null,40,"ST ANDREWS ENF PRIM","ED0046"]
[null,null,null,null,41,"ST ANDREWS SGT PRIM","ED0047"]
[null,null,null,null,42,"ST EDMUND'S PRIMARY","ED0048"]
[null,null,null,null,43,"ST GEORGES PRIMARY","ED0049"]
[null,null,null,null,44,"ST JAMES ENF PRIM","ED0050"]
[null,null,null,null,45,"ST JOHN & ST JAMES","ED0051"]
[null,null,null,null,46,"St JOHNS ENF PRIM","ED0053"]
[null,null,null,null,47,"ST MARYS PRIMARY","ED0053"]
[null,null,null,null,48,"ST MATTHEWS PRIMARY","ED0054"]
[null,null,null,null,49,"ST MICHAEL AT BOWES","ED0055"]
[null,null,null,null,50,"ST MICHAELS ENF PRIM","ED0056"]
[null,null,null,null,51,"ST MONICAS PRIMARY","ED0057"]
[null,null,null,null,52,"ST PAULS PRIMARY","ED0058"]
[null,null,null,null,53,"SUFFOLKS PRIMARY","ED0059"]
[null,null,null,null,54,"TOTTENHALL INFTS","ED0060"]
[null,null,null,null,56,"WEST GROVE PRIMARY","ED0062"]
[null,null,null,null,61,"STARKSFIELD","ED0067"]
[null,null,null,null,62,"BISHOP STOPFORD","ED0303"]
[null,null,null,null,63,"BROOMFIELD","ED0304"]
[null,null,null,null,64,"CHACE COMMUNITY","ED0305"]
[null,null,null,null,66,"ENFIELD COUNTY","ED0307"]
[null,null,null,null,67,"HIGHLANDS","ED0309"]
[null,null,null,null,68,"LATYMER","ED0311"]
[null,null,null,null,71,"ST ANNES","ED0315"]
[null,null,null,null,72,"ST IGNATIUS","ED0316"]
[null,null,null,null,73,"WINCHMORE","ED0317"]
[null,null,null,null,74,"ORCHARDSIDE","ED1001"]
[null,null,null,null,76,"DURANTS","ED0352"]
[null,null,null,null,77,"OAKTREE","ED0353"]
[null,null,null,null,78,"RUSSET HOUSE","ED0354"]
[null,null,null,null,79,"WAVERLEY","ED0355"]
[null,null,null,null,80,"WEST LEA","ED0356"]