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
- Click the Payroll tab.
- On the left hand navigation bar, click Run Off Run.
- Click Add A New Off Run.
- Select the Start Date, End Date, and Pay Date.
- Under Employees On The Run, select the specific employee(s) by checking the box to the left of the employee's name.
- Once done, click Add Off Run at the bottom of the page.
- The page will refresh. From the left-hand navigation bar, select E/D Uploader.
- Under Action, select Create Earnings and Deductions Excel.
📌 | Note: If you are using your own self-created file, skip to the steps listed under To Upload the Earnings and Deductions File. - Under Select Pay Run, select the date of the Off Run.
⚠️ | Warning: You will not be able to select an Off Run under Select Pay Run until steps 1–6 of the pay run creation process are completed. Make sure the off-run has been fully set up before attempting to generate or upload an E/D file for it. - Under Select E/D Presets, select the preset type(s) (e.g., earnings, deductions, benefits, or balance adjustments) to include in the spreadsheet.
- Leaving this blank will include all presets, but each adds three columns (dollar amount, hour amount, and optional date). Presets must be selected here and cannot be added later—unless using a self-created file.
- Under Departments, Positions, and Employees, choose which team members will be included in the spreadsheet.
- Leaving this blank will include all active employees. Selecting a department will auto-populate related positions and employees. Only those selected will appear in the spreadsheet; unselected employees cannot be added later unless they use a self-created file.
- Once done, click Submit and click Yes, do it!
- Open the spreadsheet from your device's downloads and enter the relevant details for each employee.
⚠️ | Warning: Do not change the format or structure of the file, as this will prevent it from being accepted. For guidance on how to complete the fields correctly, see the notes in Additional Information.
To Upload the Earnings and Deductions Excel
- Click the Payroll tab.
- On the left-hand navigation bar, click E/D Uploader.
- Under Action, select Upload Earnings and Deductions Excel.
- Under Upload, click the plus icon and select the appropriate file.
- If you are using a Push-created file, uncheck the box associated with Allow Self-Created E/D File Upload.
- If you are using a self-created file, check the box associated with Allow Self-Created E/D File Upload.
- Click Submit and click Yes, do it! to upload the spreadsheet details.
- The page will refresh to Earnings/Deductions, and you can review the entries created based on the spreadsheet details below!
- Once reviewed, on the left-hand navigation bar, click Run Off Run.
- Under Actions, click the Play Button icon that corresponds with the current Off Run.
- Click View/Approve Pay Run to review the Off-Run, if it looks good, click Approve Payroll!
Additional Information
Please note that you can only use the E/D Uploader in an off-run for Active Employees.
Inactive employees will not populate the E/D Excel spreadsheet as they do not have a salary or position associated with them. 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).
Important Notes When Entering Data
- If an employee has two positions, they will appear in two rows. Be cautious when adding regular pay based on a salary rate.
- To auto-calculate pay based on salary, enter the hours worked and leave the Amount column blank.
- 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.
Example:
Ross is a server ($10/hour) and host ($11/hour). You want to pay them 8 hours of regular pay for working 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.
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 you need to.
Just so you know, if you made a mistake on an entry, you will need to delete this under Earnings and Deductions and create another Earnings and Deductions 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.
📌 | Note: Only Super Administrators and Team Administrators with permissions to the E/D Uploader will have access to the E/D Uploader.
📌 | Note: The E/D Uploader permission allows Team Administrators to create and upload earnings and deductions via spreadsheet only. It does not grant access to the main Earnings and Deductions page or allow edits after upload. To modify entries after they’re created, additional Set Up Earnings and Deductions permissions are required.
⚠️ | Warning: Granting access to the E/D Uploader allows Team Administrators to select any earning or deduction preset when uploading data for payroll. This access is broader than the standard Earnings/Deductions permission, which can be limited to specific presets (for example, Retroactive Pay only). Review permissions carefully before enabling this access.
Comments
Please sign in to leave a comment.