Cash Flow Forecast Template for Churches

Churches and ministries depend on giving that rises and falls through the year: strong at Easter and Christmas, lighter in the summer when families travel. Staff salaries, mortgage payments and utilities don’t take a summer break. A cash flow forecast helps church leaders and treasurers plan for the quieter months and make commitments with confidence.

Why church cash flow is different

• Giving follows the calendar. Christmas and Easter bring peaks; summer brings a dip.
• Online giving has changed the pattern. Recurring digital gifts smooth things out, but one-off gifts still cluster around special services.
• Building funds are separate. Money pledged for a building project is usually designated and can’t pay general costs.
• Missions commitments are promises. Many churches commit a percentage of giving to missions, which rises and falls with income.
• Buildings are expensive. Heating, insurance and maintenance of older buildings can be large and seasonal.

A worked example

A church receives about $52,000 a month in tithes, offerings and online giving and commits 10 percent of general giving to missions.

The August shortfall is predictable. A forecast lets the finance team keep part of the Easter and Christmas surplus aside, or plan a summer giving emphasis, rather than scrambling in September.

How to build a church cash forecast

1. Forecast giving by month from the last two or three years of records.
2. Separate general giving from designated funds such as the building fund.
3. Calculate missions support as your committed percentage of general giving.
4. Add salaries and housing allowances, mortgage or rent, utilities and ministry costs.
5. Schedule insurance, maintenance projects and camps in the months they fall.
6. Agree a reserve level with church leadership.

Common mistakes

Using the building fund to cover a summer shortfall without approval. Forgetting that camp and event income comes weeks after deposits are paid. And planning next year’s budget on a single strong year.

What the template gives you

The Church & Ministry template includes a Building Fund tab for pledged gifts and their expected timing, and a Missions tab that calculates missions support as a share of general giving. Both feed the monthly forecast, so leaders see the true general fund position at a glance.

Key assumptions built into the Church & Ministry template

• The Building Fund tab lists large, irregular payments with the month each starts, how many payments there are and how often they repeat. The example includes building campaign pledges. Each one is routed to the right line of the forecast, and there are spare rows for your own.
• The Missions tab calculates missions giving at 10% of tithes and offerings and online giving. Change a percentage once and every month of the forecast updates, so costs rise and fall with the sales that drive them.
• 5 cash in lines and 7 cash out lines are already named for church & ministry businesses, and every one can be renamed or extended.
• The example figures follow a typical church & ministry year, busiest in December and April and quietest in July and February, so the tight months show up where they usually fall.

Every assumption sits in a yellow input cell, so you replace the example with your own numbers in minutes. The same figures flow through a 13-week weekly view, a 12-month monthly view and a 3-year outlook, and a dashboard shows your lowest balance, the weeks that fall below your minimum buffer and your cash runway.

Free or premium?

If you only need the basics, the free 12-month template or the free 13-week template will get you started today. The premium Church & Ministry template saves the setup time and adds the tabs above, best and worst case scenarios, and an actual vs forecast tracker that shows where your forecast was wrong, so next month’s is better.

Church & Ministry cash flow forecasting: questions

How should a church forecast giving?

Use the last two or three years of monthly giving to find the seasonal pattern, then adjust for known changes such as new members, a building campaign or a change to online giving.

Can a church use its building fund for general expenses?

Usually not without approval, because designated gifts must be used for the purpose donors intended. Keep them on separate lines in the forecast.

How much reserve should a church keep?

Many churches aim for two to three months of operating costs, with more if the building needs major work.