Mass Time & Expense entry from Excel

Kinetic ERP
,
1

Before I write this customization and new screen, I’m hoping someone already did this and would share it with me. Cloud, Kinetic, Payroll, Time and Expense Entry is ‘still’ in legacy mode. To enter hours, you must select an employee, then a day, the tab through entering the time(s). Even without Jobs and Indirect, this takes too much time and is too prone to key/error. My client already has the payroll in a spreadsheet and no, they didn’t license Time Management. Even if they had licensed Time Management, it doesn’t seem to support the nice cut/paste from Excel® that they’d like to use.

Anybody already do this?
Thanks

2

I was able to go into Time and Expense entry
select an employee
Paste insert in the classic view time entries for a job.

I had done this in the past, personalize/customize the grid to show the required field to make it work.

Note, in order to make it work you do need a LaborHead record to sync with the labordtl record you are importing.

Consider using DMT where there is a bit more flexibility to generate the laborhead records.

3

Thanks. I did later see the “Time Entry” Kinetic screen and checked to see if I could paste insert the LaborHed records there. I can trace that to see what’s needed to recreate a grid for multiple users and paste insert all from there. For now the business has decided to hold off on this, so I’ll try to remember to update this if they end up going for it and it works. They only needed LaborHed records to track payroll at the moment.