Cash Basis Transaction Reconciliation Report (GLR171)

Report Description

The General Ledger (GL) will contain multiple ledger groups, each containing amounts recorded under different basis of accounting:

• Modified Accrual
• Cash
• Accrual

The Actuals Ledger is the primary ledger for recording data within Florida PALM, i.e. source (Accounts Payable, Accounts Receivable, etc.) originated entries and GL originated entries. These transactions are posted to Actuals Ledger on modified accrual basis of accounting.

The GLE012 extension records accounting entries on the cash basis method i.e. when cash is received or paid against transactions in Florida. For example, when a voucher is paid, it’s corresponding accounting entries are posted to the Actuals Ledger. The accounting entries posted to Actuals Ledger are selected at specific events/timing and transformed to the cash basis entries. These cash basis accounting entries are systematically created and posted to CASH_BASIS ledger.

This report is designed to reconcile the GL Fund Cash balances reflected in the Actuals Ledger and the Cash Basis ledger, at the transactional level, and provides the exception details to identify differences in reconciliation.

Report Navigation: Main Menu > Florida PALM > Reports > GL > Cash Basis Txn Recon Report

Click below to view the sample report layout.

Business Roles

The following business roles have access to this report:

• GL Reporter 
• Batch 

Business Process Models

This report can be found in the following business processes:

• 10.3.1 Perform Month-End Close

Selection Criteria

The report data can be filtered by the following selection criteria:

Report Layout

The layout of the report is listed below. 

Version History