Below is the step by step guide on SQL Payroll Software Excel Import.

In this example, I’ll be using Allowance for illustration.

First, get the Excel Template from your dealer. After key in, remember the file MUST be save as CSV Format. The Employee Code and Allowance  Code must be already setup in SQL Payroll System.
Step 1: Payroll -> Open Pending Payroll -> Allowance  

Step 2: Click “…” to select the csv file

Step 2: Click Next.

Step 4: Import from row set to 2 -> Select fields for each column

Step 5: Click Finish

Step 6: Transaction posted to Payroll-> Click Save after check the transactions & make sure is correct.