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

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

Special Topic: U.S. Olympic Champion Ben Peterson's Autobiography "Road to Gold"

Road to Gold , by Ben Peterson We are privileged to serve our client Ben Peterson and Camp of Champs, the wrestling ministry he founded   and directs. Ben wrestled for more than 16 years, coached on a collegiate level for 28  years, and has directed Camp of Champs for more than 40 years. We have read his autobiography and found Ben's dedication to the sport and his faith to be inspiring. If you are looking for a good story we highly recommend Ben's  Road to Gold. In Road to Gold , Ben shares the lessons he learned throughout his upbringing and how they led him to achieve Olympic victory. Ben states a key element of his youth was the consistency of his parents. He was encouraged to read the Bible every day from an early age, which he now describes as the most stabilizing habit in his life. Throughout his story Ben also emphasizes the importance of confidence, solid goals, hard work, and consistency. These qualities helped Ben throughout his life and wrestling career, from learni

When you don't know what you don't know

Here at MinistryCPA, we recognize that many churches rely on volunteers and/or part-time treasurers and financial secretaries.  With this in mind, we seek to come alongside ministries in providing the much-needed support to ensure that they are operating in a manner that is both compliant with governing authorities and taking advantage of opportunities for improved stewardship of ministry and employer financial resources.  Please consider this brief checklist to determine if your ministry needs to look further into areas that could be classified as “We don’t know if we are compliant.” Please check all compliance requirements that are currently being met: File quarterly Form 941 or annual Form 944 with the IRS Issue Forms W-2 to all employees and File Forms W-2/ W-3 with SSA Ministerial Housing Allowance is only listed in box 14 of the Form W-2 – it is not included in box 1 Obtain Form W-9 from all individuals/businesses that are paid the cumulative total of $600 or more in the year f