Free church budgeting tool
Free church budget template for Excel
Enter your annual budget and payroll, and you get a church budget spreadsheet with your numbers already in it: income and expenses by month, totals, a column for actuals, a fund tracker for designated gifts, payroll detail and a summary. It's free, and you don't have to give us your email.
Budget worksheet
Monthly columns, standard ministry categories, and built-in formulas.
Fund-aware planning
Separate designated giving, payroll, and ministry spending before board review.
Clear next step
Move from spreadsheet planning to live budgeting and church financial reports.
Fill in your church budget template
Enter your church's key numbers and download an Excel budget with every month filled in and formulas you can edit.
Your template will include:
- Annual budget sheet with monthly columns and totals
- Pre-calculated expense categories
- Fund tracker for designated giving
- Payroll detail template
- Dashboard with summary formulas
Keep going after the download
Built by Grain — modern church accounting software with fund-based accounting and GAAP-compliant reports.
What's in the church budget template?
The download is one Excel workbook with four sheets. Your church's name is on it, and the months begin with the first month of your fiscal year.
- Annual Budget: income and expense lines with a column for each month, then Annual Budget, YTD Actual and Variance. Total Income, Total Expenses and Net rows cover every month, Annual Budget and YTD Actual. Type what you've actually received or spent into YTD Actual, and Variance shows how far it is from the annual budget, as a percent.
- Fund Tracker: date, description, income, expense and balance columns, with sections for a building fund and a missions fund, to keep designated gifts apart from general money.
- Payroll Detail: columns for each staff member's gross salary, housing allowance, health insurance, retirement, payroll taxes and total cost.
- Dashboard: the total budget, payroll as a share of it, and each category's amount and percent. Add your weekly attendance and it shows the annual cost per attendee too.
Sample church budget: what the template fills in
Say your church plans to spend $250,000 next year, and $110,000 of that is payroll. The template puts payroll in first, as personnel: $88,000 for salaries and wages and $22,000 for benefits and payroll taxes. It then splits the other $140,000 the same way for every church: 30% ministry, 25% missions and benevolence, 20% facilities, 15% administration and 10% reserve.
Where a $250,000 church budget goes in the template
Those are starting numbers. Change any of them to fit your church. In the sheet, facilities splits into mortgage or rent ($11,200), utilities ($7,000) and insurance and maintenance ($9,800). If your building is paid off, move that money to other lines and the totals update.
Income starts the same way: general tithes and offerings at 75% of the budget ($187,500), designated gifts at 15% ($37,500), building fund gifts at 5% ($12,500) and facility rental or other income at 5% ($12,500). Replace them with last year's actual giving. If your Net row goes negative, the plan spends more than you expect to receive. For help choosing the lines themselves, see church budget categories and these church budget examples.
After the spreadsheet
From a budget template to church budget software
The template helps you start quickly. Grain helps when your team needs budget vs. actual reports, cleaner board packets, and fund-based visibility without version control problems in spreadsheets.
Church budget software
Track live budget vs. actual performance by fund, ministry, or account.
Church financial reporting software
Generate board-ready statements and drill from totals into supporting detail.
Church fund accounting software
Keep restricted gifts and ministry balances in one fund-based ledger.
Church budget template FAQ
- What is included in the church budget template Excel download?
- The download includes a church budget worksheet with monthly columns, payroll planning rows, common ministry expense categories, fund tracking, and summary formulas for faster review.
- Does this church budget template work for fund accounting?
- Yes. The template is designed to help churches separate designated giving, payroll, and ministry spending, but it is still a spreadsheet workflow rather than a full fund-based ledger.
- When should a church move from Excel to church budget software?
- Excel works well for early planning, but churches usually need dedicated budget software once they want live budget vs. actual reporting, cleaner approvals, fund-level visibility, and fewer manual reconciliations.
- Can a small church use this budget template?
- Yes. The template is sized for small and mid-sized churches that need a simple starting point before they move into church accounting software with built-in budgeting and reporting.