Click on sample file

This export pulls Comp Accumulator data that has been tagged as part of a payroll batch. A record will only be reported on once. After it has been processed through the payroll batch process it will be marked as run and will not be pulled on future batches. Previously run batch reports can be viewed on the Compensation Worksheet Payroll Reporting screen found under the Compensation Processing menu.

This export is available at the company and system levels but was designed to be used as part of the Payroll Reporting Batch Process at the company level.

This export has one parameter – PayrollSystemReportBatchItemID. However, it is auto-populated by the payroll reporting process. You will not need to manually enter in this parameter.

Co Code

Batch Id

File #

Batch Description

Earnings 3 Code

Earnings 3 Amount

Adjust Ded Code

Adjust Ded Amount

Co Code:

This field is populated with the value located in the “Name” field found on the General tab of the Payroll System screen.

Batch Id:

This field is populated using two pieces of data. The first piece is determined by taking the Pay Period End Date in the format MMDDYY. The second piece is determined by taking the first letter of each word in the Description field found on the General tab of the Payroll System screen and concatenating them together.

For example, if the End Date is 12/31/2010 and the Description field contains “My Payroll System” the resulting text would be “123110MPS”.

File #:

This is the “From Payroll ID” field located on the primary Assignment screen.

Batch Description:

This is the “Description” field found on the General tab of the Payroll System screen.

Earning 3 Code:

This is the Primary Wage Code associated with the account the entry has been created under.

Earning 3 Amount:

This is the amount associated with the preceding Earning 3 Code.

Adjust Ded Code:

This is the Primary Wage Code associated with the account the entry has been created under.

Adjust Ded Amount:

This is the amount associated with the preceding Adjust Ded Code.

Important Notes regarding Earning 3 Code, Earning 3 Amount, Adjust Ded Code, and Adjust Ded Amount:

First, these items are always paired. If there are two “Earning 3 Code” entries, there will also be two “Earning 3 Amount” entries. These entries alternate. So the columns would be “Earning 3 Code”, “Earning 3 Amount”, “Earning 3 Code”, “Earning 3 Amount”. The same pattern will hold true for the “Adjust Ded” columns.

Earning and Adjustment columns also have a flexible count. Each category (Earning or Adjustment) will look at the maximum number of parings and that will be the number of columns that the export will use for the present running. For the next export the number of columns could change. For example, in one export there could end up being 4 Earning parings (a total of 8 columns) and only 2 Adjustment pairings (a total of 4 columns). The next export could contain only 3 Earning pairings (a total of 6 columns) but 5 Adjustment pairings (a total of 10 columns).

An Earning or Deduction is determined based upon the Wage Type on the Pay Register screen. If the Wage Type has a value of Earning, the Wage Code and Primary Payroll Amount will be reflected as an Earning 3 Code and Earning 3 Amount. If the Wage Type has a value of Deduction, the Wage Code and Primary Payroll Amount will be reflected as an Adjust Ded Code and Adjust Ded Amount. If a Wage Type corresponding to an account is not designated an Earning or Deduction, the export will fail and an error message is displayed.

Since earning and deduction amounts are commonly fed to payroll systems as positive amounts, and since deductions are typically stored in the Comp Accumulator as negatives, the export flips the sign to a positive for deductions.