Import Payroll

Overview

The Import Payroll menu is used to import employee payroll data in bulk. This feature allows you to process payroll for specific periods, upload data, and verify employee salary calculation results including components such as basic salary, JHT deductions, JP deductions, and total payments.

Page Navigation

The Import Payroll page is located in the Payroll » Import Payroll menu.

Period Filter (Month Filter)

Before importing, you need to select the payroll period to be processed. A month filter is available to facilitate selection:

Available Months List

How to Select a Period:

1. Click the Month Filter dropdown
2. Select the desired month and year
3. The system will display payroll data for that period

Payroll Import Process

The payroll import process consists of several steps that need to be followed sequentially.

Step 1: Select Period of Payroll

Title: "1. Select Period of payroll"

Description: "Choose the specific payroll period for which you want to process payments."

Field:

Buttons:

Step 2: Make Sure Timeframe Payroll

Title: "2. Make sure timeframe payroll"

Description: "Ensure that the selected payroll timeframe is accurate and covers all necessary dates."

In this step, you need to verify that the selected payroll period is correct and covers all required dates.

Status:

• Select Period of payroll (completed)
• Make sure timeframe payroll (in progress)

Buttons:

Step 3: Upload Your Data

Title: "3. Upload your data - Last step"

In this final step, you will upload the payroll data file.

Download Templates

Before uploading, you can download a template to ensure the file format is correct:

Download Templates Button:

• Click to download the template file in the appropriate format (CSV/Excel)

Import File

Import File Section:

• Import File - Area to select the file to be uploaded
• Upload - Button to start the upload process
• Back - Return to the previous step

Main Buttons:

Payroll Import Results

After the import process is successful, the system will display payroll data for the selected period.

Header Information

Information displayed:

Payroll Data Table

The table displays employee payroll data with the following columns:

Payroll Table Data

Here are examples of payroll data for the December 2025 period:

Note: Table displays 9 out of 20 data items

Payroll Components

Basic Salary

Basic salary is the employee's base salary before allowances are added or deductions are made.

Deductions

There are two types of deductions displayed:

Calculation Example:

• Basic Salary: Rp 10,000,000
• JHT 2%: Rp 200,000 (10,000,000 × 2%)
• JP 1%: Rp 100,000 (10,000,000 × 1%)

Total Deduction

Total Deduction is the sum of all deductions from the employee's salary.

Total Deduction Components:

• JHT 2%
• JP 1%
• Other deductions (if any)

Example:

• Basic Salary: Rp 10,000,000
• JHT 2%: Rp 200,000
• JP 1%: Rp 100,000
• Other Deductions: Rp 600,000
• Total Deduction: Rp 900,000

Total Payment

Total Payment is the final amount received by the employee after adding allowances and subtracting deductions.

Formula: Total Payment = Basic Salary + Allowances - Total Deduction

Example:

• Basic Salary: Rp 10,000,000
• Allowances: Rp 5,000,000
• Total Deduction: Rp 900,000
• Total Payment: Rp 14,100,000

Actions on Payroll Data

Actions

In the Actions column, there is a 🗑️ (trash) icon that appears twice:

Possible functions:

• First 🗑️: Delete payroll data
• Second 🗑️: Permanent delete or cancel import

Complete Payroll Import Flow

Here is the complete payroll import process flow:

Flow Diagram

Start ↓ Select Period (Month Filter) ↓ Step 1: Select Period of Payroll ↓ Click Continue ↓ Step 2: Make Sure Timeframe Payroll ↓ Verify Period ↓ Click Continue ↓ Step 3: Upload Your Data ↓ Download Template (optional) ↓ Upload Import File ↓ Click Upload ↓ Data Processed ↓ Display Payroll Results ↓ Verify Data ↓ Finish

Step Summary

Usage Tips

1. Select the Right Period - Ensure you select the appropriate month and year before starting the import process.
2. Use the Template - Always download the template first to ensure the file format is correct.
3. Verify Data Before Upload - Check the file to be uploaded to avoid data errors.
4. Check Calculations - After import, verify basic salary, deduction, and total payment calculations.
5. Pay Attention to Employees with Different Salaries - For employees like Sigit Pramono with different salaries, ensure the calculations are accurate.
6. Documentation - Save the import file and results for audit purposes.
7. Delete Duplicate Data - Use the delete icon to clean up unnecessary data.

Payroll Data Verification

Things to verify after import:

1. Data Completeness

• All employees appear in the list
• No employees are missed
• Number of items matches total employees

2. Basic Salary Calculation

• Basic salary matches employee data
• Employees with different positions have appropriate salaries
• No input errors in nominal values

3. Deduction Calculation

• JHT 2% calculated correctly (2% of basic salary)
• JP 1% calculated correctly (1% of basic salary)
• Total deduction is correct (sum of all deductions)

4. Total Payment Calculation

• Total payment = basic salary + allowances - deductions
• Numbers are reasonable and as expected
• No rounding errors

5. Data Consistency

• Number format is consistent (thousand separators and decimals)
• Employee names match the database
• Employee ID is valid

Troubleshooting

File Upload Failed

• Ensure the file format matches the template
• Check that the file size is not too large
• Ensure the file is not corrupted
• Try downloading the template again

Data Not Displayed After Upload

• Wait a moment, the process may be running
• Refresh the page
• Check if the month filter is appropriate
• Check for error notifications

Calculations Don't Match

• Check the calculation formulas in the import file
• Verify source data (basic salary, allowances)
• Manually calculate for a sample employee
• Edit data if necessary

Number of Items Doesn't Match

• Check the number of active employees in that period
• Ensure the import file contains all employees
• Filter to display all data

Delete Button Not Working

• Ensure you have access rights
• Try refreshing the page
• Check if the data is being processed by another system

Integration with Related Menus

Employee Database

Basic salary data comes from Employee Database under the employee compensation tab.

Payroll Report

Import results can be viewed in the Payroll Report menu for the relevant period.

Bank Payment

Total payment data can be exported for the bank payment process.

BPJS Management

JHT and JP data are integrated with BPJS Management for reporting.

Next Steps

• Payroll Report
• Employee Database - Compensation
• BPJS Management
• Bank Payment Integration