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

Church Car Purchase for Pastor

By
Question: A church would like to purchase a car for the pastor's use. What is the best method to accomplish this goal? Should the car be titled in the pastor's name? What will be the tax consequences of this arrangement? Answer: The church has two main alternatives for this purchase:  Title the car in the pastor's name and reimburse him for business expenses Title it in the church's name and treat personal use as taxable compensation There are fewer immediate tax consequences for the latter. Since both are viable options, we will discuss both situations in this post. If the church chooses to give the car to the pastor and register it in his name, he is free to use it for whatever personal use he desires with no tax consequences. However, the fair value of the car is taxable as compensation at the time it is given to the pastor. Internal Revenue Code section 102(c) clearly states that gifts given to employees by their employers are taxable compensation. The...
2 comments
Read more

Can Form 4361 be filed after the deadline?

By
Question:   Is it possible to opt out of Social Security after the 2-year deadline? Answer:  Unlike other employees, a licensed or ordained minister has the option to opt out of Social Security and Medicare (FICA). If a minister wants to opt out they must file Form 4361 by the tax deadline including extension, in the second year in which they have received ministerial income of $400 or more. This election is final, and the minister cannot opt back into FICA taxes.  At MinistryCPA, we have received questions from ministers who have exceeded the two year deadline and desire to opt-out. There have been several court cases which provide guidance in answering this question. Some have argued that the minister was unaware of the deadline, had mistakenly believed they had filed a timely election, were given incorrect advice by an IRS employee, or their opposition to participate in Social Security and Medicare did not arise until after the 2-year deadline had passed. In each of th...
Post a Comment
Read more

Form 941 or 944 - Which Should a Church Use for Payroll Reporting?

By Anonymous
Question:   Are churches required to file a Form 944 annually to report their employees' earnings and tax-withholdings? 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 Techniques Guide  explains in further detail a minister's treatments for Social Security, Medicare tax, and income tax withholding.   Form 941 or 944 must be filed when non-ministerial employees are compensated or when ministers request withholding. When can a church file the annual Form 944 rather than filing Form 941 each quarter? The IRS may permit the annual filing of Form 944 for employers wh...
Post a Comment
Read more