Detail Transaction Pivot Macro Instructions

  1. Run and Save Account Analysis Reports using the same parameters for both Operations and Budget Ledgers.
  2. These reports may be scheduled on an interval and sent to your email.
  3. When using hierarchies, ensure that the operator is “Is a descendant of”.
  4. Accounting Periods should include the entire fiscal year for both ledgers.
  5. Operations Ledger: 1-18 to 12-18
  6. Budget Ledger: FY18
  7. Instructions to run and schedule the Account Analysis Reportmay be found on the UFS Training Portal.
  1. Open “DetailTransactionPivot”. Note: Do Not Change the Name of this File.
  1. 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.
  1. Click on Report_Criteria_Information Tab to identify the original Account Analysis Report Accounting Periods and Report Date. This is information only.
  1. Click on CombinedData Tab to view all combined data from Account Analysis Reports. Do NOT change this raw data.
  1. Click on ApproprRemainBal Tab to see a summary of Appropriated Funding Sources.
  2. Use the filters to isolate specific funding sources.
  3. BUDGET = Budget Load for each rollup account posted to Budget Ledger.
  4. ACTUAL = Expenses posted to Operations Ledger.
  5. Grand Total = Remaining Budget
  6. Double click on any dollar amount to drill to transaction detail in a new tab.
  1. Click on LocalFundBal Tab to see a summary of Local Funding Sources.
  2. Use the filters to isolate specific funding sources.
  3. The Budget Ledger is filtered out in order to reflect all ACTUAL Revenue and Expenses posted to the funding source.
  4. Expand fields to see aggregated transactions at the budget rollup account.
  5. Double click on any dollar amount to drill to transaction detail in a new tab.
  1. Click on Detail Tab to see transaction details.
  2. Use the filters to isolate specific funding sources.
  3. Expand fields to see aggregated transaction at the budget rollup account, account, accounting date, and description fields.
  4. Double click on any dollar amount to drill to additional transaction detail in a new tab.
  1. Run and Save Salary Ledger Report using the same parameters as the Account Analysis Report(s).
  2. Parameters may be saved for ease of running the report.
  3. Accounting Dates should match the Account Analysis Reports.
  4. Instructions to run the Salary Ledger Reportmay be found on the UFS Training Portal.
  1. Click on Process Tab in order to refresh your salary data.
  1. Navigate to saved report and select as indicated in the pop up box.
  2. The report may take several minutes to run, depending on the amount of data pulled in.
  1. Click on the SalaryData Tab to view all data from Salary Ledger Report. Do NOT change this raw data.
  1. Click on SalaryPvt Tab to see a summary of Employees with Salary and Fringe transactions.
  2. Use the filters to isolate for a specific Funding Source or Employee.
  3. Expand fields to aggregated transactions at the account, pay end date, and accounting date.
  4. Double click on any dollar amount to drill to additional transaction detail in a new tab.