Creating and Posting Actuals Data to PeopleSoft Enterprise Financials

This chapter provides an overview of data flow between PeopleSoft Enterprise HRMS and PeopleSoft Enterprise Financials and describes how to:

Click to jump to parent topicUnderstanding the Data Flow Between PeopleSoft Enterprise HRMS and PeopleSoft Enterprise Financials

When you process a payroll, you are liquidating your encumbrances with actual earnings, benefits, and tax expenses. This actuals information needs to be posted to PeopleSoft Enterprise Financials to update the actuals and encumbrance information that is stored there. Before posting actuals information, distribute actuals across the funding sources that you've established on the Department Budget component (DEPT_BUDGET). Then post actuals to PeopleSoft Enterprise Financials using the Actuals GL Interface process (PAYGL02).

The following diagrams illustrate how the data moves from PeopleSoft Enterprise HRMS to PeopleSoft Enterprise Financials. If you are using PeopleSoft Enterprise General Ledger and Commitment Control ledgers.

Creating and posting actuals data to PeopleSoft Enterprise General Ledger

Creating and posting actuals data to PeopleSoft Enterprise General Ledger and Commitment Control

See Also

Option 4: Using the Department Budget Table Component

Click to jump to parent topicRunning Payroll Processes

It's important to understand how the PeopleSoft Enterprise Payroll for North America processes fit into the framework of managing commitment accounting. When you process a payroll, you can automatically update your budgets. When you update your budgets, you liquidate your encumbrances with actual earnings, benefits, and tax expenses and then you post them to your general ledger.

PeopleSoft Enterprise Payroll for North America includes the following basic payroll processes:

After you run the Pay Confirmation process for each pay period, run the Predistribution Audit Report to identifies any errors that could be encountered when the Actuals Distribution is run.

After the errors from the Predistribution Audit Report are addressed, run the Actuals Distribution process. This process distributes actual earnings, deductions, and taxes across the funding sources you've established and notifies you when you've exceeded any budget amounts specified on the Department Budget pages.

The earnings, deductions, and taxes are also distributed across accounting calendars in cases when a pay period spans more than one accounting period. This Actuals Distribution process (PSPPFUND) is described in detail in the following section.

See Also

PeopleSoft Enterprise Payroll for North America 9.1 PeopleBook

Click to jump to parent topicRunning the Predistribution Audit Report

To run the Predistribution Audit report, use the Predistribution Audit Report component (HP_RUN_PREDIST).

This section explains how to run the Predistribution Audit report.

Click to jump to top of pageClick to jump to parent topicPage Used to Run the Predistribution Audit Report

Page Name

Definition Name

Navigation

Usage

Predistribution Audit Report

HP_RUNCTL_PDAUDIT

  • Payroll for North America, Payroll Distribution, Commitment Accounting CAN, Predistribution Audit Report

  • Payroll for North America, Payroll Distribution, Commitment Accounting USA, Predistribution Audit Report

The Predistribution Audit report audits payroll and configuration data and identifies any errors that could be encountered when you run the Actuals Distribution or Actuals GL Interface processes.

Note. Run the Predistribution Audit report after you've run the Paysheet Create process, but before running the Actuals Distribution process.

Click to jump to top of pageClick to jump to parent topicRunning the Predistribution Audit Report

Access the Predistribution Audit Report page (Payroll for North America, Payroll Distribution, Commitment Accounting USA, Predistribution Audit Report).

Pay Run ID

Select the pay run ID of the pay run you will audit.

General Audit

Select to have the system verify that department budgets have been set up for the transactions in the selected pay run.

Specific Employer paid Earning/Deduction/Tax Codes

Select to have the system verify that department budgets have been set up for specific Earnings/Deductions/Tax codes for the transactions in the selected pay run.

Audit Project/Grant

Select to have the system verify that the project/grant ChartField specified in the combination code is valid. The system uses the project ChartField value from the ChartField Transaction Table component (ACCT_CD_TBL) to read the Project Table component (PROJECT).

Click to jump to parent topicRunning the Actuals Distribution Process

This section provides an overview of the Actuals Distribution process and how the system finds funding sources and discusses how to:

Click to jump to top of pageClick to jump to parent topicUnderstanding the Actuals Distribution Process

The Actuals Distribution process (PSPPFUND) distributes actual earnings, employer deductions, and employer taxes across the funding sources you've established and notifies you when you've exceeded any budget amounts specified on the Department Budget component or when a transaction lacks funding. If your pay period isn't fully contained within a single accounting period, the process also distributes earnings, employer deductions, and employer taxes across accounting periods using the calendar information on the Detail Calendar.

The Actuals Distribution process allocates transactions without funding sources or adequate funding to the department budget's suspense combination code. View these transactions and specify a new combination code on the Review Suspense ComboCode Dist component (HP_PYCHK_DIST_SUSP).

The system processes transactions that exceed their budget cap so long as the funding source has the Allow Overspend check box selected on the Department Budget component. The process generates a warning for these transactions.

After running the Actuals Distribution process, modify actuals distribution using the Review Actuals Distribution component (PAYCHECK_DIST).

To post actuals to your general ledger system, including any changes you make on the Review Actuals Distribution component, run the Actuals GL Interface process.

Click to jump to top of pageClick to jump to parent topicUnderstanding How the System Finds Funding Sources

This section discusses how the system finds funding sources for:

Earnings Funding Sources

Where the system looks for funding information depends on whether you are using PeopleSoft Enterprise Time and Labor distribution:

Customers Using Time and Labor Distribution

Customers Not Using Time and Labor or Time and Labor Distribution

If you are using PeopleSoft Enterprise Time and Labor and are using time and labor distribution information when determining actuals funding sources:

  • The system automatically runs the Labor Distribution process when you run the Actuals Distribution process.

  • If you select the Use TL Distribution? check box on the Departments − Comm. Acctg and EG page (DEPARTMENT_TBL_CA):

    • The system takes into account task information entered into PeopleSoft Enterprise Time and Labor during the Actuals Distribution process.

    • The Actuals Distribution process creates an entry for each time and labor task entry. It then distributes the earnings in the appropriate ratio (the same ratio used for labor distribution).

If your system doesn't find any task information, or if you opt not to use time and labor distribution information:

  • The actuals transaction for earnings, produced by the Actuals Distribution process, uses the combination code found on the:

    • Paysheet, if the combination code exists.

    • Dept Budget Earnings page (DEPT_BUDGET_ERN), if there is no combination code on the paysheet.

  • The Paysheets Creation process populates the Combination Code field on the Paycheck Data - Paycheck Earnings: Additional Information page (PAY_CHECK_E1).

    You can override the combination code on the Paysheets, if required.

See Using Time and Labor with Commitment Accounting.

See Integrating Time and Labor and Payroll for North America.

See Option 4: Using the Department Budget Table Component.

See Working with Paysheets.

See Adding Organizational Instances for Employees, Contingent Workers, and POIs.

See Classifying Jobs.

Employer-Paid Deductions and Taxes Funding Sources

For employer deductions and employer taxes, the system looks for a combination code specified on:

  1. The person's Job Data - Payroll page.

  2. If it can't find a combination code there, and a combination code is found on the Paysheet and the default funding option on Department Budget table is either Actuals or Earnings, the process will use the combination code on the Paysheet.

  3. If it can't find a combination code on Job Data and Paysheet, and the default funding option on Department Budget table is either Actuals or Earnings, the process will use the combination code from Dept Budget Earnings page.

  4. If it can't find a combination code there, the process then looks at the Dept Budget Deduction page (DEPT_BUDGET_DED) and Dept Budget Taxes page (DEPT_BUDGET_TAX or DEPT_BUDGET_CTX).

  5. If there is no combination code on the Dept Budget Deduction or Dept Budget Taxes pages, then the Actuals Distribution process can't distribute the actuals and the system will use the suspense account specified on Department Budget Date page.

See Increasing the Workforce.

See Budgeting for Employer-Paid Taxes.

Click to jump to top of pageClick to jump to parent topicPage Used to Run the Actuals Distribution Process

Page Name

Definition Name

Navigation

Usage

Actuals Distribution

RUNCTL_PPFUND

  • Payroll for North America, Payroll Distribution, Commitment Accounting CAN, Distribute Actuals, Actuals Distribution

  • Payroll for North America, Payroll Distribution, Commitment Accounting USA, Distribute Actuals, Actuals Distribution

  • Payroll for North America, Payroll Distribution, Commitment Accounting USF, Distribute Actuals, Actuals Distribution

Runs the Actuals Distribution process (PSPPFUND), which distributes actual earnings, employer deductions, and employer taxes across the funding sources and notifies you when you've exceeded any budget amounts.

Before using this page, you must have run a Pay Confirmation process.

Actuals Distribution/TL Extract

PY_TL_XTRACT_COST

  • Payroll for North America, Payroll Distribution, Commitment Accounting CAN, Actuals Distrib/TL Extract, Actuals Distribution/TL Extract

  • Payroll for North America, Payroll Distribution, Commitment Accounting USA, Actuals Distrib/TL Extract, Actuals Distribution/TL Extract

Runs the Actuals Distribution process and extracts cost information from Time and Labor to distribute actual earnings, employer deductions, and employer taxes across the funding sources and notifies you when you've exceeded any budget amounts.

Before using this page, you must have run a Pay Confirmation process.

Click to jump to top of pageClick to jump to parent topicRunning the Actuals Distribution Process

Access the Actuals Distribution page (Payroll for North America, Payroll Distribution, Commitment Accounting USA, Distribute Actuals, Actuals Distribution).

Actuals Distribution Parameters

Pay Run ID

Select the Pay Run ID.

Distribute Prorate Option

You must select either of the following options:

Calendar Days: The system uses calendar days to calculate prorated amounts across accounting periods

Work Days: If you select this and Use Holiday Schedule, the process prorates by work days, excluding holidays.

If you select Work Days and do not select Use Holiday Schedule, the process prorates by working days, including holidays.

Use Holiday Schedule

Indicate if the process should exclude holidays (based on the holiday schedule) when using Work Days to prorate distribution.

Click to jump to top of pageClick to jump to parent topicRunning the Actuals/Extract TL Costs Process

Access the Actuals Distribution/TL Extract page (actuals distribution and Time and Labor extract) page (Payroll for North America, Payroll Distribution, Commitment Accounting USA, Actuals Distrib/TL Extract, Actuals Distribution/TL Extract).

Commitment Accounting

Run Actuals Distribution

Select to run the Actuals Distribution process.

See Running the Actuals Distribution Process.

On-Cycle Run

If you are processing an on-cycle run, select the Pay Run ID.

Off-Cycle Pay Calendar

If you are processing an off-cycle run, select the Company, Pay Group, and Pay End Date. Enter the page range in the Page # and Thru fields.

Actuals Distribution Parameter

Distribution Prorate Option

If you are prorating actuals across accounting periods, you can prorate using calendar or work days. Select one of the following options for the prorate option:

Calendar Days: The system uses calendar days to calculate prorated amounts across accounting periods

Work Days: If you select this and Use Holiday Schedule, the process prorates by work days, excluding holidays.

If you select Work Days and do not select Use Holiday Schedule, the process prorates by working days, including holidays.

Use Holiday Schedule

Indicate if the process should exclude holidays (based on the holiday schedule) when using Work Days to prorate distribution.

Click to jump to parent topicModifying Actuals Distribution Prior to General Ledger Posting Using the Actuals Distribution Component

To modify actuals distribution prior to general ledger posting, use the Review Actuals Distribution component (PAYCHECK_DIST).

This section provides an overview of the Review Actuals Distribution component and describes how to:

Click to jump to top of pageClick to jump to parent topicUnderstanding the Review Actuals Distribution Component

Use the Review Actuals Distribution component to modify funding distribution information in PeopleSoft Enterprise Human Resources after you've run the Actuals Distribution process but before posting to PeopleSoft Enterprise General Ledger using the Actuals GL Interface process (PAYGL02). Use the Actuals Distribution component to change the funding source, but not the total amount. Actuals, including your changes, are posted to PeopleSoft Enterprise Financials when you run the Actuals GL Interface process.

Click to jump to top of pageClick to jump to parent topicCommon Elements Used in This Section

Corrected and Correction Date

Indicates if the distribution information of this paycheck has been corrected and, if so, the date it was corrected.

Off Cycle

Indicates if this was an off cycle pay period.

Separate Check

If all of the earnings, deductions, or taxes are on a single paycheck for this pay period, this field displays 0 (zero).

If they are on separate checks (for example, a regular earnings check and a bonus earnings check), the field displays a number between 1 and 9.

Empl Record

The employee record number associated with this paycheck.

Department, Job Code, and Position

Select the department and job code or position to which the earnings, deductions, or taxes are distributed. The Job Code and Department fields populate automatically when you select a position.

Currency

The currency of the earnings, deductions, or taxes associated with the Job Code or Position.

Position Pool ID

Displays the Position Pool ID of the Position, if applicable.

Fiscal Year, Period, Combination Code, and Account

Enter the fiscal year, period, combination code, and account to which to distribute the earnings

The Account field is only available if the account override for the expense type (earnings, deductions, or US or Canadian taxes) is selected on the Dept Budget Date page.

Edit ChartFields

Click the Edit ChartFields link to search for an existing combination code or select a unique combination of ChartFields on the ChartField Detail page.

See Editing ChartField Combinations in HRMS Transactions.

Click to jump to top of pageClick to jump to parent topicPages Used to Modify Actuals Distribution

Page Name

Definition Name

Navigation

Usage

Review Actuals Distribution - Earnings

PAY_CHECK_DIST_ERN

  • Payroll for North America, Payroll Distribution, Commitment Accounting CAN, Review Actuals Distribution, Earnings

  • Payroll for North America, Payroll Distribution, Commitment Accounting USA, Review Actuals Distribution, Earnings

  • Payroll for North America, Payroll Distribution, Commitment Accounting USF, Review Actuals Distribution, Earnings

View and modify the actuals distribution after running the Actuals Distribution process and prior to posting to general ledger. When you make changes on this page, the system performs an edit when you save the page to ensure that the total amount of earnings, deductions, and taxes redistributed compares to the paycheck totals.

Review Actuals Distribution - Deductions

PAY_CHECK_DIST_DED

  • Payroll for North America, Payroll Distribution, Commitment Accounting CAN, Review Actuals Distribution, Deductions

  • Payroll for North America, Payroll Distribution, Commitment Accounting USA, Review Actuals Distribution, Deductions

  • Payroll for North America, Payroll Distribution, Commitment Accounting USF, Review Actuals Distribution, Deductions

View and modify the actuals distribution after running the Actuals Distribution process and prior to posting to general ledger.

Review Actuals Distribution - Taxes

PAY_CHECK_DIST_TAX

  • Payroll for North America, Payroll Distribution, Commitment Accounting USA, Review Actuals Distribution, Taxes

  • Payroll for North America, Payroll Distribution, Commitment Accounting USF, Review Actuals Distribution, Taxes

View and modify the actuals distribution after running the Actuals Distribution process and prior to posting to general ledger.

Review Actuals Distribution - Taxes

PAY_CHECK_DIST_CTX

Payroll for North America, Payroll Distribution, Commitment Accounting CAN, Review Actuals Distribution, Taxes

View and modify the actuals distribution after running the Actuals Distribution process and prior to posting to general ledger.

Click to jump to top of pageClick to jump to parent topicModifying Actuals Distribution for Earnings

Access the Review Actuals Distribution - Earnings page (Payroll for North America, Payroll Distribution, Commitment Accounting USA, Review Actuals Distribution, Earnings).

Earnings

Enter the amount of earnings to be distributed to this combination code in this accounting period. The sum of the earnings in the Distribution group box must equal the displayed Earnings amount for the Earnings group box.

Account

If earnings account mapping is enabled for the corresponding department budget, this field is available for entry. When the ChartField Details column is visible, it will contain a link to the page where the user may select a combination code or account value that determines the value of the Account field on the Earnings page.

Click to jump to top of pageClick to jump to parent topicModifying Actuals Distribution for Deductions

Access the Review Actuals Distribution - Deductions page (Payroll for North America, Payroll Distribution, Commitment Accounting USA, Review Actuals Distribution, Deductions).

Current Deduction

Enter the deduction amount to be distributed to this combination code in this accounting period. The sum of the deductions in the Distribution group box must equal the displayed Current Deduction in the Deductions group box.

Account

If deduction account mapping is enabled for the corresponding department budget, this field is available for entry. When the ChartField Details column is visible, it will contain a link to the page where the user may select a combination code or account value that determines the value of the Account field on the Deductions page.

Click to jump to top of pageClick to jump to parent topicModifying Actuals Distribution for Taxes

Access the Review Actuals Distribution - Taxes page (Payroll for North America, Payroll Distribution, Commitment Accounting USA, Review Actuals Distribution, Taxes).

Displays the funding distribution for this tax. You can fund the tax from multiple combination codes by entering more than one row.

Current Tax

Enter the amount of the Current Tax to be funded by this combination code. The total of the values in the Current Tax field must equal the amount in the Current Tax field in the upper group box.

Account

If tax account mapping is enabled for the corresponding department budget, this field is available for entry. When the ChartField Details column is visible, it will contain a link to the page where the user may select a combination code or account value that determines the value of the Account field on the Taxes page.

Click to jump to parent topicViewing and Modifying Suspense Combination Code Actuals Transactions

To view and modify suspense combination code actuals, use the Review Suspense ComboCode Dist component (HP_PYCHK_DIST_SUSP).

When the Actuals Distribution process encounters transactions without funding, it posts the transactions to the transaction's department budget suspense combination code. When the process has completes, the system displays these transactions on the Distribution to Suspense Acct component. View the transactions and enter new combination code information before you run the Actuals GL Interface process.

Click to jump to top of pageClick to jump to parent topicPages Used to View and Modify Suspense Combination Code Actuals Transactions

Page Name

Definition Name

Navigation

Usage

Earnings Suspense Combo Code

HP_PAYERNSUSPDIST

  • Payroll for North America, Payroll Distribution, Commitment Accounting CAN, Review Suspense ComboCode Dist, Earnings Suspense Combo Code

  • Payroll for North America, Payroll Distribution, Commitment Accounting USA, Review Suspense ComboCode Dist, Earnings Suspense Combo Code

View earnings actuals transactions that the system posted to the suspense combination code and change the combination code information.

Deduction Suspense Combo Code

HP_PAYDEDSUSPDIST

  • Payroll for North America, Payroll Distribution, Commitment Accounting CAN, Review Suspense ComboCode Dist, Deduction Suspense Combo Code

  • Payroll for North America, Payroll Distribution, Commitment Accounting USA, Review Suspense ComboCode Dist, Deduction Suspense Combo Code

View deductions actuals transactions that the system posted to the suspense combination code and change the combination code information.

Tax Suspense Combo Code

HP_PAYCTXSUSPDIST

Payroll for North America, Payroll Distribution, Commitment Accounting CAN, Review Suspense ComboCode Dist, Tax Suspense Combo Code

View tax actuals transactions that the system posted to the suspense combination code and change the combination code information.

Tax Suspense Combo Code

HP_PAYTAXSUSPDIST

Payroll for North America, Payroll Distribution, Commitment Accounting USA, Review Suspense ComboCode Dist, Tax Suspense Combo Code

View tax actuals transactions that the system posted to the suspense combination code and change the combination code information.

ChartField Detail

HMCF_HRZNTL_CFLD

Click the Edit ChartFields link.

Use to select individual ChartField values or search for an existing combination code.

Click to jump to top of pageClick to jump to parent topicViewing and Modifying Information on the Suspense Combination Code Actuals Transactions Pages

All of the pages in the Review Suspense ComboCode Dist component share the following process.

To view and modify earnings, deductions, and tax suspense combination code actuals transactions:

  1. Access the appropriate page:

  2. Review the transaction.

    The page displays all the information about the transaction, including name, fiscal year, earnings amount, suspense combination code and other details like Department ID, JobCode, Position number and Position Pool ID.

  3. Enter a new combination code to fund the transaction.

    Enter a new combination code in the Combination Code field to fund these earnings actuals, deduction amount, or current tax when you run the Actuals GL Interface process.

    You cannot change the data in any other fields.

    See Editing ChartField Combinations in HRMS Transactions.

Click to jump to parent topicViewing Summaries of Actuals Distribution

To view summaries of actuals distribution, use Review Actuals Dist Summary component (PAYCHECK_DIST_SUM).

This section describes how to use the Actuals Distribution Summary page to view a summary of actuals distributions for earnings, deductions, and taxes on a single page.

Click to jump to top of pageClick to jump to parent topicPages Used to View Summaries of Actuals Distribution

Page Name

Definition Name

Navigation

Usage

Actuals Distribution Summary

PAY_CHECK_DIST_SUM

Payroll for North America, Payroll Distribution, Commitment Accounting USA, Review Actuals Dist Summary

View the actuals distribution after running the Actuals Distribution process and prior to posting to general ledger.

Actuals Distribution Summary

PAY_CHECK_DIST_CSM

Payroll for North America, Payroll Distribution, Commitment Accounting CAN, Review Actuals Dist Summary

View the actuals distribution after running the Actuals Distribution process and prior to posting to general ledger.

Click to jump to top of pageClick to jump to parent topicViewing the Actuals Distribution Summary for Earnings, Deductions, and Taxes

The Actuals Distribution Summary page displays the combination code actuals transactions for the earnings, deductions, and taxes of the selected paycheck. The component shares many of the same fields as the fields on the Review Actuals Distribution component, but are display only on this page.

To view a summary of all the earnings, deductions, and tax combination code actuals transactions:

  1. Access the Actuals Distribution Summary page (Payroll for North America, Payroll Distribution, Commitment Accounting USA, Review Actuals Dist Summary).

  2. Review the earnings transactions in the Earnings group box.

  3. Review the deductions transactions in the Deductions group box.

  4. Review the tax transactions in the Tax group box.

See Also

Modifying Actuals Distribution Prior to General Ledger Posting Using the Actuals Distribution Component

Click to jump to parent topicRunning the Commitment Accounting Actuals GL Interface Process

To run the commitment accounting actuals GL Interface process, use the Commitment Accounting Actuals component (RUN_PAYGL02).

Like the Encumbrance GL Interface (PAYGL03) process, the Actuals GL Interface process (PAYGL02.SQR) prepares actuals transactions (expenses and liabilities) to be published to the general ledger. This process also liquidates encumbered amounts to reflect that the actuals for that pay period have been processed. All processed transactions are reflected on the Dept Budget Actuals page.

Run the Actuals GL Interface process once per pay period, after you've completed all manual updates to the defaulted labor (expense) distributions.

Processing Retroactively Modified Checks

If you have modified the funding sources of a paycheck or group of paychecks, use the Actuals GL Interface process to update the general ledger with the changes. The Actuals GL Interface process processes all regular checks for a given pay calendar ID and then searches for any checks that have been modified retroactively. The system combines corrected entries with entries from the current payroll.

The Actuals GL process will not update the pay calendar when it processes a run made up of only retroactively modified checks. It will update the pay calendar when the process is made up of both new and retroactively modified checks.

Click to jump to top of pageClick to jump to parent topicPage Used to Run the Actuals GL Interface Process

Page Name

Definition Name

Navigation

Usage

GL Interface - Commitment Accounting Actuals

RUNCTL_PAYGL02

Payroll for North America, Payroll Distribution, Provide GL Information, Commitment Accounting Actuals, GL Interface - Commitment Accounting Actuals

Runs the Actuals GL Interface process, which prepares actuals transactions for the PeopleSoft journal generator and budget processor if you are using PeopleSoft Enterprise Commitment Control).

Before using this page, you must have run the Actuals Distribution process.

Click to jump to parent topicReviewing Actuals Distribution After GL Posting

To review actuals distribution after GL posting, use the Review Budget Actuals component (BUDGET_ACTUALS).

Click to jump to top of pageClick to jump to parent topicPage Used to Review Actuals Distribution After GL Posting

Page Name

Definition Name

Navigation

Usage

Budget Actuals

BUDGET_ACTUALS

  • Payroll for North America, Payroll Distribution, Commitment Accounting CAN, Review Budget Actuals

  • Payroll for North America, Payroll Distribution, Commitment Accounting USA, Review Budget Actuals

  • Payroll for North America, Payroll Distribution, Commitment Accounting USF, Review Budget Actuals

Review budget actuals records after posting to general ledger.

Before using this page, you must have run the Actuals GL Interface process.

Click to jump to top of pageClick to jump to parent topicReview Budget Actuals After Posting to General Ledger

Access the Budget Actuals page (Payroll for North America, Payroll Distribution, Commitment Accounting USA, Review Budget Actuals).

Click to jump to parent topicPreparing and Running the Gross Fringe Report

To prepare and run the Gross Fringe report, use the Gross/Fringe Report Column CAN component (HP_GF_COL_DEFN_CAN) or Gross/Fringe Report Column USA component (HP_GF_COL_DEFN_USA), the Load Gross/Fringe Data component (HP_RUNCTL_GF_LOAD), and the Gross/Fringe Report component (HP_RUNCTL_GF_RPT).

This section describes how to:

Click to jump to top of pageClick to jump to parent topicPages Used to Prepare and Run the Gross Fringe Report

Page Name

Definition Name

Navigation

Usage

Gross/Fringe Report Column

HP_COL_DEFN

  • Set Up HRMS, Product Related, Commitment Accounting, Fringe Costs, Gross/Fringe Report Column CAN, Gross/Fringe Report Column

  • Set Up HRMS, Product Related, Commitment Accounting, Fringe Costs, Gross/Fringe Report Column USA, Gross/Fringe Report Column

Setup column definitions to be used by the Gross Fringe report.

Load Gross/Fringe Data

HP_RCTL_GRSFR_LOAD

Payroll for North America, Payroll Distribution, Commitment Accounting USA, Load Gross/Fringe Data

Load the gross fringe data to a temporary table where it can be reported on by the Gross Fringe report.

Gross/Fringe Report

HP_RCTL_GRSFR_RPT

Payroll for North America, Payroll Distribution, GL Interface Reports, Gross and Fringe, Gross/Fringe Report

Run the Fringe and Gross Report (HPCA012). This reports on the Pay Check Distribution records. Run after you've completed the Pay Check distribution process.

You must set up column definitions and run the Fringe Gross Load process before running the report.

Click to jump to top of pageClick to jump to parent topicDefining Columns for the Gross Fringe Report

Access the Gross/Fringe Report Column page (Set Up HRMS, Product Related, Commitment Accounting, Fringe Costs, Gross/Fringe Report Column USA, Gross/Fringe Report Column).

Column ID

Enter the column identifier. Enter either A through no higher than F to represent the user-definable columns from left to right.

Gross or Fringe

Identify if this column setup is for gross earnings or fringe benefits.

Column Heading 1 and Column Heading 2

Enter one or two column headings. Use the second column heading to further describe the column if one does not suffice.

Gross

Earnings Code

If you select E in the Gross or Fringe field, select the earnings codes that the system should total in this column.

Fringe (Benefits)

Plan Type, Benefit Plan, Deduction Code, Ded Class (deduction class), and Sales Tax Type

If you select F in the Gross or Fringe field, select the benefits that the system should total in this column.

If you leave any of the fields blank the system will treat those fields as a wild card. For example, if you only specify Plan Type and Deduction Code, the system will report on the specified Plan Type and Deduction Code, regardless of Benefit Plan, deduction class, and Sales Tax Type. You must enter information in at least one field.

Fringe (Taxes)

State, Locality, and Tax Class and Province and Canadian Tax Class

If you select F in the Gross or Fringe field, select the employer paid taxes that the system should total in this column.

If you leave any of the fields blank the system will treat those fields as a wild card. For example, if you only specify State, the system will report on the specified State, regardless of Locality and Tax class. You must enter information in at least one field.

Note. You can total both taxes and benefits in a single column by entering information in both fringe group boxes.

Click to jump to top of pageClick to jump to parent topicLoading Gross Fringe Data

Access the Load Gross/Fringe Data page (Payroll for North America, Payroll Distribution, Commitment Accounting USA, Load Gross/Fringe Data).

All Companies & Paygroups, Company, and Pay Group

Select All Companies & Paygroups to process all companies and pay groups or leave the check box deselected and enter a company and pay group for processing. If you select only a company, the system will report on all pay groups in the selected company.

From Date and Thru Date

Enter the date range you want to process.

Include Retro Distribution data with distribution date that is outside of the specified date range.

Select to process retroactive distribution information for the date range you entered.

Note. To load retroactive distribution data, the system needs to read all rows on the pay check distribution records and this will slow down performance.

Click to jump to top of pageClick to jump to parent topicRunning the Gross Fringe Report

Access the Gross/Fringe Report page (Payroll for North America, Payroll Distribution, GL Interface Reports, Gross and Fringe, Gross/Fringe Report).

All Companies & Paygroups, Company, and Pay Group

Select to process all companies and pay groups or leave deselected and select a company and pay group for processing. If you select only a company the system will report on all pay groups in the selected company.

All Department, and SetID, Department

Select All Department to process all departments or leave deselected and select specific departments for processing.

All Funding Sources and Combination Code

Select All Funding Sources to process all combination codes or leave deselected and select specific combination codes for processing.

All Projects and Project Grant

Select All Projects to process all projects or leave deselected and select specific projects for processing.

Report Option

Select a report option.

Column Definition Code

The system will summarize the fringe and gross data using the column definition code that you select.

Detail Report and Summary Report

Indicate if the system should produce a detail or a summary report. A detail report lists gross and fringe data by employee and a summary report will print the summary total based on the sort option you select in the Sort Option group box.

Sort Option

Select a sort option.

By Fiscal Year & Acct Period and By Department

Select to sort the report data by fiscal year and account period or by department. Select both options to sort first by fiscal year and accounting period and then by department.

Secondary Sort Sequence

Select a secondary sort sequence to sort after fiscal year and accounting period and department.

Detail Report Sort Sequence

If you opt to create a detail report, you can select an additional sequence level.