SmartFusion Modules > Payroll > Process > Import Special Compensation 

Recent Changes: 
6.174 - Added 'Employer Med W/H' to the end of the import
6.173 - Added 'Employer FICA Wages' to the end of the import layout  

6.66 - Initial Page

Introduction

This process allows the user to import Special Compensation data from a predefined Excel document.

File Format
Excel .xls or .xlsx formatted file

Col Column Name Description
A EMP NAME Employee name
B EMPL ID Employee identifier
C FICA Wages Total employee taxable wages for FICA
D MED Wages Total employee taxable wages for Medicare
E Taxable Wages Total employee taxable wages
F State Wages Total employee taxable wages for state
G blank blank
H FICA W/H Amount of FICA taxes withheld
I Med W/H Amount of Medicare taxes withheld for employee
J TOTAL FICA/Med Total FICA and Medicare taxes withheld
K Employer FICA Wages Total employer taxable wages for FICA
L Employer Med W/H Amount of Medicare taxes withheld for the employer

Additional Notes

Only employees with specified employee ids will be imported.

No attempt is made to verify whether a row has already been imported. Care should be taken when importing special compensation, otherwise duplicates may result. When correcting for employee ids, a separate file should be used to import any employees whose special compensations were not successfully imported previously.

At the end of an import, a report displays which rows were not successfully imported. A line number, as well as an error with description, is provided.