Scholarship / financial aid report

This report displays a list of scholarships granted to customers and the usage of their scholarships.

For each scholarship, it lists the customers granted the scholarship, start and expiration date of the grant, amount of the scholarship grant, amount redeemed, and scholarship balance.

For customers who have used their scholarship, the report will list transaction details (for example, name of the activity enrolled in), transaction amount, and transaction dates.

Location

Reports > Financial Reports > Scholarship

Clicking the Recall / Schedule a saved report definition button at the top of the page takes you to the Report Definitions page, where you can select a previously saved report definition.

SCHP Filters

SCHP

1. Click the SCHP link to pop-up the Charges page.

2. From the Charges page, select the charges.

3. Click Add All Selected. To remove the charges, you can select the charge in the list box then click Remove at the right side.

Start Date Range

1. Click the calendar icon beside the From box and select a Beginning Date of the start date from the pop-up calendar.

2. Click the calendar icon beside the To box and select an Ending Date of the start date from the pop-up calendar.

3. The Day of Week field beside the calendar icon will automatically be completed.

Expiration Date Range

1. Click the calendar icon beside the From box and select a Beginning Date of the expiration date from the pop-up calendar.

2. Click the calendar icon beside the To box and select an Ending Date of the expiration date from the pop-up calendar.

3. The Day of Week field beside the calendar icon will automatically be completed.

Transaction Date/Time

1. Click the calendar icon beside the From box and select a Beginning Date of the transaction from the pop-up calendar.

2. Click the calendar icon beside the To box and select an Ending Date of the transaction from the pop-up calendar.

3. The Day of Week field beside the calendar icon will automatically be completed.

Percentage Remaining Range

1. Enter in the From box the Beginning Percentage for the remaining range.

2. Enter in the To box the Ending Percentage for the remaining range.

Donor Company      

1. Click the Donor Company link to pop-up the Company Search page and then enter some criteria to select the companies. The company search results will be displayed on the Select Company List page.

2. From the Select Company List page, select the companies.

3. Click Add All Selected. To remove the companies, you can select the company in the list box then click Remove at the right side.

Donor Customer  

1. Click the Donor Customer link to pop-up the Customer Search page and then enter some criteria to select the customers. The customer search results will be displayed on the Select Customer List page.

2. From the Select Customer List  page, select the customers.

3. Click Add All Selected. To remove the customers, you can select the customer in the list box then click Remove at the right side.

Activity

1. Click the Activity link to pop-up the Activity Search page and then enter some criteria to select the activities. The activity search results will be displayed on the Select Activity page.

2. From the Select Activity page, select the activities.

3. Click Add All Selected. To remove the activities, you can select the activity in the list box then click Remove at the right side.

Activity Category

1. Click the Activity Category link to pop-up the Activity Category List page.

2. From the Activity Category List page, select the activity categories.

3. Click Add All Selected. To remove the activity categories, you can select the activity category in the list box then click Remove at the right side.

Activity Other Category

1. Click the Activity Other Category link to pop-up the Activity Other Category List page.

2. From the Activity Other Category List page, select the activity other categories.

3. Click Add All Selected. To remove the activity other categories, you can select the activity other category in the list box then click Remove at the right side.

Activity Type

1. Click the Activity Type link to pop-up the Activity Type List page.

2. From the Activity Type List page, select the activity types.

3. Click Add All Selected. To remove the activity types, you can select the activity type in the list box then click Remove at the right side.

Department

1. Click the Department link to pop-up the Department List page.

2. From the Department List page, select the departments.

3. Click Add All Selected. To remove the departments, you can select the department in the list box then click Remove at the right side.

Season      

1. Click the Season link to pop-up the Season List page.

2. From the Season List page, select the seasons.

3. Click Add All Selected. To remove the seasons, you can select the season in the list box then click Remove at the right side.

Term    

1. Click the Term link to pop-up the Term List page.

2. From the Term List page, select the terms.

3. Click Add All Selected. To remove the terms, you can select the term in the list box then click Remove at the right side.

Daycare Program      

1. Click the Daycare Program link to pop-up the Daycare Program Search page and then enter some criteria to select the activities. The activity search results will be displayed on the Select Activity page.

2. From the Select Activity page, select the activities.

3. Click Add All Selected. To remove the activities, you can select the activity in the list box then click Remove at the right side.

Daycare Program Type     

1. Click the Daycare Program Type link to pop-up the Daycare Program Type List page.

2. From the Daycare Program Type List page, select the daycare program types.

3. Click Add All Selected. To remove the daycare program types, you can select the daycare program type in the list box then click Remove at the right side.

Package      

1. Click the Package link to pop-up the Package Search page and then enter some criteria to select the packages. The package search results will be displayed on the Select Package List page.

2. From the Select Package List page, select the packages.

3. Click Add All Selected. To remove the packages, you can select the package in the list box then click Remove at the right side.

Package Category    

1. Click the Package Category link to pop-up the Package Category List page.

2. From the Package Category List page, select the package categories.

3. Click Add All Selected. To remove the package categories, you can select the package category in the list box then click Remove at the right side.

Revenue Site - Site where the revenue is recognized

1. Click the Revenue Site link to pop-up the Revenue Site List page.

2. From the Revenue Site List page, select the revenue sites.

3. Click Add All Selected. To remove the revenue sites, you can select the revenue site in the list box then click Remove at the right side.

Transaction Site - Site where the transaction was originally entered

1. Click the Transaction Site link to pop-up the Transaction Site List page.

2. From the Transaction Site List page, select the transaction sites.

3. Click Add All Selected. To remove the  transaction sites, you can select the  transaction site in the list box then click Remove at the right side.

Population Filters

Customer      

1. Click the Customer link to pop-up the Customer Search page and then enter some criteria to select the customers. The customer search results will be displayed on the Select Customer List page.

2. From the Select Customer List  page, select the customers.

3. Click Add All Selected. To remove the customers, you can select the customer in the list box then click Remove at the right side.

Customer Type      

1. Click the Customer Type link to pop-up the Customer Type List page.

2. From the Customer Type List page, select the customer types.

3. Click Add All Selected. To remove the customer types, you can select the customer type in the list box then click Remove at the right side.

Interest List      

1. Click the Interest List link to pop-up the Interest List page.

2. From the Interest List  page, select the interest lists.

3. Click Add All Selected. To remove the interest lists, you can select the interest list in the list box then click Remove at the right side.

Subscription List      

1. Click the Subscription List link to pop-up the Subscription List page.

2. From the Subscription List  page, select the subscription lists.

3. Click Add All Selected. To remove the subscription lists, you can select the subscription list in the list box then click Remove at the right side.

Demographic

1. Click the Demographic link to pop-up the Demographic List page.

2. From the Demographic List page, select the demographics.

3. Click Add All Selected. To remove the demographic lists, you can select the demographic list in the list box then click Remove at the right side.

Geographic Area

1. Click the Geographic Area link to pop-up the Geographic Area List page.

2. From the Geographic Area List page, select the geographic areas.

3. Click Add All Selected. To remove the geographic areas, you can select the geographic area in the list box then click Remove at the right side.

Customer City

1. Click the Customer City link to pop-up the Customer City List page.

2. From the Customer City List page, select the customer cities.

3. Click Add All Selected. To remove the customer cities, you can select the customer city in the list box then click Remove at the right side.

Customer State

1. Click the Customer State link to pop-up the Customer State List page.

2. From the Customer State List page, select the customer states.

3. Click Add All Selected. To remove the customer states, you can select the customer state in the list box then click Remove at the right side.

Customer Zip / Postal Code   

1. Click the Customer Zip / Postal Code link to pop-up the Zip / Postal Code List page.

2. From the Zip / Postal Code List page, select the zip / postal codes.

3. Click Add All Selected. To remove the zip / postal codes, you can select the zip / postal code in the list box then click Remove at the right side.

Custom Question  

1. Click the Custom Question link to pop-up the Custom Question List page.

2. From the Custom Question page, select the custom questions.

3. Click Add All Selected. To remove the custom questions, you can select the custom question in the list box then click Remove at the right side.

Age Range

1. Enter in the From box the Beginning Number for the age range.

2. Enter in the To box the Ending Number for the age range.

Account Created

1. Click the calendar icon beside the From box and select a Beginning Date for the created account from the pop-up calendar.

2. Click the calendar icon beside the To box and select an Ending Date for the created account from the pop-up calendar.

3. The Day of Week field beside the calendar icon will automatically be completed.

Login Created

1. Click the calendar icon beside the From box and select a Beginning Date for the created login from the pop-up calendar.

2. Click the calendar icon beside the To box and select an Ending Date for the created login from the pop-up calendar.

3. The Day of Week field beside the calendar icon will automatically be completed.

Login Used

1. Click the calendar icon beside the From box and select a Beginning Date for the used login from the pop-up calendar.

2. Click the calendar icon beside the To box and select an Ending Date for the used login from the pop-up calendar.

3. The Day of Week field beside the calendar icon will automatically be completed.

Gender

Choose one of the following options from the Gender drop-down list. The options include:

• All

• Male

• Female

• Unknown  

Residency

Choose one of the following options from the Residency drop-down list, to only include residencies with that type. The options include:

• All Customers

• Resident

• Expired Residents

• Non-Resident  

Customers Born in

Choose one of the following options from the Customers Born in drop-down list, to only include customers born in with that type. The options include:

• All Months

• January

• February

• March

• April

• May

• June

• July

• August

• September

• October

• November

• December  

Options

Customer Name Format

Choose one of the following options from the Customer Name Format drop-down list, to only include customers with that name format. The options include:

• Lastname, Firstname

• Firstname Lastname

Summary Report

Option to hide detailed customer and transaction information and show only the totals for each scholarship.

Show Total for Each Customer

Option to show total scholarship amounts granted and used for each customer on the report. This option is only visible if Summary Report is selected above and if the report is set to Group By Customer (see below).

Show Customer Alternate Keys?

Select the Show Customer Alternate Keys? checkbox to include the customer alternate keys on the report.

Show Customer Pass Numbers?

Select the Show Customer Pass Numbers? checkbox to include the customer pass numbers on the report.

Group By

Choose the method you want to use to group data in the report. The options are:

• Customer: Group by scholarship and then by customer.

• GL Account: Group by scholarship and then by destination GL account. This option will only show scholarships that are used as a payment for transactions. If a scholarship has only been used as a discount, it will not appear on this report when grouping by GL account.

Sort by

Choose the option from the Sort Options drop-down list to sort pages by different options, as selected from a predefined list. The options are:

• Award Order: Customers are listed in the order they were awarded scholarships - earlier to most recent.

• Customer Name: Customers are listed alphabetically.

Include Online Transactions?

Option to include data from transactions that were created on the customer (public access) site.

Note: This option is only visible to system users who do not have a multi-site user profile.

Output Type

Choose the option from the Output Type drop-down list to select the output type or format of the report, as selected from a predefined list. The available output types are Adobe Acrobat Reader, HTML, and Microsoft Excel.

Run Report

Click the Run Report button to generate the report.

Save Report Definition

1. Enter in the Report Title box the desired report title.

2. Click Save to save the report definition using the current report title entered. If the report title has been changed, the original report title will be replaced by the new one.

3. Click Save As to save another version of the report definition using a different report title.

4. Click Recall/Schedule on top of the page to access a previously saved report definition from the Report Definitions page.

Related topics

Return to Financial reports