-
Print
-
DarkLight
-
PDF
Reports Catalog
-
Print
-
DarkLight
-
PDF
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. Below is a list of the planned reports in Florida PALM by module. As the report designs are completed, the Project will provide a list of new or updated reports.
- Access Advanced Search: Navigate to the Advanced search bar on the Homepage.
- Use Date Filters:
- By Week, Month, Year: Specify the timeframe to filter results according to recent updates.
- Specific Date: If you're looking for updates on a particular day, enter the date to refine your search.
- Use Tags and Categories:
- Tags: These help categorize content based on specific topics or keywords. Use relevant tags to narrow down your search.
- Categories: Filter results based on predefined categories to find information within specific domains.
For more guidance, click here to see a video demonstration on how to use the advanced search feature and filter content when searching for encumbrances!
Asset Management Module Reports | |||
ID | Report Name | Report Description | 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. | Published 01/31/2025 |
AMR007 | Asset Report by User and Location | A report of all assets assigned to an individual by location. | Published 01/31/2025 |
AMR013 | Asset Acquisition by PO or Supplier Report | A report that lists assets by Purchase Order or Supplier. | Published 01/31/2025 |
AMR014 | Asset Disposition Report | A 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. | Published 01/31/2025 |
AMR017 | Asset Summary Depreciation Report | A list of assets depreciated during the period by asset types. | Published 01/31/2025 |
AMR019 | Asset Register Report | A transaction register of all changes during a user-defined time period by asset class type, agency, transaction date or purchase amount. | Published 01/31/2025 |
AMR020 | Asset Physical Inventory Report | A physical inventory report that sorts, groups, and aggregates asset records based on available fields criteria to assist in conducting physical inventory. | 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. | Published 12/01/2023 |
AMR039 | Asset Physical Inventory Reconciliation Report | An asset inventory report that lists variances between system amounts and physical counts. | 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. | 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). | Published 12/01/2023 |
AMR047 | Asset Statewide Rollup Report | A report that lists asset balances at a statewide reporting level. | Published 01/31/2025 |
AMR048 | Building 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. | Published 01/31/2025 |
AMR060 | Incomplete Asset Profile Report | A report used to alert custodian supervisor when an asset is paid for, but the asset record data is incomplete. | Published 01/31/2025 |
AMR062 | Asset Replacement Cost by Asset Class Type | A report that lists asset replacement costs by asset category. | Published 01/31/2025 |
AMR068 | Summary of Assets | A 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. | Published 01/31/2025 |
AMR069 | Detailed Asset Listing Report | A report that lists assets based on available fields. | Published 01/31/2025 |
Accounts Payable Module Reports | |||
ID | Report Name | Report Description | As of Date |
APR001 | Prompt Payment Interest Paid Report | A 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. | Published 01/31/2025 |
APR002 | Prompt Payment Compliance Report | A report that lists interest paid for invoices not timely paid in accordance with prompt pay requirements. | Published 01/31/2025 |
APR003 | Outstanding Vouchers Report | The 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. | Published 12/01/2023 |
APR004 | Voucher Match Exceptions Report | A listing of vouchers with match exceptions. | Published 06/04/2024 |
APR006 | Supplier Payments Report | A report that summarizes payments by Supplier and other key data elements. | Published 01/31/2025 |
APR007 | Scheduled Payments Report | A report that lists Vouchers scheduled to be paid. | Updated 10/30/2024 |
APR009 | Voucher Detail | A report that lists posted vouchers that can be filtered by various criteria. | Published 01/31/2025 |
APR013 | Voucher Activity Report | A report that lists daily voucher activity. | Updated 11/13/2024 |
APR014 | Voucher Workflow Status Report | A report that lists the status of each voucher while it is in Voucher Workflow. | Updated 11/13/2024 |
APR018 | Outstanding 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. | Published 01/31/2025 |
APR021 | Payment Register Report | A report that lists electronic, warrant, or manual payments made as part of Pay Cycle. | Published 01/31/2025 |
APR024 | Prompt Payment Report | The 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. | 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). | Published 01/31/2025 |
APR027 | Payment Summary | A 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. | Published 01/31/2025 |
APR032 | Payment Detail Report | A report that lists warrant and electronic payment detail and status (cleared, outstanding, cancelled, or reissued) for all payments. | Published 01/31/2025 |
APR033 | Warrant Printing Report | A report that lists Warrants printed for distribution. | Published 11/01/2023 |
APR036 | 1099 Withholding Report | A report that provides a list of 1099 suppliers including related 1099 Payment details. | Published 01/31/2025 |
APR047 | Employee Suppliers Report | A report that lists employees doing business with the State as a supplier. | Published 01/31/2025 |
APR050 | Payment Cancellation Report | A report that lists all cancelled payments and the number of days outstanding at the point of cancellation. | Updated 10/30/2024 |
APR051 | Contract 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. | Published 01/31/2025 |
APR055 | Employee Reimbursement Report | A report that lists payments to an employee for reimbursable business events (i.e., travel). | Published 01/31/2025 |
APR064 | Clearance Pattern Report | A report that details the clearance pattern for designated projects. | Published 01/31/2025 |
APR068 | Supplier Detail Report | A report that lists Suppliers by name, TIN, or other identifying information. | Published 01/31/2025 |
APR069 | Duplicate Suppliers Report | A report that identifies potential duplicate Supplier records, or related suppliers. | Published 01/31/2025 |
APR091 | AP Holds by Hold Type Report | A list of all Vouchers on hold including the hold reason. | Updated 06/10/2024 |
APR102 | AP ACH Returns and Reissued Warrants | The 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. | 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. | 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. | Published 01/31/2025 |
APR112 | Supplier Authorized Banks Exceptions and Updates Report | A report that lists supplier banks in Florida PALM that were updated or not listed on the Authorized Bank Titles File. | Published 12/01/2023 |
APR118 | Payment 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. | Published 01/31/2025 |
APR125 | Budget Check Errors (WorkCenter) | A report in the WorkCenter used to display a list of vouchers with Budget Check errors. | More information coming soon! |
APR126 | Cash Check Errors (WorkCenter) | A report in the WorkCenter used to display a list of vouchers with Cash Check errors. | Published 06/17/2024 |
APR140 | Funds Transferred to Unclaimed Property and Funds Exempt from Transfer to Unclaimed Property Report | A 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. | Published 01/31/2025 |
Accounts Receivable Module Reports | |||
ID | Report Name | Report Description | As of Date |
ARR007 | Deposit Report | A report that provides detailed information for deposits. | Updated 11/05/2024 |
ARR020 | Reconciled Deposits Report | A report that provides reconciled deposits. | Updated 11/05/2024 |
ARR021 | Unreconciled Deposits Report | A report that provides a list of unreconciled deposits. | Updated 11/05/2024 |
ARR024 | Debit Memo | A report that provides Returned items information (includes image for returned checks). | Published 12/01/2023 |
ARR025 | AR Data Report | A PeopleSoft report that provides AR data including pending items to agencies for analysis purposes. | Published 02/06/2024 |
ARR067 | Direct Journal Accounting Entry Errors (WorkCenter) | Used to correct Direct Journal accounting entry edit errors. | More information coming soon! |
ARR070 | DOR Agency Deposit Report | This report provides a list of Agency Deposit transactions that were entered by DOR. | Updated 10/30/2024 |
Cash Management Module Reports | |||
ID | Report Name | Report Description | As of Date |
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. | Updated 11/13/2024 |
CMR011 | Accounting Errors (WorkCenter) | Summary listing of accounting errors. | More information coming soon! |
CMR028 | CRA Activity Statement | Report that provides activity and balance detail for Consolidated Revolving Accounts. | Published 02/01/2024 |
General Ledger Module Reports | |||
ID | Report Name | Report Description | As of Date |
GLR079 | GR Cash Balance and Activity Report | GR 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. | Published 07/02/2024 |
GLR080 | Cash Balance by Fund Type | A custom report that summarizes balances by Fund type for Transparency site. | Published 01/31/2025 |
GLR083 | Investment Activity Report | Investment transactions and balances by pool and participant. | Published 10/25/2023 |
GLR086 | Revenue CAP Report | A custom report providing balances by BU for specified categories (i.e., revenue and refund) for the fiscal year. | Updated 02/04/2025 |
GLR088 | Trust Fund Report | An 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. | Updated 02/10/2025 |
GLR091 | ChartField Value Report | PeopleSoft or Data Warehouse report listing established ChartField values. | More information coming soon! |
GLR099 | Trial Balance Report | A 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. | Updated 07/22/2024 |
GLR110 | Capital Assets Account Reconciliation Report | This report displays all balances related to Asset expense account values. | Published 10/25/2024 |
GLR112 | Agency Balance Sheet Report | A 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. | Published 01/31/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. | Published 11/01/2023 |
GLR132 | Journals 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). | More information coming soon! |
GLR133 | Incomplete Journals (WorkCenter) | A delivered report in the WorkCenter used to display a list of journals that are saved with an incomplete status. | More information coming soon! |
GLR136 | Journals Pending My Approval (WorkCenter) | Journals that are pending approval from the current user. | More information coming soon! |
GLR139 | Journals with Errors (WorkCenter) | Journals with any type of error that requires action. | More information coming soon! |
GLR140 | Journals with Edit Errors (WorkCenter) | Journals specifically with edit errors that require action. | More information coming soon! |
GLR143 | Journals - Commitment Control Exceptions (WorkCenter) | A delivered report in the WorkCenter used to display a list of journals with Budget Check exceptions that require action. | More information coming soon! |
GLR160 | Annual Budgetary Basis Expenditures Report | A custom report that provides posted appropriation amounts, disbursements, tentative and approved certified forward and reversion amounts. | Updated 02/04/2025 |
GLR161 | Trust Funds Terminations Report | A 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. | Published 01/31/2025 |
GLR163 | Census Bureau Detailed Expenditures and Revenues Report | A custom report containing detailed expenditure and revenue totals by Account value provided to the US Census Bureau. | Updated 02/13/2025 |
GLR164 | Equity Comparison by Fund | A custom report comparing the beginning and ending balances of equity by Fund. | Published 01/31/2025 |
GLR167 | Combination 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. | Published 01/31/2025 |
GLR168 | Multi-Year Project, Contract or Grant Activity Summary Report | A report that summarizes transaction amounts for a given date range of FLAIR and Florida PALM project, grant, or contract transactions from the General Ledger. | Published 01/31/2025 |
GLR169 | Annual GAA Load Values Report | The 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. | Published 12/01/2023 |
GLR171 | Cash Basis Transaction Reconciliation Report | This 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. | Published 08/07/2024 |
GLR172 | Cash Balances Reconciliation Report | A 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. | Published 01/31/2025 |
Grants Management Module Reports | |||
ID | Report Name | Report Description | As of Date |
GMR001 | Expense and Revenue by ALN/CSFA Report | A report that displays summary of expenses and revenues by ALN/CSFA numbers. | Published on 01/31/2025 |
Commitment Control Module Reports | |||
ID | Report Name | Report Description | As of Date |
KKR008 | Schedule of Allotment Balance Report | The 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. | Published 12/01/2023 |
KKR010 | Spend Plan Projections Report | A report displaying appropriations balances, encumbrances, expenditures (actuals and scheduled payments), and available balances. | Published 01/31/2025 |
KKR016 | Negative Budget and Cash Balances Report | The Negative Budget and Cash Balances Report is designed to provide agencies with timely information regarding all negative budget and cash balances. | Published 08/07/2024 |
KKR018 | Agency Commitments Report | The 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. | Updated 10/11/2024 |
KKR019 | Budget Detail Activity Report | The 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. | Updated 09/04/2024 |
KKR022 | Appropriations Budget Ledger Balances Reconciliation Report | The 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. | Published 12/01/2023 |
KKR023 | Revenue Report | A custom report that provides revenue estimates, revenue recognized, and revenue collected by Fund, Budget Entity, Category, and Account code by ChartField combinations. | Published 01/31/2025 |
KKR044 | Continuing Appropriations Balance Report | A custom report displaying balances of appropriations, encumbrances, expenditures, scheduled payments and available balances with a variable user-defined projection rates. | Updated 09/06/2024 |
KKR046 | February Reversion FCO Projects Worksheet Report | This 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. | Updated 09/06/2024 |
KKR057 | Tentative Carry Forward Certified Forward Balances Report | This report lists Carry Forward (Operating) Unexpended Releases and Certified Forward FCO Unexpended Appropriations for the current fiscal year. | Updated 09/06/2024 |
KKR058 | Budget and Cash Checking Exceptions/Warnings Report | A 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. | Published 02/01/2024 |
KKR059 | Trust Fund Cash Balance and Activity Report | This 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. | Published 07/02/2024 |
Inter/IntraUnit Module Reports | |||
ID | Report Name | Report Description | As of Date |
IUR002 | GR Service Charge Report | A custom report that lists service charges by ChartField combination for each Agency. | Published 01/31/2025 |
IUR003 | Inter/IntraUnit Transaction Reconciliation Report | A 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. | Published 01/31/2025 |
IUR004 | IU 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. | Published 01/31/2025 |
IUR005 | Inter/IntraUnit Transaction Detail Report | The 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. | Updated 01/09/2025 |
IUR006 | Inter/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. | Updated 11/13/2024 |
IUR007 | Pending 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. | Updated 11/25/2024 |
IUR008 | Received 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. | Updated 10/08/2024 |
IUR009 | IU 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. | Updated 11/12/2024 |
IUR010 | Denied 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. | Updated 11/13/2024 |
IUR011 | IU 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. | Updated 12/03/2024 |
Payroll Module Reports | |||
ID | Report Name | Report Description | As of Date |
PRR001 | HR Accounting Line Report | After 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. | Published 06/04/2024 |
PRR004 | Salary Refund Report | A report that lists salary refunds or other collections by employee or agency. | Published 01/31/2025 |
PRR007 | Earnings/Deductions Register Report | The 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. | Published 05/21/2024 |
PRR010 | Payroll Register | The 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. | Updated 08/21/2024 |
PRR011 | Payroll Tax Report | During 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. | Updated 08/21/2024 |
PRR012 | Payroll Summary Report | A 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. | Updated 08/21/2024 |
PRR016 | Payroll Deduction Report | A report that will provides deduction details by employee and will be pulled from precalculated deduction data and/or post confirmed deduction data. | Updated 02/04/2025 |
PRR021 | Payroll Period Compare Report | The 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. | Published 10/18/2024 |
PRR023 | Payroll Cash Budget Balance Report | This 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. | Updated 08/21/2024 |
PRR030 | Actuals Funding Report | The 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. | Published 05/21/2024 |
PRR035 | Payroll Warrant Status Report | A report that lists payroll Warrant details and status, indicating whether they have been cleared, outstanding, or canceled. | Updated 08/21/2024 |
PRR036 | Editing Paysheets Changes Report | This is a payroll report that provides a list of transactions that did not pass Edit Check as part of the Editing Paysheets process | Published 06/17/2024 |
PRR037 | Beneficiary Payment Report | A report that identifies payments to beneficiaries. | Published 01/31/2025 |
PRR045 | Employee W-4 Exempt Status Report | The 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. | Published 06/04/2024 |
PRR046 | Payroll Funds Transferred to Unclaimed Property and Funds Exempt from Transfer to Unclaimed Property Report | A 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. | Published 01/31/2025 |
PRR051 | Position Funding Data Report | The 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. | Published 05/21/2024 |
PRR055 | Payroll Deductions Not Taken | Payroll 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. | Published 05/21/2024 |
PRR059 | Inactive Position Funding SpeedKeys Report | The Inactive Position Funding SpeedKeys Report lists active positions whose funding records are assigned to an inactive SpeedKey. | Published 06/18/2024 |
PRR061 | Payroll Error Messages - Query | The 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. | Published 05/21/2024 |
PRR062 | Deductions Register | The 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. | Updated 08/21/2024 |
PRR068 | Expired W-4 Exemption | The 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. | Published 06/17/2024 |
PRR069 | Annual Leave Payments Report | A report that includes FLAIR and Florida PALM annual leave payments to employees. | Published 01/31/2025 |
Project Costing Reports | |||
ID | Report Name | Report Description | As of Date |
PCR008 | Project Expenditures Report | A custom report that lists project expenditures by COA ChartField combinations and includes project specific data elements. | Published 01/31/2025 |
PCR013 | FCO Certified Forward Request Detail Report | FCO 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. | Published 06/04/2024 |
PCR015 | Appropriations Budget vs. Project Budget Report | This 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. | Published 09/06/2024 |
Purchase Order Module Reports | |||
ID | Report Name | Report Description | As of Date |
POR009 | Outstanding Encumbrance Errors Report | A report that lists unresolved encumbrance exceptions. | Published 12/01/2023 |
System Design Reports | |||
ID | Report Name | Report Description | As of Date |
SDR003 | SpeedKey Report | The 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. | Published 08/23/2024 |