{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Nonprofit Cash Flow Projection"],"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":"Nonprofit Cash Flow Projection","index":0,"n_rows":122,"n_cols":19,"rows_kept":122,"cut":false,"hidden":false,"merged":[[103,1,103,18],[62,1,62,18],[72,1,72,18],[61,1,61,18],[8,1,8,18],[9,1,9,18],[31,1,31,18],[40,1,40,18],[52,1,52,18],[121,3,122,12]]}
[null,"NON-PROFIT CASH FLOW PROJECTION TEMPLATE"]
[null,"COMPANY NAME","MANAGER NAME","COMPLETED BY","DATES REPRESENTED","DATE OF LAST UPDATE"]
[]
[]
[null,null,"MONTH 1","MONTH 2","MONTH 3","QUARTER 1 TOTALS","MONTH 4","MONTH 5","MONTH 6","QUARTER 2 TOTALS","MONTH 7","MONTH 8","MONTH 9","QUARTER 3 TOTALS","MONTH 10","MONTH 11","MONTH 12","QUARTER 4 TOTALS","FISCAL YEAR TOTALS"]
[]
[null,"BEGINNING BALANCE | CASH ON HAND",0,{"$f":"C119","v":0},{"$f":"D119","v":0},{"$f":"SUM(C7:E7)","v":0},{"$f":"E119","v":0},{"$f":"G119","v":0},{"$f":"H119","v":0},{"$f":"SUM(G7:I7)","v":0},{"$f":"I119","v":0},{"$f":"K119","v":0},{"$f":"L119","v":0},{"$f":"SUM(K7:M7)","v":0},{"$f":"M119","v":0},{"$f":"O119","v":0},{"$f":"P119","v":0},{"$f":"SUM(O7:Q7)","v":0},{"$f":"SUM(F7,J7,N7,R7)","v":0}]
[]
[null,"( + )  CASH RECEIPTS"]
[null,"( + )  CONTRIBUTIONS AND SUPPORT"]
[null,"FOUNDATION GRANT 1",0,0,0,{"$f":"SUM(C11:E11)","v":0},0,0,0,{"$f":"SUM(G11:I11)","v":0},0,0,0,{"$f":"SUM(K11:M11)","v":0},0,0,0,{"$f":"SUM(O11:Q11)","v":0},{"$f":"SUM(F11,J11,N11,R11)","v":0}]
[null,"FOUNDATION GRANT 2",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"FOUNDATION GRANT 3",0,0,0,{"$f":"SUM(C13:E13)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"FOUNDATION GRANT 4",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"FOUNDATION GRANT 5",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"FOUNDATION GRANT 6",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"FOUNDATION GRANT 7",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"CORPORATE CONTRIBUTION 1",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"CORPORATE CONTRIBUTION 2",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"CORPORATE CONTRIBUTION 3",0,0,0,{"$f":"SUM(C20:E20)","v":0},0,0,0,{"$f":"SUM(G20:I20)","v":0},0,0,0,{"$f":"SUM(K20:M20)","v":0},0,0,0,{"$f":"SUM(O20:Q20)","v":0},{"$f":"SUM(F20,J20,N20,R20)","v":0}]
[null,"CORPORATE CONTRIBUTION 4",0,0,0,{"$f":"SUM(C21:E21)","v":0},0,0,0,{"$f":"SUM(G21:I21)","v":0},0,0,0,{"$f":"SUM(K21:M21)","v":0},0,0,0,{"$f":"SUM(O21:Q21)","v":0},{"$f":"SUM(F21,J21,N21,R21)","v":0}]
[null,"CORPORATE CONTRIBUTION 5",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"CORPORATE CONTRIBUTION 6",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"CORPORATE CONTRIBUTION 7",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"INDIVIDUAL CONTRIBUTOR 1",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"INDIVIDUAL CONTRIBUTOR 2",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"INDIVIDUAL CONTRIBUTOR 3",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"INDIVIDUAL CONTRIBUTOR 4",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"INDIVIDUAL CONTRIBUTOR 5",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"INDIVIDUAL CONTRIBUTOR 6",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"INDIVIDUAL CONTRIBUTOR 7",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"( + )  GOVERNMENT CONTRACTS"]
[null,"FEDERAL CONTRACT 1",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"FEDERAL CONTRACT 2",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"FEDERAL CONTRACT 3",0,0,0,{"$f":"SUM(C35:E35)","v":0},0,0,0,{"$f":"SUM(G35:I35)","v":0},0,0,0,{"$f":"SUM(K35:M35)","v":0},0,0,0,{"$f":"SUM(O35:Q35)","v":0},{"$f":"SUM(F35,J35,N35,R35)","v":0}]
[null,"FEDERAL CONTRACT 4",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"STATE / LOCAL CONTRACT 1",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"STATE / LOCAL CONTRACT 2",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"STATE / LOCAL CONTRACT 3",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"STATE / LOCAL CONTRACT 4",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"( + )  OTHER REVENUE SOURCES"]
[null,"CASH SALES",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"CUSTOMER ACCOUNT COLLECTIONS",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"LOAN / CASH INJECTION",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]
[null,"INVESTMENT INCOME",0,0,0,{"$f":"SUM(C46:E46)","v":0},0,0,0,{"$f":"SUM(G46:I46)","v":0},0,0,0,{"$f":"SUM(K46:M46)","v":0},0,0,0,{"$f":"SUM(O46:Q46)","v":0},{"$f":"SUM(F46,J46,N46,R46)","v":0}]
[null,"SPECIAL EVENTS",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"PROGRAM SERVICE FEES",0,0,0,{"$f":"SUM(C48:E48)","v":0},0,0,0,{"$f":"SUM(G48:I48)","v":0},0,0,0,{"$f":"SUM(K48:M48)","v":0},0,0,0,{"$f":"SUM(O48:Q48)","v":0},{"$f":"SUM(F48,J48,N48,R48)","v":0}]
[null,"TAX REFUND",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]
[null,"OTHER",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]
[null,"( + )  YEAR PREVIOUS RECEIVABLES"]
[null,"RECEIVABLE 1",0,0,0,{"$f":"SUM(C54:E54)","v":0},0,0,0,{"$f":"SUM(G54:I54)","v":0},0,0,0,{"$f":"SUM(K54:M54)","v":0},0,0,0,{"$f":"SUM(O54:Q54)","v":0},{"$f":"SUM(F54,J54,N54,R54)","v":0}]
[null,"RECEIVABLE 2",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"RECEIVABLE 3",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"RECEIVABLE 4",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"RECEIVABLE 5",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"RECEIVABLE 6",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"TOTAL CASH RECEIPTS",{"$f":"SUM(C11:C59)","v":0},{"$f":"SUM(D11:D59)","v":0},0,{"$f":"SUM(F11:F59)","v":0},{"$f":"SUM(G11:G59)","v":0},{"$f":"SUM(H11:H59)","v":0},{"$f":"SUM(I11:I59)","v":0},{"$f":"SUM(J11:J59)","v":0},{"$f":"SUM(K11:K59)","v":0},{"$f":"SUM(L11:L59)","v":0},{"$f":"SUM(M11:M59)","v":0},{"$f":"SUM(N11:N59)","v":0},{"$f":"SUM(O11:O59)","v":0},{"$f":"SUM(P11:P59)","v":0},{"$f":"SUM(Q11:Q59)","v":0},{"$f":"SUM(R11:R59)","v":0},{"$f":"SUM(S11:S59)","v":0}]
[]
[null,"( – )  CASH PAYMENTS"]
[null,"( – )  COST OF GOODS SOLD"]
[null,"DIRECT PRODUCT / SERVICE COSTS",0,0,0,{"$f":"SUM(C64:E64)","v":0},0,0,0,{"$f":"SUM(G64:I64)","v":0},0,0,0,{"$f":"SUM(K64:M64)","v":0},0,0,0,{"$f":"SUM(O64:Q64)","v":0},{"$f":"SUM(F64,J64,N64,R64)","v":0}]
[null,"PAYROLL TAXES / BENEFITS - DIRECT",0,0,0,{"$f":"SUM(C65:E65)","v":0},0,0,0,{"$f":"SUM(G65:I65)","v":0},0,0,0,{"$f":"SUM(K65:M65)","v":0},0,0,0,{"$f":"SUM(O65:Q65)","v":0},{"$f":"SUM(F65,J65,N65,R65)","v":0}]
[null,"SALARIES - DIRECT",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]
[null,"OTHER",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]
[null,"OTHER",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(C64:C70)","v":0},{"$f":"SUM(D64:D70)","v":0},{"$f":"SUM(E64:E70)","v":0},{"$f":"SUM(F64:F70)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(O64:O70)","v":0},{"$f":"SUM(P64:P70)","v":0},{"$f":"SUM(Q64:Q70)","v":0},{"$f":"SUM(O71:Q71)","v":0},{"$f":"SUM(F71,J71,N71,R71)","v":0}]
[]
[null,"( – )  OPERATING EXPENSES"]
[null,"ACCOUNT FEES",0,0,0,{"$f":"SUM(C74:E74)","v":0},0,0,0,{"$f":"SUM(G74:I74)","v":0},0,0,0,{"$f":"SUM(K74:M74)","v":0},0,0,0,{"$f":"SUM(O74:Q74)","v":0},{"$f":"SUM(F74,J74,N74,R74)","v":0}]
[null,"ADVERTISING",0,0,0,{"$f":"SUM(C75:E75)","v":0},0,0,0,{"$f":"SUM(G75:I75)","v":0},0,0,0,{"$f":"SUM(K75:M75)","v":0},0,0,0,{"$f":"SUM(O75:Q75)","v":0},{"$f":"SUM(F75,J75,N75,R75)","v":0}]
[null,"BANK FEES",0,0,0,0,0,0,0,{"$f":"SUM(G76:I76)","v":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]
[null,"DUES / SUBSCRIPTIONS",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]
[null,"INTERNET",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]
[null,"MEALS / ENTERTAINMENT",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]
[null,"PAYROLL PROCESSING",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]
[null,"POSTAGE / SHIPPING",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]
[null,"PROFESSIONAL SERVICES",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]
[null,"RENTAL FEES",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,{"$f":"SUM(G91:I91)","v":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]
[null,"TELEPHONE",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]
[null,"TRAVEL",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]
[null,"WEB DEVELOPMENT",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,{"$f":"SUM(C98:E98)","v":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]
[null,"OTHER",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(F100,J100,N100,R100)","v":0}]
[null,"OTHER",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"TOTAL OPERATING EXPENSES",{"$f":"SUM(C74:C101)","v":0},{"$f":"SUM(D74:D101)","v":0},{"$f":"SUM(E74:E101)","v":0},{"$f":"SUM(F74:F101)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(O74:O101)","v":0},{"$f":"SUM(P74:P101)","v":0},{"$f":"SUM(Q74:Q101)","v":0},{"$f":"SUM(O102:Q102)","v":0},{"$f":"SUM(F102,J102,N102,R102)","v":0}]
[]
[null,"( – )  ADDITIONAL EXPENSES"]
[null,"CASH DISBURSEMENTS TO OWNERS",0,0,0,{"$f":"SUM(C105:E105)","v":0},0,0,0,{"$f":"SUM(G105:I105)","v":0},0,0,0,{"$f":"SUM(K105:M105)","v":0},0,0,0,{"$f":"SUM(O105:Q105)","v":0},{"$f":"SUM(F105,J105,N105,R105)","v":0}]
[null,"CHARITABLE CONTRIBUTIONS",0,0,0,{"$f":"SUM(C106:E106)","v":0},0,0,0,{"$f":"SUM(G106:I106)","v":0},0,0,0,{"$f":"SUM(K106:M106)","v":0},0,0,0,{"$f":"SUM(O106:Q106)","v":0},{"$f":"SUM(F106,J106,N106,R106)","v":0}]
[null,"INTEREST EXPENSE",0,0,0,{"$f":"SUM(C107:E107)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"INCOME TAX EXPENSE",0,0,0,{"$f":"SUM(C108:E108)","v":0},0,0,0,{"$f":"SUM(G108:I108)","v":0},0,0,0,{"$f":"SUM(K108:M108)","v":0},0,0,0,{"$f":"SUM(O108:Q108)","v":0},{"$f":"SUM(F108,J108,N108,R108)","v":0}]
[null,"PRIOR YEAR ACCRUALS",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]
[null,"OTHER",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]
[null,"TOTAL ADDITIONAL EXPENSES",{"$f":"SUM(C105:C112)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(F113,J113,N113,R113)","v":0}]
[]
[null,"TOTAL CASH PAYMENTS",{"$f":"SUM(C71,C102,C113)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(F115,J115,N115,R115)","v":0}]
[]
[null,"NET CASH CHANGE\n (CASH RECEIPTS – CASH PAYMENTS)",{"$f":"C60-C115","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(F117,J117,N117,R117)","v":0}]
[]
[null,"MONTH ENDING CASH POSITION\n (CASH ON HAND + CASH RECEIPTS – CASH PAYMENTS)",{"$f":"SUM(C7,C60)-C115","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(F119,J119,N119,R119)","v":0}]
[]
[]
[null,null,null,"CLICK HERE TO CREATE NON-PROFIT CASH FLOW PROJECTION TEMPLATES IN SMARTSHEET"]