Agency Bank Deposit Extract Report (CMR001)
-
Print
-
DarkLight
-
PDF
Agency Bank Deposit Extract Report (CMR001)
-
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.
The Agency Bank Deposit Extract Report will extract unreconciled bank transactions from the bank statement. These bank transactions will need to be recorded as deposits. The objective of this report is to assist agencies with their Direct Journal deposits or Customer deposit entries in Florida PALM.
The Agency Bank Deposit Extract Report can be utilized to assist with populating the Inbound Deposit Spreadsheet Upload (ARI010).
The agency will use the spreadsheet upload to record the deposits in the AR module. The agency will research to input the appropriate accounting for direct journal deposits or input the deposit with the payment predictor flag, Item ID, and customer for application to an accounts receivable on the ARI010 upload tool.
When these deposits are successfully recorded, Florida PALM will then reconcile these transactions as part of the CM Bank Reconciliation process that the Department of Financial Services (DFS), Division of Treasury (Treasury) manages.
Once deposits are loaded into Florida PALM, Deposits will be Approved, Reconciled/Verified, Budget Checked and accounting entries will be created.
Report Navigation: Main Menu>Reporting Tools>Query>Query Viewer
Query Name: FLP_AGENCY_BANK_DEPOSIT_EXT
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 |
Bank Account Group | Optional Field prompt |
Bank | Optional Field prompt |
Bank Account | Optional Field prompt |
Bank Transaction From Date | Mandatory Date format should be available to select the date. |
Bank Transaction To Date | Mandatory Date format should be available to select the date. |
Report Layout
The layout of the report is listed below.
Data Field | Florida PALM RECORD.FIELD mapping |
Agency Deposit Number | Deposit_Control.DEPOSIT_ID |
Deposit Business Unit | Deposit_Control.BUSINESS_UNIT |
Deposit Type | Deposit_Control.DEPOSIT_TYPE |
Accounting Date | Deposit_Control.DEPOSIT_ID |
Bank Code | Deposit_Control.BANK_CD |
Bank Account | Deposit_Control.BANK_ACCT_KEY |
Control Total Amount | Deposit_Control.CONTROL_AMT |
Control Count | Deposit_Control.CONTROL_CNT |
Payment Sequence Number | Payment.PAYMENT_SEQ_NUM |
Payment ID | Payment.PAYMENT_ID |
Accounting Date | Payment.ACCOUNTING_DT |
Payment Amount | Payment.PAYMENT_AMT |
Payment Predictor Flag | Payment.PP_SW |
Direct Journal Flag | Payment.MISC_PAYMENT |
Payment Method | Payment.PAYMENT_METHOD |
Asset ID Reference | TBD |
Supplier ID | TBD |
Payment Sequence Number | Customer Deposit Data |
ID Sequence Number | Customer Deposit Data |
Customer ID | Customer Deposit Data |
Payment Sequence Number | Item Deposit Data |
ID Sequence Number | Item Deposit Data |
Reference Qualifier Code | Item Deposit Data |
Item | Item Deposit Data |
Item Line | Item Deposit Data |
Pay Amount | Item Deposit Data |
Payment Sequence Number | Payment Distribution |
Distribution Sequence Number | Payment Distribution |
SpeedKey | Payment Distribution |
Budget Date | Payment Distribution |
GL Business Unit | Payment Distribution |
Organization | Payment Distribution |
Account | Payment Distribution |
Fund | Payment Distribution |
Budget Entity | Payment Distribution |
Category | Payment Distribution |
State Program | Payment Distribution |
Grant | Payment Distribution |
Contract | Payment Distribution |
OA1 | Payment Distribution |
OA2 | Payment Distribution |
PC Business Unit | Payment Distribution |
Project | Payment Distribution |
Activity | Payment Distribution |
PC Source Type | Payment Distribution |
PC Category | Payment Distribution |
PC Subcategory | Payment Distribution |
Line Description | Payment Distribution |
Foreign Amount | Payment Distribution |
Accounting Date | Payment Distribution |
Version History
Date | Revision Description |
12/01/2023 | Original Version |
| 06/05/2024 | Updated Description |
| 11/13/2024 | Update Sample Report Layout |
Was this article helpful?
