Church Sales Forecast Template

Start with the Giving Trends sheet before you enter a single projection. Pull two to three years of actual giving from your accounting software or giving platform and enter the annual totals by stream. The sheet will calculate your historical growth rate and giving per attender, which gives you an honest baseline for the projections you're about to set. Most churches find that their assumptions become significantly more conservative — and more accurate — once they see the actual trend line rather than working from memory or optimism.

Move to the Revenue Forecast sheet and enter your monthly projections for each income stream. Use the Seasonal Model sheet to apply your church's actual giving pattern — or the default weights if you're in your first year of forecasting — so the monthly distribution reflects when money actually arrives. If you're running a capital campaign, open the Campaign Tracker and enter your pledge data: total pledged, expected fulfillment rate, and the payment schedule. The campaign sheet feeds into the Revenue Forecast automatically so your total projection includes both regular giving and campaign cash.

Come back each month and enter actuals in the Actual vs Forecast sheet as your treasurer closes the books. This monthly check-in is where the template pays for itself — you'll see immediately whether regular giving is tracking to plan, whether the summer dip is deeper than expected, and whether any streams need attention before the year-end push. Finance committees that review actual-vs-forecast monthly tend to catch shortfalls in time to respond with a mid-year appeal or a stewardship message, rather than discovering the gap in December when there's little time left to act.

Church revenue forecasting is more complex than it appears because giving is voluntary, episodic, and tied to attendance patterns that shift by season and life stage. Most churches build their annual budget using last year's giving as a baseline with a modest growth assumption, but that approach misses the real drivers — changes in congregation size, the age profile of your top givers, whether a large pledge campaign is entering its fulfillment year, and the impact of a summer attendance drop that's bigger or smaller than usual. Without a structured forecast, finance teams often don't know they're running behind until October, when there's limited runway to respond.

A complete church revenue forecast tracks income by stream because each stream behaves differently. Regular tithes and weekly offerings are tied to attendance and congregation engagement — they're relatively predictable but sensitive to pastoral transitions, growth campaigns, and community events. Facility rentals and school tuition are contractual and the most predictable income a church has. Special campaigns and one-time appeals are event-driven and need their own tracking because pledge fulfillment rates vary widely: most churches see 75–90% of pledges actually paid over the pledge period, but that range matters when a campaign represents 15% of annual revenue. Modeling each stream separately, with its own assumptions and timing, produces forecasts that finance committees can actually act on.

The most valuable use of a church revenue forecast isn't the annual number — it's the monthly picture. Knowing that your church historically receives 130% of a typical month's giving in December and 80% in July means you can plan cash reserves to cover summer payroll without a shortfall and plan your year-end stewardship campaign around the timing of when people are most likely to give. Churches that forecast by month and track actuals against the plan can make small adjustments throughout the year — scheduling an extra appeal, accelerating a facility rental push, or drawing on reserves during a soft quarter — rather than reacting to a crisis at year-end.