Skip to main content

MinistryCPA Special Topic: QuickBooks Year-End Giving Statements

Quickbooks Pro and QuickBooks Premier are great tools in helping churches stay on top of their finances. However, one setback with this software is that it does not come with a pre-installed year-end donor contribution report feature. A church which uses QuickBooks has two options, then, to prepare these statements:
  • Install an add-on to QuickBooks which will accomplish this task.
  • Use a separate, outside program to track donor giving.
MinistryCPA is currently aware of two add-on programs for donor reports:
We tested both of these add-on features (they each have a free trial version). Microsoft Excel is needed to run both of them. From our tests, the Donor Statements from Big Red had better usability, seemed to provide better support, and allowed for better customization as well.

If a church or non-profit organization chooses to purchase QuickBooks with an add-on, it must make sure to read the add-on instructions thoroughly to understand data input requirements in order for QuickBooks to prepare year-end statements.

Comments

  1. Beyond the Ledger could not pull the data out of QuickBooks so it did not work, Big Red is very complicated, could pull data, just not accurately and the only form of communication is via email which is time consuming and in the end non-productive so we had to give up on that one too. We still have had no luck getting the data out effectively.

    ReplyDelete
  2. Michelle,

    Thank you for pointing that out. This post was made almost two years ago, so it is safe to assume that functions have certainly changed.

    MinistryCPA has not tested these functions in two years.

    ReplyDelete

Post a Comment

Popular posts from this blog

Housing Allowance when Bartering for Rent Payments

Question:

If a minister rents his principal residence, but he performs services (mowing the lawn, repairing the roof, etc.) in lieu of rent, can he still qualify the rent amount for a housing allowance tax benefit?

Answer:

Of course, bartering income is taxable. The Internal Revenue Code interprets that above situation as follows: tenant/minister receives taxable income for the fair market value of the services he provides, andtenant/minster pays landlord for renal of residence. The minister in this case reports taxable income for services provided in lieu of rent. It is also likely subject to self-employment tax. He may then claim as qualifying housing allowance expense equal to the amount he "pays" for rent of his personal residence. Essentially, there is no difference than if the minister and his landlord simply traded checks.

See a past MinistryCPA post regarding this topic: http://ministrycpa.blogspot.com/2016/09/services-to-church-in-lieu-of-rent-of.html

Mission Trips Involving Both Charitable and Personal Time

Question:

A church group went on a two-week mission trip, and a few of the members stayed an additional two weeks for personal time. Will the members who stayed the two additional weeks be able to deduct expenses from the trip?

Answer:

IRS Pub 526 covers the topic of Charitable Contributions and, more specifically, travel expenses associated with charitable trips. The publication states that travel expenses will be deductible “if there is no significant element of personal pleasure, recreation, or vacation in the travel.” The publication also states, “The deduction for travel expenses won't be denied simply because you enjoy providing services to the charitable organization. Even if you enjoy the trip, you can take a charitable contribution deduction for your travel expenses if you are on duty in a genuine and substantial sense throughout the trip. However, if you have only nominal duties, or if for significant parts of the trip you don't have any duties, you can't deduct you…

403(b) Contribution Calculations Exclude Housing Allowance

Question:

Should 403(b) contributions and the subsequent match be based on the pastor's total income from the church (including housing allowance) or just from the salary minus housing allowance?

Answer:

According to Richard R. Hammar, J.D., LL.M., CPA, in his book 2015 Church & Clergy Tax Guide, “Section 107 of the tax code specifies that a minister’s housing allowance (or the annual rental value of a parsonage) is not included in the minister’s gross income for income tax reporting purposes. Therefore, it would appear that the definition of includible compensation for purposes of computing the limit on annual additions to a 403(b) plan would not include the portion of a minister’s housing allowance that is excludable from gross income." 

Hammar's Church Law and Tax Report is an excellent resource that many ministries should consider as annual subscribers.