Payroll instruction is a key component. It involves every record of all employees. This section will explain everything you need to know about payroll instructions from creating new payroll instructions to exporting payroll instructions for checking, as well as how to compare cash flow to a selected month.

1. What are Payroll Instructions?

Payroll instructions inform payroll providers of all the items that should be paid to the workers including their reoccurring items (such as salary or allowances) and one time additions (for example bonuses or expenses reimbursements). Please ensure to update the payroll instructions before the cutoff day to avoid any late processing fees.

2. Access to Payroll Instructions

1. Go to the sidebar and select Payroll
2. Click Payroll Instructions
3. The payroll instructions table will show up, defaulted to the current month.

There are 3 main tabs on the payroll instruction page:

• Totals Tab
• Variance Tab
• All Instructions Tab

3. Totals Tab

3.1. What is Totals Tab?

Totals tab shows a summary of each worker with their payments for the relevant month. The user can edit all instructions on this page.

• Each row shows the name of workers in this payrun.
• Each column shows the basic information about workers, payrun country, currency and paycode. The flag near the paycode shows the country that is applicable to that paycode.

Payroll instruction can set frequency as once, monthly, and specific months. Former payroll instruction can be ended to start the new payroll instruction in the specific month. If there is a change in any record from the previous month, it will be highlighted.

3.2. Create New Payroll Instructions

There are 2 ways to create new instructions: a. Add New Instructions Directly and b. Upload Instructions

a. Add New Instructions Directly

1. Click on the cell of the worker and the paycode that you want to add (e.g. 000 0007 - Sample Company, Allowance)
2. Set amount (e.g. ¥20,000)
3. Set frequency (e.g. Once)
4. Set first payment month and last payment month (e.g. first payment month: 7/2023, last payment month: 7/2023)
5. Set effective start date and effective end date (e.g. effective start date: 01/07/2023, effective end date: 31/07/2023)
6. Supporting documents may also be uploaded (optional). It is mandatory for expense reimbursement paycode.

7. Click Submit
8. The new instruction will show up in the table

b. Upload Instructions

It is possible to create multiple instructions in Excel and bulk upload

1. Click … near the Download Instructions
2. Download Bulk Upload Template. The template can be downloaded here

Payroll Instructions Upload Template.xlsx12.8KB

or you can download the template from the browser

3. Fill out the Excel file


Here is an example file for you to test uploading

Payroll Instructions Upload Template - Sample Company.xlsx11.7KB

4. Click ... then click Bulk Upload Payroll Instructions

5. Choose your file and upload
• For proper worker uploading onto the software, the Excel sheet must include either Client Worker ID or the client name and the tenant's worker ID.
6. The new instructions will show up in the table

3.3. Filter Payroll Instructions

You can choose desirable criteria to filter lists of payroll instructions that you want to display in the table.

1. Click Filters
2. Select criteria that you want to filter (e.g. Payrun Country)
3. Set your criteria (e.g. Japan)

4. The filtered values regarding your criteria will show up in the table

The filter can be set and edited from the bar above the table as well.

3.4. Sort Payroll Instructions

The table can be sorted alphabetically and numerically in descending and ascending order.

• If data in the selected column is alphabetic data, it will be sorted alphabetically
• If data in the selected column is numerical data, it will be sorted numerically
• If data in the selected column is in date format, it will be sorted from newest or oldest

The table can be sorted by one column at a time.

1. To sort based on that column, click on the head of a column until you get the desired sort

#️⃣

Symbols

Not Sorted

Ascending Order

Descending Order

2. The sorted table will show up

3.5. Edit Payroll Instruction

1. Click on the field of the desired employee and paycode that want to edit (e.g. Employee: 000 0007 - Sample Company, Paycode: Allowance)
2. Click Edit and then Edit Instruction
3. Edit the payroll instruction (e.g. change the amount from ¥20,000 to ¥25,000)
4. Click Continue
5. Confirm the instruction edit (changes will be highlighted)

5. Click Submit
6. The edited instruction will show up in the table

3.6. End and Create Payroll Instruction

1. Click on the cell of the desired employee and paycode that want to end and create new payroll instruction (e.g. Employee: 000 0007 - Sample Company, Paycode: Salary)
2. Click Edit and then End and Create New
3. Set the new payroll instruction (e.g. change the amount from ¥1,005,000 to ¥1,200,000 starting from 08/2023)
4. Click Continue
5. Confirm the instruction edit (changes will be highlighted)

6. Click Submit
7. The edited instruction will show up in the table

4.7. End Payroll Instruction

1. Click on the cell of the desired employee and paycode that want to end (e.g. Employee: 000 0007 - Sample Company, Paycode: Salary)
2. Click Edit and then End Payroll Transaction
3. Set the last payment month and effective end date (e.g. set to the end of July 2023)

4. Click Save
5. The edited instruction will show up in the table

3.8. Delete Payroll Instruction

1. Click on the cell of the desired employee and paycode that want to delete (e.g. Employee: 000 0007 - Sample Company, Paycode: Allowance)
2. Click Edit and then Delete Transaction
3. Click Delete
4. The deleted instruction will disappear from the table

3.9. Compare Payroll Instruction With the Previous Month

The yellow highlighted spaces indicate that there are differences in the number compared to the month before.

1. Hover on the cell of the desired employee and paycode that want to compare (e.g. Employee: 000 0007 - Sample Company, Paycode: Allowance)
2. The comparison will show up

4. Variance Tab

4.1. What is Variance Tab?

Variance tab lets users do variance analysis by comparing the value of cash flow to a selected month.

4.2. Compare Payroll Instructions To a Selected Month

1. Select a month to compare with the current month

1.1. Click on the month that is underlined and colored

1.2. Select the desired month to compare (e.g. Jun 2023)


2. Hover on the cell of the desired employee and paycode to see the comparison (e.g. Employee: 000 0007 - Sample Company, Paycode: Car/Travel Allowance)

5. All Instructions Tab

5.1. What is All Instructions Tab?

All Instructions tab shows all instructions added. Each line shows each paycode of all workers one by one summarizing start and end date, amount, currency, supporting documents etc.

5.2. Download and Update Status of Payroll Instruction

1. Check the checkbox on the left side of the desired instructions
• Check the top checkbox to select all
2. To download the selected instructions:
1. Confirm the number of payroll instructions selected
2. Click Download Instructions

3. The selected instructions will be downloaded as an Excel file
3. To update the status of the selected instructions:
1. Select a status from a drop-down list

2. Click Save
3. The status of the selected instructions will be updated