- 24 Apr 2024
- 18 Minutes to read
-
Print
-
DarkLight
-
PDF
Reports
- Updated on 24 Apr 2024
- 18 Minutes to read
-
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 |
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. |
AMR040 | Asset Exception Report | A report that lists asset related Vouchers with incomplete asset information. |
AMR042 | Asset Staging Report | A report that provides a list of asset transactions in Asset Management that have been staged for processing. |
AMR045 | Asset Workflow Status Report | A report that lists the approval status of asset transactions (e.g., approved, denied and pending). |
AMR052 | Configuration Report | A report that lists current asset controls. |
AMR043 | New Assets Report | A list of asset records created since last inventory date. |
AMR026 | Total Assets Purchased Report | A report that lists the total amount of fixed asset purchases by agency/division. |
Accounts Payable Module Reports | ||
ID | Report Name | Report Description |
APR091 | AP Holds by Hold Type Report | A list of all Vouchers on hold including the hold reason. |
APR008 | AP Staff Productivity Report | A Voucher activity count by username. |
APR125 | Budget Check Errors (WorkCenter) | A report in the WorkCenter used to display a list of vouchers with Budget Check errors. |
APR126 | Cash Check Errors (WorkCenter) | A report in the WorkCenter used to display a list of vouchers with Cash Check errors. |
APR064 | Clearance Pattern Report | A report that details the clearance pattern for designated projects. |
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. |
APR069 | Duplicate Suppliers Report | A report that identifies potential duplicate Supplier records, or related suppliers. |
APR053 | Encumbered Disbursements Report | A list of Payments made that are associated with an Encumbrance. |
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. |
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. |
APR018 | Outstanding Warrants Report | A report that lists Stale Dated Warrants that are outstanding, expired, or about to expire by specified date range to include warrant type, chart of account ChartFields, payment transaction data and Business Unit. |
APR050 | Payment Cancellation Report | A report that lists all cancelled payments and the number of days outstanding at the point of cancellation. |
APR032 | Payment Detail Report | A report that lists Warrant and electronic payment detail and status (cleared, outstanding, cancelled, or reissued) for all payments. |
APR034 | Payment Discounts and Discounts Lost Report | A report that lists discounts received for payments made in compliance with Supplier payment terms and payments made that were not in accordance with supplier payment terms. |
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. |
APR021 | Payment Register Report | A report that lists electronic, warrant, or manual payments made as part of Pay Cycle. |
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. |
APR098 | Post Audit Sampling Report | A report that lists payments subject to post audit sampling. |
APR049 | Project and Contract Expense Summary Report | A report of project and Contract payment information by month, quarter, fiscal and calendar year, inception to date, or time period with the ability to export data into an excel format. |
APR001 | Prompt Payment Compliance 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. |
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. |
APR007 | Scheduled Payments Report | A report that lists Vouchers scheduled to be paid. |
APR096 | Single Payment Vouchers Report | A listing of all Vouchers processed using a single payment supplier. If any Single Payment Voucher with a 1099 Object Code was approved and processed, it is included on this report. |
APR112 | A report that lists supplier banks in Florida PALM that were updated or not listed on the Authorized Bank Titles File. | |
APR068 | Supplier Detail Report | A report that lists Suppliers by name, TIN, or other identifying information. |
APR006 | Supplier Payments Report | A report that summarizes payments by Supplier and other key data elements. |
APR052 | Unencumbered Disbursements Report | Report that lists payments made that are not associated with an Encumbrance. |
APR013 | A report that lists daily voucher activity. | |
APR010 | Voucher Approval Aging Report | An aging schedule of vouchers pending approval. |
APR004 | Voucher Match Exceptions Report | A listing of vouchers with match exceptions. |
APR009 | Voucher Register | A report that lists posted vouchers, to include totals, that can be filtered by various criteria. |
APR014 | A report that lists the status of each voucher while it is in Voucher Workflow. | |
APR092 | Vouchers Deleted Report | A listing of vouchers deleted due to errors. |
APR033 | Warrant Printing Report | A report that lists Warrants printed for distribution. |
Accounts Receivable Module Reports | ||
ID | Report Name | Report Description |
ARR025 | AR Data Report | A PeopleSoft report that provides AR data including pending items to agencies for analysis purposes. |
ARR024 | Debit Memo | A report that provides Returned items information (includes image for returned checks). |
ARR007 | Deposit Report | A report that provides detailed information for deposits. |
ARR067 | Direct Journal Accounting Entry Errors (WorkCenter) | Used to correct Direct Journal accounting entry edit errors. |
ARR029 | Direct Journal Budget Exceptions (WorkCenter) | A delivered report used to review Direct Journal budget checking errors. |
ARR070 | DOR Agency Deposit Report | This report provides a list of Agency Deposit transactions that were entered by DOR. |
ARR065 | Posting Errors (WorkCenter) | A delivered report in the WorkCenter used to display pending items containing errors, with access to Online Error Correction pages. |
ARR020 | Reconciled Deposits Report | A report that provides reconciled deposits. |
ARR022 | Revenue Estimate Exceptions (WorkCenter) | A delivered report used to review Revenue Estimate budget checking errors. |
ARR021 | Unreconciled Deposits Report | A report that provides a list of unreconciled deposits. |
Cash Management Module Reports | ||
ID | Report Name | Report Description |
CMR011 | Accounting Errors (WorkCenter) | Summary listing of accounting errors. |
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. |
CMR028 | CRA Activity Statement | Report that provides activity and balance detail for Consolidated Revolving Accounts. |
General Ledger Module Reports | ||
ID | Report Name | Report Description |
GLR115 | A report used by EOG/OPB providing GL journal detail entered in the adjustment period 998. | |
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. |
GLR079 | Cash Balance and Activity Report | A custom report that provides the cash balance and related cash transactions for requested combination of ChartFields. |
GLR137 | ChartField Requests Pending My Approval WorkCenter | A PeopleSoft report in the WorkCenter used to display a list of ChartField requests that are pending approval from the current user. |
GLR091 | ChartField Value Report | PeopleSoft or Data Warehouse report listing established ChartField values. |
GLR167 | Combination Edit Detail Report | Report/query to pull detail Combination Edit data to be used in conjunction with the Inbound Combination Edit Spreadsheet Upload (GLI084) tool. |
GLR133 | Incomplete Journals (WorkCenter) | A delivered report in the WorkCenter used to display a list of journals that are saved with an incomplete status. |
GLR083 | Investment transactions and balances by pool and participant. | |
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. |
GLR136 | Journals Pending My Approval (WorkCenter) | Journals that are pending approval from the current user. |
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). |
GLR140 | Journals with Edit Errors (WorkCenter) | Journals specifically with edit errors that require action. |
GLR139 | Journals with Errors (WorkCenter) | Journals with any type of error that requires action. |
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. |
Commitment Control Reports | ||
ID | Report Name | Report Description |
KKR018 | Agency Obligations Report | A custom report that provides encumbrances and payables by ChartField combinations. |
KKR013 | Annual Operating Budget | A custom report displaying agency Allotments of adjusted Appropriations by program. |
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. |
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. |
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. |
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. |
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. |
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. |
KKR010 | Spend Plan Projections Report | A custom report displaying balances of Appropriations, Encumbrances, expenditures, scheduled payments and available balances with a variable user-defined projection rates. |
Payroll Module Reports | ||
ID | Report Name | Report Description |
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. |
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 |
Purchase Order Module Reports | ||
ID | Report Name | Report Description |
POR008 | Closed Encumbrances Report | A report that lists closed Encumbrances. |
POR002 | Encumbrance Aging Report | A report that lists all Encumbrances, date encumbrance was established, and the date the last activity occurred. |
POR009 | Outstanding Encumbrance Errors Report | A report that lists unresolved Encumbrance exceptions. |
POR006 | Purchase Orders Under Pending Approval Group (WorkCenter) | A report that lists Purchase Orders that are under the 'Pending Approval' group. |
System Design Reports | ||
ID | Report Name | Report Description |
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. |