Skip to main content

How to View Customer Payments & Balances

Five ways to view balances, payments, and Accounts Receivable reports

Written by Serena Edwards

There are several ways to see a Customer's balance in Enrollsy: the A/R Aging Report, the Invoices page, the A/R Payments Summary, the Enrollee Table, and the Transactions Report. Each section below explains what it shows and how to use it.

A/R Aging Report — Viewing Overdue and Current Balances

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

A/R Aging Report in Enrollsy showing account balances and the print, export, and past due notice icons

What you can view on 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 31–60 days old, balance that is 61–90 days old, and balance that is more than 90 days old.

Contact info popup in Enrollsy showing options to call or email an Account Holder

What you can do 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 or spreadsheet, click Past Due Notices to print or save past due notices, and print the report as a PDF (see Saving and Editing Reports as a PDF). You can also use this report to compare outstanding balances against processed payments and pending ACH payments, providing a comprehensive view of financial data.

Invoices Page — Viewing Current, Paid, and Future Invoices

Go to the Invoices page. Here you can view Current Invoices, Paid Invoices, and Future Invoices.

To view past due or due now invoices: first ensure you're in the proper Location (if you have more than one) in the upper-right corner, then change the dates in the Calendar, then click the Current Invoices box to see invoices that are either past due or due now.

Invoices page in Enrollsy with the Location selector, calendar dates, and Current Invoices box for viewing past due invoices

What you can do on this page: select invoices on the left to print or export them. To calculate the total outstanding balance as of a specific date, adjust the calendar to the target date, click the Current Invoices box to view invoices due or past due, and export the data. The exported file will include invoice details and balances, which you can sum to determine the total outstanding balance.

NOTE: Invoice totals may not always match the account balance because some charges may not appear on an invoice. This distinction is important when calculating outstanding balances.

Invoices page in Enrollsy showing selected invoices with the print and export icons

Click Edit on the right to view additional invoice details.

Invoices page in Enrollsy showing the Edit button used to view invoice details

You can also click the Primary Account Holder's name to go to that account's Billing page, click the Enrollee's name to go to that Enrollee's timeline, or click the Class to go to that class on the Classes page. You can also see who has Auto-Pay on or off — if it says Credit Card or ACH, Auto-Pay is on for that payment method; otherwise, it will say Off.

A/R Payments Summary — Viewing Payment History

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

A/R Payments Summary report in Enrollsy showing customer payment history by month

What you can view on this report: account names (Primary and/or Secondary Account Holders) and contact info (click the contact info icon to call or email the Account Holder).

Contact info popup in Enrollsy showing options to call or email an Account Holder

Payments made in the last 3 or 12 months, depending on the timeframe chosen.

Timeframe dropdown in the A/R Payments Summary report in Enrollsy showing 3 and 12 month options

Click the down arrow beside a payment to see more details.

A/R Payments Summary report in Enrollsy showing expanded payment details for an account

Also shown: total current balance (last column).

What you can do on this report: send text messages to everyone on the report by clicking the SMS bubble, and click the email icon to copy everyone's email addresses.

NOTE: The A/R Payments Summary page cannot be printed or exported directly. As a workaround, you can drill into each account from the summary page to export or print at the account level. Alternatively, consider using the A/R Aging Report for broader summaries.

Enrollee Table — Creating a Custom Balance Report

You can also create custom reports on the Enrollee Table page, including sorting columns based on balances and sending SMS messages (for past due notices, for example).

NOTE: The Balance due column cannot be displayed under the Enrollees Tab as column customization is not available there. However, column customization is supported in the Enrollments Tab, allowing you to tailor the view to your needs.

Steps to create a custom report:

  1. Click Columns at the top and ensure Balance is checked under Account.

    Enrollee Table page in Enrollsy showing the Columns menu with Balance checked under Account

  2. Click Balance twice to reorder the red balances to the top.

    Enrollee Table page in Enrollsy showing balances sorted with the highest amounts at the top

  3. Select the accounts you want to text, then click the bulk SMS icon.

  4. Click the email icon to copy all their email addresses, paste them into your BCC field, and send a message from your email account.

If you're sending an overdue balance message, here is an example: "You have an overdue balance. Please log in to [LINK TO ACCOUNT LOGIN] to pay your balance."

What you can do on this report: post Tags, post bulk Invoices or Credits, post bulk Payments, download or print data, and send SMS messages.

Transactions Report — Viewing All Payment Transactions

On the Reports page, click Transactions. 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.

Transactions are categorized by type: Checks, Cash, Credit Card, ACH, Refunds, Charges, and Credits.

Click the down arrow beside any column to see all the transactions for that day.

Transactions Report in Enrollsy showing a breakdown of charges for a selected day

You can print the results by clicking the printer icon, or export the list to a CSV file by clicking the export icon. Exported columns include:

  • 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 internal comments

  • Invoice Memo - Any comments that can be viewed by the Account Holders

  • 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

Troubleshooting Payment and Balance Discrepancies

Understanding Financial Terms: Past-Due Invoices vs. Account Balances

  • Past-Due Invoices: These are specific billed invoices that haven’t been paid by their due dates.

  • Past-Due Account Balances: These reflect everything currently owed on the account, including items not tied to an invoice (e.g., convenience fees or other account-only transactions).

To see exactly what a person owes, review their transaction history balance or use the account balance in reporting.

If an account shows a balance after successful payments, it is essential to understand how payments are applied and verify the charges:

  1. Partial Payment Application: A successful payment may only cover part of an invoice, leaving an outstanding balance. This is common when the payment amount is less than the total charges.

  2. Transaction History Review: To verify the balance, review the account's transaction history. Add up all charges and subtract the payments to ensure the resulting balance matches the account balance.

  3. Failed Payments: Note that failed payments are not included in the total of successful payments. Ensure all payments have been processed successfully.

  4. Outstanding Balance: If the charges are accurate and payments do not fully cover them, the remaining balance is still owed.

Did this answer your question?