...
...
...
...
...
...
...
...
...
...
...
...
...
...
| Info |
|---|
Important Notes:
|
| Anchor | ||||
|---|---|---|---|---|
|
Begin by saving the AAR(s) you downloaded.
Download or locate the pivot table you will be working with.
...
Open the pivot and confirm accuracy of the file name.
...
| Note |
|---|
If you have a previously downloaded version of this pivot stored on your computer, the file will download with a 1 or another number at the end and this is incorrect. For example, rather than GrantAccountAnalysisPivot the file may download with the name GrantAccountAnalysisPivot(1). The pivot will not work if the file name is incorrect. To move forward, you must ensure the file has the correct naming convention. |
Correct pivot file names for financial analysis:
AccountAnalysisPivot
BudgetOfficePivot
DetailTransactionPivot
GrantAccountAnalysisPivot
...
Step 2: Add Budget Rollup Line(s)
Select the GrantBudgetData Tab to enter or edit grant budget(s).
Select Insert to add a line for each budget rollup line.
...
Enter Fund, Department, Cost Center, Supplemental, and Project Segments.
Enter Natural Account as the Budget Rollup
Salaries – 410000
Fringe – 420000
Other Expense – 500000
Travel – 530000
F&A – 529500 or 895000
Student Costs – 891300 through 893200
Revenue – Enter Total Budget 334100, 335100, 338100, or 336100
Enter Net Amount as Negative Number for Expenses and Positive Number for Revenue
...
...
Step 3: Select the Number of Reports to Process
Navigate to the Process Tab of the pivot spreadsheet.
Select Generate Pivot Account Analysis Report-1 to analyze one AAR or select Generate Pivot Account Analysis Report-2 to analyze two AARs.
Navigate to the AARs saved in a prior step.
...
The report will take a few minutes to run.
...
Step 4: Review Results
Select the Report_Criteria_Information tab to view the accounting periods included in the report and the date the AAR was generated.
...
Select the CombinedData tab to view all data generated in the AAR(s). DO NOT change the data on this tab; this data is used in the pivot table.
...
Select the PvtTblRpt tab to view budget and actual expenses.
...
You can use the filters to isolate key pieces of information like funding sources.
You can filter by accounting Period_Name, Balance_Type, Fund_Department_Supplemental_Project. To sort by a particular field, select the chevron to the right of the filter and select the values to include or exclude in your search.
...
Double click on dollar amounts on the PvtTblRpt tab to drill to transaction details in a new tab.
...
Copy and paste the pivot table to additional tabs and use filters to set up specific funding sources. Update tab names to reflect filter selections.
Refresh data as often as you would like by completing step 2 with new reports
...
End of Process
...
Need help with the steps above?
For support with running this report (e.g. you received an error message) submit a Help Desk Self-Service ticket.
Visit Reporting at Boise State for more information about reporting support at the university.