{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Daily Cash Flow"],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":0,"defined_names":1,"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":"Daily Cash Flow","index":0,"n_rows":79,"n_cols":34,"rows_kept":79,"cut":false,"hidden":false,"merged":[[0,1,0,17],[1,6,2,8],[62,1,62,33],[8,1,8,33],[20,1,20,33],[21,1,21,33],[31,1,31,33],[78,1,78,8]]}
[null,"DAILY CASH FLOW TEMPLATE"]
[null,"COMPANY NAME","MANAGER NAME","COMPLETED BY","DATES REPRESENTED","DATE OF LAST UPDATE"]
[]
[]
[null,"Enter date of first day of month","2018-10-01",{"$f":"DATE(YEAR(C5), MONTH(C5), DAY(C5)+1)","v":"2018-10-02"},{"$f":"DATE(YEAR(D5), MONTH(D5), DAY(D5)+1)","v":"2018-10-03"},"2018-10-04","2018-10-05","2018-10-06","2018-10-07","2018-10-08","2018-10-09","2018-10-10","2018-10-11","2018-10-12","2018-10-13","2018-10-14","2018-10-15","2018-10-16","2018-10-17","2018-10-18","2018-10-19","2018-10-20","2018-10-21","2018-10-22","2018-10-23","2018-10-24","2018-10-25","2018-10-26","2018-10-27","2018-10-28","2018-10-29","2018-10-30","2018-10-31"]
[]
[null,"BEGINNING BALANCE | CASH ON HAND",0,{"$f":"C77","v":0},{"$f":"D77","v":0},{"$f":"E77","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AF77","v":0},{"$f":"C7","v":0}]
[]
[null,"( + )  CASH RECEIPTS"]
[null,"CASH SALES",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C10:AG10)","v":0}]
[null,"CUSTOMER ACCOUNT COLLECTIONS",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C11:AG11)","v":0}]
[null,"LOAN / CASH INJECTION",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"INTEREST INCOME",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"TAX REFUND",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"OTHER CASH RECEIPTS",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"OTHER",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C16:AG16)","v":0}]
[null,"OTHER",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"OTHER",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"TOTAL CASH RECEIPTS",{"$f":"SUM(C10:C18)","v":0},{"$f":"SUM(D10:D18)","v":0},{"$f":"SUM(E10:E18)","v":0},{"$f":"SUM(F10:F18)","v":0},0,{"$f":"SUM(H10:H18)","v":0},0,{"$f":"SUM(J10:J18)","v":0},0,{"$f":"SUM(L10:L18)","v":0},0,0,0,0,0,{"$f":"SUM(R10:R18)","v":0},{"$f":"SUM(S10:S18)","v":0},{"$f":"SUM(T10:T18)","v":0},{"$f":"SUM(U10:U18)","v":0},{"$f":"SUM(V10:V18)","v":0},{"$f":"SUM(W10:W18)","v":0},{"$f":"SUM(X10:X18)","v":0},{"$f":"SUM(Y10:Y18)","v":0},{"$f":"SUM(Z10:Z18)","v":0},{"$f":"SUM(AA10:AA18)","v":0},{"$f":"SUM(AB10:AB18)","v":0},{"$f":"SUM(AC10:AC18)","v":0},{"$f":"SUM(AD10:AD18)","v":0},{"$f":"SUM(AE10:AE18)","v":0},{"$f":"SUM(AF10:AF18)","v":0},{"$f":"SUM(AG10:AG18)","v":0},{"$f":"SUM(AH10:AH18)","v":0}]
[]
[null,"( – )  CASH PAYMENTS"]
[null,"( – )  COST OF GOODS SOLD"]
[null,"DIRECT PRODUCT / SERVICE COSTS",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C23:AG23)","v":0}]
[null,"PAYROLL TAXES / BENEFITS - DIRECT",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"SALARIES - DIRECT",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"SUPPLIES",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"OTHER",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"OTHER",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"OTHER",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"TOTAL COST OF GOODS SOLD",{"$f":"SUM(C23:C29)","v":0},{"$f":"SUM(D23:D29)","v":0},{"$f":"SUM(E23:E29)","v":0},{"$f":"SUM(F23:F29)","v":0},{"$f":"SUM(G23:G29)","v":0},0,0,0,0,0,0,{"$f":"SUM(N23:N29)","v":0},0,0,0,0,0,{"$f":"SUM(T23:T29)","v":0},{"$f":"SUM(U23:U29)","v":0},{"$f":"SUM(V23:V29)","v":0},{"$f":"SUM(W23:W29)","v":0},{"$f":"SUM(X23:X29)","v":0},{"$f":"SUM(Y23:Y29)","v":0},{"$f":"SUM(Z23:Z29)","v":0},{"$f":"SUM(AA23:AA29)","v":0},{"$f":"SUM(AB23:AB29)","v":0},0,0,0,0,0,0]
[]
[null,"( – )  OPERATING EXPENSES"]
[null,"ACCOUNT FEES",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C33:AG33)","v":0}]
[null,"ADVERTISING",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C34:AG34)","v":0}]
[null,"BANK FEES",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"CONTINUING EDUCATION",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"DUES / SUBSCRIPTIONS",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"INSURANCE",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"INTERNET",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"LICENSES / PERMITS",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"MEALS / ENTERTAINMENT",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"OFFICE SUPPLIES",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"PAYROLL PROCESSING",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"PAYROLL TAXES / BENEFITS - INDIRECT",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"POSTAGE / SHIPPING",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"PRINTING",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"PROFESSIONAL SERVICES",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"OCCUPANCY",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"RENTAL FEES",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"SALARIES - INDIRECT",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"SUBCONTRACTORS",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"TELEPHONE",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"TRANSPORTATION",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"TRAVEL",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"UTILITIES",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"WEB DEVELOPMENT",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"WEB DOMAIN AND HOSTING",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"OTHER",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"OTHER",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"OTHER",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"TOTAL OPERATING EXPENSES",{"$f":"SUM(C33:C60)","v":0},{"$f":"SUM(D33:D60)","v":0},{"$f":"SUM(E33:E60)","v":0},{"$f":"SUM(F33:F60)","v":0},0,{"$f":"SUM(H33:H60)","v":0},0,0,0,0,0,{"$f":"SUM(N33:N60)","v":0},0,0,0,0,0,{"$f":"SUM(T33:T60)","v":0},{"$f":"SUM(U33:U60)","v":0},{"$f":"SUM(V33:V60)","v":0},{"$f":"SUM(W33:W60)","v":0},{"$f":"SUM(X33:X60)","v":0},{"$f":"SUM(Y33:Y60)","v":0},{"$f":"SUM(Z33:Z60)","v":0},{"$f":"SUM(AA33:AA60)","v":0},{"$f":"SUM(AB33:AB60)","v":0},0,0,0,0,0,0]
[]
[null,"( – )  ADDITIONAL EXPENSES"]
[null,"CASH DISBURSEMENTS TO OWNERS",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C64:AG64)","v":0}]
[null,"CHARITABLE CONTRIBUTIONS",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"INTEREST EXPENSE",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"INCOME TAX EXPENSE",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"OTHER",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"OTHER",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"OTHER",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"TOTAL ADDITIONAL EXPENSES",{"$f":"SUM(C64:C70)","v":0},{"$f":"SUM(D64:D70)","v":0},{"$f":"SUM(E64:E70)","v":0},{"$f":"SUM(F64:F70)","v":0},0,0,{"$f":"SUM(I64:I70)","v":0},0,0,0,{"$f":"SUM(M64:M70)","v":0},{"$f":"SUM(N64:N70)","v":0},0,0,{"$f":"SUM(Q64:Q70)","v":0},{"$f":"SUM(R64:R70)","v":0},{"$f":"SUM(S64:S70)","v":0},{"$f":"SUM(T64:T70)","v":0},{"$f":"SUM(U64:U70)","v":0},{"$f":"SUM(V64:V70)","v":0},{"$f":"SUM(W64:W70)","v":0},{"$f":"SUM(X64:X70)","v":0},{"$f":"SUM(Y64:Y70)","v":0},{"$f":"SUM(Z64:Z70)","v":0},{"$f":"SUM(AA64:AA70)","v":0},{"$f":"SUM(AB64:AB70)","v":0},{"$f":"SUM(AC64:AC70)","v":0},{"$f":"SUM(AD64:AD70)","v":0},{"$f":"SUM(AE64:AE70)","v":0},{"$f":"SUM(AF64:AF70)","v":0},{"$f":"SUM(AG64:AG70)","v":0},{"$f":"SUM(AH64:AH70)","v":0}]
[]
[null,"TOTAL CASH PAYMENTS",{"$f":"SUM(C30,C61,C71)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(AH30,AH61,AH71)","v":0}]
[]
[null,"NET CASH CHANGE\n (CASH RECEIPTS – CASH PAYMENTS)",{"$f":"C19-C73","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AH19-AH73","v":0}]
[]
[null,"MONTH ENDING CASH POSITION\n (CASH ON HAND + CASH RECEIPTS – CASH PAYMENTS)",{"$f":"SUM(C7,C19)-C73","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(AH7,AH19)-AH73","v":0}]
[]
[null,"CLICK HERE TO CREATE DAILY CASH FLOW TEMPLATES IN SMARTSHEET"]