Description

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

File format

The file for import has to be a .csv type - comma, semicolon, or tab used as a column separator.

Columns for import:

Fields explanation

1. COMMAND is mandatory and required in order for the system to import the record in question.
   The following commands may be found:

   • COMMENT  - This record will not be imported. It most likely consists not of an import info, but various other data.

   • <blank> In the event the field is blank, then this is a record that will be imported.

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

3. VESSELNO is vessel org. code that you can check in Organization Structure.

4. PERIOD must be entered in format YYYYMM.

5. ENTRYCODE is the Entry Code number

6. QUANTITY is number of days/hours for entry record

7. RATE is daily/hourly pay rate

8. TEXT normally contains comments.

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

10. 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 of import files

1. The file includes only mandatory columns.
   All COMMAND rows are blank, which means data will be imported starting with the 2nd row.
   
   

   Open

   

    

2. The file includes optional columns.
   All COMMAND rows are blank, which means data will be imported starting in the 2nd row.
   
   

3. The file includes optional columns.
   Some COMMAND rows are set with COMMENT - such rows contain additional data and will not be imported, in the case of the below sample, the import will start with the 9th row.
   
   

   Open

   

Import process

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

In the next window:

1. Select file

2. Select the correct column separator used in your file.

3. Use the "Skip entries with the existing correspondent entry" option if your import file contains entries from the previous import - the system will skip them to avoid duplicates.

4. Archive the import log file.
   
   

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