Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

NOTE: if using a .CSV open with Notepad as the leading zero will disappear if the column format is not Text type           type   Step 1:

Create the

...

Import File:

On the desktop of your computer, right click the screen > new > Text document. it should make a new .TXT file.

...

Example: (.TXT) file might change. It is depends on software provider

Image Removed

The file has the following format:
Image Added

Column 1

...

Employee id
Column 2

...

Pay category
Column 3

...

Numbers of Hours
Column 4

...

Amount

If the value is not there leave

...

Example: line 1 importing units; line 2 importing amounts

First line:

  • Employee Code (1003)
  • Payroll Category (107) This is hourly Type
  • Hours (55) Number of Hours

Second line:

  • Employee Code(1003)
  • Payroll Category (117) This is Regular Type
  • blank ,,
  • Amount (700)

     

...

them blank.

Create a new import interface:

Steps:

  1. Go to Configuration > Interfaces > Paycard import interfaces

...

  1. .
  2. Click on (+) sign to create a new interface.
  3. On Details tab add Code

...

  1. and Name of the new layout
    File Type= Comma delimited file
    Additional settings: only check The file provides payroll category numbers
    Image Modified
  2. Click on “Filed mapping” tab.
  3. Select the Source field from the drop down list and enter the source column from the file.
  4. Click “Add” button to add new line.
  5. Click on the Save button.
    Image Modified

...

Batch the payroll using new interface:

Steps:

  1. Go to Payroll > Process Paycards > Batch Payroll

...

  1. .
  2. Make the selection > click Next.
    Image Modified
  3. Select import interface name and browse for the file to be imported.
  4. Click next (at the bottom)
    Image Modified
  5. Click Run Payroll
    Image Modified
    A successful import will produce the following screen
    Image Modified
  6. To check the imported data: Go to Payroll > Process Paycards > Edit Paycards

...

  1. Double click on your employee.
    Image Modified

...

  1. If the entry is incorrect review the import file.  You can Overwrite on the Batch Paycard wizard as many time as you want.
    Image Modified