Blog · Territory, capacity and quota planning
Separate cash available for general operations from restricted and designated balances. Compare grant receipt dates, payroll and program payments with a worked nonprofit cash schedule and reconciliation.
Nonprofit cash management separates cash available for current operating payments from balances limited by grant terms, donor purposes or internal approvals. It then compares receipt dates with payroll and program payment dates. Total cash alone cannot answer whether the next operating payment is covered.
Use classifications approved by the finance team from grant agreements, gift documentation and board policies. A bank account name is insufficient: one checking account may contain operating cash and cash assigned to several restricted programs.
Propel Nonprofits explains donor restrictions by reference to the gift instrument, including purpose and time limits. The cash review should carry the resulting approved labels; it should not attempt to determine the legal meaning of an agreement from transaction descriptions.
Keep board-designated reserves separate from donor-restricted cash. Internal designation and donor restriction have different origins and approval routes. For operational planning, identify who can authorize use and whether that approval has occurred before assuming a reserve will cover ordinary payments.
Avoid starting with total net assets or treating all net assets without donor restrictions as cash. Those balances can include receivables and property. Begin with bank and treasury records reconciled to the ledger, then allocate the cash by its actual permitted use.
Use the bank reconciliation, general ledger cash detail, grant register, pledge collection schedule, payroll calendar and open payables. The IRS requires exempt organizations to support receipt and expenditure sources with books and records. Preserve those source references in the working cash file.
Give every row an ID, expected or actual cash date, program, grant identifier, availability category, receipt amount, payment amount, status and owner. Use separate columns for expected and confirmed dates. An awarded grant, an invoice submitted for reimbursement and a deposited payment are different stages.
The controller owns the reconciliation and classifications. Development confirms expected donation collections, grant managers confirm claim status, and program managers identify committed spending. Payroll dates and related tax payments should come from the actual payroll calendar, rather than an even monthly allocation.
Keep the wider monthly package in management reporting. This weekly review should stay focused on balances, timing, exceptions and decisions.
Closing cash = Opening cash + Cash receipts - Cash payments
Operating cash variance = Actual closing operating cash - Planned closing operating cash
An illustrative US community-services nonprofit reviews the week ending October 16, 2026. Finance has approved the classifications below. The program grant may fund only its specified program, and the board reserve requires approval before routine use.
| Cash category | Opening cash (USD) | Receipts (USD) | Payments (USD) | Closing cash (USD) |
|---|---|---|---|---|
| Available general operations | 160,000 | 70,000 | 140,000 | 90,000 |
| Restricted program grant | 90,000 | 50,000 | 60,000 | 80,000 |
| Board-designated reserve | 50,000 | 0 | 0 | 50,000 |
| Total | 300,000 | 120,000 | 200,000 | 220,000 |
These are whole-dollar amounts without rounding. Put the table in A:E, starting with general operations in row 2. In E2 enter:
=B2+C2-D2
Fill through row 4. Sum each money column in row 5. The $220,000 total includes $80,000 assigned to the restricted program and $50,000 awaiting the reserve approval process. The current general operating balance is $90,000.
For detailed records on a sheet named Cash, place category in A, date in B, receipts in C and payments in D. With category in G2 and start and end dates in H2:I2, calculate the period movements using:
=SUMIFS(Cash!C:C,Cash!A:A,G2,Cash!B:B,">="&H2,Cash!B:B,"<"&I2+1)
=SUMIFS(Cash!D:D,Cash!A:A,G2,Cash!B:B,">="&H2,Cash!B:B,"<"&I2+1)
Retain the opening allocation separately. Do not sum a beginning balance repeated on every transaction row.
The full cash proof is $300,000 + $120,000 - $200,000 = $220,000. Independently, $90,000 + $80,000 + $50,000 = $220,000. Both results must match the reconciled cash balance at the same cutoff.
The operating plan expected the following movements:
| General operating measure | Plan (USD) | Actual (USD) | Actual less plan (USD) |
|---|---|---|---|
| Opening cash | 160,000 | 160,000 | 0 |
| Receipts | 90,000 | 70,000 | -20,000 |
| Payments | 130,000 | 140,000 | 10,000 |
| Closing cash | 120,000 | 90,000 | -30,000 |
Closing cash is $30,000 below plan: $20,000 less received and $10,000 more paid. Ask whether the receipt shortfall is late collection or lost funding, and whether the payment increase is accelerated timing or additional cost. Those answers lead to different spending decisions.
Suppose next week's general operating payroll and related payments total $100,000. With an expected $30,000 operating donation deposited beforehand, available operating cash closes at $90,000 + $30,000 - $100,000 = $20,000. If that donation arrives later, the balance reaches -$10,000.
The restricted program's $80,000 does not automatically cover that gap. Management should verify the donation date, examine payments that can legitimately move and follow the reserve approval process before accepting additional commitments. A cash management report records the exception and owner; cash management and receivables covers the collection work behind the receipt assumption.
For federal grants, 2 CFR 200.305 connects qualifying advance payments to immediate cash needs and describes reimbursement arrangements. Apply the relevant award terms when scheduling grant cash rather than assuming the whole award is available immediately.
Bring a sample of your own classified cash, grant receipt and payment schedules in a file or Google Sheet. Covirage maps the columns, its tools compute and check the supplied balances and timing differences, and the external AI model explains the result with every figure traced to its rows. Create a free Covirage account and bring a sample of your own records.
See FP&A reporting for the supporting reporting approach.
No. Cash is one asset balance. Net assets reflect all assets less liabilities and can include receivables, property and other noncash items. A schedule of cash available for upcoming payments must start with reconciled cash and identify restrictions affecting those specific funds.
That depends on the approved grant purpose, award terms and payroll allocation. Program payroll may qualify while general administration does not, or different limits may apply. Have the responsible finance or grant owner approve the classification before using the grant balance in the payment schedule.
Choose a minimum through the organization's approved reserve and liquidity policies. Consider collection volatility, payroll timing and the ability to change spending. Show the minimum beside the forecast, and distinguish amounts requiring board approval from cash already available for routine operating payments.
Keep pledges in the receipt schedule with expected collection dates and supporting status. Include them in projected cash only when the assumption is explicit. They do not belong in reconciled opening cash, and a pledge balance does not prove that payroll can be paid on its due date.