AR Deposits (60.2.2)

1

Receive Payment from Customer

The Agency AR Deposit Processor receives a payment from a customer. If the Agency AR Deposit Processor receives a request to create a small volume of deposits, the Agency AR Deposit Processor creates a customer payment in Florida PALM online through a manual process.

2

Create Online Deposit

The Agency AR Deposit Processor enters the required information related to a customer payment on the deposit page. If the deposit is related to a customer payment, an Item reference will need to be entered for Payment Predictor to match the customer payment to the item.   

Once customer payments are created by the agencies, the system transactions are available for Payment Predictor to match to an Item and reconcile to the bank statement transactions. 

The agencies can monitor the reconciliation process to confirm the customer payment is verified. 

Below provides an example of the Deposit Control Page, Totals Tab, and Payments Tab where deposit and related payment(s) information is displayed. 

3

Inbound Deposit Data (ARI007, ARI010)

Some agencies provide deposit information via a file, which can be loaded to create the customer payment. 

The Agency AR Deposit Spreadsheet Upload Processor user is responsible for creating and loading the ARI010 Inbound Deposit Spreadsheet Upload file. 

The ARI007 Inbound Deposit Data interface is loaded through the batch process as an agency business system interface file.

The CMR001 Agency Bank Deposit Extract report provides bank data in the ARI010 Inbound Deposit Spreadsheet Upload format. Bank data from the report can be copied and pasted to the spreadsheet upload template for a starting point to load deposits. The user will need to provide and enter the customer and item date to complete the deposit and payment entries.

The CMI004 Outbound Bank Deposit Transactions and the CMI013 Outbound BAI Bank Statement interfaces provide bank data to agencies for creating their inbound deposit files (ARI007 and ARI010). 

4

Perform Interface Error Checking

Edit validations are performed on each interface before the data is allowed to load to the AR module. If the file is rejected, all transactions in the file are rejected and the file must be resubmitted once the issue is resolved.

If the file is not rejected, edit validations are performed on each transaction before the data is allowed to load for processing in the AR module. Additional edits will be performed during the transaction life cycle.

Rejected transactions are managed through the 120.1 Interface Error Handling Process.

Edit Validations include:

• ChartField Validation
• Amount Validation
• Open Period Validation
• Supplier Validation

5

Load Deposit Data

Data passing the initial edits is interfaced and loaded into the AR module through an automated process. 

Interfaced customer payments bypass approval workflow and are marked approved systematically through the interface processing. 

Once customer payments are created by the interfaces, the system transactions are available for Payment Predictor to match to an Item and reconcile to the bank statement transactions. The agencies can monitor the reconciliation process to confirm the customer payment is verified. Customer payments must be reconciled and verified to go through the system jobs (e.g., edit check, budget check, cash check, and post to the ledgers). 

6

Payment Predictor

If the deposit is recorded to an open AR Item, then the system uses the Payment Predictor process to apply payment to the open AR Item. Payment Predictor uses Customer, Amount, and Item ID criteria to systematically match deposits to the open AR item.

7

Review Unreconciled Deposits

If the deposit is not reconciled, the Agency AR Deposit Processor must review and determine why the deposit is not reconciled. If a deposit correction is needed, the Agency AR Deposit Processor must correct the deposit entry to match the bank deposit information. If a bank correction is needed, the Agency AR Deposit Processor must contact Treasury.

8

Submit Research Request/Recon. Assist. Form (CMF007)

The Agency AR Deposit Processor submits a Treasury Correspondence Research Request/Reconciliation Assistance Form to provide the specific correction needed at the bank. The Agency AR Deposit Processor can also submit this form to claim a deposit not correctly identified.

9

Review Assistance Needed

If a bank correction is needed, the DFS Bank Reconciliation Processor contacts the bank. If the DFS Bank Reconciliation Processor needs further information, the Treasury Request Assistance Request Form is routed back to the Agency Deposit Processor.

10

Build Worksheet and Apply Payment

If Payment Predictor process is not selected, the Agency AR Deposit Processor builds a Payment Worksheet and selects an open AR item to apply payment manually.

If Payment Predictor process is selected and is incomplete where the customer has an underpayment, the system creates a payment worksheet, and the Agency AR Deposit Processor manually applies the underpayment to the item.

If Payment Predictor processes an overpayment, the system creates a payment worksheet with a line for the Open Item and a line for the New Item related to the overpayment amount. Once the Payment worksheet is set to post the system applies the payment line to the Open Item and posts the New Item credit to the customer account for the overpayment.

The overpayment credit Item has two paths for processing. The Agency AR Item Processor creates a maintenance worksheet to refund the customer (60.1.2 Refund AR business subprocess) or the Agency AR Deposit Processor creates a payment worksheet to apply the credit Item to an open AR Item.   

Below shows an example of the Payment Worksheet.

11

Set Worksheet to Post

The Agency AR Deposit Processor sets the Payment Worksheet to post by selecting Batch Standard on the page. This step is required for the Receivables Update to process the payment transaction and continue the lifecycle.

Below provides the Payment Worksheet page where the user selects Batch Standard.

12

Run Edit Check

Edit check process will run at the designated interval. Edit check process will validate that ChartField values are active, validate combination edit rules applicable to the transaction (i.e., does transaction reflect an accurate Budget Entity to State Program correlation), and validate the accounting period is open.

Below Figure 9 shows an example of journalled customer payment accounting entry.

13

Resolve Edit Errors

Edit errors must be resolved prior to transaction proceeding. The Agency AR Deposit Processor should confirm the validity of the ChartField values and the ChartField string used on the transaction and make necessary updates. Agency AR Deposit Processor should confirm that date of transaction falls within an open period. 

If error persists after making updates, and a SpeedKey is being used, Agency AR Deposit Processor should consult with Agency COA Maintainer to determine if the SpeedKey was established inaccurately. 

14

Run Budget/Cash Check

The Budget Check process will run at the designated interval to increase the collected revenue balance. Budget check is set to systematically pass. 

The Cash Check process will run at the designated interval to confirm use of valid ChartFields and increase the spendable cash balances. 

When an AR Item passes budget and cash check, the transaction lifecycle will proceed.

15

Update Ledger Balances

Upon passing the budget and cash check, the applicable revenue, cash, and budget ledgers will be updated. Please see 20.2 Budget Execution and Management for more information.

16

Generate GL Journals

Journal Generator (JGEN) processes posted accounting entry data from the Florida PALM source modules, summarizes the data, and creates journals in the General Ledger. The Journal Generator process will edit, budget check, and post the journal entries created during the process. Please see 10.2 Enter and Process Journals for more information on source module journal entries.

17

Export Deposit Data

Florida PALM exports agency specific AR Deposit data.

18

Outbound Deposit Data (ARI024)

Outbound AR Deposits and payments are sent to agency business systems.

AR08

AR Deposit

Debit: Cash (S)
Credit: AR (U)

Increases Collected Revenue Balance, Increases Spendable Cash Balance

Debit: Cash
Credit: AR

R1

CMR001

Agency Bank Deposit Extract Report – A report that provides a query to prepopulate the deposit spreadsheet from the bank statement file to assist agencies in recording deposits.

PeopleSoft

Periodic

Agency, DFS

R2

ARR021

Unreconciled Deposits Report – A report that provides a list of unreconciled deposits. Report includes unreconciled bank data to assist with deposit entries that are needed in the system for reconciliation.

PeopleSoft

Periodic

Agency, DFS

R3

ARR007

Deposit Report – A report that provides detailed information for deposits. 

PeopleSoft

Periodic

Agency, DFS

R7

KKR023

Revenue Report – A report that provides revenue estimates, revenue recognized, and revenue collected by Fund, Budget Entity, Category, and account code by ChartField combinations.

PeopleSoft

Periodic

Agency, DFS

ARI007

Inbound Deposit Data – Inbound interface file that provides direct journal and customer deposit information from business systems.

Daily

Agency Business Systems

Florida PALM

ARI010

Inbound Deposit Spreadsheet Upload – Inbound interface file that provides direct journal and AR deposit information via a spreadsheet (Excel) upload.

Daily

Agency Business Systems

Florida PALM

ARI024

Outbound Deposit Data – Outbound interface file that provides Item payment and Direct journal payment data to business systems.

Daily

Florida PALM

Agency Business Systems

CMF007

Research Request/Reconciliation Assistance - Request form used by organizations to request Research Request/Reconciliation Assistance from DFS.

Agency, Treasury

N/A

02/08/2024

Original Version