{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Business Budget - Goods","Business Budget - Services"],"not_rendered":{"charts":2,"images":2,"macros":0,"external_links":0,"defined_names":2,"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":"Business Budget - Goods","index":0,"n_rows":75,"n_cols":5,"rows_kept":75,"cut":false,"hidden":false,"merged":[[8,5,16,5],[20,5,33,5],[74,1,74,5],[35,5,38,5],[40,5,47,5],[49,5,53,5],[55,5,61,5],[63,5,69,5]]}
[null,"BUSINESS BUDGET"]
[]
[null,"SUMMARY","BUDGET","ACTUAL","UNDER/OVER"]
[null,"Total Income",{"$f":"C18","v":7270},{"$f":"D18","v":7020},{"$f":"C4-D4","v":250}]
[null,"Total Expenses",{"$f":"SUM(C34,C39,C48,C54+C62,C70)","v":5023},{"$f":"SUM(D34,D39,D48,D54+D62,D70)","v":5450},{"$f":"C5-D5","v":-427}]
[]
[null,null,"BUDGET","ACTUAL","UNDER/OVER"]
[null,"INCOME"]
[null,"OPERATING INCOME"]
[null,"Category 1",6000,6000,{"$f":"D10-C10","v":0}]
[null,"Category 2",200,150,{"$f":"D11-C11","v":-50}]
[null,"Category 3",100,100,0]
[null,"Category 4",55,20,-35]
[null,"Category 5",500,500,0]
[null,"Category 6",300,200,-100]
[null,"Category 7",115,50,-65]
[]
[null,"TOTAL",{"$f":"SUM(C10:C16)","v":7270},{"$f":"SUM(D10:D16)","v":7020}]
[]
[null,"EXPENSES","BUDGET","ACTUAL","UNDER/OVER"]
[null,"OPERATING EXPENSE"]
[null,"Accounting & Legal",2250,2250,{"$f":"D22-C22","v":0}]
[null,"Advertising",25,null,{"$f":"D23-C23","v":-25}]
[null,"Depreciation",40,null,-40]
[null,"Dues & Subscriptions",44,null,-44]
[null,"Insurance",20,null,-20]
[null,"Interest Expense",15,null,-15]
[null,"Maintenance/Improvements",null,null,0]
[null,"Taxes & Licenses",29,null,-29]
[null,"Telephone",null,null,0]
[null,"Travel",null,null,0]
[null,"Utilities",null,null,0]
[null,"Web Hosting & Domains"]
[null,null,{"$f":"SUM(C22:C33)","v":2423},{"$f":"SUM(D22:D33)","v":2250}]
[null,"PAYROLL"]
[null,"Payroll Expenses",2600,3200,{"$f":"D36-C36","v":600}]
[null,"Salaries & Wages",null,null,0]
[null,"Contractor Wages",null,null,0]
[null,null,{"$f":"SUM(C36:C38)","v":2600},{"$f":"SUM(D36:D38)","v":3200}]
[null,"OFFICE"]
[null,"Office Supplies",null,null,{"$f":"D41-C41","v":0}]
[null,"Space Rental",null,null,{"$f":"D42-C42","v":0}]
[null,"Décor",null,null,0]
[null,"Machine Rental",null,null,0]
[null,"Equipment",null,null,{"$f":"D45-C45","v":0}]
[null,"Postage",null,null,0]
[null,"Other",null,null,0]
[null,null,{"$f":"SUM(C41:C47)","v":0},{"$f":"SUM(D41:D47)","v":0}]
[null,"ENTERTAINMENT"]
[null,"Video/DVD/Movies",null,null,{"$f":"D50-C50","v":0}]
[null,"Concerts/Plays",null,null,{"$f":"D51-C51","v":0}]
[null,"Sports",null,null,{"$f":"D52-C52","v":0}]
[null,"Outdoor Recreation",null,null,{"$f":"D53-C53","v":0}]
[null,null,{"$f":"SUM(C50:C53)","v":0}]
[null,"HEALTH"]
[null,"Health Insurance",null,null,{"$f":"D56-C56","v":0}]
[null,"Gym Membership",null,null,0]
[null,"Doctors/Dentist Visits",null,null,0]
[null,"Medicine/Prescriptions",null,null,0]
[null,"Veterinarian",null,null,0]
[null,"Life Insurance",null,null,0]
[null,null,{"$f":"SUM(C56:C61)","v":0},{"$f":"SUM(D56:D61)","v":0}]
[null,"VACATION/HOLIDAY"]
[null,"Airfare",null,null,{"$f":"D64-C64","v":0}]
[null,"Accommodations",null,null,0]
[null,"Food",null,null,0]
[null,"Souvenirs",null,null,0]
[null,"Pet Boarding",null,null,0]
[null,"Rental Car",null,null,0]
[null,null,{"$f":"SUM(C64:C69)","v":0},{"$f":"SUM(D64:D69)","v":0}]
[]
[null,"TOTAL",{"$f":"C70+C62+C54+C48+C39+C34","v":5023},{"$f":"D70+D62+D54+D48+D39+D34","v":5450}]
[]
[]
[null,"CLICK HERE TO CREATE BUSINESS BUDGET TEMPLATES IN SMARTSHEET"]

{"sheet":"Business Budget - Services","index":1,"n_rows":32,"n_cols":10,"rows_kept":32,"cut":false,"hidden":false,"merged":[[5,2,5,3],[5,4,5,5],[7,10,19,10],[31,1,31,10],[5,6,6,6]]}
[null,"BUSINESS BUDGET"]
[]
[null,null,null,null,null,null,null,"BUDGET","ACTUAL","UNDER/OVER"]
[null,null,null,null,null,null,null,{"$f":"H30","v":850},{"$f":"I30","v":800},{"$f":"H4-I4","v":50}]
[]
[null,null,"LABOR",null,"MATERIALS",null,"FIXED COST","BUDGET","ACTUAL","UNDER/OVER"]
[null,"TASK","HRS","RATE","UNITS","$/UNIT"]
[null,"CATEGORY"]
[null,"Task",10,15,50,10,200,{"$f":"C9*D9+E9*F9+G9","v":850},800,{"$f":"I9-H9","v":-50}]
[null,"Task",null,null,null,null,null,{"$f":"C10*D10+E10*F10+G10","v":0},null,{"$f":"I10-H10","v":0}]
[null,"Task",null,null,null,null,null,0,null,{"$f":"I11-H11","v":0}]
[null,"Task",null,null,null,null,null,0,null,{"$f":"I12-H12","v":0}]
[null,"Task",null,null,null,null,null,0,null,{"$f":"I13-H13","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(H9:H13)","v":850},{"$f":"SUM(I9:I13)","v":800}]
[null,"CATEGORY"]
[null,"Task",null,null,null,null,null,{"$f":"C16*D16+E16*F16+G16","v":0},null,{"$f":"I16-H16","v":0}]
[null,"Task",null,null,null,null,null,{"$f":"C17*D17+E17*F17+G17","v":0},null,{"$f":"I17-H17","v":0}]
[null,"Task",null,null,null,null,null,0,null,{"$f":"I18-H18","v":0}]
[null,"Task",null,null,null,null,null,0,null,{"$f":"I19-H19","v":0}]
[null,"Task",null,null,null,null,null,{"$f":"C20*D20+E20*F20+G20","v":0},null,{"$f":"I20-H20","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(H16:H20)","v":0},{"$f":"SUM(I16:I20)","v":0}]
[null,"CATEGORY"]
[null,"Task",null,null,null,null,null,{"$f":"C23*D23+E23*F23+G23","v":0},null,{"$f":"I23-H23","v":0}]
[null,"Task",null,null,null,null,null,{"$f":"C24*D24+E24*F24+G24","v":0},null,{"$f":"I24-H24","v":0}]
[null,"Task",null,null,null,null,null,0,null,{"$f":"I25-H25","v":0}]
[null,"Task",null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,{"$f":"SUM(H24:H26)","v":0},{"$f":"SUM(I24:I26)","v":0}]
[]
[null,"TOTAL",null,null,null,null,null,{"$f":"SUM(H14,H21,H28)","v":850},{"$f":"SUM(I14,I21,I28)","v":800}]
[]
[null,"CLICK HERE TO CREATE BUSINESS BUDGET TEMPLATES IN SMARTSHEET"]