Description
...
Candidate ID | Job ID | Item Date | Pay Code Name | Pay Quantity | Pay Rate | Bill Code | Bill Rate | Reimbursement Item | Reimbursement Net Value | Reimbursement GST/VAT Value |
100000094 | 200005708 | 17/06/24 | Ordinary | 8 |
|
|
|
| ||
100000094 | 200005708 | 17/06/24 |
|
|
| Reimbursement | 100 | 10 | ||
100000094 | 200005708 | 18/06/24 | Ordinary | 8 |
|
|
|
| ||
100000094 | 200005708 | 19/06/24 | Ordinary | 8 |
|
|
|
| ||
100000094 | 200005708 | 20/06/24 | Ordinary | 8 |
|
|
|
| ||
100000094 | 200005708 | 21/06/24 | Ordinary | 8 |
|
|
|
|
...
Candidate ID | Job ID | Item Date | Pay Code Name | Pay Quantity | Pay Rate | Bill Code | Bill Rate | Reimbursement Item | Reimbursement Net Value | Reimbursement GST/VAT Value |
100000094 | 200005708 | 17/06/24 | Ordinary | -8 |
|
|
|
| ||
100000094 | 200005708 | 17/06/24 |
|
|
| Reimbursement | -100 | Reimbursement | -100 | -10 |
100000094 | 200005708 | 18/06/24 | Ordinary | -8 |
|
|
|
| ||
100000094 | 200005708 | 19/06/24 | Ordinary | -8 |
|
|
|
| ||
100000094 | 200005708 | 20/06/24 | Ordinary | -8 |
|
|
|
| ||
100000094 | 200005708 | 21/06/24 | Ordinary | -8 |
|
|
|
|
...
Candidate ID | Job ID | Item Date | Pay Code Name | Pay Quantity | Pay Rate | Bill Code | Bill Rate | Reimbursement Item | Reimbursement Net Value | Reimbursement GST/VAT Value |
100000094 | 200005708 | 17/06/24 | Ordinary | 8 |
|
|
|
| ||
100000094 | 200005708 | 17/06/24 |
|
|
| Reimbursement | 100 | 10 | ||
100000094 | 200005708 | 18/06/24 | Ordinary | 8 |
|
|
|
| ||
100000094 | 200005708 | 19/06/24 | Ordinary | 8 |
|
|
|
| ||
100000094 | 200005708 | 20/06/24 | Ordinary | 7 |
|
|
|
| ||
100000094 | 200005708 | 21/06/24 | Ordinary | 8 |
|
|
|
|
...
Invoice for Timesheet 1234 for 8 * 5 Ordinary, and a reimbursement $100 + $10 GST/VAT.
Credit Note for Timesheet 1235 for negative 8 * 5 Ordinary, and a negative reimbursement of reimbursement $100 + $10 GST/VAT.
Invoice for Timesheet 1236 for 8 * 4 + 1 * 7 Ordinary, and a reimbursement $100 + $10 GST/VAT.
| Note |
|---|
It is important to note that you must not import a mixture of positive and negative values in an individual timesheet as the interpreter will attempt to find the difference to the original timesheet item for positive values and will treat negative items as a full credit. The data will be confusing and the summed results will be confusing. This strategy will only work for Standard Rate timesheet’s. Agreement Rate timesheets must use the as is/to be strategy were all values are positive where adjustments are required. |
Reimbursements: When using the Debit / Credit strategy, it is important to note for the credit timesheet, the reimbursement item imported must include a negative value for both Net and GST/VAT as per the preceding positive timesheet, and the related reimbursement Bill Code and Bill Rate. If the Bill Code and Rate are not included the interpreter will interpret the Pay items as negative and the Bill items as positive so you will not achieve a full credit note.
In the interpreted timesheet the negative Bill Rate will display as a superseded value as the logic considers it different to what is in the job, which is a positive value.
Benefits
The Debit / Credit strategy will assist clients where they wish to bill clients with full debits and credits of timesheets, where there are timesheet iterations (same Job and same Week Ending Date).
...