Add several jobs at once to Smartcat by importing them in an Excel file. Here we’ll explain how to prepare, save and upload such files.
1. Navigate to Payments, select Supplier payments and click Add supplier job. 
2. In the Bulk import multiple jobs section click Import. 
3. Click Download to download the job register template. Then populate the template with the details of the completed tasks.
For a comprehensive description of each field in the job register, go to the How to fill in your register correctly section below.
4. When the job register is completed and saved, click Choose File to select it for uploading.
5. If the date or decimal separator format is incorrect or invalid, click Back and correct the format.
Click Next to continue reviewing the values. This window will also be displayed in the first step of the register upload if the system is unable to automatically parse the columns or the uploaded data format.
6. After uploading, you can still edit the register or fix any data entry errors by doing one of the following:
- Double-click on a cell to enter the correct value.
- Select a column to adjust from the drop-down list and enter the value to be applied to every row in that column.
Note that a supplier name in this window may differ from the name that you entered in the register. This happens when a supplier is already registered in the Smartcat platform with this email address and the name has been taken from that account. In this case the supplier’s name is not editable.
The job cost is calculated automatically by multiplying the rate per unit by the unit count.
7. Click Next to confirm that you would like to import the jobs.
8. When the jobs have been successfully imported, you can create an invoice for them and remit the payment by clicking Create invoice & pay. Alternatively, click Go to jobs to open the imported jobs and review them.
How to fill in your register correctly
Each row in the Excel spreadsheet listing jobs for payment must contain the following fields:
| Field name | Description |
| Contact email | Supplier's email address |
| Supplier | Supplier’s full name |
| Service | The service provided by the supplier. Select the relevant option from the drop-down list. |
| Description | Additional details on the provided service |
| Source language | The job's source language. Select the relevant option from the drop-down list. Refer to Language pair selection below for details. |
| Target language | The job's target language. Select the relevant option from the drop-down list. Refer to Language pair selection below for details. |
| Unit type | The billable unit type. Select the relevant option from the drop-down list. |
| Unit count | The amount of units in the job. |
| Rate per unit | The unit rate represented in the service currency selected in the Currency field. For details, refer to Rate-per-unit ranges below. |
| Sum (formula) | The total payable for the job. This value is automatically calculated by multiplying the Unit count by the Rate per unit. |
| Currency | The currency in which the unit rate is represented. Select the relevant option from the drop-down list. |
| Start date | The date on which the job was started. Any date format is allowed, provided that it is used consistently across the CSV. |
| Done date | The date on which the job was completed. Any date format is allowed, provided that it is used consistently across the CSV. |
| External ID | The ID assigned to the job in the client's system. This field is optional and should be populated only if applicable. |
| Supplier type | Select Freelancer or Company from the drop-down list. Refer to the section Supplier type selection below for details. |
Language pair selection
The requirements regarding the language pair selection depend on the value specified in the Service field.
- If one of the following services is selected, provide both Source language and Target language, and make sure that they are not identical:
| Translation | Certified translation | Transcreation |
| Glossary management | Simultaneous interpreting | Consecutive interpreting |
| Audiovisual translation | Quality assurance | TM management |
| Copywriting | Transcription | Interpretation services |
| Translation for subtitling | Subtitles translation |
- For the following services, only the Target language attribute is mandatory. The Source language field can be left empty:
| Editing | Proofreading | MT post-editing |
| Editing translation of subtitles |
- For the following services, neither the Target language or the Source language is mandatory. Both fields can be left empty:
| Training | Project management | Desktop publishing |
| Notarization | Legalization/Apostille | Other services related to translation |
Rate-per-unit ranges
When specifying the rate per unit, make sure to remain within the pre-defined ranges. The allowed minimum and maximum values represented in USD are listed below:
| Unit | Minimum | Maximum |
| word | 0.0005 | 1 |
| page | 0.125 | 250 |
| symbol | 0.00007 | 0.14 |
| hour | 1 | 1000 |
| minute | 0.01 | 17 |
| document | 10 | 1000 |
| day limits | 10 | 1000 |
| month limits | 100 | 8000 |
Supplier type selection
When importing a job for payment, you need to indicate the payee type in the Supplier Type field. Two options are available: Freelancer or Company.
- If the field is not populated, the system assumes that the supplier type is Freelancer
- If Company is selected as the supplier type, the payment will be remitted to the corporate account balance. The payee will be able to use these funds to pay other freelancers across the platform or request a cash out.
- If Freelancer is selected as the supplier type, the payment will be processed as specified in the payee's account details.
Did this article help you find the answer you were looking for? If not or if you have further questions, please contact our support team.
