Direct Journal Deposits (60.2.1)
  • 12 Mar 2024
  • 18 Minutes to read
  • Dark
    Light
  • PDF

Direct Journal Deposits (60.2.1)

  • Dark
    Light
  • PDF

Article summary

Business Process Overview

Direct Journal Deposits are used to record payments that are not generally associated with a customer or outstanding receivables. A deposit can have one-to-many payments and one-to-many accounting lines. The agency will make a business decision to understand the level at which they need to enter payments and accounting lines. Direct Journals are also used to correct accounting entries or reclassify revenues within their agency through $0 deposits. Once deposits and payments are recorded in Florida PALM, they must be verified and approved to go through system checks (e.g., Edit, Budget, and Cash) and posted to the ledger where the fund cash balance is updated in Florida PALM. Successfully passing these checks and posting them to the ledgers makes the deposit amount available for agency use.

Business Process Diagram

Business Process Diagram for 60.2.1 Direct Journal Deposits (part 1)

Business Process Diagram for 60.2.1 Direct Journal Deposits (part 2)
Business Roles

The Business Process Flow Diagrams use horizontal swim lanes to depict where different parties or systems perform activities. Each swim lane is titled with a role, either agency-based or within DFS, and in some cases, is representative of an external entity or system. The swim lanes may change from page to page within a single business subprocess as more or fewer roles are required to execute sections of the business subprocess. 

Business Process Flows Details

The tables below describe steps in each business subprocess as reflected on the Business Process Flow Diagrams. The tables also reflect information associated with each step, describing the intent of the specific process. Florida PALM screenshots are included within the sections to allow connections to be made from specific business subprocess steps to screens within Florida PALM. This information should be read in conjunction with the Business Process Flow Diagrams.

Process Step ID

Process Step Title

Description of Process

1

Determines Need to Record Deposit

The Agency AR Deposit Processor receives a payment that is not tied to an open receivable item. Such payments are referred to as Direct Journal Payments. If the deposit is a paper check, the last three digits of the deposit slip number can be entered as the Agency Deposit Number (e.g.,111) while creating the deposit for bank reconciliation purposes.


Deposits with a non-revenue GL ChartField Account (e.g., Expenditure Refund to GL Account – 7*****) will require agency and DFS Accounting & Auditing approval through workflow. The best practice is to separate the non-revenue deposits from revenue deposits when preparing the bank deposit slip or transmitting with the bank. The agency business process to separate the non-revenue deposits from the revenue deposits upfront when transacting with the bank will minimize cash delays due to the workflow required on non-revenue deposits.


The agency may also need to reclassify revenues through a $0 deposit.

2

Obtain Electronic Deposit #

Before entering electronic deposit payments in Florida PALM, the Agency AR Deposit Processor reviews the ARR021 Unreconciled Deposits Report to obtain the deposit number (e.g., 11111A) and confirm the amount.


3

Inbound Deposit Data (ARI007, ARI010)

Some agencies provide deposit information via a file, which can be loaded to create the deposit and payments. The Agency AR Deposit Spreadsheet Upload Processor user is responsible for creating and loading the ARI010 Inbound Deposit Spreadsheet Upload file, and the ARI007 Inbound Deposit Data interface is loaded through the batch process as an agency business system interface file.


Deposits with a non-revenue GL ChartField Account (e.g., Expenditure Refund to GL Account – 7*****) will require agency and DFS Accounting & Auditing approval through workflow. The best practice is to separate the non-revenue deposits from revenue deposits when preparing the bank deposit slip or transmitting with the bank. The agency business process to separate the non-revenue deposits from the revenue deposits upfront when transacting with the bank will minimize cash delays due to the workflow required on non-revenue deposits.


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 accounting data to complete the deposit and payment entries.


The user will need to provide and enter accounting data 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.


Most deposits and payments interfaced bypass approval workflow and are marked approved systematically through the interface processing. If for example, a non-revenue GL ChartField Account (e.g., Expenditure Refund to GL Account – 7*****) is entered through the interfaces, the payment is routed through workflow (ARW002) for an agency-level approval before routing for the DFS audit level approval.


Once the interfaces create deposits and payments, the system transactions are available for reconciliation to the bank statement transactions. The agencies can monitor the reconciliation process to confirm the deposit is verified. Deposits and payments must be verified and approved to go through the system jobs (e.g., edit check, budget check, cash check, and post to the ledgers).


6

Create Deposit and Accounting Entries

The Agency AR Deposit Processor enters the required payment information on the deposit page. ChartField values are used to link and report deposits associated with projects, grants, and contracts. There are also fields on the deposit to reference a Supplier ID and an Asset ID.


Federal and State funds can be included in one deposit and identified separately in the accounting lines.


If the deposit is related to a clearing fund bank, a specific deposit type is used for financial reporting purposes.


If the deposit is for a revenue reclassification that does not require budget authority, a $0 deposit entry is created with payments and accounting lines representing the revenue reclassifications.


Supporting documentation can be attached for each payment. The DFS A&A Expenditure Refund Form is attached at this step and may require an Accounts Payable (AP) payment query to obtain data for completion.


Once the agencies create deposits and payments, the system transactions are available for reconciliation to the bank statement transactions. The agencies can monitor the reconciliation process to confirm the deposit is verified. Deposits and payments must be verified and approved to go through the system jobs (e.g., edit check, budget check, cash check, and post to the ledgers).


If entered online manually, the deposit and payment routes through workflow (ARW002) to the Agency AR Deposit Approver for approval.


Figure 1 and Figure 2 provide an example of the Deposit Control Page, Totals Tab, and Payments Tab, where deposit and related payment(s) information is displayed.


Figure 3 provides an example of the Modify Accounting Entries Page, Directly Journalled Payments Tab, where accounting information is displayed.


7

Approve Deposit (ARW002)

The deposit approvers use the Direct Journal Deposit Approval link in the WorkCenter to review any payments pending their approval.


If the deposits and payments are Denied, or the Agency AR Deposit Approver requests more information, the ARW002 Direct Journal Workflow routes the transaction back to the Agency AR Deposit Processor to provide updates or more information.


If a deposit and payment(s) include non-revenue and revenue accounting together on a transaction, the Agency AR Deposit Approver can deny the transaction through workflow and request the Agency AR Deposit Processor to update the non-revenue accounting line to a revenue default accounting line. The update will allow for the transaction to continue in the lifecycle without routing to the DFS AR Audit Approver, which would cause a cash delay. The Agency AR Deposit Processor can create a $0 deposit to reverse the revenue default accounting line and enter the non-revenue accounting line to be routed through workflow for approval. The $0 deposit separates the non-revenue accounting line from the revenue accounting line on the original deposit.    


If transactional updates are completed, the transactions will be routed back through all applicable Approvers.


If the transaction is Denied and the Agency AR Processor does not make updates, the agency will follow the 60.1.4 AR Period Close business process to close out the transaction.


If the deposits and payments are Approved by the Agency AR Deposit Approver, the transaction lifecycle proceeds.


Deposits and payments must be verified and approved to go through the system jobs (e.g., edit check, budget check, cash check, and post to the ledgers).


If the payment accounting is for a non-revenue GL ChartField Account (e.g., Expenditure Refund to GL Account – 7*****), the transaction routes to the DFS AR Audit Approver.


8

Approve Deposit (ARW002)

The deposit approvers use the Direct Journal Deposit Approval link in the Work Center to review any pending payments.


If the deposits and payments are pushed back through the ARW002 Direct Journal Workflow by the DFS AR Audit Approver, the transactions route back to the Agency AR Deposit Approver to provide more information.


If Request Information is used through the ARW002 Direct Journal Workflow by the DFS AR Audit Approver, the transactions are placed on hold for the Agency AR Deposit Processor to provide more information before the approval process can proceed.


If the deposits and payments are Denied through the ARW002 Direct Journal Workflow by the DFS AR Audit Approver, the transactions route back to the Agency AR Deposit Processor for updates (e.g., update to prior year revenue account for expenditure refunds).


If transactional updates are completed, the transactions will be routed back through all applicable Approvers.


The transaction lifecycle proceeds if the DFS AR Audit Approver approves the deposits and payments.


Deposits and payments must be verified and approved to go through the system jobs (e.g., edit check, budget check, cash check, and post to the ledgers).


9

Submit Same Day Deposit Type (ARW002)

In cases where deposit verification approval is needed before receiving the bank statement file, the agency submits a Same-Day Deposit Type to be routed through the ARW002 Direct Journal Workflow for Treasury review.


10

Approve Same Day Deposit Type (ARW002)

The deposit approvers use the Direct Journal Deposit Approval link in the Work Center to review any payments pending their approval.


The Treasury reviews and approves the same-day deposit entry based on validating the information in the banking portal. The workflow is used for large ACH or wire deposits on a case-by-case basis.


If the deposit and payment are Denied or the DFS Same Day Deposit Approver requests more information, the ARW002 Direct Journal Workflow routes the transaction back to the Agency AR Deposit Processor to provide updates or more information.


The transaction routes back through all applicable Approvers if a transactional update is completed.


If the transaction is Denied and the Agency AR Processor does not make updates, the agency will follow the 60.1.4 AR Period Close business process to close out the transaction.

If the deposit and payment are Approved by the DFS Same Day Deposit Approver, the transaction lifecycle proceeds.


Deposits and payments must be verified and approved to go through the system jobs (e.g., edit check, budget check, cash check, and post to the ledgers).


11

Review Unreconciled Same-Day Deposits

DFS Same Day Deposit Approver reviews unreconciled system transaction deposits entered by the agency against unreconciled bank transactions for reconciliation purposes.


12

Semi Manual Reconciliation

If the same-day deposit system transaction matches the bank transaction, the DFS Same Day Deposit Approver reconciles the transactions together through the Semi Manual Reconciliation page.


13

Review Unreconciled Deposits

After bank reconciliation runs, 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.


14

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

The Agency AR Deposit Processor submits a Treasury Correspondence Form – Research Req Reconciliation form to provide the specific bank or deposit assistance needed.


15

Review Assistance Needed

If a bank correction is needed, the DFS CM Bank Reconciliation Processor contacts the bank. If the DFS CM Bank Reconciliation Processor needs further information, the form is routed back to the Agency AR Deposit Processor.


16

Run Edit Check

Edit Check process will run at the designated interval. Edit check process will validate that ChartField values are active, validate the 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.


17

Resolve Edit Errors

Edit errors must be resolved before the transaction proceeds. 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 the transaction date falls within an open period.


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


18

Run Budget/Cash Check

For revenue deposits, the Budget Check process will run at the designated interval to increase or decrease the revenue balances. The Revenue Budget check is set to systematically pass when revenue Account values are present on a transaction to allow revenue to post.


For revenue deposits, the Cash check process will run at the designated interval to confirm using valid ChartFields and increase or decrease the spendable cash balances.


Expenditure Refund deposits, the Budget check process will run at the designated intervals to confirm use of valid ChartFields and restore the appropriation balances expended and received within the same fiscal year.


Expenditure Refund deposits the Cash Check process will run at the designated intervals to confirm using valid ChartFields and increase the spendable cash balances.


The transaction lifecycle will proceed when a Revenue or Expenditure Refund deposit passes the budget and cash check with no exceptions.


19

Manage Budget/Cash Exceptions

The transaction will fail if a deposit consumes cash (e.g., debit deposit adjustment) and exceeds the spendable cash balance. Transactions with errors stop at the cash-checking stage and do not proceed until the error is corrected or overridden by DFS. Please see 20.2 Budget Execution and Management for more information.


If an Expenditure Refund deposit results in an available appropriation balance that exceeds the original appropriation amount (e.g., expenditure refund amount exceeds the total expended for the fiscal year) or no budget exists for the ChartField String, the transaction fails the budget check. The Agency AR Deposit Processor can update the ChartField string (e.g., update to prior year revenue account, update expenditure category) to resolve the error or contact the Agency KK Budget and Cash Maintainers. Internal agency policy should guide the Agency AR Deposit Processor regarding transaction processing when an error is returned. Please see 20.2 Budget Execution and Management for more information.


Budget and cash check errors are systematically checked until they are resolved.


20

Update Ledger Balances

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


21

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.


Figure 4 provides an example of the Modify Accounting Entries Page, where the Journal IDs are referenced after the JGEN process.


22

Export Deposit Data

Florida PALM exports agency-specific Direct Journal Deposit data.


23

Outbound Deposit Data (ARI024)

Outbound Direct Journal Deposits and payments are sent to agency business systems.

Figure 1: Deposit Control Page, Totals Tab

Deposit Control Page, Totals Tab

Figure 2: Deposit Control Page, Payments Tab

Deposit Control Page, Payments Tab

Figure 3: Modify Accounting Entries Page, Directly Journalled Payments Tab

Modify Accounting Entries Page, Directly Journalled Payments Tab

Figure 4: Modify Accounting Entries Page, Directly Journalled Payments Tab


Accounting Events

Accounting events originate during transaction processing in the applicable source module. The accounting events impact the source module, Commitment Control ledgers, and the General ledger (Actuals).

  • Source Module accounting entries require user input (I) of the primary line (i.e., expenditure, revenues) with an automated (A) system offsetting line (i.e., payable, receivable) during transaction entry. The source model transaction must pass Edit Check, Budget Check, and Cash Check (on applicable entries) before posting the transaction.
  • If the transaction passes the budget check process, the Run Budget Check (Commitment Control) process automatically affects balances in the appropriate budget ledger (i.e., appropriation, spendable cash).
  • After the transaction is posted in the source module, an automated system process summarizes and posts the entries in the General Ledger module to the Actuals Ledger.

The table below provides the most common accounting events applicable to this business process.

Acct Event ID 

Accounting Event

Commitment Control
Ledger(s) Impact

Source Module
Accounting Entry

General Ledger (Actuals) Entry

AR01

Revenue Deposit

Increases Collected Revenue Balance, Increases Spendable Cash Balance

Debit: Cash (S)

Credit: Revenue (U)

Debit: Cash

Credit: Revenue

AR02

Revenue Deposit Returned Item or Bank Adjustment

Decreases Collected Revenue Balance, Decreases Spendable Cash Balance

Debit: Revenue (U)

Credit: Cash (S)

Debit: Revenue

Credit: Cash

AR03

Expenditure Refund Deposit

Increases Spendable Cash Balance, Increases Available Appropriations Balance

Debit: Cash (S)

Credit: Expenditures (U)

Debit: Cash

Credit: Expenditures

Reports

Key Reports are displayed as icons with the Report Number on the Business Process Flow Diagrams. The table below provides the reports identified to be produced at a particular process step or used to support the completion of a process step.

Report Number

Report RICEFW ID

Report Description

Report Source

Report Frequency

Audience

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. The 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

R4

ARR020

Reconciled Deposits Report – A report that provides reconciled deposits. Report can be used to monitor deposits that have been reconciled.

PeopleSoft

Periodic

Agency, DFS

R5

ARR070

DOR Agency Deposit Report – A report that provides a list of Agency Deposit transactions that were entered by DOR.

PeopleSoft

Periodic

Agency, DFS

R6

KKR058

Budget and Cash Checking Exceptions/Warnings Report – A custom report that lists transactions budget and cash check exceptions and warnings along with transaction amounts, to include the type of exception and where an override was applied.

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

Note: A complete list of reports may be found in the Reports Catalog.

Interfaces

The table below provides the Interface IDs for each interface identified on the Business Process Flow Diagrams.

Interface Number

Interface Description

Interface Frequency

Source

Target

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

Note: A complete list of interfaces may be found in the Interface Catalog.

Forms

The table below provides the Form Numbers for any forms identified on the Business Process Flow Diagrams.

Form Number

Form Description

Audience

CMF007

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

Agency, Treasury

Workflows

The table below provides the Workflow Numbers for any workflows identified on the Business Process Flow Diagrams.

Workflow Number

Workflow Description

Audience

ARW002

Direct Journal Workflow – Workflow that routes Direct Journal Deposit entries for approval.

Agency, A&A, Treasury

Version History

Date

Revision Description

12/22/2023

Original Version

Attachments

Was this article helpful?

Changing your password will log you out immediately. Use the new password to log back in.
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.