Reports Catalog
  • Dark
    Light
  • PDF

Reports Catalog

  • Dark
    Light
  • PDF

Article summary

Users will have access to reports, data, and reporting tools. End users will access reports and data through standard reports, inquiries, data extracts, or dashboards, in either in Florida PALM or the Data Warehouse/Business Intelligence (DW/BI) solution. Additional information about the DW/BI solution can be found here. Below is a list of the planned reports in Florida PALM by module.

NOTE: As the Project, enterprise partners, agencies, and third parties complete testing, additional changes may be made to report layouts. The “As of Date” column below reflects either the original date of publication or the most recent date on which the layout was updated. The Version History table on each report article provides a brief description of the changes when an update is noted for a layout.


Asset Management Module Reports

IDReport NameReport DescriptionBusiness ProcessReport Type
As of Date
AMR006
Asset Improvement Report
A report that lists improvements associated with an asset, including optional unique identification of improvements associated with specific assets.
40.2.1 Deploy and Maintain Assets Data WarehousePublished 01/31/2025
AMR007Asset Report by User and LocationA report of all assets assigned to an individual by location.40.2.1 Deploy and Maintain Assets 
Data Warehouse
Published 01/31/2025
AMR013Asset Acquisition by PO or Supplier ReportA report that lists assets by Purchase Order or Supplier.40.1.1 Import Asset Add

40.1.2 Online Asset Add

40.2.1 Deploy and Maintain Assets

90.2.3 Monitor and Closeout Grant
Data Warehouse
Published 01/31/2025
AMR014Asset Disposition ReportA report of asset dispositions by type. The report provides totals for the asset dispositions and details regarding the asset descriptions, custodians, and dates of acquisition and disposition. This report is used to monitor asset dispositions for compliance with applicable statutory and other requirements and supports details required for financial reporting.40.1.2 Online Asset Add

40.2.1 Deploy and Maintain Assets

40.2.4 Asset Disposal
Data Warehouse
Published 01/31/2025
AMR017Asset Summary Depreciation ReportA list of assets depreciated during the period by asset types.40.1.1 Import Asset Add

40.1.2 Online Asset Add

40.2.1 Deploy and Maintain Assets
Data Warehouse
Published 01/31/2025
AMR019Asset Register ReportA transaction register of all changes during a user-defined time period by asset class type, agency, transaction date or purchase amount. 40.2.1 Deploy and Maintain AssetsData Warehouse
Published 01/31/2025
AMR020Asset Physical Inventory ReportA physical inventory report that sorts, groups, and aggregates asset records based on available fields criteria to assist in conducting physical inventory.40.2.1 Deploy and Maintain Assets
Data Warehouse
Published 01/31/2025
AMR023
Asset Depreciation Forecast Report
A report that forecasts depreciation by individual asset, groups of assets, or total assets for a user-specified period of time.
40.2.1 Deploy and Maintain Assets
PeopleSoftPublished 12/01/2023
AMR039Asset Physical Inventory Reconciliation ReportAn asset inventory report that lists variances between system amounts and physical counts.40.2.1 Deploy and Maintain Assets
Data Warehouse
Published 01/31/2025
AMR042
Asset Staging Report
A report that provides a list of asset transactions in Asset Management that have been staged for processing.

40.1.1 Import Asset Add

40.1.2 Online Asset Add

40.2.1 Deploy and Maintain Assets

40.2.2 InterUnit Asset Transfer

40.2.3 IntraUnit Asset Transfer

40.2.4 Asset Disposal

40.2.5 Physical Inventory

PeopleSoft
Updated 11/13/2024
AMR045
Asset Workflow Status Report
A report that lists the approval status of asset transactions (e.g., approved, denied and pending).
40.2.1 Deploy and Maintain Assets

40.2.2 InterUnit Asset Transfer

40.2.3 IntraUnit Asset Transfer

40.2.4 Asset Disposal
PeopleSoft
Published 12/01/2023
AMR047Asset Statewide Rollup Report A report that lists asset balances at a statewide reporting level.40.1.1 Import Asset Add

40.1.2 Online Asset Add

40.2.1 Deploy and Maintain Assets
Data Warehouse
Published 01/31/2025
AMR048Building Contents and Values Detail with Accumulated Depreciation A report that displays building, contents (capitalized subsystems, equipment), associated value, and accumulated depreciation at a point in time provided by a user. 40.1.2 Online Asset Add

40.2.1 Deploy and Maintain Assets
Data Warehouse
Published 01/31/2025
AMR060Incomplete Asset Profile Report A report used to alert custodian supervisor when an asset is paid for, but the asset record data is incomplete.40.1.1 Import Asset Add

Data Warehouse 
Published 01/31/2025
AMR062Asset Replacement Cost by Asset Class TypeA report that lists asset replacement costs by asset category.40.2.1 Deploy and Maintain AssetsData Warehouse
Published 01/31/2025
AMR068Summary of AssetsA report of total assets and changes made to asset records for a given period. The report includes changes in asset status, useful life, or re-categorization. This report is used to monitor changes to the records and support the details required for financial reporting.40.1.1 Import Asset Add

40.1.2 Online Asset Add

40.2.1 Deploy and Maintain Assets

40.2.2 InterUnit Asset Transfer

40.2.3 IntraUnit Asset Transfer

40.2.4 Asset Disposal

40.2.5 Physical Inventory
Data Warehouse
Published 01/31/2025
AMR069Detailed Asset Listing ReportA report that lists assets based on available fields.40.2.1 Deploy and Maintain AssetsData Warehouse
Published 01/31/2025

Accounts Payable Module Reports

IDReport NameReport DescriptionBusiness ProcessReport TypeAs of Date
APR001Prompt Payment Interest Paid ReportA report that measures the time elapsed between receipt of invoice, receipt of goods and services, approval of goods and services, and payment date by Business Unit.30.3.1. Process Vouchers

30.3.6 Run Prompt Payment Interest Calculation

30.4.1 Process Pay Cycle
Data Warehouse
Published 01/31/2025
APR002Prompt Payment Compliance Report
A report that lists interest paid for invoices not timely paid in accordance with prompt pay requirements.
30.3.1. Process Vouchers
Data Warehouse
Published 01/31/2025
APR003Outstanding Vouchers ReportThe Outstanding Vouchers Report will provide an aging schedule of Vouchers that have not been approved or paid. This includes vouchers that are not approved, unposted, not paid, not deleted, and not closed in Florida PALM. This is a custom PS Query that generates the report in an Excel format.30.3.1. Process Vouchers

30.3.2 Voucher Matching

30.3.3 Review and Approve Vouchers

30.3.5 Enterprise Process Vouchers

30.3.6 Run Prompt Payment Interest Calculation

PeopleSoft
Published 12/01/2023
APR004Voucher Match Exceptions ReportA listing of vouchers with match exceptions.30.3.2 Voucher MatchingPeopleSoft

Published 06/04/2024
APR006Supplier Payments Report
A report that summarizes payments by Supplier and other key data elements.30.4.1 Process Pay CycleData Warehouse

Published 01/31/2025
APR007Scheduled Payments ReportA report that lists Vouchers scheduled to be paid.30.3.1 Process Vouchers

30.4.1 Process Pay Cycle

30.4.2 Process Warrant Payments
PeopleSoft

Updated 10/30/2024
APR009Voucher DetailA report that lists posted vouchers that can be filtered by various criteria.30.3.1 Process Vouchers

30.4.1 Process Pay Cycle
Data Warehouse

Published 01/31/2025
APR013Voucher Activity ReportA report that lists daily voucher activity.30.3.1 Process Vouchers

30.3.3 Review and Approver Vouchers

30.3.5 Enterprise Process Vouchers
PeopleSoft

Updated 11/13/2024
APR014Voucher Workflow Status ReportA report that lists the status of each voucher while it is in Voucher Workflow.30.3.1. Process Vouchers

30.3.2 Review and Approve Vouchers
PeopleSoft

Updated 11/13/2024
APR018Outstanding Warrants Report
A report that lists Warrants that are outstanding, expired, or about to expire by specified date range to include chart of account ChartFields, payment transaction data and business unit.30.4.2 Process Warrant Payments

30.5.3 Manage Stale Payments
Data Warehouse

Published 01/31/2025
APR021Payment Register Report
A report that lists electronic, warrant, or manual payments made as part of Pay Cycle.30.4.1 Process Pay CycleData Warehouse

Published 01/31/2025
APR024Prompt Payment ReportThe Prompt Payment Report is a custom report that lists vouchers that are approaching Prompt Payment processing deadlines i.e., vouchers that are not paid, and the Basis Date is greater than 10 Days. The report also lists Interest vouchers which are approaching payments (i.e., Interest vouchers that are not paid). The Prompt Payment Report lists the vouchers approaching prompt payment processing deadlines and also interest vouchers which are approaching payments.30.3.1 Process Vouchers

30.3.6 Run Prompt Payment Interest Calculation
PeopleSoft

Updated 10/30/2024
APR025
Travel Expense Report
A report that lists travel costs of air carriers, car rentals, and hotels (by supplier) regardless of how they are paid (i.e., via P-Card, reimbursement to employee or direct payment).
30.4.1 Process Pay Cycle
Data Warehouse

Published 01/31/2025
APR027Payment SummaryA report used to compute the number and dollar amount of payments made by Warrant and/or ACH run by day, per month, or other user-defined time-period.30.4.1 Process Pay Cycle

90.2.4 Monitor CMIA
Data Warehouse

Published 01/31/2025
APR032Payment Detail Report
A report that lists warrant and electronic payment detail and status (cleared, outstanding, cancelled, or reissued) for all payments.
30.4.1 Process Pay Cycle

30.4.2 Process Warrant Payments

30.5.1 Record Manual Payments
Data Warehouse

Published 01/31/2025
APR033Warrant Printing ReportA report that lists Warrants printed for distribution.30.4.2 Process Warrant Payments
PeopleSoft

Published 11/01/2023
APR036
1099 Withholding Report
A report that provides a list of 1099 suppliers including related 1099 Payment details.
30.6 Manage Tax ReportingData Warehouse

Published 01/31/2025
APR047
Employee Suppliers Report
A report that lists employees doing business with the State as a supplier.
30.4.2 Import Suppliers

30.6 Manage Tax Reporting
Data Warehouse

Published 01/31/2025
APR050Payment Cancellation ReportA report that lists all cancelled payments and the number of days outstanding at the point of cancellation.30.5.4 Cancel and Reissue Payments
PeopleSoft
Updated 10/30/2024
APR051Contract Expenditures Report
A report of contract payment information by Vendor Name, contract ID number, Payment Number, Posted Invoice #, Date Posted Invoice posted, Payment Amount, document number unique to document payment, Voucher information, voucher status or available fields with the ability to export data into an excel format.
30.3.1 Process Vouchers

30.4.1 Process Pay Cycle

90.3.2 Monitor and Close Out Contract
Data Warehouse

Published 01/31/2025
APR055
Employee Reimbursement Report
A report that lists payments to an employee for reimbursable business events (i.e., travel).
30.4.1. Process Pay Cycle
Data Warehouse

Published 01/31/2025
APR064Clearance Pattern Report
A report that details the clearance pattern for designated projects.
30.4.1. Process Pay Cycle

90.2.4 Monitor CMIA
Data Warehouse

Published 01/31/2025
APR068Supplier Detail Report
A report that lists Suppliers by name, TIN, or other identifying information.30.3.1 Process Vouchers

30.4.1 Process Pay Cycle
Data Warehouse

Published 01/31/2025
APR069Duplicate Suppliers Report
A report that identifies potential duplicate Supplier records, or related suppliers.30.1.1 Add and Update Suppliers Online

30.1.2 Import Suppliers
Data Warehouse

Published 01/31/2025
APR091AP Holds by Hold Type ReportA list of all Vouchers on hold including the hold reason.30.1.2 Import Suppliers
PeopleSoft

Updated 06/10/2024
APR102AP ACH Returns and Reissued WarrantsThe AP ACH Returns and Reissued Warrants Report is run on demand to extract the details of the ACHPayments originating in the Accounts Payable (AP) module that were not successfully processed and returned by the bank.30.5.2 Manage ACH/EFT NotificationsPeopleSoft

Updated 08/23/2024
APR103
1099 Updates Report

A report that lists all 1099 adjustments and corrections and expenditure refund deposits with 1099 applicable account values.

30.6 Manage Tax ReportingData Warehouse

Published 01/31/2025
APR104
1099 Summary Report
A report of 1099s that have been generated. This report is to support the 1099 process. This will be at the Enterprise Level and will not include Confidential Information.
30.6 Manage Tax Reporting
Data Warehouse

Published 01/31/2025
APR112Supplier Authorized Banks Exceptions and Updates ReportA report that lists supplier banks in Florida PALM that were updated or not listed on the Authorized Bank Titles File.30.1.1 Add and Update Suppliers Online

30.1.5 Manage Supplier Banks
PeopleSoft

Published 12/01/2023
APR118Payment Lifecycle Report
A report that determines the number of days between agency payment approval, payment posting, payment issuance, and payment settlement and store for reporting and statistical purposes.  
30.3.1 Process Vouchers

30.4.1 Process Pay Cycle

90.2.4 Monitor CMIA
Data Warehouse

Published 01/31/2025
APR125Budget Check Errors (WorkCenter)A report in the WorkCenter used to display a list of vouchers with Budget Check errors.120.1.1 Interface File Error Handling

120.1.2 Spreadsheet Upload Error Handling
PeopleSoft

More information coming soon!
APR126Cash Check Errors (WorkCenter)A report in the WorkCenter used to display a list of vouchers with Cash Check errors.30.4.1 Process Pay CyclePeopleSoft

Updated 03/05/2025
APR140Funds Transferred to Unclaimed Property and Funds Exempt from Transfer to Unclaimed Property ReportA report that lists payment information for funds transferred to the Unclaimed Property Trust Fund or those that are exempt from Transfer to Unclaimed Property, pursuant to Sections 17.26 and 717.117, Florida Statutes, and payment information for funds returned to the original source.  
30.5 Manage Payments

30.5.3 Manage Stale Payments

Data Warehouse
Published 01/31/2025

Accounts Receivable Module Reports

IDReport NameReport DescriptionBusiness Process
Report Type
As of Date
ARR007Deposit ReportA report that provides detailed information for deposits.60.2.1 Direct Journal Deposits

60.2.2 AR Deposits

60.2.3 Returned Items
PeopleSoft
Updated 11/05/2024
ARR020Reconciled Deposits ReportA report that provides reconciled deposits.60.2.1 Direct Journal DepositsPeopleSoft
Updated 11/05/2024
ARR021Unreconciled Deposits ReportA report that provides a list of unreconciled deposits.60.2.1 Direct Journal Deposits

60.2.2 AR Deposits

60.2.3 Returned Items
PeopleSoft
Updated 11/05/2024
ARR024Debit MemoA report that provides Returned items information (includes image for returned checks).60.2.3 Returned Items
PeopleSoft
Published 12/01/2023
ARR025AR Data ReportA PeopleSoft report that provides AR data including pending items to agencies for analysis purposes.60.1.1 Record AR

60.1.2 Refund AR

60.1.3 Write-off AR

60.1.4 AR Period Close

Data Warehouse
Published 02/06/2024
ARR067Direct Journal Accounting Entry Errors (WorkCenter)Used to correct Direct Journal accounting entry edit errors. 120.1.1 Interface File Error Handling

120.1.2 Spreadsheet Upload Error Handling
PeopleSoft
More information coming soon!
ARR070DOR Agency Deposit ReportThis report provides a list of Agency Deposit transactions that were entered by DOR.60.2.1 Direct Journal DepositsPeopleSoft
Updated 10/30/2024

Cash Management Module Reports

IDReport NameReport DescriptionBusiness ProcessReport TypeAs of Date
CMR001Agency Bank Deposit Extract ReportA report that provides a query to prepopulate the deposit spreadsheet from the bank statement file to assist agencies in recording deposits.60.2.1 Direct Journal Deposits

60.2.2 AR Deposits
PeopleSoft
Updated 11/13/2024
CMR011Accounting Errors (WorkCenter)Summary listing of accounting errors.120.1.1 Interface File Error Handling

120.1.2 Spreadsheet Upload Error Handling
PeopleSoft
More information coming soon!
CMR028CRA Activity StatementReport that provides activity and balance detail for Consolidated Revolving Accounts.N/APeopleSoft
Published 02/01/2024

General Ledger Module Reports

IDReport NameReport DescriptionBusiness ProcessReport TypeAs of Date
GLR079GR Cash Balance and Activity ReportGR Cash Balance and Activity Report is generated to display a cash position by GR Fund from the ACTUALS Ledger and associated modules that displays the following: Cash Balance, Pending AP Transactions, AR Unverified deposits, IU, and GL transactions that are not successfully Budget/Cash Checked and Anticipated Cash balance.10.3.1 Perform Month End ClosePeopleSoft
Published 07/02/2024
GLR080Cash Balance by Fund TypeA custom report that summarizes balances by Fund type for Transparency site.10.4 Close General Ledger and Consolidate ResultsData Warehouse
Published 01/31/2025
GLR083Investment Activity ReportInvestment transactions and balances by pool and participant.20.2.2 Manage Cash CheckingPeopleSoft
Published 10/25/2023
GLR086Revenue CAP ReportA custom report providing balances by BU for specified categories (i.e., revenue and refund) for the fiscal year.10.3.1 Perform Month-End CloseData Warehouse
Updated 02/04/2025
GLR088Trust Fund ReportAn annual, statutory custom report that contains trust fund balances for operating and non-operating disbursements, revenues, and unencumbered balances in excess of $2 million in each of the 2 preceding fiscal years.10.3.1 Perform Month-End Close
Data Warehouse
Updated 02/10/2025
GLR091ChartField Value Report
PeopleSoft or Data Warehouse report listing established ChartField values.10.1.1 Agency Add or Modify ChartField Values

10.1.2 Enterprise Add or Modify Statewide ChartField Values

10.1.3 Enterprise Add or Modify Fund Values

10.1.4 Enterprise Add or Modify Budgetary ChartField Values
PeopleSoft
More information coming soon!
GLR099Trial Balance ReportA custom report of summarized balances (debits and credits) pulled from Actuals Ledger by ChartField String based on a particular fiscal year, the selected accounting period range and other parameters selected.10.3.1 Perform Month-End Close

PeopleSoft
Updated 07/22/2024
GLR110
Capital Assets Account Reconciliation Report
This report displays all balances related to Asset expense account values.
10.3.1 Perform Month-End Close
PeopleSoft
Published 10/25/2024
GLR112Agency Balance Sheet ReportA custom report of the finalized agency balance sheet reflecting the balances of assets, liabilities and fund balance with any adjustments that were made during the close process.10.4 Close General Ledger and Consolidate ResultsData Warehouse

Updated 03/05/2025
GLR115
Adjustment Period 998 GL Journal Entry Report
A report used by EOG/OPB providing GL journal detail entered in the adjustment period 998.
10.4 Close General Ledger and Consolidate Results
PeopleSoft
Published 11/01/2023
GLR132Journals Ready for Processing (WorkCenter)A delivered report in the WorkCenter used to display a list of journals that are not posted but available for processing (edit, budget check, and post).10.2.3 Agency Create and Approve Journals

10.2.4 Enterprise Create and Approve Journals
PeopleSoft
More information coming soon!
GLR133Incomplete Journals (WorkCenter)A delivered report in the WorkCenter used to display a list of journals that are saved with an incomplete status.10.2.3 Agency Create and Approve Journals

10.2.4 Enterprise Create and Approve Journals
PeopleSoft
More information coming soon!
GLR136Journals Pending My Approval (WorkCenter)Journals that are pending approval from the current user.10.2.3 Agency Create and Approve Journals

10.2.4 Enterprise Create and Approve Journals
PeopleSoft
More information coming soon!
GLR139Journals with Errors (WorkCenter)Journals with any type of error that requires action.120.1.1 Interface File Error Handling

120.1.2 Spreadsheet Upload Error Handling
PeopleSoft
More information coming soon!
GLR140Journals with Edit Errors (WorkCenter)Journals specifically with edit errors that require action.10.2.2 Edit Check 

PeopleSoft
More information coming soon!
GLR143Journals - Commitment Control Exceptions (WorkCenter)A delivered report in the WorkCenter used to display a list of journals with Budget Check exceptions that require action.10.2.3 Agency Create and Approve Journals

10.2.4 Enterprise Create and Approve Journals
PeopleSoft
More information coming soon!
GLR160Annual Budgetary Basis Expenditures ReportA custom report that provides posted appropriation amounts, disbursements, tentative and approved certified forward and reversion amounts.N/AData Warehouse

Updated 02/04/2025
GLR161Trust Funds Terminations ReportA custom report that lists all agency Trust Funds exempt from termination, scheduled for termination, and scheduled for legislative review. This report is required by FS 215.3206(3) F.S. and is sent annually to the Legislature.10.4 Close General Ledger and Consolidate ResultsData Warehouse

Updated 03/17/2025
GLR163Census Bureau Detailed Expenditures and Revenues ReportA custom report containing detailed expenditure and revenue totals by Account value provided to the US Census Bureau.N/AData Warehouse

Updated 02/13/2025
GLR164Equity Comparison by FundA custom report comparing the beginning and ending balances of equity by Fund.10.4 Close General Ledger and Consolidate Results
Data Warehouse

Published 01/31/2025
GLR167Combination Edit Detail Report
Custom report/query to pull detail combination edit data to be used in conjunction with the custom combination edit spreadsheet upload tool.
10.1.5 Enterprise Set Up and Maintain Trees and/or Combination EditsData Warehouse

Published 01/31/2025
GLR168Multi-Year Project, Contract or Grant Activity Summary ReportA report that summarizes transaction amounts for a given date range of FLAIR and Florida PALM project, grant, or contract transactions from the General Ledger.90.1.5 Monitor and Closeout ProjectData Warehouse

Published 01/31/2025
GLR169Annual GAA Load Values ReportThe Annual GAA Load Values Report gives a combination of new Budgetary Codes from the General Appropriation Act Load to the agencies. This report provides users with information needed to support their requests for new Transactional Fund values and Budgetary Value combination edits.10.1.1 Agency Add or Modify ChartField Values

10.1.4 Enterprise Add or Modify Budgetary ChartField Values
PeopleSoft
Published 12/01/2023
GLR171Cash Basis Transaction Reconciliation ReportThis report is designed to reconcile the GL Fund Cash balances reflected in the Actuals Ledger and the Cash Basis ledger, at the transactional level, and provides the exception details to identify differences in reconciliation.10.3.1 Perform Month-End ClosePeopleSoft
Updated 03/18/2025
GLR172Cash Balances Reconciliation ReportA custom report for enterprise users to identify if spendable cash (KK) and Fund Cash (GL) balances are reconciled between the Actuals, Cash and KK ledgers.10.2.3 Agency Create and Approve Journals

10.2.4 Enterprise Create and Approve Journals

20.2.2 Manage Cash Checking
Data Warehouse

Updated 03/18/2025

Grants Management Module Reports

IDReport NameReport DescriptionBusiness ProcessReport TypeAs of Date
GMR001Expense and Revenue by ALN/CSFA ReportA report that displays summary of expenses and revenues by ALN/CSFA numbers.60.1.1 Record AR

60.2.1 Direct Journal Deposits

60.2.2 AR Deposits

90.2.3 Monitor and Closeout Grants
Data Warehouse
Published on 01/31/2025

Commitment Control Module Reports

ID
Report Name
Report Description
Business ProcessReport TypeAs of Date
KKR008Schedule of Allotment Balance ReportThe Schedule of Allotment Balances Report allows users with security access to run a report to reflect recorded Allotments, Encumbrance, expenditures, and associated remaining balances for designated time periods grouped by designated ChartField and ChartField combinations.10.3.1 Perform Month-End Close

20.1.2 Manage Agency Allotments

20.1.4 Agency Estimated Revenue

90.2.3 Monitor and Closeout Grant

90.3.2 Monitor and Closeout Contracts 
PeopleSoft

Published 12/01/2023
KKR010Spend Plan Projections Report
A report displaying appropriations balances, encumbrances, expenditures (actuals and scheduled payments), and available balances.20.1.2 Manage Agency Allotments

110.3.5 Inter-IntraUnit Reclassifications
Data Warehouse
Published 01/31/2025
KKR016Negative Budget and Cash Balances ReportThe Negative Budget and Cash Balances Report is designed to provide agencies with timely information regarding all negative budget and cash balances.20.2.1 Manage Budget Checking

20.2.2 Manage Cash Checking

100.7.2 Generate Payroll Accounting Distributions
PeopleSoft

Published 08/07/2024
KKR018Agency Commitments ReportThe Agency Commitments Report allows users with security access to run a report to reflect open Encumbrances, IU Accruals, and Carry Forward Payables for a designated time period grouped by designated ChartFields and ChartField combinations.

10.2.3 Agency Create and Approve Journals 


10.2.4 Enterprise Create and Approve Journals


20.1.2 Manage Agency Allotments


20.2.1 Manage Budget Checking


20.2.2 Manage Cash Checking


20.3.1 Carry Forward


20.3.2 Certified Forward


20.3.3 Continuing Appropriations


30.2.1 Create and Maintain Encumbrances


30.2.2 Monitor Encumbrances


30.2.3 Establish Enterprise Encumbrances


90.1 Create and Maintain Projects


90.2 Create and Maintain Grants


90.3 Create and Maintain Contracts


110.1.1 Create and Maintain Inter/IntraUnit Encumbrances


110.1.2 Monitor Inter/IntraUnit Encumbrances


110.2.1 Create and Maintain Inter/IntraUnit Accruals


110.2.2 Monitor Inter/IntraUnit Accruals


110.4.2 Inter/IntraUnit Carry Forward Process


PeopleSoft

Updated 10/11/2024
KKR019Budget Detail Activity ReportThe Budget Detail Activity Report displays Budget Journal created in Florida PALM for any budget ledger group (Continuing Appropriation, Releases, Reserves, Projects, Allotments and Revenue). This includes Budget Journals which are not yet edited, not yet submitted for approval, approved but not yet posted, posted or in error.

20.1.1 Enterprise Post Appropriations


20.1.2 Manage Agency Allotments


20.1.3 Enterprise Budget Ledger Reconciliation


20.1.4 Agency Estimated Revenue


20.2.1 Manage Budget Checking


20.2.2 Manage Cash Checking


20.2.3 Invested Balance Checking


20.3.1 Carry Forward


20.3.2 Certified Forward


20.3.3 Continuing Appropriations

PeopleSoft

Updated 09/04/2024
KKR022Appropriations Budget Ledger Balances Reconciliation ReportThe Appropriations Budget Ledger Balances Reconciliation Report displays details of differences in budgetary ledger balances for LAS/PBS and Florida PALM for same budgetary COA combination. The report will show differences between LAS/PBS balances and Florida PALM Commitment Control Ledger budget balances. This report will be available to DFS and EOG/OPB to run on-demand and will be run nightly after the Inbound Appropriation Budget Ledger Reconciliation (KKI002) process has completed.20.1.3 Enterprise Budget Ledger Reconciliation
PeopleSoft

Published 12/01/2023
KKR023Revenue Report
A custom report that provides revenue estimates, revenue recognized, and revenue collected by Fund, Budget Entity, Category, and Account code by ChartField combinations.

20.1.4 Agency Estimated Revenue


60.1.1 Record AR


60.1.2 Refund AR


60.1.3 Write-Off AR


60.2.1 Direct Journal Deposits


60.2.2 AR Deposits

Data Warehouse

Published 01/31/2025
KKR044Continuing Appropriations Balance ReportA custom report displaying balances of appropriations, encumbrances, expenditures, scheduled payments and available balances with a variable user-defined projection rates.20.3.3 Continuing AppropriationsPeopleSoft

Updated 09/06/2024
KKR046February Reversion FCO Projects Worksheet ReportThis report contains budget ledger available balances for all Fixed Capital Outlay(FCO) projects by Business Unit, Fund, Budget Entity, and Category ChartField values with descriptions, including a budget period, as per statutory requirement for agencies.20.3.2 Certified ForwardPeopleSoft

Updated 09/06/2024
KKR057Tentative Carry Forward Certified Forward Balances ReportThis report lists Carry Forward (Operating) Unexpended Releases and Certified Forward FCO Unexpended Appropriations for the current fiscal year.20.3.1 Carry Forward
20.3.2 Certified Forward
PeopleSoft

Updated 09/06/2024
KKR058Budget and Cash Checking Exceptions/Warnings ReportA 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.

10.3.1 Perform Month-End Close


20.1.1 Enterprise Post Appropriations


20.1.2 Manage Agency Allotments


20.1.3 Enterprise Budget Ledger Reconciliation


20.1.4 Agency Estimated Revenue


30.2.1 Create and Maintain Encumbrances


30.2.2 Monitor Encumbrances


30.2.3 Establish Enterprise Encumbrances


30.3.1 Process Vouchers


30.3.3 Review and Approve Vouchers


30.4.1 Process Pay Cycle


30.5.1 Record Manual Payments


60.1.4 AR Period Close


60.2.1 Direct Journal Deposits


60.2.3 Returned Items


PeopleSoft

Published 02/01/2024
KKR059Trust Fund Cash Balance and Activity ReportThis report provides the Trust Fund spendable cash balance and is updated from Accounts Receivable (AR), Accounts Payable (AP), and Inter/IntraUnit, GL journal entries captured in Florida PALM Financials along with pending activity that may impact the overall cash balance.

20.2.1 Manage Budget Checking


30.3.1 Process Vouchers


30.3.5 Enterprise Process Vouchers


30.3.7 Process Carry Forward Vouchers


PeopleSoft

Published 07/02/2024

Inter/IntraUnit Module Reports

ID
Report Name
Report Description
Business ProcessReport Type
As of Date
IUR002GR Service Charge ReportA custom report that lists service charges by ChartField combination for each Agency.110.3.3 Process GR Service ChargeData Warehouse
Published 01/31/2025
IUR003Inter/IntraUnit Transaction Reconciliation ReportA report by transaction Inter/IntraUnit ID that reflects the sending information and the receiving information. The report will show data if any subsequent Inter/IntraUnit transactions occurred. 

110.3.1 Agency Record Inter/IntraUnit Transactions

 

110.3.2 Enterprise Record Inter/IntraUnit Transactions


110.3.3 Process GR Service Charge


110.3.5 Inter/IntraUnit Reclassifications


110.4.2 Inter/IntraUnit Carry Forward Process


Data Warehouse


Published 01/31/2025
IUR004IU Encumbrance and Accrual Activity Report

A report detailing the IU Encumbrance and IU Accrual activity including the established encumbrance/accrual, payments made against the encumbrance/accrual, and remaining balances.

110.1.1 Create and Maintain Inter/IntraUnit Encumbrances


110.1.2 Monitor Inter/IntraUnit Encumbrances


110.2.1 Create and Maintain Inter/IntraUnit Accruals


110.2.2 Monitor Inter/IntraUnit Accruals


110.3.1 Agency Record Inter/IntraUnit Transactions


110.3.2 Enterprise Record Inter/IntraUnit Transactions


110.3.4 Manage Trust Fund Loans


110.4.2 Inter/IntraUnit Carry Forward Process

Data Warehouse


Published 01/31/2025
IUR005Inter/IntraUnit Transaction Detail ReportThe Inter/IntraUnit Transaction Detail Report allows agencies to view all pending and posted Inter/IntraUnit (IU) transactions associated with their Business Unit in Florida PALM. This report can be used for analysis and contains detailed information related to IU transactions.

110.1.1 Create and Maintain Inter/IntraUnit Encumbrances


110.1.2 Monitor Inter/IntraUnit Encumbrances


110.2.1 Create and Maintain Inter/IntraUnit Accruals


110.2.2 Monitor Inter/IntraUnit Accruals


110.3.1 Agency Record Inter/IntraUnit Transactions


110.3.2 Enterprise Record Inter/IntraUnit Transactions


110.3.3 Process GR Service Charge


110.3.4 Manage Trust Fund Loans


110.3.5 Inter/IntraUnit Reclassifications


110.4.1 Inter/IntraUnit Period Close


110.4.2 Inter/IntraUnit Carry Forward Process


100.7.3 Process Redistributions 


PeopleSoft

Updated 01/09/2025
IUR006Inter/IntraUnit Budget-Cash Check Errors (WorkCenter)The Inter/IntraUnit Budget-Cash Check Errors Report (IUR006) is an IU WorkCenter report that provides users with a list of IU transactions with budget and/or cash check errors. Users can drill into a transaction generated on this report to open the transaction and make edits if necessary.

110.1.1 Create and Maintain Inter/IntraUnit Encumbrances


110.1.2 Monitor Inter/IntraUnit Encumbrances


110.2.1 Create and Maintain Inter/IntraUnit Accruals


110.2.2 Monitor Inter/IntraUnit Accruals


110.3.1 Agency Record Inter/IntraUnit Transactions


110.3.2 Enterprise Record Inter/IntraUnit Transactions


110.3.3 Process GR Service Charge


110.3.4 Manage Trust Fund Loans


110.3.5 Inter/IntraUnit Reclassifications


110.4.1 Inter/IntraUnit Period Close


110.4.2 Inter/IntraUnit Carry Forward Process


100.7.3 Process Redistributions


PeopleSoft

Updated 03/17/2025
IUR007Pending Submission IU Transactions (WorkCenter)This Pending Submission IU Transactions Report (IUR007) is an IU WorkCenter report that provides users with the ability to view IU transactions that have been initiated by their agency and saved but not yet submitted.Users can drill into a transaction generated on this report to open, update, and submit the transaction.

110.1.1 Create and Maintain Inter/IntraUnit Encumbrances


110.1.2 Monitor Inter/IntraUnit Encumbrances


110.2.1 Create and Maintain Inter/IntraUnit Accruals


110.2.2 Monitor Inter/IntraUnit Accruals


110.3.1 Agency Record Inter/IntraUnit Transactions


110.3.2 Enterprise Record Inter/IntraUnit Transactions


110.3.3 Process GR Service Charge


110.3.4 Manage Trust Fund Loans


110.3.5 Inter/IntraUnit Reclassifications


110.4.1 Inter/IntraUnit Period Close


110.4.2 Inter/IntraUnit Carry Forward Process


100.7.3 Process Redistributions


PeopleSoft

Updated 11/25/2024
IUR008Received IU Transactions (WorkCenter)The Received IU Transactions Report (IUR008) is an IU WorkCenter report that provides a listing of IU transactions that were received from another agency. Users can drill into these transactions from the report to open and input their COA information in the IU transaction.

110.1.1 Create and Maintain Inter/IntraUnit Encumbrances


110.1.2 Monitor Inter/IntraUnit Encumbrances


110.2.1 Create and Maintain Inter/IntraUnit Accruals


110.2.2 Monitor Inter/IntraUnit Accruals


110.3.1 Agency Record Inter/IntraUnit Transactions


110.3.2 Enterprise Record Inter/IntraUnit Transactions


110.3.3 Process GR Service Charge


110.3.4 Manage Trust Fund Loans


110.3.5 Inter/IntraUnit Reclassifications


110.4.1 Inter/IntraUnit Period Close


110.4.2 Inter/IntraUnit Carry Forward Process


100.7.3 Process Redistributions


PeopleSoft

Updated 10/08/2024
IUR009IU Pending Approval (WorkCenter)The IU Pending Approval Report (IUR009) is an IU WorkCenter report that provides users with the ability to view IU transactions that have been submitted to approvers. This report provides a quick glance of each approver status for the transactions. Users can drill into a transaction generated on this report to open the transaction.

110.1.1 Create and Maintain Inter/IntraUnit Encumbrances


110.1.2 Monitor Inter/IntraUnit Encumbrances


110.2.1 Create and Maintain Inter/IntraUnit Accruals


110.2.2 Monitor Inter/IntraUnit Accruals


110.3.1 Agency Record Inter/IntraUnit Transactions


110.3.2 Enterprise Record Inter/IntraUnit Transactions


110.3.3 Process GR Service Charge


110.3.4 Manage Trust Fund Loans


110.3.5 Inter/IntraUnit Reclassifications


110.4.1 Inter/IntraUnit Period Close


110.4.2 Inter/IntraUnit Carry Forward Process


100.7.3 Process Redistributions


PeopleSoft

Updated 11/12/2024
IUR010Denied IU Transactions (WorkCenter)The Denied IU Transactions Report (IUR010) is an IU WorkCenter report that provides users with the ability to view IU transactions that were denied by an approver. Users can drill into a transaction generated on this report to open the denied transaction and make edits if necessary.

110.1.1 Create and Maintain Inter/IntraUnit Encumbrances


110.1.2 Monitor Inter/IntraUnit Encumbrances


110.2.1 Create and Maintain Inter/IntraUnit Accruals


110.2.2 Monitor Inter/IntraUnit Accruals


110.3.1 Agency Record Inter/IntraUnit Transactions


110.3.2 Enterprise Record Inter/IntraUnit Transactions


110.3.3 Process GR Service Charge


110.3.4 Manage Trust Fund Loans


110.3.5 Inter/IntraUnit Reclassifications


110.4.1 Inter/IntraUnit Period Close


110.4.2 Inter/IntraUnit Carry Forward Process


100.7.3 Process Redistributions


PeopleSoft

Updated 11/13/2024
IUR011IU Edit Errors (WorkCenter)The IU Edit Errors Report (IUR011)is an IU WorkCenter report that provides users with the ability view IU transactions with edit errors (e.g., combo edit errors, page validation errors). Users can drill into a transaction generated on this report to open and update the transaction if necessary.

110.1.1 Create and Maintain Inter/IntraUnit Encumbrances


110.1.2 Monitor Inter/IntraUnit Encumbrances


110.2.1 Create and Maintain Inter/IntraUnit Accruals


110.2.2 Monitor Inter/IntraUnit Accruals


110.3.1 Agency Record Inter/IntraUnit Transactions


110.3.2 Enterprise Record Inter/IntraUnit Transactions


110.3.3 Process GR Service Charge


110.3.4 Manage Trust Fund Loans


110.3.5 Inter/IntraUnit Reclassifications


110.4.1 Inter/IntraUnit Period Close


110.4.2 Inter/IntraUnit Carry Forward Process


100.7.3 Process Redistributions


PeopleSoft

Updated 12/03/2024

Payroll Module Reports

ID
Report Name
Report Description
Business ProcessReport TypeAs of Date
PRR001HR Accounting Line ReportAfter a Payroll is confirmed in Florida PALM, the Actuals Distribution process will distribute earnings, employer deductions, and employer taxes across established position funding sources. Then, the GL Interface Process (PAYGL02) will load this information to the HR Accounting Line and post it to the GL.

Agency users and BOSP will be able to use PRR001 HR Accounting Line Report to view Payroll payment data from the GL HR Accounting Line in FIN. This report will include employee data, warrant number, and distribution information. It can be run as a query or output as an Excel file and filtered as necessary.
100.7.2 Generate Payroll Accounting Distributions
PeopleSoft


Updated 02/27/2025
PRR004Salary Refund ReportA report that lists salary refunds or other collections by employee or agency.  100.6.1 Record Overpayments and Recovery

100.6.3 Reverse Unreconciled Warrants

100.6.4 Adjust Retirement Earnings and Contributions

100.6.5 Record Non-Cash, Fringe, and Other Adjustment 
Data Warehouse
Published 01/31/2025
PRR007Earnings/Deductions Register ReportThe Earnings Register Report produces a detailed report of earnings for all employees in each payroll period. This report shows the earnings successfully loaded to the Paysheet, and any additional earnings entered on an employee’s payline. This report can be run after a payroll calculation for a preliminary view of employee earnings and or after confirmation for the final earnings paid and stored for record keeping. The report includes employee earnings codes processed within a given payroll period, with the employees’ ‘Month to Date’, ‘Quarter to Date’ and ‘Year to Date’ balance amounts per the employees’ payroll record. The run control includes the Business Unit as a field to identify an employee’s earnings per agency.100.3.2 Calculate PayrollPeopleSoft


Updated 02/27/2025
PRR010Payroll RegisterThe Payroll Register displays by employee. It provides data that reflects defined elements for the employee's pay history by payroll run, including gross wages, net pay, benefits, taxes, other deductions, garnishments, employer contributions, and payment data.100.3.2 Calculate Payroll

100.3.4 Confirm Payroll
PeopleSoft
Updated 02/27/2025
PRR011Payroll Tax ReportDuring the payroll processing cycle, the Bureau of State Payroll(BOSP) and agencies need the ability to review the payroll taxes withheld from employee paychecks. This report will provide the daily taxes withheld in an Excel report for BOSP and agency usage.100.3.2 Calculate Payroll

100.3.4 Confirm Payroll
PeopleSoft
Updated 02/27/2025
PRR012Payroll Summary ReportA report that provides summary and detailed payroll data (payroll register) for pre-production payroll runs and production payroll runs by employee, agency or other available fields.100.3.2 Calculate Payroll

100.3.4 Confirm Payroll
PeopleSoft
Updated 02/27/2025
PRR016Payroll Deduction ReportA report that will provides deduction details by employee and will be pulled from precalculated deduction data and/or post confirmed deduction data.100.3.2 Calculate Payroll

100.3.3 Updating Paysheets

100.3.4 Confirm Payroll
PeopleSoft
Updated 02/04/2025
PRR021Payroll Period Compare ReportThe Payroll Period Compare Report is a report that provides information generated during the preliminary and final payroll run that compares the current payroll to the prior payroll period and identifies variances based on defined criteria.100.3.2 Calculate PayrollPeopleSoft
Updated 02/27/2025
PRR023Payroll Cash Budget Balance ReportThis report is produced as part of the Actuals Distribution Process to compare the preliminary payroll amount to the available spending authority (spendable cash), remaining spending authority (appropriations), and the remaining General Revenue (GR) release available.100.7.2 Generate Payroll Accounting Distributions 
PeopleSoft
Updated 02/27/2025
PRR030Actuals Funding ReportThe Actuals Funding Report is a custom Florida PALM report that will run by agency payroll users and BOSP to view actuals funding after Payroll Calculation. The report will read from the earnings, deduction, and tax distribution tables and combine results from all three into one spreadsheet for easier review. Some fields will be specific to the type of distribution.100.7.2 Generate Payroll Accounting Distributions
PeopleSoft
Updated 03/18/2025
PRR035Payroll Warrant Status ReportA report that lists payroll Warrant details and status, indicating whether they have been cleared, outstanding, or canceled.100.3.6 Distribute Payroll Warrants

100.5.2 Manage Stale Payroll Warrants
PeopleSoft
Updated 02/27/2025
PRR036Editing Paysheets Changes ReportThis is a payroll report that provides a list of transactions that did not pass Edit Check as part of the Editing Paysheets process100.3.2 Calculate PayrollPeopleSoft
Updated 02/27/2025
PRR037Beneficiary Payment ReportA report that identifies payments to beneficiaries.100.4.2 Beneficiary Payments 
Data Warehouse
Published 01/31/2025
PRR045Employee W-4 Exempt Status ReportThe Employee W-4 Exempt Status report lists all employees whose current Federal Income Tax Withholding status is exempt.

The report can be run ad-hoc throughout the year and at the end of the calendar year to identify the employees currently exempt from Federal Income Tax Withholding. It can be used to identify who must submit a new W-4 for the upcoming calendar year. The report is executed every year after (February 15) the due date to submit the Exempt form.
100.8.8 Reset Employee W-4 Exempt StatusPeopleSoft
Updated 02/27/2025
PRR046Payroll Funds Transferred to Unclaimed Property and Funds Exempt from Transfer to Unclaimed Property ReportA report that lists payroll payment information for funds transferred to the Unclaimed Property Trust Fund or those that are exempt from Transfer to Unclaimed Property, pursuant to Sections 17.26 and 717.117, Florida Statutes, and payment information for funds returned to the original source.100.5.2 Manage Stale Payroll WarrantsData Warehouse
Published 01/31/2025
PRR051Position Funding Data ReportThe Position Funding Report is a comprehensive report that show users the position funding established in Florida PALM. The report will show the SpeedKey, value that gives the detailed accounting, associated with the position. The ChartField values and the status of the SpeedKey will also be available in the report. The report pulls from the following tables to give a complete story of the position funding that has been established: Department Budget Earnings Distribution Table and Valid Combination Codes Table.100.7.1 Set Up Position DistributionsPeopleSoft
Updated 02/27/2025
PRR055Payroll Deductions Not TakenPayroll Deductions Not Taken Report (PRR055) contains employee deductions not taken for a given payroll cycle. This report identifies the deduction code and the associated deduction not taken reason. This report is being modified to include Row Level Security per the user profiles running the report.100.2.5 Garnishments

100.3.2 Calculate Payroll
PeopleSoft
Updated 02/27/2025
PRR059Inactive Position Funding SpeedKeys ReportThe Inactive Position Funding SpeedKeys Report lists active positions whose funding records are assigned to an inactive SpeedKey.100.7.1 Set Up Position Distributions 
PeopleSoft
Updated 02/27/2025
PRR061Payroll Error Messages - QueryThe Payroll Error Messages-Query (PRR061) prints a list of the error messages generated during payroll processing. If the system encounters an error for an employee during the Calendar Creation, Paysheet Creation, Pay Calculation or Pay Confirmation processes, the process creates a payroll error message describing the condition impacting the employee.100.3.2 Calculate PayrollPeopleSoft
Updated 02/27/2025
PRR062Deductions RegisterThe Deductions Register produces a detailed report of deductions for all employees for each payroll cycle or post confirm of a payroll cycle. This report is run during payroll calculation for a preliminary view of an employee’s deductions withheld and/or after payroll confirmation for a final list of deductions withheld.N/APeopleSoft
Updated 02/27/2025
PRR068Expired W-4 ExemptionThe Expired W-4 Exemption report lists all employees who claimed ‘exempt’ on their W-4 for the prior calendar year, did not update their exempt status for the current year, and had their status updated to single and zero by the system.100.8.8 Reset Employees W-4 Exempt StatusPeopleSoft
Updated 03/05/2025
PRR069Annual Leave Payments ReportA report that includes FLAIR and Florida PALM annual leave payments to employees.100.2.1 Personal DataData Warehouse
Published 01/31/2025

Project Costing Reports

ID
Report Name
Report Description
Business Process
Report Type
As of Date
PCR008Project Expenditures ReportA custom report that lists project expenditures by COA ChartField combinations and includes project specific data elements.90.1.1 Add or Modify Project

90.1.5 Monitor and Closeout Project

90.2.3 Monitor and Closeout Grant
Data Warehouse

Published 01/31/2025
PCR013FCO Certified Forward Request Detail ReportFCO Certified Forward Request Detail Report is a detailed, custom report which includes all FCO appropriation balances, including projects and activity balances, and the amounts agencies will request to be Certified Forward.90.1.5 Monitor and Closeout Project

90.1.6 FCO Certified Forward Request

PeopleSoft

Published 06/04/2024
PCR015Appropriations Budget vs. Project Budget ReportThis report provides a comparison between Project Budget Balances and Appropriations Balances. For FCO project types, the agency should review the Appropriations Budget vs. Project Budget Report (PCR015). This report will allow the Agency to determine any variance between the FCO Appropriation and the remaining project and activity balances budgeted to those funding sources.20.3.2 Certified Forward

90.1.1 Add or Modify Project

90.1.5 Monitor and Closeout Project

90.1.6 FCO Certified Forward Request 

PeopleSoft
Published 09/06/2024

Purchase Order Module Reports

ID
Report Name
Report Description
Business Process
Report Type
As of Date
POR009Outstanding Encumbrance Errors ReportA report that lists unresolved encumbrance exceptions.30.2.2 Monitor EncumbrancesPeopleSoft
Published 12/01/2023

System Design Reports

ID
Report Name
Report Description
Business ProcessReport TypeAs of Date
SDR003SpeedKey ReportThe SpeedKey Report fetches the SpeedKeys added or modified in Florida PALM. The output file can be used by Agency Business Systems, and Enterprise partners to select the appropriate SpeedKey reflecting the combination of ChartField values needed and create transaction within each module, namely General Ledger (GL), Commitment Control (KK), Accounts Payable (AP), Purchasing (PO), and Accounts Receivable (AR) using identified ChartField values.10.1.6 Agency Set Up and Maintain SpeedKeysPeopleSoft
Published 08/23/2024
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.