Employee Pay and Benefits Page
Employee pays & benefits will start in Manage. Once Manage has staffing updates configured, a regular update to the employee salaries & benefits will happen. When a user starts budgeting within an adopted scenario, they will be able to choose how to populate the staffing data in the scenario; by starting with a copy of the data in Manage, or by starting from scratch (without anything filled in).
If you start from scratch, then the admin will need to upload data about the employee’s pay & benefits for position planning to work correctly.
If you start from a copy of the status quo in Manage, we will take the current Manage table for benefits and salaries, and copy it into the budget scenario for Employee Pays and Employee Benefits as a starting place.
From that point forward, the Budget table for Employee Pays is DIVORCED from the Manage table for salaries, and while the Manage table will continue to receive nightly updates, the budget table will only be updated by the people with permission to adjust employee pays for a budget scenario. The administrator responsible for updating those Budget Scenario Employee Pays & Benefits will be able to upload changes to those values in bulk, and those changes will be part of a proposal, which must be approved for the changes to be applied. This means any and all changes to employee pay or benefits will be a part of the list of approved proposals.
How to Upload Employee Pays
If you choose to start from scratch, follow the steps outlined below to upload your employee pay and benefits.
Set the scenario that you wish to upload your employee pay into on the Overview page.
From Pay and Benefits, select Employee Pays.
Select the Upload Pays button.
The Select Proposal page displays.
Since this is the first time uploading employee pays, there will be no unapproved proposals.
Select the Add Changes to Proposal dropdown and choose + Create New Proposal.
Update the Proposal Title, if applicable. The default is New Proposal for ‘Scenario name’. This is a required field.
Use the Budget dropdown to select a specific budget to upload your employee pays to, or leave blank if the upload applies to more than one or all Budgets. This field is optional.
Enter a description or purpose for the proposal in the Proposal Justification field. This field is optional.
Select Create Proposal and Continue button to continue with the upload process.
Your blank proposal has been created, and you are returned to Select Proposal where the proposal you created is displayed in the Add Changes to Proposal field.
Select the Continue to Prepare and Upload button.
The Prepare and Upload page displays.
Select the Download CSV Template button to download a CSV file containing all the fields necessary for the upload.
Update the CSV file with your employee pay records. Review the Employee Pays Explanation of Fields on the page.
Once you have existing employee pay records, the CSV template will be pre-populated with all the data already in the system. Existing employee pay records you update and records you add to the CSV file are the records that will be created in your proposal. If you select an existing proposal that contains employee pay records, these are the records that are pre-populated in the CSV file.
When your file is ready, Drag and drop your file to the file upload box or choose the Browse Files link to select the file.
Select the Upload button to upload your records.
Map Fields page displays.
Your CSV Spreadsheet Field will automatically be mapped to an Allovue Field. If the mapping is incorrect, you can select the Allovue Field dropdown and select the correct Allovue Field.
If there are extra columns in your CSV file, you can choose to ignore them. Select the Allovue Field dropdown and select Ignore.
Once the mappings are set, select the Review and Confirm button.
Review and Confirm page displays.
No data has changed yet. This is your opportunity to review the records that will be created and updated. You may also see some records displaying errors. These records will be ignored if you choose to continue with the upload.
If there are records with errors you wish to correct or you want to make any additional changes, select the Back to Map Fields button to return.
If there are errors and you choose not to correct them, select the I understand some rows will be ignored, continue anyway button, or if there were no errors or you corrected the errors and you are ready to save your changes, select the Confirm and Save button.
The Upload Complete page displays which records were updated and/or ignored.
Select the View pays button to view the proposal’s Employee Pays records created and/or updated by the upload.
The proposal must be submitted and approved before the changes are applied to the budget scenario and are visible on the employee pays page.
How to Upload Employee Benefits
Review How to Import Staffing Data to populate staffing data using a copy of employee pays and benefits from Manage. If you choose to start from scratch, follow the steps outlined below to upload your employee pays and benefits.
Set the scenario that you wish to upload your employee benefits into on the Overview page.
From Pay and Benefits, select Employee Benefits.
Select the Upload Benefits button.
The Select Proposal page displays.
Since this is the first time uploading employee benefits, there will be no unapproved proposals.
Select the Add Changes to Proposal dropdown and choose + Create New Proposal.
Update the Proposal Title, if applicable. The default is New Proposal for ‘Scenario name’. This is a required field.
Use the Budget dropdown to select a specific budget to upload your employee benefits to, or leave blank if the upload applies to more than one or all Budgets. This field is optional.
Enter a description or purpose for the proposal in the Proposal Justification field. This field is optional.
Select the Create Proposal and Continue button to continue with the upload process.
Your blank proposal has been created, and you are returned to the Select Proposal paage where the proposal you created is displayed in the Add Changes to Proposal field.
Select the Continue to Prepare and Upload button.
The Prepare and Upload page displays.
Select the Download CSV Template button to download a CSV file containing all the fields necessary for the upload.
Update the CSV file with your employee benefit records. Review the Employee Benefits Explanation of Fields on the page for further details.
Once you have existing employee benefit records, the CSV template will be pre-populated with all the data already in the system. Existing employee benefit records you update and records you add to the CSV file are the records that will be created in your proposal. If you select an existing proposal that contains employee benefit records, these are the records that are pre-populated in the CSV file.
When your file is ready, Drag and drop your file to the file upload box or choose the browse files link to select the file.
Select the Upload button to upload your records.
The Map Fields page displays.
Your CSV Spreadsheet Field will automatically be mapped to an Allovue Field. If the mapping is incorrect, you can select the Allovue Field dropdown and select the correct Allovue Field.
If there are extra columns in your CSV file, you can choose to ignore them. Select the Allovue Field dropdown and select Ignore.
Once the mappings are set, click the Review and Confirm button.
The Review and Confirm page displays.
No data has changed yet. This is your opportunity to review the records that will be created and updated. You may also see some records displaying errors. These records will be ignored if you choose to continue with the upload.
If there are records with errors you wish to correct or you want to make any additional changes, select the Back to Map Fields button to return to Map Fields page.
From Map Fields, select the Back to Prepare and Upload button to return to – Prepare and Upload page. Make your changes to your CSV file and upload the new file.
If there are errors and you choose not to correct them, select the I understand some rows will be ignored, continue anyway button or if there were no errors or you corrected the errors and you are ready to save your changes, select the Confirm and Save button.
The Upload Complete page displays showing which records were updated and/or ignored.
Select the View benefits button to view the proposal’s Employee Benefits records created and/or updated by the upload.
The proposal must be submitted and approved before the changes are applied to the budget scenario and are visible on the employee benefits page.