Budget Office Pivot Macro Instructions

1.  Run and Save Account Analysis Reports using the same parameters for both Operations and Budget Ledgers.

  1. These reports may be scheduled on an interval and sent to your email.
  2. When using hierarchies, ensure that the operator is “Is a descendant of”.
  3. Accounting Periods should include the entire fiscal year for both ledgers.
  4. Operations Ledger: 1-17 to 12-17
  5. Budget Ledger: FY17
  6. Instructions to run and schedule the Account Analysis Report may be found on the UFS Training Portal.

2.  Open “BudgetOfficePivot”. Note: Do Not Change the Name of this File.

3.  Click on Process Tab in order to refresh your report data.

  1. Select either one or two reports to include.
  2. Navigate to reports saved in step one and select as indicated in the pop up boxes.
  3. The report may take several minutes to run, depending on the amount of data pulled in.

4.  Click on Report_Criteria_Information Tab to identify the original Account Analysis Report Accounting Periods and Report Date. This is information only.

5.  Click on CombinedData Tab to view all combined data from Account Analysis Reports. Do NOT change this raw data.

6.  Click on ApproprRemainBal Tab to see a summary of Appropriated Funding Sources.

  1. Use the filters to isolate specific funding sources.
  2. BUDGET = Budget Load for each rollup account posted to Budget Ledger.
  3. ACTUAL = Expenses posted to Operations Ledger.
  4. Grand Total = Remaining Budget
  5. Double click on any dollar amount to drill to transaction detail in a new tab.

7.  Click on LocalFundBal Tab to see a summary of Local Funding Sources.

  1. Use the filters to isolate specific funding sources.
  2. The Budget Ledger is filtered out in order to reflect all ACTUAL Revenue and Expenses posted to the funding source.
  3. Expand fields to see aggregated transactions at the budget rollup account.
  4. Double click on any dollar amount to drill to transaction detail in a new tab.

8.  Click on AuxPL Tab to see a summary of Auxiliary Funding Sources.

  1. Use the filters to isolate specific funding sources.
  2. The Budget Ledger is filtered out in order to reflect all ACTUAL all Revenue and Expenses posted to the funding source.
  3. Expand fields to see aggregated transaction at the budget rollup account.
  4. Double click on any dollar amount to drill to transaction detail in a new tab.