Nonprofits using QBO are encountering much difficulty in understanding how to get QBO to provide the necessary IRS required donor notification for individual donors. This class will walk through step by step the cleanest method of entering donations to allow for both a donor notification that can be easily e-mailed as well as donation summary reports that can be sent to donors at Year-end.
Do you know what report he is using for the Year End Acknowlegement letter? (Page 13)
More importantly -- how can that report be used when it has more than 1 donor per page? Is there a way to make that report page break on new donors (Customers)?
Thank you for reaching out to the Community. It looks like Gregg is running a customized "Transaction Detail By Account" Report (Reports > All Reports > Accountant Reports > Transaction Detail by Account) in QuickBooks Online. It looks like they customized the following:
If you are working with only donors, this should pull up all the information about who donated and how much. If you have an account for just donations, you can run an itemized report sorted by account.
Thank you for asking, I will do a more thorough guide for this soon!
Thank you for the detailed, clear and timely response. I appreciate it.
The problem is -- no page breaks. So these reports will not suffice for a donor statement because any given page will have multiple donors listed.
Thank you for letting me know. How did you set up your donations in QBO? Do you have a specified category for charitable donations in your Chart of Accounts? You can always run a custom report on that particular account by user. You would have to run each individually, but it perhaps that document would work as a statement?
@Clarise would definitely know the answer .
Thank -- yes I could filter by customer and run one at a time. Just not very efficient.
I have a product - Donations and I have various classes for those donations. A transactional report works or a Sales Report by Class Detail (group by customer) works too. But I have to filter by 1 customer and run 1 report at a time.
@BBTFinance770, thanks for letting me know.
There will be a more formal piece about NPO tools coming out soon on "Do More with QuickBooks," but you might check out the Donor Receipts app for QBO. It lets you process multiple donation/transactions from multiple donors at once. There are a few cool donation apps out there, but this one is the simplest end-to-end.
Let me know what you think!
Thanks again for the reply and suggestion.
Sorry so late to the party!
Others have already commented on the specifics, but I'd like to raise the question of when is it appropriate for a nonprofit to move the donations out of the accounting system and into a separate fundraising system that handles receipting and reporting, as well as posting summary transactions to the accounting system?
Entry level fundraising packages can be very inexpensive and help you set up campaigns and appeals, as well as tracking donor history better than an accounting system can.
Wish I had know what you shared about QBO being a new product before we switched from OQDesktop. Not being able to produce thank you letters has made for a huge issue for us. I have tried the mail merge suggestion, but no report I pull has all the info I need for this process. The thoughts of having to use a seperate software to record donations seems like a duplicate effort. Has anyone used the Big Red Consulting excel add on?
Big Red Consulting's add-on only works on Windows computers. It does not have a Mac product for donor statements.