Acclaim - How to import Job cost with a .TXT file

Prerequisite:

You must define cost center: 

Go to Setup > Cost Centres
Add / Edit the Cost Centers 

Open

Import file is a .txt file (Header record not require)

Here is a layout for import file:

W,sEmpNo,sPayCategory,sHours,sRate,sDate,sCostCentre,sCCDep,sCCAccount

The column in the file are listed below:

Example of .txt file:

W,001,102,10.00,20.00,01/18/2019,123123121212,00001,444

W,001,110,2,22.00,01/18/2019,44444781414,00001,444

W,003,102,11.50,20.00,01/08/2019,123123121212,00001,444

W,003,110,3,25.00,01/08/2019,777723121212,00001,444

How to Import the job cost from file:

To import job cost (.txt file)

1. Go to Payroll > Process Payroll then Job Costing > Work Details > Import

Open

Open

2. After successful import you must review the job cost:

Payroll > Process Payroll then Job Costing > Work Details > Edit

Open

Open

How to create Paycards:

After creating the Job Centers user have 2 options to create paycards:

• Option 1: Batch the paycards – all employees at once

• Option 2: Add the paycard – one employee at the time

Option 1: Batch  paycards using the job cost:

Steps:

1. Payroll > Process payroll

2. Batch > Batch Create Timesheets > place a checkmark in the “Only create timesheets for employee with Job Costing or Import entries

3. Click Batch button

Open

Open

     4. After batch the user can review paycards (payroll -> process payroll)

Option 2: Create Employee Paycard after job cost import:

1. Go to Payroll > Process Payroll.

2. Double click the employee in the “Paymate Payroll Processing” window.

3. Click “+” to create the paycard.

Open