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.

• Click the Print icon to process the report immediately or enter a date and time in the field next to the Print icon to schedule the report to generate at a later time. You can view the progress of the report on the Job Viewer window (SS> Utilities> Show Scheduled Jobs).
  • Click the Print icon drop-down menu and select Print Preview to preview the report before printing.
  • Click the Print icon drop-down menu and select Excel to export the report data to an Excel spreadsheet as unformatted data.
  • Click the Print icon drop-down menu and select Excel (Formatted) to export the report data to an Excel spreadsheet that includes much of the Springbrook formatting found on the printed version of the report.
  • Once the report is generated, you can also display the report using the View Reports window (SS> Utilities> View Report).