Church Cash Flow Template

Start with the 13-Week Cash Flow sheet. Download the file and open it in Excel or Google Sheets — no macros or plugins required. Enter your current operating cash balance in the starting balance cell, then fill in expected inflows for the next 13 weeks: projected weekly offering totals based on your trailing 4-week average, any scheduled facility rental payments, school tuition receipts, and known special offerings. Most church treasurers can complete this initial setup in 20–30 minutes using recent bank statements and a giving report from their church management software.

Next, set up the Giving & Income Tracker. Enter every recurring income stream — active facility rental agreements with payment dates, school tuition schedules, capital campaign pledge commitments, and any large donors who give on a predictable pattern. This step often reveals the shape of your year more clearly than anything else: you'll see which months your income naturally concentrates, which months you're relying on giving momentum to hold steady, and where a slow week or two would put you below a comfortable cash threshold. Update the tracker as pledges are fulfilled or rental agreements change.

Use the Monthly Cash Flow and Dashboard together for board reporting. At the start of each month, enter last month's actual receipts and disbursements in the Monthly Cash Flow sheet — cash received by income category and cash paid out by expense category. The Dashboard updates automatically with your current operating reserve months, the year-to-date giving versus expense chart, and the personnel and facilities cost percentages that elder boards typically want to review. Finance committees typically spend 10 minutes on the Dashboard summary at monthly meetings, then pull up the 13-week view only when they want to discuss a specific upcoming cash trough or seasonal planning question.

Churches face a cash management challenge that most organizations don't: their primary income source — weekly giving — is highly sensitive to attendance, and attendance is seasonal. Easter and Christmas weekend offerings can run 2–4x a typical Sunday. Summer months routinely see 10–20% attendance declines, which compounds into real cash shortfalls when July and August giving falls below the monthly expense run rate. A church with $600K in annual giving can carry $50K in monthly expenses year-round but only bring in $35–40K during a slow summer month. Without a cash flow projection, that gap shows up as a surprise bank balance rather than a known and managed period.

The financial metrics that matter most for church health are specific to religious organizations. Operating reserve months — unrestricted cash divided by monthly operating expenses — is the primary indicator that church finance consultants and denominational advisors look at first. Two months of reserves is widely considered the minimum; three to six months is healthy. Personnel cost as a percentage of total spending is the second key ratio: most healthy churches spend 45–55% of their total budget on staff compensation. When that number climbs above 60%, it signals that ministry program spending is being squeezed. Facilities cost typically runs 15–25% of budget — manageable unless debt service on a building project pushes it higher.

The most effective use of this template is to run it three to four weeks ahead of your actual cash position. Load the Giving & Income Tracker with all anticipated receipts through the next quarter — scheduled rental payments, tuition installments, any expected large gifts from pledge conversations already in progress. Run the 13-week projection to see exactly when your ending balance dips toward your minimum reserve threshold. That advance notice is what gives finance teams and leadership the time to make thoughtful decisions: whether to delay a discretionary purchase, draw on a line of credit, or have a conversation with major donors about timing. Churches that run cash flow projections consistently report that they stopped managing surprises and started managing decisions — which is a fundamentally different and less stressful way to lead the organization's financial life.