{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["BLANK 12 Month Business Budget","12 Month Business Budget"],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"BLANK 12 Month Business Budget","index":0,"n_rows":91,"n_cols":19,"rows_kept":91,"cut":false,"hidden":false,"merged":[[90,1,90,18]]}
[" ","12-MONTH BUSINESS BUDGET"]
[]
[null,"PROFIT & LOSS CATEGORY","JAN","FEB","MAR","Q1 TOTAL","APR","MAY","JUN","Q2 TOTAL","JUL","AUG","SEPT","Q3 TOTAL","OCT","NOV","DEC","Q4 TOTAL","YR TOTAL"]
[null,"REVENUE"]
[null,"BUDGET",null,null,null,{"$f":"SUM(C5:E5)","v":0},null,null,null,{"$f":"SUM(G5:I5)","v":0},null,null,null,{"$f":"SUM(K5:M5)","v":0},null,null,null,{"$f":"SUM(O5:Q5)","v":0},{"$f":"SUM(F5,J5,N5,R5)","v":0}]
[null,"ACTUAL",null,null,null,{"$f":"SUM(C6:E6)","v":0},null,null,null,{"$f":"SUM(G6:I6)","v":0},null,null,null,{"$f":"SUM(K6:M6)","v":0},null,null,null,{"$f":"SUM(O6:Q6)","v":0},{"$f":"SUM(F6,J6,N6,R6)","v":0}]
[null,"VARIANCE",{"$f":"C6-C5","v":0},{"$f":"D6-D5","v":0},0,{"$f":"F6-F5","v":0},{"$f":"G6-G5","v":0},{"$f":"H6-H5","v":0},0,{"$f":"J6-J5","v":0},{"$f":"K6-K5","v":0},{"$f":"L6-L5","v":0},0,{"$f":"N6-N5","v":0},{"$f":"O6-O5","v":0},{"$f":"P6-P5","v":0},0,{"$f":"R6-R5","v":0},0]
[null,"PREVIOUS YEAR ACTUAL",null,null,null,{"$f":"SUM(C8:E8)","v":0},null,null,null,{"$f":"SUM(G8:I8)","v":0},null,null,null,{"$f":"SUM(K8:M8)","v":0},null,null,null,{"$f":"SUM(O8:Q8)","v":0},0]
[null,"PREVIOUS YEAR VARIANCE",{"$f":"C6-C8","v":0},{"$f":"D6-D8","v":0},0,0,{"$f":"G6-G8","v":0},{"$f":"H6-H8","v":0},0,0,{"$f":"K6-K8","v":0},{"$f":"L6-L8","v":0},0,0,{"$f":"O6-O8","v":0},{"$f":"P6-P8","v":0},0,0,0]
[null,"COGS Cost of Goods Sold"]
[null,"BUDGET",null,null,null,{"$f":"SUM(C11:E11)","v":0},null,null,null,{"$f":"SUM(G11:I11)","v":0},null,null,null,{"$f":"SUM(K11:M11)","v":0},null,null,null,{"$f":"SUM(O11:Q11)","v":0},{"$f":"SUM(F11,J11,N11,R11)","v":0}]
[null,"ACTUAL",null,null,null,{"$f":"SUM(C12:E12)","v":0},null,null,null,{"$f":"SUM(G12:I12)","v":0},null,null,null,{"$f":"SUM(K12:M12)","v":0},null,null,null,{"$f":"SUM(O12:Q12)","v":0},{"$f":"SUM(F12,J12,N12,R12)","v":0}]
[null,"VARIANCE",{"$f":"C12-C11","v":0},{"$f":"D12-D11","v":0},{"$f":"E12-E11","v":0},{"$f":"F12-F11","v":0},{"$f":"G12-G11","v":0},{"$f":"H12-H11","v":0},{"$f":"I12-I11","v":0},{"$f":"J12-J11","v":0},{"$f":"K12-K11","v":0},{"$f":"L12-L11","v":0},{"$f":"M12-M11","v":0},{"$f":"N12-N11","v":0},{"$f":"O12-O11","v":0},{"$f":"P12-P11","v":0},{"$f":"Q12-Q11","v":0},{"$f":"R12-R11","v":0},0]
[null,"PREVIOUS YEAR ACTUAL",null,null,null,{"$f":"SUM(C14:E14)","v":0},null,null,null,{"$f":"SUM(G14:I14)","v":0},null,null,null,{"$f":"SUM(K14:M14)","v":0},null,null,null,{"$f":"SUM(O14:Q14)","v":0},0]
[null,"PREVIOUS YEAR VARIANCE",{"$f":"C12-C14","v":0},{"$f":"D12-D14","v":0},{"$f":"E12-E14","v":0},{"$f":"F12-F14","v":0},{"$f":"G12-G14","v":0},{"$f":"H12-H14","v":0},{"$f":"I12-I14","v":0},{"$f":"J12-J14","v":0},{"$f":"K12-K14","v":0},{"$f":"L12-L14","v":0},{"$f":"M12-M14","v":0},{"$f":"N12-N14","v":0},{"$f":"O12-O14","v":0},{"$f":"P12-P14","v":0},{"$f":"Q12-Q14","v":0},{"$f":"R12-R14","v":0},0]
[null,"SALES/MARKETING COSTS"]
[null,"BUDGET",null,null,null,{"$f":"SUM(C17:E17)","v":0},null,null,null,{"$f":"SUM(G17:I17)","v":0},null,null,null,{"$f":"SUM(K17:M17)","v":0},null,null,null,{"$f":"SUM(O17:Q17)","v":0},{"$f":"SUM(F17,J17,N17,R17)","v":0}]
[null,"ACTUAL",null,null,null,{"$f":"SUM(C18:E18)","v":0},null,null,null,{"$f":"SUM(G18:I18)","v":0},null,null,null,{"$f":"SUM(K18:M18)","v":0},null,null,null,{"$f":"SUM(O18:Q18)","v":0},{"$f":"SUM(F18,J18,N18,R18)","v":0}]
[null,"VARIANCE",{"$f":"C18-C17","v":0},{"$f":"D18-D17","v":0},{"$f":"E18-E17","v":0},{"$f":"F18-F17","v":0},{"$f":"G18-G17","v":0},{"$f":"H18-H17","v":0},{"$f":"I18-I17","v":0},{"$f":"J18-J17","v":0},{"$f":"K18-K17","v":0},{"$f":"L18-L17","v":0},{"$f":"M18-M17","v":0},{"$f":"N18-N17","v":0},{"$f":"O18-O17","v":0},{"$f":"P18-P17","v":0},{"$f":"Q18-Q17","v":0},{"$f":"R18-R17","v":0},0]
[null,"PREVIOUS YEAR ACTUAL",null,null,null,{"$f":"SUM(C20:E20)","v":0},null,null,null,{"$f":"SUM(G20:I20)","v":0},null,null,null,{"$f":"SUM(K20:M20)","v":0},null,null,null,{"$f":"SUM(O20:Q20)","v":0},0]
[null,"PREVIOUS YEAR VARIANCE",{"$f":"C18-C20","v":0},{"$f":"D18-D20","v":0},{"$f":"E18-E20","v":0},{"$f":"F18-F20","v":0},{"$f":"G18-G20","v":0},{"$f":"H18-H20","v":0},{"$f":"I18-I20","v":0},{"$f":"J18-J20","v":0},{"$f":"K18-K20","v":0},{"$f":"L18-L20","v":0},{"$f":"M18-M20","v":0},{"$f":"N18-N20","v":0},{"$f":"O18-O20","v":0},{"$f":"P18-P20","v":0},{"$f":"Q18-Q20","v":0},{"$f":"R18-R20","v":0},0]
[null,"LABOR COSTS"]
[null,"BUDGET",null,null,null,{"$f":"SUM(C23:E23)","v":0},null,null,null,{"$f":"SUM(G23:I23)","v":0},null,null,null,{"$f":"SUM(K23:M23)","v":0},null,null,null,{"$f":"SUM(O23:Q23)","v":0},{"$f":"SUM(F23,J23,N23,R23)","v":0}]
[null,"ACTUAL",null,null,null,{"$f":"SUM(C24:E24)","v":0},null,null,null,{"$f":"SUM(G24:I24)","v":0},null,null,null,{"$f":"SUM(K24:M24)","v":0},null,null,null,{"$f":"SUM(O24:Q24)","v":0},{"$f":"SUM(F24,J24,N24,R24)","v":0}]
[null,"VARIANCE",{"$f":"C24-C23","v":0},{"$f":"D24-D23","v":0},{"$f":"E24-E23","v":0},{"$f":"F24-F23","v":0},{"$f":"G24-G23","v":0},{"$f":"H24-H23","v":0},{"$f":"I24-I23","v":0},{"$f":"J24-J23","v":0},{"$f":"K24-K23","v":0},{"$f":"L24-L23","v":0},{"$f":"M24-M23","v":0},{"$f":"N24-N23","v":0},{"$f":"O24-O23","v":0},{"$f":"P24-P23","v":0},{"$f":"Q24-Q23","v":0},{"$f":"R24-R23","v":0},0]
[null,"PREVIOUS YEAR ACTUAL",null,null,null,{"$f":"SUM(C26:E26)","v":0},null,null,null,{"$f":"SUM(G26:I26)","v":0},null,null,null,{"$f":"SUM(K26:M26)","v":0},null,null,null,{"$f":"SUM(O26:Q26)","v":0},0]
[null,"PREVIOUS YEAR VARIANCE",{"$f":"C24-C26","v":0},{"$f":"D24-D26","v":0},{"$f":"E24-E26","v":0},{"$f":"F24-F26","v":0},{"$f":"G24-G26","v":0},{"$f":"H24-H26","v":0},{"$f":"I24-I26","v":0},{"$f":"J24-J26","v":0},{"$f":"K24-K26","v":0},{"$f":"L24-L26","v":0},{"$f":"M24-M26","v":0},{"$f":"N24-N26","v":0},{"$f":"O24-O26","v":0},{"$f":"P24-P26","v":0},{"$f":"Q24-Q26","v":0},{"$f":"R24-R26","v":0},0]
[null,"ADMIN/GENERAL"]
[null,"BUDGET",null,null,null,{"$f":"SUM(C29:E29)","v":0},null,null,null,{"$f":"SUM(G29:I29)","v":0},null,null,null,{"$f":"SUM(K29:M29)","v":0},null,null,null,{"$f":"SUM(O29:Q29)","v":0},{"$f":"SUM(F29,J29,N29,R29)","v":0}]
[null,"ACTUAL",null,null,null,{"$f":"SUM(C30:E30)","v":0},null,null,null,{"$f":"SUM(G30:I30)","v":0},null,null,null,{"$f":"SUM(K30:M30)","v":0},null,null,null,{"$f":"SUM(O30:Q30)","v":0},{"$f":"SUM(F30,J30,N30,R30)","v":0}]
[null,"VARIANCE",{"$f":"C30-C29","v":0},{"$f":"D30-D29","v":0},{"$f":"E30-E29","v":0},{"$f":"F30-F29","v":0},{"$f":"G30-G29","v":0},{"$f":"H30-H29","v":0},{"$f":"I30-I29","v":0},{"$f":"J30-J29","v":0},{"$f":"K30-K29","v":0},{"$f":"L30-L29","v":0},{"$f":"M30-M29","v":0},{"$f":"N30-N29","v":0},{"$f":"O30-O29","v":0},{"$f":"P30-P29","v":0},{"$f":"Q30-Q29","v":0},{"$f":"R30-R29","v":0},0]
[null,"PREVIOUS YEAR ACTUAL",null,null,null,{"$f":"SUM(C32:E32)","v":0},null,null,null,{"$f":"SUM(G32:I32)","v":0},null,null,null,{"$f":"SUM(K32:M32)","v":0},null,null,null,{"$f":"SUM(O32:Q32)","v":0},0]
[null,"PREVIOUS YEAR VARIANCE",{"$f":"C30-C32","v":0},{"$f":"D30-D32","v":0},{"$f":"E30-E32","v":0},{"$f":"F30-F32","v":0},{"$f":"G30-G32","v":0},{"$f":"H30-H32","v":0},{"$f":"I30-I32","v":0},{"$f":"J30-J32","v":0},{"$f":"K30-K32","v":0},{"$f":"L30-L32","v":0},{"$f":"M30-M32","v":0},{"$f":"N30-N32","v":0},{"$f":"O30-O32","v":0},{"$f":"P30-P32","v":0},{"$f":"Q30-Q32","v":0},{"$f":"R30-R32","v":0},0]
[null,"EBIT Earnings Before Interest & Taxes"]
[null,"BUDGET",null,null,null,{"$f":"SUM(C35:E35)","v":0},null,null,null,{"$f":"SUM(G35:I35)","v":0},null,null,null,{"$f":"SUM(K35:M35)","v":0},null,null,null,{"$f":"SUM(O35:Q35)","v":0},{"$f":"SUM(F35,J35,N35,R35)","v":0}]
[null,"ACTUAL",null,null,null,{"$f":"SUM(C36:E36)","v":0},null,null,null,{"$f":"SUM(G36:I36)","v":0},null,null,null,{"$f":"SUM(K36:M36)","v":0},null,null,null,{"$f":"SUM(O36:Q36)","v":0},{"$f":"SUM(F36,J36,N36,R36)","v":0}]
[null,"VARIANCE",{"$f":"C36-C35","v":0},{"$f":"D36-D35","v":0},{"$f":"E36-E35","v":0},{"$f":"F36-F35","v":0},{"$f":"G36-G35","v":0},{"$f":"H36-H35","v":0},{"$f":"I36-I35","v":0},{"$f":"J36-J35","v":0},{"$f":"K36-K35","v":0},{"$f":"L36-L35","v":0},{"$f":"M36-M35","v":0},{"$f":"N36-N35","v":0},{"$f":"O36-O35","v":0},{"$f":"P36-P35","v":0},{"$f":"Q36-Q35","v":0},{"$f":"R36-R35","v":0},0]
[null,"PREVIOUS YEAR ACTUAL",null,null,null,{"$f":"SUM(C38:E38)","v":0},null,null,null,{"$f":"SUM(G38:I38)","v":0},null,null,null,{"$f":"SUM(K38:M38)","v":0},null,null,null,{"$f":"SUM(O38:Q38)","v":0},0]
[null,"PREVIOUS YEAR VARIANCE",{"$f":"C36-C38","v":0},{"$f":"D36-D38","v":0},{"$f":"E36-E38","v":0},{"$f":"F36-F38","v":0},{"$f":"G36-G38","v":0},{"$f":"H36-H38","v":0},{"$f":"I36-I38","v":0},{"$f":"J36-J38","v":0},{"$f":"K36-K38","v":0},{"$f":"L36-L38","v":0},{"$f":"M36-M38","v":0},{"$f":"N36-N38","v":0},{"$f":"O36-O38","v":0},{"$f":"P36-P38","v":0},{"$f":"Q36-Q38","v":0},{"$f":"R36-R38","v":0},0]
[null,"OTHER"]
[null,"BUDGET",null,null,null,{"$f":"SUM(C41:E41)","v":0},null,null,null,{"$f":"SUM(G41:I41)","v":0},null,null,null,{"$f":"SUM(K41:M41)","v":0},null,null,null,{"$f":"SUM(O41:Q41)","v":0},{"$f":"SUM(F41,J41,N41,R41)","v":0}]
[null,"ACTUAL",null,null,null,{"$f":"SUM(C42:E42)","v":0},null,null,null,{"$f":"SUM(G42:I42)","v":0},null,null,null,{"$f":"SUM(K42:M42)","v":0},null,null,null,{"$f":"SUM(O42:Q42)","v":0},{"$f":"SUM(F42,J42,N42,R42)","v":0}]
[null,"VARIANCE",{"$f":"C42-C41","v":0},{"$f":"D42-D41","v":0},{"$f":"E42-E41","v":0},{"$f":"F42-F41","v":0},{"$f":"G42-G41","v":0},{"$f":"H42-H41","v":0},{"$f":"I42-I41","v":0},{"$f":"J42-J41","v":0},{"$f":"K42-K41","v":0},{"$f":"L42-L41","v":0},{"$f":"M42-M41","v":0},{"$f":"N42-N41","v":0},{"$f":"O42-O41","v":0},{"$f":"P42-P41","v":0},{"$f":"Q42-Q41","v":0},{"$f":"R42-R41","v":0},0]
[null,"PREVIOUS YEAR ACTUAL",null,null,null,{"$f":"SUM(C44:E44)","v":0},null,null,null,{"$f":"SUM(G44:I44)","v":0},null,null,null,{"$f":"SUM(K44:M44)","v":0},null,null,null,{"$f":"SUM(O44:Q44)","v":0},0]
[null,"PREVIOUS YEAR VARIANCE",{"$f":"C42-C44","v":0},{"$f":"D42-D44","v":0},{"$f":"E42-E44","v":0},{"$f":"F42-F44","v":0},{"$f":"G42-G44","v":0},{"$f":"H42-H44","v":0},{"$f":"I42-I44","v":0},{"$f":"J42-J44","v":0},{"$f":"K42-K44","v":0},{"$f":"L42-L44","v":0},{"$f":"M42-M44","v":0},{"$f":"N42-N44","v":0},{"$f":"O42-O44","v":0},{"$f":"P42-P44","v":0},{"$f":"Q42-Q44","v":0},{"$f":"R42-R44","v":0},0]
[]
[null,"BALANCE SHEET CATEGORY","JAN","FEB","MAR","Q1 TOTAL","APR","MAY","JUN","Q2 TOTAL","JUL","AUG","SEPT","Q3 TOTAL","OCT","NOV","DEC","Q4 TOTAL","YR TOTAL"]
[null,"CASH"]
[null,"BUDGET",null,null,null,{"$f":"SUM(C49:E49)","v":0},null,null,null,{"$f":"SUM(G49:I49)","v":0},null,null,null,{"$f":"SUM(K49:M49)","v":0},null,null,null,{"$f":"SUM(O49:Q49)","v":0},{"$f":"SUM(F49,J49,N49,R49)","v":0}]
[null,"ACTUAL",null,null,null,{"$f":"SUM(C50:E50)","v":0},null,null,null,{"$f":"SUM(G50:I50)","v":0},null,null,null,{"$f":"SUM(K50:M50)","v":0},null,null,null,{"$f":"SUM(O50:Q50)","v":0},{"$f":"SUM(F50,J50,N50,R50)","v":0}]
[null,"VARIANCE",{"$f":"C50-C49","v":0},{"$f":"D50-D49","v":0},{"$f":"E50-E49","v":0},{"$f":"F50-F49","v":0},{"$f":"G50-G49","v":0},{"$f":"H50-H49","v":0},{"$f":"I50-I49","v":0},{"$f":"J50-J49","v":0},{"$f":"K50-K49","v":0},{"$f":"L50-L49","v":0},{"$f":"M50-M49","v":0},{"$f":"N50-N49","v":0},{"$f":"O50-O49","v":0},{"$f":"P50-P49","v":0},{"$f":"Q50-Q49","v":0},{"$f":"R50-R49","v":0},0]
[null,"PREVIOUS YEAR ACTUAL",null,null,null,{"$f":"SUM(C52:E52)","v":0},null,null,null,{"$f":"SUM(G52:I52)","v":0},null,null,null,{"$f":"SUM(K52:M52)","v":0},null,null,null,{"$f":"SUM(O52:Q52)","v":0},0]
[null,"PREVIOUS YEAR VARIANCE",{"$f":"C50-C52","v":0},{"$f":"D50-D52","v":0},{"$f":"E50-E52","v":0},{"$f":"F50-F52","v":0},{"$f":"G50-G52","v":0},{"$f":"H50-H52","v":0},{"$f":"I50-I52","v":0},{"$f":"J50-J52","v":0},{"$f":"K50-K52","v":0},{"$f":"L50-L52","v":0},{"$f":"M50-M52","v":0},{"$f":"N50-N52","v":0},{"$f":"O50-O52","v":0},{"$f":"P50-P52","v":0},{"$f":"Q50-Q52","v":0},{"$f":"R50-R52","v":0},0]
[null,"INVENTORY"]
[null,"BUDGET",null,null,null,{"$f":"SUM(C55:E55)","v":0},null,null,null,{"$f":"SUM(G55:I55)","v":0},null,null,null,{"$f":"SUM(K55:M55)","v":0},null,null,null,{"$f":"SUM(O55:Q55)","v":0},{"$f":"SUM(F55,J55,N55,R55)","v":0}]
[null,"ACTUAL",null,null,null,{"$f":"SUM(C56:E56)","v":0},null,null,null,{"$f":"SUM(G56:I56)","v":0},null,null,null,{"$f":"SUM(K56:M56)","v":0},null,null,null,{"$f":"SUM(O56:Q56)","v":0},{"$f":"SUM(F56,J56,N56,R56)","v":0}]
[null,"VARIANCE",{"$f":"C56-C55","v":0},{"$f":"D56-D55","v":0},{"$f":"E56-E55","v":0},{"$f":"F56-F55","v":0},{"$f":"G56-G55","v":0},{"$f":"H56-H55","v":0},{"$f":"I56-I55","v":0},{"$f":"J56-J55","v":0},{"$f":"K56-K55","v":0},{"$f":"L56-L55","v":0},{"$f":"M56-M55","v":0},{"$f":"N56-N55","v":0},{"$f":"O56-O55","v":0},{"$f":"P56-P55","v":0},{"$f":"Q56-Q55","v":0},{"$f":"R56-R55","v":0},0]
[null,"PREVIOUS YEAR ACTUAL",null,null,null,{"$f":"SUM(C58:E58)","v":0},null,null,null,{"$f":"SUM(G58:I58)","v":0},null,null,null,{"$f":"SUM(K58:M58)","v":0},null,null,null,{"$f":"SUM(O58:Q58)","v":0},0]
[null,"PREVIOUS YEAR VARIANCE",{"$f":"C56-C58","v":0},{"$f":"D56-D58","v":0},{"$f":"E56-E58","v":0},{"$f":"F56-F58","v":0},{"$f":"G56-G58","v":0},{"$f":"H56-H58","v":0},{"$f":"I56-I58","v":0},{"$f":"J56-J58","v":0},{"$f":"K56-K58","v":0},{"$f":"L56-L58","v":0},{"$f":"M56-M58","v":0},{"$f":"N56-N58","v":0},{"$f":"O56-O58","v":0},{"$f":"P56-P58","v":0},{"$f":"Q56-Q58","v":0},{"$f":"R56-R58","v":0},0]
[null,"ACCOUNTS RECEIVABLE"]
[null,"BUDGET",null,null,null,{"$f":"SUM(C61:E61)","v":0},null,null,null,{"$f":"SUM(G61:I61)","v":0},null,null,null,{"$f":"SUM(K61:M61)","v":0},null,null,null,{"$f":"SUM(O61:Q61)","v":0},{"$f":"SUM(F61,J61,N61,R61)","v":0}]
[null,"ACTUAL",null,null,null,{"$f":"SUM(C62:E62)","v":0},null,null,null,{"$f":"SUM(G62:I62)","v":0},null,null,null,{"$f":"SUM(K62:M62)","v":0},null,null,null,{"$f":"SUM(O62:Q62)","v":0},{"$f":"SUM(F62,J62,N62,R62)","v":0}]
[null,"VARIANCE",{"$f":"C62-C61","v":0},{"$f":"D62-D61","v":0},{"$f":"E62-E61","v":0},{"$f":"F62-F61","v":0},{"$f":"G62-G61","v":0},{"$f":"H62-H61","v":0},{"$f":"I62-I61","v":0},{"$f":"J62-J61","v":0},{"$f":"K62-K61","v":0},{"$f":"L62-L61","v":0},{"$f":"M62-M61","v":0},{"$f":"N62-N61","v":0},{"$f":"O62-O61","v":0},{"$f":"P62-P61","v":0},{"$f":"Q62-Q61","v":0},{"$f":"R62-R61","v":0},0]
[null,"PREVIOUS YEAR ACTUAL",null,null,null,{"$f":"SUM(C64:E64)","v":0},null,null,null,{"$f":"SUM(G64:I64)","v":0},null,null,null,{"$f":"SUM(K64:M64)","v":0},null,null,null,{"$f":"SUM(O64:Q64)","v":0},0]
[null,"PREVIOUS YEAR VARIANCE",{"$f":"C62-C64","v":0},{"$f":"D62-D64","v":0},{"$f":"E62-E64","v":0},{"$f":"F62-F64","v":0},{"$f":"G62-G64","v":0},{"$f":"H62-H64","v":0},{"$f":"I62-I64","v":0},{"$f":"J62-J64","v":0},{"$f":"K62-K64","v":0},{"$f":"L62-L64","v":0},{"$f":"M62-M64","v":0},{"$f":"N62-N64","v":0},{"$f":"O62-O64","v":0},{"$f":"P62-P64","v":0},{"$f":"Q62-Q64","v":0},{"$f":"R62-R64","v":0},0]
[null,"NET FIXED ASSETS"]
[null,"BUDGET",null,null,null,{"$f":"SUM(C67:E67)","v":0},null,null,null,{"$f":"SUM(G67:I67)","v":0},null,null,null,{"$f":"SUM(K67:M67)","v":0},null,null,null,{"$f":"SUM(O67:Q67)","v":0},{"$f":"SUM(F67,J67,N67,R67)","v":0}]
[null,"ACTUAL",null,null,null,{"$f":"SUM(C68:E68)","v":0},null,null,null,{"$f":"SUM(G68:I68)","v":0},null,null,null,{"$f":"SUM(K68:M68)","v":0},null,null,null,{"$f":"SUM(O68:Q68)","v":0},{"$f":"SUM(F68,J68,N68,R68)","v":0}]
[null,"VARIANCE",{"$f":"C68-C67","v":0},{"$f":"D68-D67","v":0},{"$f":"E68-E67","v":0},{"$f":"F68-F67","v":0},{"$f":"G68-G67","v":0},{"$f":"H68-H67","v":0},{"$f":"I68-I67","v":0},{"$f":"J68-J67","v":0},{"$f":"K68-K67","v":0},{"$f":"L68-L67","v":0},{"$f":"M68-M67","v":0},{"$f":"N68-N67","v":0},{"$f":"O68-O67","v":0},{"$f":"P68-P67","v":0},{"$f":"Q68-Q67","v":0},{"$f":"R68-R67","v":0},0]
[null,"PREVIOUS YEAR ACTUAL",null,null,null,{"$f":"SUM(C70:E70)","v":0},null,null,null,{"$f":"SUM(G70:I70)","v":0},null,null,null,{"$f":"SUM(K70:M70)","v":0},null,null,null,{"$f":"SUM(O70:Q70)","v":0},0]
[null,"PREVIOUS YEAR VARIANCE",{"$f":"C68-C70","v":0},{"$f":"D68-D70","v":0},{"$f":"E68-E70","v":0},{"$f":"F68-F70","v":0},{"$f":"G68-G70","v":0},{"$f":"H68-H70","v":0},{"$f":"I68-I70","v":0},{"$f":"J68-J70","v":0},{"$f":"K68-K70","v":0},{"$f":"L68-L70","v":0},{"$f":"M68-M70","v":0},{"$f":"N68-N70","v":0},{"$f":"O68-O70","v":0},{"$f":"P68-P70","v":0},{"$f":"Q68-Q70","v":0},{"$f":"R68-R70","v":0},0]
[null,"ACCOUNTS PAYABLE"]
[null,"BUDGET",null,null,null,{"$f":"SUM(C73:E73)","v":0},null,null,null,{"$f":"SUM(G73:I73)","v":0},null,null,null,{"$f":"SUM(K73:M73)","v":0},null,null,null,{"$f":"SUM(O73:Q73)","v":0},{"$f":"SUM(F73,J73,N73,R73)","v":0}]
[null,"ACTUAL",null,null,null,{"$f":"SUM(C74:E74)","v":0},null,null,null,{"$f":"SUM(G74:I74)","v":0},null,null,null,{"$f":"SUM(K74:M74)","v":0},null,null,null,{"$f":"SUM(O74:Q74)","v":0},{"$f":"SUM(F74,J74,N74,R74)","v":0}]
[null,"VARIANCE",{"$f":"C74-C73","v":0},{"$f":"D74-D73","v":0},{"$f":"E74-E73","v":0},{"$f":"F74-F73","v":0},{"$f":"G74-G73","v":0},{"$f":"H74-H73","v":0},{"$f":"I74-I73","v":0},{"$f":"J74-J73","v":0},{"$f":"K74-K73","v":0},{"$f":"L74-L73","v":0},{"$f":"M74-M73","v":0},{"$f":"N74-N73","v":0},{"$f":"O74-O73","v":0},{"$f":"P74-P73","v":0},{"$f":"Q74-Q73","v":0},{"$f":"R74-R73","v":0},0]
[null,"PREVIOUS YEAR ACTUAL",null,null,null,{"$f":"SUM(C76:E76)","v":0},null,null,null,{"$f":"SUM(G76:I76)","v":0},null,null,null,{"$f":"SUM(K76:M76)","v":0},null,null,null,{"$f":"SUM(O76:Q76)","v":0},0]
[null,"PREVIOUS YEAR VARIANCE",{"$f":"C74-C76","v":0},{"$f":"D74-D76","v":0},{"$f":"E74-E76","v":0},{"$f":"F74-F76","v":0},{"$f":"G74-G76","v":0},{"$f":"H74-H76","v":0},{"$f":"I74-I76","v":0},{"$f":"J74-J76","v":0},{"$f":"K74-K76","v":0},{"$f":"L74-L76","v":0},{"$f":"M74-M76","v":0},{"$f":"N74-N76","v":0},{"$f":"O74-O76","v":0},{"$f":"P74-P76","v":0},{"$f":"Q74-Q76","v":0},{"$f":"R74-R76","v":0},0]
[null,"LONG-TERM DEBT"]
[null,"BUDGET",null,null,null,{"$f":"SUM(C79:E79)","v":0},null,null,null,{"$f":"SUM(G79:I79)","v":0},null,null,null,{"$f":"SUM(K79:M79)","v":0},null,null,null,{"$f":"SUM(O79:Q79)","v":0},{"$f":"SUM(F79,J79,N79,R79)","v":0}]
[null,"ACTUAL",null,null,null,{"$f":"SUM(C80:E80)","v":0},null,null,null,{"$f":"SUM(G80:I80)","v":0},null,null,null,{"$f":"SUM(K80:M80)","v":0},null,null,null,{"$f":"SUM(O80:Q80)","v":0},{"$f":"SUM(F80,J80,N80,R80)","v":0}]
[null,"VARIANCE",{"$f":"C80-C79","v":0},{"$f":"D80-D79","v":0},{"$f":"E80-E79","v":0},{"$f":"F80-F79","v":0},{"$f":"G80-G79","v":0},{"$f":"H80-H79","v":0},{"$f":"I80-I79","v":0},{"$f":"J80-J79","v":0},{"$f":"K80-K79","v":0},{"$f":"L80-L79","v":0},{"$f":"M80-M79","v":0},{"$f":"N80-N79","v":0},{"$f":"O80-O79","v":0},{"$f":"P80-P79","v":0},{"$f":"Q80-Q79","v":0},{"$f":"R80-R79","v":0},0]
[null,"PREVIOUS YEAR ACTUAL",null,null,null,{"$f":"SUM(C82:E82)","v":0},null,null,null,{"$f":"SUM(G82:I82)","v":0},null,null,null,{"$f":"SUM(K82:M82)","v":0},null,null,null,{"$f":"SUM(O82:Q82)","v":0},0]
[null,"PREVIOUS YEAR VARIANCE",{"$f":"C80-C82","v":0},{"$f":"D80-D82","v":0},{"$f":"E80-E82","v":0},{"$f":"F80-F82","v":0},{"$f":"G80-G82","v":0},{"$f":"H80-H82","v":0},{"$f":"I80-I82","v":0},{"$f":"J80-J82","v":0},{"$f":"K80-K82","v":0},{"$f":"L80-L82","v":0},{"$f":"M80-M82","v":0},{"$f":"N80-N82","v":0},{"$f":"O80-O82","v":0},{"$f":"P80-P82","v":0},{"$f":"Q80-Q82","v":0},{"$f":"R80-R82","v":0},0]
[null,"OTHER"]
[null,"BUDGET",null,null,null,{"$f":"SUM(C85:E85)","v":0},null,null,null,{"$f":"SUM(G85:I85)","v":0},null,null,null,{"$f":"SUM(K85:M85)","v":0},null,null,null,{"$f":"SUM(O85:Q85)","v":0},{"$f":"SUM(F85,J85,N85,R85)","v":0}]
[null,"ACTUAL",null,null,null,{"$f":"SUM(C86:E86)","v":0},null,null,null,{"$f":"SUM(G86:I86)","v":0},null,null,null,{"$f":"SUM(K86:M86)","v":0},null,null,null,{"$f":"SUM(O86:Q86)","v":0},{"$f":"SUM(F86,J86,N86,R86)","v":0}]
[null,"VARIANCE",{"$f":"C86-C85","v":0},{"$f":"D86-D85","v":0},{"$f":"E86-E85","v":0},{"$f":"F86-F85","v":0},{"$f":"G86-G85","v":0},{"$f":"H86-H85","v":0},{"$f":"I86-I85","v":0},{"$f":"J86-J85","v":0},{"$f":"K86-K85","v":0},{"$f":"L86-L85","v":0},{"$f":"M86-M85","v":0},{"$f":"N86-N85","v":0},{"$f":"O86-O85","v":0},{"$f":"P86-P85","v":0},{"$f":"Q86-Q85","v":0},{"$f":"R86-R85","v":0},0]
[null,"PREVIOUS YEAR ACTUAL",null,null,null,{"$f":"SUM(C88:E88)","v":0},null,null,null,{"$f":"SUM(G88:I88)","v":0},null,null,null,{"$f":"SUM(K88:M88)","v":0},null,null,null,{"$f":"SUM(O88:Q88)","v":0},0]
[null,"PREVIOUS YEAR VARIANCE",{"$f":"C86-C88","v":0},{"$f":"D86-D88","v":0},{"$f":"E86-E88","v":0},{"$f":"F86-F88","v":0},{"$f":"G86-G88","v":0},{"$f":"H86-H88","v":0},{"$f":"I86-I88","v":0},{"$f":"J86-J88","v":0},{"$f":"K86-K88","v":0},{"$f":"L86-L88","v":0},{"$f":"M86-M88","v":0},{"$f":"N86-N88","v":0},{"$f":"O86-O88","v":0},{"$f":"P86-P88","v":0},{"$f":"Q86-Q88","v":0},{"$f":"R86-R88","v":0},0]
[]
[null,"CLICK HERE TO CREATE 12-MONTH BUSINESS BUDGET TEMPLATES IN SMARTSHEET"]

{"sheet":"12 Month Business Budget","index":1,"n_rows":91,"n_cols":19,"rows_kept":91,"cut":false,"hidden":false,"merged":[[90,2,90,16]]}
[" ","12 MONTH BUSINESS BUDGET"]
[]
[null,"PROFIT & LOSS CATEGORY","JAN","FEB","MAR","Q1 TOTAL","APR","MAY","JUN","Q2 TOTAL","JUL","AUG","SEPT","Q3 TOTAL","OCT","NOV","DEC","Q4 TOTAL","YR TOTAL"]
[null,"REVENUE"]
[null,"BUDGET",1000,1000,1000,{"$f":"SUM(C5:E5)","v":3000},1000,1000,1000,{"$f":"SUM(G5:I5)","v":3000},1000,1000,1000,{"$f":"SUM(K5:M5)","v":3000},1000,1000,1000,{"$f":"SUM(O5:Q5)","v":3000},{"$f":"SUM(F5,J5,N5,R5)","v":12000}]
[null,"ACTUAL",500,700,1100,{"$f":"SUM(C6:E6)","v":2300},500,700,1100,{"$f":"SUM(G6:I6)","v":2300},500,700,1100,{"$f":"SUM(K6:M6)","v":2300},500,700,1100,{"$f":"SUM(O6:Q6)","v":2300},{"$f":"SUM(F6,J6,N6,R6)","v":9200}]
[null,"VARIANCE",{"$f":"C6-C5","v":-500},{"$f":"D6-D5","v":-300},100,{"$f":"F6-F5","v":-700},{"$f":"G6-G5","v":-500},{"$f":"H6-H5","v":-300},{"$f":"I6-I5","v":100},{"$f":"J6-J5","v":-700},{"$f":"K6-K5","v":-500},{"$f":"L6-L5","v":-300},{"$f":"M6-M5","v":100},{"$f":"N6-N5","v":-700},{"$f":"O6-O5","v":-500},{"$f":"P6-P5","v":-300},{"$f":"Q6-Q5","v":100},{"$f":"R6-R5","v":-700},-2800]
[null,"PREVIOUS YEAR ACTUAL",700,1100,800,{"$f":"SUM(C8:E8)","v":2600},700,1100,800,{"$f":"SUM(G8:I8)","v":2600},700,1100,800,{"$f":"SUM(K8:M8)","v":2600},700,1100,800,{"$f":"SUM(O8:Q8)","v":2600},10400]
[null,"PREVIOUS YEAR VARIANCE",{"$f":"C6-C8","v":-200},{"$f":"D6-D8","v":-400},300,-300,{"$f":"G6-G8","v":-200},{"$f":"H6-H8","v":-400},{"$f":"I6-I8","v":300},{"$f":"J6-J8","v":-300},{"$f":"K6-K8","v":-200},{"$f":"L6-L8","v":-400},{"$f":"M6-M8","v":300},{"$f":"N6-N8","v":-300},{"$f":"O6-O8","v":-200},{"$f":"P6-P8","v":-400},{"$f":"Q6-Q8","v":300},{"$f":"R6-R8","v":-300},-1200]
[null,"COGS Cost of Goods Sold"]
[null,"BUDGET",1000,1000,1000,{"$f":"SUM(C11:E11)","v":3000},1000,1000,1000,{"$f":"SUM(G11:I11)","v":3000},1000,1000,1000,{"$f":"SUM(K11:M11)","v":3000},1000,1000,1000,{"$f":"SUM(O11:Q11)","v":3000},{"$f":"SUM(F11,J11,N11,R11)","v":12000}]
[null,"ACTUAL",500,700,1100,{"$f":"SUM(C12:E12)","v":2300},500,700,1100,{"$f":"SUM(G12:I12)","v":2300},500,700,1100,{"$f":"SUM(K12:M12)","v":2300},500,700,1100,{"$f":"SUM(O12:Q12)","v":2300},{"$f":"SUM(F12,J12,N12,R12)","v":9200}]
[null,"VARIANCE",{"$f":"C12-C11","v":-500},{"$f":"D12-D11","v":-300},{"$f":"E12-E11","v":100},{"$f":"F12-F11","v":-700},{"$f":"G12-G11","v":-500},{"$f":"H12-H11","v":-300},{"$f":"I12-I11","v":100},{"$f":"J12-J11","v":-700},{"$f":"K12-K11","v":-500},{"$f":"L12-L11","v":-300},{"$f":"M12-M11","v":100},{"$f":"N12-N11","v":-700},{"$f":"O12-O11","v":-500},{"$f":"P12-P11","v":-300},{"$f":"Q12-Q11","v":100},{"$f":"R12-R11","v":-700},-2800]
[null,"PREVIOUS YEAR ACTUAL",700,1100,800,{"$f":"SUM(C14:E14)","v":2600},700,1100,800,{"$f":"SUM(G14:I14)","v":2600},700,1100,800,{"$f":"SUM(K14:M14)","v":2600},700,1100,800,{"$f":"SUM(O14:Q14)","v":2600},10400]
[null,"PREVIOUS YEAR VARIANCE",{"$f":"C12-C14","v":-200},{"$f":"D12-D14","v":-400},{"$f":"E12-E14","v":300},{"$f":"F12-F14","v":-300},{"$f":"G12-G14","v":-200},{"$f":"H12-H14","v":-400},{"$f":"I12-I14","v":300},{"$f":"J12-J14","v":-300},{"$f":"K12-K14","v":-200},{"$f":"L12-L14","v":-400},{"$f":"M12-M14","v":300},{"$f":"N12-N14","v":-300},{"$f":"O12-O14","v":-200},{"$f":"P12-P14","v":-400},{"$f":"Q12-Q14","v":300},{"$f":"R12-R14","v":-300},-1200]
[null,"SALES / MARKETING COSTS"]
[null,"BUDGET",1000,1000,1000,{"$f":"SUM(C17:E17)","v":3000},1000,1000,1000,{"$f":"SUM(G17:I17)","v":3000},1000,1000,1000,{"$f":"SUM(K17:M17)","v":3000},1000,1000,1000,{"$f":"SUM(O17:Q17)","v":3000},{"$f":"SUM(F17,J17,N17,R17)","v":12000}]
[null,"ACTUAL",500,700,1100,{"$f":"SUM(C18:E18)","v":2300},500,700,1100,{"$f":"SUM(G18:I18)","v":2300},500,700,1100,{"$f":"SUM(K18:M18)","v":2300},500,700,1100,{"$f":"SUM(O18:Q18)","v":2300},{"$f":"SUM(F18,J18,N18,R18)","v":9200}]
[null,"VARIANCE",{"$f":"C18-C17","v":-500},{"$f":"D18-D17","v":-300},{"$f":"E18-E17","v":100},{"$f":"F18-F17","v":-700},{"$f":"G18-G17","v":-500},{"$f":"H18-H17","v":-300},{"$f":"I18-I17","v":100},{"$f":"J18-J17","v":-700},{"$f":"K18-K17","v":-500},{"$f":"L18-L17","v":-300},{"$f":"M18-M17","v":100},{"$f":"N18-N17","v":-700},{"$f":"O18-O17","v":-500},{"$f":"P18-P17","v":-300},{"$f":"Q18-Q17","v":100},{"$f":"R18-R17","v":-700},-2800]
[null,"PREVIOUS YEAR ACTUAL",700,1100,800,{"$f":"SUM(C20:E20)","v":2600},700,1100,800,{"$f":"SUM(G20:I20)","v":2600},700,1100,800,{"$f":"SUM(K20:M20)","v":2600},700,1100,800,{"$f":"SUM(O20:Q20)","v":2600},10400]
[null,"PREVIOUS YEAR VARIANCE",{"$f":"C18-C20","v":-200},{"$f":"D18-D20","v":-400},{"$f":"E18-E20","v":300},{"$f":"F18-F20","v":-300},{"$f":"G18-G20","v":-200},{"$f":"H18-H20","v":-400},{"$f":"I18-I20","v":300},{"$f":"J18-J20","v":-300},{"$f":"K18-K20","v":-200},{"$f":"L18-L20","v":-400},{"$f":"M18-M20","v":300},{"$f":"N18-N20","v":-300},{"$f":"O18-O20","v":-200},{"$f":"P18-P20","v":-400},{"$f":"Q18-Q20","v":300},{"$f":"R18-R20","v":-300},-1200]
[null,"LABOR COSTS"]
[null,"BUDGET",1000,1000,1000,{"$f":"SUM(C23:E23)","v":3000},1000,1000,1000,{"$f":"SUM(G23:I23)","v":3000},1000,1000,1000,{"$f":"SUM(K23:M23)","v":3000},1000,1000,1000,{"$f":"SUM(O23:Q23)","v":3000},{"$f":"SUM(F23,J23,N23,R23)","v":12000}]
[null,"ACTUAL",500,700,1100,{"$f":"SUM(C24:E24)","v":2300},500,700,1100,{"$f":"SUM(G24:I24)","v":2300},500,700,1100,{"$f":"SUM(K24:M24)","v":2300},500,700,1100,{"$f":"SUM(O24:Q24)","v":2300},{"$f":"SUM(F24,J24,N24,R24)","v":9200}]
[null,"VARIANCE",{"$f":"C24-C23","v":-500},{"$f":"D24-D23","v":-300},{"$f":"E24-E23","v":100},{"$f":"F24-F23","v":-700},{"$f":"G24-G23","v":-500},{"$f":"H24-H23","v":-300},{"$f":"I24-I23","v":100},{"$f":"J24-J23","v":-700},{"$f":"K24-K23","v":-500},{"$f":"L24-L23","v":-300},{"$f":"M24-M23","v":100},{"$f":"N24-N23","v":-700},{"$f":"O24-O23","v":-500},{"$f":"P24-P23","v":-300},{"$f":"Q24-Q23","v":100},{"$f":"R24-R23","v":-700},-2800]
[null,"PREVIOUS YEAR ACTUAL",700,1100,800,{"$f":"SUM(C26:E26)","v":2600},700,1100,800,{"$f":"SUM(G26:I26)","v":2600},700,1100,800,{"$f":"SUM(K26:M26)","v":2600},700,1100,800,{"$f":"SUM(O26:Q26)","v":2600},10400]
[null,"PREVIOUS YEAR VARIANCE",{"$f":"C24-C26","v":-200},{"$f":"D24-D26","v":-400},{"$f":"E24-E26","v":300},{"$f":"F24-F26","v":-300},{"$f":"G24-G26","v":-200},{"$f":"H24-H26","v":-400},{"$f":"I24-I26","v":300},{"$f":"J24-J26","v":-300},{"$f":"K24-K26","v":-200},{"$f":"L24-L26","v":-400},{"$f":"M24-M26","v":300},{"$f":"N24-N26","v":-300},{"$f":"O24-O26","v":-200},{"$f":"P24-P26","v":-400},{"$f":"Q24-Q26","v":300},{"$f":"R24-R26","v":-300},-1200]
[null,"ADMIN / GENERAL"]
[null,"BUDGET",1000,1000,1000,{"$f":"SUM(C29:E29)","v":3000},1000,1000,1000,{"$f":"SUM(G29:I29)","v":3000},1000,1000,1000,{"$f":"SUM(K29:M29)","v":3000},1000,1000,1000,{"$f":"SUM(O29:Q29)","v":3000},{"$f":"SUM(F29,J29,N29,R29)","v":12000}]
[null,"ACTUAL",500,700,1100,{"$f":"SUM(C30:E30)","v":2300},500,700,1100,{"$f":"SUM(G30:I30)","v":2300},500,700,1100,{"$f":"SUM(K30:M30)","v":2300},500,700,1100,{"$f":"SUM(O30:Q30)","v":2300},{"$f":"SUM(F30,J30,N30,R30)","v":9200}]
[null,"VARIANCE",{"$f":"C30-C29","v":-500},{"$f":"D30-D29","v":-300},{"$f":"E30-E29","v":100},{"$f":"F30-F29","v":-700},{"$f":"G30-G29","v":-500},{"$f":"H30-H29","v":-300},{"$f":"I30-I29","v":100},{"$f":"J30-J29","v":-700},{"$f":"K30-K29","v":-500},{"$f":"L30-L29","v":-300},{"$f":"M30-M29","v":100},{"$f":"N30-N29","v":-700},{"$f":"O30-O29","v":-500},{"$f":"P30-P29","v":-300},{"$f":"Q30-Q29","v":100},{"$f":"R30-R29","v":-700},-2800]
[null,"PREVIOUS YEAR ACTUAL",700,1100,800,{"$f":"SUM(C32:E32)","v":2600},700,1100,800,{"$f":"SUM(G32:I32)","v":2600},700,1100,800,{"$f":"SUM(K32:M32)","v":2600},700,1100,800,{"$f":"SUM(O32:Q32)","v":2600},10400]
[null,"PREVIOUS YEAR VARIANCE",{"$f":"C30-C32","v":-200},{"$f":"D30-D32","v":-400},{"$f":"E30-E32","v":300},{"$f":"F30-F32","v":-300},{"$f":"G30-G32","v":-200},{"$f":"H30-H32","v":-400},{"$f":"I30-I32","v":300},{"$f":"J30-J32","v":-300},{"$f":"K30-K32","v":-200},{"$f":"L30-L32","v":-400},{"$f":"M30-M32","v":300},{"$f":"N30-N32","v":-300},{"$f":"O30-O32","v":-200},{"$f":"P30-P32","v":-400},{"$f":"Q30-Q32","v":300},{"$f":"R30-R32","v":-300},-1200]
[null,"EBIT Earnings Before Interest &  Taxes"]
[null,"BUDGET",1000,1000,1000,{"$f":"SUM(C35:E35)","v":3000},1000,1000,1000,{"$f":"SUM(G35:I35)","v":3000},1000,1000,1000,{"$f":"SUM(K35:M35)","v":3000},1000,1000,1000,{"$f":"SUM(O35:Q35)","v":3000},{"$f":"SUM(F35,J35,N35,R35)","v":12000}]
[null,"ACTUAL",500,700,1100,{"$f":"SUM(C36:E36)","v":2300},500,700,1100,{"$f":"SUM(G36:I36)","v":2300},500,700,1100,{"$f":"SUM(K36:M36)","v":2300},500,700,1100,{"$f":"SUM(O36:Q36)","v":2300},{"$f":"SUM(F36,J36,N36,R36)","v":9200}]
[null,"VARIANCE",{"$f":"C36-C35","v":-500},{"$f":"D36-D35","v":-300},{"$f":"E36-E35","v":100},{"$f":"F36-F35","v":-700},{"$f":"G36-G35","v":-500},{"$f":"H36-H35","v":-300},{"$f":"I36-I35","v":100},{"$f":"J36-J35","v":-700},{"$f":"K36-K35","v":-500},{"$f":"L36-L35","v":-300},{"$f":"M36-M35","v":100},{"$f":"N36-N35","v":-700},{"$f":"O36-O35","v":-500},{"$f":"P36-P35","v":-300},{"$f":"Q36-Q35","v":100},{"$f":"R36-R35","v":-700},-2800]
[null,"PREVIOUS YEAR ACTUAL",700,1100,800,{"$f":"SUM(C38:E38)","v":2600},700,1100,800,{"$f":"SUM(G38:I38)","v":2600},700,1100,800,{"$f":"SUM(K38:M38)","v":2600},700,1100,800,{"$f":"SUM(O38:Q38)","v":2600},10400]
[null,"PREVIOUS YEAR VARIANCE",{"$f":"C36-C38","v":-200},{"$f":"D36-D38","v":-400},{"$f":"E36-E38","v":300},{"$f":"F36-F38","v":-300},{"$f":"G36-G38","v":-200},{"$f":"H36-H38","v":-400},{"$f":"I36-I38","v":300},{"$f":"J36-J38","v":-300},{"$f":"K36-K38","v":-200},{"$f":"L36-L38","v":-400},{"$f":"M36-M38","v":300},{"$f":"N36-N38","v":-300},{"$f":"O36-O38","v":-200},{"$f":"P36-P38","v":-400},{"$f":"Q36-Q38","v":300},{"$f":"R36-R38","v":-300},-1200]
[null,"OTHER"]
[null,"BUDGET",1000,1000,1000,{"$f":"SUM(C41:E41)","v":3000},1000,1000,1000,{"$f":"SUM(G41:I41)","v":3000},1000,1000,1000,{"$f":"SUM(K41:M41)","v":3000},1000,1000,1000,{"$f":"SUM(O41:Q41)","v":3000},{"$f":"SUM(F41,J41,N41,R41)","v":12000}]
[null,"ACTUAL",500,700,1100,{"$f":"SUM(C42:E42)","v":2300},500,700,1100,{"$f":"SUM(G42:I42)","v":2300},500,700,1100,{"$f":"SUM(K42:M42)","v":2300},500,700,1100,{"$f":"SUM(O42:Q42)","v":2300},{"$f":"SUM(F42,J42,N42,R42)","v":9200}]
[null,"VARIANCE",{"$f":"C42-C41","v":-500},{"$f":"D42-D41","v":-300},{"$f":"E42-E41","v":100},{"$f":"F42-F41","v":-700},{"$f":"G42-G41","v":-500},{"$f":"H42-H41","v":-300},{"$f":"I42-I41","v":100},{"$f":"J42-J41","v":-700},{"$f":"K42-K41","v":-500},{"$f":"L42-L41","v":-300},{"$f":"M42-M41","v":100},{"$f":"N42-N41","v":-700},{"$f":"O42-O41","v":-500},{"$f":"P42-P41","v":-300},{"$f":"Q42-Q41","v":100},{"$f":"R42-R41","v":-700},-2800]
[null,"PREVIOUS YEAR ACTUAL",700,1100,800,{"$f":"SUM(C44:E44)","v":2600},700,1100,800,{"$f":"SUM(G44:I44)","v":2600},700,1100,800,{"$f":"SUM(K44:M44)","v":2600},700,1100,800,{"$f":"SUM(O44:Q44)","v":2600},10400]
[null,"PREVIOUS YEAR VARIANCE",{"$f":"C42-C44","v":-200},{"$f":"D42-D44","v":-400},{"$f":"E42-E44","v":300},{"$f":"F42-F44","v":-300},{"$f":"G42-G44","v":-200},{"$f":"H42-H44","v":-400},{"$f":"I42-I44","v":300},{"$f":"J42-J44","v":-300},{"$f":"K42-K44","v":-200},{"$f":"L42-L44","v":-400},{"$f":"M42-M44","v":300},{"$f":"N42-N44","v":-300},{"$f":"O42-O44","v":-200},{"$f":"P42-P44","v":-400},{"$f":"Q42-Q44","v":300},{"$f":"R42-R44","v":-300},-1200]
[]
[null,"BALANCE SHEET CATEGORY","JAN","FEB","MAR","Q1 TOTAL","APR","MAY","JUN","Q2 TOTAL","JUL","AUG","SEPT","Q3 TOTAL","OCT","NOV","DEC","Q4 TOTAL","YR TOTAL"]
[null,"CASH"]
[null,"BUDGET",1000,1000,1000,{"$f":"SUM(C49:E49)","v":3000},1000,1000,1000,{"$f":"SUM(G49:I49)","v":3000},1000,1000,1000,{"$f":"SUM(K49:M49)","v":3000},1000,1000,1000,{"$f":"SUM(O49:Q49)","v":3000},{"$f":"SUM(F49,J49,N49,R49)","v":12000}]
[null,"ACTUAL",500,700,1100,{"$f":"SUM(C50:E50)","v":2300},500,700,1100,{"$f":"SUM(G50:I50)","v":2300},500,700,1100,{"$f":"SUM(K50:M50)","v":2300},500,700,1100,{"$f":"SUM(O50:Q50)","v":2300},{"$f":"SUM(F50,J50,N50,R50)","v":9200}]
[null,"VARIANCE",{"$f":"C50-C49","v":-500},{"$f":"D50-D49","v":-300},{"$f":"E50-E49","v":100},{"$f":"F50-F49","v":-700},{"$f":"G50-G49","v":-500},{"$f":"H50-H49","v":-300},{"$f":"I50-I49","v":100},{"$f":"J50-J49","v":-700},{"$f":"K50-K49","v":-500},{"$f":"L50-L49","v":-300},{"$f":"M50-M49","v":100},{"$f":"N50-N49","v":-700},{"$f":"O50-O49","v":-500},{"$f":"P50-P49","v":-300},{"$f":"Q50-Q49","v":100},{"$f":"R50-R49","v":-700},-2800]
[null,"PREVIOUS YEAR ACTUAL",700,1100,800,{"$f":"SUM(C52:E52)","v":2600},700,1100,800,{"$f":"SUM(G52:I52)","v":2600},700,1100,800,{"$f":"SUM(K52:M52)","v":2600},700,1100,800,{"$f":"SUM(O52:Q52)","v":2600},10400]
[null,"PREVIOUS YEAR VARIANCE",{"$f":"C50-C52","v":-200},{"$f":"D50-D52","v":-400},{"$f":"E50-E52","v":300},{"$f":"F50-F52","v":-300},{"$f":"G50-G52","v":-200},{"$f":"H50-H52","v":-400},{"$f":"I50-I52","v":300},{"$f":"J50-J52","v":-300},{"$f":"K50-K52","v":-200},{"$f":"L50-L52","v":-400},{"$f":"M50-M52","v":300},{"$f":"N50-N52","v":-300},{"$f":"O50-O52","v":-200},{"$f":"P50-P52","v":-400},{"$f":"Q50-Q52","v":300},{"$f":"R50-R52","v":-300},-1200]
[null,"INVENTORY"]
[null,"BUDGET",1000,1000,1000,{"$f":"SUM(C55:E55)","v":3000},1000,1000,1000,{"$f":"SUM(G55:I55)","v":3000},1000,1000,1000,{"$f":"SUM(K55:M55)","v":3000},1000,1000,1000,{"$f":"SUM(O55:Q55)","v":3000},{"$f":"SUM(F55,J55,N55,R55)","v":12000}]
[null,"ACTUAL",500,700,1100,{"$f":"SUM(C56:E56)","v":2300},500,700,1100,{"$f":"SUM(G56:I56)","v":2300},500,700,1100,{"$f":"SUM(K56:M56)","v":2300},500,700,1100,{"$f":"SUM(O56:Q56)","v":2300},{"$f":"SUM(F56,J56,N56,R56)","v":9200}]
[null,"VARIANCE",{"$f":"C56-C55","v":-500},{"$f":"D56-D55","v":-300},{"$f":"E56-E55","v":100},{"$f":"F56-F55","v":-700},{"$f":"G56-G55","v":-500},{"$f":"H56-H55","v":-300},{"$f":"I56-I55","v":100},{"$f":"J56-J55","v":-700},{"$f":"K56-K55","v":-500},{"$f":"L56-L55","v":-300},{"$f":"M56-M55","v":100},{"$f":"N56-N55","v":-700},{"$f":"O56-O55","v":-500},{"$f":"P56-P55","v":-300},{"$f":"Q56-Q55","v":100},{"$f":"R56-R55","v":-700},-2800]
[null,"PREVIOUS YEAR ACTUAL",700,1100,800,{"$f":"SUM(C58:E58)","v":2600},700,1100,800,{"$f":"SUM(G58:I58)","v":2600},700,1100,800,{"$f":"SUM(K58:M58)","v":2600},700,1100,800,{"$f":"SUM(O58:Q58)","v":2600},10400]
[null,"PREVIOUS YEAR VARIANCE",{"$f":"C56-C58","v":-200},{"$f":"D56-D58","v":-400},{"$f":"E56-E58","v":300},{"$f":"F56-F58","v":-300},{"$f":"G56-G58","v":-200},{"$f":"H56-H58","v":-400},{"$f":"I56-I58","v":300},{"$f":"J56-J58","v":-300},{"$f":"K56-K58","v":-200},{"$f":"L56-L58","v":-400},{"$f":"M56-M58","v":300},{"$f":"N56-N58","v":-300},{"$f":"O56-O58","v":-200},{"$f":"P56-P58","v":-400},{"$f":"Q56-Q58","v":300},{"$f":"R56-R58","v":-300},-1200]
[null,"ACCOUNTS RECEIVABLE"]
[null,"BUDGET",1000,1000,1000,{"$f":"SUM(C61:E61)","v":3000},1000,1000,1000,{"$f":"SUM(G61:I61)","v":3000},1000,1000,1000,{"$f":"SUM(K61:M61)","v":3000},1000,1000,1000,{"$f":"SUM(O61:Q61)","v":3000},{"$f":"SUM(F61,J61,N61,R61)","v":12000}]
[null,"ACTUAL",500,700,1100,{"$f":"SUM(C62:E62)","v":2300},500,700,1100,{"$f":"SUM(G62:I62)","v":2300},500,700,1100,{"$f":"SUM(K62:M62)","v":2300},500,700,1100,{"$f":"SUM(O62:Q62)","v":2300},{"$f":"SUM(F62,J62,N62,R62)","v":9200}]
[null,"VARIANCE",{"$f":"C62-C61","v":-500},{"$f":"D62-D61","v":-300},{"$f":"E62-E61","v":100},{"$f":"F62-F61","v":-700},{"$f":"G62-G61","v":-500},{"$f":"H62-H61","v":-300},{"$f":"I62-I61","v":100},{"$f":"J62-J61","v":-700},{"$f":"K62-K61","v":-500},{"$f":"L62-L61","v":-300},{"$f":"M62-M61","v":100},{"$f":"N62-N61","v":-700},{"$f":"O62-O61","v":-500},{"$f":"P62-P61","v":-300},{"$f":"Q62-Q61","v":100},{"$f":"R62-R61","v":-700},-2800]
[null,"PREVIOUS YEAR ACTUAL",700,1100,800,{"$f":"SUM(C64:E64)","v":2600},700,1100,800,{"$f":"SUM(G64:I64)","v":2600},700,1100,800,{"$f":"SUM(K64:M64)","v":2600},700,1100,800,{"$f":"SUM(O64:Q64)","v":2600},10400]
[null,"PREVIOUS YEAR VARIANCE",{"$f":"C62-C64","v":-200},{"$f":"D62-D64","v":-400},{"$f":"E62-E64","v":300},{"$f":"F62-F64","v":-300},{"$f":"G62-G64","v":-200},{"$f":"H62-H64","v":-400},{"$f":"I62-I64","v":300},{"$f":"J62-J64","v":-300},{"$f":"K62-K64","v":-200},{"$f":"L62-L64","v":-400},{"$f":"M62-M64","v":300},{"$f":"N62-N64","v":-300},{"$f":"O62-O64","v":-200},{"$f":"P62-P64","v":-400},{"$f":"Q62-Q64","v":300},{"$f":"R62-R64","v":-300},-1200]
[null,"NET FIXED ASSETS"]
[null,"BUDGET",1000,1000,1000,{"$f":"SUM(C67:E67)","v":3000},1000,1000,1000,{"$f":"SUM(G67:I67)","v":3000},1000,1000,1000,{"$f":"SUM(K67:M67)","v":3000},1000,1000,1000,{"$f":"SUM(O67:Q67)","v":3000},{"$f":"SUM(F67,J67,N67,R67)","v":12000}]
[null,"ACTUAL",500,700,1100,{"$f":"SUM(C68:E68)","v":2300},500,700,1100,{"$f":"SUM(G68:I68)","v":2300},500,700,1100,{"$f":"SUM(K68:M68)","v":2300},500,700,1100,{"$f":"SUM(O68:Q68)","v":2300},{"$f":"SUM(F68,J68,N68,R68)","v":9200}]
[null,"VARIANCE",{"$f":"C68-C67","v":-500},{"$f":"D68-D67","v":-300},{"$f":"E68-E67","v":100},{"$f":"F68-F67","v":-700},{"$f":"G68-G67","v":-500},{"$f":"H68-H67","v":-300},{"$f":"I68-I67","v":100},{"$f":"J68-J67","v":-700},{"$f":"K68-K67","v":-500},{"$f":"L68-L67","v":-300},{"$f":"M68-M67","v":100},{"$f":"N68-N67","v":-700},{"$f":"O68-O67","v":-500},{"$f":"P68-P67","v":-300},{"$f":"Q68-Q67","v":100},{"$f":"R68-R67","v":-700},-2800]
[null,"PREVIOUS YEAR ACTUAL",700,1100,800,{"$f":"SUM(C70:E70)","v":2600},700,1100,800,{"$f":"SUM(G70:I70)","v":2600},700,1100,800,{"$f":"SUM(K70:M70)","v":2600},700,1100,800,{"$f":"SUM(O70:Q70)","v":2600},10400]
[null,"PREVIOUS YEAR VARIANCE",{"$f":"C68-C70","v":-200},{"$f":"D68-D70","v":-400},{"$f":"E68-E70","v":300},{"$f":"F68-F70","v":-300},{"$f":"G68-G70","v":-200},{"$f":"H68-H70","v":-400},{"$f":"I68-I70","v":300},{"$f":"J68-J70","v":-300},{"$f":"K68-K70","v":-200},{"$f":"L68-L70","v":-400},{"$f":"M68-M70","v":300},{"$f":"N68-N70","v":-300},{"$f":"O68-O70","v":-200},{"$f":"P68-P70","v":-400},{"$f":"Q68-Q70","v":300},{"$f":"R68-R70","v":-300},-1200]
[null,"ACCOUNTS PAYABLE"]
[null,"BUDGET",1000,1000,1000,{"$f":"SUM(C73:E73)","v":3000},1000,1000,1000,{"$f":"SUM(G73:I73)","v":3000},1000,1000,1000,{"$f":"SUM(K73:M73)","v":3000},1000,1000,1000,{"$f":"SUM(O73:Q73)","v":3000},{"$f":"SUM(F73,J73,N73,R73)","v":12000}]
[null,"ACTUAL",500,700,1100,{"$f":"SUM(C74:E74)","v":2300},500,700,1100,{"$f":"SUM(G74:I74)","v":2300},500,700,1100,{"$f":"SUM(K74:M74)","v":2300},500,700,1100,{"$f":"SUM(O74:Q74)","v":2300},{"$f":"SUM(F74,J74,N74,R74)","v":9200}]
[null,"VARIANCE",{"$f":"C74-C73","v":-500},{"$f":"D74-D73","v":-300},{"$f":"E74-E73","v":100},{"$f":"F74-F73","v":-700},{"$f":"G74-G73","v":-500},{"$f":"H74-H73","v":-300},{"$f":"I74-I73","v":100},{"$f":"J74-J73","v":-700},{"$f":"K74-K73","v":-500},{"$f":"L74-L73","v":-300},{"$f":"M74-M73","v":100},{"$f":"N74-N73","v":-700},{"$f":"O74-O73","v":-500},{"$f":"P74-P73","v":-300},{"$f":"Q74-Q73","v":100},{"$f":"R74-R73","v":-700},-2800]
[null,"PREVIOUS YEAR ACTUAL",700,1100,800,{"$f":"SUM(C76:E76)","v":2600},700,1100,800,{"$f":"SUM(G76:I76)","v":2600},700,1100,800,{"$f":"SUM(K76:M76)","v":2600},700,1100,800,{"$f":"SUM(O76:Q76)","v":2600},10400]
[null,"PREVIOUS YEAR VARIANCE",{"$f":"C74-C76","v":-200},{"$f":"D74-D76","v":-400},{"$f":"E74-E76","v":300},{"$f":"F74-F76","v":-300},{"$f":"G74-G76","v":-200},{"$f":"H74-H76","v":-400},{"$f":"I74-I76","v":300},{"$f":"J74-J76","v":-300},{"$f":"K74-K76","v":-200},{"$f":"L74-L76","v":-400},{"$f":"M74-M76","v":300},{"$f":"N74-N76","v":-300},{"$f":"O74-O76","v":-200},{"$f":"P74-P76","v":-400},{"$f":"Q74-Q76","v":300},{"$f":"R74-R76","v":-300},-1200]
[null,"LONG-TERM DEBT"]
[null,"BUDGET",1000,1000,1000,{"$f":"SUM(C79:E79)","v":3000},1000,1000,1000,{"$f":"SUM(G79:I79)","v":3000},1000,1000,1000,{"$f":"SUM(K79:M79)","v":3000},1000,1000,1000,{"$f":"SUM(O79:Q79)","v":3000},{"$f":"SUM(F79,J79,N79,R79)","v":12000}]
[null,"ACTUAL",500,700,1100,{"$f":"SUM(C80:E80)","v":2300},500,700,1100,{"$f":"SUM(G80:I80)","v":2300},500,700,1100,{"$f":"SUM(K80:M80)","v":2300},500,700,1100,{"$f":"SUM(O80:Q80)","v":2300},{"$f":"SUM(F80,J80,N80,R80)","v":9200}]
[null,"VARIANCE",{"$f":"C80-C79","v":-500},{"$f":"D80-D79","v":-300},{"$f":"E80-E79","v":100},{"$f":"F80-F79","v":-700},{"$f":"G80-G79","v":-500},{"$f":"H80-H79","v":-300},{"$f":"I80-I79","v":100},{"$f":"J80-J79","v":-700},{"$f":"K80-K79","v":-500},{"$f":"L80-L79","v":-300},{"$f":"M80-M79","v":100},{"$f":"N80-N79","v":-700},{"$f":"O80-O79","v":-500},{"$f":"P80-P79","v":-300},{"$f":"Q80-Q79","v":100},{"$f":"R80-R79","v":-700},-2800]
[null,"PREVIOUS YEAR ACTUAL",700,1100,800,{"$f":"SUM(C82:E82)","v":2600},700,1100,800,{"$f":"SUM(G82:I82)","v":2600},700,1100,800,{"$f":"SUM(K82:M82)","v":2600},700,1100,800,{"$f":"SUM(O82:Q82)","v":2600},10400]
[null,"PREVIOUS YEAR VARIANCE",{"$f":"C80-C82","v":-200},{"$f":"D80-D82","v":-400},{"$f":"E80-E82","v":300},{"$f":"F80-F82","v":-300},{"$f":"G80-G82","v":-200},{"$f":"H80-H82","v":-400},{"$f":"I80-I82","v":300},{"$f":"J80-J82","v":-300},{"$f":"K80-K82","v":-200},{"$f":"L80-L82","v":-400},{"$f":"M80-M82","v":300},{"$f":"N80-N82","v":-300},{"$f":"O80-O82","v":-200},{"$f":"P80-P82","v":-400},{"$f":"Q80-Q82","v":300},{"$f":"R80-R82","v":-300},-1200]
[null,"OTHER"]
[null,"BUDGET",1000,1000,1000,{"$f":"SUM(C85:E85)","v":3000},1000,1000,1000,{"$f":"SUM(G85:I85)","v":3000},1000,1000,1000,{"$f":"SUM(K85:M85)","v":3000},1000,1000,1000,{"$f":"SUM(O85:Q85)","v":3000},{"$f":"SUM(F85,J85,N85,R85)","v":12000}]
[null,"ACTUAL",500,700,1100,{"$f":"SUM(C86:E86)","v":2300},500,700,1100,{"$f":"SUM(G86:I86)","v":2300},500,700,1100,{"$f":"SUM(K86:M86)","v":2300},500,700,1100,{"$f":"SUM(O86:Q86)","v":2300},{"$f":"SUM(F86,J86,N86,R86)","v":9200}]
[null,"VARIANCE",{"$f":"C86-C85","v":-500},{"$f":"D86-D85","v":-300},{"$f":"E86-E85","v":100},{"$f":"F86-F85","v":-700},{"$f":"G86-G85","v":-500},{"$f":"H86-H85","v":-300},{"$f":"I86-I85","v":100},{"$f":"J86-J85","v":-700},{"$f":"K86-K85","v":-500},{"$f":"L86-L85","v":-300},{"$f":"M86-M85","v":100},{"$f":"N86-N85","v":-700},{"$f":"O86-O85","v":-500},{"$f":"P86-P85","v":-300},{"$f":"Q86-Q85","v":100},{"$f":"R86-R85","v":-700},-2800]
[null,"PREVIOUS YEAR ACTUAL",700,1100,800,{"$f":"SUM(C88:E88)","v":2600},700,1100,800,{"$f":"SUM(G88:I88)","v":2600},700,1100,800,{"$f":"SUM(K88:M88)","v":2600},700,1100,800,{"$f":"SUM(O88:Q88)","v":2600},10400]
[null,"PREVIOUS YEAR VARIANCE",{"$f":"C86-C88","v":-200},{"$f":"D86-D88","v":-400},{"$f":"E86-E88","v":300},{"$f":"F86-F88","v":-300},{"$f":"G86-G88","v":-200},{"$f":"H86-H88","v":-400},{"$f":"I86-I88","v":300},{"$f":"J86-J88","v":-300},{"$f":"K86-K88","v":-200},{"$f":"L86-L88","v":-400},{"$f":"M86-M88","v":300},{"$f":"N86-N88","v":-300},{"$f":"O86-O88","v":-200},{"$f":"P86-P88","v":-400},{"$f":"Q86-Q88","v":300},{"$f":"R86-R88","v":-300},-1200]
[]
[null,null,"CLICK HERE TO CREATE BUSINESS BUDGET TEMPLATES IN SMARTSHEET"]