{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["YTD BUDGET SUMMARY","MONTHLY EXPENSES SUMMARY","ITEMISED EXPENSES","CHARITABLES & SPONSORSHIPS"],"not_rendered":{"images":1,"defined_names":15},"read":"whole","date_system":"1900"}

{"sheet":"YTD BUDGET SUMMARY","index":0,"n_rows":16,"n_cols":7,"rows_kept":16,"merged":[[1,1,1,4]]}
[]
[null,"ACTUAL vs BUDGET YTD",{"$nulls":3},"YEAR",{"$f":"YEAR(TODAY())","v":2019}]
[null,"G/L code","Account title","Actual","Budget","Remaining £","Remaining %"]
[null,1000,"Advertising",{"$f":"SUMIF(MonthlyExpensesSummary[G/L code],YearToDateTable[[#This Row],[G/L code]],MonthlyExpensesSummary[Total])","v":{"v":0,"d":"£0.00"}},{"v":100000,"d":"£100,000.00"},{"$f":"IF(YearToDateTable[[#This Row],[Budget]]=\"\",\"\",YearToDateTable[[#This Row],[Budget]]-YearToDateTable[[#This Row],[Actual]])","v":{"v":100000,"d":"£100,000.00"}},{"$f":"IFERROR(YearToDateTable[[#This Row],[Remaining £]]/YearToDateTable[[#This Row],[Budget]],\"\")","v":{"v":1,"d":"100.00%"}}]
[null,2000,"Office equipment",{"$f":"SUMIF(MonthlyExpensesSummary[G/L code],YearToDateTable[[#This Row],[G/L code]],MonthlyExpensesSummary[Total])","v":{"v":0,"d":"£0.00"}},{"v":100000,"d":"£100,000.00"},{"$f":"IF(YearToDateTable[[#This Row],[Budget]]=\"\",\"\",YearToDateTable[[#This Row],[Budget]]-YearToDateTable[[#This Row],[Actual]])","v":{"v":100000,"d":"£100,000.00"}},{"$f":"IFERROR(YearToDateTable[[#This Row],[Remaining £]]/YearToDateTable[[#This Row],[Budget]],\"\")","v":{"v":1,"d":"100.00%"}}]
[null,3000,"Printers",{"$f":"SUMIF(MonthlyExpensesSummary[G/L code],YearToDateTable[[#This Row],[G/L code]],MonthlyExpensesSummary[Total])","v":{"v":0,"d":"£0.00"}},{"v":100000,"d":"£100,000.00"},{"$f":"IF(YearToDateTable[[#This Row],[Budget]]=\"\",\"\",YearToDateTable[[#This Row],[Budget]]-YearToDateTable[[#This Row],[Actual]])","v":{"v":100000,"d":"£100,000.00"}},{"$f":"IFERROR(YearToDateTable[[#This Row],[Remaining £]]/YearToDateTable[[#This Row],[Budget]],\"\")","v":{"v":1,"d":"100.00%"}}]
[null,4000,"Server costs",{"$f":"SUMIF(MonthlyExpensesSummary[G/L code],YearToDateTable[[#This Row],[G/L code]],MonthlyExpensesSummary[Total])","v":{"v":0,"d":"£0.00"}},{"v":100000,"d":"£100,000.00"},{"$f":"IF(YearToDateTable[[#This Row],[Budget]]=\"\",\"\",YearToDateTable[[#This Row],[Budget]]-YearToDateTable[[#This Row],[Actual]])","v":{"v":100000,"d":"£100,000.00"}},{"$f":"IFERROR(YearToDateTable[[#This Row],[Remaining £]]/YearToDateTable[[#This Row],[Budget]],\"\")","v":{"v":1,"d":"100.00%"}}]
[null,5000,"Supplies",{"$f":"SUMIF(MonthlyExpensesSummary[G/L code],YearToDateTable[[#This Row],[G/L code]],MonthlyExpensesSummary[Total])","v":{"v":0,"d":"£0.00"}},{"v":50000,"d":"£50,000.00"},{"$f":"IF(YearToDateTable[[#This Row],[Budget]]=\"\",\"\",YearToDateTable[[#This Row],[Budget]]-YearToDateTable[[#This Row],[Actual]])","v":{"v":50000,"d":"£50,000.00"}},{"$f":"IFERROR(YearToDateTable[[#This Row],[Remaining £]]/YearToDateTable[[#This Row],[Budget]],\"\")","v":{"v":1,"d":"100.00%"}}]
[null,6000,"Client expenses",{"$f":"SUMIF(MonthlyExpensesSummary[G/L code],YearToDateTable[[#This Row],[G/L code]],MonthlyExpensesSummary[Total])","v":{"v":0,"d":"£0.00"}},{"v":25000,"d":"£25,000.00"},{"$f":"IF(YearToDateTable[[#This Row],[Budget]]=\"\",\"\",YearToDateTable[[#This Row],[Budget]]-YearToDateTable[[#This Row],[Actual]])","v":{"v":25000,"d":"£25,000.00"}},{"$f":"IFERROR(YearToDateTable[[#This Row],[Remaining £]]/YearToDateTable[[#This Row],[Budget]],\"\")","v":{"v":1,"d":"100.00%"}}]
[null,7000,"Computers",{"$f":"SUMIF(MonthlyExpensesSummary[G/L code],YearToDateTable[[#This Row],[G/L code]],MonthlyExpensesSummary[Total])","v":{"v":0,"d":"£0.00"}},{"v":75000,"d":"£75,000.00"},{"$f":"IF(YearToDateTable[[#This Row],[Budget]]=\"\",\"\",YearToDateTable[[#This Row],[Budget]]-YearToDateTable[[#This Row],[Actual]])","v":{"v":75000,"d":"£75,000.00"}},{"$f":"IFERROR(YearToDateTable[[#This Row],[Remaining £]]/YearToDateTable[[#This Row],[Budget]],\"\")","v":{"v":1,"d":"100.00%"}}]
[null,8000,"Medical plan",{"$f":"SUMIF(MonthlyExpensesSummary[G/L code],YearToDateTable[[#This Row],[G/L code]],MonthlyExpensesSummary[Total])","v":{"v":0,"d":"£0.00"}},{"v":65000,"d":"£65,000.00"},{"$f":"IF(YearToDateTable[[#This Row],[Budget]]=\"\",\"\",YearToDateTable[[#This Row],[Budget]]-YearToDateTable[[#This Row],[Actual]])","v":{"v":65000,"d":"£65,000.00"}},{"$f":"IFERROR(YearToDateTable[[#This Row],[Remaining £]]/YearToDateTable[[#This Row],[Budget]],\"\")","v":{"v":1,"d":"100.00%"}}]
[null,9000,"Building costs",{"$f":"SUMIF(MonthlyExpensesSummary[G/L code],YearToDateTable[[#This Row],[G/L code]],MonthlyExpensesSummary[Total])","v":{"v":0,"d":"£0.00"}},{"v":125000,"d":"£125,000.00"},{"$f":"IF(YearToDateTable[[#This Row],[Budget]]=\"\",\"\",YearToDateTable[[#This Row],[Budget]]-YearToDateTable[[#This Row],[Actual]])","v":{"v":125000,"d":"£125,000.00"}},{"$f":"IFERROR(YearToDateTable[[#This Row],[Remaining £]]/YearToDateTable[[#This Row],[Budget]],\"\")","v":{"v":1,"d":"100.00%"}}]
[null,10000,"Marketing",{"$f":"SUMIF(MonthlyExpensesSummary[G/L code],YearToDateTable[[#This Row],[G/L code]],MonthlyExpensesSummary[Total])","v":{"v":0,"d":"£0.00"}},{"v":100000,"d":"£100,000.00"},{"$f":"IF(YearToDateTable[[#This Row],[Budget]]=\"\",\"\",YearToDateTable[[#This Row],[Budget]]-YearToDateTable[[#This Row],[Actual]])","v":{"v":100000,"d":"£100,000.00"}},{"$f":"IFERROR(YearToDateTable[[#This Row],[Remaining £]]/YearToDateTable[[#This Row],[Budget]],\"\")","v":{"v":1,"d":"100.00%"}}]
[null,11000,"Charitables",{"$f":"SUMIF(MonthlyExpensesSummary[G/L code],YearToDateTable[[#This Row],[G/L code]],MonthlyExpensesSummary[Total])","v":{"v":0,"d":"£0.00"}},{"v":250000,"d":"£250,000.00"},{"$f":"IF(YearToDateTable[[#This Row],[Budget]]=\"\",\"\",YearToDateTable[[#This Row],[Budget]]-YearToDateTable[[#This Row],[Actual]])","v":{"v":250000,"d":"£250,000.00"}},{"$f":"IFERROR(YearToDateTable[[#This Row],[Remaining £]]/YearToDateTable[[#This Row],[Budget]],\"\")","v":{"v":1,"d":"100.00%"}}]
[null,12000,"Sponsorships",{"$f":"SUMIF(MonthlyExpensesSummary[G/L code],YearToDateTable[[#This Row],[G/L code]],MonthlyExpensesSummary[Total])","v":{"v":0,"d":"£0.00"}},{"v":50000,"d":"£50,000.00"},{"$f":"IF(YearToDateTable[[#This Row],[Budget]]=\"\",\"\",YearToDateTable[[#This Row],[Budget]]-YearToDateTable[[#This Row],[Actual]])","v":{"v":50000,"d":"£50,000.00"}},{"$f":"IFERROR(YearToDateTable[[#This Row],[Remaining £]]/YearToDateTable[[#This Row],[Budget]],\"\")","v":{"v":1,"d":"100.00%"}}]
[null,"Total",null,{"$f":"SUBTOTAL(109,YearToDateTable[Actual])","v":{"v":0,"d":"£0.00"}},{"$f":"SUBTOTAL(109,YearToDateTable[Budget])","v":{"v":1140000,"d":"£1,140,000.00"}},{"$f":"SUBTOTAL(109,YearToDateTable[Remaining £])","v":{"v":1140000,"d":"£1,140,000.00"}},{"$f":"YearToDateTable[[#Totals],[Remaining £]]/YearToDateTable[[#Totals],[Budget]]","v":{"v":1,"d":"100.00%"}}]

{"sheet":"MONTHLY EXPENSES SUMMARY","index":1,"n_rows":18,"n_cols":17,"rows_kept":18,"merged":[[1,1,1,16]]}
[]
[null,"MONTHLY EXPENSES SUMMARY"]
[null,"Slicer to filter data by Account titles is in this cell.",null,{"$f":"DATEVALUE(\"1-JAN\"&_YEAR)","v":"2019-01-01"},{"$f":"DATEVALUE(\"1-FEB\"&_YEAR)","v":"2019-02-01"},{"$f":"DATEVALUE(\"1-MAR\"&_YEAR)","v":"2019-03-01"},{"$f":"DATEVALUE(\"1-APR\"&_YEAR)","v":"2019-04-01"},{"$f":"DATEVALUE(\"1-MAY\"&_YEAR)","v":"2019-05-01"},{"$f":"DATEVALUE(\"1-JUN\"&_YEAR)","v":"2019-06-01"},{"$f":"DATEVALUE(\"1-JULY\"&_YEAR)","v":"2019-07-01"},{"$f":"DATEVALUE(\"1-AUG\"&_YEAR)","v":"2019-08-01"},{"$f":"DATEVALUE(\"1-SEP\"&_YEAR)","v":"2019-09-01"},{"$f":"DATEVALUE(\"1-OCT\"&_YEAR)","v":"2019-10-01"},{"$f":"DATEVALUE(\"1-NOV\"&_YEAR)","v":"2019-11-01"},{"$f":"DATEVALUE(\"1-DEC\"&_YEAR)","v":"2019-12-01"}]
[{"$nulls":3},{"$f":"EOMONTH(D3,0)","v":"2019-01-31"},{"$f":"EOMONTH(E3,0)","v":"2019-02-28"},{"$f":"EOMONTH(F3,0)","v":"2019-03-31"},{"$f":"EOMONTH(G3,0)","v":"2019-04-30"},{"$f":"EOMONTH(H3,0)","v":"2019-05-31"},{"$f":"EOMONTH(I3,0)","v":"2019-06-30"},"2019-07-31","2019-08-31","2019-09-30","2019-10-31","2019-11-30","2019-12-31"]
[null,"G/L code","Account title","January","February","March","April","May","June","July","August","September","October","November","December","Total"," "]
[null,1000,"Advertising",{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&D$3,ItemisedExpenses[Invoice date],\"<=\"&D$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[January]]&_YEAR),Other[Date cheque request initiated],\"<=\"&D$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&E$3,ItemisedExpenses[Invoice date],\"<=\"&E$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[February]]&_YEAR),Other[Date cheque request initiated],\"<=\"&E$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&F$3,ItemisedExpenses[Invoice date],\"<=\"&F$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[March]]&_YEAR),Other[Date cheque request initiated],\"<=\"&F$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&G$3,ItemisedExpenses[Invoice date],\"<=\"&G$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[April]]&_YEAR),Other[Date cheque request initiated],\"<=\"&G$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&H$3,ItemisedExpenses[Invoice date],\"<=\"&H$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[May]]&_YEAR),Other[Date cheque request initiated],\"<=\"&H$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&I$3,ItemisedExpenses[Invoice date],\"<=\"&I$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[June]]&_YEAR),Other[Date cheque request initiated],\"<=\"&I$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&J$3,ItemisedExpenses[Invoice date],\"<=\"&J$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[July]]&_YEAR),Other[Date cheque request initiated],\"<=\"&J$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&K$3,ItemisedExpenses[Invoice date],\"<=\"&K$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[August]]&_YEAR),Other[Date cheque request initiated],\"<=\"&K$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&L$3,ItemisedExpenses[Invoice date],\"<=\"&L$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[September]]&_YEAR),Other[Date cheque request initiated],\"<=\"&L$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&M$3,ItemisedExpenses[Invoice date],\"<=\"&M$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[October]]&_YEAR),Other[Date cheque request initiated],\"<=\"&M$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&N$3,ItemisedExpenses[Invoice date],\"<=\"&N$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[November]]&_YEAR),Other[Date cheque request initiated],\"<=\"&N$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&O$3,ItemisedExpenses[Invoice date],\"<=\"&O$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[December]]&_YEAR),Other[Date cheque request initiated],\"<=\"&O$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUM(MonthlyExpensesSummary[[#This Row],[January]:[December]])","v":{"v":0,"d":"£0.00"}}]
[null,2000,"Office equipment",{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&D$3,ItemisedExpenses[Invoice date],\"<=\"&D$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[January]]&_YEAR),Other[Date cheque request initiated],\"<=\"&D$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&E$3,ItemisedExpenses[Invoice date],\"<=\"&E$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[February]]&_YEAR),Other[Date cheque request initiated],\"<=\"&E$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&F$3,ItemisedExpenses[Invoice date],\"<=\"&F$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[March]]&_YEAR),Other[Date cheque request initiated],\"<=\"&F$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&G$3,ItemisedExpenses[Invoice date],\"<=\"&G$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[April]]&_YEAR),Other[Date cheque request initiated],\"<=\"&G$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&H$3,ItemisedExpenses[Invoice date],\"<=\"&H$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[May]]&_YEAR),Other[Date cheque request initiated],\"<=\"&H$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&I$3,ItemisedExpenses[Invoice date],\"<=\"&I$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[June]]&_YEAR),Other[Date cheque request initiated],\"<=\"&I$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&J$3,ItemisedExpenses[Invoice date],\"<=\"&J$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[July]]&_YEAR),Other[Date cheque request initiated],\"<=\"&J$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&K$3,ItemisedExpenses[Invoice date],\"<=\"&K$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[August]]&_YEAR),Other[Date cheque request initiated],\"<=\"&K$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&L$3,ItemisedExpenses[Invoice date],\"<=\"&L$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[September]]&_YEAR),Other[Date cheque request initiated],\"<=\"&L$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&M$3,ItemisedExpenses[Invoice date],\"<=\"&M$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[October]]&_YEAR),Other[Date cheque request initiated],\"<=\"&M$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&N$3,ItemisedExpenses[Invoice date],\"<=\"&N$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[November]]&_YEAR),Other[Date cheque request initiated],\"<=\"&N$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&O$3,ItemisedExpenses[Invoice date],\"<=\"&O$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[December]]&_YEAR),Other[Date cheque request initiated],\"<=\"&O$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUM(MonthlyExpensesSummary[[#This Row],[January]:[December]])","v":{"v":0,"d":"£0.00"}}]
[null,3000,"Printers",{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&D$3,ItemisedExpenses[Invoice date],\"<=\"&D$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[January]]&_YEAR),Other[Date cheque request initiated],\"<=\"&D$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&E$3,ItemisedExpenses[Invoice date],\"<=\"&E$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[February]]&_YEAR),Other[Date cheque request initiated],\"<=\"&E$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&F$3,ItemisedExpenses[Invoice date],\"<=\"&F$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[March]]&_YEAR),Other[Date cheque request initiated],\"<=\"&F$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&G$3,ItemisedExpenses[Invoice date],\"<=\"&G$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[April]]&_YEAR),Other[Date cheque request initiated],\"<=\"&G$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&H$3,ItemisedExpenses[Invoice date],\"<=\"&H$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[May]]&_YEAR),Other[Date cheque request initiated],\"<=\"&H$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&I$3,ItemisedExpenses[Invoice date],\"<=\"&I$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[June]]&_YEAR),Other[Date cheque request initiated],\"<=\"&I$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&J$3,ItemisedExpenses[Invoice date],\"<=\"&J$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[July]]&_YEAR),Other[Date cheque request initiated],\"<=\"&J$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&K$3,ItemisedExpenses[Invoice date],\"<=\"&K$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[August]]&_YEAR),Other[Date cheque request initiated],\"<=\"&K$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&L$3,ItemisedExpenses[Invoice date],\"<=\"&L$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[September]]&_YEAR),Other[Date cheque request initiated],\"<=\"&L$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&M$3,ItemisedExpenses[Invoice date],\"<=\"&M$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[October]]&_YEAR),Other[Date cheque request initiated],\"<=\"&M$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&N$3,ItemisedExpenses[Invoice date],\"<=\"&N$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[November]]&_YEAR),Other[Date cheque request initiated],\"<=\"&N$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&O$3,ItemisedExpenses[Invoice date],\"<=\"&O$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[December]]&_YEAR),Other[Date cheque request initiated],\"<=\"&O$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUM(MonthlyExpensesSummary[[#This Row],[January]:[December]])","v":{"v":0,"d":"£0.00"}}]
[null,4000,"Server costs",{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&D$3,ItemisedExpenses[Invoice date],\"<=\"&D$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[January]]&_YEAR),Other[Date cheque request initiated],\"<=\"&D$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&E$3,ItemisedExpenses[Invoice date],\"<=\"&E$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[February]]&_YEAR),Other[Date cheque request initiated],\"<=\"&E$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&F$3,ItemisedExpenses[Invoice date],\"<=\"&F$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[March]]&_YEAR),Other[Date cheque request initiated],\"<=\"&F$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&G$3,ItemisedExpenses[Invoice date],\"<=\"&G$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[April]]&_YEAR),Other[Date cheque request initiated],\"<=\"&G$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&H$3,ItemisedExpenses[Invoice date],\"<=\"&H$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[May]]&_YEAR),Other[Date cheque request initiated],\"<=\"&H$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&I$3,ItemisedExpenses[Invoice date],\"<=\"&I$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[June]]&_YEAR),Other[Date cheque request initiated],\"<=\"&I$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&J$3,ItemisedExpenses[Invoice date],\"<=\"&J$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[July]]&_YEAR),Other[Date cheque request initiated],\"<=\"&J$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&K$3,ItemisedExpenses[Invoice date],\"<=\"&K$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[August]]&_YEAR),Other[Date cheque request initiated],\"<=\"&K$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&L$3,ItemisedExpenses[Invoice date],\"<=\"&L$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[September]]&_YEAR),Other[Date cheque request initiated],\"<=\"&L$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&M$3,ItemisedExpenses[Invoice date],\"<=\"&M$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[October]]&_YEAR),Other[Date cheque request initiated],\"<=\"&M$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&N$3,ItemisedExpenses[Invoice date],\"<=\"&N$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[November]]&_YEAR),Other[Date cheque request initiated],\"<=\"&N$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&O$3,ItemisedExpenses[Invoice date],\"<=\"&O$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[December]]&_YEAR),Other[Date cheque request initiated],\"<=\"&O$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUM(MonthlyExpensesSummary[[#This Row],[January]:[December]])","v":{"v":0,"d":"£0.00"}}]
[null,5000,"Supplies",{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&D$3,ItemisedExpenses[Invoice date],\"<=\"&D$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[January]]&_YEAR),Other[Date cheque request initiated],\"<=\"&D$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&E$3,ItemisedExpenses[Invoice date],\"<=\"&E$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[February]]&_YEAR),Other[Date cheque request initiated],\"<=\"&E$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&F$3,ItemisedExpenses[Invoice date],\"<=\"&F$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[March]]&_YEAR),Other[Date cheque request initiated],\"<=\"&F$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&G$3,ItemisedExpenses[Invoice date],\"<=\"&G$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[April]]&_YEAR),Other[Date cheque request initiated],\"<=\"&G$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&H$3,ItemisedExpenses[Invoice date],\"<=\"&H$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[May]]&_YEAR),Other[Date cheque request initiated],\"<=\"&H$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&I$3,ItemisedExpenses[Invoice date],\"<=\"&I$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[June]]&_YEAR),Other[Date cheque request initiated],\"<=\"&I$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&J$3,ItemisedExpenses[Invoice date],\"<=\"&J$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[July]]&_YEAR),Other[Date cheque request initiated],\"<=\"&J$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&K$3,ItemisedExpenses[Invoice date],\"<=\"&K$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[August]]&_YEAR),Other[Date cheque request initiated],\"<=\"&K$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&L$3,ItemisedExpenses[Invoice date],\"<=\"&L$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[September]]&_YEAR),Other[Date cheque request initiated],\"<=\"&L$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&M$3,ItemisedExpenses[Invoice date],\"<=\"&M$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[October]]&_YEAR),Other[Date cheque request initiated],\"<=\"&M$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&N$3,ItemisedExpenses[Invoice date],\"<=\"&N$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[November]]&_YEAR),Other[Date cheque request initiated],\"<=\"&N$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&O$3,ItemisedExpenses[Invoice date],\"<=\"&O$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[December]]&_YEAR),Other[Date cheque request initiated],\"<=\"&O$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUM(MonthlyExpensesSummary[[#This Row],[January]:[December]])","v":{"v":0,"d":"£0.00"}}]
[null,6000,"Client expenses",{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&D$3,ItemisedExpenses[Invoice date],\"<=\"&D$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[January]]&_YEAR),Other[Date cheque request initiated],\"<=\"&D$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&E$3,ItemisedExpenses[Invoice date],\"<=\"&E$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[February]]&_YEAR),Other[Date cheque request initiated],\"<=\"&E$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&F$3,ItemisedExpenses[Invoice date],\"<=\"&F$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[March]]&_YEAR),Other[Date cheque request initiated],\"<=\"&F$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&G$3,ItemisedExpenses[Invoice date],\"<=\"&G$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[April]]&_YEAR),Other[Date cheque request initiated],\"<=\"&G$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&H$3,ItemisedExpenses[Invoice date],\"<=\"&H$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[May]]&_YEAR),Other[Date cheque request initiated],\"<=\"&H$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&I$3,ItemisedExpenses[Invoice date],\"<=\"&I$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[June]]&_YEAR),Other[Date cheque request initiated],\"<=\"&I$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&J$3,ItemisedExpenses[Invoice date],\"<=\"&J$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[July]]&_YEAR),Other[Date cheque request initiated],\"<=\"&J$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&K$3,ItemisedExpenses[Invoice date],\"<=\"&K$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[August]]&_YEAR),Other[Date cheque request initiated],\"<=\"&K$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&L$3,ItemisedExpenses[Invoice date],\"<=\"&L$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[September]]&_YEAR),Other[Date cheque request initiated],\"<=\"&L$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&M$3,ItemisedExpenses[Invoice date],\"<=\"&M$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[October]]&_YEAR),Other[Date cheque request initiated],\"<=\"&M$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&N$3,ItemisedExpenses[Invoice date],\"<=\"&N$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[November]]&_YEAR),Other[Date cheque request initiated],\"<=\"&N$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&O$3,ItemisedExpenses[Invoice date],\"<=\"&O$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[December]]&_YEAR),Other[Date cheque request initiated],\"<=\"&O$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUM(MonthlyExpensesSummary[[#This Row],[January]:[December]])","v":{"v":0,"d":"£0.00"}}]
[null,7000,"Computers",{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&D$3,ItemisedExpenses[Invoice date],\"<=\"&D$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[January]]&_YEAR),Other[Date cheque request initiated],\"<=\"&D$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&E$3,ItemisedExpenses[Invoice date],\"<=\"&E$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[February]]&_YEAR),Other[Date cheque request initiated],\"<=\"&E$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&F$3,ItemisedExpenses[Invoice date],\"<=\"&F$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[March]]&_YEAR),Other[Date cheque request initiated],\"<=\"&F$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&G$3,ItemisedExpenses[Invoice date],\"<=\"&G$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[April]]&_YEAR),Other[Date cheque request initiated],\"<=\"&G$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&H$3,ItemisedExpenses[Invoice date],\"<=\"&H$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[May]]&_YEAR),Other[Date cheque request initiated],\"<=\"&H$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&I$3,ItemisedExpenses[Invoice date],\"<=\"&I$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[June]]&_YEAR),Other[Date cheque request initiated],\"<=\"&I$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&J$3,ItemisedExpenses[Invoice date],\"<=\"&J$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[July]]&_YEAR),Other[Date cheque request initiated],\"<=\"&J$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&K$3,ItemisedExpenses[Invoice date],\"<=\"&K$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[August]]&_YEAR),Other[Date cheque request initiated],\"<=\"&K$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&L$3,ItemisedExpenses[Invoice date],\"<=\"&L$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[September]]&_YEAR),Other[Date cheque request initiated],\"<=\"&L$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&M$3,ItemisedExpenses[Invoice date],\"<=\"&M$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[October]]&_YEAR),Other[Date cheque request initiated],\"<=\"&M$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&N$3,ItemisedExpenses[Invoice date],\"<=\"&N$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[November]]&_YEAR),Other[Date cheque request initiated],\"<=\"&N$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&O$3,ItemisedExpenses[Invoice date],\"<=\"&O$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[December]]&_YEAR),Other[Date cheque request initiated],\"<=\"&O$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUM(MonthlyExpensesSummary[[#This Row],[January]:[December]])","v":{"v":0,"d":"£0.00"}}]
[null,8000,"Medical plan",{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&D$3,ItemisedExpenses[Invoice date],\"<=\"&D$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[January]]&_YEAR),Other[Date cheque request initiated],\"<=\"&D$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&E$3,ItemisedExpenses[Invoice date],\"<=\"&E$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[February]]&_YEAR),Other[Date cheque request initiated],\"<=\"&E$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&F$3,ItemisedExpenses[Invoice date],\"<=\"&F$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[March]]&_YEAR),Other[Date cheque request initiated],\"<=\"&F$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&G$3,ItemisedExpenses[Invoice date],\"<=\"&G$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[April]]&_YEAR),Other[Date cheque request initiated],\"<=\"&G$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&H$3,ItemisedExpenses[Invoice date],\"<=\"&H$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[May]]&_YEAR),Other[Date cheque request initiated],\"<=\"&H$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&I$3,ItemisedExpenses[Invoice date],\"<=\"&I$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[June]]&_YEAR),Other[Date cheque request initiated],\"<=\"&I$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&J$3,ItemisedExpenses[Invoice date],\"<=\"&J$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[July]]&_YEAR),Other[Date cheque request initiated],\"<=\"&J$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&K$3,ItemisedExpenses[Invoice date],\"<=\"&K$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[August]]&_YEAR),Other[Date cheque request initiated],\"<=\"&K$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&L$3,ItemisedExpenses[Invoice date],\"<=\"&L$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[September]]&_YEAR),Other[Date cheque request initiated],\"<=\"&L$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&M$3,ItemisedExpenses[Invoice date],\"<=\"&M$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[October]]&_YEAR),Other[Date cheque request initiated],\"<=\"&M$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&N$3,ItemisedExpenses[Invoice date],\"<=\"&N$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[November]]&_YEAR),Other[Date cheque request initiated],\"<=\"&N$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&O$3,ItemisedExpenses[Invoice date],\"<=\"&O$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[December]]&_YEAR),Other[Date cheque request initiated],\"<=\"&O$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUM(MonthlyExpensesSummary[[#This Row],[January]:[December]])","v":{"v":0,"d":"£0.00"}}]
[null,9000,"Building costs",{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&D$3,ItemisedExpenses[Invoice date],\"<=\"&D$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[January]]&_YEAR),Other[Date cheque request initiated],\"<=\"&D$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&E$3,ItemisedExpenses[Invoice date],\"<=\"&E$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[February]]&_YEAR),Other[Date cheque request initiated],\"<=\"&E$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&F$3,ItemisedExpenses[Invoice date],\"<=\"&F$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[March]]&_YEAR),Other[Date cheque request initiated],\"<=\"&F$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&G$3,ItemisedExpenses[Invoice date],\"<=\"&G$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[April]]&_YEAR),Other[Date cheque request initiated],\"<=\"&G$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&H$3,ItemisedExpenses[Invoice date],\"<=\"&H$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[May]]&_YEAR),Other[Date cheque request initiated],\"<=\"&H$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&I$3,ItemisedExpenses[Invoice date],\"<=\"&I$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[June]]&_YEAR),Other[Date cheque request initiated],\"<=\"&I$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&J$3,ItemisedExpenses[Invoice date],\"<=\"&J$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[July]]&_YEAR),Other[Date cheque request initiated],\"<=\"&J$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&K$3,ItemisedExpenses[Invoice date],\"<=\"&K$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[August]]&_YEAR),Other[Date cheque request initiated],\"<=\"&K$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&L$3,ItemisedExpenses[Invoice date],\"<=\"&L$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[September]]&_YEAR),Other[Date cheque request initiated],\"<=\"&L$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&M$3,ItemisedExpenses[Invoice date],\"<=\"&M$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[October]]&_YEAR),Other[Date cheque request initiated],\"<=\"&M$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&N$3,ItemisedExpenses[Invoice date],\"<=\"&N$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[November]]&_YEAR),Other[Date cheque request initiated],\"<=\"&N$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&O$3,ItemisedExpenses[Invoice date],\"<=\"&O$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[December]]&_YEAR),Other[Date cheque request initiated],\"<=\"&O$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUM(MonthlyExpensesSummary[[#This Row],[January]:[December]])","v":{"v":0,"d":"£0.00"}}]
[null,10000,"Marketing",{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&D$3,ItemisedExpenses[Invoice date],\"<=\"&D$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[January]]&_YEAR),Other[Date cheque request initiated],\"<=\"&D$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&E$3,ItemisedExpenses[Invoice date],\"<=\"&E$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[February]]&_YEAR),Other[Date cheque request initiated],\"<=\"&E$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&F$3,ItemisedExpenses[Invoice date],\"<=\"&F$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[March]]&_YEAR),Other[Date cheque request initiated],\"<=\"&F$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&G$3,ItemisedExpenses[Invoice date],\"<=\"&G$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[April]]&_YEAR),Other[Date cheque request initiated],\"<=\"&G$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&H$3,ItemisedExpenses[Invoice date],\"<=\"&H$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[May]]&_YEAR),Other[Date cheque request initiated],\"<=\"&H$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&I$3,ItemisedExpenses[Invoice date],\"<=\"&I$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[June]]&_YEAR),Other[Date cheque request initiated],\"<=\"&I$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&J$3,ItemisedExpenses[Invoice date],\"<=\"&J$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[July]]&_YEAR),Other[Date cheque request initiated],\"<=\"&J$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&K$3,ItemisedExpenses[Invoice date],\"<=\"&K$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[August]]&_YEAR),Other[Date cheque request initiated],\"<=\"&K$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&L$3,ItemisedExpenses[Invoice date],\"<=\"&L$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[September]]&_YEAR),Other[Date cheque request initiated],\"<=\"&L$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&M$3,ItemisedExpenses[Invoice date],\"<=\"&M$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[October]]&_YEAR),Other[Date cheque request initiated],\"<=\"&M$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&N$3,ItemisedExpenses[Invoice date],\"<=\"&N$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[November]]&_YEAR),Other[Date cheque request initiated],\"<=\"&N$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&O$3,ItemisedExpenses[Invoice date],\"<=\"&O$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[December]]&_YEAR),Other[Date cheque request initiated],\"<=\"&O$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUM(MonthlyExpensesSummary[[#This Row],[January]:[December]])","v":{"v":0,"d":"£0.00"}}]
[null,11000,"Charitables",{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&D$3,ItemisedExpenses[Invoice date],\"<=\"&D$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[January]]&_YEAR),Other[Date cheque request initiated],\"<=\"&D$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&E$3,ItemisedExpenses[Invoice date],\"<=\"&E$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[February]]&_YEAR),Other[Date cheque request initiated],\"<=\"&E$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&F$3,ItemisedExpenses[Invoice date],\"<=\"&F$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[March]]&_YEAR),Other[Date cheque request initiated],\"<=\"&F$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&G$3,ItemisedExpenses[Invoice date],\"<=\"&G$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[April]]&_YEAR),Other[Date cheque request initiated],\"<=\"&G$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&H$3,ItemisedExpenses[Invoice date],\"<=\"&H$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[May]]&_YEAR),Other[Date cheque request initiated],\"<=\"&H$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&I$3,ItemisedExpenses[Invoice date],\"<=\"&I$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[June]]&_YEAR),Other[Date cheque request initiated],\"<=\"&I$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&J$3,ItemisedExpenses[Invoice date],\"<=\"&J$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[July]]&_YEAR),Other[Date cheque request initiated],\"<=\"&J$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&K$3,ItemisedExpenses[Invoice date],\"<=\"&K$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[August]]&_YEAR),Other[Date cheque request initiated],\"<=\"&K$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&L$3,ItemisedExpenses[Invoice date],\"<=\"&L$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[September]]&_YEAR),Other[Date cheque request initiated],\"<=\"&L$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&M$3,ItemisedExpenses[Invoice date],\"<=\"&M$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[October]]&_YEAR),Other[Date cheque request initiated],\"<=\"&M$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&N$3,ItemisedExpenses[Invoice date],\"<=\"&N$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[November]]&_YEAR),Other[Date cheque request initiated],\"<=\"&N$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&O$3,ItemisedExpenses[Invoice date],\"<=\"&O$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[December]]&_YEAR),Other[Date cheque request initiated],\"<=\"&O$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUM(MonthlyExpensesSummary[[#This Row],[January]:[December]])","v":{"v":0,"d":"£0.00"}}]
[null,12000,"Sponsorships",{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&D$3,ItemisedExpenses[Invoice date],\"<=\"&D$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[January]]&_YEAR),Other[Date cheque request initiated],\"<=\"&D$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&E$3,ItemisedExpenses[Invoice date],\"<=\"&E$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[February]]&_YEAR),Other[Date cheque request initiated],\"<=\"&E$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&F$3,ItemisedExpenses[Invoice date],\"<=\"&F$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[March]]&_YEAR),Other[Date cheque request initiated],\"<=\"&F$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&G$3,ItemisedExpenses[Invoice date],\"<=\"&G$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[April]]&_YEAR),Other[Date cheque request initiated],\"<=\"&G$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&H$3,ItemisedExpenses[Invoice date],\"<=\"&H$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[May]]&_YEAR),Other[Date cheque request initiated],\"<=\"&H$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&I$3,ItemisedExpenses[Invoice date],\"<=\"&I$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[June]]&_YEAR),Other[Date cheque request initiated],\"<=\"&I$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&J$3,ItemisedExpenses[Invoice date],\"<=\"&J$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[July]]&_YEAR),Other[Date cheque request initiated],\"<=\"&J$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&K$3,ItemisedExpenses[Invoice date],\"<=\"&K$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[August]]&_YEAR),Other[Date cheque request initiated],\"<=\"&K$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&L$3,ItemisedExpenses[Invoice date],\"<=\"&L$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[September]]&_YEAR),Other[Date cheque request initiated],\"<=\"&L$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&M$3,ItemisedExpenses[Invoice date],\"<=\"&M$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[October]]&_YEAR),Other[Date cheque request initiated],\"<=\"&M$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&N$3,ItemisedExpenses[Invoice date],\"<=\"&N$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[November]]&_YEAR),Other[Date cheque request initiated],\"<=\"&N$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUMIFS(ItemisedExpenses[Cheque amount],ItemisedExpenses[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],ItemisedExpenses[Invoice date],\">=\"&O$3,ItemisedExpenses[Invoice date],\"<=\"&O$4)+SUMIFS(Other[Cheque amount],Other[G/L code],MonthlyExpensesSummary[[#This Row],[G/L code]],Other[Date cheque request initiated],\">=\"&DATEVALUE(\" 1 \"&MonthlyExpensesSummary[[#Headers],[December]]&_YEAR),Other[Date cheque request initiated],\"<=\"&O$4)","v":{"v":0,"d":"£0.00"}},{"$f":"SUM(MonthlyExpensesSummary[[#This Row],[January]:[December]])","v":{"v":0,"d":"£0.00"}}]
[null,"Total",null,{"$f":"SUBTOTAL(109,MonthlyExpensesSummary[January])","v":{"v":0,"d":"£0.00"}},{"$f":"SUBTOTAL(109,MonthlyExpensesSummary[February])","v":{"v":0,"d":"£0.00"}},{"$f":"SUBTOTAL(109,MonthlyExpensesSummary[March])","v":{"v":0,"d":"£0.00"}},{"$f":"SUBTOTAL(109,MonthlyExpensesSummary[April])","v":{"v":0,"d":"£0.00"}},{"$f":"SUBTOTAL(109,MonthlyExpensesSummary[May])","v":{"v":0,"d":"£0.00"}},{"$f":"SUBTOTAL(109,MonthlyExpensesSummary[June])","v":{"v":0,"d":"£0.00"}},{"$f":"SUBTOTAL(109,MonthlyExpensesSummary[July])","v":{"v":0,"d":"£0.00"}},{"$f":"SUBTOTAL(109,MonthlyExpensesSummary[August])","v":{"v":0,"d":"£0.00"}},{"$f":"SUBTOTAL(109,MonthlyExpensesSummary[September])","v":{"v":0,"d":"£0.00"}},{"$f":"SUBTOTAL(109,MonthlyExpensesSummary[October])","v":{"v":0,"d":"£0.00"}},{"$f":"SUBTOTAL(109,MonthlyExpensesSummary[November])","v":{"v":0,"d":"£0.00"}},{"$f":"SUBTOTAL(109,MonthlyExpensesSummary[December])","v":{"v":0,"d":"£0.00"}},{"$f":"SUBTOTAL(109,MonthlyExpensesSummary[Total])","v":{"v":0,"d":"£0.00"}}]

{"sheet":"ITEMISED EXPENSES","index":2,"n_rows":6,"n_cols":10,"rows_kept":6,"merged":[[1,1,1,9],[2,1,2,5],[2,6,2,9]]}
[]
[null,"ITEMISED EXPENSES"]
[]
[null,"G/L code","Invoice date","Invoice no.","Requested by","Cheque amount","Payee","Cheque use","Method of distribution","File date"]
[null,1000,"Date",100,"Andy Teal",{"v":750.75,"d":"£750.75"},"Consolidated Messenger ","Mailer","Post","Date"]
[null,7000,"Date",101,"Robert Walters",{"v":2500,"d":"£2,500.00"},"A. Datum Corporation ","Two desktop computers","Credit","Date"]

{"sheet":"CHARITABLES & SPONSORSHIPS","index":3,"n_rows":6,"n_cols":12,"rows_kept":6,"merged":[[1,1,1,11],[2,1,2,5],[2,6,2,11]]}
[]
[null,"CHARITABLES & SPONSORSHIPS"]
[]
[null,"G/L code","Date cheque request initiated","Requested by","Cheque amount","Previous year contribution","Payee","Used for","Signed off by","Category","Method of distribution","File date"]
[null,12000,"Date","Susan W. Eaton",{"v":1000,"d":"£1,000.00"},{"v":12,"d":"£12.00"},"School of Fine Art ","Scholarships","Kim Ralls","Arts","Cheque","Date"]
[null,11000,"Date","Susan W. Eaton",{"v":2500,"d":"£2,500.00"},{"v":0,"d":"£0.00"},"Wingtip Toys ","Community","Kathie Flood","Community","Cheque","Date"]