Guides / QuickBooks Online
How to export donations from QuickBooks Online
To make year-end donor statements from QuickBooks Online, you need two exports: a report of the year's gifts, and your customer contact list for postal addresses.
Run a report of the year's gifts
Open Reports and search for Transaction List by Customer. In a company set up for a nonprofit, QuickBooks may call customers “donors”, so look for Transaction List by Donor as well. If you record gifts as sales receipts, Sales by Customer Detail works too.
Set the report's date range to your tax year, for example January 1 to December 31.
If the report also contains income that isn't a gift (event tickets, program fees, grants), narrow it to your donation accounts with the report's filter options, or delete those rows from the file afterwards.
Run the report. You don't need to tidy it: the tool reads the report as QuickBooks exports it, with its title lines, donor headings and total rows.
Export it as CSV
Use the report's export button. Intuit's help describes Export to Excel; some accounts also offer CSV. The tool reads CSV, so if you get an .xlsx file, open it in Excel, Numbers or Google Sheets and save or download it as CSV.
Export your donors' addresses
Transaction reports usually don't carry postal addresses, which window envelopes need. Get them from the contact list:
Go to Reports, then Standard reports, Sales and Customers, Customer Contact List.
Choose Customize, then Rows/Columns and Change columns, and make sure the name, email and billing address are included. Run the report.
Export it to Excel and save it as CSV, as above.
In the tool, drop this file into the Address book box, not into the gift files box.
What the tool does with it
- Recognises the report by its columns (such as Transaction Type, Num, Account and Split) and takes each donor's name from the report's group headings.
- Subtracts refund receipts from the gifts they refund.
- Matches the address book to donors by email, then by name.
- If QuickBooks has renamed a column, asks you to pick it rather than guessing.
Menus change. Intuit renames reports and moves menus from time to time, and labels differ between editions and countries. If a step here doesn't match your screen, search for the report's name in the Reports search box. The contact list path above is from Intuit's help pages, checked in November 2026; the gift report names are not.
Try it with your export
Free for up to 10 donors. Nothing is uploaded.