This article describes Import Payroll Entries functionality, which allows to import csv files into payroll module for accurate distribution of variable payments.

Description

Import Payroll Entries tool is efficiently used when there is need to make a batch import of variable payments for multiple crew in the month.

File format

This import utility accepts files of a strict format and column order. The file has be to a .csv type - comma, semicolon or tab used as column separator.

Columns for import:

NUMORGID is vessel org. ID that you can check in Organization Structure.

PERIOD must be entered in format YYYYMM.

TEXT normally contains comments.

ENTRYFIELD4-6 are fields on payroll entries used to store various info.

ACCOUNTDIM3-9 are entry accounting (cost) dimensions. NB: the system normally is setup to set correct info in accounting dimensions during calculation for the variable entries as well, therefore it is optional for import.

Samples

Minimum required columns for import are 6, they all are marked as mandatory.

COMMAND, PERIOD, NUMORGID, ENTRYCODE, PIN, AMOUNT

Some optional columns can be included to the import file a well in the following order.

COMMAND, PERIOD, NUMORGID, ENTRYCODE, PIN, RANK, QUANTITY, RATE, AMOUNT, TEXT, etc. 

Import process

You can find the Import Payroll Entries utility in Tools > Import list

In the next window:

1. Select file
2. Select correct column separator used in your file
3. Use "Skip entries with existing correspondent entry" option if your import file contains entries from previous import - the system will skip them to avoid duplicates.
4. Archive the import log file.

The system will show you a message for successful or failed import and log file listing how many entries were created (in case of success) or reason for import failure.