The Expenditure/Revenue Report gives you access to view budget information and all committed, encumbered, and expended monies for all the Expense, Revenue, and Internal Accounts. The report is defined and generated based on parameters defined in the report’s criteria. Data can be sorted, filtered, and hidden in a number of ways and can include as many years of information as selected.
1a. In ERP, in the Budgeting/General Ledger menu, click Expenditure/Revenue Report.
1b. In SIS, in the Billing menu, click Expenditure/Revenue Report.
2. Use the Categories section to begin defining your report criteria.
3. Select Expense, Revenue, or Internal from the Category Type pull-down to select the type of accounts.
4. Select the Month. Selecting a month will pull data from the beginning of the fiscal year to the month selected. You also have the option to enter in a date range by selecting Custom Date from the pull-down.
5. Select the fiscal Year and the number of years of History you wish to be displayed. The historic data displayed depends on criteria selected from the Month and Year menu options.
6. The Month 13+ pull-down may display depending on your profile permissions. To pull audit corrections for select months, select the month from the Month 13+ pull-down.
If Manual Journals have been created using a Journal Date with a closed fiscal year, options 13-20 can be selected and applied to the journal to indicate an audit correction. Month 13 is used to post entries for when the auditor visits and asks for corrections. Using Month 13+ allows you to run the Trial Balance and Expenditure/Revenue Report that reflect financial statements (June / Month 12) and be able to run corrected financial statements (as of month 13). If there are multiple rounds of audit changes, Month 13-20 can be selected.
Upon making a selection from the Month 13+ pull-down, be sure to select the correct Year that was audited or in which the journal corrections were created.
7. Select the Sum Expenses check box to configure the report to total expenses across all prior fiscal years plus the selected date range.
Drilldowns for expense columns will show only journals within the reports date range, allowing you to review current period details while providing a comprehensive total.
8. Select the Include Zero Lines check box to pull all data for accounts that have a beginning budget and ending balance of zero dollars.
9. Select the Capitalized Objects Only check box to only pull data for accounts tied to capitalized object codes.
10. The Show Descriptions pull-down gives you the ability to display accounting strip and/or element descriptions in your report. Select Element Descriptions to see each code and code name. Select Element Descriptions (Split) to display the element description in a separate column from the element codes.
13. Select the desired Selected Categories to include in your report. You can also clear the check box to remove categories from the report.
Click the Check/Uncheck All link to select all categories at once or to clear all selections made.
Selecting Internal or Revenue from the Category Type pull-down may alter elements listed in Selected Categories. For example, Internal Accounts typically has more elements than Expense and Revenue accounts.
To change the order of the Selected Categories, you can drag and drop any of the displayed categories.
At least one category must be selected to generate the report.
14. Click the Group Level arrows to define the level of detail within your report. Click the right blue arrow to move the Group Level by the desired number of spaces.
In the Project Category, move two spaces to group codes by the hundreds: i.e. 10XX, 11XX, etc. The ‘X’ stands in as a wildcard.
15. Select the Subtotal check box to display the subtotal of each categories identified, such as Department.
16. Element Filters can be used to help further breakdown the report. If you need data for a specific Fund, Function, Object, etc., type the code in the correct text field before generating the report.
Element Filters can be removed by deleting the code from the text field and regenerating the report.
Wildcards can be used in element codes: i.e. If you want all project codes beginning with ‘70,’ you can type '70XX' in the Project text field. The ‘X’ stands in as your wildcard. Note: using wildcards here will not group elements together.
17. To conduct a search of accounts, click the Account Lookup button. This opens a pop-up window giving you the ability to search through all available elements and corresponding codes and descriptions.
18. Define criteria in the Payroll section for payroll specific results.
a. Select the Only Payroll check box to generate data pertaining only to payroll accounts.
The data displayed is based on the fiscal Year selected in the Categories section.
19. Click Run Report to generate the report.
Depending on the Category Type selected in Generating the Expenditure/Revenue Report, different columns display.
Below is an example of Revenue category type.
Shown below is an example of Expense category type.
The remaining balance for each budget is determined by the following formula:
Budgeted - Committed - Encumbered - Expended YTD (Year to Date) = Balance.
Note: This formula applies to Expense and Internal accounts.
The Percent column shows the remaining budget for each account. The Visual Percent column displays a color-coded bar graph to visually represent the percent of budget monies remaining.
| Visual Percent | Definition |
|---|---|
| Green | More than 50% remaining |
|
Yellow |
50% or less remaining |
| Red | 25% of less remaining |
| White | 0% remaining or negative balance |
The blue amounts displayed in the report are hyperlinks. Click on any amount to open the Budget Drilldown pop-up window.
Depending on the amount selected, you may see different sections in your Budget Drilldown, such as Manual Journal Allocations, Invoice Allocations, Imported Journals, Additional Journals, Receipts, etc.
Receipts, Invoices, Sources, POs, etc. will be in blue as well. Click on these links to drilldown further and open the original record.
Click Open Journal Report to open the account data in the Journal Report.
See Additional Features for more information about Pages, Printing, Exporting, Toggle Columns, etc.