Reconcile Monthly Payroll Taxes (100.8.2)
  • 30 Jul 2024
  • 3 Minutes to read
  • Dark
    Light
  • PDF

Reconcile Monthly Payroll Taxes (100.8.2)

  • Dark
    Light
  • PDF

Article summary

Business Process Overview

Reconcile Monthly Payroll Taxes includes the monthly reconciliation between the Florida PALM payroll activity and the Florida PALM tax data table containing the daily tax transaction activity.

Business Process Diagram

Business Process Flow for 100.8.2 Reconcile Monthly Payroll Taxes

Business Roles

The Business Process Flow Diagrams use horizontal swim lanes to depict where activities are performed by different parties or systems. Each swim lane is titled with a role, either agency-based or within DFS, and in some cases, are representative of an external entity or system. The swim lanes may change from page to page within a single business subprocess as more or fewer roles are required to execute sections of the business subprocess. 

  • BOSP Tax Maintainer: BOSP role responsible for managing tax payment processes with the ability to update tax configuration.

Business Process Flows Details

The tables below describe steps in each business subprocess as reflected on the Business Process Flow Diagrams. The tables also reflect information associated with each step describing the intent of the specific process. Florida PALM screenshots are included within the sections to allow connections to be made from specific business subprocess steps to screens within Florida PALM. This information should be read in conjunction with the Business Process Flow Diagrams.

Process Step ID

Process Step Title

Description of Process

1

Run Monthly Tax Reports

BOSP Tax Maintainer will manually run the reports needed for monthly payroll tax reconciliations.


2

Reconcile Tax Trust Funds

BOSP Tax Maintainer will use the information from the Tax Data Table page to reconcile tax data table balances with the tax trust fund balances.


3

Reconcile Tax Reports to Tax Data Table

BOSP Tax Maintainer will use the Monthly Tax Reconciliation Report to reconcile between the tax data table and what the system has processed over the past month.


The Monthly Tax Deposit Report will be used to reconcile tax payments entered in the tax data table and the system reported tax liabilities for the month.


4

Enter Tax Data Table Adjustments

After the monthly reconciliations, the BOSP Tax Maintainer will enter any needed adjustments into the tax data table and re-run the monthly reconciliation reports for verification.

Accounting Events

Accounting events originate during transaction processing in the applicable source module. The accounting events impact the source module, Commitment Control ledgers, and the General ledger (Actuals).

  • Source Module accounting entries require user input (I) of the primary line (i.e., expenditure, revenues) with an automated (A) system offsetting line (i.e., payable, receivable) during transaction entry. The source model transaction must pass Edit Check, Budget Check, and Cash Check (on applicable entries) prior to posting the transaction.
  • The Run Budget Check (Commitment Control) process automatically affects balances in the appropriate budget ledger (i.e., appropriation, spendable cash) if the transaction passes the budget check process.
  • After the transaction is posted in the source module, an automated system process summarizes and posts the entries in the General Ledger module to the Actuals Ledger.

The table below provides the most common accounting events applicable to this business process.

Acct Event ID 

Accounting Event

Commitment Control Ledger(s) Impact

Source Module Accounting Entry

General Ledger (Actuals) Entry

N/A





Reports

Key Reports are displayed as icons with the Report Number on this Business Process. The table below provides the reports identified to be produced at a particular process step or is used to support the completion of a process step.

Report Number

Report RICEFW ID

Report Description

Report Source

Report Frequency

Audience

R3

PRR040

Tax Trust Fund Reconciliation Report – A report to reconcile tax activity in HCM to Tax Trust Fund cash balances in the General Ledger.

DW/BI

On-Demand

BOSP

R4

PRR041

Tax Reconciliation Report – A report comparing the tax withholdings to the tax data table for the period requested.

PeopleSoft

Monthly

BOSP

R5

PRR042

Tax Deposit Report – A report reconciling the system tax withholdings with the tax deposits for the period requested. 

PeopleSoft

Monthly

BOSP

Interfaces

The table below provides the Interfaces identified on the Business Process.

Interface Number

Interface Description

Interface Frequency

Source

Target

N/A





Forms

The table below provides the forms identified on this Business Process.

Form Number

Form Description

Audience

N/A



Workflows

The table below provides the workflows identified on this Business Process.

Workflow Number

Workflow Description

Audience

N/A



Version History

Date

Revision Description

07/30/2024

Original Version

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.