Summary
The Revenue vs. Expenses Summary report displays activity in revenue and expense accounts for a range of fiscal periods summarized by fund. If the fund (GL account section 1) has been assigned a section name (GL> Maintenance> Section), that section name will display on the report.
Step by Step
1 Open the Revenue vs. Expenses Summary window (GL> Reports> Revenue vs. Expenses Summary).
2 Configure the report.
- The From Fiscal Period and To Fiscal Period fields are used to filter the activity included in the report by the fiscal period in which it was posted.
- Enter the Fiscal Year of the activity you would like to include in the report.
- Check the Include Inactive Accounts toggle to include inactive accounts in the report.
- Check the Include Uncommitted JEs toggle to include uncommitted manual journal entries in the report. Checking this toggle will not include uncommitted AP invoice batches or other transaction processes in the report, it will only include uncommitted manual journal entries.
- Manual journal entries are created in the Edit step of the Journal Entries process (GL> Journal Entries> Journal Entries).
- The Revenue vs. Expenses Summary report will display the Fund, Fund Description, YTD Balance Before Period, Revenues for Period, Expenses for Period, and Year to Date Amount. The report will also include a report total.
- In order for the activity of a fund to display in this report, it must have a general ledger account with an account type that is set up as an expense or revenue. If a fund has a general ledger account that should be displaying in the report but is not, make sure the Account Type is set up as revenue or expense in the Account Type Maintenance window (GL> Maintenance> Account Type) and that the general ledger account is given the correct account type on the Chart of Accounts (GL> Maintenance> Chart of Accounts> General tab> Account Type field).
- The YTD Balance Before Period column is the sum of the Revenues (positive) and the Expenses (negative) of all periods prior to the fiscal period selected in the Period From field.
- The Year to Date Amount column is the sum of the Revenues (positive) and the Expenses (negative) of all periods in the fiscal year.
- All of the columns in the report can contain uncommitted manual journal entries if you check the Include Uncommitted JEs toggle.
3 Print the report.
- Once the required report settings have been specified, click the Print button to print your report.
- Click the options arrow on the right side of the Print button to see other print options.
- Select Send PDF to Job Viewer to print the report in the default Springbrook format.
- Select Send Excel to Job Viewer to export the report data to an Excel spreadsheet as unformatted data.
- Select Send Excel (Formatted) to Job Viewer to export the report data to an Excel spreadsheet that includes much of the Springbrook formatting found on the printed version of the report.
- Click the Schedule icon next to the Print button in order to schedule the report to generate at a later date and time.
- Scheduled printing has not yet been enabled for reports generated from process batches. This functionality will be released in an upcoming service pack.
- Users can also regenerate a report with the same configuration as a prior report via the report history section. This can help improve efficiency when an identical report is frequently generated.
- Once a report has been generated, the date and time it was generated will display in the report history accessed via the Expand Arrow button on the right side of the window.
- Expand the report history and click on a previous report record to automatically populate the report criteria with the criteria specified on the previously generated report. This section will display the last three times the report was generated.