Process Daily Payroll Tax Data (100.8.1)
  • 30 Jul 2024
  • 3 Minutes to read
  • Dark
    Light
  • PDF

Process Daily Payroll Tax Data (100.8.1)

  • Dark
    Light
  • PDF

Article summary

Business Process Overview

Process Daily Payroll Tax Data encompasses the daily gathering of employee tax withholdings, employer tax liabilities, and tax payments made to taxing authorities. Tax payments due are also calculated and managed daily along with reconciling the tax trust accounts.

Business Process Diagram

Business Process Flow for 100.8.1 Process Daily Payroll Tax Data

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

Tax Data Table Update Process

After the payroll cycle completes for the day, all tax related employee withholdings and employer liabilities will be stored in the tax data table for reporting and tracking.


2

Review Daily Tax Reports

BOSP Tax Maintainer will review the Daily Tax Activity Report and the Projected Tax Liability Report.


If a tax deposit is needed, proceed to step 3, Select Tax Payments from Tax Settlement Page. If no tax deposits are needed, proceed to step 4, Reconcile Tax Trust Funds.


3

Select Tax Payments from the Tax Settlement Page

If a tax deposit is needed, the BOSP Tax Maintainer will select the tax class items from the Tax Settlement Page to be paid. The page will total all amounts to paid and update the tax data table when the page is saved.


After tax payments selections are made, the BOSP Tax Maintainer will process a voucher request through Accounts Payable as described in 30.3 Enter and Process Vouchers.


4

Reconcile Tax Trust Funds

If needed, the BOSP Tax Maintainer will use the Tax Data page information to reconcile tax data table balances with the tax trust fund balances.

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

R1

PRR038

Daily Tax Activity Report – A report that lists all activity on the tax data table for the respective day.

PeopleSoft

Daily

BOSP

R2

PRR039

Projected Tax Liability Report – A report of projected upcoming tax deposits.

PeopleSoft

Daily

BOSP

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

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.