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
Open the Account Transactions report.
Choose your donation income account or accounts, and set the date range to your tax year.
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
Open Contacts and export them (all contacts, or your donor group).
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 asPOAddressLine1andPOCity).
What the tool does with it
- Reads credits to the account as gifts and debits as refunds, and skips opening and closing balance rows.
- Takes the donor from a Contact column if you added one to the report, otherwise from the Description, where Xero often puts the contact's name.
- Reads Xero's month-name and day-first dates; when a date could be read two ways, it asks.
- If a column has been renamed, asks you to pick 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.
Sources: