Exporting to QuickBooks, Xero, or Aplos

Each of these gives you a CSV file in the same column layout, so the import steps below work the same way for all of them.

• Donations / gifts: in Donor Management → Gifts, click Export for accounting.
• Membership dues: in Membership → Member Roster, click Export for accounting.
• Event ticket sales: in Fundraising & Development → Events, click Export for accounting (one line per event with its ticket revenue).

The columns are: Date, Type, Name, Email, Amount, Fund/Designation, Restriction, Payment method, Reference, Memo

The Restriction column carries the FASB ASC 958 net-asset class for each line, so your books separate restricted from unrestricted support without re-categorizing by hand. Donations export the class you set on each gift (Unrestricted, Temporarily restricted, or Permanently restricted); membership dues and event ticket sales export as Without donor restrictions, since those are unrestricted exchange revenue. To classify a gift, open it in Donor Management and use the Designation (net assets) control: pick the restriction level and name the purpose (for example, Education or Building fund).

1. Go to Transactions → Bank transactions (under Bookkeeping or the All apps menu).
2. Select the account the money was deposited into, then the Link account dropdown, and choose Upload from file.
3. Drag in your exported CSV and continue.
4. When QuickBooks asks you to map columns, point Date to Date, Amount to Amount, and use Name (or Type) as the Description. The other columns can be left unmapped.
5. Pick the bank or clearing account, review the rows, and finish. Then categorize them to your donations, dues, or ticket-income account.

QuickBooks' built-in CSV import expects a Date, a Description, and an Amount, which our file provides. See Intuit's upload transactions guide.

1. Go to Accounting → Bank accounts.
2. On the account you want, open its menu and choose Import a Statement.
3. Select your exported CSV and click Next.
4. Map the columns when prompted: Xero needs at least Date and Amount (income is a positive amount). Use Name or Memo as the payee/description.
5. Confirm the date format, finish the import, then reconcile to the right income account.

See Xero Central's import a CSV bank statement guide.

Aplos is built for nonprofits, so for donations use the Contributions import, which keeps giving tracked by donor for year-end statements.

1. Go to the Donations area and open the import page, or Fund Accounting → Transactions → Registers and the Import icon for dues and ticket income.
2. Download Aplos' sample template and line up your exported columns to it. Aplos contributions need Date, Contact (use our Name), Purpose (use our Fund/Designation), and Amount.
3. Upload, review, and import.

See Aplos' how to import donations and importing transactions guides.