Agency Balance Sheet Report (GLR112)
-
Print
-
DarkLight
-
PDF
Agency Balance Sheet Report (GLR112)
-
Print
-
DarkLight
-
PDF
Article summary
Did you find this summary helpful?
Thank you for your feedback
Report Description
A custom report of the finalized agency balance sheet reflecting the balances of assets, liabilities and fund balance with any adjustments that were made during the close process.
An agency report comparing the agency real account (balances sheet accounts) balances as of period 12 closing and agency real account balances after all adjustment periods (997 & 998) have been closed.
Report Location
Data Warehouse
Report Sample Layout
See the sample layout report below.
Report Navigation
Coming Soon!
Report Audience
- FLP_GL_Reporter
- FLP_EOG_OPB_REPORTER
Suggested Report Frequency
- Annual Report run for the previous year
Business Process Models
This report can be found in the following business processes:
Report Prompts
The report data can be filtered by the following report prompts:
| Parameter Name | Default Value | Column in Subject Area | Required (Y/N) | User Input |
|---|---|---|---|---|
Fiscal Year | N | Financials – GL Balance Sheet.Time.Fiscal Year | Y | Y |
Business unit | N | Financials – GL Balance Sheet.GL Fund Details.Business Unit | N | Y |
Fund | N | Financials – GL Balance Sheet.GL Fund Details.Transactional Fund | N | Y |
Report Columns
The layout of the report is listed below.
| Column Name | Column in Subject Area or TableName.ColumnName |
|---|---|
Fiscal Year | Financials – GL Balance Sheet.Time.Fiscal Year |
Business Unit | Financials – GL Balance Sheet.GL Fund Details.Business Unit |
GAAFR | Financials – GL Balance Sheet.GL CF Attribute Details.GAAFR |
Fund | Financials – GL Balance Sheet.GL Fund Details.Transactional Fund |
Fund Description | Financials – GL Balance Sheet.GL Fund Details.Description |
Account | Financials – GL Balance Sheet.GL Fund Details.Account Number |
Account Description | Financials – GL Balance Sheet.GL Fund Details.Account Description |
Account Type | Financials – GL Balance Sheet.GL Fund Details.Account Type Description |
Closing Balance | CASE WHEN “GL Fund Details”.”Accounting Period” IN (‘0’,’1’,’2’,’3’,’4’,’5’,’6’,’7’,’8’,’9’,’10’,’11’,’12’,’998’) THEN SUM(“Fact – Financials GL Ledger Transactions”.”Posted Total Amount(Sum)” BY "Time"."Fiscal Year", "GL Fund Details"."Business Unit", "GL Fund Details"."Transactional Fund", GL Fund Details"."Account Number", GL Fund Details"."Account Type", GL Fund Details"."Accounting Period", "GL CF Attribute Details"."GAAFR") ELSE 0 END |
Ending Balance | CASE WHEN “GL Fund Details”.”Accounting Period” IN (‘0’,’1’,’2’,’3’,’4’,’5’,’6’,’7’,’8’,’9’,’10’,’11’,’12’,’997’,’998’) THEN SUM(“Fact – Financials GL Ledger Transactions”.”Posted Total Amount(Sum)” BY "Time"."Fiscal Year", "GL Fund Details"."Business Unit", "GL Fund Details"."Transactional Fund", GL Fund Details"."Account Number", GL Fund Details"."Account Type", GL Fund Details"."Accounting Period", "GL CF Attribute Details"."GAAFR") ELSE 0 END |
Difference Between Closing & Ending Balance | CASE WHEN “GL Fund Details”.”Accounting Period” IN (‘0’,’1’,’2’,’3’,’4’,’5’,’6’,’7’,’8’,’9’,’10’,’11’,’12’,’998’) THEN SUM(“Fact – Financials GL Ledger Transactions”.”Posted Total Amount(Sum)” BY "Time"."Fiscal Year", "GL Fund Details"."Business Unit", "GL Fund Details"."Transactional Fund", GL Fund Details"."Account Number", GL Fund Details"."Account Type", GL Fund Details"."Accounting Period", "GL CF Attribute Details"."GAAFR") ELSE 0 END - CASE WHEN “GL Fund Details”.”Accounting Period” IN (‘0’,’1’,’2’,’3’,’4’,’5’,’6’,’7’,’8’,’9’,’10’,’11’,’12’,’997’,’998’) THEN SUM(“Fact – Financials GL Ledger Transactions”.”Posted Total Amount(Sum)” BY "Time"."Fiscal Year", "GL Fund Details"."Business Unit", "GL Fund Details"."Transactional Fund", GL Fund Details"."Account Number", GL Fund Details"."Account Type", GL Fund Details"."Accounting Period", "GL CF Attribute Details"."GAAFR") ELSE 0 END |
Data
More information about the data fields, including business definition and key values, is included as part of the Interface Catalog and applicable interface file layouts.
More information about the data values is included here: Configured Data Values.
More information about the ChartFields and related values is included in the Chart of Accounts Design.
Version History
Date | Revision Description |
|---|---|
01/31/2025 | Original Version |
| 03/05/2025 | Added the following sections:
|
Was this article helpful?
