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

IN BRIEF
The Category List Report (FIN-6) generates a list of charges created, adjusted, or deleted within a selected date range, based on the Charge Date. The report can include paid/unpaid status, Location information, tax details, and remaining balances. Administrators use this report to review charge activity, reconcile financial data, and audit entries tied to specific programs, categories, instructors, or enrollments.

Overview
Accessing the Report
Step-by-Step Instructions
Troubleshooting & FAQs
Related Articles

Overview

The Category List Report displays all charges created, adjusted, or deleted within a specified date range. The System uses the Charge Date to determine which entries fall within the selected range. The report can also identify:

Whether charges are paid or unpaid
The Location associated with each charge
Any taxes applied
Remaining balances

If any filters that relate to enrollments are enabled, the results are generated based on the As of Date selected at the time of report generation.

Accessing the Report

From the main navigation menu, go to Reports.
Select Category List Report (FIN-6) from the list.

Step-by-Step Instructions

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.
- Event Keywords – the family must have a student with an active enrollment in an event with the selected keyword assigned.
CLASS/EVENT STATUS
- Active – will limit the report to only families with outstanding charges who have students with enrollments in classes/events that are currently marked “Active.”
- Inactive – will limit the report to only families with outstanding charges who have students with enrollments in classes/events that are currently marked “Inactive.”

Enabling one or both of the "Class/Event Status" options will automatically limit the report results to tuition-type charges associated with the selected Charge Categories.

CHOOSE INSTRUCTOR - select one or more Instructor(s) to limit the “Choose Class”/”Choose Event” filters to only show classes/events associated with the specified Instructor(s).
- NOTE: Entries will not be included on the final report for any selected instructor/staff member who was not associated with specified enrollments, activities, etc., during the designated date/date range.
  - If an instructor was deleted AFTER the start date of the report, the results will include relevant entries for the instructor on the date(s) before they were deleted.
  - If an instructor was created/attached to an activity AFTER the end date of the report, the instructor will not be included in the results.

Class/Event Filters

Changing the date range of the report AFTER making any Pre-filter selections may cause some of the selections to become invalid. These selections will not be reflected on the final report.

PRE-FILTER – the “Pre-filter” limits the results of the “Choose Class”/”Choose Event” filter and only affects the options shown there. It does not affect any actual report results.
- CHOOSE INSTRUCTOR - select one or more Instructor(s) to limit the “Choose Class”/”Choose Event” filters to only show classes/events associated with the specified Instructor(s).
  - NOTE: Entries will not be included on the final report for any selected instructor/staff member who was not associated with specified enrollments, activities, etc., during the designated date/date range.
    - If an instructor was deleted AFTER the start date of the report, the results will include relevant entries for the instructor on the date(s) before they were deleted.
    - If an instructor was created/attached to an activity AFTER the end date of the report, the instructor will not be included in the results.
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 EVENT: selecting one or more specific events will limit the results only to families with enrollments in the selected event(s) within the specified Start/End dates.

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 "Anniversary" or “Other” line item type charges, leave this section blank.

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

Select Report Format

After reviewing your selected filters, the Aged Accounts Report can be generated in the following formats:

HTML
PDF
XLS
CSV

Select your preferred format to generate the report. Note that if the report date range encompasses more than two months, XLS will not be an available format.

How Adjusted Charges Appear

When an ADJUSTMENT or ADJUSTMENT - BAD DEBT line item is applied to a charge, both the original charge and the adjustment are shown on the dates they actually occurred. A later adjustment no longer reduces the historical total of the original charge.

Values

Each adjustment is attributed to the Program/Charge Category of the line item it was applied to. The Amount column shows the base portion of the adjustment as a negative value, and the Tax column shows the uncollected tax removed as a negative value. The Total column is the sum of the two. The Due column shows a negative value, as does Past Due where the charge meets the report’s past due criteria for the selected range.
The Amount column is not made gross. Amount and Tax are separate figures that add up to Total, so an adjustment is never double-counted.
If a charge contains line items in more than one Program/Charge Category and each has been adjusted, each adjustment reports against its own category rather than the full reduction landing on one.
Adjustments and their tax reductions report in the period containing the adjustment date, evaluated in your account’s time zone. The original charge and its tax are not restated in the period the charge was created. A charge billed in one month and written off in the next therefore appears at full value in the first month and as a negative adjustment in the second.

Charges section

An original charge whose date falls in the selected range is shown at its full original amount, even when it was adjusted later.
An adjustment whose date falls in the selected range is shown as its own row.
Where both dates fall in the range, the charge and the adjustment appear as two separate rows.
An Adjusted column appears between the Title and Amount columns.
On an original charge row, the Adjusted column reads Adjusted on [date]. Where a charge has more than one adjustment, the dates are listed together in chronological order, separated by commas — for example, Adjusted on 7/1/2026, 7/8/2026, 7/9/2026.
On an adjustment row, the Adjusted column reads Adjusted [date], showing only that adjustment’s own date.
Dates use your account’s time zone and follow the Preferred Date Format set under SETTINGS > BUSINESS INFORMATION.
ADJUSTMENT - BAD DEBT line items use the same wording as regular adjustments.

Deleted/Adjusted Charges section

A charge that was adjusted within the selected range appears in this section at its original, pre-adjustment amount, with a note in the Deleted/Adjusted column reading Adjusted on [date], using the same formatting as the Charges section. Deleted charges continue to behave exactly as before.

Existing adjustments

ADJUSTMENT line items created before this release, including those generated by Point of Sale returns, are shown under the same display rules. No historical data was changed, and no tax was retroactively corrected on them.

Troubleshooting & FAQs

Why are some charge categories or programs missing from my results?
- Class/Event filters restrict results to Tuition Charges. If you need Other type charges, leave the Class/Event Filters section blank.
Why does XLS format not appear as an option?
- XLS export is only available when the report covers two months or less. Select HTML, PDF, or CSV for longer date ranges.
Why is an instructor missing from the report?
- Instructor records follow date logic:
  - If added after the End Date, they will not appear.
  - If deleted after the Start Date, their earlier entries will still be included.
Why does the paid/unpaid status not match what I expect?
- If All Collected Payments is enabled, the System considers all payments ever applied, not just those within the selected date range.
Why does this report show a negative amount for a charge?
- An ADJUSTMENT or ADJUSTMENT - BAD DEBT line item was applied within the selected date range. The negative value is the reduction and the uncollected tax removed with it, reported on the date the adjustment was made.
Why does the original charge still show at full value in an earlier month?
- Adjustments report on the date they occur. The original charge is not restated in the period it was created, so totals for closed periods stay accurate.
Why is a charge I did not delete showing in the Deleted/Adjusted Charges section?
- That section now tracks adjusted charges as well as deleted ones. An adjusted charge appears there at its original pre-adjustment amount, annotated with the date of the adjustment.