Hours Collection Documentation - Mercedes Benz

Owned by Zachary Ruma (Unlicensed)
Last updated: Jul 22, 2022
6 min read

Hours Collection Documentation – Mercedes-Benz

 

Timesheet Import (Monday)

  1. Sign into Mercedes-Benz Beeline using Lastpass

2. Select the DAIMLER/deliverysupport module at the top of the home page to work in the Daimler client system

3. Go to Report Gallery Timesheets Detail Run

4. Enter the week ending date range for the client (Friday – Sunday; this range can be expanded if you are not catching all weekly timesheets in the report data pull). Select all for Timesheet Status (Approved, Incomplete, Locked, Missing, Not Submitted, Rejected, Submitted). The remaining fields may remain blank. -> Then hit ‘Create Report’ at the bottom of the page.

5. Download file as a CSV open the downloaded file

6. Enable Editing Delete the top 3 rows -> Filter the new top row and remove/hide columns A-D; F-H; & L-T. Your report should now resemble what is below.

7. Filter to show all Missing timesheets Delete them Filter to show all Approved and Submitted Timesheets

8. Insert new column to the left of the daily date column Label it “Payroll Number”

9. Go to Epi Finance Field Reports in the left column Finance Reports Employee Payroll Number Download as CSV Open file Move employee name on the other side of payroll number so it reads employee name then payroll number

10. In the Payroll Number column in our original spreadsheet enter =vlookup(A2,(A1 through B1684 of the Employee Payroll Number spreadsheet),2,false) Copy the formula down the column

11. Sort from largest to smallest to show all that will return a #N/A and look them up in Epifinance Click on their name at the top of the page copy and paste the payroll number at the bottom of the right margin into the spreadsheet (This will likely have to be done with several employees) Once this is done filter from largest to smallest again to be sure all payroll numbers are accounted for.

12. Manually go through the spreadsheet and make sure all hours (units) are in intervals of .25 (0, .25, .5, .75).

13. Go into the Epitec Inc folder Finance Team – General Hours Collection Timesheets – 2022 Timesheet Import Template Copy and paste our data into this template (Payroll number, dates (short date), hours, and payroll code ‘R’) Save as, browse, timesheet imports, Mercedes-Benz folder and save as “Mercedes-Benz #-##-##”

 

14. From Epi Finance Time sheet imports in the left margin Choose file Finance Team – General Hours Collection Timesheets – 2022 -> Mercedes-Benz –> “Mercedes-Benz #-##-##” file, Open If no errors are shown you are all set, if there are errors download the spreadsheet to see what needs to be corrected.

15. Once Errors are corrected save the file Delete the submission in Epi Finance Refresh the pageRepeat step 14 & 15 as needed.

 

Reconciliation (Tuesday)

  1. Follow steps 1 through 12 Above.

  2. Filter to only show Approved timesheets Replace all Approved with the letter “Y” Copy down the entire column.

  3. Filter to only show timesheets that are Submitted/Pending Approval. Replace all Submitted timesheets with the letter “N”. Select all timesheets ( Y and N). Delete any ‘Missing’ timesheets

  1. Open the Reconciliation Spreadsheet

  2. Copy and paste the Payroll Number, Date (make sure it is short date) and Quantity (Units). Billable is always “Y” and copy that all the way down. For the approved section on the Reconciliation spreadsheet copy and paste the Name column (Y & N).

  3. Once the Reconciliation spreadsheet is complete; Save as Browse Reconciliations Mercedes-Benz Name the file Mercedes-Benz XX-XX-XXXsave

  4. Go to Epi FinanceReconciliations Add reconciliation Choose generic Daily choose the file that was just savedSave

  5. Look over the file, If there are entries highlighted in Red that means they are in Epitec but not the client system.

  6. For entries highlighted red, get that person’s payroll number and copy and paste it to the bottom of the reconciliation spreadsheet that was just created. Enter the date and quantity shown in red. Billable will be “N” and Approved is “Y

  7. For those entries highlighted in Blue, they are in the client system but not Epilink.

  8. For these, go to the employees profile in Epi Finance Add Time Transaction Enter the time as it appears in Blue Save with a note saying “Entering to match client system-KM (Your Initials). The service code will be regular imported.

  9. Do this for all red and Blue highlighted entries. Once complete, delete the current entry and submit the new updated one. Repeat steps 7-12 as needed.