Skip to main content
Financial Reports Explained

An overview of the financial reports that help you evaluate your income and outstanding payments.

Serena Edwards avatar
Written by Serena Edwards
Updated over 3 months ago

The following are all the types of Financial Reports you can generate in Enrollsy and descriptions of each one and what information they contain.

Invoices

There are a variety of ways to print Invoices. You can print a list of current or paid Invoices for multiple accounts, or just one account.

Invoices Page

The first way is on the Invoices page, located in the left-hand menu, which is a great place to see an overview of all current, paid, and future invoices. Use this tool to keep track of revenue collected and projected revenue.

On this page, you can view current Invoices, paid Invoices, and future Invoices.

Select Invoices on the left to print or export them.

Click on “Edit” on the right to view additional details of that Invoice.

Invoices can be filtered using the Filter button before exporting. You can filter Invoices in the following ways:

  • Payment Plan - Filter by Payment Plan name and view all those who currently have that specific Payment Plan.

  • Primary Account Holder - Filter by Primary Account Holder's first or last name.

  • Charges/Discounts - Filter by Charge Items (i.e., Tuition, Registration, Deposit, etc.) or Discounts (i.e., Sibling Discount, Scholarship, etc.)

Export Invoices (Invoices Page)

Select the Invoices to export on the left, then select the export button at the top right.

The following information will be exported:

  • Date

  • Days Past Due

  • Invoice number

  • Payment Plan

  • Amount

  • Status (i.e., paid, unpaid, etc.)

  • Invoice Balance

  • Enrollee Name

  • Enrollment

  • Class

  • Primary Account Holder's Name

  • Auto Payment Method (ACH or Credit Card)

  • Invoice Enrollee Name

  • Invoice Class Name

  • Invoice Class Location

  • Invoice Program

Print Invoices (Invoices Page)

Select the Invoices to print on the left, then select the print button at the top right.

The following information will be printed:

  • Company Name

  • Location & Location Address

  • Enrollment Period

  • Tax ID

  • Primary Account Holder's Name & Email Address

  • Enrollee Name

  • Invoice Number

  • Date

  • Amount

  • Item(s) (Charge Items and/or Discount Items)

  • Price (Cost)

  • Quantity

  • Total

  • Amount Paid

  • Amount Due

Example Invoice Print:

Customer Billing Page/Invoices

Admins can view and manage all current, paid, and future Invoices from the Billing page. Click "Manage" to open the Invoice editor to view and edit Invoices.

The Invoices editor window opens where you can view Current, Paid, or Future Invoices (click on one of the three options above to see the Invoices). You can edit any transactions within each Invoice by clicking "Edit."

Export Invoices (Customer Billing Page)

Select the Invoices to export on the left, then select the export button at the top right.

The following information will be exported:

  • Amount

  • Last 4 Digits of Credit Card or Bank Account

  • Payment Type

  • Date Posted

  • Posted By (Enrollsy, Admin User, or Account Holder)

  • Private Comments

  • Invoice Memo

  • ACH Status

  • Items (Charge Items or Discount Items)

  • Classification (Company Name)

  • Primary Account Holder Email Address

  • Primary Account Holder Name

  • Enrollee Name

  • Program Name

  • Class Names (first 10 Classes)

  • Location

  • Invoice Number

  • Invoice Class Name

  • Invoice Enrollee Name

  • Invoice Class Location

  • Invoice Program

  • Enrollment Period

  • Program Options

Print Invoices (Customer Billing Page)

Select the Invoices to print on the left, then select the print button at the top right.

The printed Invoices here contain the same information and look exactly like the Invoices printed from the Invoices page. See Print Invoices (Invoices Page)

to see what information the Invoice contains and an example.

Invoice Builder (Customer Billing Page)

Go to the Customer's Billing page. Next, select "Build Invoice Summary" at the top right of the Billing page.

Select one Location and Enrollment Period. NOTE: You can only choose ONE Location and ONE Enrollment Period. Next, choose the Enrollees whose Invoices you need to view. If there is only one, select the name so the builder will work.

You can choose which totals you want on the summary. You can include the totals related to the Enrollee(s) and/or all the Invoice totals.

The last step is to click "Build". You will then have the option to print a hard copy or download it as a PDF to circulate electronically.

The following information will be populated:

  • Location & Location Address

  • Enrollment Period

  • Tax ID

  • Primary Account Holder's Name and Email Address

  • Enrollee Name

  • Description (Charge Items and/or Discount Items)

  • Number of Payments

  • Amount Due

  • Total

  • Amount Paid

  • Invoices Total: Total / Amount Paid / Amount Due / Gift Card/Prepayments (if applicable)

Here's an example of how an Invoice Summary might look:

Statements & Summaries

Customers can only print or export statements while logged in using a browser - we recommend Chrome or Safari. The link they'll need is the Account Sign-In link found on the My Company page under Links. You can also embed the Account Sign-In link on your company website.

Customer Portal

Once signed in, here are the steps to print or export a tax statement:

  • Click on Transactions from the Menu.

  • Click the Printer icon at the top-right of the Transaction History, then select the Print Transaction Summary.

  • Select the dates of the Summary and click Load.

  • Select Print on the next screen. Choose either "Save as a PDF" or print the document from the Print screen. You can then email the statement as an attachment.

  • To export the Transaction History in its entirety to a spreadsheet, click the Export icon.

NOTE: Even if customers withdraw from your Program, they can still access their account.

Payment Receipt

Customers can also print receipts for payment on a web browser. Follow these steps to print a receipt for any transaction:

  • Navigate to the Transactions page. Find the transaction you want to print a receipt for.

  • Select the three dots beside the transaction. From the options that appear, select 'Create Receipt.' This will open the receipt in a new window.

  • Select Print twice to open up your Print Window. You can print it or download it as a PDF.

Example of Payment Receipt:

Admin Portal

If you do need to print a statement for a customer, here are the steps to do that:

  • Search for the customer in the search bar (by name, email, or phone).

  • On the customer's Billing page, scroll down to the Transaction History.

  • Click the Printer icon and then Print Statement or Print Transaction Summary at the top-right of the Transaction History.

  • Select the desired date range and click "Load" then "Print." Send the statement either to a printer or save it as a PDF to email.

  • Click the Export icon to export the Transaction History in its entirety to a spreadsheet.

Here is more information on the two options:

Transaction Statement

This statement shows (for a specified period) the following information:

  • Company Name & Contact Information (Address, Phone Number)

  • Company TIN/FEIN

  • Date & Time Printed

  • Date Range Printing

  • Primary Account Holder Name & Address

  • Statement Beginning Balance

For Each Transaction Listed:

  • Date & Time Posted

  • Program Name

  • Enrollee Name

  • Payment Method Type (ACH, Credit Card, Cash or Check)

  • Last 4 Digits of Card Number or Account Number

  • Items (Charge Items or Discount Items)

  • Details (Invoice Memo or Comments)

  • Amount

  • Balance

  • Statement Ending Balance

Example Transaction Statement:

Transaction Summary

This statement is a summary of all transactions made within a specified period.

  • Company Name & Contact Information (Address, Phone Number)

  • Company TIN/FEIN

  • Date & Time Printed

  • Date Range Printing

  • Primary Account Holder Name & Address

  • Statement Beginning Balance

For Each Transaction Listed:

  • Items (Charge Items or Discount Items)

  • Debits (Charges)

  • Credits (Credits and Discounts)

  • Total

  • Statement Ending Balance

Example Transaction Summary:

Exports (Accounts & Transactions)

To export a list of active and inactive accounts, run an Accounts Export Report. To export a list of all transactions, run the Transactions Export Report. See below for steps.

Account Export Report

First, make sure that Enrollsy has unlocked this feature for you. If you want this feature, and it’s not already unlocked, let us know via chat, and we’ll unlock it for you!

Go to the Reports page and select "Account Export." This will export all accounts within Enrollsy to a CSV spreadsheet. You can then sort and manipulate this report to pull the necessary information.

The "Accounts Export" report shows the following information:

  • 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 there is 1 active account; shows "0" if the account is inactive)

  • Notes

  • Created at

Example:


Transaction Export Report

First, make sure that Enrollsy has unlocked this feature for you. If you want this feature, and it’s not already unlocked, let us know via chat, and we’ll unlock it for you!

On the Reports page, select "Transactions Export." This will export all transactions within Enrollsy and the class or program tied to that payment to a CSV spreadsheet. You can then sort and manipulate this report to pull the necessary information. This will allow you to find all transactions within a specific Enrollment Period, Program, or Class.

You can then use this CSV to import payments into your accounting software.

The "Transaction Export" report shows the following information:

  • 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

Example:

Reconciliation Reports

Reconciliation reports would typically include a detailed overview of account activities and changes to ensure that all records are accurate and up-to-date. Here’s what such a report might include:

  • Payments Received: A list of payments received, including dates, amounts, and payment methods.

  • Outstanding Balances: A report on any outstanding balances, overdue payments, or discrepancies in payment records.

  • Refunds Issued: Details of any refunds given, including reasons and amounts.

  • Scholarships/Discounts Applied: A record of any scholarships, discounts, or financial aid applied to accounts.

The following are Reports you can run for the above information.

A/R Payments

Go to the Reports page and then A/R Payments. This Report shows all the payments (in green) for those with balances for the last three or 12 months.

Here’s what you can view this Report:

  • Account Names (Primary and/or Secondary Account Holders)

  • Contact info - Click the contact info icon to call or email the Account Holder

  • Payments made in the last 3/12 months depending on the timeframe chosen

  • Click on the down arrow beside the Payments to see more details

  • Total current balance (last column)

Here’s what you can do on this Report:

  • Send text messages to everyone on the Report by clicking the SMS bubble

  • Click the email icon to copy everyone’s email addresses

A/R Aging

Go to the Reports page and then A/R Aging. This Report shows all balances (in red) and credits (in green) and how past due each balance is.

Here’s what you can view this Report:

  • Account Names (Primary and/or Secondary Account Holders)

  • Contact info - Click the contact info icon to call or email the Account Holder

  • Total current balance (first column under "Total")

  • Balance that is 0 - 30 days old

  • Balance that is 30-60 days old

  • Balance that is more than 90 days old

Here’s what you can on this Report:

  • Choose a back date using the date picker (clock icon)

  • Send text messages to everyone on the Report by clicking the SMS bubble

  • Click the email icon to copy everyone’s email addresses

  • Export the Report (into a CSV/spreadsheet)

  • Click Past Due Notices to print or save past due notices

  • Print the Report (see how to print as a PDF here)

Transactions Report

If you need to run a report for any of the following, a Transactions Report may be what you need:

  • Payments made

  • Charges posted ("Debits")

  • Discounts given ("Credits")

  • Enrollees (students) and Programs/Classes enrolled in

The Transactions Report is available from the Reports page: Reports > Transactions. Follow these steps to create a Report of Transactions.

  1. If you have more than one Location, choose All Locations or a specific Location in the upper-right corner.

  2. Enter the dates you want to see transactions for and click Submit.

  3. Once you select the date range, the transactions are categorized in columns of transaction type:

    • Checks

    • Cash

    • Credit Card

    • ACH

    • Refunds

    • Charges

    • Credits

      Here is an example of the columns that populate:

      transaction report  in Enrollsy

      Click on the down arrow beside any of the columns to see all the transactions that happened on that day. For example, in the screenshot below, by clicking on the down arrow beside the charges "$300.90," you can view all the charges that made up that total.

Export Transactions Report

You can export this list to a ".csv" file that can be opened in Excel or Google Sheets (or any other spreadsheet software). The button is located at the top of the report.

The following are the headings that are exported and can be sorted and filtered in any spreadsheet program:

  • Amount - The dollar amount of the transaction

  • Last 4 of the credit card number

  • Payment Type - Charge, Credit, ACH, Credit Card, Refund, etc.

  • Posted Date - Date the transaction was posted

  • Posted By - Account Holder name, Admin name, or "Enrollsy" for automated transactions

  • Private Comment - Any comments that can be viewed by the Account Holders

  • Invoice Memo - Any internal comments

  • ACH Status - Shows ACH transaction statuses (i.e., pending, settled, rejected)

  • Items - The specific Charge Item name or Discount Item name (i.e. "Tuition," "Sibling Discount")

  • Classification - The company name

  • Account Email - The Primary Account Holder's email address

  • Account Name - The Primary Account Holder's first and last name

  • Enrollee Name - The Enrollee's first and last name

  • Program - The Program name associated with the transaction (if any)

  • "first10Classes - The first 10 Classes the Enrollee is enrolled in associated with the transaction (if any)

  • Location - The location the Enrollee is enrolled in

Print Transactions Report

From the transactions report (Menu > Reports > Transactions), you can print the results in a readable format from the top right.

View Revenue by Program

When Charges and Credits are initially placed at Enrollment, the Account will have an associated Program when running Transactions Reports. Payments, however, do not work this way (at this time).

If you are looking to see how much money you collected for a specific Program, you will have to do it by using Charges and Credits instead of Payments. Here's how you do that:

  • Step 1 - Run a Transactions Report for a specific date range

  • Step 2 - Export the Report to a CSV file

    In this exported file you will see a Program column along with a Type column. If the value in the Type column is a Charge or Credit, you will see a value for Programs. If the Type is a Payment, the Program will NOT be listed (see below).

  • Step 3 - Sort this spreadsheet according to your Charges and Credits to come up with your total revenue.

Coupon Code Report

When a Coupon Code is used, the code can be found in the "Details" column in the Customer's Transaction History, like this:

Coupon Codes are also saved under the default Discount "Misc Credit," which cannot be found on the Discount Report. Therefore, at this time, the best way to create a Coupon Code report is to run a Transactions Report and export it. Follow these steps:

Step 1 - Run Transaction Report

Run a Transactions report for the desired date range. Click here for instructions on how to run this report.

Step 2 - Download & Filter

Download the results to a CSV. Within Excel, filter to show only the rows of the type "Misc Credit." The Coupon Code will show up under the column "Invoice Memo."

Charge Items/Discount Items Report

The Charge Item Report shows you specific Charge Items that were charged during a specified period. Follow these steps to run a Report on specific Charge Items and/or Discount Items.

  • Go to the Reports page and click on Charge/Discount Items.

  • Choose the period (dates) you want to view on the calendar.

  • To see specific Charge Items or Discount Items, select the Item at the top then check the boxes of those items you want to see.

  • Once you have your list, click on the blue arrow under each item to see more specifics.

Export Charge Item/Discount Item Report

For a more granular report, export this report by selecting the download icon to the right of the report. The following information can be sorted and filtered on the spreadsheet:

  • Amount

  • Last 4 digits of Credit Card (if applicable)

  • Transaction Type (i.e., "Charge," "Credit Card," etc.)

  • Posted date

  • Private comment

  • Invoice Memo (includes Coupon Codes)

  • ACH status (i.e., "Pending," etc.)

  • Item (Charge Item or Discount Item name)

  • Classification (company name)

  • Account email address

  • Account Name (Primary Account Holder)

  • Enrollee Name

  • Program Name

  • First 10 Classes

  • Location

  • Invoice number

  • Invoice Class name (if the Invoice is for a specific Class)

  • Invoice Enrollee name (if the Invoice is for a specific Enrollee)

  • Invoice Class location (if the Invoice is for a specific Location)

  • Invoice Program (if the Invoice is for a specific Program)

Print Charge Item/Discount Item Report

When printing, you have these two options:

Transactions List

The Transactions List lists each transaction, along with the following information:

  • TIN/FEIN number (if added)

  • Company name and contact info

  • Time and Date of Report

  • Date Range selected

  • Customer Name (Primary Account Holder)

  • Posted date and time

  • Classification (Company name)

  • Program Name

  • Enrollee Name

  • Type of Transaction (i.e., "Charge")

  • Account

  • Item Name

  • Amount

Transactions Summary Report

The Transactions Summary Report summarizes the transactions under each Item Type with the associated amounts within the date range chosen.

Gateway Reports

ACHQ Gateway Reports

To login to your ACHQ (Electronic Check) Account, which is run through Speedchex, please login here.

When you completed your merchant account application, you should have received an email with login instructions for accessing Speedchex. If you did not receive this email or if you need to add someone else to your account, please send an email to onboarding@achq.com and request access.

TillPayments Gateway Reports

To login to your TillPayments (Credit Card) Account, please login here.

This portal contains a variety of reports and helpful information that you may choose to use for account reconciliation. Here are two resources to help you successfully utilize these resources.

When you completed your merchant account application, you should have received an email with login instructions for accessing the Till Merchant Portal. If you did not receive this email or if you need to add someone else to your account, please send the following information to us-support@tillpayments.com for each person to whom you would like to grant access:

  • Full name

  • Email address

  • Time zone

  • MID (Merchant ID, which you can find on your statements or in your welcome email)

CardConnect/CardPointe (Legacy Clients)

When you completed your merchant account application, you received an email with login instructions for accessing Cardpointe. If you have forgotten your password, please use the Forgot Password? link and enter the email address you used on your application or used in receiving statements.

You can log in to Cardpointe here. If you need to contact CardPointe support, go here.

Refunds

There are two ways to create a "Refunds Report." One is to run a Transactions Report, and the other is to run a Discount Item Report. We'll go through each of these methods below.

Transaction Report (Refunds)

  • Go to Reports > Transactions. Follow these steps:

  • If you have more than one Location, choose All Locations or a specific Location in the upper-right corner

  • Enter the dates you want to see transactions for and click Submit.

How to Read the Transactions Report

Once you select the date range, the transactions are categorized in columns of transaction type.

Click on the down arrow beside the Refund column to see all the transactions that happened on that day. For example, in the screenshot below, by clicking on the down arrow beside the refund "$237.10" you can view all the charges that made up that total.

You can also scroll to the end of the report and click on the down arrow beside "Refunds" to see ALL the transactions within the timeframe given.

  • Select the export button at the top right of the total Refunds window to export this list to a ".csv" file that can be opened in Excel or Google Sheets (or any other spreadsheet software).

  • The headings can be sorted and filtered in any spreadsheet program. Refunds will show up under the heading Payment Type.

  • You can also print the report by clicking the printer icon. You can print a hard copy or print the document as a PDF.

Discount Item Report (Refunds)

We suggest that you create a new Discount Item called “Refund Adjustment” or "Account Adjustment" and always use that item when doing refunds instead of a Misc. Credit.

To run a report on the new Refund Discount Item, head to the Reports page and click on Charge/Discount Items.

charge/discount items  in Enrollsy

Then follow these steps:

  • Choose the period (dates) you want to view on the calendar.

  • Select the down arrow beside "Discounts" at the top, then check the box of the Refund Discount Item. In this example, the Discount Item is called "Refund Adjustment."

  • This will populate a list. Click on the blue arrow under each item to see more specifics.

  • You can export and/or print this report by selecting the icons to the right.

Custom Report

If you need any of the following information, you can create a Custom Report on the Enrollees (or whatever you call those who enroll, i.e. "Students," etc.) Table.

Information Needed

How to Filter on the Enrollees Table

Inactive Accounts with balances within a specified timeframe

On the Account Tab, filter by "enrolled on date" and switch the Inactive switch on

Accounts paid in full for specific programs/specific classes

Filter columns based on balances and programs/classes

Accounts paid/paid invoices/total payments (paid in full or payment plans); per location/program/class OR Payments (income) by charge items

Filter columns based on payment plan name ("None" if paid in full)

Accounts due/balances

Filter by balance column

See this support article for how to create a Custom Report, which includes information on how to filter and sort the table.

Prepayment Report

Prepayment allows you to accept prepaid payments on future Charge Items such as tuition fees. By accepting prepayments, you give customers the option to prepay their fees in advance. Once a customer agrees to prepay the charges, they can make the payments at the time and frequency of their choice.

If you use Prepayments, you can view them on a Prepayment Report (this feature must be turned on by Enrollsy, so let us know if you need it).

Go to Reports > Pre Payments. Here you can change the date and/or time and export the information to a CSV.


Did this answer your question?