Fees Reports

This article will go over the various reports available for the tuition/fees module, as well as how to generate them.

This article will cover: 

• Fee Details 
• Account Balances 
• Account Statement 
• Daily Deposit
• Find Unpaid Fees
• Course Fees

Fee Details Report

The Fee Details report is used for reviewing a list of all fees posted to a single account within a time frame for students and/or employees. 

To generate a fee details report:

1. Go To School main > Tuition/Fees > Fee Details 
2. Configure the following fields from the report: 
   • Schools: Select a single school or multiple schools
   • Account: Choose the account to view fees for
   • Time Frame: Choose what time frame will be used when looking for fees
   • Who to show: Determines who the report will generate balances for
   • Category: Select all categories or a single category within the account
3. Configure the Options: 
   • Show all fees in one table: Choose to display all fees as a single running list. Deselecting this option will generate a table of fees per user rather than a single list. Selecting this option allows for the following four fields to be selected: 
     • (Non-lunch account only) For payments, also show associated category: Show the category the payment was applied to 
     • Show course subtotals for associated payments: Generate a payment total by course table
     • Show "Entered By" breakdown:  Generate a column to display which administrator created the fee
     • Subtotal by entering employee:Display a total fee amount for each administrator that created a fee
   • Show current account balance: Generates a column of how the fee amount affected the account balance
     • Show current account balance cannot be selected if show all fees in one table is selected
   • Show voided fees: Display fees that have been voided
   • Show notes: Show notes that have been entered by administrators
   • Show category subtotals: Display a total amount per category
   • Hide accounts with no fees: Opt to omit accounts with no fees when generating the report
   • Hide inactive students and employees: Choose to only display active users or to display both active and inactive users
   • Show school name: Displays the school name
   • Printable Page: Generate the report in a printer-friendly format
4. Generate 

Account Balances Report

The account balance report allows admins to view the current balance of students, employees, or both. For more information on the Account Balances report, please refer to the following article.

Account Statement Report

The account statement report is used to generate all activity within one more or accounts for students and/or employees. The account statement report can be generated in several formats, including as a printable letter. 

To generate an account statement report: 

1. Go To School Main > Tuition/Fees > Account Statement
2. Configure the following fields from the report: 
   • Title: Edit the title of the report
   • Account: Choose one or more accounts 
   • Time Frame: Choose what time frame to use 
   • Who to show: Determine who the report will generate statements for
   • Where Shown: Choose the format of the report when generated
   • Sort By: Determines how the information will be sorted on the report
3. Customize the report Options: 
   • Balances below or Balances above: The report will generate accounts with balances below or above the entered amount 
   • Show free students, show reduced students, or show paid students: The report will show students who pay full-priced lunch or who have free or reduced lunch
   • Show homeroom instructor: View each student’s homeroom instructor if assigned
   • Show school: Check to enable the school name to appear on the report
   • Show school address: View the school’s address on the report
   • Show voided fees: Display fees that have been voided
   • Show notes: Show notes that have been entered by administrators
   • Show total: Display an account summary table for each user
   • Hide accounts with no fees: Opt to omit accounts with no fees when generating the report
   • Hide inactive students and employees: Choose to only display active users or to display both active and inactive users
   • Show school name: Displays the school name
4. Generate 

Daily Deposit Report

The Daily Deposit report is used for reviewing a list of deposits made to accounts by students and/or employees. Additionally, the report can show transfers made between schools and/or between in-school accounts.  

To generate a Daily Deposit report:

1. Go To School Main > Tuition/Fees > Daily Deposit
2. Configure the following fields from the report:   
   • Schools: Choose to see deposits within one school or multiple 
   • Account: Choose one or more accounts 
   • Time Frame: Choose what time frame to use 
   • Who to show: Determine who the report will show deposits from
   • Run Report By: Show summary or daily totals sorted by account or payment type
3. Customize the report Options: 
   • Hide zero totals: Omit payment or account types with no deposits 
   • Show entered by breakdown: Show which administrator entered the deposits by total amount entered
   • Show school name: Display the school name
   • Show Transfers To/From Other Schools: Display transfers that have been made to or from other schools
   • Include In-School Transfers in Account Totals: Display transfers that have been made between accounts within the school
   • Printable Page: Generate the report in a printer-friendly format
4. Generate

Find Unpaid Fees Report

The Find Unpaid Fees report is used for finding students and/or employees that have unpaid fees. The report offers a variety of filters so that unpaid fees can be reviewed by category and time frame. This report can also be used to show users who have unapplied payments in their accounts.

To generate a Find Unpaid Fees report:

1. Go To School Main > Tuition/Fees > Find Unpaid Fees
2. Configure the following fields from the report:
   • Account: Choose the account 
   • Category: Select the category within the account 
   • Who to show: Determine who the report will generate for
   • Time Frame: Choose what time frame to use 
3. Customize the report Options: 
   • Only show if unapplied payments exist: Display only students and/or employees who have unapplied payments in their accounts
   • Show all fees in one table: Generate a single list of unpaid fees. Deselecting this will generate a table per user 
   • Show category subtotals: Display a total amount per category
   • Show current account balance: Generate a row that shows the user’s current account balance
   • Show notes: Show notes that have been entered by administrators
   • Hide inactive students and employees: Display active users only
   • Show school name: Display the school name
   • Printable Page: Generate the report in a printer-friendly format
4. Generate

Course Fees Report

The Course Fees report is used for reviewing a list of course fees charged to students. The report can list these fees by course, grade level, or subject.  

To generate a Course Fees report:

1. Go To School Main > Tuition/Fees > Course Fees
2. Configure the following fields from the report:
   • What to show: decide to show fees by course, grade level, or subject
   • Options: choose whether to display school name and whether to make the report a printable page
3. Generate