{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Simple Cash Flow Template"],"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":"Simple Cash Flow Template","index":0,"n_rows":81,"n_cols":7,"rows_kept":81,"cut":false,"hidden":false,"merged":[[80,1,80,7],[76,2,76,3],[76,4,76,5],[76,6,76,7],[78,2,78,3],[78,4,78,5],[78,6,78,7],[40,2,40,3],[40,4,40,5],[40,6,40,7],[57,2,57,3],[57,4,57,5],[57,6,57,7],[58,2,58,3],[58,4,58,5],[58,6,58,7],[71,2,71,3],[71,4,71,5],[71,6,71,7],[74,2,74,3],[74,4,74,5],[74,6,74,7],[41,2,41,3],[41,4,41,5],[41,6,41,7],[72,2,72,3],[72,4,72,5],[72,6,72,7],[69,2,69,3],[69,4,69,5],[69,6,69,7],[70,2,70,3],[70,4,70,5],[70,6,70,7],[67,2,67,3],[67,4,67,5],[67,6,67,7],[68,2,68,3],[68,4,68,5],[68,6,68,7],[47,2,47,3],[47,4,47,5],[47,6,47,7],[64,1,64,7],[65,2,65,3],[65,4,65,5],[65,6,65,7],[66,2,66,3],[66,4,66,5],[66,6,66,7],[43,4,43,5],[43,6,43,7],[44,2,44,3],[44,4,44,5],[44,6,44,7],[45,2,45,3],[45,4,45,5],[45,6,45,7],[46,2,46,3],[46,4,46,5],[46,6,46,7],[61,2,61,3],[61,4,61,5],[61,6,61,7],[62,2,62,3],[62,4,62,5],[62,6,62,7],[48,2,48,3],[48,4,48,5],[48,6,48,7],[49,2,49,3],[49,4,49,5],[34,2,34,3],[34,4,34,5],[34,6,34,7],[35,2,35,3],[35,4,35,5],[35,6,35,7],[36,2,36,3],[36,4,36,5],[36,6,36,7],[49,6,49,7],[50,2,50,3],[50,4,50,5],[50,6,50,7],[56,2,56,3],[56,4,56,5],[56,6,56,7],[59,2,59,3],[59,4,59,5],[59,6,59,7],[60,2,60,3],[60,4,60,5],[60,6,60,7],[53,2,53,3],[53,4,53,5],[53,6,53,7],[54,2,54,3],[54,4,54,5],[54,6,54,7],[55,2,55,3],[55,4,55,5],[55,6,55,7],[31,2,31,3],[31,4,31,5],[31,6,31,7],[23,1,23,7],[33,1,33,7],[51,2,51,3],[51,4,51,5],[51,6,51,7],[52,2,52,3],[52,4,52,5],[52,6,52,7],[37,2,37,3],[37,4,37,5],[37,6,37,7],[38,2,38,3],[38,4,38,5],[38,6,38,7],[39,2,39,3],[39,4,39,5],[39,6,39,7],[42,2,42,3],[42,4,42,5],[42,6,42,7],[43,2,43,3],[28,2,28,3],[28,4,28,5],[28,6,28,7],[29,2,29,3],[29,4,29,5],[29,6,29,7],[30,2,30,3],[30,4,30,5],[30,6,30,7],[27,2,27,3],[27,4,27,5],[27,6,27,7],[22,1,22,7],[24,2,24,3],[24,4,24,5],[24,6,24,7],[25,2,25,3],[25,4,25,5],[25,6,25,7],[26,2,26,3],[26,4,26,5],[26,6,26,7],[16,2,16,3],[16,4,16,5],[16,6,16,7],[17,2,17,3],[17,4,17,5],[17,6,17,7],[18,2,18,3],[18,4,18,5],[18,6,18,7],[0,1,0,4],[1,6,1,7],[1,2,1,3],[1,4,1,5],[2,2,2,3],[2,4,2,5],[2,6,2,7],[10,1,10,7],[20,2,20,3],[20,4,20,5],[20,6,20,7],[11,2,11,3],[11,4,11,5],[11,6,11,7],[19,2,19,3],[19,4,19,5],[19,6,19,7],[12,2,12,3],[12,4,12,5],[12,6,12,7],[13,2,13,3],[13,4,13,5],[13,6,13,7],[14,2,14,3],[14,4,14,5],[14,6,14,7],[15,2,15,3],[15,4,15,5],[15,6,15,7],[8,2,8,3],[8,4,8,5],[8,6,8,7],[4,4,4,5],[4,2,4,3],[4,6,6,7]]}
[null,"SIMPLE CASH FLOW TEMPLATE"]
[null,"COMPANY NAME","MANAGER NAME",null,"COMPLETED BY",null,"DATE COMPLETED"]
[]
[]
[null,null,"CURRENT PERIOD",null,"PREVIOUS PERIOD",null,"INCREASE (or DECREASE)"]
[null,null,"BEGIN","END","BEGIN","END"]
[]
[]
[null,"BEGINNING BALANCE | CASH ON HAND",0,null,0,null,{"$f":"+C9-E9","v":0}]
[]
[null,"( + )  CASH RECEIPTS"]
[null,"CASH SALES",0,null,0,null,{"$f":"+C12-E12","v":0}]
[null,"CUSTOMER ACCOUNT COLLECTIONS",0,null,0,null,{"$f":"+C13-E13","v":0}]
[null,"LOAN / CASH INJECTION",0,null,0,null,0]
[null,"INTEREST INCOME",0,null,0,null,0]
[null,"TAX REFUND",0,null,0,null,0]
[null,"OTHER CASH RECEIPTS",0,null,0,null,0]
[null,"OTHER",0,null,0,null,0]
[null,"OTHER",0,null,0,null,0]
[null,"OTHER",0,null,0,null,0]
[null,"TOTAL CASH RECEIPTS",{"$f":"SUM(C12:D20)","v":0},null,{"$f":"SUM(E12:F20)","v":0},null,{"$f":"+C21-E21","v":0}]
[]
[null,"( – )  CASH PAYMENTS"]
[null,"( – )  COST OF GOODS SOLD"]
[null,"DIRECT PRODUCT / SERVICE COSTS",0,null,0,null,{"$f":"+C25-E25","v":0}]
[null,"PAYROLL TAXES / BENEFITS - DIRECT",0,null,0,null,{"$f":"+C26-E26","v":0}]
[null,"SALARIES - DIRECT",0,null,0,null,0]
[null,"SUPPLIES",0,null,0,null,0]
[null,"OTHER",0,null,0,null,0]
[null,"OTHER",0,null,0,null,0]
[null,"OTHER",0,null,0,null,0]
[null,"TOTAL COST OF GOODS SOLD",{"$f":"SUM(C25:D31)","v":0},null,{"$f":"SUM(E25:F31)","v":0},null,{"$f":"+C32-E32","v":0}]
[]
[null,"( – )  OPERATING EXPENSES"]
[null,"ACCOUNT FEES",0,null,0,null,{"$f":"+C35-E35","v":0}]
[null,"ADVERTISING",0,null,0,null,{"$f":"+C36-E36","v":0}]
[null,"BANK FEES",0,null,0,null,0]
[null,"CONTINUING EDUCATION",0,null,0,null,{"$f":"+C38-E38","v":0}]
[null,"DUES / SUBSCRIPTIONS",0,null,0,null,0]
[null,"INSURANCE",0,null,0,null,0]
[null,"INTERNET",0,null,0,null,{"$f":"+C41-E41","v":0}]
[null,"LICENSES / PERMITS",0,null,0,null,{"$f":"+C42-E42","v":0}]
[null,"MEALS / ENTERTAINMENT",0,null,0,null,{"$f":"+C43-E43","v":0}]
[null,"OFFICE SUPPLIES",0,null,0,null,{"$f":"+C44-E44","v":0}]
[null,"PAYROLL PROCESSING",0,null,0,null,0]
[null,"PAYROLL TAXES / BENEFITS - INDIRECT",0,null,0,null,0]
[null,"POSTAGE / SHIPPING",0,null,0,null,0]
[null,"PRINTING",0,null,0,null,0]
[null,"PROFESSIONAL SVCS",0,null,0,null,0]
[null,"OCCUPANCY",0,null,0,null,0]
[null,"RENTAL FEES",0,null,0,null,0]
[null,"SALARIES - INDIRECT",0,null,0,null,{"$f":"+C52-E52","v":0}]
[null,"SUBCONTRACTORS",0,null,0,null,{"$f":"+C53-E53","v":0}]
[null,"TELEPHONE",0,null,0,null,0]
[null,"TRANSPORTATION",0,null,0,null,0]
[null,"TRAVEL",0,null,0,null,0]
[null,"UTILITIES",0,null,0,null,0]
[null,"WEB DEVELOPMENT",0,null,0,null,{"$f":"+C58-E58","v":0}]
[null,"WEB DOMAIN AND HOSTING",0,null,0,null,0]
[null,"OTHER",0,null,0,null,0]
[null,"OTHER",0,null,0,null,0]
[null,"OTHER",0,null,0,null,0]
[null,"TOTAL OPERATING EXPENSES",{"$f":"SUM(C35:D62)","v":0},null,{"$f":"SUM(E35:F62)","v":0},null,{"$f":"+C63-E63","v":0}]
[]
[null,"( – )  ADDITIONAL EXPENSES"]
[null,"CASH DISBURSEMENTS TO OWNERS",0,null,0,null,{"$f":"+C66-E66","v":0}]
[null,"CHARITABLE CONTRIBUTIONS",0,null,0,null,{"$f":"+C67-E67","v":0}]
[null,"INTEREST EXPENSE",0,null,0,null,0]
[null,"INCOME TAX EXPENSE",0,null,0,null,0]
[null,"OTHER",0,null,0,null,0]
[null,"OTHER",0,null,0,null,0]
[null,"OTHER",0,null,0,null,0]
[null,"TOTAL ADDITIONAL EXPENSES",{"$f":"SUM(C66:D72)","v":0},null,{"$f":"SUM(E66:F72)","v":0},null,{"$f":"+C73-E73","v":0}]
[]
[null,"TOTAL CASH PAYMENTS",{"$f":"SUM(C32,C63,C73)","v":0},null,{"$f":"SUM(E32,E63,E73)","v":0},null,{"$f":"+C75-E75","v":0}]
[]
[null,"NET CASH CHANGE\n ( CASH RECEIPTS – CASH PAYMENTS )",{"$f":"C21-C75","v":0},null,{"$f":"E21-E75","v":0},null,{"$f":"+C77-E77","v":0}]
[]
[null,"MONTH ENDING CASH POSITION\n ( CASH ON HAND + CASH RECEIPTS – CASH PAYMENTS )",{"$f":"SUM(C9,C21)-C75","v":0},null,{"$f":"SUM(E9,E21)-E75","v":0},null,{"$f":"+C79-E79","v":0}]
[]
[null,"CLICK HERE TO CREATE SIMPLE CASH FLOW TEMPLATES IN SMARTSHEET"]