Unique Fire Industry

Unique Fire Industry

Uniquefire IT Portal

Q:

Auto-detection of employee department code and automation of payroll journal

1. Auto-Detection of Employee Department Code

We would like to request a system enhancement to automatically detect and assign the employee’s department code based on the employees name/ID, whichever you consider to be the most suitable solution. (e.g., in Journal module when posting monthly staff claims).

Please refer to the attached file for the list of employees and their respective department codes.

 

2. Payroll Journal Upload Automation

Currently, our payroll system (Infotech) is not linked to Epicor system. As a result, all payroll related journal entries are posted manually each month.

This process involves a significant amount of manual work, as we are required to map and reconcile all payroll expense GL codes (e.g., salaries, allowances, and statutory payments) with the respective department codes.

We would like to have a more efficient solution whereby payroll details can be uploaded from an Excel file into Epicor to automatically generate and post the payroll journal entries.

Could you please advise on the available options and recommend a solution to improve the efficiency of this process?

3 Replies

Hi Hui Xuan,

We will update you as soon as possible, and we will raise ticket by now.

Hi Hui Xuan,

1. Auto-Detection of Employee Department Code

May I know how do you enter your staff claims? What kind of “journal” we have to do this? Is there any particular GL codes that you use for staff claim purpose?

 

2. Payroll Journal Upload Automation

We can integrate through API or Excel file. May I know if your payroll system support API? If no, do you extract the Excel manually?

For both of these requirements, could you please attach the files again? I cannot see any file from my end.

1.     1. We enter monthly staff claim records through the Journal Entry module based on the hardcopy ‘Claim Detail Report (Individual)’ provided by the HR Department, which is generated from Infotech. There are no specific GL codes assigned to staff claims, as the claims are recorded according to their nature. Therefore, various GL codes may be involved.

Kindly refer to the attached sample of ‘Claim Detail Report (Individual)’.

For example, a department lunch will be charged to GL code 9000/S06-HQ, while a Touch N’Go (Toll) is 9000/T04-HQ. We are required to review the supporting documents attached to verify the nature of the expense. This is necessary because employees may incorrectly select the claim category during submission. Therefore, we need to confirm the actual nature of the expense before assigning the appropriate GL code.

 

1.      2. HR department will provide us with a monthly payroll breakdown, which is prepared based on the information extracted from Infotech. We use it as the source document to prepare our working report before posting to the journal entries module.

Kindly refer to the attached sample of ‘Monthly payroll breakdown by HR’.

Would it be possible to provide an Excel template that allows us to enter double entry and directly upload staff claims and payroll journal entries into Epicor? Alternatively, do you have any suggestions on how we can further improve the current process?

Please noted that account department does not have access right to the Infotech claim and payroll module.

Attachments:
You must be logged in to view attached files.

Viewing 3 replies - 1 through 3 (of 3 total)