Invested Balance Checking (20.2.3)
  • 02 Apr 2024
  • 11 Minutes to read
  • Dark
    Light
  • PDF

Invested Balance Checking (20.2.3)

  • Dark
    Light
  • PDF

Article Summary

Business Process Overview

The Commitment Control (KK) module is designed for control, management, and reporting of budget. The KK module includes the Invested Balance Checking business subprocess within Florida PALM that validates General Ledger module transactions to the Investments Ledger, along with the appropriate ChartField values.

The Invested Balance Checking business subprocess addresses how invested cash balances are checked and updated. Invested cash balances are updated as investments and disinvestments are made. The Invested Balance Checking business subprocess compares investments to investment appropriations and disinvestments to the available invested cash balance. General Ledger journal entries without an invested balance account type of asset (e.g., equity, liability, and revenue) are excluded from this process and proceed with the transaction lifecycle.

The Investment/Disinvestment Journal Automation, referenced as the Investment Activity Entry page, is built to simplify the Investment/Disinvestment journal entry process to enable agency users to perform the Investments/Disinvestments efficiently in a controlled manner and to minimize errors. When there is not sufficient investment appropriations or invested cash balance, the transaction will fail the Invested Balance Checking process, generate budget exception errors (no warnings apply to this process), and there are no impacts to the KK Investment Ledger.

The Invested Balance Checking budget exceptions are errors and defined as follows:

  • Errors– These are budget exceptions that have failed Budget Checkbecause they do not conform to the established rules. Once Budget Check errors occur, the options available to resolve Invested Balance Checking errors in the General Ledger module are as follows:
    • Change source transaction (includes amount and/or ChartFields);
    • Cancel / Delete transaction; or
    • Request Override (extraordinary instances)

Budget Check errors continue to be systematically checked by KK until the budget errors have been resolved. Once Budget Check errors are resolved the transaction lifecycle continues in the General Ledger module.

Florida PALM has been designed for extraordinary instances whereas an agency can submit an Override Request Form which includes workflow to DFS for review and consideration. The DFS Override Processor has the appropriate security to override a budget, cash, and invested balance error based upon an agency’s override request form submission, along with supporting documentation. The Override Request Form is not intended as an accounting and budget management tool for day-to-day operations. Agencies are expected to use appropriate accounting and budget policies along with acceptable business practices to manage operations. For those agencies who choose the allotments ledger control option, KK security will be applied to allow agency override for the allotments ledger only and this does not apply to the Override Request Form process.

The following are examples of Override Request Form considerations that agencies could use to address time sensitive and/or extraordinary instances, but not limited to:

  • Transactions supported by legislative Back of the Bill appropriations,
  • Budget Amendments (emphasis on extraordinary instances); or
  • Declaration of State of Emergency

Agencies should be prepared to provide the following:

  • Justification which includes detail information,
  • Agency’s fiscal impact statement; and
  • Supporting documentation

The DFS Override Processor works collaboratively with the Executive Office of the Governor/Office of Policy and Budget (EOG/OPB) to review override request form and render a decision to approve or deny and request additional information from agency, if needed. Once the transaction is approved or denied, Florida PALM will systematically notify the agency of the decision, with the noted outcome:

  • Approve – The DFS Override Processor approves override request, the transaction is overridden and manually submitted for Budget Check to pass, and the transaction will proceed to its source module lifecycle.
  • Denied – The DFS Override Processor denies override request and the agency will need to take alternative action to modify transaction and resubmit for Budget Check.

Transactions that are approved for override and/or denied will be included on the Budget and Cash Checking Exceptions/Warnings Report.

Florida PALM will be configured for those rare instances whereas DFS can assign a Commitment Control attribute to designate ChartField values, to permit systematic override of transactions for a designated period of time, as deemed appropriate.

The KK module provides designated users management and reporting tools to support the resolution of budget exceptions, such as:

  • Commitment Control email notification feature and workflow worklist page, which includes errors and warnings; and
  • Commitment Control online screens (i.e., Commitment Control Exceptions Dashboard, Budget Exception Inquiry, Budget Overview, Budget Detail, and Log Activity) which display and enable drill down capability to view summarized and detailed information regarding budget journals, source transactions, and budget exceptions, with user-defined dimensions.

Business Process Diagram

Business Process Diagram for 20.2.3 Invested Balance Checking

Business Roles

The Business Process Flow Diagrams use horizontal swim lanes to depict where activities are performed by different parties or systems. Each swim lane is titled with a role, either agency-based or within DFS, and in some cases, are 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

Run Invested Balance Checking

The Investment Activity Entry page simplifies the Investment/Disinvestment journal entry process to enable agency users to perform the Investments/Disinvestments efficiently in a controlled manner and to minimize errors.


Invested Balance Checking is initiated by the General Ledger (GL) module using the Investment Activity Entry page and will check investment appropriations or available invested balance. Investment and disinvestment transactions created as described in the 10.2.3 Agency Create and Approve Journals process are subject to Invested Balance Checking. Invested Balance Checking validates investment transaction amounts to available investment appropriations and ChartField values and validates disinvestments to the invested balance available and ChartField values.


The use of the Investment Activity Entry page will minimize errors and therefore, if no errors result from the Invested Balance Checking the transaction passes, updates the KK Investment ledger, and proceeds forward in the GL module transaction lifecycle. If errors exist that cannot be resolved through the Investment Activity Entry page, the GL Journal Processor manages the errors directly in the GL.


2

Update KK Investments Ledger Balances

Investment transactions that successfully pass Investment Balance Checking for investment appropriations are processed, will consume budget, increase the KK investments ledger balance, and proceed with the transaction lifecycle.


Disinvestment transactions that successfully pass Investment Balance Checking for invested amounts will consume the amount from the available invested balance, decrease the KK investments ledger balance, and proceed with the transaction lifecycle.


The Investment Activity Report is available for review and management purposes.


3

Manage Invested Balance Exceptions Issued

The use of the Investment Activity Entry page will minimize errors and reflect if there is insufficient investment appropriations or insufficient invested balance amounts. If the balance is insufficient to support the transaction, the transaction fails the Invested Balance Checking.

If the investment transaction fails, the agency verifies the remaining investment appropriations by using the KK Budget Overview page or the Investment Activity Entry page to ensure investment appropriations are available to perform the investment transaction.


If the disinvestment transaction fails, the agency updates or deletes the transaction. The GL Journal Processor completes the update following the 10.2.3 Agency Create and Approve Journals business process.


The Budget and Cash Checking Exceptions/Warnings Report and Investment Activity Report are available for review and management purposes.


4

Perform Edits in General Ledger Module

The use of the Investment Activity Entry page will minimize errors prior to transaction being submitted for invested balance checking. If the page is bypassed, errors can occur. The GL Journal Processor can perform due diligence to review and resolve invested balance checking errors directly in the GL. Once Invested Balance Checking errors occur, the options available to resolve errors in the General Ledger module are as follows:


  • Change Transaction (includes amount and/or ChartFields);
  • Cancel / Delete transaction; or
  • Request Override (extraordinary instances)


Invested Balance Checking errors continue to be systematically checked by Commitment Control until the errors have been resolved. Once Investment Balance Checking errors are resolved the transaction lifecycle continues in the General Ledger module and KK Investments ledger is updated accordingly. Transactions with errors or have failed Invested Balance Checking, do not consume budget, and will not update the KK Investments ledger.


Figures below display a journal entry with journal status = E and error message.


The Budget and Cash Checking Exceptions/Warnings Report and Investment Activity Report are available for review and management purposes.


5

Submit Override Request Form

The GL Journal Processor submits Override Request Form, along with supporting documentation through workflow to the DFS Investment Override Processor for consideration.


The Budget and Cash Checking Exceptions/Warnings Report and Investment Activity Report are available for review and management purposes.


6

Review Override Request Form

The DFS Investment Override Processor determines if an override of the invested balance is appropriate and if approved, the DFS Investment Override Processor manually overrides the transaction and either initiates budget check to occur immediately or on the next system scheduled budget check process. Once the transaction is investment balance checked, it will pass and update the KK investments ledger balance to consume the amount from the available balance and proceed with the transaction lifecycle.


With approval of override request, the transaction meets the Invested Balance Checking rules established, the transaction continues processing as described in the below business subprocesses:


The Budget and Cash Checking Exceptions/Warnings Report and Investment Activity Report are available for review and management purposes.


7

Email Notification of Approval to Agency

Once the transaction is approved, Florida PALM will systematically notify the agency of the decision.


The DFS Investment Override Processor has approved the override request, the transaction is overridden and manually submitted for Investment Balance Check to pass, and the transaction will proceed to its source module lifecycle.


Transactions that are approved for override and/or denied will be included on the Budget and Cash Checking Exceptions/Warnings Report.


The Investment Activity Report is available for review and management purposes.


8

Email Notification of Denial to Agency

Once the transaction is denied, Florida PALM will systematically notify the agency of the decision.


The DFS Investment Override Processor has denied the override request, and the agency will need to take alternative action to modify transaction and resubmit for Investment Balance Check.


Transactions that are approved for override and/or denied will be included on the Budget and Cash Checking Exceptions/Warnings Report.


The Budget and Cash Checking Exceptions/Warnings Report and Investment Activity Report are available for review and management purposes.


Journal Entry with Journal Status = E

Journal Entry with Journal Status = E

Error Message

Error Message

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) prior to posting the transaction.
  • The Run Budget Check (Commitment Control) process automatically affects balances in the appropriate budget ledger (i.e., appropriation, spendable cash) if the transaction passes the budget check process.
  • 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

N/A

Accounting Events occur in the General Ledger and source modules and not directly in the Commitment Control Ledger.

Reports

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

Report Number

Report RICEFW ID

Report Description

Report Source

Report Frequency

Audience

R4

KKR058

Budget and Cash Checking Exceptions/Warnings Report – 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

DFS, Agency

R6

GLR083

Investment Activity Report – Investment transactions and balances by pool and participant. 

PeopleSoft

Periodic

DFS, Agency

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

Interfaces

The table below provides the Interfaces identified on the Business Process.

Interface Number

Interface Description

Interface Frequency

Source

Target

N/A





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

Forms

The table below provides the forms identified on this Business Process.

Form Number

Form Description

Audience

KKF001

Override Request Form – Request form used by agencies to request a Budget or Investment Balance Checking override from DFS.

Agency KK Budget Processor, Agency KK Budget Maintainer, DFS Override Processor

Workflows

The table below provides the workflows identified on this Business Process.

Workflow Number

Workflow Description

Audience

KKW002

Override Request Workflow – Workflow that routes the Override Request Form to DFS A&A for approval.

Agency KK Budget Processor, Agency KK Budget Maintainer, DFS Override Processor

Version History

Date

Revision Description

03/25/2024

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.