Chart of Accounts (part 1 of 4)

A chart of accounts (CoA) is the road map in accounting. It makes processing payments and receipts, creating reports, extracting information, and so many others things much easier. There are several well-established rules for creating a chart of accounts which have been codified by the AICPA (American Institute of Certified Professional Accountants). These patterns means that anyone pick up a financial statement from any company and pretty quickly get the information they’re looking for (presuming the data is in there to begin with). Look at your chart of accounts and see if it follows the rules listed in these blog posts.

 

Accounting uses different names for the same thing. It can be confusing but I’ll give you some of the variations. They’ve acquired these names over the years and in different industries but they mean the same thing.

 

Every CoA has several divisions. The most basic one is the Balance Sheet and the Income Statement. A balance sheet shows all the money an organization has (assets), all the debts it has (liabilities), and the difference between the two (retained equity).

 

You can create as many lines and categories in your financial statements as you need but not too many. Even the largest of churches do not have more than 300 (that includes bank accounts, designated funds, payables, revenue lines, and expense lines.

 

Get to know what each of these mean so that when you’re looking at a financial statement so you’ll know what the difference is between them and what their respective purposes are. Next post, the descriptions of these sections.

 

Lead On!

Steve

Software Packages

  1. Membership & Financials
    1. There are two big companies are Shelby Systems and ACS. These are very robust financial/accounting systems and a very strong membership/people module. The contributions module in the Membership section posts gift info to individual members and then it posts it to the financial section for a seamless posting of Sunday receipts. Of the two, my preference is Shelby for several reasons which are too detailed to get into here. If you get both and their modules then annual support will cost about $1,500.
  2. Membership Only
    1. Both Shelby and ACS have a membership/people module that can be bought separately from the financials. There are some newer companies that only do membership such as ChurchTeams, Church Community Builder, Servant Keeper, and about a dozen others. The ones I’ve listed are the larger ones. Frankly, this is an area where you get what you pay for.
  3. Financials Only
    1. To my knowledge, only ACS and Shelby do a dedicated church financials software package. I have made Quickbooks (online and desktop versions) work in a church setting but there are some nuances the Quickbooks just can’t handle such as donor gift statements (I’ve had to find a very time-consuming work-around for that). For church financials, I encourage you to look at either Shelby or ACS.
  4. Payroll
    1. Both ACS and Shelby have payroll modules. However, I strongly recommend you outsource your payroll to a national company such as Paychex, CBIZ, or ADP. They file all taxes on time so that you never incur a penalty from the IRS. They cost about $65 per pay period (for up to about 12 employees). Outsourcing payroll is a LOT of peace of mind – knowing you’ll never have a visit from the IRS is a wonderful thing!

 

Lead On!

Steve

Church Software

This is from an email I received: “I belong to a small church and we are looking to update our software. Can you recommend software that is membership/financial based for churches?”

 

My reply:

Your church size is a big factor – the larger it is, the more robust a system you’ll need; the smaller it is, then you can patch-work a couple of systems. Here is some info:

 

Do you want to handle all your financials “in-house” or are you comfortable out-sourcing your financials? For several years I’ve done out-sourced financials for several clients. I’m biased but I strongly encourage you to out-source your financials to a trusted person. With the internet, your financial person can be several states away. All info (bills and even checks) can be emailed for posting by this company. This saves the church in many ways (no office for a person, no computer to purchase, no employee benefits to pay for, etc.) but it costs a little more in terms of straight wages (because the other company has to cover their own benefits & taxes). If you want to go that direction, I can give you a quote and the names of other companies doing the same thing.

 

If you do this in-house, then you have several decisions to make:

  1. Do you want a system that combines both? That will cost more, be stronger and extremely effective in handling your needs, and require initial training plus on-going training of the staff using it.
  2. Do you want to install the software on your own server or have it online? If you put it on your server then you also need to have it backed up and that will cost about $500 or $750 a year. Having someone else host your data online will cost (price varies) but there is a LOT of peace of mind knowing that your data will never be lost.
  3. Training is a must. Every dollar invested in training will yield results in efficiency and effectiveness in very tangible ways. Get the training!

 

Lead On!

Steve

Church Business Meetings (part 1 of 3)

Most church business meetings are boring – at least the ones I’ve attended. They typically consist of three distinct areas:

  • Numbers: someone presents financial numbers (without giving too much detail lest the audience doze off) and someone else reads a list of people who have joined or left the church
  • Reports: occasionally there is a report about some area of the church and usually these reports are read aloud from the information which is in the packet handed out to all attendees
  • Decisions: sometimes there is an item or two on which church members will vote based on a two-minute presentation

Then the meeting ends, and members leave with very little new information about what is going on in their church. I propose a new format which contains much of the same information, but the presentation is completely different.

Numbers: Every business meeting should have the “nickels and noses” reports (how many people and how much money we’ve got). Financial information, which can be very dry, must be presented to the church in a more dynamic way – more on that in the reports blog (part 2).

  • Membership data should be treated with sensitivity. Most people never know what a church does until they actually experience it, good and bad. What if we told members ahead of time how they can expect to be treated? I can also imagine how members might share that knowledge with other people who have a negative impression of the church in general and sometimes your church specifically. Here are ways to change the membership report:

o   For those who leave the church due to death, the business meeting should pause so that the minister or volunteers talk about the ways the church ministers to the dying and their families. This helps those who are hearing the informatlon to know how their church helps families at some of the worst and hardest times.

o   For those who leave the church to go to another church, someone should talk about how the church reached out to these people to ask them why they left and then explain the reasons, even if the reasons are painful and personal.

o   For those who join the church, there should be a celebration and telling of their stories. New members who are willing could be interviewed at the business meeting so that everyone can get to know something about them. A standard set of “get-to-know-you” questions can be created and given to them ahead of time. Caution: new members must not be forced into doing this – it should be optional, not mandatory.

o   Finally, each new member should be paired with a same-gender long-time member for a year in order to guide the new person through the idiosyncrasies of the church. This pairing will help the new member be integrated to the church and help retain them.

 

Lead On!

Steve

Top 10 Ways to Help the Finance Office (part 1 of 3)

A colleague asked me how staff and lay members can help the church’s Finance Office. Here is my top ten list; yours may be different, so please let me know what I left out.      

1. Pay all bills on time

  • The church doesn’t want to be seen as a deadbeat, so get your bills/invoices to the Finance Office in a timely way so they can be paid on time.
  • The church has a Christian witness every time it pays its bills
  • If a payment is late, vendors will not want to work with the church and even tell others how poorly the church pays its bills
  • If a payment is on time or even earlier than expected, it generates good will and that is a good thing.
  1. ALWAYS attach receipts to EVERY bill to be paid. NO EXCEPTIONS.
  2. The Finance Office needs TWO weeks to process payments. This allows for sick or vacation time off in the Finance Office and for other crises that arise.
  3. The Finance Office can make emergency payments the same day, but that should be for benevolent or charity needs: medicine, housing, food, and gas for traveling to work.
  4. Fill out the payment request forms for all expenses. Make sure the following are on it:
  • Payee
  • Instructions for delivery (such as “give check to …” otherwise it will be mailed)
  • Budget account number
  • A BRIEF explanation of the expense
  • Dollar amount
  • Signature of authorizing minister

2. Using a credit card is convenient, but it has requirements

  • Every credit card expenses MUST have a receipt which is given to the Finance Office. NO exceptions.
  • Every credit card charge is posted into the financial database so that you can look back at your expenses to see what you spent money on.
  • For EVERY credit card expense, write in the budget line to which that expense should be charged.
  • Turn in all receipts as soon as you get the credit card statement.

3. Paying staff for work is a payroll expense

  • Unless you’re reimbursing staff for a work expense, all payments to staff must go through payroll. This even includes gift cards given to staff.
  • This is an IRS requirement. Don’t blame the Finance Office for this.

 

Lead On!

Steve

 

Simple, Transparent, Expectant, Accountable

Financial statements should have these characteristics and here’s why:

  • Simple

o   Any accountant can make financial statements hard to read and interpret but that undermines their goal of being a tool which is used to help the church make better decisions (not just better financial decisions).

o   Keep things as simple as possible because most people can’t read financial statements. If the statements are too hard to read, many people will conclude that things are being hidden from them and the trust level degrades.

  • Transparent

o   All financial statements should have all church financial figures. Hiding or consolidating numbers is not good for the church. It decreases the confidence level members have in the church’s financial leaders. Besides, all the money was given by church members so they should be able to see where all the money is.

o   All financial statements should be published every month. If corporate America can put out monthly statements, then every church should be able to do that, too. I think complete financial statements should be made available to everyone who wants them every month, not just to the Finance Committee.

  • Expectant

o   By this I mean the church should have high expectations of how its money is handled.

o   It should have highly qualified, fiscally impeccable, and well-trained staff in the Finance Office.

o   Its lay leaders should give their time to know the figures and help the church understand the figures.

o   The pastor and other ministers should understand their role in teaching generosity and personal financial priorities.

  • Accountable

o   There is accountability to the church: if the leadership expectations are not being met, then the church should ask them to fulfill their responsibilities or seek others for these roles. There is also legal accountability: if anyone involved in the church’s finances has any hint of fiscal irresponsibility, then the church is obligated to remove him/her from that role.

o   All churches should have a financial audit at least every four years and in the off years, the church should have an “agreed upon procedures” audit. The AUP ensures the finance office is following best practices for a church.

These are non-negotiable items for me in a church finance office, its financial statements, and the people who work there (paid and volunteer). What are your standards?

 

Lead On!

Steve

 

Fiscal Year

What should be a church’s fiscal year: The calendar year or some other 12-month time period? There isn’t a right or wrong answer; just find an answer that works best in your context. Second, there are pros and cons to having a calendar-year or non-calendar-year fiscal year. For instance, churches receive as much as 5% of their annual receipts in the last 10 days of the year, and it is impossible to spend that money before December 31. That leads to the question: should a church’s fiscal year end on 12/31 when it can’t use all the funds given to it, or should it use a different fiscal year?

Some denominations, such as the Nazarenes, require a different fiscal year; all Nazarene churches have a fiscal year which ends on April 30. Southern Baptist churches historically start on October 1 and end on September 30, but it is not mandated. Below is a list which was initiated by Brandon Woodard, a colleague and friend of mine.

Reasons not to use a calendar year as a fiscal year

  • Church won’t have to rely on December’s offering to meet their annual budget receipts or not
  • Allows the church to spend the December gifts in the subsequent calendar year because it is part of the December fiscal year
  • Spreads out the workload of calendar year-end closing of inputting a new budget; sending out donor gift statements, W-2s, W-3, 1099s, 1096; updating payroll increases, benefit premium changes; opening and closing fiscal years on the General Ledger; and all other year end closing procedures in a 30 day period (December 15-January 15)

Reasons to use a calendar year as a fiscal year

  • Most church members presume their church is on a calendar year
  • Many churches will receive more money in the last few days of the year than they can spend and these “unspent budget funds” can be set aside in the next fiscal year and used to fund reserves, pay for capital needs, knock down debt, or any number of other things that the church didn’t budget or plan for
  • It provides the opportunity to encourage people to be generous at Christmas and to help the church out even more

Personally, I prefer a calendar year as the fiscal year. It requires the church to be fiscally prudent throughout the year and then it can provide some monies for major needs. Also, many if not most businesses (including the IRS) use a calendar year, so society has trained people to use it.

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