Account Balance report

Overview

Use the Account Balance report (Accounts Receivable) to see which families still owe money for a selected season or program group and how those balances compare to their scheduled payments.

The report lists all families with a non-zero balance for the selected season, along with contact details, registration information, charges, scheduled payments, and current balance.

What the report shows

The Account Balance report is scoped by season/program group. It includes only families with a non-zero balance for the selected season or program group(s).

Each row represents a family account and includes:

• Key identifiers (family name and account number)

• Registration context (plan, registration date, campers, products)

• Contact information

• Financial totals (charges, scheduled payments, and outstanding balance)

Use it alongside your scheduled payments and deposit reports to monitor whether what is owed is actually planned to be collected.

Filters

Season / program group

The primary filter is Season / program group.

• Season / program group: Select the season or program group you want to review. The report then shows families with non-zero balances for that selection.

If you use multiple program groups within a season, run the report once per group if you want to focus on a specific camp or program.

Columns in the Account Balance report

This section describes the main columns you will see for each family row.

Family and registration details

• Name: The family account name.

• Account Number: The internal account identifier for the family.

• Plan: The payment plan or arrangement associated with the family’s registration for the selected season or program group.

• Registration Date: The date the family completed registration for that season or program group.

• Campers: The campers linked to this family’s registration for the selected season.

• Products: The camp sessions, add-ons, or other products tied to the family’s registration.

Contact information

• Primary contact info: The primary contact details for the family, typically including email and phone, so you can reach out about outstanding balances or payment plan changes.

Financial totals

• Charges: The total charges for this family for the selected season or program group. This is what the family owes before payments.

• Scheduled: The total amount of future scheduled payments for this family that have not yet been completed for the relevant charges.

• Balance: The current outstanding balance for the family for the selected season or program group, after payments and credits.

Red-row mismatch warning

When you see a red row:

• Review the family’s scheduled payments and payment plan.

• Confirm whether additional payments need to be scheduled, or if charges, discounts, or manual payments need adjustment.

• Follow up with the family if the plan does not fully cover the remaining balance.

Red-highlighted families are your priority list for fixing gaps between what is owed and what is currently planned to be collected.

Run the report

How to use this report in your workflow

Use the Account Balance report regularly during your season to:

• Identify families with outstanding balances that are not fully covered by scheduled payments (red rows).

• Confirm that families on plans have enough future payments scheduled to cover their balances.

• Prioritize outreach to families who need updated payment plans or additional payments before session start dates.