Jeff Atwater | CFO

The Florida PALM Solution

Technology

Florida PALM will operate on Oracle® PeopleSoft 9.2, will leverage a Service Oriented Architecture (SOA), will be hosted by Oracle Cloud Infrastructure, and will be connected via MyFloridaNet-2. Florida PALM will be web-based with adaptable user interface.

View the Catalog of Interface Offerings. A list of business systems and their planned interface approach for the CMS Wave go-live is in progress.

Reporting

Oversight, enterprise partners, and agency end users will have access to reports, data, and reporting tools in Florida PALM. End users will access reports and data through standard reports, inquiries, data extracts, or dashboards. Agencies may choose to use existing reports or create agency-specific reports using self-service functionality.

A Reports Catalog lists the reports identified for the CMS Wave. This report will be validated through agency collaboration and will expand during future implementation waves.

The Reporting Approach and reporting demonstrations can be used to learn more about Florida PALM reporting.

Functional Transition

The following accounting and cash management functions will transition to Florida PALM:

  1. CMS – cash management functions
  2. Central – State budgeting functions
  3. Departmental/Reporting – State agencies’ accounting records and budget management fuctions
  4. Payroll – payroll functions
  5. Enhanced Functionality – additional functionality (e.g., Projects and Grants) will be implemented for all State agencies

In 2021, all organizations will transition to Florida PALM for Treasury Cash Management Systems (CMS) functionality.

In 2022, all organizations will transition to Florida PALM for Central FLAIR functionality.

In 2024, all organizations will transition to Florida PALM for Payroll (planned for January) and Departmental FLAIR functionality (planned for July).

In 2026, the Project plans to implement additional functionality for all organizations.

View the Project Timeline for details on the implementation schedule.

Statewide Chart of Accounts Design

The Florida PALM Chart of Accounts (COA) establishes a statewide structure for tracking and recording financial transactions, combining the two COA structures (Central and Departmental) used in FLAIR into one. The Florida PALM COA is comprised of individual ChartFields, like the use of data elements in FLAIR. The COA Design evolved and was refined through iterative and collaborative work with Department of Financial Services (DFS) Divisions and Offices, agencies, and enterprise partners. The COA Design establishes the statewide COA structure for all Waves and Phases.

COA Design Structure Overview – This document provides agencies with a summary of how FLAIR data elements will be accounted for in Florida PALM.

COA Configuration Workbook – The purpose of the COA Workbook is to document the Florida PALM Chart of Account values for the CMS Wave.

Business Process Groupings

The Florida PALM Team categorized the financial management processes used today in nine business process groupings. The following groupings will be used to organize and communicate the design of the Florida PALM solution for the State.

  1. Account Management and Financial Reporting – establishes the statewide accounting framework through the general ledger and maintains accounting and reporting needs.
  2. Budget Management – manages the tracking and reporting of appropriations, allotments, revenue estimates, and budget exceptions.
  3. Disbursements Management – manages supplier information, supports disbursement obligations of the State, and performs month and year-end closing activities.
  4. Asset and Account Management – manages agency property, establishes the security controls, and performs month and year-end closing activities.
  5. Revenue Accounting – manages customer information and supports the billing process for State revenues.
  6. Accounts Receivables – manages accounting, reporting, and the collection of outstanding State revenues; supports the intake and accounting receipts; and ensures the closure of outstanding debt.
  7. Treasury Management – manages banking relationships, investments, and interest apportionment; supports bank and general ledger reconciliation; and supports cash transfers between bank accounts.
  8. Cash Management – manages cash balances to support disbursements and alignment with State and federal requirements, supports the forecast and management of agency cash balances, and supports revolving funds.
  9. Payroll Management – manages state employee and retiree payments. Details will be defined at a later date.

CMS Wave Business Process Models

The CMS Wave business process models document the details of the cash management processes for the CMS Wave implementation in July 2021. Select a link below to view the flows and narratives within a business process.

Account Management and Financial Reporting

AMFR CMSW.10.1 – Setup and Maintain Chart of Accounts | AMFR – CMSW.10.1 – Flows | AMFR – CMSW.10.1 – Narratives
AMFR CMSW.10.2 – Enter and Process Journals | AMFR – CMSW.10.2 – Flows | AMFR – CMSW.10.2 – Narratives
AMFR CMSW.10.3 – Analyze and Reconcile Accounts | AMFR – CMSW.10.3 – Flows | AMFR – CMSW.10.3 – Narratives

Disbursement Management

DM CMSW.30.8 – Record Central FLAIR Issued and Cancelled Payments | DM – CMSW.30.8 – Flows | DM – CMSW.30.8 – Narratives

Accounts Receivables

AR CMSW.60.2 – Deposits and Apply Receipts | AR – CMSW.60.2 – Flows | AR – CMSW.60.2 Narratives

Treasury Management

TM CMSW.70.1 – Manage Banking Relationships | TM – CMSW.70.1 – Flows | TM – CMSW.70.1 – Narratives
TM CMSW.70.2 – Manage and Reconcile Bank Statements | TM – CMSW.70.2 – Flows | TM – CMSW.70.2 – Narratives
TM CMSW.70.4 – Process Bank Cash Transfers | TM – CMSW.70.4 – Flows | TM – CMSW.70.4 – Narratives
TM CMSW.70.5 – Reconcile Book to Bank Balances | TM – CMSW.70.5 – Flows | TM – CMSW.70.5 – Narrative
TM CMSW.70.6 – Create and Maintain Deals | TM – CMSW.70.6 – Flows | TM – CMSW.70.6 – Narratives
TM CMSW.70.7 – Manage Investment Pools | TM – CMSW.70.7 – Flows | TM – CMSW.70.7 – Narratives

Cash Management

CM CMSW.80.1 – Manage Cash Checking | CM – CMSW.80.1 – Flows | CM – CMSW.80.1 – Narratives
CM CMSW.80.2 – Monitor and Manage Fund Cash | CM – CMSW.80.2 – Flows | CM – CMSW.80.2 – Narrative

A CMS Wave Summary provides the approach used to develop the business process models, an overview of the models, and a mapping of legacy activities and processes to the CMS Wave activities and processes. The summary serves as a tool for building end-user understanding for adoption of Florida PALM at the CMS Wave.