Chart of Accounts (part 4 of 4)

Large churches can have a complicated accounting structure but I strongly recommend a simple one. Fortunately all good accounting software allows for flexibility. The greatest area which needs flexibility is in expenses. For instance, some churches have large children’s departments with budgets for the different age levels (preschool and children) or even further sub-groupings (infant, preschool, early elementary, elementary, and middle school, and high school).

 

Some churches have even further needs for classification because they are multisite churches. For instance, they may want to track expenses across campuses for each classification (how much did we spend on craft supplies for our children across all campuses?) but also expenses within a campus (how much did we spend all the preschool program at campus X?).

 

This can be accomplished by adding a three digit department number at the front of the five digit accounting number. The accounting department can do an inquiry to get the financial info requested for each campus and/or budget line. Multisite accounting can be as simple as assigning a department number to a campus so that inquiries are made easier.

 

The critical path is to assign account and department/multisite numbers in a logical pattern which later makes it easy to retrieve data. If there isn’t a good pattern, then getting information will be difficult and that works against what you’re trying to accomplish: getting financial data to help you make better financial decisions.

 

Lead On!

Steve

Chart of Accounts (part 3 of 4)

A chart of accounts must start with the end in mind. The end is always the reports that you want to generate and use for decision-making. What data do you need and how should that info be presented? That determines the format of the chart of accounts. For example, all information about age-level expenses in a church should be in the same area of the CoA and not spread out everywhere; in fact, all the children’s and youth expenses should be grouped together and then sub-totaled which then totaled with other age-level expenses let the reader know how much was spent in that category.

 

The numbering system in a CoA is very logical. I recommend that accounts have no more than five (5) numbers but I’ve seen some as short as three numbers and as long as 16 digits. Five is a happy medium!

 

Here is the basic accounting numbering system which is used pretty much everywhere in the US (where AICPA controls the accounting system).

1XXXX – Cash

2XXXX – Payables, Restricted or Designated Funds

3XXXX – Retained Equity or Net Assets

4XXXX – Revenue & Receipts

5XXXX – Usually reserved for revenues related to special projects

6XXXX – Expenses

7XXXX – Expenses

8XXXX – Expenses

9XXXX – Usually reserved for expenses related to special projects

 

The first digit is the accounting classification. The rest of the digits can be used for sub-categories and other classifications. For instance:

61XXX Missions

65XXX Worship

68XXX Care & Fellowship

70XXX Discipleship-General

71XXX Preschool

72XXX Children

73XXX Youth

74XXX College

75XXX Young Families

76XXX Median Adults

78XXX Senior Adults

81XXX Office & Administration

85XXX Building & Grounds

88XXX Personnel

 

Finally, when the system is set up, the last digit is usually zero (0) so that additional lines can be added over time as needed without having to renumber the entire CoA.

 

Be familiar with the standard accounting numbering system so that when you see an account number, you’ll have an idea of what its accounting classification is. It will help you when you meet with the finance committee.

 

Larger churches have more complicated accounting structures. See part 3 for larger church department and multisite accounting.

 

Lead On!

Steve

Chart of Accounts (part 2 of 4)

In part one, I talked in generalities about financial statements. This post is description of each of the major areas.

 

Balance Sheet (no other name for this doc)

  • Assets
    • Cash on hand in bank and investment accounts
    • Petty cash
    • Sometimes it lists cash you’ll get within the next 12 months
  • Liabilities
    • Payables – usually payroll taxes and payroll deductions which will be sent to the proper recipient the next month. These should never sit for month than a month.
    • Debts – long and short term debts for mortgages and building loans. Each debt should be listed separately so you’ll know what it was for. This must be updated each month as you pay down your debt.
    • Temporarily restricted funds – these are typically restricted by purpose (what they are for). Usually these monies are spent within 12 months for a specific cause such as mission trips, children’s and worship events, etc. Sometimes funds are there for years but each one should have a “sunset clause.” (see my UPMIFA blog post regarding what to do with “old funds”)
    • Permanently restricted funds are restricted by time (how long they are set aside). Usually these are put into an endowment fund because they time and purpose is longer than 12 months.
  • Net Assets (also known as equity, retained equity, or owner’s equity)
    • This is the total cash balance of what the church has accrued since it was started. Often there are two figures for this: the current year-to-date earnings and the prior years’ earnings.

 

Profit & Loss Statement (also known as an Income Statement and Statement of Revenues & Expenses)

  • Revenues or Receipts
    • This section is the total income for the church. I strongly encourage that this section have only revenues from the main purposes of the church. Include in this category only tithes, offerings, and other undesignated budget gifts.
    • You can have a subsection for other receipts such as interest, building use receipts, etc. but this receipts are incidental revenues.
  • Expenses
    • These are budget expense lines grouped into categories with a similar purpose. Churches have several broad categories and the most common ones are:
      • Worship & Music
      • Care & Fellowship
      • Discipleship & Education
      • Missions & Outreach
      • Office Administration
      • Building & Grounds
      • Personnel

 

Lead On!

Steve

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

Church Cuts

Churches spend money on three things

  • Staffing: church personnel form the heart and brains in leading the work of the church
    • If you cut staff, you may need to replace with untrained volunteers
  • Buildings are the skin and skeleton of the church that holds everything in place and in its place
    • If you cut buildings, you save on infrastructure but it is expensive to tear down and re-build
  • Programming is the blood and muscle of a church; this is what gives the church energy and motion and dynamism
    • If you cut programming, you end up with staff sitting in their offices and nothing to attract people and give the church a mission

 

Where does a church cut its budget when it desperately needs to cut?

 

My first answer is, nowhere. Instead of cutting, the very first thing you do is to raise income. Do all you can to encourage generosity among your members, show them the results of what they’ve done in the past, help them experience the joy of giving, and let them see the people who have been helped by their tithes and offerings.

 

My second answer is, everywhere. IF you absolutely must cut AND you have really tried to raise funds, then you are at a critical point in your church’s future.

  • It may be time to close the church down. Seriously – if people are not willing to give more to help the ministry of the church, then perhaps it is time for the church to close its doors. Think about it – actually, you probably already have thought about closing down the church.
  • The other option in the “everywhere category” is to cut a staff person, and the programs overseen by that person, and shutter the rooms used by that ministry area (lights, AC, heat, cleaning, etc.). This is an “All of the above” strategy.

 

Often churches cut everything by 10% or 20%. That won’t resolve the crisis because you keep doing the same ministry and programs with the same staff in the same rooms but now you’re trying to do it on the cheap. Ministry on the cheap results in cheap ministry. That is no way to do ministry. Death by inches is what people do when they are afraid to lead.

 

When gangrene sets in and antibiotics don’t stop it, sometimes the only option is amputation. It is dramatic, traumatic, painful, and requires learning a new set of skills. But you can get a prosthetic limb. It won’t be as good as the original but it will give you much (not all) of the same functionality you had before. Churches need to be willing to sever some staff & programs (and close down building wings). Cutting one or two of the three isn’t enough. Decide what is the main focus of the church and provide staffing, buildings, and programming money for that. Anything that isn’t a part of the Main Thing is removed. It might be replaced later but if it is not needed now, it is done away with.

 

Before you cut, raise money. But if you cut, cut strategically and not indiscriminately.

 

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

IRS Payroll Audit Checklist

A friend of mine had an IRS payroll audit (and passed with flying colors). Below is the actual checklist required by the IRS (I changed only the dates; all other information is original). If you fail this, they won’t revoke your tax-exempt status but they can issue fees and penalties.

As an administrator, please look at this checklist and see if you could give this information immediately to the IRS officer so that he or she is in your office for only a day or two. You don’t want them to stay long and the better organized your records are, the sooner you can return to your normal hectic work.

When a staff person or a committee member complains that you want too much paperwork, show them this checklist and explain that the IRS really does visit churches every single year and asks for this stuff; you’re just trying to protect the staff and church, not trying to do more paperwork.

The instructions below are directly from the IRS:

The following information is being requested for the examination of your Forms 941 for the period covering January 01, 20XX and ending December 31, 20XX. The information being requested will be used in examining the information provided on the return and will be used to determine the employment tax liability for your organization for the period of January 01, 20XX through December 31, 20XX.

Please provide the following documentation:

  1. Copies of Forms W-4 for all employees during 20XX
  2. Copies of Forms W-3 & W-2 for all employees during 20XX
  3. 20XX payroll ledger, check register, employee earning record and year end payroll summary
  4. 20XX general ledger, trial balance, and a chart of accounts
  5. All Bank statements for accounts used in 20XX
  6. 20XX Time cards, sign in sheets, or other method used to track employee hours
  7. Please provide copies of Forms 1096 & 1099 Misc. issued and filed for 20XX
  8. Copies of all employee credit card statements for 20XX
  9. Detailed explanation of payroll procedures, including whether reimbursement is handled under an Accountable or Non-Accountable plan
  10. List of names & addresses of all officers, directors & trustees to include compensation, if paid in 20XX. Also a current list of officers.
  11. Minute books of your governing body (Session) (Officers, Directors , Trustees) including compensation committees if available from January 1, 20XX to December 31, 20XX
  12. Employee personnel manual, job descriptions, compensation policy, and compensation comparable data if used
  13. Copies of Forms W-9
  14. Copies of prior and subsequent year employment tax returns Forms 941.
  15. If your employees were “leased” through a third party management company, or you used the services of a temporary staffing agency, please provide a copy of the contract(s) for 20XX
  16. Provide documentation for any resident or non-resident aliens used in 20XX; include copies of applicable 1042s filed
  17. A tour of the organization’s facilities, as well as a desk or work-area to work in during the examination

NOTE: Additional information may be requested in the future, including a meeting to discuss the supporting documentation you provide. It is to your benefit to provide clear and concise explanations and supporting documentation regarding the information being requested.