by Phil Cllins
(Houston, Tx)
I work part time as the bookkeeper for a church reporting to the senior pastor. I am a retired accountant having spent 38 years in aerospace accounting, the last 25 years with Lockheed Corporation at the corporate level. Please bear with me while I provide the needed background / contextual information for my question.
The church uses QuickBooks and fund accounting with approximately 35 funds on the balance sheet. The church has two bank accounts, operating and designated. Undesignated contributions are deposited in the operating bank account, designated contributions to the designated bank account.
ALL monies received are counted by volunteer 'teller counters' on Sundays and recorded on either the operating count sheet or the designated count sheet. The tellers deposit all cash on Sunday at the bank night depository box. The endorsement stamp is placed by the tellers on all checks, a stamp for operating and a stamp for designated. The checks remain in the church and are copied on Monday morning and deposited. I enter the data from the teller's count worksheets into a similar Excel worksheet to verify the math / totals of the teller worksheets and to facilitate the grouping/identification/posting to the appropriate QB accounts.
From time to time a donor will write a check indicating on the check but sometimes with a sticky note attached to the check that $ are for operating and $ are for designated. This creates an immediate problem for the teller counters in not knowing on which count sheet to record the check, operating or designated. Either choice will not be correct.
Once I get the checks, I can't split up, i.e. between operating and designated accounts, the check including funds for both operating and designated. So the check is deposited in either the operating or the designated and a transfer is made online between the bank accounts in order to have the check amount in the correct account. The transactions (all recorded in the AJE folder) needed to complete the correction are 3: (1) transfer between online bank accounts; (2)QB: record transfer between bank accounts; (3) AJE to record the distribution of the transfer and this can only be done if I am given reliable information to do so.
Closer to my question. The senior pastor has clearly indicated that if she is approached by a member who is wanting to write a check and then decides to add an amount for a memorial, the pastor will not ask the member to write separate checks but will tell the donor that "we her staff or 'me' will fix it." I openly disagreed with the pastor by her remarks, by throwing the fix back to me and increasing my workload by unnecessary 'fix it' steps.
Furthermore, I told the senior pastor making regular transfers between cash accounts will also raise red flags during an audit. My words did not impact her position at all. In my opinion she is deliberately managing overriding controls.
Answer
Wow Phil. I am not sure what to say. 35 funds??? You do have your hands full!
Okay, I can see both sides of this dilemma. I have constantly stated that churches and pastors need to make their accounting as simple as possible for their volunteers and staff. It is very hard to find anyone willing to take on the responsibility of taking care of the church’s finances, so if you find a good one you should do everything in your power to keep them.
However, I can see your pastor’s side too. It is very difficult to ask your donors to write out two or three different checks.
We have people do that all the time, but we only have one bank account and the distinction is all done in the recording. So I have no easy solution for you.
I do believe that if your donors realized how difficult they were making it on the church staff...most would gladly write out the separate checks. Maybe your pastor could make an announcement to that effect...you know...not make it a requirement but a request and then if some still wanted to put it on one check they could...but most would probably do as requested.
Does anyone have a suggestion for Phil?
Hope this helps,
Church Accounting Package
www.freechurchaccounting.com
Face the same situation? Have a suggestion or comment? Please click on the comment link below.
7Comments
QuickBooks for a Church
VVickey
Carla, if you would like to take Phil up on his generous offer. Contact me and I will forward your request on to Phil.
Phil, thank you for all the posting you do on this site. Your posts are always informative and very much appreciated!
Budgeting for Principal and Interest
PPhil Collins
Our church has a monthly mortgage note and the 2010 budgeted monthly disbursement included both principal and interest ? this was not the way it should be done but I was not asked for my input even though I am the church bookkeeper with 38+ years in my profession.
Your QuickBooks is doing the correct entry by recording the principal as a liability. When a payment is made for an example $200 that includes interest of $175 and principal $25, the entry is debit to expense $175 (increases expense), debit to liability account $25 (decreases the liability) and credit to cash $200 (decreases cash.
This is what I have done to compensate our reporting in 2010 with the principal amount being in the budget but the actual principal payment being correctly recorded in the liability:
Total Expense 50,596.49
Net Income before mortgage payment 3,067.21
Principal payment on mortgage note 1,949.26
Net Income including mortgage payment 1,117.95
Because the budgeted principal portion of the payment is not being reduced in QuickBooks, (I export all the monthly financial reports to Excel where I can do some minor formatting) I add the last 3 lines (see above example) to the financial statement(s). This provides the financial report with the principal payment without overriding how QuickBooks records the payment.
I will be glad to discuss this further if this is not clear enough. You might contact Vickey on this website how we might could discuss this in more detail if so needed.
Restricted Accounts
CCarla
Our Budget was set up with expenses for principle and interest seperate. Now QuickBooks shows principle under "Liabilities" and we are wondering if we can still do as original budget was set up.
As far as your 1st comment on splitting checks for various accounts, do you use tithe envelopes? We have members use 1 check and use the tithe envelope to seperate tithe (General Fund), Faith Promise Missions, and then Other (Restricted Accounts). All money is deposited into the General Fund and then transferred to Mission, Restricted and Payroll accounts. The Restricted Account uses "classes" to seperate various restricted funds rather than individual checking accounts.
We do one General Account entry per deposit slip and have not been entering individual check numbers by members. Is that necessary?
We are still trying to work on various ways of doing reports to look as simple as Quicken's reports, but haven't mastered that yet.
Mgnt overriding controls
AAnonymous
Another Example Needing A Solution
PPhil
The starting point of this example is that the senior pastor basically prepared the 2010 annual budget herself, with some requested input from me the bookkeeper. In doing so, she combined both the interest and principle amounts of the debt service on the church mortgage as debt retirement expense. The budget was reviewed by the finance committee and approved by the church council. I was never asked to review the budget. Now in 2010 as payments are made to the mortgage company, I record the interest portion of the payment to the debt retirement expense (income statement) and the principal to the liability or note payable (balance sheet account). This recording is basic 101 accounting. However, the effect is going to be an underrun for the debt retirement expense because the principal was budgeted as an expense but will be posted to the note payable account. She is quite upset about this and the "false underrun condition" that will appear on the income statement. But she is experiencing the consequence of trying to doing an accountant's job when she is not an accountant. She is good with numbers and sharp in analysis but totally void of accounting theory which is needed whether the organization is a not-for-profit church or mega oil company. She now wants me to make some kind of entry each month to offset the underrun. I have told her it cannot be done and not violate generally accepted accounting principles at the same time. I told her I can add a note to the financial statements but it does not appear that will satisify her. She is determined not to show the undderrun. If the note/mortgage payable is not reduced each month, then the balance sheet will not be fairly presented. The drama continues.
Build healthy relationships without compromise
PPhil
Treasuers Dilemma
PPete