How to write donation thank you letters using QuickBooks Online

In this video, I will teach you how to generate thank you letters using a mail merge in Word. First I begin with QBO to create the two reports necessary. Those include “Sales by Customer Summary”. It may also say “Sales by Donor/Member Summary” depending on your QBO preferences. I export that report after I filtered the dates and income categories. Next I export a QBO report called Customer Contact List. It also may be called Donor/Member Contact List. Once I have those two reports in 1 Excel file, I can use a vlookup to find the amounts donated.

Watch the video for step by step instruction.

By Steve Chase|2018-06-07T23:46:08-05:00February 10th, 2018|Excel, QuickBooks Online|0 Comments

About the Author: Steve Chase

Steve Chase grew up in Dayton, OH but now calls San Antonio, TX home along with his entrepreneur wife, Erin, and their 4 sons. Steve founded Sequentia Solutions in 2017 to help small business owners grow their business with practical and effective solutions. Steve's #1 Clifton StrengthsFinder skill is Learner which comes in handy while he teaches others how to best use various business software applications like QuickBooks Online and Excel. Steve is an active volunteer leader with the Boy Scouts and treasures the lessons he learned while participating in Scouts as a youth on his path to Eagle. Steve enjoys drinking coffee, a good book, visiting art museums, and doing math problems using a brand new sharpened #2 pencils.