For the Church Musician: A Music Program Budget Worksheet

Budget Worksheet for the Church Music Program | @ashleydanyew

New year, new budget, right?

Most churches run on a January-December fiscal year, which means it's time to pull out your budget worksheets and start fresh.

Then you remember your budget worksheets are boring, black and white Excel files, with lots of black grid lines, Arial font, and pages that run on forever, which sort of puts a damper on the whole happy "fresh start" thing.

If this sounds familiar, then you're in for a real treat today!

Here is a beautiful, color-coded, auto-fill budget worksheet for your music program, with pretty pie charts and bar graphs to boot! 

budget, worksheet, music program, church musician, church music, planning, fiscal year, color-coded, auto-fill, Excel, free download, template
budget, worksheet, music program, church musician, church music, planning, fiscal year, color-coded, auto-fill, Excel, free download, template

Download the Music Budget Worksheet here. It's free!

HOW TO USE:

1. Enter your budgeted amount for each category in the Budget column of the Summary by Category table. The actual column will auto-populate with numbers you enter on the Transactions page (tab in bottom left corner of the page).

2. Enter your transactions (date, description, category, and amount). Make sure your categories match the categories on the first page.

3. Use the pie charts to compare budgeted amounts with year-to-date spending (categories are color-coded!).

4. Use the bar chart at the bottom of the first page to see a summary of your year-to-date spending per category.

budget, worksheet, music program, church musician, church music, planning, fiscal year, color-coded, auto-fill, Excel, free download, template

To update or change the categories on the first page:

1. Type a new name into the box.

2. Tab over two boxes to the Actual column and change the name in quotes in the formula bar. It should look like this:

=SUMIFS(Transactions!H4:I21,Transactions!F4:G21,"Children's Choir")

3. Make sure to update the category name for any transactions you may have added on page 2.

Happy planning!