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

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

Form 944 or 941 Filing for Churches

Question:   A new church filed for an employer identification number (EIN) recently. It received notification from the IRS about the EIN, stating that the church must file Form 944 by the following January deadline. The church has no non-ministerial staff members. Since income tax withholding is elective by ministers and none of the pastors has elected to request non-mandatory withholding is the church required to file Form 944 annually? Also, a quarterly Form 941 (rather than an annual Form 944) is required of some employers. Which IRS form, if any, should be filed? Answer: According to IRS Section 1402(c) and 3121(c), ministers are not subject to mandatory income tax withholding. Unless one or more ministerial employees request non-mandatory withholding, church employers with only ministerial employees do not need to file Form 941 or Form 944.  The IRS  Ministers Audit Technique Guide  explains in further detail a minister's treatments for social security, Medicare tax, Fed