Most church leaders know their bank balance today. Far fewer can say what it will be in ten weeks.
That gap is where stress lives: the summer dip that catches you off guard, the building payment that lands the same week as payroll, the year-end surge you can’t plan around because you never mapped it. A 13-week cash flow forecast closes that gap. It’s a simple, rolling look at the next quarter of cash coming in and going out, updated every week.
This guide shows how to build one: what goes in it, how to estimate giving, a worked example and how to keep it useful. If you want the broader picture of financial disciplines for growing churches, start with our overview of CFO best practices for churches. This post goes deep on one of them.
What a 13-Week Cash Flow Forecast Is (and Isn’t)
A 13-week cash flow forecast is a week-by-week projection of the cash you expect to receive and spend over the next 13 weeks, which is one quarter. At the end of each week you replace the forecast with what actually happened and add a new week at the end, so you always see 13 weeks ahead.
It is:
- A short-term cash tool that answers “will we have enough cash each week?”
- Built around real dates: payroll days, bill due dates, deposit timing
- A rolling document, refreshed weekly
It isn’t:
- A budget. A budget is your annual plan for income and spending by category. A forecast tracks when cash actually moves.
- A financial statement. It won’t replace your statement of activities or financial position.
- A prediction you can’t change. Its purpose is to show problems early enough to act.
If you want to see how a budget, financial statements and a forecast fit together, our post on nonprofit CFO services vs. traditional accounting explains the difference between looking back and planning forward.
Why Churches Especially Need One
Most organizations have some seasonality. Churches have a lot of it.
- Giving often moves with the calendar: summer attendance dips, holiday and year-end increases, and early-year softness after the holidays
- A large share of spending is fixed and predictable (payroll, facilities, debt service), so a dip in giving hits quickly
- Restricted gifts can sit in your bank account without being available for general spending, which makes the bank balance look healthier than your usable cash (see our guide to restricted vs. unrestricted funds)
- Big one-time items, such as a roof repair, a mission trip or a campaign pledge schedule, rarely line up with when the money arrives
A forecast turns these from surprises into line items.
Before You Start: Gather Four Things
- Bank and giving data for at least the last 12 months, by week or month. If you use a giving platform, include its deposit schedule, since deposits often arrive a few days after the gift.
- Your payroll calendar, including payroll taxes and benefit payments.
- A list of recurring bills and due dates: rent or mortgage, utilities, insurance, software, vendor payments.
- A list of known one-time items for the next quarter: planned purchases, events, repairs, campaign or pledge payments.
If your books are behind, fix that first. A forecast built on stale numbers will only mislead you. Reliable bookkeeping is what makes forward planning possible, which is why church bookkeeping and CFO-level planning work best together.
Step-by-Step: How to Build the Forecast
Step 1: Set up the grid
Create a spreadsheet with 13 columns, one per week, labeled by the week-ending date. Rows go top to bottom in this order:
Row | What goes in it |
Beginning cash | Cash in the bank at the start of the week (week 1 = today’s actual balance) |
Cash in: General giving | Tithes and offerings expected |
Cash in: Designated / restricted giving | Gifts earmarked for specific funds |
Cash in: Other | Facility rental, events, program fees, grants, interest |
Total cash in | Sum of the above |
Cash out: Payroll and taxes | Net pay, employer taxes, benefits |
Cash out: Facilities | Rent/mortgage, utilities, maintenance |
Cash out: Ministry and operations | Programs, supplies, software, insurance |
Cash out: Debt service | Loan or mortgage payments |
Cash out: One-time items | Planned repairs, purchases, events |
Total cash out | Sum of the above |
Net cash flow | Total in minus total out |
Ending cash | Beginning cash + net cash flow |
Minimum cash target | The floor you want to stay above |
Restricted cash on hand | Cash you can’t use for general spending |
Available unrestricted cash | Ending cash minus restricted cash |
The last three rows are the ones most church forecasts miss. “Available unrestricted cash” is the number leaders actually need.
Step 2: Fill in cash going out first
Spending is easier to predict than giving, so start there.
- Map payroll to your actual pay dates. If you pay biweekly, some months contain three pay periods; make sure those weeks show it.
- Place each bill in the week it’s due, not the week you think about it.
- Add quarterly and annual items (insurance premiums, payroll tax deposits, subscriptions) in the right weeks.
- Include one-time items you already know about.
Step 3: Estimate cash coming in
Giving is the hard part, so use a method, not a guess.
- Start with history. Look at the same weeks last year, adjusted for any change in attendance or giving trends since.
- Separate the streams. Forecast general giving, designated giving, online giving and other income separately.
- Account for timing. If online gifts reach your bank two or three days after they’re made, shift them accordingly.
- Be conservative on uncertain items. Pledges, special offerings and one-time gifts are best entered when they are likely, or in a lower scenario.
- Note special weeks. Easter, Christmas, year-end, GivingTuesday and any campaigns can move giving noticeably in either direction.
Step 4: Check ending cash against your floor
Compare each week’s ending cash to the minimum cash target you set (many churches define it as a number of weeks or months of operating expenses; choose what fits your church and board). Any week that dips below it is a flag.
Step 5: Add a downside scenario
Duplicate the sheet and reduce expected giving by a percentage your leadership considers a realistic bad case. See which week you’d first run short and how deep the gap goes. This isn’t pessimism, it’s preparation. It also tells you how much warning you’d have.
A Simple Illustration
The numbers below are made up and rounded purely to show how the mechanics work. They aren’t benchmarks and don’t represent any real church.
Week 1 | Week 2 | Week 3 | Week 4 | |
Beginning cash | $60,000 | $64,000 | $59,000 | $62,000 |
Total cash in | $18,000 | $12,000 | $17,000 | $13,000 |
Total cash out | $14,000 | $17,000 | $14,000 | $20,000 |
Net cash flow | +$4,000 | −$5,000 | +$3,000 | −$7,000 |
Ending cash | $64,000 | $59,000 | $62,000 | $55,000 |
Restricted cash on hand | $22,000 | $22,000 | $22,000 | $22,000 |
Available unrestricted cash | $42,000 | $37,000 | $40,000 | $33,000 |
The bank balance looks comfortable every week. But once restricted cash is separated out, available cash drifts down, and week 4 (the payroll week with a one-time expense) is the tightest. Seeing that in week 1 gives leadership time to move a purchase, adjust timing or plan a communication, instead of finding out on payday.
How to Keep It Current: A 30-Minute Weekly Routine
A forecast only works if it’s updated. A simple rhythm:
- Replace last week’s forecast with actuals from the bank and giving platform.
- Note the variance and ask why giving or spending came in higher or lower.
- Add week 14 at the end so you always see a full quarter.
- Update known changes: new bills, new pledges, schedule changes.
- Flag anything under your minimum and decide what to do about it.
Share a one-page summary with your pastor, treasurer or finance team on a regular cadence. Our post on what a church finance committee does explains how oversight and forecasting reinforce each other.
Common Mistakes to Avoid
- Treating the bank balance as available cash. Subtract restricted funds.
- Forecasting by month instead of by week. Cash problems happen in specific weeks, usually payroll weeks.
- Optimistic giving assumptions. Build the forecast on history and keep the optimistic case separate.
- Forgetting timing lags. Online gifts, checks and reimbursements all land on different days.
- Setting it and forgetting it. An out-of-date forecast is worse than none, because it creates false confidence.
- Building it on unreliable books. If reconciliations are behind, fix the books first. Good church financial reporting feeds a good forecast.
When a Forecast Needs More Than a Spreadsheet
A basic 13-week forecast is something many church administrators can build. Some situations call for more experience:
- Several campuses or funds that need consolidated cash views A building project, loan or capital campaign that changes cash timing for years
- Payroll that’s a large share of spending and interacts with giving swings
- A board that wants scenarios and recommendations, not just numbers
That’s the point where forecasting becomes financial leadership, which is the territory of fractional CFO services for churches.
Want a forecast built around your church’s actual giving patterns? Prospera’s CFO team can build your 13-week view, set your cash targets and walk your leaders through what it means. Schedule a Strategic Consultation
How Prospera Helps
Prospera’s CFO advisory services for churches turn clean books into forward-looking decisions. We build cash flow forecasts from your real giving and spending history, separate restricted from available cash, model scenarios before major commitments, and present the results in plain language your pastor, board and finance team can act on. It’s one of the core systems we describe in our overview of financial systems every growing church needs.
Frequently Asked Questions
What is a 13-week cash flow forecast?
It is a rolling, week-by-week projection of the cash a church expects to receive and spend over the next 13 weeks (one quarter). Each week you replace the forecast with actual results and add a new week, so you always have a forward view.
Why 13 weeks instead of 12 months?
Thirteen weeks is long enough to see seasonal swings and upcoming large payments, and short enough to be reasonably accurate. A 12-month budget answers “what’s our plan?”; the 13-week forecast answers “will we have enough cash in each of the next weeks?”
How is a cash flow forecast different from a church budget?
A budget is an annual plan by category. A cash flow forecast tracks when money actually arrives and leaves, week by week. A church can be on budget for the year and still run short in a particular week.
How do you forecast church giving?
Start with the same period in prior years, adjust for changes in attendance and giving trends, forecast designated and general giving separately, and account for deposit timing from online platforms. Be conservative on pledges and one-time gifts, and build a lower-giving scenario.
How often should we update the forecast?
Weekly. Replace the previous week with actuals, note the variances, and add a new week at the end. Even 30 minutes a week keeps it reliable.
Do we need a CFO to build one?
Not for a basic version. Many church administrators or treasurers can build and maintain one. A fractional CFO adds the most value when you have multiple funds or campuses, a building project or debt, or a board that needs scenario modeling and recommendations.
Related Reading
- CFO Best Practices Every Growing Church Should Implement
- Nonprofit CFO Services vs. Traditional Accounting
- 5 Financial Systems Every Growing Church Should Have in Place
- Restricted vs. Unrestricted Funds: A Plain-English Guide
Ready to See Your Church’s Next 13 Weeks Clearly?
If you’d rather not build and maintain this alone, our team can set up the forecast, train your staff to update it, or run it with you each month so your leadership always knows where cash stands.




