Reconciled Deposits Report (ARR020)
-
Print
-
DarkLight
-
PDF
Reconciled Deposits Report (ARR020)
-
Print
-
DarkLight
-
PDF
Article summary
Did you find this summary helpful?
Thank you for your feedback
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 been reconciled within Florida PALM. Florida PALM imports bank statements and performs a reconciliation process where system transactions are reconciled with bank transactions. Once the reconciliation process occurs, the reconciled deposits are available to view in this query. This report is used to monitor whether funds deposited are correctly accounted for and reconciled in Florida PALM. The Reconciled Deposit Report will display only reconciled deposit transactions that exist in Florida PALM.
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_Reconciled_Deposits_Report
See the sample layout report below.
Business Roles
The following business roles have access to this report:
- Agency AR Deposit Processor
- Agency AR Deposit Spreadsheet Upload Processor
- Agency AR Deposit Approver
- Agency AR Deposit Reporter
- DFS CM Bank Reconciliation Processor
- DFS Same Day Deposit Approver
- DFS AR Deposit Processor
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/2024 | Updated Sample Report Layout |
Was this article helpful?
