Aged Accounts Report (FIN-1)

Available formats: HTML/PDF/XLS/CSV

The Aged Accounts Report is a list of families who have outstanding balances on their accounts.

NOTE: Chosen filters that relate to enrollments will produce results that are true based on the “As of Date” you select when generating the report.

Available filters are:

General Filters

  • AS OF DATE: the system will only show families with unpaid charges as of this date.
  • LOCATIONS: the system will only include charges/payments associated with the selected Location(s) in the results. (In order to reconcile the report, these should match the Location(s) chosen for your Category List Report and Program Deposit Split Report.)
  • DISPLAY OPTIONS:
    • Show Only Families With Past Due Charges: the system will only list families who have charges where the due date of their charge is before the selected “As of Date.”
    • Landscape: will generate the report in Landscape mode (rather than Portrait). 

ENROLLMENT FILTERS

  • STATUS (ENROLLMENT):
    • Currently Enrolled (Active) – Choose this option to include families/students that are enrolled in classes/camps on the “As of Date” (regardless of past or future enrollment status)
    • Enrolled in the Future (Active) – Choose this option to include families/students that are NOT enrolled in classes/camps on the “As of Date” but are enrolled after that date.
    • Previously Enrolled (Active) – Choose this option to include families/students that are NOT enrolled in classes/camps on the “As of Date”, but were enrolled prior to that date
    • Never Enrolled – Choose this option to include families/students which have no recorded enrollments in classes/camps.
  • CHOOSE PROGRAM: selecting one or more specific programs will limit the results only to families with active enrollments in classes/camps assigned to the selected program(s) on the selected “As of Date.” (Leaving this filter blank will include all programs.)
  • KEYWORD: select a Keyword to limit the report to only families who are associated with a particular Keyword.
    • Family Keywords – the family keyword must be assigned to the family
    • Student Keywords – the family must have at least one student with with the selected keyword assigned.
    • Class Keywords – the family must have a student with an active enrollment in a class with the selected keyword assigned.
    • Camp Keywords – the family must have a student with an active enrollment in a camp with the selected keyword assigned. 

Class/Camp Filters

These filters are used in conjunction with the “Enrollment Status” filters to determine whether you want the system to look at enrollments in Active or Inactive classes. (By default, the system will only look at Active classes.)

  • STATUS:
    • Active – the status on the class is currently set to “Active”
    • Inactive – the status of the class is currently set to “Inactive”
  • CHOOSE CLASS: selecting one or more specific classes will limit the results only to families with enrollments in the selected class(es) on the “As of Date.”
  • CHOOSE CAMP: selecting one or more specific camps will limit the results only to families with enrollments in the selected camp(s) on the “As of Date.” 

Ledger Filters

  • CHOOSE PROGRAM: selecting one or more specific programs will limit the results only to charges assigned to the selected program(s) and payments which were applied to them within the specified date range of the report. (Leaving this filter blank will include all programs.)
  • CHOOSE CHARGE CATEGORIES: selecting one or more specific charge categories will limit the results only to charges assigned to the selected charge category/categories and payments which were applied to them within the specified date range of the report. (Leaving this filter blank will include all charge categories.)

Need More Assistance?

Call us at 877-554-6776. Our business hours are Mon-Fri 9am-6pm Central Standard Time.