Cash Flow Forecast for Reimbursement Grants

A reimbursement grant can look healthy in the budget and still strain the bank account.

The reason is timing. Staff get paid every two weeks. Rent is due each month. Vendors may need payment before the report is ready. The funder may reimburse only after costs are incurred, reviewed, and approved. That creates a gap between allowable spending and available cash.

This guide is for executive directors, finance leads, and grants managers who need to see that gap before it becomes a payroll problem.

Start with the cash question

The first question is not, “Do we have grant budget left?” The first question is, “Can we pay the cost before reimbursement arrives?”

Build the forecast around actual cash movement:

• beginning unrestricted cash
• beginning restricted cash by fund, if applicable
• payroll dates and amounts
• rent, insurance, and other fixed costs
• grant costs expected by month
• reimbursement request dates
• expected payment dates
• grant receivables already booked
• reserve or line-of-credit availability
• board-approved limits on interfund borrowing

Do not mix earned revenue, budget authority, and cash in one line. They answer different questions.

Map the reimbursement cycle

For each reimbursement grant, write the cycle in plain terms:

1. Costs are incurred.
2. Costs are reviewed for allowability.
3. The reimbursement package is assembled.
4. The request is submitted.
5. The funder reviews the request.
6. Cash is paid.
7. The receivable is cleared.

The forecast should show dates for each step. If the funder usually pays 30 days after submission, use that as the baseline. If payment timing is unknown, use a conservative range and label it as an estimate.

Federal award cash management rules are especially important. For some awards, advance payments are allowed only when procedures minimize the time between receipt and disbursement. For reimbursement awards, the organization needs support that ties each request to actual eligible costs.

Separate budget pace from cash pace

Budget pace asks whether the grant is spending too fast or too slow. Cash pace asks whether the organization has enough liquidity while it waits for reimbursement.

Both matter. A grant can be on budget and still create a cash gap. A grant can also be behind budget and still have a large receivable if spending was concentrated in one month.

Put these columns next to each other:

• approved budget
• life-to-date expenses
• remaining budget
• reimbursement requests submitted
• reimbursement received
• receivable outstanding
• expected next payment date

GrantPipe keeps spend-down, reporting dates, documents, and reimbursement status tied to the same grant record. That makes the forecast easier to maintain because the finance view and grant view are not two separate spreadsheets.

Add payroll first

Payroll is usually the largest and least flexible timing item. If grant-funded staff are paid before reimbursement, the organization needs enough cash to cover wages, taxes, benefits, and any payroll service timing.

Forecast payroll by pay date, not by month-end accounting period. A month with three payrolls can create a short cash window even when the monthly budget looks fine.

For federal grants, personnel costs also need support from records that accurately reflect work performed. Do not let the cash forecast become detached from time-and-effort documentation. If payroll is charged to the grant, the support needs to be ready before the reimbursement package is submitted.

Show the board the right risk

The board does not need every invoice in the cash forecast. It needs exception signals:

• largest reimbursement receivables
• number of days since submission
• unrestricted cash available after restricted balances are removed
• reserve use or interfund borrowing
• any reimbursement that is late or disputed
• payroll dates that depend on expected funder payments

If reimbursement timing could affect payroll, vendor payments, or reserve policy, put it in the board packet early. Do not wait for the bank balance to make the decision for you.

Build a weekly view during tight periods

Monthly cash forecasts are fine when the organization has a strong reserve. They are not enough when a large reimbursement is late.

During tight periods, switch to a weekly forecast. Use actual due dates and expected deposits. Include a low, expected, and high cash scenario if payment timing is uncertain.

The low case should assume the reimbursement is delayed. The expected case should reflect normal payment timing. The high case should include payments that are likely but not guaranteed. Label each assumption so leaders know what they are approving.

Keep the support file close

The forecast is a decision tool. It is not the audit file. Still, it should connect to the support file.

For each reimbursement request, keep:

• the expenditure detail
• invoices, receipts, or payroll support
• time-and-effort records if personnel costs are included
• proof of submission
• funder approval or payment notice
• bank deposit record
• receivable clearing entry

If the forecast shows a large receivable but the support file is incomplete, the cash plan is weaker than it looks.

The simplest forecast structure

Start with one tab or table per month:

1. Beginning cash.
2. Expected receipts by source.
3. Required payments by due date.
4. Reimbursement requests expected to be submitted.
5. Reimbursements expected to be received.
6. Ending unrestricted cash.
7. Restricted cash not available for general use.
8. Notes on assumptions and risks.

Then add one grant-level tab that tracks each reimbursement request from submission to receipt. The finance lead owns the cash view. The grants manager owns the report and submission details. The executive director owns the decision when the forecast shows a gap.

The point is not a perfect model. The point is an early warning system.

DEFINITION

Grant receivable

A reimbursement amount the organization has earned or requested but has not yet received in cash.

DEFINITION

Reimbursement lag

The time between incurring or reporting an eligible grant cost and receiving cash from the funder.

DEFINITION

Interfund borrowing

Temporary use of one fund's available cash to cover another fund's timing gap, subject to board policy and restriction limits.