...
NOTE: The adjustment wizard creates additional adjustment timesheets in the same period as the original timesheets. It does not alter existing timesheets in any way.
Using the Adjustment Wizard
- From the menu, select Timesheets -> Adjustment Wizard. You will be presented with the familiar filter form. Search for the timesheets you wish to correct, select them from the list, then click the "Adjust Timesheets" button.
- You will be presented with the adjustment wizard screen:
All of the fields within the Adjustment Configuration section are optional.
| Field | Purpose |
|---|---|
| Affects | Whether the adjustment will impact the Pay side, the charge side or both. |
| How to process | Partial Credit or Invoice - A new timesheet/expense will be created to cover the difference in pay/charge Part Credit and Reinvoice - A negative timesheet/expense will be created to reverse the incorrect one and a new timesheet/expense put in its place. Full Credit and Reinvoice - For all the timesheets/expenses adjusted or not adjusted in an invoice. A negative timesheet/expense will be created to reverse the incorrect (or the correct one ) and a new timesheet/expense put in its place. (for a rectified or not rectified both) Note: This feature is only applicable to Pay Only and Charge Only. |
| Invoice Custom Text | This text will be included on any invoices or credit notes generated by the adjustment wizard. |
| Invoice Date | This defaults to today's date but can be overridden here. |
| Re-Approve | Tick this box if you want to send the adjustment timesheets through the normal approval process. You will not be able to select the "Process Invoicing" box if this is selected |
| Process Invoicing | Tick this box if you want to invoice the adjustment timesheets. You will not be able to select the "Re-Approve" box if this is selected. NOTE - Adjustment Timesheets will attempt to be grouped onto an invoice based on the last invoice for the original timesheets. However, the existing consolidation settings for the client/worker/provider will be respected. NOTE - Automatic invoice adjustments such as Withholding Tax will be included in the invoice value |
| Reason for Crediting | This checkbox is by default greyed out and is enabled only when "Process Invoicing" checkbox is ticked. Select the reason for crediting to store in credit notes. |
Adjusting Timesheets:
Once you have configured how you want the adjustments to be processed, you can proceed to enter your adjustments against each of the timesheets. You should enter the correct unit, pay and charge values. only change the fields where the data was incorrect. The system automatically calculates the adjustments needed. For example, if a worker claimed 10 hours, but should have claimed 8 hours, you should enter 8 hours in the units field, and do not change the Pay or Charge fields.
- The Bulk Update Rates section is used to update the pay/charge rates in the Timesheet Adjustments section en-masse. Modify the pay/charge rates as required then click the Bulk Update Rates button. NOTE: This does not process any adjustments.
- In the Timesheet Adjustments section, you can correct the total units, pay and charge for a given rate on each timesheet. Once your adjustments are complete, click the Process Adjustments button.
Adjustment Expenses:
Similarly, you can proceed to enter you adjustment against each of the expenses as well. You should change the field where the data was incorrect but you have to enter the respective changes manually impacting other fields. E.g., If Unit Net is modified, it will impact the respective Net, VAT Rate, VAT and Gross.
- The Bulk Update Rates section does not work for Expense Adjustments.
- In the Expense Adjustments section, you can correct the total units, unit net, net, vat rate, vat and gross.
Note: Both Timesheets and Expenses can be adjusted together.
Selecting a credit reason
If you have created a credit reason, you will be able to choose one within the timesheet adjust wizard when you tick Process Invoicing.
Viewing Adjustments:
A message is displayed on the adjustment timesheet with a link back to the original timesheet:
On the original timesheet, you can click the "Adjustments" tab to view all adjustments for that timesheet:
Example - Partial Invoice Or Credit
The worker claims 8 hours:
An Administrator realises they should have claimed 10 hours and wants an adjustment for the additional 2 hours only, so chooses the Partial Invoice or Credit option and enters 10 hours against the appropriate rate:
The system automatically creates a new timesheet showing the reversal of the incorrect hours and the addition of the correct hours:
If you chose the Process Invoicing option, the adjustment timesheet will have been invoiced:
Example - Part Credit and Reinvoice
The worker claims 8 hours:
An Administrator realises they should have claimed 10 hours and wants a timesheet showing 10 hours, so chooses the Part Credit and Reinvoice option and enters 10 hours against the appropriate rate:
The system automatically creates a new negative timesheet to negate the original:
It also creates a new timesheet with the correct hours:
If you chose the Process Invoicing option, the negative timesheet will have a credit note against it and the adjustment timesheet will have an invoice:
In this example the worker has a fixed addition of £10 per invoice configured on his record and this was included on the generated self-bill invoice:
:
The reason selected in the Timesheet Adjustment Wizard screen is stored in Credit Notes as follows:
Example - Full Credit and Reinvoice
An invoice is generated with 3 timesheets in it.
In one of the timesheet the worker claimed 8 units.
An Administrator realises the worker should have claimed 10 units, so chooses the Full Credit and Reinvoice option and enter appropriate rates. Click on Process Adjustment.
Note: Full Credit and Reinvoice only works with Pay Only and Charge Only.
The system automatically creates three new timesheets showing the reversal of the incorrect hours (adjusted ones and non adjusted ones) and the addition of the correct hours (adjusted ones and non adjusted ones). The adjustment will impact on all the timesheets linked in invoice.
The system automatically creates a new negative timesheet to negate the original:
It also creates a new timesheet with the correct hours:
Similarly, it will create negative and positive timesheets for other timesheets invoices.
If you chose the Process Invoicing option, the negative timesheet will have a credit note against it and the adjustment timesheet will have an invoice
New Invoice:
Credit Invoice:
