When you look at the Program Revenue Report, you will see several columns: Gross, Discounts, Refunds, Net, and Percent of Net.  Fees are not added to the Gross revenue in the program revenue report. The Gross column shows how much revenue was collected before discounts, fees, or refunds for tickets to that Program. The Net Amount shows how much ticket revenue was collected after refunds and discounts were applied to sales for the program.  When you apply a discount to a Sales Order, Altru applies it to the ticket sales and not to the fees. 

If you want to pull a report of the fees that have been collected, you can run the Fee Report found in Sales. Fees are not tied to each program, but you can run the report to see how much was collected in fees for a certain Sales Method and/or Date Range. 

If your fees are applies per ticket by Program and you want to report on Fees collected by Program, you can build a query to show this information. 

Start your query:
1. Navigate to Analysis, then click on Information Library.
2. Click Add an Ad-hoc query.
3. Select the source view of Sales Orders and click Ok.

Add fields to include records where:
1. In the "Browse for fields in" column, expand Sales Order Item, expand Sales Order Item Fee, then click on Fee. In the "Select Fee fields" column, click on Name and move this to the "Include records where"and choose "Is not blank."
2. In the "Browse for fields in" column, expand Sales Order Item, expand Sales Order Item Ticket, then click on Program. In the "Select Program fields" column, click on Name. Type the name of the program you want to query on.
3. If you do not want refunded orders included in the query results: In the "Browse for fields in" column, click on Sales Orders at the top. In the "Select Sales Orders fields" move Refund status to "Include records where" and enter "Not One of 1 or 2."

Add fields to Results to Display:
1. In the "Browse for fields in" column, expand Sales Order Item, expand Sales Order Item Fee, then click on Fee. In the "Select Fee fields" column, click on Amount and move this to the "Results fields to display." Right click on the same row, go to Summarize and click SUM.  This will add all the fees together.
2. In the "Browse for fields in" column, expand Sales Order Item, expand Sales Order Item Fee, then click on Fee. In the "Select Fee fields" column, click on Name and move this to the "Results fields to display."
3. In the "Browse for fields in" column, expand Sales Order Item, expand Sales Order Item Ticket, then click on Program. In the "Select Program fields" column, click on Name and move this to the "Results fields to display."

Finally, go to the Set Save options tab, name and save the query.

Fees by Program Query