Articles in this section

How To Use The E/D Uploader In An Off Run

Avatar
Push Operations Support
  • Updated

Goal

  • How to mass upload Earnings and Deduction entries in an Off Run

Environment:

  • Push Web App

Process:

To Create the Earnings and Deductions Excel

  1. Click the Payroll tab
  2. On the left hand navigation bar, click Run Off Run
  3. Click Add A New Off Run
  4. Select the Start Date, End Date, and Pay Date
  5. Under Employees On The Run, select the specific employee(s) by checking the box to the left of the employee's name
  6. Once done, click Add Off Run at the bottom of the page
  7. The page will refresh, on the right-hand side under the Employees Column, click the Coin Stack that corresponds with the employee you wish to input hours/dollars
  8. On the left hand navigation bar, click E/D Uploader
  9. Under Action, select Create Earnings and Deductions Excel
  10. Under Select Pay Run, select the date of the Off Run 
  11. Under Select E/D Presets, Departments, Positions, and Employees leave blank to select all or filter accordingly
  12. Click Submit and click Yes, do it! to download the Excel spreadsheet
  13. Open the Excel Spreadsheet and enter in the hours worked for each of the employees

To Upload the Earnings and Deductions Excel 

  1. Click the Payroll tab
  2. On the left hand navigation bar, click Run Off Run
  3. On the left hand navigation bar, click E/D Uploader
  4. Under Action, select Upload Earnings and Deductions Excel
  5. Under Upload, click the plus icon and select the appropriate file
  6. Click Submit and click Yes, do it! to upload the Excel spreadsheet
  7. The page will refresh and will take you to Earnings and Deductions to review the entries 
  8. Once reviewed, on the left hand navigation bar click Run Off Run 
  9. Under Actions, click the Play Button icon that corresponds with the current Off Run
  10. Click View/Approve Pay Run to review the Off-Run, if it looks good, click Approve Payroll

Additional Information

Please note, that you are only able to use the E/D Uploader in an Off Run for Active Employees only.

Inactive Employees will not populate in the E/D Excel Spreadsheet as they do not have a Salary or Position associated. You can leave the Employee Profile as Inactive and add in the entries manually or you can reactivate the Employee Profiles and deactivate once the Off Run is approved to use the E/D Uploader. 

When entering information into the Earnings and Deductions Excel:

  • Please do not change the format of the csv.
  • Please do not change the title of the Excel sheet
  • Please only add numbers into the cells (no symbols like $).
  • You may only add numbers with two decimal places (like 22.22).
  • There will be a row for each position (unless you have checked off Exclude Positions).

If an employee has two positions, they will show up twice. If you are adding regular pay, based on a salary rate, please be cautious.
If you wish to auto-calculate pay based on the employee's salary rate, you can fill in the hours column, and leave the amount column empty.

For example:
Ross is a server ($10/hour) and host($11/hour). You want to pay them 8 hours of regular pay, worked as a server. In this case, you will leave their host row blank, and fill in their server row with 8 hours and leave the amount column blank.
The system will auto-calculate their pay based on the amount of hours you've entered x their rate.

Once you have completed entering in the hours worked, remember to save the file as a .CSV file or else it will not be uploaded properly into Push.

After Uploading the Earnings and Deductions Excel

Your entries will now be found in the Earnings and Deductions page. You can edit and delete your entries there, if necessary.

Please note, that if you made a mistake on an entry, you will need to delete this under Earnings and Deductions and create another Earning and Deduction spreadsheet to upload with the adjustments only. If you upload another spreadsheet for the same pay period with the exact same information that was uploaded in a previous spreadsheet, this will double up the hours and dollar amounts. 

Please note that only Super Administrators and Team Administrators with permissions to payroll will be able to use the E/D Uploader.

Related Articles

Related articles

Comments

0 comments

Please sign in to leave a comment.