{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Quarterly Cash Flow Projections"],"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":"Quarterly Cash Flow Projections","index":0,"n_rows":77,"n_cols":11,"rows_kept":77,"cut":false,"hidden":false,"merged":[[76,1,76,10],[1,8,1,10],[60,1,60,4],[19,1,19,4],[29,1,29,4],[18,1,18,4],[6,1,6,4],[1,2,1,4],[1,5,1,7]]}
[null,"QUARTERLY CASH FLOW PROJECTIONS TEMPLATE"]
[null,"COMPANY NAME","JANUARY",null,null,"FEBRUARY",null,null,"MARCH"]
[null,"DATES REPRESENTED","ESTIMATE","ACTUAL","VARIANCE","ESTIMATE","ACTUAL","VARIANCE","ESTIMATE","ACTUAL","VARIANCE"]
[]
[null,"BEGINNING BALANCE | CASH ON HAND",0,0,{"$f":"+C5-D5","v":0},0,0,{"$f":"+F5-G5","v":0},0,0,{"$f":"+I5-J5","v":0}]
[]
[null,"( + )  CASH RECEIPTS"]
[null,"CASH SALES",0,0,{"$f":"+C8-D8","v":0},0,0,{"$f":"+F8-G8","v":0},0,0,{"$f":"+I8-J8","v":0}]
[null,"CUSTOMER ACCOUNT COLLECTIONS",0,0,0,0,0,0,0,0,0]
[null,"LOAN / CASH INJECTION",0,0,0,0,0,0,0,0,0]
[null,"INTEREST INCOME",0,0,0,0,0,0,0,0,0]
[null,"TAX REFUND",0,0,0,0,0,0,0,0,0]
[null,"OTHER CASH RECEIPTS",0,0,0,0,0,0,0,0,0]
[null,"OTHER",0,0,0,0,0,0,0,0,0]
[null,"OTHER",0,0,0,0,0,0,0,0,0]
[null,"OTHER",0,0,0,0,0,0,0,0,0]
[null,"TOTAL CASH RECEIPTS",{"$f":"SUM(C8:C16)","v":0},{"$f":"SUM(D8:D16)","v":0},0,{"$f":"SUM(F8:F16)","v":0},{"$f":"SUM(G8:G16)","v":0},0,{"$f":"SUM(I8:I16)","v":0},{"$f":"SUM(J8:J16)","v":0},0]
[]
[null,"( – )  CASH PAYMENTS"]
[null,"( – )  COST OF GOODS SOLD"]
[null,"DIRECT PRODUCT / SERVICE COSTS",0,0,{"$f":"+C21-D21","v":0},0,0,{"$f":"+F21-G21","v":0},0,0,{"$f":"+I21-J21","v":0}]
[null,"PAYROLL TAXES / BENEFITS - DIRECT",0,0,0,0,0,0,0,0,0]
[null,"SALARIES - DIRECT",0,0,0,0,0,0,0,0,0]
[null,"SUPPLIES",0,0,0,0,0,0,0,0,0]
[null,"OTHER",0,0,0,0,0,0,0,0,0]
[null,"OTHER",0,0,0,0,0,0,0,0,0]
[null,"OTHER",0,0,0,0,0,0,0,0,0]
[null,"TOTAL COST OF GOODS SOLD",{"$f":"SUM(C21:C27)","v":0},{"$f":"SUM(D21:D27)","v":0},0,{"$f":"SUM(F21:F27)","v":0},{"$f":"SUM(G21:G27)","v":0},0,{"$f":"SUM(I21:I27)","v":0},{"$f":"SUM(J21:J27)","v":0},0]
[]
[null,"( – )  OPERATING EXPENSES"]
[null,"ACCOUNT FEES",0,0,{"$f":"+C31-D31","v":0},0,0,{"$f":"+F31-G31","v":0},0,0,{"$f":"+I31-J31","v":0}]
[null,"ADVERTISING",0,0,0,0,0,0,0,0,0]
[null,"BANK FEES",0,0,0,0,0,0,0,0,0]
[null,"CONTINUING EDUCATION",0,0,0,0,0,0,0,0,0]
[null,"DUES / SUBSCRIPTIONS",0,0,0,0,0,0,0,0,0]
[null,"INSURANCE",0,0,0,0,0,0,0,0,0]
[null,"INTERNET",0,0,0,0,0,0,0,0,0]
[null,"LICENSES / PERMITS",0,0,0,0,0,0,0,0,0]
[null,"MEALS / ENTERTAINMENT",0,0,0,0,0,0,0,0,0]
[null,"OFFICE SUPPLIES",0,0,0,0,0,0,0,0,0]
[null,"PAYROLL PROCESSING",0,0,0,0,0,0,0,0,0]
[null,"PAYROLL TAXES / BENEFITS - INDIRECT",0,0,0,0,0,0,0,0,0]
[null,"POSTAGE / SHIPPING",0,0,0,0,0,0,0,0,0]
[null,"PRINTING",0,0,0,0,0,0,0,0,0]
[null,"PROFESSIONAL SERVICES",0,0,0,0,0,0,0,0,0]
[null,"OCCUPANCY",0,0,0,0,0,0,0,0,0]
[null,"RENTAL FEES",0,0,0,0,0,0,0,0,0]
[null,"SALARIES - INDIRECT",0,0,0,0,0,0,0,0,0]
[null,"SUBCONTRACTORS",0,0,0,0,0,0,0,0,0]
[null,"TELEPHONE",0,0,0,0,0,0,0,0,0]
[null,"TRANSPORTATION",0,0,0,0,0,0,0,0,0]
[null,"TRAVEL",0,0,0,0,0,0,0,0,0]
[null,"UTILITIES",0,0,0,0,0,0,0,0,0]
[null,"WEB DEVELOPMENT",0,0,0,0,0,0,0,0,0]
[null,"WEB DOMAIN AND HOSTING",0,0,0,0,0,0,0,0,0]
[null,"OTHER",0,0,0,0,0,0,0,0,0]
[null,"OTHER",0,0,0,0,0,0,0,0,0]
[null,"OTHER",0,0,0,0,0,0,0,0,0]
[null,"TOTAL OPERATING EXPENSES",{"$f":"SUM(C31:C58)","v":0},{"$f":"SUM(D31:D58)","v":0},0,{"$f":"SUM(F31:F58)","v":0},{"$f":"SUM(G31:G58)","v":0},0,{"$f":"SUM(I31:I58)","v":0},{"$f":"SUM(J31:J58)","v":0},0]
[]
[null,"( – )  ADDITIONAL EXPENSES"]
[null,"CASH DISBURSEMENTS TO OWNERS",0,0,{"$f":"+C62-D62","v":0},0,0,{"$f":"+F62-G62","v":0},0,0,{"$f":"+I62-J62","v":0}]
[null,"CHARITABLE CONTRIBUTIONS",0,0,0,0,0,0,0,0,0]
[null,"INTEREST EXPENSE",0,0,0,0,0,0,0,0,0]
[null,"INCOME TAX EXPENSE",0,0,0,0,0,0,0,0,0]
[null,"OTHER",0,0,0,0,0,0,0,0,0]
[null,"OTHER",0,0,0,0,0,0,0,0,0]
[null,"OTHER",0,0,0,0,0,0,0,0,0]
[null,"TOTAL ADDITIONAL EXPENSES",{"$f":"SUM(C60:C66)","v":0},{"$f":"SUM(D60:D66)","v":0},0,{"$f":"SUM(F60:F66)","v":0},{"$f":"SUM(G60:G66)","v":0},0,{"$f":"SUM(I60:I66)","v":0},{"$f":"SUM(J60:J66)","v":0},0]
[]
[null,"TOTAL CASH PAYMENTS",{"$f":"SUM(C28,C59,C69)","v":0},{"$f":"SUM(D28,D59,D69)","v":0},{"$f":"+C71-D71","v":0},{"$f":"SUM(F28,F59,F69)","v":0},{"$f":"SUM(G28,G59,G69)","v":0},{"$f":"+F71-G71","v":0},{"$f":"SUM(I28,I59,I69)","v":0},{"$f":"SUM(J28,J59,J69)","v":0},{"$f":"+I71-J71","v":0}]
[]
[null,"NET CASH CHANGE\n (CASH RECEIPTS – CASH PAYMENTS)",{"$f":"C17-C71","v":0},{"$f":"D17-D71","v":0},{"$f":"+C73-D73","v":0},{"$f":"F17-F71","v":0},{"$f":"G17-G71","v":0},{"$f":"+F73-G73","v":0},{"$f":"I17-I71","v":0},{"$f":"J17-J71","v":0},{"$f":"+I73-J73","v":0}]
[]
[null,"MONTH ENDING CASH POSITION\n (CASH ON HAND + CASH RECEIPTS – CASH PAYMENTS)",{"$f":"SUM(C5,C17)-C71","v":0},{"$f":"SUM(D5,D17)-D71","v":0},{"$f":"+C75-D75","v":0},{"$f":"SUM(F5,F17)-F71","v":0},{"$f":"SUM(G5,G17)-G71","v":0},{"$f":"+F75-G75","v":0},{"$f":"SUM(I5,I17)-I71","v":0},{"$f":"SUM(J5,J17)-J71","v":0},{"$f":"+I75-J75","v":0}]
[]
[null,"CLICK HERE TO CREATE QUATERLY CASH FLOW PROJECTIONS TEMPLATES IN SMARTSHEET"]