What is the Families With Unapplied Credit Balances Report (FIN-12)? – iClassPro Support

IN BRIEF
The Families With Unapplied Credit Balances Report (FIN-12) provides a list of families who have payments or credits on their accounts that have not been applied to charges. Administrators can use this report to identify unapplied funds, reconcile balances, and better understand how credits relate to enrollment activity as of a specific date.

Overview
- Important Notes
- Available Report Formats
Accessing the Report
Step-by-Step Instructions
Troubleshooting & FAQs
Related Articles

Overview

The Families With Unapplied Credit Balances Report displays families who have payments or credits that are not currently applied to charges on their accounts. This report is commonly used during reconciliation to locate unapplied funds and to distinguish between true credits and payments that may be applied to future-dated charges.

Important Notes

Any filters related to enrollments produce results that are true based on the As of Date selected when generating the report.
Enrollment-related filters evaluate enrollment status in relation to the selected As of Date, not the current date.

Available Report Formats

HTML
PDF
XLS
CSV

Accessing the Report

From the main navigation menu, go to Reports.
Select Families With Unapplied Credit Balances Report (FIN-12) from the list.

Step-by-Step Instructions

Navigate to the Families With Unapplied Credit Balances Report (FIN-12).
Configure the desired report filters.
Select the preferred output format to generate the report.

General Filters

As of Date
- The System displays families with unapplied payments or credits as of the selected date.
- Results are evaluated based on the Include All Transactions setting.
Include All Transactions
- Before As of Date
  - The System checks whether payments or credits were applied to transactions on or before the selected As of Date.
- After As of Date
  - The System checks whether payments or credits were applied to transactions after the selected As of Date, even if they were unapplied on that date.
  - This option is useful for identifying “real credit” when future-dated charges already have payments applied.
Locations
- Limits results to charges and payments associated with the selected Location(s).
- For reconciliation purposes, these should match the Location(s) selected on the Category List Report and the Program Deposit Split Report.
Display Options
- Landscape
  - Generates the report in landscape orientation instead of portrait.

Enrollment Filters

Status (Enrollment)
- Currently Enrolled (Active)
  - Includes families or students with an ACTIVE enrollment in classes or camps on the selected As of Date, regardless of past or future enrollment status.
- Enrolled in the Future (Only)
  - Includes families or students without an ACTIVE enrollment on the As of Date, but with an ACTIVE enrollment after that date.
- Previously Enrolled (Only)
  - Includes families or students without an ACTIVE enrollment on the As of Date, but with an ACTIVE enrollment prior to that date.
- Never Enrolled
  - Includes families or students with no recorded ACTIVE enrollments in classes or camps.
Choose Program
- Selecting one or more programs limits results to families with ACTIVE enrollments in classes or camps assigned to the selected program(s) on the As of Date.
- Leaving this filter blank includes all programs.

Camp Enrollment Considerations

Camp enrollments are considered ACTIVE for a continuous date range.
The active period starts with the first selected camp block and ends with the last selected camp block.
- For example: A student enrolled only on May fifth and May eighth is considered ACTIVE from May fifth through May eighth, including May sixth and May seventh.

Generating the report

Confirm your filters.
Select your preferred format (HTML, PDF, XLS, or CSV) to generate the report.

Troubleshooting & FAQs

Why do enrollment-based results change when I adjust the As of Date?
- Enrollment-related filters evaluate enrollment status relative to the selected As of Date, not the current date. Changing this date can alter which enrollments are considered ACTIVE.
When should I use the “After As of Date” option for Include All Transactions?
- This option is useful when reviewing future-dated charges that already have payments applied, helping identify true unapplied credit.
Why should Location filters match other reconciliation reports?
- Matching Location selections across related reports ensures consistent data when reconciling balances and deposits.