Preliminary Payroll Cash and Budget Balance Report (PRR023)

Print
Share
Dark

Light
PDF

Article summary

Did you find this summary helpful?

Thank you for your feedback

Report Description

Before payroll is confirmed in Florida PALM, the state Actuals Distribution Process will run to provide a preview of the accounting distribution associated with the payroll that is being ran. To support payroll accounting distributions, all active positions must have valid position funding associated with them or a SpeedKey must be provided on the individual earnings transaction. The Bureau of State Payroll (BOSP) and agencies will be able to view the actual distribution and determine if any funding updates need to be made in Florida PALM before payroll is confirmed and accounting finalized.

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. The payroll amount is the amount charged to a unique combination of the following ChartFields:

Business Unit
Fund
Budget Entity
Category Level

This combination of ChartFields is given by the SpeedKey associated to the position or the earnings processed in payroll. The report will look at the payroll distributions for earnings, deductions, and taxes to determine the payroll amount reported. The spendable cash, appropriations, and GR release balances will be pulled from Florida PALM’s Financials module database.

Report Navigation: Main Menu > Florida PALM > Payroll > Reports > Preliminary Payroll Cash and Budget Balance Report

Click below to view the sample report layout.

PRR023_Pre_Actuals_Cash_and_Budget_Balance_Report_Payroll.xlsx

Business Roles

The following business roles have access to this report:

Business Process Models

This report can be found in the following business processes:

100.7.2 Generate Payroll Accounting Distributions

Selection Criteria

The report data can be filtered by the following selection criteria:

Data Field	Data Field Details
Pay Run ID	Conditional
Pay End Date	Conditional
Pay Group	Conditional
Business Unit	Optional

Report Layout

The layout of the report is listed below.

Data Field	Florida PALM RECORD.FIELD Mapping
Business Unit	VALID_COMBO_TBL.SETID
Fund	VALID_COMBO_TBL.FUND_CODE
Budget Entity	VALID_COMBO_TBL.BUDGET_REF
Category	VALID_COMBO_TBL.PRODUCT
Budget Period	If Category ChartField is NOT “08” or “14,” then Budget Period is: FISCAL_YEAR on payroll distribution tables. If Category ChartField is “08” or “14," then Budget Period is: VALID_COMBO_TBL.RESOURCE_SUB_CAT
Preliminary Payroll Amount	Sum the following amounts for all rows that have the combination of the BU, Fund, BE, and Category ChartFields after the join of the payroll distribution tables with valid combination code table: PAY_ERN_DIST.EARNINGS PAY_DED_DIST.DED_CUR PAY_TAX_DIST.TAX_CUR
Spendable Cash Balance	Sum the Posted Total Amount field (POSTED_TOTAL_AMT) for the following ledgers (LEDGER_ KK.LEDGER): C_CSH_CNV C_CSH_SC Leave the field blank for GR funds. Format negative values in parentheses.
Appropriations Balance	Sum the Posted Total Amount field (POSTED_TOTAL_AMT) for the following ledgers (LEDGER_ KK.LEDGER): C_APPR_BD C_APPR_ENC C_APPR_EXP Multiply sum by negative 1. Format negative values in parentheses.
GR Release Balance	Sum the Posted Total Amount field (POSTED_TOTAL_AMT) for the following ledgers (LEDGER_ KK.LEDGER): C_REL_BD C_REL_EXP Multiply sum by negative 1. Leave this field blank for trust funds. Format negative values in parentheses.
Anticipated Spendable Cash	Subtract the value in the Preliminary Payroll Amount field from the Spendable Cash Balance field. Leave this field blank if Spendable Cash is not populated. Format negative values in parentheses.
Anticipated Appropriations	Subtract the value in the Preliminary Payroll Amount field from the Appropriations Balance field. Format negative values in parenthesis.
Anticipated GR Release	Subtract the value in the Preliminary Payroll Amount field from the GR Release Balance field. Leave this field blank if GR Release is not populated. Format negative values in parentheses.

Version History

Date	Revision Description
07/02/2024	Original Version
08/21/2024	Renamed to Preliminary Payroll Cash and Budget Balance Report and removed 100.3.2 and 100.3.4 BPMs

Was this article helpful?

What's Next

Payroll Deduction Report (PRR016)

Table of contents

Report Description
Business Roles
Business Process Models
Selection Criteria
Report Layout
Version History