What is the Aged Accounts Report (FIN-1)?

IN THIS ARTICLE:
Learn about the Aged Accounts Report (FIN-1), its filter options, and how to generate it.

What is the Aged Accounts Report?

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 Formats

The Aged Accounts Report is available in either HTML, PDF, XLS or CSV format.

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).
    • Display Results for 1-15 Days Past Due: will include separate columns for charges that are 1-15 and 16-30 Days Past Due on the completed report.  Leaving this option disabled includes a single "1-30" Days Past Due column instead.

Enrollment Filters

  • STATUS (ENROLLMENT):
    • Currently Enrolled (Active) – Choose this option to include families/students that have an "ACTIVE" type enrollment in classes/camps on the “As of Date” (regardless of past or future enrollment status)
    • Enrolled in the Future (Only) – Choose this option to include families/students that do not have a current "ACTIVE" type enrollment in classes/camps on the “As of Date” but do have an "ACTIVE" type enrollment after that date.
    • Previously Enrolled (Only) – Choose this option to include families/students that do not have a current "ACTIVE" type enrollment in classes/camps on the “As of Date” but did have an "ACTIVE" type enrollment prior to that date.
    • Never Enrolled – Choose this option to include families/students which have no recorded "ACTIVE" type 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 "ACTIVE" type 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 "ACTIVE" type enrollments in the selected camp(s) on the “As of Date.” 
    • NOTE: Camp enrollments are considered ACTIVE in a camp for a period of time starting with the first block they have selected and ending with the last block. Therefore, if a student is enrolled only on May 5th and May 8th, their enrollment will be considered active from May 5th-May 8th (also encompassing May 6th and 7th).

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.)

Display Options

  • SHOW
    • Only Families With Past Due Charges - enabling this option will limit the results to only families with charges that are past their specified due date.
    • Display Results for 1-15 Days Past Due - enabling this option will list results for families with charges that are 1-15 days past their specified due date in a separate column.
  • PRINT LAYOUT
    • Landscape

Need more assistance?

Customer support is available at 1-877-554-6776 Mon - Fri, 9 am to 9 pm (CT) and Sat, 9 am to 6 pm (CT).