Doreming > List of functions > Import function > Import employee salary information

Import employee salary information

img

3 years ago Updated

【For administrators】

Here is the procedure to import salary information of employee with CSV file * 1.

You can set multiple salary information settings at once.

If you want to import employee social insurance · tax information, click here.



  1. Click employee working conditions



  2. Click the ↑ icon,  and click the format download icon on the bottom of the popped up window.




  3. Select a file name, format type, encoding * 2, and click Download.
    Select [Salary, allowance, deduction] as the format type
    By default, encoding is set to SJIS if the language setting is Japanese, and UTF-8 for cases other than Japanese.



  4. We will create data with downloaded format.
    The first to fourth lines of the format are as follows.
    Please enter the data from line 5.
    Save the data with the CSV comma separated for file format.

    line 1    Types of data
    line 2    The number of characters of data and the type of characters that can be registered
    line 3    Data sample
    line 4    Whether the field is mandatory 

    Item
    Employee code (required)Enter employee code (up to 15 half-width alphanumeric characters)
    Effective date(required)Enter the year and month you want to reflect payroll information
    YYYY/MM (Half-width number)
    example)2018/04
    Salary type (required)Enter payroll category (Half-width number)
    1:Monthly wage 2:Fixed hourly wage 3:Time slot wage 5:Daily wage
    Wage
    Enter amount(Half-width number)
    Transportation typeSelect number from below(Half-width number)
    1:None 2:Monthly 3:Daily 4:Lower
    Transportation expenses monthlyEnter monthly transportation expenses(Half-width number) 
    Enter the amount when selecting "2: Monthly" and "4: Lower" in the transportation expense category
    Transportation expenses daily
    Enter daily transportation expenses (Half-width number)
    Enter the amount when selecting "3: Daily" and "4: Lower" in the transportation expense category
    Allowance, Deduction Item 1 codeEnter code for allowance or deduction item(Half-width number)
    Allowance, Deduction Amount 1 code
    Enter amount code of allowance or deduction item(Half-width number)
    Allowance, Deduction Amount 1Enter amount of allowance or deduction(Half-width number)
    Allowance / deduction items can be added to 2-10 below.

    【CSV data sample】


  5. Import the data.
    ↑ icon: click on import


  6. Select file, encoding and click Import

    • Select file
      Please select the CSV file created in step 4.
    • Select encoding
      Please select the same format as downloaded in step 3.

  7. The import result will be displayed.


    If it fails, follow the error message and try again.


Imported salary settings are reflected in the employee working conditions batch edit screen.

It will also be reflected in the employee's working conditions.





* 1 CSV file
CSV is an abbreviation of Comma Separated Value, and is a file of Separated (delimited) Value (value) in Comma.
It is also called a comma-separated file. To handle this file, spreadsheet software such as Microsoft Office Excel and text editor such as memo pad are necessary.

* 2 Encoding
Converting data according to certain rules. SJIS and UTF-8 correspond to the encoding of CSV file.
【SJIS】 It is a character code made for Japanese. It is widely used in files on PC. [UTF - 8] It is a universal character code. You can display almost any PC environment.
Although both are common, there is a possibility of garbled characters depending on your environment. If you get garbled characters, please try it with a different encoding.

Was this article helpful?
Scroll