Import Data From Ingress To Million Payroll Using External File (Excel)

Million allow user to import external data using Excel to Million Payroll

Step 1: Ensure Employee No exist in Employee Maintenance (Million Payroll) #

  1. Go to Employee and click on Employee Maintenance.
  1. Click “Add” to add new employee details.

3. Enter required / all data to create data for the employee.

4. Click on “Save” button after insert all data.

Step 2: Add a new first half / second half / month end payroll using Million Payroll. #

  1. Go to Transaction and click on Payroll.
  1. Click Add.
  1. Select Payroll Month.
  2. Select Payroll Type MonthEndPay.
  3. Click on Save.
  1. Click Yes.
  1. Click Close.

Step 3: Download and export excel file data from Ingress into Excel File. #

  1. Go to Ingress Software and click Attendance.
  2. Click the “Export Payroll”.
  1. Select Million Payroll Template.
  2. Select the user to export data.
  3. Select the date range.
  4. Click the Export.

Step 4: Set File Format in Million Payroll. #

The main purpose of this step is to allow Million Payroll capture data from excel spreadsheet
correctly. User need to matched the column in Million Payroll with the column in Excel Spreadsheet.
This setting only need to perform one time only.

  1. Go to System then select Administrative Tools
  1. In menu, select Import Data from External File
  2. Click OK.
  1. Select File Format Setting
  1. Click on Generate Sample.
  1. Select Million
  2. Click OK
  1. Click Yes
  1. Click OK
  1. Enter xls#1 number according to column number in excel spreadsheet.
    Eg: Public Holiday in Excel is under C3 column. In million, user need to enter 3 under Public Holiday in xls#1 column.
    NOTE: If column in Million does not appear in Excel spreadsheet, user need to enter 0 in Million to indicate the column is not in use.
  2. Click Save.

Step 5: Import data into Million Payroll #

  1. Click Import
  1. Select Excel File option
  2. Click search button to search the file.
  1. Navigate to file location and click OK
  1. Once system display the file directory, click OK.
  1. Click Yes
  1. Click OK

Step 6: Save and process the payroll. #

  1. Go to Transaction and click on Payroll.
  1. Select monthly payroll and click Edit.
  1. Select employee record and click Edit
  1. View the data import from Excel file.
  2. Click Save
  1. Click OK
  1. Tick on the record
  2. Click on Process Pay
  1. Click OK
  1. Click Yes
  1. Click OK
  1. Click on View Payslip to view the payslip.

Powered by BetterDocs