Cash Balances Comparison Report (GLR172)
-
Print
-
DarkLight
-
PDF
Cash Balances Comparison Report (GLR172)
-
Print
-
DarkLight
-
PDF
Article summary
Did you find this summary helpful?
Thank you for your feedback
Report Description
A custom report for enterprise users to identify if spendable cash (KK) and Fund Cash (GL) balances are reconciled between the Actuals, Cash and KK ledgers. This enterprise report compares balances from the Actuals, Cash Basis, and CC Cash ledgers. This report presents balances as of the last nightly Data Warehouse (DW) update. This report can be used to identify whether additional research is needed to identify specific differences.
Report Location
Data Warehouse
Report Sample Layout
See the sample layout report below.
Coming Soon!
Report Navigation
Coming Soon!
Report Audience
- FLP_GL_Reporter
Suggested Report Frequency
- Ad Hoc
Business Process Models
This report can be found in the following business processes:
- 10.2.3 Agency Create and Approval Journals
- 10.2.4 Enterprise Create and Approve Journals
- 20.2.2 Manage Cash Checking
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 |
|---|---|---|---|---|
| Business Unit | N | "GL Fund Details"."Business Unit" | Y | Y |
Report Columns
The layout of the report is listed below.
| Column Name | Column in Subject Area or TableName.ColumnName |
|---|---|
Business Unit | WC_LEDGER_KK_D. BUSINESS_UNIT |
Transactional Fund | WC_LEDGER_KK_D.FUND_CODE |
Actual Ledger | SUM(CASE WHEN WC_GL_LEDGER_F.LEDGER = 'ACTUALS' AND WC_GL_LEDGER_F. ACCOUNTING_PERIOD IN ( 0, 1, 2, 3, 4,5, 6, 7, 8, 9,10, 11, 12, 997, 998 ) THEN WC_GL_LEDGER_F. POSTED_TOTAL_AMT ELSE 0 END) |
Cash Basis Ledger | SUM(CASE WHEN WC_GL_LEDGER_F.LEDGER = ' CASH_BASIS' AND WC_GL_LEDGER_F. ACCOUNTING_PERIOD IN ( 0, 1, 2, 3, 4,5, 6, 7, 8, 9,10, 11, 12, 997, 998 ) THEN WC_GL_LEDGER_F. POSTED_TOTAL_AMT ELSE 0 END) |
Spendable Cash | SUM(CASE WHEN WC_GL_LEDGER_KK_F.LEDGER IN ( 'C_CSH_CNV', 'C_CSH_SC' ) THEN WC_GL_LEDGER_KK_F. POSTED_TOTAL_AMT ELSE 0 END) |
Actual - Cash | Calculation: Actual Ledger - Cash Basis Ledger |
Actual - Spendable | Calculation: Actual Ledger - Spendable Cash |
Cash - Spendable | Calculation: Cash Basis Ledger - Spendable Cash |
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/18/2025 | Added the following to the article:
|
| 03/26/2025 | Updated Report Name from Cash Balances Reconciliation Report to Cash Balances Comparison Report |
Was this article helpful?
