What is the Category List Report (FIN-6)?

IN THIS ARTICLE:
Learn about the Category List Report (FIN-6), its filter options, and how to generate it.

What is the Category List Report?

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, Location associated with the charge, taxes charged, 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 Formats

The Category List Report is available in either HTML, PDF, XLS or CSV format.

Due to the amount of data returned, the option to generate this report in XLS format is only available if the date range is two months or less. If you need to generate a report greater than two months, you will need to generate the report as HTML, PDF, or CSV instead.

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.)
  • KEYWORDS: 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.

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.
    • NOTE: This filter references permanently assigned instructors only.
  • 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.)

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.)
  • SHOW
    • Source of Charge - If enabled, will display a column noting whether the charge was created from the:
      • Customer Portal
      • Office Portal (via one of the following methods)
        • Transaction Page
        • Enrollment Wizard
        • Manual
    • Early Bird Discounts - If enabled, an “Early Bird” column will be added to the report to reflect potential Early Bird discounts that may be applied if the charge is paid in full prior to the defined Early Bird Date.
      • NOTE: Early Bird is estimated based on when charge is created and only added to the total discounts when charge is fully paid.
  • PRINT LAYOUT
    • Landscape: will generate the report in Landscape mode (rather than Portrait). 

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