Skip to main content

How can I link with the payroll software "PCA Payroll DX"?

Please check the following setting method and cooperate.

 

※Note
With PCA salary, you can change the item name and the rules associated with the item (such as changing the premium rate from x1.5 to x0.25), but this article describes the default settings.

 

Functional overview

You can link by outputting attendance information as CSV data from KING OF TIME and importing it into PCA salary. Payroll can be calculated based on the linked information.

 

Advance preparation

To output from KING OF TIME, create an output layout that includes linked items.

 

1. KING OF TIME Login > Frequently used menu “Export / Import” > Monthly data “Create output layout” > Click “New”.

1.png

 

2. Set any name such as the layout name "PCA Payroll DX Linkage".

4.png

 

3. Select the output item in "Display item".

Select the item in the "KING OF TIME" column of the "Linkage item" below and click [Register].

* Items and order to be imported into PCA salary are specified. Please select the same items and order.

* Select the same number of "--blank--".

 

Linkage item

PCA salary Premium rate KING OF TIME

Remark

Employee code      Employee code  
Number of working days required      Fixed (days)  
Working hours required      Contract working hours per day (employee)  
Number of working days      Total clock-in days  
Attendance time      Fixed (hrs)  
Accident absentee days      Absence days  
Illness absentee days   --Blank--  
Number of special holidays   Substitute time-off days  
Time-off clock-in (days) on holiday   Legal time-off clock-in (days)   
Number of days of paid holidays   --Blank--  
Number of days remaining   --Blank--  
Overtime weekdays normal 125% Overtime hours (+ overtime)

Unspecified premium rate

If different, term

Please separate your eyes. (※1

Overtime work weekdays midnight 150% Midnight overtime (+ midnight non-scheduled)

Midnight extra charge

If the rates are different

Separate items

Sai. (※2

Overtime holiday normal 125%

Non-legal time-off overtime

+ Non-statutory holidays

+ Non-statutory holidays Non-scheduled

"Monthly data cas

Tom item function

Use and one term

Add up as eyes

Please give me. (※3

Overtime holiday midnight 150%

Non-Legal time-off late night overtime (hrs)       

+ Non-statutory holiday midnight prescribed

+ Non-statutory holiday Midnight non-scheduled

"Monthly data cas

Tom item function

Use and one term

Add up as eyes

Please give me. (※3

Overtime legal holiday 135% Legal time-off overtime (hrs)
+ Legal holidays
+ Not specified on legal holidays

"Monthly data cas

Tom item function

Use and one term

Add up as eyes

Please give me. (※3

Overtime legal midnight 160% Legal time-off late night overtime (hrs)
+ Legal holiday midnight scheduled time
+ Legal holiday midnight overtime     

"Monthly data cas

Tom item function

Use and one term

Add up as eyes

Please give me. (※3

Late-in/early-out (count)   Late-in/early-out (count)  
Late-in/early-out (hrs)   Late-in/early-out (hrs)  
Number of holidays   Number of leave days taken  
Paid time digestion   Paid holiday acquisition time  
Remaining number of holidays   Number of days remaining  
Remaining paid holidays   Remaining vacation time  
Available holidays   --Blank--  
Overtime work weekdays normally under 45 125% --Blank--  
Overtime Weekdays Normal over 45 125% Extra overtime hours  
Overtime Weekdays Normal over 60  150% Bonus wage overtime 2 (hrs)  
Overtime weekdays regular holidays 125% --Blank--  
Overtime work weekdays under 45 midnight  150% --Blank--  
Overtime Weekdays over 45 midnight  150% Extra midnight overtime hours  
Overtime Weekdays over 60 midnight 175% Bonus wage late night overtime 2 (hrs)  
Overtime Weekday midnight holiday 150% --Blank--  
Overtime holidays usually under 45   --Blank--  
Overtime holidays over 45 125% --Blank--  
Overtime holidays usually over 60 150% --Blank--  
Overtime holidays Regular holidays 125% --Blank--  
Overtime holiday under midnight 45   --Blank--  
Overtime holiday over 45 midnight     150% --Blank--  
Overtime holiday over 60 midnight     175% --Blank--  
Overtime holiday Midnight holiday    150% --Blank--  
Attendance free time 1-10      --Blank--  
Attendance free number 1-10      --Blank--  
Number of times 1 to 30   --Blank--  

 

※1
If the "non-scheduled" premium rate is 125%, add up the "overtime hours", and if the premium rate is 100%, add up the "prescribed hours" and output. When calculating salary separately from "overtime hours" and "prescribed hours", output in the order that matches the import items on the PCA salary side, such as "Attendance free time 1 to 10".


※2
If the premium rate for "Midnight overtime" is 150%, add it to "Midnight overtime" and output. When calculating salary separately from "Midnight overtime hours", output in the order that matches the import items on the PCA salary side, such as "Attendance free time 1 to 10".

 

※1~※3
Please refer to here for the total method.

 

Cooperation method

1. KING OF TIME Login > Frequently used menu “Export / Import” > Click [Monthly Data Output].

3.png

 

2. Select the output target date, output layout, and output target employee, and click [Data Output] on the [Data Output]> Confirmation screen.

On the monthly data output confirmation screen, select ": Colon" for "Time delimiter" and click [Data output].

For the output layout, select the layout created in "Preparation".

 

Notice
If you change the time delimiter to ": (colon)" and open the output CSV file in Excel, the time display format may change depending on the Excel specifications. When checking / editing the data output with a colon, it is recommended to open the output CSV file with "Notepad" and edit it. The format of the time item of PCA Payroll DX is "99:59". When editing with Excel, if "[h]: mm: ss" is displayed up to the number of seconds due to cell formatting, an error will occur if you import it as it is. Be sure to delete the seconds part.

 

img001.png

 

3. Click PCA Payroll DX> Main Category "Anytime"> [Accept General Purpose Data].

7.png

 

4. Select the CSV data to be imported and the payroll month.

(1) Select "Distributed data".

(2) Select "Salary attendance data".

(3) Select the CSV data output from KING OF TIME.

(4) Select the payment month corresponding to the payment month.

(5) After selecting the above four, click [Execute].

img002.png

 

5. Two pop-up confirmation screens will be displayed. Click [Yes].

9.png

 

6. The "Transfer General Data" screen will be displayed. Click [Transfer].

10.png

 

7. Click Close when the transfer is complete.

 
Return to top of page
Was this article helpful?
0 out of 1 found this helpful