General Ledger Balances by Fiscal Year & General Ledger Balances by Period Report

Summary

This QRG covers locating, running, and filtering results for both reports. This report provides a budget to actual summary for organizations to show activity by period over time. Use this report for planning purposes and to compare budget amounts against actual balances at a high overview level. It is recommended to use the Account Analysis Report to view more specific activity details.

Body

This guide will cover:

Note: This report automatically downloads as an Excel Spreadsheet.

 

Information

The General Ledger Balances by Fiscal Year Report (Step 2) and General Ledger Balances by Period Report (Step 3) provide details about the general ledger balances for the Fiscal Year and for select periods throughout the Fiscal Year. The General Ledger Balances by Fiscal Year Report can be used to view beginning and current fund balances with expenditures.

 

Step One

Navigating to the Transactional 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 "General Ledger Balances by Fiscal Year (Step 2) or the “General Ledger Balances by Period” (Step 3). Both reports are found under the Budget and General Ledger header.

 

Step Two

Running the General Ledger Balances by Fiscal Year Report

  • Under the "Budget and General Ledger" header on the Table of Contents, click on the General Ledger Balances by Fiscal Year 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. It is required to search by Fiscal year and recommended at minimum to prompt by the organization.

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

  • After selecting desired prompts, click Apply.

  • The General Ledger Balances by Fiscal Year Report is downloaded as an Excel File to your Browser and may be opened. 

 

Step Three

Running the General Ledger Balances by Period

  • Under the "Budget and General Ledger" header on the Table of Contents, click on the General Ledger Balances by Period 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. It is required to search by Period Name and recommended at minimum to prompt by the organization.

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

  • After selecting desired prompts, click Apply.

  • The General Ledger Balances by Period Report is downloaded as an Excel File to your Browser and may be opened. 

 

Step Four

Parameters, Defined:

Column Name

Column Definition

Example

Mandatory Field:

Fiscal Year

Select the appropriate Fiscal Year

2022

Period Name

Select the appropriate Period

1 (July)

Optional Fields:

Subdivision

Name of the Subdivision

Business Enterprises Subdivision

Department

Name of the Department

Administration Department

Organization

Name of the Organization

 Accounting Office

Organization Code

Number that represents the Organization

22102 (Accounting Office)

Entity Code

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

10 (University of Wyoming) 

Natural Account Code

Specific type of asset, liability, equity, revenue and expense. *Budgets are defined at this level, but ultimately rollup to specific categories*

64002 (Office Supplies)

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 Five 

Interpreting the Report 

This completes the General Ledger Balances by Fiscal Year and General Ledger Balances by Period Reports Processes.

Details

Details

Article ID: 138193
Created
Wed 2/23/22 11:45 AM
Modified
Tue 10/31/23 5:06 PM