The “Standard Text Export” method exports the wage summary for a period to a standard text file. You may want to use this export method to provide payroll information to your payroll service or payroll software. Check with your payroll service or payroll software to determine if this file can be imported. The file specifications are detailed below.
To use this export method:
· Determine if your payroll service or software can import this file format (see File Specification below).
· In Payroll Setup (“Main Menu | Setup | Payroll”, Import/Export Tab)
o Select “Standard Text Export” as your “Import/Export Folder”.
o Specify a valid “Import/Export Folder”. Note that this folder must be visible from the workstation that exports the payroll information.
· Export your periods after posting
o The file will be created in the “Import/Export Folder” as specified in payroll setup. The “Import/Export Folder” must be visible from the workstation that exports the payroll information.
o
The file will be named
<yyyymmdd>_<periodtype>_<periodid>.txt.
<yyyymmdd> the ending date of the
period being exported.
<periodtype> a single character
(W,B,M, or S) for weekly, biweekly, monthly, semimonthly.
<periodid> the period Id number
for the period within SuccessWare21.
For example, the weekly period #25
ending September 12, 2004 would create the file named: “20040912_W_25.txt”.
NOTE: Payroll Period Reconciliation information can be imported. Review the Payroll: Reconciliation Import documentation to determine if your payroll service or software can provide you with the necessary text file(s).
The Standard Export Method creates a comma delimited text file. The first line/record of the file contains the fieldnames. The following lines/records contain the wage summary detail.
The fields exported are described below:
|
Fieldname |
Data Type |
Max Length |
Notes |
|
SSN |
Character |
11 |
The
employee’s social security number. |
|
PayItemPremium |
Character |
18 |
A code that
describes the hours/units/amounts being processed. This is the SuccessWare21 PayItem and
PremiumCode separated by a hyphen.
These fields are also provided individually. |
|
Hours |
Numeric |
12 |
Used for
hourly items only; blank for salary, commissions and piece rate items. |
|
Amount |
Numeric |
12 |
Total amount
earned for the item. For hourly items,
this should equal Hours times Rate. |
|
Rate |
Numeric |
12 |
Used for
hourly items only; blank for salary, commissions and piece rate items. This is actual rate the employee is paid
for this wage and includes any premium rate inflation. The normal rate with out premium inflation
is also provided. |
|
Name |
Character |
50 |
Last, First,
M. |
|
EmployeeCode |
Character |
6 |
A 6
character code that uniquely identifies the employee. |
|
ItemDate |
Date |
10 |
mm/dd/yyyy;
Date the wage is expensed. |
|
ItemPayType |
Character |
10 |
Code
indicating type of wage. Possible
values: Hourly, Salary, or Piecerate, or Commission. |
|
PayItem |
Character |
15 |
The
SuccessWare21 PayItem. Relates
specific type of wage for an employee to an expense type, G/L account and
sub-account within SuccessWare21. |
|
NormalRate |
Numeric |
12 |
Used for
hourly items only; blank for salary, commissions and piece rate items. This is normal rate the employee would be
paid for this wage and does not include any applicable premium rate
inflation. |
|
PremiumCode |
Character |
2 |
Code
indicating a premium was applied (e.g., OT for Overtime, DT for double time,
or HP for Holiday Pay) |
|
Department |
Character |
2 |
A two
character code uniquely identifying a department within SuccessWare21. |
|
ExpenseType |
Character |
6 |
Relates
directly to a G/L Account and sub-account within SuccessWare21. |
|
GL_Account |
Character |
4 |
The G/L
Account the wage will be posted to within SuccessWare21. |
|
SubAccount |
Character |
10 |
The G/L
Sub-Account the wage will be posted to within SuccessWare21. |
|
PeriodID |
Numeric |
6 |
99999 (whole
number, no fractions, uniquely identifies each payroll period in
SuccessWare21.) |
|
PeriodEndDate
|
Date |
10 |
mm/dd/yyyy;
The date on which the payroll period ends. |
Following is a sample export file. This example shows wages paid to five employees for a single weekly pay period #39 ending on September 28, 2004; It includes a combination of salary, piece rate, hourly, and vacation time.
SSN,PayItemPremium,Hours,Amount,Rate,Name,EmployeeCode,ItemDate,ItemPayType,PayItem,NormalRate,PremiumCode,PremiumRateIncrease,Department,ExpenseType,GL_Account,SubAccount,PeriodID,PeriodEndDate
111-11-1111,"SALARY
TECH",,7.08000,,"Doe,
John",MARBRA,09/22/2003,Salary,"SALARY TECH",,,,10,LABOR,4002,,39,9/28/2003
111-11-1111,"SALARY
TECH",,42.55000,,"Doe,
John",MARBRA,09/22/2003,Salary,"SALARY
TECH",,,,20,LABOR,4002,,39,9/28/2003
111-11-1111,"SALARY
TECH",,35.83000,,"Doe,
John",MARBRA,09/22/2003,Salary,"SALARY TECH",,,,21,LABOR,4002,,39,9/28/2003
111-11-1111,"SALARY
TECH",,14.17000,,"Doe,
John",MARBRA,09/22/2003,Salary,"SALARY
TECH",,,,22,LABOR,4002,,39,9/28/2003
111-11-1111,"SALARY
TECH",,35.83000,,"Doe,
John",MARBRA,09/22/2003,Salary,"SALARY
TECH",,,,70,LABOR,4002,,39,9/28/2003
111-11-1111,"SALARY
TECH",,7.08000,,"Doe,
John",MARBRA,09/22/2003,Salary,"SALARY
TECH",,,,71,LABOR,4002,,39,9/28/2003
111-11-1111,"SALARY
TECH",,7.08000,,"Doe,
John",MARBRA,09/23/2003,Salary,"SALARY
TECH",,,,10,LABOR,4002,,39,9/28/2003
111-11-1111,"SALARY TECH",,42.92000,,"Doe,
John",MARBRA,09/23/2003,Salary,"SALARY
TECH",,,,20,LABOR,4002,,39,9/28/2003
111-11-1111,"SALARY
TECH",,35.83000,,"Doe,
John",MARBRA,09/23/2003,Salary,"SALARY
TECH",,,,21,LABOR,4002,,39,9/28/2003
111-11-1111,"SALARY
TECH",,14.17000,,"Doe,
John",MARBRA,09/23/2003,Salary,"SALARY
TECH",,,,22,LABOR,4002,,39,9/28/2003
111-11-1111,"SALARY
TECH",,35.83000,,"Doe,
John",MARBRA,09/23/2003,Salary,"SALARY
TECH",,,,70,LABOR,4002,,39,9/28/2003
111-11-1111,"SALARY
TECH",,7.08000,,"Doe, John",MARBRA,09/23/2003,Salary,"SALARY
TECH",,,,71,LABOR,4002,,39,9/28/2003
111-11-1111,"SALARY
TECH",,7.08000,,"Doe,
John",MARBRA,09/24/2003,Salary,"SALARY
TECH",,,,10,LABOR,4002,,39,9/28/2003
111-11-1111,"SALARY
TECH",,42.92000,,"Doe, John",MARBRA,09/24/2003,Salary,"SALARY
TECH",,,,20,LABOR,4002,,39,9/28/2003
111-11-1111,"SALARY
TECH",,35.83000,,"Doe,
John",MARBRA,09/24/2003,Salary,"SALARY
TECH",,,,21,LABOR,4002,,39,9/28/2003
111-11-1111,"SALARY
TECH",,14.17000,,"Doe,
John",MARBRA,09/24/2003,Salary,"SALARY TECH",,,,22,LABOR,4002,,39,9/28/2003
111-11-1111,"SALARY
TECH",,35.83000,,"Doe,
John",MARBRA,09/24/2003,Salary,"SALARY
TECH",,,,70,LABOR,4002,,39,9/28/2003
111-11-1111,"SALARY
TECH",,7.08000,,"Doe,
John",MARBRA,09/24/2003,Salary,"SALARY
TECH",,,,71,LABOR,4002,,39,9/28/2003
111-11-1111,"SALARY
TECH",,7.08000,,"Doe,
John",MARBRA,09/25/2003,Salary,"SALARY
TECH",,,,10,LABOR,4002,,39,9/28/2003
111-11-1111,"SALARY
TECH",,42.92000,,"Doe,
John",MARBRA,09/25/2003,Salary,"SALARY
TECH",,,,20,LABOR,4002,,39,9/28/2003
111-11-1111,"SALARY
TECH",,35.83000,,"Doe,
John",MARBRA,09/25/2003,Salary,"SALARY
TECH",,,,21,LABOR,4002,,39,9/28/2003
111-11-1111,"SALARY
TECH",,14.17000,,"Doe,
John",MARBRA,09/25/2003,Salary,"SALARY
TECH",,,,22,LABOR,4002,,39,9/28/2003
111-11-1111,"SALARY
TECH",,35.83000,,"Doe,
John",MARBRA,09/25/2003,Salary,"SALARY
TECH",,,,70,LABOR,4002,,39,9/28/2003
111-11-1111,"SALARY
TECH",,7.08000,,"Doe,
John",MARBRA,09/25/2003,Salary,"SALARY
TECH",,,,71,LABOR,4002,,39,9/28/2003
111-11-1111,"SALARY
TECH",,7.08000,,"Doe, John",MARBRA,09/26/2003,Salary,"SALARY
TECH",,,,10,LABOR,4002,,39,9/28/2003
111-11-1111,"SALARY
TECH",,42.92000,,"Doe,
John",MARBRA,09/26/2003,Salary,"SALARY
TECH",,,,20,LABOR,4002,,39,9/28/2003
111-11-1111,"SALARY
TECH",,35.83000,,"Doe, John",MARBRA,09/26/2003,Salary,"SALARY
TECH",,,,21,LABOR,4002,,39,9/28/2003
111-11-1111,"SALARY
TECH",,14.17000,,"Doe,
John",MARBRA,09/26/2003,Salary,"SALARY
TECH",,,,22,LABOR,4002,,39,9/28/2003
111-11-1111,"SALARY
TECH",,35.83000,,"Doe,
John",MARBRA,09/26/2003,Salary,"SALARY TECH",,,,70,LABOR,4002,,39,9/28/2003
111-11-1111,"SALARY
TECH",,7.08000,,"Doe,
John",MARBRA,09/26/2003,Salary,"SALARY
TECH",,,,71,LABOR,4002,,39,9/28/2003
111-11-1111,"SALARY
TECH",,7.08000,,"Doe,
John",MARBRA,09/27/2003,Salary,"SALARY TECH",,,,10,LABOR,4002,,39,9/28/2003
111-11-1111,"SALARY
TECH",,42.92000,,"Doe,
John",MARBRA,09/27/2003,Salary,"SALARY
TECH",,,,20,LABOR,4002,,39,9/28/2003
111-11-1111,"SALARY
TECH",,35.83000,,"Doe,
John",MARBRA,09/27/2003,Salary,"SALARY
TECH",,,,21,LABOR,4002,,39,9/28/2003
111-11-1111,"SALARY
TECH",,14.17000,,"Doe,
John",MARBRA,09/27/2003,Salary,"SALARY
TECH",,,,22,LABOR,4002,,39,9/28/2003
111-11-1111,"SALARY
TECH",,35.83000,,"Doe,
John",MARBRA,09/27/2003,Salary,"SALARY
TECH",,,,70,LABOR,4002,,39,9/28/2003
111-11-1111,"SALARY
TECH",,7.08000,,"Doe,
John",MARBRA,09/27/2003,Salary,"SALARY
TECH",,,,71,LABOR,4002,,39,9/28/2003
111-11-1111,"SALARY
TECH",,7.08000,,"Doe,
John",MARBRA,09/28/2003,Salary,"SALARY
TECH",,,,10,LABOR,4002,,39,9/28/2003
111-11-1111,"SALARY
TECH",,42.92000,,"Doe,
John",MARBRA,09/28/2003,Salary,"SALARY
TECH",,,,20,LABOR,4002,,39,9/28/2003
111-11-1111,"SALARY
TECH",,35.83000,,"Doe,
John",MARBRA,09/28/2003,Salary,"SALARY
TECH",,,,21,LABOR,4002,,39,9/28/2003
111-11-1111,"SALARY
TECH",,14.17000,,"Doe, John",MARBRA,09/28/2003,Salary,"SALARY
TECH",,,,22,LABOR,4002,,39,9/28/2003
111-11-1111,"SALARY
TECH",,35.83000,,"Doe,
John",MARBRA,09/28/2003,Salary,"SALARY
TECH",,,,70,LABOR,4002,,39,9/28/2003
111-11-1111,"SALARY
TECH",,7.08000,,"Doe, John",MARBRA,09/28/2003,Salary,"SALARY
TECH",,,,71,LABOR,4002,,39,9/28/2003
333-33-3333,SALARY,,71.50000,,"Jones,
Joe W",MIKRAM,09/22/2003,Salary,SALARY,,,,00,ADMWAG,6060,,39,9/28/2003
333-33-3333,SALARY,,17.00000,,"Jones,
Joe W",MIKRAM,09/22/2003,Salary,SALARY,,,,20,ADMWAG,6060,,39,9/28/2003
333-33-3333,SALARY,,17.00000,,"Jones,
Joe W",MIKRAM,09/22/2003,Salary,SALARY,,,,21,ADMWAG,6060,,39,9/28/2003
333-33-3333,SALARY,,68.50000,,"Jones,
Joe W",MIKRAM,09/22/2003,Salary,SALARY,,,,70,ADMWAG,6060,,39,9/28/2003
333-33-3333,SALARY,,68.50000,,"Jones,
Joe W",MIKRAM,09/23/2003,Salary,SALARY,,,,00,ADMWAG,6060,,39,9/28/2003
333-33-3333,SALARY,,17.00000,,"Jones,
Joe W",MIKRAM,09/23/2003,Salary,SALARY,,,,20,ADMWAG,6060,,39,9/28/2003
333-33-3333,SALARY,,17.00000,,"Jones,
Joe W",MIKRAM,09/23/2003,Salary,SALARY,,,,21,ADMWAG,6060,,39,9/28/2003
333-33-3333,SALARY,,68.50000,,"Jones,
Joe W",MIKRAM,09/23/2003,Salary,SALARY,,,,70,ADMWAG,6060,,39,9/28/2003
333-33-3333,SALARY,,68.50000,,"Jones,
Joe W",MIKRAM,09/24/2003,Salary,SALARY,,,,00,ADMWAG,6060,,39,9/28/2003
333-33-3333,SALARY,,17.00000,,"Jones,
Joe W",MIKRAM,09/24/2003,Salary,SALARY,,,,20,ADMWAG,6060,,39,9/28/2003
333-33-3333,SALARY,,17.00000,,"Jones,
Joe W",MIKRAM,09/24/2003,Salary,SALARY,,,,21,ADMWAG,6060,,39,9/28/2003
333-33-3333,SALARY,,68.50000,,"Jones,
Joe W",MIKRAM,09/24/2003,Salary,SALARY,,,,70,ADMWAG,6060,,39,9/28/2003
333-33-3333,SALARY,,68.50000,,"Jones,
Joe W",MIKRAM,09/25/2003,Salary,SALARY,,,,00,ADMWAG,6060,,39,9/28/2003
333-33-3333,SALARY,,17.00000,,"Jones,
Joe W",MIKRAM,09/25/2003,Salary,SALARY,,,,20,ADMWAG,6060,,39,9/28/2003
333-33-3333,SALARY,,17.00000,,"Jones,
Joe W",MIKRAM,09/25/2003,Salary,SALARY,,,,21,ADMWAG,6060,,39,9/28/2003
333-33-3333,SALARY,,68.50000,,"Jones,
Joe W",MIKRAM,09/25/2003,Salary,SALARY,,,,70,ADMWAG,6060,,39,9/28/2003
333-33-3333,SALARY,,68.50000,,"Jones,
Joe W",MIKRAM,09/26/2003,Salary,SALARY,,,,00,ADMWAG,6060,,39,9/28/2003
333-33-3333,SALARY,,17.00000,,"Jones,
Joe W",MIKRAM,09/26/2003,Salary,SALARY,,,,20,ADMWAG,6060,,39,9/28/2003
333-33-3333,SALARY,,17.00000,,"Jones,
Joe W",MIKRAM,09/26/2003,Salary,SALARY,,,,21,ADMWAG,6060,,39,9/28/2003
333-33-3333,SALARY,,68.50000,,"Jones,
Joe W",MIKRAM,09/26/2003,Salary,SALARY,,,,70,ADMWAG,6060,,39,9/28/2003
333-33-3333,SALARY,,68.50000,,"Jones,
Joe W",MIKRAM,09/27/2003,Salary,SALARY,,,,00,ADMWAG,6060,,39,9/28/2003
333-33-3333,SALARY,,17.00000,,"Jones,
Joe W",MIKRAM,09/27/2003,Salary,SALARY,,,,20,ADMWAG,6060,,39,9/28/2003
333-33-3333,SALARY,,17.00000,,"Jones,
Joe W",MIKRAM,09/27/2003,Salary,SALARY,,,,21,ADMWAG,6060,,39,9/28/2003
333-33-3333,SALARY,,68.50000,,"Jones,
Joe W",MIKRAM,09/27/2003,Salary,SALARY,,,,70,ADMWAG,6060,,39,9/28/2003
333-33-3333,SALARY,,68.50000,,"Jones,
Joe W",MIKRAM,09/28/2003,Salary,SALARY,,,,00,ADMWAG,6060,,39,9/28/2003
333-33-3333,SALARY,,17.00000,,"Jones,
Joe W",MIKRAM,09/28/2003,Salary,SALARY,,,,20,ADMWAG,6060,,39,9/28/2003
333-33-3333,SALARY,,17.00000,,"Jones,
Joe W",MIKRAM,09/28/2003,Salary,SALARY,,,,21,ADMWAG,6060,,39,9/28/2003
333-33-3333,SALARY,,68.50000,,"Jones,
Joe W",MIKRAM,09/28/2003,Salary,SALARY,,,,70,ADMWAG,6060,,39,9/28/2003
555-55-5555,PIECERATE,,390.00000,,"George,
Washington",NICSMI,09/26/2003,Piecerate,PIECERATE,,,,70,LABOR,4002,,39,9/28/2003
222-22-2222,HOURLY,5.00000,100.00000,20.00000,"Smith,
Mary L",STELEC,09/22/2003,Hourly,HOURLY,20.00000,,,22,LABOR,4002,,39,9/28/2003
222-22-2222,HOURLY,5.50000,110.00000,20.00000,"Smith,
Mary
L",STELEC,09/22/2003,Hourly,HOURLY,20.00000,,,70,LABOR,4002,,39,9/28/2003
222-22-2222,HOURLY,3.50000,70.00000,20.00000,"Smith,
Mary L",STELEC,09/23/2003,Hourly,HOURLY,20.00000,,,20,LABOR,4002,,39,9/28/2003
222-22-2222,HOURLY,6.25000,125.00000,20.00000,"Smith,
Mary
L",STELEC,09/23/2003,Hourly,HOURLY,20.00000,,,21,LABOR,4002,,39,9/28/2003
222-22-2222,HOURLY,1.00000,20.00000,20.00000,"Smith,
Mary
L",STELEC,09/24/2003,Hourly,HOURLY,20.00000,,,20,LABOR,4002,,39,9/28/2003
222-22-2222,HOURLY,1.50000,30.00000,20.00000,"Smith,
Mary
L",STELEC,09/24/2003,Hourly,HOURLY,20.00000,,,22,LABOR,4002,,39,9/28/2003
222-22-2222,HOURLY,4.25000,85.00000,20.00000,"Smith,
Mary
L",STELEC,09/24/2003,Hourly,HOURLY,20.00000,,,70,LABOR,4002,,39,9/28/2003
222-22-2222,"NJ
HOURLY",1.00000,20.00000,20.00000,"Smith, Mary
L",STELEC,09/24/2003,Hourly,"NJ
HOURLY",20.00000,,,70,LABOR,4002,,39,9/28/2003
222-22-2222,HOURLY,6.75000,135.00000,20.00000,"Smith,
Mary
L",STELEC,09/25/2003,Hourly,HOURLY,20.00000,,,70,LABOR,4002,,39,9/28/2003
222-22-2222,"NJ
HOURLY",0.50000,10.00000,20.00000,"Smith, Mary
L",STELEC,09/25/2003,Hourly,"NJ
HOURLY",20.00000,,,70,LABOR,4002,,39,9/28/2003
222-22-2222,HOURLY,4.75000,95.00000,20.00000,"Smith,
Mary
L",STELEC,09/26/2003,Hourly,HOURLY,20.00000,,,70,LABOR,4002,,39,9/28/2003
222-22-2222,HOURLY-OT,5.25000,157.50000,30.00000,"Smith,
Mary
L",STELEC,09/26/2003,Hourly,HOURLY,20.00000,OT,10.00000,70,LABOR,4002,,39,9/28/2003
444-44-4444,"NJ
HOURLY",2.00000,28.00000,14.00000,"Jones, Tommy
L",TOMSCO,09/26/2003,Hourly,"NJ
HOURLY",14.00000,,,70,LABOR,4002,,39,9/28/2003
444-44-4444,PIECERATE,,525.00000,,"Jones,
Tommy L",TOMSCO,09/26/2003,Piecerate,PIECERATE,,,,70,LABOR,4002,,39,9/28/2003
444-44-4444,VACATION,20.00000,280.00000,14.00000,"Jones,
Tommy
L",TOMSCO,09/26/2003,Hourly,VACATION,14.00000,,,70,VACHOL,6120,,39,9/28/2003