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.
Navigating to the Transactional Table of Contents
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
Note: in most cases, you can leave a prompt blank or leave the default in any or all prompts.
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
Note: in most cases, you can leave a prompt blank or leave the default in any or all prompts.
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
Column Name
|
Description
|
Balance Type
|
Type of balance in the fiscal year for the General Ledger account
|
Beginning Balance
|
Beginning fiscal year balance in the General Ledger account
|
Net Activity
|
Amount going in/out of the General Ledger account during the fiscal year
|
Ending Balance
|
Balance in the General Ledger account following the net activity at the end of the fiscal year
|
This completes the General Ledger Balances by Fiscal Year and General Ledger Balances by Period Reports Processes.