GL Revenue and Expense Report window (Fund product only)
The Revenue and Expense Report shows the relationship between revenue and expenses for the period range you specify.
Fund Number
Enter a fund number to show only accounts in that fund on the report.
Print All Funds (Fund product only)
This drop-down is only active if the Fund Number field is blank. If you want to print one report that displays all the included funds, select Combined from the drop-down. If you want to print a separate report for each fund, select Separated.
Starting Period / Ending Period
Enter the starting and ending period number(s) that you want to include in the report. You can choose any period(s) in your
fiscal calendar, from 1 to 60. If you want to include only one period in the report, enter the same number in both the
Starting Period and
Ending Period boxes.
When you enter the period number, the first date of the starting period and the last date of the ending period will appear to the right of the corresponding boxes so you can verify that these are the periods you want to include in the report.
If the Allow multiple fiscal calendars check box is selected in Module Preferences and the fund calendar is different than the organization calendar, the fund’s organization calendar will be used for these dates.
Skip Zero Balance
Select this check box to exclude accounts that have a zero balance for the specified time period on the report. If the accounts have a balance, but not in the time period shown on the report, they will not appear on the report.
Sort by Fund
This check box is only active if you select Combined from the Print All Funds drop-down. Select this check box if you want to sort the included accounts by fund number.
Print Account Number
Select this check box if you want to print the account number next to the account description.
Use Advanced Report Groups
Select this check box if you want to generate a report with an
advanced layout. When you select this check box, different options are available from the
Report Type drop-down and the
Report Group Lookup is enabled.
Exclude Encumbrances
Select this check box to exclude encumbrance amounts on the report.
Report Type
Select the type of report you want to run from the drop-down. Your choices are:
• Detailed: Prints all revenue and expense activity for the selected funds.
• Summary: Prints only the revenue and expense totals for the selected funds.
• Classified: Prints a report sorted by account class subcategories (report groups). To set up report groups, see
Setting Up Account Groups. You must have every revenue and expense account in your general ledger assigned to an appropriate classified report group to run this report.
• Comparative Detailed: Prints all revenue and expense activity for both the period you selected in the Ending Period box and the same period for the prior two years.
• Comparative Classified: Prints revenue and expense activity by account class subcategories (report groups) for both the period you selected in the
Ending Period box and the same period for the prior two years. You must have every revenue and expense account in your general ledger assigned to an appropriate classified report group in order to run this report. To set up report groups, see
Setting Up Account Groups.
• Drilldown: Prints a report that allows you to drill down to individual transactions. Double-click any line on the report for more information. A new report will open showing transaction information specific to the line you selected. You can only print this report to screen.
If you selected the Use Advanced Report Groups check box, the following options are available:
• Advanced Classified: Prints the Revenue and Expense Report sorted by account class subcategories using the layout you select in the
Report Group field. You must have every revenue and expense account in your general ledger assigned to an appropriate classified report group to run this report. To set up report groups, see
Setting Up Account Groups.
• Advanced Comparative Classified: Prints the Revenue and Expense Report sorted by account class subcategories for both the period you selected in the
Ending Period box and the same period for the prior two years using the layout you select in the
Report Group field. You must have every revenue and expense account in your general ledger assigned to an appropriate classified report group to run this report. To set up report groups, see
Setting Up Account Groups.
• Advanced Detailed: Prints the Revenue and Expense Report sorted by the accounts you added to the Advanced Report Group layout, even if the accounts do not have a Group 1 Report Group assignment in the GL Accounts window.
Use Account Filter
Select this check box and enter a filter to use to print a customized report which includes only those accounts that meet the filter criteria. This option is not available if you selected the Use Advanced Report Groups check box.
Use Advanced Filter
Select this check box to use an
Advanced Filter Code as a filter for the report.
Account Filter
If you selected the Use Account Filter check box, enter the filter you will use here. Only accounts that match the specified filter criteria will appear on the report. Use wildcards (* and ?) to establish the filter parameters. Substitute a (?) for any single character in the account number, or an (*) for any number of characters. For example, to include all four-digit accounts beginning with a 1, enter 1??? in the Account Filter box. To include all accounts that end in 02, enter *02.
Report Group
This field is only available if you selected the Use Advanced Report Groups check box. Type the Report Group Code you want to use for this report layout or open the Lookup to select one.
Use a Custom Report
This check box is only available if you
defined a custom report for this window in Controller. Select this check box if you want to run a custom report instead of the default report. The drop-down is enabled after you select the check box and you can choose the custom report you want to run.
Related Topics
Published date: 03/12/2021