Bookkeeper errors can give you inaccurate data and end up costing your church or nonprofit organization thousands of dollars to "clean up".
See tips below to spot those errors and correct them...
Whether you are using an inhouse or remote bookkeeper, you as church and nonprofit administrators should be able to spot bookkeeper errors. As I stated above, bookkeeper errors can...
As a treasurer of my own church for 30+ years and owner of a bookkeeping firm that specializes in nonprofit and church accounting, I have seen and cleaned up my share of bookkeeping "messes". So I am going to share with you some things to look for to ensure that your bookkeeper is doing the best possible job for your organization.
You would think this was a given, but I can't tell you how many accounting systems I have looked at that have NEVER been reconciled! Reconciling your bank, credit card, investment, mortgages, giving records, Paypal, and especially your PETTY CASH accounts EVERY month is one of the most important tasks you can do to ensure your accounting data accuracy and catch errors such as duplicates and overpayments.
Your bookkeeper should be providing you with reconciliation reports every month. If not, you have a problem!
If you are getting those recon reports, please do not just glance quickly over them or even worse... not look at them at all. A trustworthy bookkeeper will point out any outstanding transactions on those reports and discuss them with you.
Your bookkeeper should also look for duplicate payments or incorrect charges AND contact you, if they find any. However, you should never rely just on them.
You need to examine all of the "cleared" transactions on the reconciliation report. Does anything look "different" to you? If so... investigate the transaction(s)! Your credit card could have been hacked or your gas company overcharged you...but you are not going to know if you are not looking over your cleared transactions or at the very least...the bank/credit card statements. My clients know that if I see something that sticks out as "unusual" or different than the normal transactions, we are going to contact them about it.
The section that you should ALWAYS pay close attention to is the "Uncleared Transactions Before the Statement Date". If you see a deposit from months ago in this section on your bank reconciliation report... you have a problem! Find out why!
You may have outstanding deposits in that section every once in awhile ...but there should be a good reason why they are there such as an "end of the month" deposit/donation that was entered into your accounting system, but not physically deposited for a couple of days. BUT there should not be an outstanding deposit months old!
It may have been a duplicate...but your bookkeeper should have caught it and voided/deleted it while they were reconciling OR maybe your mobile deposit did not process correctly. Again...find out why!
If you have outstanding checks over 60 days old, someone should contact the payee and find out why the check was never cashed.
If you are reconciling credit cards, you should not have any outstanding transactions... especially if you are rolling those charges automatically into your accounting software. If you are entering them manually, you may have a transaction near the closing date that didn't completely process until the next period. BUT if you have some transaction on dates that had time to process, you probably have duplicates that again your bookkeeper should have caught and took care of.
If you have "cash on hand", your bookkeeper should have a separate "register" set up for it and RECONCILING it EVERY month! All expenses and replenishments should be recorded.
Financial statements are a good place to spot bookkeeper errors. When I have a prospective client inquire about my bookkeeping services, the first financial statement that I ask for or pull up in their accounting system is a Statement of Financial Position (Balance Sheet).
I know there is a problem when I see a balance on the following accounts :
1) Uncategorized Asset: It may be titled something different in your accounting software, but in QuickBooks that account is a "holding" account for transactions that it can't "guess" where to assign. There should NEVER be any transactions assigned to anything "uncategorized" in your register!
2) Undeposited Funds: If you are tracking donations in QuickBooks, you are probably familiar with this account. I tell clients to think of this account as their bank bag... you know... that bag you put the checks and cash in and lock up until you can deposit them in the bank =)
The only time you should have a balance in this account is if you are recording those donations on "Sales Receipts" as of the date of the offering and then you record the deposit in the next month... which may happen if the end of the month falls on the weekend. But I have seen some large balances in this account and upon further investigation discovered that hundreds of Sales Receipts were sitting in that account because the bookkeeper incorrectly assigned deposits in the bank feed and left the "undeposited" funds in this account.
Note: This is a situation that if they have reconciled the bank account... you have a complicated "mess". Hire an accountant to clean up or try to search the internet on how to fix...BUT know if you are tracking donors donations...you can NOT just delete those "undeposited" sales receipts!
Account Payables: High balances could indicate bookkeeper errors have been made with bill payments handled incorrectly. Seen this a couple of months ago with a new bookkeeping client. They had a large balance in AP on the balance sheet for the previous year. Upon further investigation, I discovered that the former bookkeeper had been using a bill pay service that automatically rolled in invoices as bills in Account Payables, but then she imported the checks written to pay those bills and auto payments in the bank and credit card feeds as regular expenses.
The result was a lot of expenses were doubled, so several 1099s had to be corrected and a lot of work had to be done to "fix" those payable errors. Here is a good article on how to fix that kind of error in QuickBooks: Instructions for Fixing Accounts Payable Errors in QuickBooks If you are using another software, you can usually search the internet for a "fix", but I would advise hiring an accountant as this kind of bookkeeper errors can be a mess to fix too =(
Payroll Liabilities: It you have large balances in one of these accounts, get professional help immediately! You may have bookkeeper errors that could cost you dearly.
Opening Balance Equity: Ok this may not be so much a bookkeeper error as it is a QuickBooks setup error, but any bookkeeper worth their salt knows that when a QB file is completely and successfully set up, no balance should remain in the Opening Balance Equity account.
QuickBooks automatically creates this aggravating account and records balances when you connect bank or credit cards or if opening balances are entered when new Donors or Vendors are set up. It is one of the things about QB that I do NOT like. I create a journal entry with beginning balances when I setup a QB file and then delete the automatic recordings to the Opening Balance Equity (OBE) account (if they occur) as I already have those balances set up. If you have a balance in OBE account, you can google how to zero it out.
Church Accounting Package
A set of 4 ebooks that covers the following topics...
Warning... this is one of my pet peeves in bookkeeping, so I will try not to sound too harsh and not harp on it very long =)
We create a Transaction Detail by Account report for our clients every month. It is an excellent report to have on hand during board meetings when someone asks why a certain account went over budget or was unusually high. The report will show all transactions in that account, so you can tell them exactly what transactions made up that amount.
If your bookkeeper provides you with a similar report each month, look at your transactions and make sure they are entering the Payee/Vendor name. You would not believe the number of clients I get that have hundreds of missing vendor names. This, in my humble opinion, is sloppy and lazy bookkeeping. How long does it take to enter a name! (I warned you this was a sore spot with me =)
Reasons this is a bookkeeper error:
1) 1099s! With some vendor names missing in your accounting data, your bookkeeper will probably report incorrect amounts paid to independent contractors.
2) If another bookkeeper has to step in or if your bookkeeper goes on vacation and someone "helps" while they are gone... they will need to look in the accounting history to assign many transactions. The easiest way to do that is to pull up the vendor and look at what account has been historically assigned to that vendor's transactions. With no name, this is impossible.
3) Opens the door to fraud! Without names on expenses, unauthorized or even fraudulent expenses can go unnoticed.
Enough said! The next section pertains to signs that your paid bookkeeper may not be doing their best for your church or nonprofit organization.
I clean up a lot of “messed up” books in my bookkeeping business. When it is because a volunteer or staff member didn’t know how to do everything exactly right, I totally understand and will work with them to get everything “in order”. BUT when I see inexcusable errors from a previous bookkeeper that was charging the church or nonprofit a high monthly fee to do it right…I get upset!
So besides the bookkeeper errors I mentioned above, here are some signs that your paid bookkeeper may not be the best fit for your organization...
Tip: If you are paying a bargain rate for bookkeeping …you are probably getting a bargain rate bookkeeper. Now I know this is not always the case, I have in times past gave some startup and small churches a deep discounted rate to begin with, but if you are using a bookkeeping service or software company that offers a discount prices to everyone …they are usually not paying much for their “remote” bookkeepers and you may not get the best bookkeeper possible for your particular organization.
If you want to DIY your payroll, I highly recommend you look at using Gusto! It is very user friendly and their support is awesome! Plus they know how to set up and maintain payrolls for churches and nonprofit organizations.
Note: I am a "partner" of Gusto, but as I have told you before ... I never recommend anything that we or our clients have not tried and love =)