Net revenue reports

Net revenue reports display the net revenue earned by the agency from different transaction modules. These reports show an agency's regular sales revenue after deducting expenses.

 

There are several types of net revenue reports, listed in the Report Types section below.

 

Note: When comparing the Net Revenue report by Activity Name to the Roster - with Payment, keep in mind that the Net Revenue report includes both tax and refund charge amounts. As a result, the amounts in this report may not match up exactly to the amounts in the Roster - with Payment (which includes tax but does not include refund charges).

Go to section

Filters

Options

Save Report Definition

Report Types

On the main Net Revenue Reports page, select the criteria to organize the report by, as selected from the following: Account Name, Account Number, Account Category, Activity Name, Activity Category, Activity Number, Customer Type, Daycare Program, Donation Campaign, Event Type, Facility Name, Facility Number, Facility Type, Fee Name, Instructor, Membership Package, POS Product, Parent Season, Child Season, and Site Name.

 

Click Continue to proceed to the specific report page.

 

On the specific Net Revenue Report page, clicking the Recall 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.

 

The following fields are available on the Net Revenue Report page:

Name of Field

Type

Description

Filters

Report Filter

Hyperlink

All reports have the following filters: Transaction Date and Time range, Revenue Site, and Transaction Site. The other filters vary depending on the type of report.

 

For the Net Revenue Report by Account Name, Account Number, Customer Type and Site Name: G/L Account, Financial Department, Customer Type, or Site Name.

 

For the Net Revenue Report by Activity Category, Activity Name and Activity Number: Activity, Organization Department, Activity Category, Parent Season, Child Season and Financial Department.

 

For the Net Revenue Report by Activity Season: Activity, Organization Department, Activity Category, Parent Season, Child Season and Financial Department.

 

For the Net Revenue Report by Event Type Facility Name, Facility Number and Facility Type: Facility, Facility Type, Event Type and Financial Department.

 

For the Net Revenue Report by Daycare Program: Program and Financial Department.

 

For the Net Revenue Report by Donation Campaign: Campaign Name, Activity, Organization Department, Activity Category, Parent Season, Child Season and Financial Department.

 

For the Net Revenue Report by Fee Name: Charges and Customer Type and Department.

 

For the Net Revenue Report by Membership Package: Package and Financial Department.

 

For the Net Revenue Report by POS Product: POS Product, POS Product, Department, POS Product Class, POS Product SubClass, Activity and Financial Department.

 

For the Net Revenue Report by Parent Season: Activity, Organization Department, Activity Category, Parent Season and Financial Department.

 

Click the Report Filter link to learn more about reports and their filters.

 

Note: When accounting A/R (accrual) is turned on, put the A/R account (accrual) in the UnPaid_Amounts column, not the Total Refs column.

Options

Note: Some options do not apply to all net revenue report types.

Show Sub Totals

Checkbox

Option to show subtotal amounts for each sub-grouping in the report.

 

For example, for the Net Revenue Report by Account Number, subtotals will be displayed for each account number.

 

Note: This option is unavailable if you have selected Microsoft Excel (Tabular Format) as the Output Type below.

Summary Report

Checkbox

Option to produce a summary report or a detailed report.

 

Summary reports only display the amount totals for each sub-grouping in the report, while detailed reports list individual transactions, receipts, or fees (depending on the report type).

 

Note: This option is unavailable if you have selected Microsoft Excel (Tabular Format) as the Output Type below.

No Zero Amount Records

Checkbox

Option to exclude transactions that have zero amounts (for example, transactions that did not require payment).

Include Additional Charge?

Checkbox

Option to include additional charge amounts in the report.

 

Note: This option appears when running one of the following Net Revenue reports:

  • by Activity Name

  • by Activity Number

  • by Activity Category

  • by Season

  • by Term

  • by Flexreg Program

Show Other Transactions

Checkbox

Option to include other transactions in the report.

Subtract Third Party Fees from Net Revenue?

Checkbox

Select whether to include third party fees (absorbed convenience fee, credit card fees, and electronic check payment fees) in the report.

 

Third party fees will display for each line item in the report. They will also be deducted from net revenue for each line item in the report.

Residency

Dropdown list

Option to group the transaction by Resident, Non-Resident, or both, as selected from a predefined list.

Group By

Dropdown list

Option to group the transactions either by Date (default), Site, or Fee Contract.

Inner Grouping

Dropdown list

Note: This option is available for Activity Name and Activity Number type reports.

 

You can group data by:

  • Instructor

  • Receipt Number

  • Transaction Type

  • Transactions

  • GL Account Name

Include Online Transactions?

Checkbox

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

Dropdown list

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.

 

If you want to export this report using a plain format and no subtotals so that you can easily manipulate the figures in a spreadsheet, select Microsoft Excel (Tabular Format).

Save Report Definition

Report Title

Text

Option to save the report definition for later use.

 

Click the Report Filter link to learn more about report definitions.