Detail Transaction Account Analysis Report Pivot Macro Instructions
- Natalie Nation
- Brookebarton
Important Notes:
Pivot macros are a supplemental tool that can be used to analyze the Account Analysis Report.
Once you have generated your report, save the pivot macro as something other than the original name to ensure that you do not experience issues using the macro in the future. It is recommended that you save the original download to your desktop or a folder that you access regularly and that you save the file with a different name when saving the report to keep the information that you need (e.g. save the file as AccountAnalysisPivot - OCI FY23).
If you want to download the macro to use on a regular basis (not recommended), DO NOT rename it.
You are able to upload new information into the macro if you have not renamed it. For example, if you want to generate a new pivot with updated AARs, as long as you have not changed the name, you can go to the 'Process' tab and select the button to import the new information.
Step 1: Save Account Analysis Report & Open Pivot
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.
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 DetailTransactionPivot the file may download with the name DetailTransactionPivot(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: 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 3: 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 ApproprRemainBal tab to see a summary of Appropriated Funding Sources. You can use the filters to isolate key pieces of information like funding sources.
BUDGET = Budget Load for each rollup account posted to Budget Ledger.
ACTUAL = Expenses posted to Operations Ledger.
Grand Total = Remaining Budget
Double click on dollar amounts to drill to transaction details in a new tab.
Select the LocalFundBal tab to see a summary of Local Funding Sources.
Use the filters to isolate specific funding sources.
The Budget Ledger is filtered out in order to reflect all ACTUAL Revenue and Expenses posted to the funding source.
Expand fields to see aggregated transactions at the budget rollup account.
Double click on any dollar amount to drill to transaction detail in a new tab.
Select the Detail tab to see transaction details.
Use the filters to isolate specific funding sources.
Expand fields to see aggregated transactions at the budget rollup account, account, accounting date, and description fields.
Double click on any dollar amount to drill to additional transaction detail in a new tab.
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.
Office of Continuous Improvement
oci@boisestate.edu
1910 University Dr. Boise, ID 83725-1247