PCN Budget to Actuals Report

PCN Budget to Actuals Report

Important Notes:

  • The primary purpose of the budget to actuals report is to compare position budgets with actual salary expenses.

  • This comparison helps identify variances between the budget and actuals to help determine any onetime salary savings, permanent salary savings, or deficits by PCN.

Step 1: Locate and Access the PCN Budget to Actuals Report

  1. Begin by signing in to Bronco Hub.

  2. Select My Organization from the top navigation section of Bronco Hub and then AXIOM.

  3. Select the Labor Reports dropdown.

  4. Select the Boise State Labor Planning Reports dropdown.

  5. Select Boise State PCN Budget to Actuals Report.

Step 2: Filtering the PCN Budget to Actuals Report

  1. Select the filter icon to filter the parameters for the PCN Budget to Actuals Report

image of budget report filter
  1. Select the “Fiscal Year” dropdown and select the desired fiscal year. Then set your parameters by choosing from the dropdown menu.

    1. Filter by Department.

    2. Filter by Cost Center.

    3. Filter by Project.

    4. Filter by Budget Type (BTT=Base (permanent) Transfer; CFD=Carryforward; ORG=Original budget load; OTT=One-time Transfer).

    5. Filter by PCN.

image of filter fields

Be aware that there might be a hidden scroll bar at the bottom of the report. This indicates that there are additional fields available, but you may not be able to scroll to view them all. Please adjust your view or export the data if you need to see all fields.

Filter notes and tips:

  • If your desired filter doesn’t show up as a preset filter option you can use the filter wizard for additional options.

  • Use the Filter Wizard dropdown to filter for multiple funds, departments, or cost centers.

    • Filter by any field(s).

    • You must double click the field in the left menu for the options to show on the right menu. Then select your choice and select Apply.

    • Select Ok to apply your filter.

    • Select Apply on the left hand filter menu to run your updated report.

Step 3: Export to Excel

  1. Select Export to Excel located above the report output to export results to Microsoft Excel for further analysis.

image of report excel download option

Report Output Definitions:

  • Original Budget: The base budget that was loaded to that PCN at the beginning of the fiscal year.

  • Budget Adjustments: One time and base budget adjustments that were transferred to or from that PCN on that specific FDCC.

  • Total Adjusted Budget by FDCC/Total Adjusted Fringe by FDCC: The original budget plus one time and base budget adjustments for the FDCC listed.

  • Total Adjusted Budget by PCN: The original budget plus one time and base budget adjustments for that PCN in total regardless of the FDCC listed.

  • Payroll Actuals: Salary expenses incurred year to date.

  • Payroll Variance: “Total Adjusted Budget by FDCC” minus “Payroll Actuals”

  • HCM Annual Salary: The total salary of the PCN listed in HCM.

Note about Vacant PCNs: Vacant PCNs will list the previous incumbents salary as a placeholder in the HCM Annual Salary column if vacated within the current fiscal year.

  • Budget vs. HCM Salary Variance: “Total Adjusted Budget by PCN” minus “HCM Annual Salary. This column helps you see the overall funding picture and whether a PCN is overfunded or needs more funds.

For situations where funding and payout happen in different departments, it might be best to run the PCN Budget to Actuals report on a specific PCN rather than the entire department.

End of Process


Need help with the steps above?

If you need assistance with the process outlined above, reach out to the Office of Budget and Planning at budgetandplanning@boisestate.edu.

If you have suggestions to improve the instructions in this job aid, please submit an OCI Service Request ticket.

 

 

Office of Continuous Improvement
oci@boisestate.edu
1910 University Dr. Boise, ID 83725-1247