Net to Gross payments can be imported directly into the pay run. Go to the current open pay run, and click the button in top right corner, then select New bulk import.
When creating a new import, we recommend completing the Your reference (optional) field. This is the name that will appear in the Bulk Import Jobs list, for example ‘Net to Gross - July’.
You will then need to select one of the behaviours below.
New payment behaviour:
- Create New payment - (default) if there is no payment, the import will create one
- Ignore these records - if there is no payment, the import will not create one
Existing payment behaviour:
- Update payment - (default) if there is an existing payment, the import will update it
- Ignore these records - if there is an existing payment, the import will not update it.
To import data into a pay run, create a CSV file with column headings that match those below or use the template attached at the bottom of this article.
| Note: Employee can only have one net to gross payment in a pay run. |
Import file Column Definitions
| Field / Header | Example | Notes |
| Pay ID / Employee Code | P1 / EC1 | Can be Employee Code or RTI Payroll ID |
| Cost Code | CCA | Optional cost code to use in reports |
| Type | n2g_bonus | The ID of the Net to Gross Pay Element you have in the Company Setup |
| Description | Bonus | The name/ description for this payment that will be visible on the employee's payslip. If empty, a Description set on the company pay element will be used |
| Net Target | 500 | the net target amount to be grossed up |
Comments
0 comments
Article is closed for comments.