{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Forecast","Actuals","Guide"],"read":"whole","date_system":"1900"}

{"sheet":"Forecast","index":0,"n_rows":48,"n_cols":15,"rows_kept":48}
[]
[null,"BriQs Group: 13-week cash forecast",{"$nulls":10},"Case selected:",null,{"$f":"CHOOSE('Forecast'!$O$4,\"Base\",\"Downside\")","v":"Base"}]
[]
[null,"Start week (Monday)","2026-09-14",null,null,"Opening cash (EUR)",null,{"v":42000,"d":"€42,000"},null,"Minimum cash (EUR)",null,{"v":15000,"d":"€15,000"},null,"Case number",1]
[null,"Yellow cells are editable. Enter zero when no cash is expected. See Guide before rolling the dates.",{"$nulls":10},"1 = Base, 2 = Downside"]
[]
[null,"Lowest closing cash",{"$nulls":3},"Weeks below minimum",{"$nulls":4},"Week 13 closing cash"]
[null,{"$f":"IF(COUNT(C26:O26)=13,MIN(C26:O26),\"Missing input\")","v":{"v":22000,"d":"€22,000"}},{"$nulls":3},{"$f":"IF(COUNT(C28:O28)=13,COUNTIFS(C28:O28,\"<0\"),\"Missing input\")","v":0},{"$nulls":4},{"$f":"O26","v":{"v":48000,"d":"€48,000"}}]
[]
[null,"EUR, whole amounts. The supplied forecast and actuals are an original synthetic example. Replace them with your own figures."]
[]
[null,"Week starting (EUR)",{"$f":"$C$4","v":"2026-09-14"},{"$f":"C12+7","v":"2026-09-21"},{"$f":"D12+7","v":"2026-09-28"},{"$f":"E12+7","v":"2026-10-05"},{"$f":"F12+7","v":"2026-10-12"},{"$f":"G12+7","v":"2026-10-19"},{"$f":"H12+7","v":"2026-10-26"},{"$f":"I12+7","v":"2026-11-02"},{"$f":"J12+7","v":"2026-11-09"},{"$f":"K12+7","v":"2026-11-16"},{"$f":"L12+7","v":"2026-11-23"},{"$f":"M12+7","v":"2026-11-30"},{"$f":"N12+7","v":"2026-12-07"}]
[null,"Opening cash",{"$f":"IF(ISNUMBER($H$4),$H$4,\"n.a.\")","v":{"v":42000,"d":"€42,000"}},{"$f":"C26","v":{"v":35000,"d":"€35,000"}},{"$f":"D26","v":{"v":40000,"d":"€40,000"}},{"$f":"E26","v":{"v":22000,"d":"€22,000"}},{"$f":"F26","v":{"v":40000,"d":"€40,000"}},{"$f":"G26","v":{"v":34000,"d":"€34,000"}},{"$f":"H26","v":{"v":41000,"d":"€41,000"}},{"$f":"I26","v":{"v":36000,"d":"€36,000"}},{"$f":"J26","v":{"v":46000,"d":"€46,000"}},{"$f":"K26","v":{"v":37000,"d":"€37,000"}},{"$f":"L26","v":{"v":48000,"d":"€48,000"}},{"$f":"M26","v":{"v":49000,"d":"€49,000"}},{"$f":"N26","v":{"v":47000,"d":"€47,000"}}]
[null,"Customer collections",{"$f":"C34","v":{"v":20000,"d":"20,000"}},{"$f":"D34","v":{"v":28000,"d":"28,000"}},{"$f":"E34","v":{"v":18000,"d":"18,000"}},{"$f":"F34","v":{"v":32000,"d":"32,000"}},{"$f":"G34","v":{"v":27000,"d":"27,000"}},{"$f":"H34","v":{"v":22000,"d":"22,000"}},{"$f":"I34","v":{"v":34000,"d":"34,000"}},{"$f":"J34","v":{"v":26000,"d":"26,000"}},{"$f":"K34","v":{"v":24000,"d":"24,000"}},{"$f":"L34","v":{"v":36000,"d":"36,000"}},{"$f":"M34","v":{"v":30000,"d":"30,000"}},{"$f":"N34","v":{"v":28000,"d":"28,000"}},{"$f":"O34","v":{"v":38000,"d":"38,000"}}]
[null,"Other cash receipts",{"$f":"IF(ISNUMBER(C38),C38,\"n.a.\")","v":0},{"$f":"IF(ISNUMBER(D38),D38,\"n.a.\")","v":0},{"$f":"IF(ISNUMBER(E38),E38,\"n.a.\")","v":0},{"$f":"IF(ISNUMBER(F38),F38,\"n.a.\")","v":0},{"$f":"IF(ISNUMBER(G38),G38,\"n.a.\")","v":0},{"$f":"IF(ISNUMBER(H38),H38,\"n.a.\")","v":{"v":5000,"d":"5,000"}},{"$f":"IF(ISNUMBER(I38),I38,\"n.a.\")","v":0},{"$f":"IF(ISNUMBER(J38),J38,\"n.a.\")","v":0},{"$f":"IF(ISNUMBER(K38),K38,\"n.a.\")","v":0},{"$f":"IF(ISNUMBER(L38),L38,\"n.a.\")","v":{"v":2000,"d":"2,000"}},{"$f":"IF(ISNUMBER(M38),M38,\"n.a.\")","v":0},{"$f":"IF(ISNUMBER(N38),N38,\"n.a.\")","v":0},{"$f":"IF(ISNUMBER(O38),O38,\"n.a.\")","v":0}]
[null,"Total cash receipts",{"$f":"IF(COUNT(C14:C15)=2,SUM(C14:C15),\"n.a.\")","v":{"v":20000,"d":"€20,000"}},{"$f":"IF(COUNT(D14:D15)=2,SUM(D14:D15),\"n.a.\")","v":{"v":28000,"d":"€28,000"}},{"$f":"IF(COUNT(E14:E15)=2,SUM(E14:E15),\"n.a.\")","v":{"v":18000,"d":"€18,000"}},{"$f":"IF(COUNT(F14:F15)=2,SUM(F14:F15),\"n.a.\")","v":{"v":32000,"d":"€32,000"}},{"$f":"IF(COUNT(G14:G15)=2,SUM(G14:G15),\"n.a.\")","v":{"v":27000,"d":"€27,000"}},{"$f":"IF(COUNT(H14:H15)=2,SUM(H14:H15),\"n.a.\")","v":{"v":27000,"d":"€27,000"}},{"$f":"IF(COUNT(I14:I15)=2,SUM(I14:I15),\"n.a.\")","v":{"v":34000,"d":"€34,000"}},{"$f":"IF(COUNT(J14:J15)=2,SUM(J14:J15),\"n.a.\")","v":{"v":26000,"d":"€26,000"}},{"$f":"IF(COUNT(K14:K15)=2,SUM(K14:K15),\"n.a.\")","v":{"v":24000,"d":"€24,000"}},{"$f":"IF(COUNT(L14:L15)=2,SUM(L14:L15),\"n.a.\")","v":{"v":38000,"d":"€38,000"}},{"$f":"IF(COUNT(M14:M15)=2,SUM(M14:M15),\"n.a.\")","v":{"v":30000,"d":"€30,000"}},{"$f":"IF(COUNT(N14:N15)=2,SUM(N14:N15),\"n.a.\")","v":{"v":28000,"d":"€28,000"}},{"$f":"IF(COUNT(O14:O15)=2,SUM(O14:O15),\"n.a.\")","v":{"v":38000,"d":"€38,000"}}]
[]
[null,"Supplier payments",{"$f":"IF(ISNUMBER(C41),C41,\"n.a.\")","v":{"v":12000,"d":"12,000"}},{"$f":"IF(ISNUMBER(D41),D41,\"n.a.\")","v":{"v":16000,"d":"16,000"}},{"$f":"IF(ISNUMBER(E41),E41,\"n.a.\")","v":{"v":18000,"d":"18,000"}},{"$f":"IF(ISNUMBER(F41),F41,\"n.a.\")","v":{"v":14000,"d":"14,000"}},{"$f":"IF(ISNUMBER(G41),G41,\"n.a.\")","v":{"v":18000,"d":"18,000"}},{"$f":"IF(ISNUMBER(H41),H41,\"n.a.\")","v":{"v":14000,"d":"14,000"}},{"$f":"IF(ISNUMBER(I41),I41,\"n.a.\")","v":{"v":19000,"d":"19,000"}},{"$f":"IF(ISNUMBER(J41),J41,\"n.a.\")","v":{"v":16000,"d":"16,000"}},{"$f":"IF(ISNUMBER(K41),K41,\"n.a.\")","v":{"v":18000,"d":"18,000"}},{"$f":"IF(ISNUMBER(L41),L41,\"n.a.\")","v":{"v":20000,"d":"20,000"}},{"$f":"IF(ISNUMBER(M41),M41,\"n.a.\")","v":{"v":19000,"d":"19,000"}},{"$f":"IF(ISNUMBER(N41),N41,\"n.a.\")","v":{"v":18000,"d":"18,000"}},{"$f":"IF(ISNUMBER(O41),O41,\"n.a.\")","v":{"v":22000,"d":"22,000"}}]
[null,"Payroll payments",{"$f":"IF(ISNUMBER(C42),C42,\"n.a.\")","v":{"v":10000,"d":"10,000"}},{"$f":"IF(ISNUMBER(D42),D42,\"n.a.\")","v":0},{"$f":"IF(ISNUMBER(E42),E42,\"n.a.\")","v":{"v":10000,"d":"10,000"}},{"$f":"IF(ISNUMBER(F42),F42,\"n.a.\")","v":0},{"$f":"IF(ISNUMBER(G42),G42,\"n.a.\")","v":{"v":10000,"d":"10,000"}},{"$f":"IF(ISNUMBER(H42),H42,\"n.a.\")","v":0},{"$f":"IF(ISNUMBER(I42),I42,\"n.a.\")","v":{"v":10000,"d":"10,000"}},{"$f":"IF(ISNUMBER(J42),J42,\"n.a.\")","v":0},{"$f":"IF(ISNUMBER(K42),K42,\"n.a.\")","v":{"v":10000,"d":"10,000"}},{"$f":"IF(ISNUMBER(L42),L42,\"n.a.\")","v":0},{"$f":"IF(ISNUMBER(M42),M42,\"n.a.\")","v":{"v":10000,"d":"10,000"}},{"$f":"IF(ISNUMBER(N42),N42,\"n.a.\")","v":0},{"$f":"IF(ISNUMBER(O42),O42,\"n.a.\")","v":{"v":10000,"d":"10,000"}}]
[null,"Rent and utilities",{"$f":"IF(ISNUMBER(C43),C43,\"n.a.\")","v":{"v":3000,"d":"3,000"}},{"$f":"IF(ISNUMBER(D43),D43,\"n.a.\")","v":0},{"$f":"IF(ISNUMBER(E43),E43,\"n.a.\")","v":0},{"$f":"IF(ISNUMBER(F43),F43,\"n.a.\")","v":0},{"$f":"IF(ISNUMBER(G43),G43,\"n.a.\")","v":{"v":3000,"d":"3,000"}},{"$f":"IF(ISNUMBER(H43),H43,\"n.a.\")","v":0},{"$f":"IF(ISNUMBER(I43),I43,\"n.a.\")","v":0},{"$f":"IF(ISNUMBER(J43),J43,\"n.a.\")","v":0},{"$f":"IF(ISNUMBER(K43),K43,\"n.a.\")","v":{"v":3000,"d":"3,000"}},{"$f":"IF(ISNUMBER(L43),L43,\"n.a.\")","v":0},{"$f":"IF(ISNUMBER(M43),M43,\"n.a.\")","v":0},{"$f":"IF(ISNUMBER(N43),N43,\"n.a.\")","v":0},{"$f":"IF(ISNUMBER(O43),O43,\"n.a.\")","v":{"v":3000,"d":"3,000"}}]
[null,"Tax payments",{"$f":"IF(ISNUMBER(C44),C44,\"n.a.\")","v":0},{"$f":"IF(ISNUMBER(D44),D44,\"n.a.\")","v":{"v":7000,"d":"7,000"}},{"$f":"IF(ISNUMBER(E44),E44,\"n.a.\")","v":0},{"$f":"IF(ISNUMBER(F44),F44,\"n.a.\")","v":0},{"$f":"IF(ISNUMBER(G44),G44,\"n.a.\")","v":0},{"$f":"IF(ISNUMBER(H44),H44,\"n.a.\")","v":{"v":6000,"d":"6,000"}},{"$f":"IF(ISNUMBER(I44),I44,\"n.a.\")","v":0},{"$f":"IF(ISNUMBER(J44),J44,\"n.a.\")","v":0},{"$f":"IF(ISNUMBER(K44),K44,\"n.a.\")","v":0},{"$f":"IF(ISNUMBER(L44),L44,\"n.a.\")","v":{"v":7000,"d":"7,000"}},{"$f":"IF(ISNUMBER(M44),M44,\"n.a.\")","v":0},{"$f":"IF(ISNUMBER(N44),N44,\"n.a.\")","v":0},{"$f":"IF(ISNUMBER(O44),O44,\"n.a.\")","v":0}]
[null,"Debt service",{"$f":"IF(ISNUMBER(C45),C45,\"n.a.\")","v":{"v":2000,"d":"2,000"}},{"$f":"IF(ISNUMBER(D45),D45,\"n.a.\")","v":0},{"$f":"IF(ISNUMBER(E45),E45,\"n.a.\")","v":0},{"$f":"IF(ISNUMBER(F45),F45,\"n.a.\")","v":0},{"$f":"IF(ISNUMBER(G45),G45,\"n.a.\")","v":{"v":2000,"d":"2,000"}},{"$f":"IF(ISNUMBER(H45),H45,\"n.a.\")","v":0},{"$f":"IF(ISNUMBER(I45),I45,\"n.a.\")","v":0},{"$f":"IF(ISNUMBER(J45),J45,\"n.a.\")","v":0},{"$f":"IF(ISNUMBER(K45),K45,\"n.a.\")","v":{"v":2000,"d":"2,000"}},{"$f":"IF(ISNUMBER(L45),L45,\"n.a.\")","v":0},{"$f":"IF(ISNUMBER(M45),M45,\"n.a.\")","v":0},{"$f":"IF(ISNUMBER(N45),N45,\"n.a.\")","v":0},{"$f":"IF(ISNUMBER(O45),O45,\"n.a.\")","v":{"v":2000,"d":"2,000"}}]
[null,"Capital expenditure",{"$f":"IF(ISNUMBER(C46),C46,\"n.a.\")","v":0},{"$f":"IF(ISNUMBER(D46),D46,\"n.a.\")","v":0},{"$f":"IF(ISNUMBER(E46),E46,\"n.a.\")","v":{"v":8000,"d":"8,000"}},{"$f":"IF(ISNUMBER(F46),F46,\"n.a.\")","v":0},{"$f":"IF(ISNUMBER(G46),G46,\"n.a.\")","v":0},{"$f":"IF(ISNUMBER(H46),H46,\"n.a.\")","v":0},{"$f":"IF(ISNUMBER(I46),I46,\"n.a.\")","v":{"v":10000,"d":"10,000"}},{"$f":"IF(ISNUMBER(J46),J46,\"n.a.\")","v":0},{"$f":"IF(ISNUMBER(K46),K46,\"n.a.\")","v":0},{"$f":"IF(ISNUMBER(L46),L46,\"n.a.\")","v":0},{"$f":"IF(ISNUMBER(M46),M46,\"n.a.\")","v":0},{"$f":"IF(ISNUMBER(N46),N46,\"n.a.\")","v":{"v":12000,"d":"12,000"}},{"$f":"IF(ISNUMBER(O46),O46,\"n.a.\")","v":0}]
[null,"Total cash payments",{"$f":"IF(COUNT(C18:C23)=6,SUM(C18:C23),\"n.a.\")","v":{"v":27000,"d":"€27,000"}},{"$f":"IF(COUNT(D18:D23)=6,SUM(D18:D23),\"n.a.\")","v":{"v":23000,"d":"€23,000"}},{"$f":"IF(COUNT(E18:E23)=6,SUM(E18:E23),\"n.a.\")","v":{"v":36000,"d":"€36,000"}},{"$f":"IF(COUNT(F18:F23)=6,SUM(F18:F23),\"n.a.\")","v":{"v":14000,"d":"€14,000"}},{"$f":"IF(COUNT(G18:G23)=6,SUM(G18:G23),\"n.a.\")","v":{"v":33000,"d":"€33,000"}},{"$f":"IF(COUNT(H18:H23)=6,SUM(H18:H23),\"n.a.\")","v":{"v":20000,"d":"€20,000"}},{"$f":"IF(COUNT(I18:I23)=6,SUM(I18:I23),\"n.a.\")","v":{"v":39000,"d":"€39,000"}},{"$f":"IF(COUNT(J18:J23)=6,SUM(J18:J23),\"n.a.\")","v":{"v":16000,"d":"€16,000"}},{"$f":"IF(COUNT(K18:K23)=6,SUM(K18:K23),\"n.a.\")","v":{"v":33000,"d":"€33,000"}},{"$f":"IF(COUNT(L18:L23)=6,SUM(L18:L23),\"n.a.\")","v":{"v":27000,"d":"€27,000"}},{"$f":"IF(COUNT(M18:M23)=6,SUM(M18:M23),\"n.a.\")","v":{"v":29000,"d":"€29,000"}},{"$f":"IF(COUNT(N18:N23)=6,SUM(N18:N23),\"n.a.\")","v":{"v":30000,"d":"€30,000"}},{"$f":"IF(COUNT(O18:O23)=6,SUM(O18:O23),\"n.a.\")","v":{"v":37000,"d":"€37,000"}}]
[null,"Net cash flow",{"$f":"IF(COUNT(C16,C24)=2,C16-C24,\"n.a.\")","v":{"v":-7000,"d":"(€7,000)"}},{"$f":"IF(COUNT(D16,D24)=2,D16-D24,\"n.a.\")","v":{"v":5000,"d":"€5,000"}},{"$f":"IF(COUNT(E16,E24)=2,E16-E24,\"n.a.\")","v":{"v":-18000,"d":"(€18,000)"}},{"$f":"IF(COUNT(F16,F24)=2,F16-F24,\"n.a.\")","v":{"v":18000,"d":"€18,000"}},{"$f":"IF(COUNT(G16,G24)=2,G16-G24,\"n.a.\")","v":{"v":-6000,"d":"(€6,000)"}},{"$f":"IF(COUNT(H16,H24)=2,H16-H24,\"n.a.\")","v":{"v":7000,"d":"€7,000"}},{"$f":"IF(COUNT(I16,I24)=2,I16-I24,\"n.a.\")","v":{"v":-5000,"d":"(€5,000)"}},{"$f":"IF(COUNT(J16,J24)=2,J16-J24,\"n.a.\")","v":{"v":10000,"d":"€10,000"}},{"$f":"IF(COUNT(K16,K24)=2,K16-K24,\"n.a.\")","v":{"v":-9000,"d":"(€9,000)"}},{"$f":"IF(COUNT(L16,L24)=2,L16-L24,\"n.a.\")","v":{"v":11000,"d":"€11,000"}},{"$f":"IF(COUNT(M16,M24)=2,M16-M24,\"n.a.\")","v":{"v":1000,"d":"€1,000"}},{"$f":"IF(COUNT(N16,N24)=2,N16-N24,\"n.a.\")","v":{"v":-2000,"d":"(€2,000)"}},{"$f":"IF(COUNT(O16,O24)=2,O16-O24,\"n.a.\")","v":{"v":1000,"d":"€1,000"}}]
[null,"Closing cash",{"$f":"IF(COUNT(C13,C25)=2,C13+C25,\"n.a.\")","v":{"v":35000,"d":"€35,000"}},{"$f":"IF(COUNT(D13,D25)=2,D13+D25,\"n.a.\")","v":{"v":40000,"d":"€40,000"}},{"$f":"IF(COUNT(E13,E25)=2,E13+E25,\"n.a.\")","v":{"v":22000,"d":"€22,000"}},{"$f":"IF(COUNT(F13,F25)=2,F13+F25,\"n.a.\")","v":{"v":40000,"d":"€40,000"}},{"$f":"IF(COUNT(G13,G25)=2,G13+G25,\"n.a.\")","v":{"v":34000,"d":"€34,000"}},{"$f":"IF(COUNT(H13,H25)=2,H13+H25,\"n.a.\")","v":{"v":41000,"d":"€41,000"}},{"$f":"IF(COUNT(I13,I25)=2,I13+I25,\"n.a.\")","v":{"v":36000,"d":"€36,000"}},{"$f":"IF(COUNT(J13,J25)=2,J13+J25,\"n.a.\")","v":{"v":46000,"d":"€46,000"}},{"$f":"IF(COUNT(K13,K25)=2,K13+K25,\"n.a.\")","v":{"v":37000,"d":"€37,000"}},{"$f":"IF(COUNT(L13,L25)=2,L13+L25,\"n.a.\")","v":{"v":48000,"d":"€48,000"}},{"$f":"IF(COUNT(M13,M25)=2,M13+M25,\"n.a.\")","v":{"v":49000,"d":"€49,000"}},{"$f":"IF(COUNT(N13,N25)=2,N13+N25,\"n.a.\")","v":{"v":47000,"d":"€47,000"}},{"$f":"IF(COUNT(O13,O25)=2,O13+O25,\"n.a.\")","v":{"v":48000,"d":"€48,000"}}]
[null,"Minimum cash",{"$f":"IF(ISNUMBER($L$4),$L$4,\"n.a.\")","v":{"v":15000,"d":"€15,000"}},{"$f":"IF(ISNUMBER($L$4),$L$4,\"n.a.\")","v":{"v":15000,"d":"€15,000"}},{"$f":"IF(ISNUMBER($L$4),$L$4,\"n.a.\")","v":{"v":15000,"d":"€15,000"}},{"$f":"IF(ISNUMBER($L$4),$L$4,\"n.a.\")","v":{"v":15000,"d":"€15,000"}},{"$f":"IF(ISNUMBER($L$4),$L$4,\"n.a.\")","v":{"v":15000,"d":"€15,000"}},{"$f":"IF(ISNUMBER($L$4),$L$4,\"n.a.\")","v":{"v":15000,"d":"€15,000"}},{"$f":"IF(ISNUMBER($L$4),$L$4,\"n.a.\")","v":{"v":15000,"d":"€15,000"}},{"$f":"IF(ISNUMBER($L$4),$L$4,\"n.a.\")","v":{"v":15000,"d":"€15,000"}},{"$f":"IF(ISNUMBER($L$4),$L$4,\"n.a.\")","v":{"v":15000,"d":"€15,000"}},{"$f":"IF(ISNUMBER($L$4),$L$4,\"n.a.\")","v":{"v":15000,"d":"€15,000"}},{"$f":"IF(ISNUMBER($L$4),$L$4,\"n.a.\")","v":{"v":15000,"d":"€15,000"}},{"$f":"IF(ISNUMBER($L$4),$L$4,\"n.a.\")","v":{"v":15000,"d":"€15,000"}},{"$f":"IF(ISNUMBER($L$4),$L$4,\"n.a.\")","v":{"v":15000,"d":"€15,000"}}]
[null,"Headroom / (shortfall)",{"$f":"IF(COUNT(C26:C27)=2,C26-C27,\"n.a.\")","v":{"v":20000,"d":"€20,000"}},{"$f":"IF(COUNT(D26:D27)=2,D26-D27,\"n.a.\")","v":{"v":25000,"d":"€25,000"}},{"$f":"IF(COUNT(E26:E27)=2,E26-E27,\"n.a.\")","v":{"v":7000,"d":"€7,000"}},{"$f":"IF(COUNT(F26:F27)=2,F26-F27,\"n.a.\")","v":{"v":25000,"d":"€25,000"}},{"$f":"IF(COUNT(G26:G27)=2,G26-G27,\"n.a.\")","v":{"v":19000,"d":"€19,000"}},{"$f":"IF(COUNT(H26:H27)=2,H26-H27,\"n.a.\")","v":{"v":26000,"d":"€26,000"}},{"$f":"IF(COUNT(I26:I27)=2,I26-I27,\"n.a.\")","v":{"v":21000,"d":"€21,000"}},{"$f":"IF(COUNT(J26:J27)=2,J26-J27,\"n.a.\")","v":{"v":31000,"d":"€31,000"}},{"$f":"IF(COUNT(K26:K27)=2,K26-K27,\"n.a.\")","v":{"v":22000,"d":"€22,000"}},{"$f":"IF(COUNT(L26:L27)=2,L26-L27,\"n.a.\")","v":{"v":33000,"d":"€33,000"}},{"$f":"IF(COUNT(M26:M27)=2,M26-M27,\"n.a.\")","v":{"v":34000,"d":"€34,000"}},{"$f":"IF(COUNT(N26:N27)=2,N26-N27,\"n.a.\")","v":{"v":32000,"d":"€32,000"}},{"$f":"IF(COUNT(O26:O27)=2,O26-O27,\"n.a.\")","v":{"v":33000,"d":"€33,000"}}]
[null,"Cash status",{"$f":"IF(ISNUMBER(C28),IF(C28<0,\"Below minimum\",\"Meets minimum\"),\"Missing input\")","v":"Meets minimum"},{"$f":"IF(ISNUMBER(D28),IF(D28<0,\"Below minimum\",\"Meets minimum\"),\"Missing input\")","v":"Meets minimum"},{"$f":"IF(ISNUMBER(E28),IF(E28<0,\"Below minimum\",\"Meets minimum\"),\"Missing input\")","v":"Meets minimum"},{"$f":"IF(ISNUMBER(F28),IF(F28<0,\"Below minimum\",\"Meets minimum\"),\"Missing input\")","v":"Meets minimum"},{"$f":"IF(ISNUMBER(G28),IF(G28<0,\"Below minimum\",\"Meets minimum\"),\"Missing input\")","v":"Meets minimum"},{"$f":"IF(ISNUMBER(H28),IF(H28<0,\"Below minimum\",\"Meets minimum\"),\"Missing input\")","v":"Meets minimum"},{"$f":"IF(ISNUMBER(I28),IF(I28<0,\"Below minimum\",\"Meets minimum\"),\"Missing input\")","v":"Meets minimum"},{"$f":"IF(ISNUMBER(J28),IF(J28<0,\"Below minimum\",\"Meets minimum\"),\"Missing input\")","v":"Meets minimum"},{"$f":"IF(ISNUMBER(K28),IF(K28<0,\"Below minimum\",\"Meets minimum\"),\"Missing input\")","v":"Meets minimum"},{"$f":"IF(ISNUMBER(L28),IF(L28<0,\"Below minimum\",\"Meets minimum\"),\"Missing input\")","v":"Meets minimum"},{"$f":"IF(ISNUMBER(M28),IF(M28<0,\"Below minimum\",\"Meets minimum\"),\"Missing input\")","v":"Meets minimum"},{"$f":"IF(ISNUMBER(N28),IF(N28<0,\"Below minimum\",\"Meets minimum\"),\"Missing input\")","v":"Meets minimum"},{"$f":"IF(ISNUMBER(O28),IF(O28<0,\"Below minimum\",\"Meets minimum\"),\"Missing input\")","v":"Meets minimum"}]
[]
[]
[]
[null,"Customer collections assumptions"]
[null,"Active customer collections",{"$f":"IF($O$4=1,IF(ISNUMBER(C35),C35,\"n.a.\"),IF($O$4=2,IF(ISNUMBER(C36),C36,\"n.a.\"),\"Select case 1 or 2\"))","v":{"v":20000,"d":"20,000"}},{"$f":"IF($O$4=1,IF(ISNUMBER(D35),D35,\"n.a.\"),IF($O$4=2,IF(ISNUMBER(D36),D36,\"n.a.\"),\"Select case 1 or 2\"))","v":{"v":28000,"d":"28,000"}},{"$f":"IF($O$4=1,IF(ISNUMBER(E35),E35,\"n.a.\"),IF($O$4=2,IF(ISNUMBER(E36),E36,\"n.a.\"),\"Select case 1 or 2\"))","v":{"v":18000,"d":"18,000"}},{"$f":"IF($O$4=1,IF(ISNUMBER(F35),F35,\"n.a.\"),IF($O$4=2,IF(ISNUMBER(F36),F36,\"n.a.\"),\"Select case 1 or 2\"))","v":{"v":32000,"d":"32,000"}},{"$f":"IF($O$4=1,IF(ISNUMBER(G35),G35,\"n.a.\"),IF($O$4=2,IF(ISNUMBER(G36),G36,\"n.a.\"),\"Select case 1 or 2\"))","v":{"v":27000,"d":"27,000"}},{"$f":"IF($O$4=1,IF(ISNUMBER(H35),H35,\"n.a.\"),IF($O$4=2,IF(ISNUMBER(H36),H36,\"n.a.\"),\"Select case 1 or 2\"))","v":{"v":22000,"d":"22,000"}},{"$f":"IF($O$4=1,IF(ISNUMBER(I35),I35,\"n.a.\"),IF($O$4=2,IF(ISNUMBER(I36),I36,\"n.a.\"),\"Select case 1 or 2\"))","v":{"v":34000,"d":"34,000"}},{"$f":"IF($O$4=1,IF(ISNUMBER(J35),J35,\"n.a.\"),IF($O$4=2,IF(ISNUMBER(J36),J36,\"n.a.\"),\"Select case 1 or 2\"))","v":{"v":26000,"d":"26,000"}},{"$f":"IF($O$4=1,IF(ISNUMBER(K35),K35,\"n.a.\"),IF($O$4=2,IF(ISNUMBER(K36),K36,\"n.a.\"),\"Select case 1 or 2\"))","v":{"v":24000,"d":"24,000"}},{"$f":"IF($O$4=1,IF(ISNUMBER(L35),L35,\"n.a.\"),IF($O$4=2,IF(ISNUMBER(L36),L36,\"n.a.\"),\"Select case 1 or 2\"))","v":{"v":36000,"d":"36,000"}},{"$f":"IF($O$4=1,IF(ISNUMBER(M35),M35,\"n.a.\"),IF($O$4=2,IF(ISNUMBER(M36),M36,\"n.a.\"),\"Select case 1 or 2\"))","v":{"v":30000,"d":"30,000"}},{"$f":"IF($O$4=1,IF(ISNUMBER(N35),N35,\"n.a.\"),IF($O$4=2,IF(ISNUMBER(N36),N36,\"n.a.\"),\"Select case 1 or 2\"))","v":{"v":28000,"d":"28,000"}},{"$f":"IF($O$4=1,IF(ISNUMBER(O35),O35,\"n.a.\"),IF($O$4=2,IF(ISNUMBER(O36),O36,\"n.a.\"),\"Select case 1 or 2\"))","v":{"v":38000,"d":"38,000"}}]
[null,"Base",{"v":20000,"d":"20,000"},{"v":28000,"d":"28,000"},{"v":18000,"d":"18,000"},{"v":32000,"d":"32,000"},{"v":27000,"d":"27,000"},{"v":22000,"d":"22,000"},{"v":34000,"d":"34,000"},{"v":26000,"d":"26,000"},{"v":24000,"d":"24,000"},{"v":36000,"d":"36,000"},{"v":30000,"d":"30,000"},{"v":28000,"d":"28,000"},{"v":38000,"d":"38,000"}]
[null,"Downside",{"v":14000,"d":"14,000"},{"v":22000,"d":"22,000"},{"v":14000,"d":"14,000"},{"v":24000,"d":"24,000"},{"v":23000,"d":"23,000"},{"v":18000,"d":"18,000"},{"v":26000,"d":"26,000"},{"v":22000,"d":"22,000"},{"v":20000,"d":"20,000"},{"v":29000,"d":"29,000"},{"v":25000,"d":"25,000"},{"v":24000,"d":"24,000"},{"v":31000,"d":"31,000"}]
[]
[null,"Other cash receipts",0,0,0,0,0,{"v":5000,"d":"5,000"},0,0,0,{"v":2000,"d":"2,000"},0,0,0]
[]
[null,"Cash payments (shared across cases)"]
[null,"Supplier payments",{"v":12000,"d":"12,000"},{"v":16000,"d":"16,000"},{"v":18000,"d":"18,000"},{"v":14000,"d":"14,000"},{"v":18000,"d":"18,000"},{"v":14000,"d":"14,000"},{"v":19000,"d":"19,000"},{"v":16000,"d":"16,000"},{"v":18000,"d":"18,000"},{"v":20000,"d":"20,000"},{"v":19000,"d":"19,000"},{"v":18000,"d":"18,000"},{"v":22000,"d":"22,000"}]
[null,"Payroll payments",{"v":10000,"d":"10,000"},0,{"v":10000,"d":"10,000"},0,{"v":10000,"d":"10,000"},0,{"v":10000,"d":"10,000"},0,{"v":10000,"d":"10,000"},0,{"v":10000,"d":"10,000"},0,{"v":10000,"d":"10,000"}]
[null,"Rent and utilities",{"v":3000,"d":"3,000"},0,0,0,{"v":3000,"d":"3,000"},0,0,0,{"v":3000,"d":"3,000"},0,0,0,{"v":3000,"d":"3,000"}]
[null,"Tax payments",0,{"v":7000,"d":"7,000"},0,0,0,{"v":6000,"d":"6,000"},0,0,0,{"v":7000,"d":"7,000"},0,0,0]
[null,"Debt service",{"v":2000,"d":"2,000"},0,0,0,{"v":2000,"d":"2,000"},0,0,0,{"v":2000,"d":"2,000"},0,0,0,{"v":2000,"d":"2,000"}]
[null,"Capital expenditure",0,0,{"v":8000,"d":"8,000"},0,0,0,{"v":10000,"d":"10,000"},0,0,0,0,{"v":12000,"d":"12,000"},0]
[]
[null,"Collections are cash received, not invoiced revenue. Include all cash payments in their expected payment week."]

{"sheet":"Actuals","index":1,"n_rows":32,"n_cols":11,"rows_kept":32}
[]
[null,"BriQs Group: forecast vs actuals",{"$nulls":6},"Case selected:",null,{"$f":"CHOOSE('Forecast'!$O$4,\"Base\",\"Downside\")","v":"Base"}]
[]
[{"$nulls":5},"Opening bank cash (EUR)",null,{"v":42000,"d":"€42,000"}]
[null,"Enter actual cash totals and bank balances in yellow cells. Actual dates stay fixed when Forecast dates change."]
[]
[null,"Bank closes entered",{"$nulls":3},"Completed actual weeks",null,null,"Reconciliation differences"]
[null,{"$f":"COUNT(F13:F25)","v":3},{"$nulls":3},{"$f":"COUNT(J13:J25)","v":3},null,null,{"$f":"COUNTIFS(J13:J25,\">0.01\")+COUNTIFS(J13:J25,\"<-0.01\")","v":0}]
[]
[null,"Positive closing variance means more cash than forecast. Reconciliation should be zero for each completed week."]
[]
[null,"Week starting","Forecast closing","Actual receipts","Actual payments","Bank closing","Closing variance","Variance %","Expected closing","Reconciliation","Status"]
[null,"2026-09-14",{"$f":"IF(COUNTIFS('Forecast'!$C$12:$O$12,B13)=1,INDEX('Forecast'!$C$26:$O$26,1,MATCH(B13,'Forecast'!$C$12:$O$12,0)),\"Outside forecast\")","v":{"v":35000,"d":"€35,000"}},{"v":18000,"d":"€18,000"},{"v":27000,"d":"€27,000"},{"v":33000,"d":"€33,000"},{"$f":"IF(ISNUMBER(F13),IF(ISNUMBER(C13),F13-C13,\"n.a.\"),\"No actual\")","v":{"v":-2000,"d":"(€2,000)"}},{"$f":"IF(ISNUMBER(G13),IF(C13=0,\"n.a.\",G13/ABS(C13)),\"n.a.\")","v":{"v":-0.05714285714285714,"d":"(5.7%)"}},{"$f":"IF(COUNT(D13:E13)=2,IF(ISNUMBER($H$4),$H$4+D13-E13,\"n.a.\"),\"n.a.\")","v":{"v":33000,"d":"€33,000"}},{"$f":"IF(COUNT(F13,I13)=2,F13-I13,\"n.a.\")","v":{"v":0,"d":"0.00"}},{"$f":"IF(COUNT(D13:F13)=0,\"No actual entered\",IF(COUNT(D13:F13)<3,\"Complete yellow inputs\",IF(ISNUMBER(I13),IF(ABS(F13-I13)>0.01,\"Reconcile bank difference\",\"Recorded\"),\"Prior opening cash needed\")))","v":"Recorded"}]
[null,"2026-09-21",{"$f":"IF(COUNTIFS('Forecast'!$C$12:$O$12,B14)=1,INDEX('Forecast'!$C$26:$O$26,1,MATCH(B14,'Forecast'!$C$12:$O$12,0)),\"Outside forecast\")","v":{"v":40000,"d":"€40,000"}},{"v":30000,"d":"€30,000"},{"v":23000,"d":"€23,000"},{"v":40000,"d":"€40,000"},{"$f":"IF(ISNUMBER(F14),IF(ISNUMBER(C14),F14-C14,\"n.a.\"),\"No actual\")","v":0},{"$f":"IF(ISNUMBER(G14),IF(C14=0,\"n.a.\",G14/ABS(C14)),\"n.a.\")","v":0},{"$f":"IF(COUNT(D14:E14)=2,IF(AND(ISNUMBER(F13),B14=B13+7),F13+D14-E14,\"n.a.\"),\"n.a.\")","v":{"v":40000,"d":"€40,000"}},{"$f":"IF(COUNT(F14,I14)=2,F14-I14,\"n.a.\")","v":{"v":0,"d":"0.00"}},{"$f":"IF(COUNT(D14:F14)=0,\"No actual entered\",IF(COUNT(D14:F14)<3,\"Complete yellow inputs\",IF(ISNUMBER(I14),IF(ABS(F14-I14)>0.01,\"Reconcile bank difference\",\"Recorded\"),\"Prior opening cash needed\")))","v":"Recorded"}]
[null,"2026-09-28",{"$f":"IF(COUNTIFS('Forecast'!$C$12:$O$12,B15)=1,INDEX('Forecast'!$C$26:$O$26,1,MATCH(B15,'Forecast'!$C$12:$O$12,0)),\"Outside forecast\")","v":{"v":22000,"d":"€22,000"}},{"v":16000,"d":"€16,000"},{"v":38000,"d":"€38,000"},{"v":18000,"d":"€18,000"},{"$f":"IF(ISNUMBER(F15),IF(ISNUMBER(C15),F15-C15,\"n.a.\"),\"No actual\")","v":{"v":-4000,"d":"(€4,000)"}},{"$f":"IF(ISNUMBER(G15),IF(C15=0,\"n.a.\",G15/ABS(C15)),\"n.a.\")","v":{"v":-0.18181818181818182,"d":"(18.2%)"}},{"$f":"IF(COUNT(D15:E15)=2,IF(AND(ISNUMBER(F14),B15=B14+7),F14+D15-E15,\"n.a.\"),\"n.a.\")","v":{"v":18000,"d":"€18,000"}},{"$f":"IF(COUNT(F15,I15)=2,F15-I15,\"n.a.\")","v":{"v":0,"d":"0.00"}},{"$f":"IF(COUNT(D15:F15)=0,\"No actual entered\",IF(COUNT(D15:F15)<3,\"Complete yellow inputs\",IF(ISNUMBER(I15),IF(ABS(F15-I15)>0.01,\"Reconcile bank difference\",\"Recorded\"),\"Prior opening cash needed\")))","v":"Recorded"}]
[null,"2026-10-05",{"$f":"IF(COUNTIFS('Forecast'!$C$12:$O$12,B16)=1,INDEX('Forecast'!$C$26:$O$26,1,MATCH(B16,'Forecast'!$C$12:$O$12,0)),\"Outside forecast\")","v":{"v":40000,"d":"€40,000"}},{"$nulls":3},{"$f":"IF(ISNUMBER(F16),IF(ISNUMBER(C16),F16-C16,\"n.a.\"),\"No actual\")","v":"No actual"},{"$f":"IF(ISNUMBER(G16),IF(C16=0,\"n.a.\",G16/ABS(C16)),\"n.a.\")","v":"n.a."},{"$f":"IF(COUNT(D16:E16)=2,IF(AND(ISNUMBER(F15),B16=B15+7),F15+D16-E16,\"n.a.\"),\"n.a.\")","v":"n.a."},{"$f":"IF(COUNT(F16,I16)=2,F16-I16,\"n.a.\")","v":"n.a."},{"$f":"IF(COUNT(D16:F16)=0,\"No actual entered\",IF(COUNT(D16:F16)<3,\"Complete yellow inputs\",IF(ISNUMBER(I16),IF(ABS(F16-I16)>0.01,\"Reconcile bank difference\",\"Recorded\"),\"Prior opening cash needed\")))","v":"No actual entered"}]
[null,"2026-10-12",{"$f":"IF(COUNTIFS('Forecast'!$C$12:$O$12,B17)=1,INDEX('Forecast'!$C$26:$O$26,1,MATCH(B17,'Forecast'!$C$12:$O$12,0)),\"Outside forecast\")","v":{"v":34000,"d":"€34,000"}},{"$nulls":3},{"$f":"IF(ISNUMBER(F17),IF(ISNUMBER(C17),F17-C17,\"n.a.\"),\"No actual\")","v":"No actual"},{"$f":"IF(ISNUMBER(G17),IF(C17=0,\"n.a.\",G17/ABS(C17)),\"n.a.\")","v":"n.a."},{"$f":"IF(COUNT(D17:E17)=2,IF(AND(ISNUMBER(F16),B17=B16+7),F16+D17-E17,\"n.a.\"),\"n.a.\")","v":"n.a."},{"$f":"IF(COUNT(F17,I17)=2,F17-I17,\"n.a.\")","v":"n.a."},{"$f":"IF(COUNT(D17:F17)=0,\"No actual entered\",IF(COUNT(D17:F17)<3,\"Complete yellow inputs\",IF(ISNUMBER(I17),IF(ABS(F17-I17)>0.01,\"Reconcile bank difference\",\"Recorded\"),\"Prior opening cash needed\")))","v":"No actual entered"}]
[null,"2026-10-19",{"$f":"IF(COUNTIFS('Forecast'!$C$12:$O$12,B18)=1,INDEX('Forecast'!$C$26:$O$26,1,MATCH(B18,'Forecast'!$C$12:$O$12,0)),\"Outside forecast\")","v":{"v":41000,"d":"€41,000"}},{"$nulls":3},{"$f":"IF(ISNUMBER(F18),IF(ISNUMBER(C18),F18-C18,\"n.a.\"),\"No actual\")","v":"No actual"},{"$f":"IF(ISNUMBER(G18),IF(C18=0,\"n.a.\",G18/ABS(C18)),\"n.a.\")","v":"n.a."},{"$f":"IF(COUNT(D18:E18)=2,IF(AND(ISNUMBER(F17),B18=B17+7),F17+D18-E18,\"n.a.\"),\"n.a.\")","v":"n.a."},{"$f":"IF(COUNT(F18,I18)=2,F18-I18,\"n.a.\")","v":"n.a."},{"$f":"IF(COUNT(D18:F18)=0,\"No actual entered\",IF(COUNT(D18:F18)<3,\"Complete yellow inputs\",IF(ISNUMBER(I18),IF(ABS(F18-I18)>0.01,\"Reconcile bank difference\",\"Recorded\"),\"Prior opening cash needed\")))","v":"No actual entered"}]
[null,"2026-10-26",{"$f":"IF(COUNTIFS('Forecast'!$C$12:$O$12,B19)=1,INDEX('Forecast'!$C$26:$O$26,1,MATCH(B19,'Forecast'!$C$12:$O$12,0)),\"Outside forecast\")","v":{"v":36000,"d":"€36,000"}},{"$nulls":3},{"$f":"IF(ISNUMBER(F19),IF(ISNUMBER(C19),F19-C19,\"n.a.\"),\"No actual\")","v":"No actual"},{"$f":"IF(ISNUMBER(G19),IF(C19=0,\"n.a.\",G19/ABS(C19)),\"n.a.\")","v":"n.a."},{"$f":"IF(COUNT(D19:E19)=2,IF(AND(ISNUMBER(F18),B19=B18+7),F18+D19-E19,\"n.a.\"),\"n.a.\")","v":"n.a."},{"$f":"IF(COUNT(F19,I19)=2,F19-I19,\"n.a.\")","v":"n.a."},{"$f":"IF(COUNT(D19:F19)=0,\"No actual entered\",IF(COUNT(D19:F19)<3,\"Complete yellow inputs\",IF(ISNUMBER(I19),IF(ABS(F19-I19)>0.01,\"Reconcile bank difference\",\"Recorded\"),\"Prior opening cash needed\")))","v":"No actual entered"}]
[null,"2026-11-02",{"$f":"IF(COUNTIFS('Forecast'!$C$12:$O$12,B20)=1,INDEX('Forecast'!$C$26:$O$26,1,MATCH(B20,'Forecast'!$C$12:$O$12,0)),\"Outside forecast\")","v":{"v":46000,"d":"€46,000"}},{"$nulls":3},{"$f":"IF(ISNUMBER(F20),IF(ISNUMBER(C20),F20-C20,\"n.a.\"),\"No actual\")","v":"No actual"},{"$f":"IF(ISNUMBER(G20),IF(C20=0,\"n.a.\",G20/ABS(C20)),\"n.a.\")","v":"n.a."},{"$f":"IF(COUNT(D20:E20)=2,IF(AND(ISNUMBER(F19),B20=B19+7),F19+D20-E20,\"n.a.\"),\"n.a.\")","v":"n.a."},{"$f":"IF(COUNT(F20,I20)=2,F20-I20,\"n.a.\")","v":"n.a."},{"$f":"IF(COUNT(D20:F20)=0,\"No actual entered\",IF(COUNT(D20:F20)<3,\"Complete yellow inputs\",IF(ISNUMBER(I20),IF(ABS(F20-I20)>0.01,\"Reconcile bank difference\",\"Recorded\"),\"Prior opening cash needed\")))","v":"No actual entered"}]
[null,"2026-11-09",{"$f":"IF(COUNTIFS('Forecast'!$C$12:$O$12,B21)=1,INDEX('Forecast'!$C$26:$O$26,1,MATCH(B21,'Forecast'!$C$12:$O$12,0)),\"Outside forecast\")","v":{"v":37000,"d":"€37,000"}},{"$nulls":3},{"$f":"IF(ISNUMBER(F21),IF(ISNUMBER(C21),F21-C21,\"n.a.\"),\"No actual\")","v":"No actual"},{"$f":"IF(ISNUMBER(G21),IF(C21=0,\"n.a.\",G21/ABS(C21)),\"n.a.\")","v":"n.a."},{"$f":"IF(COUNT(D21:E21)=2,IF(AND(ISNUMBER(F20),B21=B20+7),F20+D21-E21,\"n.a.\"),\"n.a.\")","v":"n.a."},{"$f":"IF(COUNT(F21,I21)=2,F21-I21,\"n.a.\")","v":"n.a."},{"$f":"IF(COUNT(D21:F21)=0,\"No actual entered\",IF(COUNT(D21:F21)<3,\"Complete yellow inputs\",IF(ISNUMBER(I21),IF(ABS(F21-I21)>0.01,\"Reconcile bank difference\",\"Recorded\"),\"Prior opening cash needed\")))","v":"No actual entered"}]
[null,"2026-11-16",{"$f":"IF(COUNTIFS('Forecast'!$C$12:$O$12,B22)=1,INDEX('Forecast'!$C$26:$O$26,1,MATCH(B22,'Forecast'!$C$12:$O$12,0)),\"Outside forecast\")","v":{"v":48000,"d":"€48,000"}},{"$nulls":3},{"$f":"IF(ISNUMBER(F22),IF(ISNUMBER(C22),F22-C22,\"n.a.\"),\"No actual\")","v":"No actual"},{"$f":"IF(ISNUMBER(G22),IF(C22=0,\"n.a.\",G22/ABS(C22)),\"n.a.\")","v":"n.a."},{"$f":"IF(COUNT(D22:E22)=2,IF(AND(ISNUMBER(F21),B22=B21+7),F21+D22-E22,\"n.a.\"),\"n.a.\")","v":"n.a."},{"$f":"IF(COUNT(F22,I22)=2,F22-I22,\"n.a.\")","v":"n.a."},{"$f":"IF(COUNT(D22:F22)=0,\"No actual entered\",IF(COUNT(D22:F22)<3,\"Complete yellow inputs\",IF(ISNUMBER(I22),IF(ABS(F22-I22)>0.01,\"Reconcile bank difference\",\"Recorded\"),\"Prior opening cash needed\")))","v":"No actual entered"}]
[null,"2026-11-23",{"$f":"IF(COUNTIFS('Forecast'!$C$12:$O$12,B23)=1,INDEX('Forecast'!$C$26:$O$26,1,MATCH(B23,'Forecast'!$C$12:$O$12,0)),\"Outside forecast\")","v":{"v":49000,"d":"€49,000"}},{"$nulls":3},{"$f":"IF(ISNUMBER(F23),IF(ISNUMBER(C23),F23-C23,\"n.a.\"),\"No actual\")","v":"No actual"},{"$f":"IF(ISNUMBER(G23),IF(C23=0,\"n.a.\",G23/ABS(C23)),\"n.a.\")","v":"n.a."},{"$f":"IF(COUNT(D23:E23)=2,IF(AND(ISNUMBER(F22),B23=B22+7),F22+D23-E23,\"n.a.\"),\"n.a.\")","v":"n.a."},{"$f":"IF(COUNT(F23,I23)=2,F23-I23,\"n.a.\")","v":"n.a."},{"$f":"IF(COUNT(D23:F23)=0,\"No actual entered\",IF(COUNT(D23:F23)<3,\"Complete yellow inputs\",IF(ISNUMBER(I23),IF(ABS(F23-I23)>0.01,\"Reconcile bank difference\",\"Recorded\"),\"Prior opening cash needed\")))","v":"No actual entered"}]
[null,"2026-11-30",{"$f":"IF(COUNTIFS('Forecast'!$C$12:$O$12,B24)=1,INDEX('Forecast'!$C$26:$O$26,1,MATCH(B24,'Forecast'!$C$12:$O$12,0)),\"Outside forecast\")","v":{"v":47000,"d":"€47,000"}},{"$nulls":3},{"$f":"IF(ISNUMBER(F24),IF(ISNUMBER(C24),F24-C24,\"n.a.\"),\"No actual\")","v":"No actual"},{"$f":"IF(ISNUMBER(G24),IF(C24=0,\"n.a.\",G24/ABS(C24)),\"n.a.\")","v":"n.a."},{"$f":"IF(COUNT(D24:E24)=2,IF(AND(ISNUMBER(F23),B24=B23+7),F23+D24-E24,\"n.a.\"),\"n.a.\")","v":"n.a."},{"$f":"IF(COUNT(F24,I24)=2,F24-I24,\"n.a.\")","v":"n.a."},{"$f":"IF(COUNT(D24:F24)=0,\"No actual entered\",IF(COUNT(D24:F24)<3,\"Complete yellow inputs\",IF(ISNUMBER(I24),IF(ABS(F24-I24)>0.01,\"Reconcile bank difference\",\"Recorded\"),\"Prior opening cash needed\")))","v":"No actual entered"}]
[null,"2026-12-07",{"$f":"IF(COUNTIFS('Forecast'!$C$12:$O$12,B25)=1,INDEX('Forecast'!$C$26:$O$26,1,MATCH(B25,'Forecast'!$C$12:$O$12,0)),\"Outside forecast\")","v":{"v":48000,"d":"€48,000"}},{"$nulls":3},{"$f":"IF(ISNUMBER(F25),IF(ISNUMBER(C25),F25-C25,\"n.a.\"),\"No actual\")","v":"No actual"},{"$f":"IF(ISNUMBER(G25),IF(C25=0,\"n.a.\",G25/ABS(C25)),\"n.a.\")","v":"n.a."},{"$f":"IF(COUNT(D25:E25)=2,IF(AND(ISNUMBER(F24),B25=B24+7),F24+D25-E25,\"n.a.\"),\"n.a.\")","v":"n.a."},{"$f":"IF(COUNT(F25,I25)=2,F25-I25,\"n.a.\")","v":"n.a."},{"$f":"IF(COUNT(D25:F25)=0,\"No actual entered\",IF(COUNT(D25:F25)<3,\"Complete yellow inputs\",IF(ISNUMBER(I25),IF(ABS(F25-I25)>0.01,\"Reconcile bank difference\",\"Recorded\"),\"Prior opening cash needed\")))","v":"No actual entered"}]
[]
[]
[null,"No actual entered means unavailable. An entered zero is a real amount and is included in comparisons."]
[]
[null,"Expected closing = opening bank cash + actual receipts − actual payments. Later weeks use the prior bank closing."]
[]
[null,"Use one row per Monday in chronological order. The opening bank cash must precede the first date in this table."]

{"sheet":"Guide","index":2,"n_rows":40,"n_cols":11,"rows_kept":40}
[]
[null,"BriQs Group: using the cash forecast",{"$nulls":6},"Case selected:",null,{"$f":"CHOOSE('Forecast'!$O$4,\"Base\",\"Downside\")","v":"Base"}]
[]
[]
[null,"A practical weekly cash view"]
[null,"This workbook uses EUR cash amounts. All prefilled forecast and actual figures are synthetic illustrations."]
[]
[null,"1. Set the starting position"]
[null,"On Forecast, set the Monday start date, opening cash balance and minimum cash you want to retain."]
[null,"Opening cash should be the cash available immediately before week 1. Use the same bank-account scope throughout."]
[]
[null,"2. Replace the yellow forecast inputs"]
[null,"Enter customer collections for Base and Downside. Select 1 for Base or 2 for Downside in the case-number cell."]
[null,"The Downside example reduces customer collections. Other receipts and every payment category are shared."]
[null,"Enter receipts and payments as positive amounts, in the week cash is expected to reach or leave the bank."]
[null,"Enter 0 when an amount is genuinely zero. A blank required forecast input makes its dependent cash results unavailable."]
[]
[null,"3. Review cash before the week begins"]
[null,"Closing cash = opening cash + total cash receipts − total cash payments. It becomes the next week’s opening cash."]
[null,"Headroom = closing cash − minimum cash. A negative amount and red warning identify a shortfall against your minimum."]
[null,"Include tax when it is paid. Debt service includes cash principal and interest. Capital expenditure is cash paid for assets."]
[null,"Other receipts can include funding or asset-sale proceeds. This template does not calculate revenue, profit, tax or borrowing availability."]
[]
[null,"4. Record and reconcile actual cash"]
[null,"On Actuals, enter the opening bank cash, dated receipts, payments and bank closing balances. Keep dates unique and chronological."]
[null,"The first three completed actual weeks are examples. Clear or replace them before using the workbook for your business."]
[null,"Actual dates and raw amounts are independent of the scenario selector. Each actual date matches the current forecast by date."]
[null,"A blank actual balance is “No actual”. An entered zero is compared with forecast. A zero forecast makes percentage variance unavailable."]
[null,"Closing variance is actual bank closing less forecast closing. Reconciliation is actual bank closing less expected closing."]
[null,"Complete every yellow amount for the week and investigate any reconciliation difference. Expected closing uses the prior bank balance."]
[]
[null,"5. Refresh the 13-week view"]
[null,"Save a dated copy before changing the forecast. Record actuals and compare them with that saved forecast before revising assumptions."]
[null,"Changing the start date changes forecast labels only. Review and move every forecast input to its correct week, then add the new week."]
[null,"Actuals keep their dates. If reusing its 13 rows for a later period, archive the history and update its opening cash and dated inputs together."]
[]
[null,"Reading the workbook"]
[null,"Yellow fill and blue numbers identify editable inputs. Calculated cash results use dark text. The green case name shows the active selection."]
[null,"n.a. means a result cannot yet be calculated. Formula cells are editable for adaptation, so preserve them when entering ordinary cash data."]
[null,"The forecast comparison follows the current selected case. Saved copies preserve the assumptions used in earlier weekly reviews."]