Payroll Cash Budget Balance Report (PRR023)
  • 24 Jun 2024
  • 3 Minutes to read
  • Dark
    Light
  • PDF

Payroll Cash Budget Balance Report (PRR023)

  • Dark
    Light
  • PDF

Article summary

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.

Business Roles

The following business roles have access to this report:

  • Batch Scheduler
  • Agency Payroll Accounting Maintainer
  • Agency Payroll Reporter
  • BOSP Payroll Processor
  • BOSP Payroll Reporter
  • BOSP Payroll Maintainer

Business Process Models

This report can be found in the following business processes:

  • 100.3.2 Calculate Payroll
  • 100.3.4 Confirm Payroll
  • 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



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.