QR Codes

QR codes are free. Get a QR code for your webpage for online giving. Print the QR code in every week’s bulletin and remind people they can give online by scanning the QR code in the bulletin. Keep the CR code in the same place in the bulletin so people will know where to look for it each week. For the increasing number of people who don’t carry cash, this is a simple way to facilitate electronic giving (after all, everyone carries a smartphone everywhere but wallets are disappearing).

Lead On!

Steve

Left-Shoulder Giving

The blog post “Bell Curves and Giving” discusses the average age of your givers and shows that donors in their 50s are the single largest contributors to churches and non-profits. That is the age range on which churches most rely to support their current and future programs. If you visit a church where the average age is older than 60, then that church is likely in decline (unless there is a major endowment supporting the church).

The top of this bell curve are the 50-somethings. The 60-somethings and older form the right shoulder and it is shoulder with a steep downward trend. The overall amount of gifts from 60-, 70-, and 80-somethings declines very quickly for several reasons

  • they are not earning as much as they used to and therefore can’t give as much
  • they are trying to not outlive their money so they restrict what they give to their church and instead will give it as a bequest (if the church cultivates that gift)

The left shoulder is formed by 20-, 30-, and 40-somethings.

  • They are just getting started in their marriages, careers, and families
  • They often make poor financial decisions about cars, houses, and furnishings they purchase.
  • Many end up paying off credit card balances for years or decades.
  • Others are paying down college debt or establishing college funds for their own children.
  • Some are doing all of the above!

Left-shoulder donors have less disposable income than they want to have. They really, really want to give to their church, they just can’t. Churches should and must help them – almost no one else is doing something to address this need. When a church helps a left-shoulder giver get out of or decrease his debt, many pay it forward through their church. This seems self-serving but there is a biblical viewpoint to this – helping people, especially young adults, to understand that our society makes an idol out of money and that distracts them from worshipping God.

Every church with young people (hopefully that means every church) should have classes on Dave Ramsey’s Financial Peace University or Crown Ministries. Everyone in the church should read Randy Alcorn’s The Treasure Principle and/or Andy Stanley’s Fields of Gold. These classes and books provide resources that help people approach money from a rational and biblical point of view, not just an emotional one.

This is an important and urgent matter. If you don’t think it is, try this: take the current giving levels on your bell curve and fast forward 10 or 20 years to see how much money your church will have (realizing that many right shoulder donors will die). That should be a wakeup call to see how significant it is to develop left shoulder donors as fast as possible. Then, when these left shoulder givers are in their 50s or even before, they can be generous givers to their church and the causes that appeal to them.

 

Lead On!

Steve

Revenue Projections Spreadsheet

Projecting church gifts is difficult but not impossible. If you have a few years of giving history and a good spreadsheet, you can get a pretty accurate forecast of how much a church will receive in a current fiscal year with a high degree of statistical confidence, about 98%. I use this with the most important revenue stream for a church, gifts and offerings, but it can be used for any revenue stream that is relatively stable (no major fluctuations from year to year).

To do this, you’ll need at least four years’ worth of giving data with totals by month. The more history you’ve got, the more accurate your projection will be. If you keep up this spreadsheet, each year, the forecasts will get more accurate. Here’s how to do the financial forecast:

  1. Look on the Free Resources tab for the Annual Revenue Projections spreadsheet and open it.
  2. Fill in the church’s or organization’s name
  3. Change the “Year’s Row” to reflect the years for which you have data
  4. Enter all the data for all the years prior to the current fiscal year
  5. Enter current year data through the most recent month in the current year’s column
  6. Change the formula in the row “Through the rest of year”
    1. If you have current year data for seven months, then change the formula in B20 to add up the giving for the last five months of the year.
    2. Repeat for all prior years – you want to add up in row 20 the amount given in each respective prior years’ last five months
    3. The current year’s row 20 cell cannot follow the pattern of the previous cells because there isn’t any data to add. Instead, average the percentage data for all the previous years.
    4. This step, #6, is crucial – it is the only step that is changed each month. As you input data for the most recently completed fiscal month in the current year you’ll need to change what months are added in row 20.
    5. The spreadsheet will give you a figure in “Projected Total as of EOM” (end of month). That is the forecasted receipts figure based on the data you have so far. I suggest copying that figure into the row underneath for the appropriate month so you can see from month-to-month how the forecast changes.

I’ve used this spreadsheet for about 10 years and it uncanny how accurate it is when you’ve got six years of prior giving history and six months of current year giving data. In fact, give the spreadsheet a test: since you know what the total giving was for your most recently completed fiscal year, enter the data as if that year were still in progress and see what the model forecasts with six months’ of data or seven. Compare the forecast with the actual year-end figure to see if it was within a statistical margin (4% or less).

The model isn’t flawless but it is about 98% to 99% accurate. Your Finance Committee will be impressed! This spreadsheet does not account for variances that skew giving such as major gifts or deaths or departures of major givers so consider those events when entering your data. Make sure you save this spreadsheet to your files so you can update it each month.

 

Lead On!

Steve

Decision-Making Committees and Working Teams

Churches need to differentiate between committees and teams. Most churches have one or the other but in reality they have both. However, they don’t distinguish between the two whereas I think there is a difference.

  • Committees
    • Committees make decisions. Committee members should have expertise in the areas to which they are assigned. For example, you need numbers people reading financial statements.
    • Committees always have an indefinite existence.
    • Examples of committees are:
      • Personnel
      • Finance
      • Strategic Planning
      • (that’s really all there are – everything else is a Working Team)
      • Working Teams
        • Working Teams accomplish a specific project. They may have an indefinite lifespan, but they have a specific job to do. Most of the teams do not require skills, they require willingness to serve.
        • Examples of Working Teams are:
          • Ushers
          • Teachers
          • Greeters
          • New Building
          • Fundraising
          • Missions
          • And dozens more, however many the church needs to accomplish its tasks

Many Working Teams should have a sunset clause – when the building is built, when the mission trip is over, etc. Committees never end. One of the key differences is that decisions by Committees may have legal consequences whereas the Tellers’ Team and other teams don’t make decisions with legal concerns.

Working Teams don’t need to have a rotation schedule but Committees must have one. It may be a three or four year rotation with the opportunity to re-up for another term or not, but rotation is important. Committees need a balance of institutional memory (members who have been around a while and know the church’s history and politics) and new blood (members who can bring fresh ideas and current concepts to help the church adapt to the present and future). The easiest and best way to get that mix of history and new is to rotate members. Frequently this rotation helps to keep the average age of a committee in the late-40s and that is a pretty good mix of ages.

 

Lead On!

Steve

Last Will & Testament of Churches

Does your church have a will? What will happen to the church when the time comes to close the doors? No one wants to think about that; it’s too emotional. After all, this is the building where you were married, your children were baptized, your dad’s funeral was held, and your children ran down the halls despite your threats. This is a building full of emotion. So how do you make a rational decision about an emotional subject? The answer is, you don’t at the time. You make those decisions before it becomes overwhelmingly emotional.

Every church will close, and every church building will crumble. That’s a fact. Yes, there are some churches that are over a thousand years old, but most of those are historical structures (think cathedrals in Europe) that are tourist sites and thus get a lot of their funding from visitors (FYI, it costs money to get into St. Paul’s Cathedral and Westminster Abbey in London but St. Peter’s in Rome is still free though donations are encouraged).

First Church, Jerusalem was pastored by James, the brother of Jesus. This guy, not one of the disciples, was so revered that he was elevated to be the leader of the most important church in the new group called The Way (aka, Christianity). To see how important James was, just read about the very first business meeting of the church (Acts 15) and that when James spoke, everyone listened and followed what he said. First Church, Jerusalem probably met in a home, albeit a house big enough to handle over 100 people. At some point the Jesus Movement became institutionalized with buildings and structures but early on, it probably met in a house. Here’s the kicker, we don’t know where that house is today – it’s somewhere under all the buildings currently in Jerusalem. Surely God would have saved the meeting place of First Jerusalem just to show everyone how important church buildings are, but God didn’t. That building is now rubble, somewhere.

If God didn’t save First Church, Jerusalem, He won’t keep your building and your church around till Jesus comes. So, what is your plan when the time comes? I urge you to think about it – and I mean “think.” When the time comes the decision will be so overwhelmingly emotional that most people will not be able to deal with the subject in a calm manner. That is expected, this is an emotional subject.

Put together a plan now to answer questions related to closing the church

  • How small will the congregation have to be so that the doors are closed?
  • How small will the budget have to be?
  • What options will be pursued prior to closing the church? Options include merging with another church; becoming a mission point of another church.
  • What will happen to the assets of the church?
  • Will you sell the building and grounds to a developer or donate the property to the local denominational governing body?
  • Will you take action before the buildings begin to deteriorate such that their upkeep means they are the single largest expense?
  • Who will originate the discussion?
  • Who will make these decisions? The trustees? The deacons? The church members themselves?

There are a dozen other questions to be asked of any congregation and a dozen other questions which are congregation-specific. I encourage every church’s leadership to have a well-thought-out and well-documented conversation now, while your church is in good shape. Then, when the time comes to begin a painful conversation, you’ll be ready to address this subject.

 

Lead On!

Steve

The Best Shredders for Churches

The Best Shredders for Churches

Every office likes to have shredders. The finance office needs to shred sensitive financial files or personnel records; a counseling minister may need to get rid of confidential files; an administrative assistant needs to shred papers with members’ addresses and phone numbers. Shredders are good and necessary to protect the church from any liability resulting from sharing confidential information accidentally.

But shredders are not cheap. The smallest ones cost about $50, and industrial ones go for a few thousand dollars (way beyond what a church needs). Shredders are not used a lot, though. They are used heavily for few projects and then they may sit for a few days or even weeks till they are used again. A real drawback to shredders is the mess they make – every time the plastic liner is replaced, some shreddings fall on the floor which then requires a vacuum to come out to clean it all up. Finally, they have to be maintained and eventually replaced, all of which costs even more money.

Here’s my recommendation: don’t spend any money on a shredder. Instead, take all your papers to your bank to shred. Every bank (including small branches) has shred boxes for their own internal use. They have to have these because of the volume of confidential info they deal with each day. Every so often (usually once a week), the bank’s shred box is emptied and shredded by a professional company. This is a benefit of using a bank that a bank won’t tell you about, but they’ll most often provide this customer service at no additional charge.

Get a box or plastic tub and place it in your office somewhere. When people need something to be shredded, they put the papers in the box/tub. Then, when the financial assistant goes to the bank for the regular weekly or semi-weekly bank deposit, the assistant can take the shred box/tub with her to the bank. Talk with your bank ahead of time to ask about doing this. As long as you don’t flood them with a huge box each week, they’ll be glad to help (at least, that’s what they’ll say in front of you!).

So, let your bank’s industrial strength shredders do your work, save you some money, and keep your office cleaner (and give you a little more space). Take advantage of this (unadvertised) service.

 

Lead On!

Steve

Financial Statements – Statement of Receipts & Expenses (Part 3)

Part 3: Expenses

Expenses are the longest section of an R&E statement. It is typically divided in ministry departments according to how the church staff and programs are structured. Ideally, this part of the financial statements has an increasing amount of detail and all of these layers are stacked so they create synergy.

  • The top of the pyramid is the mission of the church – the further down you go there is more detail but all that detail must support the mission of the church
  • The next layer consists of the various departments. All of these must be on the critical path of the church’s mission. If there is a department that is not central to the purpose of the church, that section should be eliminated. That could be painful and/or emotional, but that program is using resources (people, time, and money) that should be used for the main thing.
  • The next layer, and usually the final one, is made up of the individual line items that support the ministry (which supports the mission). If there is a line that does not support the programming area or the church’s mission, then than line should be eliminated.
  • For purposes of creating the budget, I recommend that yet another layer of detail be created on a spreadsheet (see sample in Free Resources at www.financeforchurches.org). This spreadsheet give explicit detail of every expense from every line item. This enables the budget lines to reflect combinations of smaller amounts or similar expense types to form one large line item.

The numbering system in the chart of accounts should have some reason

  • A number system should have five digits at a minimum. Some organizations use a department prefix of two or three digits followed by a four or five digit line item number. This is effective for larger churches. Small and mid-sized churches can use a five digit line item number where the second and third digits specify a ministry department. For instance: missions can be X2XX0, discipleship can be X3XX0, worship is X4XX0, etc.
  • Increase the numbers by 10 or 20 to provide enough space to insert new expense lines as you grow and the church changes. That means the fifth digit is almost always a zero when a chart of accounts is created.
  • The third and fourth digits can specify the same type of expense across ministry area. For instance: continuing ed in missions can be X241X, in discipleship it can be X3410, in worship it can be X4410, etc.

Spending should only be done against line items which have a budget figure

  • Too many times the financial administrator doesn’t know to what line item an expense should be charged so he creates a new line. But there’s no budget for that expense and unbudgeted expenses means that money is being spent which the church didn’t authorize.
  • Put all expenses in budgeted lines. You may need to move the expense to another budget line later through a journal entry. Or, with the authorization of the Finance Committee take an existing budget line and divide it to create two lines with budgets and put this expense in the new line.

As I mentioned in the post on Receipts, income that is received against a specific expense should not be in the revenues section. Instead, there are a couple of ways to show this in the program expense section.

  • Create a line for income in that ministry expense area. Receipts that are posted here will show up as a negative because they are a “negative expense” (which means income). This method clearly shows the receipts and helps with financial transparency.
  • The other way is to net receipts and expenses in the same line so that figure on the published financial statement is a combination of both income and expenses. It is impossible to see from that one number how much was spent or received.

Grouping expenses into one line is sometimes a legal necessity and sometimes common sense and sometimes creates financial flexibility. from members Here are some examples:

  • Personnel classes
    • It used to be common for churches to have line items for each salary and each benefit for each minister. This creates a huge chart of accounts but it also invades personal privacy and thus creates some legal issues of confidentiality. Churches will do much better to create just two classifications:
      • Salaries & Housing
      • Benefits
  • If necessary, salaries can be differentiated between ministerial staff and support staff.
  • If necessary, benefits can be differentiated between Employer FICA, Retirement, Insurance (Health, Dental, and Disability).
  • Instead of keeping track of personnel expenses in a document which is frequently handed out to the entire church, the financial administrator should have a spreadsheet which tracks all personnel expenses by person and by category. Go to Free Resources at www.financeforchurches.org to see the Personnel Spreadsheet template which you can adapt to your own church’s needs.
  • Office Operations
    • Unless you have a very large office, it is more effective and efficient to put all your office expenses into one line called Office Operations. This includes items such as copy paper, office supplies, toner, copier expenses, postage, etc. If anyone wants to know how much was spent on one of these items, that information can be obtained by running a vendor report or printing out the general ledger detail for that line. All office expenses are the “cost of doing business” and usually don’t amount to a lot so it makes sense to group them together.
    • Utilities
      • Some churches have line items for each utility. I strongly encourage churches to have one line for utilities and put all expenses into that one line. This may decrease the number of questions from members who may focus on the church’s utility bills and not be as concerned about the main purpose of the church.
      • If anyone wants to see the amount of utilities expenses, give them the utilities spreadsheet (see Utilities Spreadsheet in Free Resources at www.financeforchurches.org) or run the general ledger detail with all the information. Using the spreadsheet helps the building committee members see the use of various utilities month-by-month and year-by-year.

Putting expenses into broad categories speeds up the process of entering bills to be paid and that can be a big time saver to the finance office.

As with all financial statements, the R&E Statement must provide relevant and timely information which helps the appropriate committees and team make good decisions. If the financial statements are not providing that information, then the statements must be changed so they meet the needs of the committee unless that same info can be obtained elsewhere (such as the utilities spreadsheet).

 

Lead On!

Steve

Financial Statements – Statement of Receipts & Expenses (Part 2)

Part 2: Receipts or Revenue or Income

The section listing receipts is always first in the R&E Statement and it is usually one of the smallest.  There are several factors to consider as this section is made:

  • There should be one line for every major revenue stream on which the organization depends. For most churches and non-profits this is one or two (sometimes three) lines such as gifts & offerings, bequests & memorials, and maybe endowment transfers (from your own endowment).
  • Some churches have separate revenue line items for gifts from members versus non-members or gifts from members who pledged versus gifts from non-pledgers. Unless you are using that information for reports and to make decisions there is no reason to separate those gifts. They were given for the operating budget as undesignated gifts so put them all in one line (keep it simple).
  • Small, inconsequential, and occasional revenues should be grouped together into an “Other Receipts” line which may or may not have a budget attached to it. Do NOT create a revenue line for every revenue source – it will make your document unwieldy.
  • Revenues from sources for which there is a direct expense should be in the expense section netted against the actual expense or in a revenue line (actually it is a “negative expense line”) just above the expense line. For instance, many churches have weekly suppers; the receipts from the
  • Transfers to the operating budget from designated funds should not be in the income section. This is not new money but merely a transfer of existing money to offset an expense. To show designated funds transfers as new money is disingenuous.
  • Gifts to designated funds should always go through the appropriate fund on the balance sheet, not through the R&E Statement. To do otherwise will inflate the total amount of operating budget receipts of an organization and make it seem like there are greater revenues from its primary revenue stream than there really is.
  • Budgeting receipts is not simple – you cannot take your annual expected figure for receipts and divide by twelve because every church and non-profit gets a significant bump in December. December is the 13th month because typically twice as much money is received in December as any other month (actually, for most churches the last week of December nets as much revenue as any other month). I created a spreadsheet to help calculate what you should budget for receipts for each month. Here’s how to use that spreadsheet:
    • Go to www.financeforchurches.org and under Free Resources, open the spreadsheet titled Monthly Gifts & Offerings Budget Calculation
    • Insert your church’s name in the title
    • From the Annual Revenue Projections spreadsheet (template is also under Free Resources at www.financeforchurches.org) get the total giving by month for all the years for which you have data. Put that data in column B by the respective month.
    • Delete the respective columns K through Z according to the total number of years for which you have giving data and that automatically changes the figure in  column C (Total # of Sundays). (To delete a column or row – click on the column or row symbol which highlights it, then right click and select “Delete”).
    • Make sure that column E has the correct number of Sundays for the current fiscal year (the formula gets the figure from the list of Sundays to the right on the spreadsheet)
    • In cell I19, type in the annual budget for receipts. The spreadsheet will calculate the monthly receipts figure for your new budget year based on historical giving and number of Sundays in the current year.
    • Take the monthly budget figures and put them into your financial software so that you know what an accurate figure for receipts is for each month, especially December.

When church finances get tight, the initial desire is to cut expenses. Most churches can cut their expenses by 5% without affecting their ministries too much for a year or two. However, the other side of the equation is receipts – most churches should increase their revenues by at least 10% if not 20% based on the financial ability of their members. But asking people to give more is harder than asking a few staff members to cut their budgets. I strongly encourage churches to do both/and: cut expenses AND raise income. It will make your church stronger in the long run.

 

Lead On!

Steve