YearEndReceipts Try it free

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

  1. 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.

  2. Set the report's date range to your tax year, for example January 1 to December 31.

  3. 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.

  4. 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:

  1. Go to Reports, then Standard reports, Sales and Customers, Customer Contact List.

  2. Choose Customize, then Rows/Columns and Change columns, and make sure the name, email and billing address are included. Run the report.

  3. Export it to Excel and save it as CSV, as above.

  4. In the tool, drop this file into the Address book box, not into the gift files box.

What the tool does with it

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.

Try it free