Skip to main content

Exporting Enrollees, Accounts, and Transactions to a Spreadsheet

Download your enrollee, account, or transaction data as a spreadsheet for reporting or bookkeeping

Written by Serena Edwards

To export a specific list of enrollees, use the Enrollees table. To export a list of active and inactive accounts, run an Accounts Export report. To export a list of all payment activity, run a Transactions Export report. Both reports are unlockable features — if you'd like access and they aren't already turned on for your account, let the Enrollsy team know via chat and they'll unlock them for you.

Exporting Enrollees

The Enrollees table lets you export a specific list of enrollees, rather than every account in Enrollsy. Follow these steps to download it:

  • Go to the Enrollees table, found under the Enrollments tab

  • Find the list of enrollees you want to export — this can be a saved view or a custom list (see how to create a custom report)

  • Select all or some of the enrollees in the list

  • Click the export icon (the cloud with an arrow) on the far right of the table

  • Choose to download just the data in your current view, or all data

Enrollsy Enrollees table with enrollees selected and export icon on toolbar

Exporting Accounts

  • Go to the Reports page.

  • Select Accounts Export.

  • This exports every account in Enrollsy to a CSV (comma-separated values) file, which you can sort and edit to pull the information you need. The export includes all accounts, even those created manually and not currently enrolled in any program.

Enrollsy Reports page with Account Export option highlighted

Accounts Export — What's Included

The Accounts Export report includes the following fields:

  • ID (ID of the specific account; searchable within Enrollsy)

  • Primary Account Holder Email

  • Primary Account Holder First Name, Middle Name, Last Name

  • Primary Account Holder Address

  • Primary Account Holder Phone Numbers

  • Primary Account Holder Contact Preference

  • Secondary Account Holder Email

  • Secondary Account Holder First Name, Middle Name, Last Name

  • Secondary Account Holder Address

  • Secondary Account Holder Phone Numbers

  • Secondary Account Holder Contact Preference

  • Emergency Contact

  • Emergency Phone

  • Active (shows "1" if the account is active; shows "0" if the account is inactive)

  • Notes

  • Created at

Accounts Export — Example

Here's what an Accounts Export looks like once downloaded:

Enrollsy account export spreadsheet showing account holder columns in Google Sheets

TIP: To use an export to spot duplicate accounts, see How to Find Duplicate Accounts.

Exporting Transactions

  • Go to the Reports page.

  • Select Transactions Export.

  • This exports every transaction in Enrollsy, along with the class or program tied to each payment, to a CSV spreadsheet.

  • Use this report to find transactions within a specific enrollment period, program, or class.

  • Import the resulting CSV into your accounting software to reconcile payments.

Enrollsy Reports page with Transactions Export option highlighted

Transactions Export — What's Included

The Transactions Export report includes the following fields:

  • ID (if applicable)

  • Processor transaction ID

  • Processor transaction amount

  • Amount

  • Last 4 (if the payment method is a credit card)

  • Type (payment method)

  • Posted at

  • Posted by

  • Item index

  • Item name (charge item)

  • Item type (fee)

  • Item amount

  • Private comment

  • Invoice memo

  • ACH status

  • Classification (payment account)

  • Account ID (ID of the specific account; searchable within Enrollsy)

  • Location

  • Invoice number

  • Enrollment period

  • Program option(s) - List all Program Options

Transactions Export — Example

Here's what a Transactions Export looks like once downloaded:

Enrollsy transaction export spreadsheet showing payment and invoice columns in Google Sheets
Did this answer your question?