IN THIS ARTICLE:
Learn about the Statements Report (FIN-7), its filter options, and how to generate it.
- What is the Statements Report?
- Available Formats
- General Filters
- Enrollment Filters
- Class/Camp Filters
- Ledger Filters
What is the Statements Report?
The Statements report generates family statements in bulk for #9 double window envelopes. Depending on your settings (under SETTINGS>FAMILY SETTINGS>STATEMENTS), this may include all charges on the family ledger (overdue, current, and future) or only current outstanding charges and may or may not be broken down into specific line items within charge entries.
NOTES:
- This generates reports for all families with outstanding charges. To run a statement for a single family, you must use the “Generate Statement” or “Email Statement” option from the family ledger. These options can be selected from the MORE ACTIONS menu on the full ledger view.
- Chosen filters that relate to enrollments will produce results that are true as of the date you generate the report.
- If you have selected Business as the Statement Type, you can upload a Business Statement Logo under SETTINGS>SETUP>FAMILY SETTINGS>CONFIGURE STATEMENTS.
- If you have selected Location as the Statement Type, you can upload a Location Statement Logo under SETTINGS>LOCATIONS.
Available Formats
The Statements Report is available in either HTML and PDF format.
General Filters
- SORT ORDER: determines how the generated statements are ordered.
- Last Name – sorts alphabetically by customer’s last name
- Zip – sorts numerically by customer’s Zip/Postal code
- 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.
- INCLUDE GLOBAL MEMO: if enabled, the system will include your customize “Global Memo” on each statement generated.
- Edit Global Memo – clicking this button will bring up the screen to edit your “Global Memo.”
Enrollment Filters
- PROGRAM: selecting a specific program will limit the statement results only to families with outstanding charges assigned to that program. (Leaving this filter blank will include all programs.)
- STATUS: this setting refers to the family’s enrollment status
- Active – returns only families that have at least one student with an active enrollment as of the day you run the statements.
- 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).
- Inactive - returns only families that have no students with active enrollments as of the day you run the statements.
- Active – returns only families that have at least one student with an active enrollment as of the day you run the statements.
Class/Camp Filters
- PRE-FILTER – the “Pre-filter” limits the results of the “Choose Class”/”Choose Camp” filter and only affects the options shown there. It does not affect any actual report results.
- CHOOSE INSTRUCTORS - select one or more Instructor(s) to limit the “Choose Class”/”Choose Camp” filters to only show classes/camps associated with the specified Instructor(s).
- NOTE: This option references permanently assigned instructors only.
- CHOOSE INSTRUCTORS - select one or more Instructor(s) to limit the “Choose Class”/”Choose Camp” filters to only show classes/camps associated with the specified Instructor(s).
- CHOOSE CLASS: selecting one or more specific classes will limit the results only to families with enrollments in the selected class(es) as of the day you run the statements.
- CHOOSE CAMP: selecting one or more specific camps will limit the results only to families with enrollments in the selected camp(s) as of the day you run the statements.
Ledger Filters
- CHARGE CATEGORY: selecting a specific charge category will limit the results only to families with outstanding charges assigned to the selected charge category. (Leaving this filter blank will include all charge categories.)
- AGED A/R: selecting a specific accounts receivable (A/R) range limits the results only to families who have charges where the charge due date falls within the chosen range.
- All A/R – all outstanding charges, regardless of whether or not they are past due.
- Current-15 – only charges less than 15 days past due or the due date has not yet been exceeded.
- 16-30 – only charges between 16-30 days past due.
- 31+ days - only charges between 31-60 days past due.
- 61+ days - only charges greater than 61 days past due.
- MINIMUM DUE: the results only to families who show an outstanding amount equal to or greater than the amount entered (defaults to $0.01).