Skip to main content

MinistryCPA Special Topic: QuickBooks Year-End Giving Statements

By
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.
Labels:

Comments

  1. Michelle RJanuary 15, 2015 at 10:17 AM

    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. UnknownJanuary 19, 2015 at 1:30 PM

    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

By
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...
Post a Comment
Read more

How can my ministry expenses be covered by the church?

By
     How can my ministry expenses be covered?                            Many ministers use their personal autos for ministry purposes. Their employers can reimburse these costs using a standard mileage rate published by the IRS. The per mile rate represents employees’ entire reimbursable cost other than highway tolls and parking tabs. If not covered by use of the ministries’ credit card, other costs can be reimbursed as well—business and travel meals, lodging, office supplies, and professional library purchases among them. Some ministries reimburse travel costs using per-diems published by the IRS. If employee business expenses are not reimbursed, the personal tax deduction benefit to the individual minister is severely limited. Non-taxable reimbursements after documentation is provided to the employer follows IRS rules for accountable plans. Non-taxable cash advances before expenses are in...
Post a Comment
Read more

What is the best retirement account for a Minister?

By
       What are my options for retirement savings?                  Regardless of options, start now! You probably have learned about traditional and Roth IRAs. We have often found them well short of the benefits we will share here regarding Internal Revenue Code section 403(b) plans. These plans must be established by your employer (although you might need to be the initiator). They are funded in two ways—withholding from your paycheck at your option (called “elective deferrals”) and as initiated by the employer (matching or non-elective contributions). These contributions not only save income tax, but they also reduce the income you must report as subject to the 15.3% SECA tax. Further, at retirement with the cooperation of your church or Christian ministry the distributions to you can be tax-free to the extent of your qualified housing expenses. Many ministries also adopt what are often called “FICA alternative” be...
Post a Comment
Read more