You are here : Technology >Software >

How to Prepare Year End Donation Acknowledgment Statements in QuickBooks

How to Prepare Year End Donation Acknowledgment Statements in QuickBooks

By: Ruth Perryman | Mar 31, 2010 | 250 words | 27077 views
Ranking: ( 0 time(s) )

Before a donor can claim a tax deduction for any single contribution of $250 or more, the IRS requires a written acknowledgment of the contribution from the nonprofit organization. Nonprofit organizations typically send these acknowledgments to donors no later than January 31 of the year following the donation.

QuickBooks Premier for Nonprofits has a nice built-in report called Donor Contribution Summary which can be used by many nonprofits to prepare their year-end donation acknowledgment statements. However, this report includes all revenue including fees for services that aren't tax deductible. But you can create a custom report in QuickBooks that excludes these fees. Here are the instructions:

1. Go to Reports >Custom Transaction Detail Report.

2. Click on the Modify Report button.

3. Select your date range, most likely "Last Fiscal Year."

4. Select Cash for report basis.

5. Select Customer in the Total box.

6. Check the columns you want on the report and uncheck the columns you don't want - at the very least I recommend using Date, Name, Memo and Paid Amount.

7. Select the Filters tab.

8. Select Account in the Filter box, Multiple Accounts in the Account box and check off the revenue accounts you want to include on the report.

9. Select the Header/Footer tab and change the report title to Donor Contribution Summary.

10. If you want each donor printed on a separate page, check the box next to "Page break after each major grouping" after clicking the Print box.

11. Once you have the report looking the way you want it, click on the Memorize button.

Author Description :

Ruth Perryman, MBA, CMA, CFE, CFM is a Certified Advanced QuickBooks ProAdvisor and an Intuit Solutions Provider. She specializes in customizing QuickBooks Enterprise and POS. She can be reached at 800-707-0940 x101 or ruth@theQBspecialists.com.
You can also follower her on Twitter at http://twitter.com/ruthperryman.
Looking for more QuickBooks Tips & Tricks? Visit our blog or subscribe to our e-zine at http://www.theQBspecialists.com.

How to Prepare Year End Donation Acknowledgment Statements in QuickBooks

Ezine Articles Submission - Massive Exposure for Quality Article
Welcome, Guest!   Log In | Create Account