Running the Budget vs Actual – Expandable by Column
Purpose: This report can be used to monitor any combination of segment values to retrieve summary data by account segment, drill down to department and cost center activity from hierarchies, and drill to transaction details. It is a year to date report.
Note: The preferred browser for this report is Firefox because of the auto-refresh feature.
Step / Action /1. / Users may access the Budget vs Actual – Expandable by Column by clicking the icon on the Home Pageor via the Navigator menu.
To navigate to the Home Page, click the house icon in the top right hand corner.
2. / From the OFC Home Page, click the Financial Reporting icon.
3. / Select Budget vs Actual – Expandable by Column by clicking on the blue link.
4. / The report will first generate results based on the filters at the top of the screen. These will default to the last filters entered.
5. / The Accounting Period should be updated to the current period to capture year to date information.
Click to update.
Select by opening the Accounting Period, Year, and Quarter chevrons. Select the appropriate Accounting Period radio button and click OK.
6. / Enter data fields as appropriate to filter the data request. Select “All Values” for segments that will not be filtered.
Each segment is entered in the same manner, either by using the search feature or drop down values.
Note: A value other than “All Values” must be selected for Cost Center. You may select either a specific value or a hierarchy.
7. / Search a Specific Value:
Select the segment that will be filtered by clicking the segment.
Enter the value and click the binoculars.
Select the appropriate value, click OK and OK, again.
Repeat for each appropriate segment.
8. / Search a Hierarchy:
Select the segment that will be filtered by clicking the segment.
Enter the value and click the binoculars (Reference: Hierarchies List)
Select the value that indicates “Current”, click OK and OK, again.
Repeat for each appropriate segment.
6. / Select from Dropdown Menu:
Select the segment that will be filtered by clicking the segment.
Click the chevron next to the segment to access drop down of all values available. Select the appropriate value by clicking in the radio button and clicking OK.
7. / Each Hierarchy and Department with a chevron in the report may be expanded by column to get to the department and cost center segment summary data.
8. / Each Account Rollup row with a chevron in the report may be expanded to get to the account segment summary data.
Each value in the Budget and Actual columns may be drilled into by clicking on the dollar amount hyperlink.
9. / After clicking on an amount to drill to, Select Drill to Detail Balances to review transaction details.
Reference: Running a Detail Balances Report
10. / Results may be exported to Excel by selecting Export to Excel from the dropdown menu on the top left side of the report.
Protips:
àThe export will only include data shown on the screen, click the chevrons to show all data you would like included in the report before you export.
àYou may have to remove formatting to view export in Excel.
àThe next time you open the report, the filters from the last time it was run will remain.
11. / End of Procedure.
Last Updated: 10/24/16 / Page 1