Finance & FP&A

How to build a 13-week cash flow forecast as Foundation and Nonprofit Ops Teams

Finance & FP&AFor Foundation and Nonprofit Ops Teams3 apps10 steps~20 min to set up

Your foundation runs a 13-week cash flow forecast the same way it's been done for a decade: someone exports QuickBooks actuals into a shared Google Sheet, manually layers in grant disbursement schedules from a Salesforce pipeline that may or may not reflect what program staff actually committed, and guesses at the timing of upcoming 990-related expenditures. The sheet breaks when two people edit it at once. Board members ask for an updated projection three days before the meeting and the answer is 'give us a day.' A delayed grant payment from a government funder can quietly drop your operating reserve below policy minimums before finance catches it.

Build this on Starch → See the apps used

Finance & FP&AFor Foundation and Nonprofit Ops Teams3 apps10 steps~20 min to set up

Outcome

What you'll set up

A live 13-week cash flow dashboard that pulls QuickBooks actuals and Plaid bank balances on a schedule — no manual exports, no stale numbers the week before a board meeting

A scenario layer where you can test what happens to operating reserves if a major foundation grant lands 6 weeks late, or if a government reimbursement cycle stretches from 30 days to 90

A weekly Slack digest that surfaces any new vendor charge, unusual spend spike, or balance dip against your operating reserve policy — before the next finance committee call

The Starch recipe

Apps, data, and prompts

The combination of Starch apps, the data sources they pull from, and the prompts you use to drive them.

Apps used

Runway Analysis Scenario Analysis Transaction Insights

Data sources & config

Starch syncs your QuickBooks data on a schedule — invoices, bills, payments, vendors, and journal entries — so actuals are always current without a manual export. Starch also syncs your Plaid bank account transactions and balances on a schedule for real-time cash positioning. Salesforce, where your grant pipeline lives, is connected from Starch's integration catalog and the agent queries it live when the forecast needs pending receivables. Any funder portal or government reimbursement tracker that doesn't have an API — Starch automates it through your browser, no API needed.

Prompts to copy

Connect my QuickBooks and Plaid accounts and build me a 13-week cash flow dashboard. Rows should be: operating checking balance, grant receivables by funder (pull from my QuickBooks AR), scheduled grant disbursements, payroll and benefits, occupancy, program expenses, and net cash position week by week. Flag any week where projected balance drops below $400,000 — that's our board-approved operating reserve floor.

Build me a scenario model on top of my baseline cash flow. I want to compare three cases: (1) all grants land on schedule, (2) our state government reimbursement is 6 weeks late, (3) our state reimbursement is late AND we accelerate one $75,000 program grant payment to a grantee that needs it early. Show runway and minimum weekly balance under each case.

Show me a rolling 60-day view of all transactions across my Plaid-connected accounts. Flag any vendor that charged us more than 25% above their prior month amount, any new vendor that hasn't appeared before, and all recurring charges over $500 so I can reconcile them against our approved vendor list before the audit.

Run these in Starch → or paste them into your favorite agent

Walkthrough

Step-by-step

1 Connect QuickBooks as a scheduled-sync provider. Starch will pull your chart of accounts, open AR (grant receivables), unpaid bills, payroll entries, and journal entries on a recurring schedule — typically daily — so your actuals are never more than 24 hours stale.

2 Connect your operating and reserve checking accounts through Plaid. Starch syncs balances and transactions so the dashboard always reflects what's actually in the bank, not what QuickBooks thinks is there after a 3-day clearing lag.

3 Connect Salesforce from Starch's integration catalog. The agent queries it live to pull your grant pipeline — funder name, expected payment date, grant amount, and stage — so pending receivables feed into the forecast automatically.

4 Install the Runway Analysis app from the Starch App Store and customize it for nonprofit cash flow: swap 'revenue' for 'grant receipts and government reimbursements,' add a row for restricted vs. unrestricted cash, and set your operating reserve floor as a highlighted threshold line.

5 Add your grant disbursement schedule as a structured input — either by connecting the Google Sheet where it lives from Starch's integration catalog, or by describing the disbursement calendar in plain language so Starch can build a recurring input table you update weekly.

6 Install Scenario Analysis. Set the baseline to your current 13-week projection, then build at least two stress scenarios: one where your largest government reimbursement is delayed 45 days, and one where you accelerate a grantee payment. Starch shows minimum weekly balance and how many weeks you have before hitting your reserve floor under each case.

7 Install Transaction Insights and set a threshold alert: any new vendor, any charge more than 20% above its prior-month amount, and any week where total outflows exceed your approved weekly spend budget. These surface in a digest, not buried in QuickBooks.

8 Set up a Monday morning automation: 'Every Monday at 8 a.m., pull the current 13-week cash position, check whether any week in the next 90 days is projected to fall below $400,000, and send me a Slack summary with the three weeks at most risk and the grant receivables that could close the gap if they land on time.'

9 For any government funder portal that requires manual balance checks or reimbursement status lookups — state arts council portals, HHS payment systems — describe the workflow to Starch and it automates the login and data extraction through your browser. No API required.

10 Two weeks before each board or finance committee meeting, run the scenario comparison and export a board-ready table directly from Starch. No reformatting a Google Sheet at 11 p.m.

See this running on Starch

Connect your tools, describe what you want, and the agent builds it. Closed beta is free.

Try it on Starch →

Worked example

Q2 2026 operating reserve stress test — May board packet

Sample numbers from a real run

Operating checking (Plaid balance, April 28)	612,000
Restricted program reserve (separate Plaid account)	185,000
Open AR — Smith Family Foundation grant (QuickBooks, due May 15)	250,000
Open AR — State arts council reimbursement Q1 (due May 30, at risk)	94,000
Payroll + benefits — next 13 weeks (6 pay periods)	318,000
Scheduled grant disbursements — next 13 weeks	210,000
Occupancy and shared services — next 13 weeks	67,000
Projected minimum balance (base case, week 8 trough)	152,000
Projected minimum balance (state reimbursement delayed 6 weeks)	58,000

Going into the May board meeting, the base-case 13-week forecast looks fine: a $612k opening balance, a $250k Smith Family grant expected May 15, and a trough of $152k in week 8 — comfortably above the $400k reserve floor on a total-assets basis but close enough to flag. The scenario layer is what surfaces the real risk. The state arts council reimbursement of $94k has been running 3-4 weeks late all year. If it slips to 6 weeks late, the week-8 trough drops to $58k — below the board's $400k total reserve policy when you factor in the $185k restricted account that can't be touched. Starch flags this automatically in the Monday digest two weeks before the meeting. The finance director walks into the board room with a one-page scenario table already prepared: base case, delayed-reimbursement case, and a third scenario showing what happens if you defer one $40k discretionary grant disbursement to week 10. The board approves the deferral contingency in 10 minutes instead of spending 45 minutes asking for a spreadsheet that doesn't exist yet.

Measurement

How you'll know it's working

Projected minimum weekly cash balance over the next 13 weeks vs. board-approved operating reserve floor

Days of operating expense coverage in unrestricted cash (target: 90 days minimum per investment policy)

Grant receivables aging: dollar amount of open AR more than 30, 60, and 90 days past expected payment date

Government reimbursement cycle time: average days from expenditure to receipt, tracked by funder

Scenario delta: difference in 13-week trough balance between base case and 'largest grant delayed 6 weeks' stress case

Comparison

What this replaces

The other ways teams handle this today, and how the Starch version compares.

QuickBooks + Google Sheets (manual export)

Works until it doesn't — the sheet breaks when two people edit, actuals go stale between exports, and building a scenario takes a full afternoon the week it's most inconvenient.

Fluxx or Foundant (purpose-built grants management)

Strong for grants lifecycle management, but six-figure licensing assumes a dedicated grants team; neither product is built for rolling cash flow forecasting or bank-level cash positioning.

Blackbaud Financial Edge

Serious nonprofit accounting depth, but cash flow forecasting and scenario modeling still require manual exports to Excel; the reporting layer is not built for a 4-person ops team to maintain without a consultant.

Float (cash flow forecasting SaaS)

Purpose-built 13-week forecasting that syncs with QuickBooks, but no grant pipeline integration, no scenario builder tied to your Salesforce grant stages, and no browser automation for government portals that have no API.

Excel / local spreadsheet

Zero recurring cost and maximum flexibility, but no live data connection, no alerts, and the model lives on one person's laptop — which is a single point of failure the week before an audit.

On Starch RECOMMENDED

One platform — runway analysis, scenario planning, transaction insights all running on connected data. Setup in plain English; numbers stay current via scheduled syncs and live agent queries.

Try it on Starch →

FAQ

Frequently asked questions

We use QuickBooks but our grant receivables are tracked in Salesforce. Can Starch pull from both at the same time?

Yes. Starch syncs your QuickBooks data on a schedule — including open AR, bills, and journal entries — and separately queries Salesforce live from its integration catalog when the forecast runs. The 13-week dashboard can combine QuickBooks actuals with Salesforce pipeline data in the same view. You describe what you want the combined surface to show and Starch builds it.

Our biggest cash flow risk is government reimbursements that show up late. Can Starch track when those payments actually post?

Yes, two ways. If the reimbursement posts to your bank account, Plaid will surface it in Transaction Insights within 24 hours of the scheduled sync. If you need to check status on a government funder portal before it posts — say, to see whether a claim is 'approved' or 'pending' in the state's system — Starch can automate that portal check through your browser and alert you when the status changes. No API required on the government side.

Is Starch SOC 2 Type II certified? We have a data security review process for any tool that touches financial data.

Starch is not currently SOC 2 Type II certified. That's worth knowing upfront. If your data security policy requires SOC 2 Type II for tools with access to bank or accounting data, you'll need to factor that into your evaluation. Starch connects to QuickBooks and Plaid using standard OAuth — your credentials stay with those providers — but the certification gap is real and we'd rather you know it now.

QuickBooks report views like P&L and Transaction List — can Starch pull those for the board packet?

QuickBooks report views (P&L, Transaction List, Vendor Expenses) are temporarily unavailable pending a connector fix. Entity-level data — invoices, bills, payments, vendors, and journal entries — syncs normally. For board packets that need a formatted P&L, the current path is to pull entity-level data through Starch and have the agent assemble the summary, or export the P&L directly from QuickBooks and bring it in separately.

We don't use Stripe — we receive grants by ACH and checks, not subscription revenue. Does Runway Analysis still work for us?

Runway Analysis is pre-built around Stripe + Plaid for companies with subscription revenue. For a foundation, you'd fork it: drop Stripe, keep Plaid for bank-level cash positioning, and replace the revenue rows with grant receipt categories pulled from QuickBooks AR. Describe that to Starch — 'build me a 13-week cash flow dashboard using Plaid balances and QuickBooks grant receivables, no Stripe' — and it builds the custom version. The App Store template is the starting point, not the ceiling.

Can we share this dashboard with board members or the finance committee without giving them Starch accounts?

Today, Starch is a tool for your internal ops team — the dashboards and apps live inside your Starch workspace. Sharing with board members who aren't Starch users isn't a native feature yet. The practical path is to generate a board-ready export or summary from Starch and distribute it through your existing board portal or email. Worth flagging if board self-serve access is a requirement.