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

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

  • If this is the first time accessing reports, you will need to follow the steps to navigate to the reporting dashboard. To navigate to the Transactional Reporting Table of Contents, follow the quick reference guide labeled Navigating to the Transactional Reporting Table of Contents and Set Favorites in the Reports and Analytics. The guide will also outline how to locate and set frequently used reports as favorites for easier access

  • 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)

 

Interpreting the Report 

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

Was this helpful?
0 reviews

Details

Article ID: 138193
Created
Wed 2/23/22 9:45 AM
Modified
Wed 9/28/22 3:06 PM