Overview
This guide will explain how to upload a Rate Card using the excel uploader into the SCOPE Better platform. Rate Card upload is a scope feature that allows users to upload one or multiple Ratecards from an Excel file.
Prerequisites
- You must be signed in to your SCOPE Better Account.
- You must have the right 'User Permissions' enabled on your account.
Step-by-Step Instructions
Step 1- Head to Manage -> Rate cards page
- Click Manage
- Click Rate Cards
Step 2- Select 'Upload Rate Card'
- Click '...' on the right hand side next to 'Add Rate Card'
- Click 'Upload Rate Card'
Step 3- Generate Template
- Select 'Generate Template' to download excel file
Step 4- Complete Excel File
- Add Rate Card Name
- Add Currency
- Add Rate Card Departments
- Add Rate Card Roles
- Add Rate Card charge out and cost Rates
Save File
Step 5- Upload Rate Card
- Click 'Browse'
- Select Excel file
- Select 'Validate'
Step 6- Confirm Upload
- Click Upload
Trouble Shooting
Issue: File won't Upload
Solution:
Note: all fields are required.
- All roles should be grouped by the department (do not duplicate department name in the Department name column)
- Different Ratecards should be on separate tabs in the excel file
- The format cannot be changed otherwise the upload will fail
'Instruction Manual' link will redirect the user to a page with upload instructions
In the case of any invalid or missing data in the upload file, you will see the option to download the validated excel file.
This download will highlight all missing or invalid data according to a colour code (pictured below). All highlighted data should be updated and then the file can be re-uploaded back into the scope system.
Comments
0 comments
Please sign in to leave a comment.