Login
Contents x
Unreconciled Deposits Report (ARR021)
  • Print
  • Dark
    Light
  • PDF
Contents

Unreconciled Deposits Report (ARR021)

  • Print
  • Dark
    Light
  • PDF
Article summary

Report Description

This report was implemented in CMS Wave and will be updated in Financials Wave. The information in this article is the planned design for Financials Wave.

This query will display all the deposits that have not been reconciled within Florida PALM. Florida PALM imports bank statements and provides a reconciliation process (e.g., automated, semi-manual, and manual) where transactions are reconciled with bank transactions (e.g., validated in banking portal). Bank Transactions and deposits that are not reconciled are available to view in this report. This query assists the agency with the deposit entry or update process. This report will display multiple payments for single deposit both direct journal and customer payments. This report provides a list of bank and deposit transactions that were unable to reconcile in Florida PALM. Includes the electronic deposit number as Reference ID for FLAIR entry. 

The Unreconciled Deposits Report includes the electronic deposit number as Reference ID for deposit entry and reconciliation purposes. The first set of data represents the unreconciled bank deposit transactions. The data below and to the right, contains the unreconciled system deposit transactions.  

This report is showing us the deposit data from the bank is missing the matching deposit record. Reconciliation Status: NTF = (Not Found) This typically means the deposit has not been entered in the system or the system deposit transaction does not match the bank statement.  UNR = (Unreconciled) Typically you will need to monitor these transactions as they should be rare and fall off the report eventually.  Very rare will you need to take action on these deposits. BAI Codes- Agency can filter the BAI code that requires no action from the agency because Treasury will handle. (BAI Codes – 100, 255, 475, 495, 577, BTD, and BTC (Treasury Bank Accounts*)

Additional fields for Financial Segment: New ChartFields, Supplier ID, Asset ID Reference, AR Item, and Customer.

Report Navigation: Main Menu>Reporting Tools>Query>Query Viewer

Query Name: FLP_Unrecon_Deposits_Report

See the sample layout report below.

ARR021 - Unreconciled Deposits Report - Sample Data.xlsx

Business Roles

The following business roles have access to this report:

Business Process Models

This report can be found in the following business processes:

Selection Criteria

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

Data Field

Data Field Details

Deposit BU

Required; Business Unit Edit

From Date and To Date

Required - Deposit Accounting date

Bank Code

Optional; Bank Code Edit

Bank Account #

Optional; Bank Account # prompt

Agency Deposit Number

Optional; No edit

Payment ID

Optional; No edit

Deposit ID

Optional; No edit

Deposit Amount

Optional; No edit

Payment Amount

Optional; No edit

Distribution Amount

Optional; No edit

Organization

Optional; Organization prompt

Account

Optional; Account prompt

Fund Code

Optional; Fund Code prompt

Budget Entity

Optional; Budget Entity prompt

Category

Optional; Category prompt

Grant

Optional; Grant prompt

OA1

Optional; OA1 prompt

OA2

Optional; OA2 prompt

Project

Optional; Project prompt

Customer ID

Optional; Customer ID prompt

Item ID

Optional; Item ID prompt

Supplier ID

Optional; Supplier ID prompt

Asset ID Reference

Optional; Asset ID prompt

Deposit Type

Optional; Deposit Type Edit

Report Layout

The layout of the report is listed below. 

Data Field

Florida PALM RECORD.FIELD mapping

Deposit Unit

DEPOSIT_CONTROL.DEPOSIT_BU

Deposit ID

DEPOSIT_CONTROL.DEPOSIT_ID

Agency Deposit Number

FLP_DEP_NUM_TBL.FLP_AGEN_DEP_NO

Deposit Type

DEPOSIT_CONTROL.DEPOSIT_TYPE

Bank Code

DEPOSIT_CONTROL.BANK_CD

Bank Account Key

DEPOSIT_CONTROL.BANK_ACCT_KEY

Bank Account Number

DEPOSIT_CONTROL.BANK_ACCOUNT_NUM

Control Total Amount

DEPOSIT_CONTROL.CONTROL_AMT

Control Count

DEPOSIT_CONTROL.CONTROL_CNT

Accounting Date

DEPOSIT_CONTROL.ACCOUNTING_DT

Reconciliation Type

PAYMENT.RECON_TYPE

Reconciliation Date

PAYMENT. RECONCILE_DT

Reconciliation Status

PAYMENT.RECON_STATUS (Translate Value)

Statement ID

PAYMENT.RECON_CYCLE_NBR

Received Date

DEPOSIT_CONTROL. RECEIVED_DT

Entered Date

DEPOSIT_CONTROL. ENTRY_DT

User ID

DEPOSIT_CONTROL.OPRID

Payment ID

PAYMENT.PAYMENT_ID

Payment Amount

PAYMENT.PAYMENT_AMT

Payment Status

PAYMENT.PAYMENT_STATUS (Translate Value)

GL Distribution Status

PAY_MISC_DST,ITEM_DST.GL_DISTRIB_STATUS

Journal Directly

PAYMENT.MISC_PAYMENT

Payment Predictor

PAYMENT.PP_SW

Payment Sequence

PAYMENT.PAYMENT_SEQ_NUM

Customer ID

PAYMENT_ID_CUST.CUST_ID

Item ID

PAYMENT_ID_ITEM.ITEM

Item Line

PAYMENT_ID_ITEM.ITEM_LINE

Budget Date

PAY_MISC_DST.BUDGET_DT

ITEM_DST. BUDGET_DT

GL Business Unit

PAY_MISC_DST.BUSINESS_UNIT_GL

ITEM_DST. BUSINESS_UNIT_GL

Organization

PAY_MISC_DST.DEPTID

ITEM_DST. DEPTID

Account

PAY_MISC_DST.ACCOUNT

ITEM_DST. ACCOUNT

Fund

PAY_MISC_DST.FUND_CODE

ITEM_DST.FUND_CODE

Budget Entity

PAY_MISC_DST.BUDGET_REF

ITEM_DST.BUDGET_REF

Category

PAY_MISC_DST.PRODUCT

ITEM_DST.PRODUCT

State Program

PAY_MISC_DST.CHARTFIELD2

ITEM_DST.CHARTFIELD2

Grant

PAY_MISC_DST.PROGRAM_CODE

ITEM_DST. PROGRAM_CODE

Contract

PAY_MISC_DST.CHARTFIELD1

ITEM_DST. CHARTFIELD1

OA1

PAY_MISC_DST.CLASS_FLD

ITEM_DST.CLASS_FLD

OA2

PAY_MISC_DST.CHARTFIELD3

ITEM_DST. CHARTFIELD3

PC Business Unit

PAY_MISC_DST.BUSINESS_UNIT_PC

ITEM_DST.BUSINESS_UNIT_PC

Project

PAY_MISC_DST.PROJECT_ID

ITEM_DST.PROJECT_ID

Activity

PAY_MISC_DST.ACTIVITY_ID

ITEM_DST.ACTIVITY_ID

PC Source Type

PAY_MISC_DST.RESOURCE_TYPE

ITEM_DST.RESOURCE_TYPE

PC Category

PAY_MISC_DST.RESOURCE_CATEGORY

ITEM_DST. RESOURCE_CATEGORY

PC Subcategory

PAY_MISC_DST.RESOURCE_SUB_CAT

ITEM_DST. RESOURCE_SUB_CAT

Asset ID Reference

CUSTOM_TABLE.ASSET_ID

ITEM.DOCUMENT

Supplier ID

CUSTOM_TABLE.SUPPLIER_ID

ITEM.BILL_OF_LADING

Verified By

CUSTOM_TABLE.VERIFIED_BY

Verified Date

CUSTOM_TABLE.VERIFIED_DT

Journal ID

PAY_MISC_DST.JOURNAL_ID

ITEM_DST.JOURNAL_ID

Journal Date

PAY_MISC_DST.JOURNAL_DATE

ITEM_DST. JOURNAL_DATE

Created On

PAY_MISC_DST.ENTERED_DTTM

ITEM_DST. ENTERED_DTTM

Created By

PAY_MISC_DST.OPRID

ITEM_DST. OPRID

Last Modified On

PAY_MISC_DST.LAST_UPDATE_DTTM

ITEM_DST. LAST_UPDATE_DTTM

Modified By

PAY_MISC_DST.OPRID_LAST_UPDT

ITEM_DST. OPRID_LAST_UPDT

Distribution Amount

PAY_MISC_DST.FOREIGN_AMOUNT

ITEM_DST. FOREIGN_AMOUNT

ChartField Combo Edit Status

PAY_MISC_DST.CF_EDIT_STATUS (Translate Value)

Line Description

PAY_MISC_DST.LINE_DESCR

ITEM_DST.LINE_DESCR

Version History

Date

Revision Description

12/01/2023

Original Version

11/05/2024Updated Sample Report Layout




Was this article helpful?
What's Next
The Florida PALM Knowledge Center serves as the central hub of information that helps agencies quickly and effectively adopt Florida PALM at Financials and Payroll Wave by providing quick access to the design of the system.
Change password!
Changing your password will log you out immediately. Use the new password to log back in.
Change profile
Success!
First name must have atleast 2 characters. Numbers and special characters are not allowed.
Last name must have atleast 1 characters. Numbers and special characters are not allowed.
Enter a valid email
Enter a valid password
Your profile has been successfully updated.
Logout