Creating a Church Budget Sheet
Here is an example of a basic spreadsheet for a church budget:
Category | Budgeted Amount | Actual Amount | Variance |
---|---|---|---|
Tithes and Offerings | $50,000 | ||
Building Maintenance | $15,000 | ||
Salaries and Wages | $30,000 | ||
Utilities | $5,000 | ||
Insurance | $2,500 | ||
Supplies | $2,000 | ||
Missions | $10,000 | ||
Special Events | $5,000 | ||
Other | $5,000 | ||
Total | $115,000 |
In this spreadsheet, the “Budgeted Amount” column contains the amount of money that the church has budgeted for each category. The “Actual Amount” column will contain the amount of money that was actually spent on that category. The “Variance” column will show the difference between the budgeted amount and the actual amount.
You can add or remove categories as needed. For example, you might want to include separate categories for staff salaries and operations, you can also breakdown other categories even further, like splitting Salaries and wages into different department or staff.
It would be helpful to have a line item for income such as contributions and grants, this line item will allow you to track the income and plan accordingly.
Additionally, you may want to include a sheet with a breakdown of expenses per month, this will allow you to see where the church is spending money on a month to month basis.
You could also use the spreadsheet to track donations by individual contributors, or to track attendance at special events.
Keep in mind that this is just a basic template, and you should tailor it to the specific needs of your church.
Phil is the owner and principal designer and developer at All Saints Media. He has been in the industry for over 20 years and enjoys working with clients from a variety of industries.
Phil is a 1995 graduate of Cedarville University. He has a Bachelors in History. He received his Masters in Biblical Studies from Antietam Bible Seminary in 2007. Along with being a web and graphic designer, Phil is the senior pastor at First Baptist Church of Brunswick, MD.
Phil is married, and is the father of 5 beautiful children.