Category List Report (FIN-6)

Available formats: HTML/PDF/XLS/CSV

The Category List Report is a list of charges that were created or deleted within a specified date range (determined by the “Charge Date”), along with indicators as to whether the charges are paid/unpaid and any remaining balance on the charges.

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

  • START DATE/END DATE: the system will only show charges with a “Charge Date” that falls within these days.
  • 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.)
  • 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 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.
  • DISPLAY OPTIONS:
    • Include All Collected Payments: enabling this setting will consider all payments applied to charges when determining paid/unpaid status, regardless of whether the payment was made within the specified Start/End dates. (By leaving this option disabled, the system will determine this status as of the specified end date.)
    • Landscape: will generate the report in Landscape mode (rather than Portrait). 

Class/Camp Filters

NOTE: Selecting filters in this section takes enrollments into consideration, and therefore will result in the system only looking at Tuition Charges. This may override options selected in the “Ledger Filters” section.
If you are looking for “Other” line item type charges, leave this section blank.

  • STATUS:
    • Active – the status on the class is currently set to “Active”
    • Inactive – the status of the class is currently set to “Inactive”
  • CHOOSE INSTRUCTOR: selecting one or more specific classes will limit the results only to families with enrollments in class(es)/camp(s) within the specified Start/End dates and that have the selected Instructor(s) assigned.
  • CHOOSE CLASS: selecting one or more specific classes will limit the results only to families with enrollments in the selected class(es) within the specified Start/End dates.
  • CHOOSE CAMP: selecting one or more specific camps will limit the results only to families with enrollments in the selected camp(s) within the specified Start/End dates.

Ledger Filters

  • PAID/NOT PAID:
    • Paid – the system will only list charges that are paid as the specified End date of the report. (If “Include All Collected Payments” has been checked the system will consider all payments.)
    • Not Paid – the system will only list charges that are unpaid as of the specified End date of the report. (If “Include All Collected Payments” has been checked the system will consider all payments.)
  • 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 CATEGORY: 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.