Skip to main content

Three QuickBooks Alternatives to Posting Designated Gifts

Question: 

What is the best approach to recording the receipt and disbursement of designated gifts in QuickBooks?

Answer:

There are three ways we recommend tracking receipts and disbursements for designated gifts. Each of these alternatives will come to the same conclusion at year end on the Statement of Financial Position (aka, the "Balance Sheet"), showing the same beginning- and end-of-year balances.

    1) The first approach is to post the receipts and disbursements of each designated fund throughout the year to a single equity account. The benefit of this is that you will always have a real-time balance of remaining funds. The total receipts and total disbursements can also be viewed on QuickBooks by creating a "Transactions by Account" report and view the total credits (receipts) and debits (disbursements) of the desired designated fund. An additional benefit is that no year-end closing entries need to be made, as everything is posted directly to the equity account.

    2) The second approach makes use of two subaccounts for each designated fund, one for current year receipts and one for current year disbursements. The title account maintains the beginning of year balance throughout the year. This option allows total year-to-date receipts and disbursements to be viewed on the face of the Statement of Financial Position. The current fund balance can then be determined through the combination of the beginning balance (the title account) and the two sub accounts. At the end of the year both the receipt and disbursement accounts must be closed to the title account to update the balance for the beginning of the next year. We recommend that these closing entries be dated the first day of the new year. While both the title account and subaccounts are visible on a detailed Statement of Financial Position, QuickBooks also enables the subaccounts to be hidden. When hidden the report will display the combined year-to-date balance in a single line item on a Statement of Financial Position that can be more readable.

    3) The third approach makes use of QuickBooks' class feature. A class is set up for each desired designated fund, and every transaction relating to the designated fund is posted under that class. Using this option, the balance shown on the Statement of Financial Position remains the same as the beginning balance all year. This is an obvious disadvantage as the real time balance on any single date equals the beginning balance on the Statement of Financial Position plus the net increase or decrease on a per class Statement of Activities. However, by using classes for designated funds a separate Statement of Activity (aka, the "Profit & Loss") can be presented for each fund. This also allows for a budget to be created and compared to the specific designated fund class. At the end of the year the net profit or loss from each class should be closed to its related designated fund equity account on the Statement of Financial Position. 

Each approach for posting designated gifts gives an accurate record of designated fund receipts, disbursements and ending balance. It is also important to note that a church or Christian ministry may use a combination of these approaches. 

For example, a church might use the first approach to record love offerings for speakers. This would allow them to record the in and out postings of the transaction directly to an equity account. The church can also use the second approach for its benevolence fund, allowing its leaders  and members to easily view the total benevolence received and disbursed during the current year. The same church can also use classes as discussed in the third approach for tracking a faith promise missions fund. By creating a class for faith promise missions, it can create a budget for each missionary and create reports comparing actual and budgeted disbursements. 

Remember it is important to consider which option works best for your ministry, as each approach has its benefits. While using a combination of the approaches can provide some benefit for different designated funds, it may not be worth the extra time and complexity it adds. 

For more on QuickBooks Classes see...
    QuickBooks Classes for Church Ministries

Comments

Popular posts from this blog

Rental of a Church Parsonage to a Non-Minister

Question: A church owns a parsonage, but the pastor does not use it as he owns his own home. The church rents the parsonage to a tenant other than a minister or employee of the church. Will the church be responsible for paying income tax on these monies as Unrelated Business Income (filing a Form 990-T) even if the money is used to carry on the business of the church? Answer: Whether the money is used for church purposes is irrelevant.  IRS Publication 598  states: "If an exempt organization regularly carries on a trade or business not substantially related to its exempt purpose, except that it provides funds to carry out that purpose, the organization is subject to tax on its income from that unrelated trade or business." Fortunately, in the case of rental income from real property, such income is "excluded in computing unrelated business taxable income" (Publication 598). Caution: see content below regarding debt-financed property.  However, a second concern not a...

Review: Form 1099 Payments to 501(c)(3) Organizations

Question: A church rented space from another church last year. Should it request a completed Form W-9 and issue Form 1099-MISC? Answer: Payments from one 501(c)(3) organization to another 501(c)(3) organization are not subject to Form 1099-MISC reporting. The IRS Instructions for Form 1099-MISC state that "payments to a tax-exempt organization" are exempt from reporting a Form 1099-MISC.  The following are typical examples of payments of $600 or more by a church which are subject to reporting a Form 1099-MISC: Rent paid to an individual (non-corporation) Payments for services rendered by individuals who are not employees (e.g. janitorial service, facilities, snow removal, guest speakers) Support sent directly to missionaries

Housing Allowance and Form 1099-MISC Reporting

Question: A church provides its minister a housing allowance but believes it must report the full amount of compensation (including the non-taxable housing allowance portion) on Form 1099-MISC in order to demonstrate the full earnings of the minister. (Starting in 2020, Form 1099-MISC is replaced with Form 1099-NEC for non-employee compensation.) If the church reports his compensation, including the housing allowance, on the Form 1099-NEC as taxable income, will he be able to deduct his housing expenses somewhere else on the Form 1040? Answer: This question brings up a couple of issues. First, most ministers are properly classified as employees who receive Form W-2 , not as independent contractors who receive Form 1099-NEC . Box 1 on Form W-2 reports taxable compensation. It is reduced to reflect the church's designation of a portion of his pay as non-taxable housing. Then, in Box 14 (Other), Form W-2 typically reports as a memorandum item his additional non-taxable, housing allowa...