YearEndReceipts Try it free

Guides / Xero

How to export donations from Xero

To make donation receipts from Xero, you need the year's gifts from one of two places, and your contacts for postal addresses.

The year's gifts

If gifts go straight to a donations account

  1. Open the Account Transactions report.

  2. Choose your donation income account or accounts, and set the date range to your tax year.

  3. Export the report. If Xero gives you an Excel file, open it and save it as CSV.

If you raise invoices for gifts

For pledges or memberships invoiced in Xero, export your sales invoices for the year as CSV instead. The tool counts each invoice once at its total, treats credit notes as refunds and, when the file has a status column, counts only paid invoices.

Your contacts, for addresses

  1. Open Contacts and export them (all contacts, or your donor group).

  2. In the tool, drop the file into the Address book box. It reads Xero's postal address columns (the ones whose names start with PO, such as POAddressLine1 and POCity).

What the tool does with it

Check the menus in Xero. We could not confirm Xero's current menu labels and export formats for this guide, so the steps above are deliberately general. Xero Central has the exact clicks: search it for “Account Transactions report”, “Export invoices” and “Export contacts”.

Try it with your export

Free for up to 10 donors. Nothing is uploaded.

Try it free