Budget to Actuals with Fund Balances

This guide will cover:

 

Information

The Budget to Actuals with Fund Balances Reports provide a budget to actual summary for organizations to show activity over time with an additional button to view fund balances. Use these reports for planning purposes and to compare budget amounts against actual balances at a high overview level.

 

Step One

Navigating to the Reporting Table of Contents

  • Navigate to WyoCloud and click on the Reporting Table of Contents tile.

  • Once you have located the Table of Contents, click on the "Budget to Actuals with Fund Balances Current Fiscal Year”  or the “Budget to Actuals with Fund Balances FY XX Report”. All reports are found under the Business Intelligence and Data Visualizations header.

 

Step Two

Running the Budget to Actuals with Fund Balances Report

To run the Budget to Actuals with Fund Balances Report:

  • Under the "Business Intelligence and Data Visualizations" header on the Table of Contents, click on the Budget to Actuals with Fund Balances Report.

  • The report prompt page will now be opened.

 

Narrowing Down the Report

  • You may use the following prompts to narrow the report to only display information relevant to your needs. The report will update as desired prompts are selected.

           Note: in most cases, you can leave a prompt blank or leave the default in any or all prompts.

  • Users can toggle between the Budget to Actuals and Fund Balance pages.

  • You may also narrow down either report page by right clicking on a numerical value and selecting drill through to only more detailed information.

Step Three

Parameters, Defined:

Column Name

Column Definition

Example

Entity

Subset of the University reporting unit (most transactions fall under 10, unless your department is a specialized entity)

10 (University of Wyoming)

Division

Name and number of the division

Budget & Finance Division

Subdivision

Name and number of the Subdivision

Business Enterprises Subdivision

Organization

Name and number that represents the Organization

Accounting Office
Program The segment pertains to the unique specialization within the department/organization. Codes are grouped by division/unit/department but can be used by departments from across campus if applicable. 1502 MBA Program
Activity The segment provides more opportunity to further differentiate a transaction for departmental or unit reporting purposes. This segment is definable by the department by using the generic codes that have been loaded into WyoCloud. There are placeholders for Project 1, Project 2, etc., Activity 1, Activity 2, etc., Game 1, Game 2, etc., Exhibit 1, Exhibit 2 and each department can assign what the code means for their use. 4931 Course Materials

Fund Class Code

Source of funds for transactions.

105 (Unrestricted Operating)

 

Fund Source Code

Specifies the exact nature of the source of funds, classified by restrictions to further narrow down the funding source

000001 (Unrestricted Operating)

 

Step Four

Interpreting the Report

Column Name

Description
Summary Level Natural Accounts The expenditure classifications for the natural accounts.
Budget The fund amount budgeted to the organization for the fiscal year.
YTD Actuals The actual difference between the debits and credits for that fiscal year.
Encumbrances The encumbrance difference between the debits and credits for that fiscal year.
Total Actuals The total difference between the debits and credits for that fiscal year including the encumbrances.
Variance The difference between the budget and actuals for that fiscal year.
% Variance The percent difference between the budget and actuals for that fiscal year.
Was this helpful?
0 reviews
Print Article