Split Costing on Excel Timesheet

Sometimes employees will work for different departments during a pay period. When this is a one-off or the hours are changeable from pay period to pay period, it can be useful to stipulate the costing on your Excel timesheet.
Any costing different to the employee's Home Costing needs to have a new line on the timesheet. This guide gives instructions on how to split a costing using Office 2013.

Select and copy the entire row of the relevant employee in your Excel timesheet then right-click on the row number directly below the relevant employee and select 'Insert Copied Cells' (If you are unable to make these changes, find Review in your Excel menu and click on Unprotect Sheet).

In the new row, enter the hours to be split into alternative Division/Cost Centre/Department and enter in the cost codes for Division, Cost Centre and Department these separate hours are to be costed to (you can check the codes under Cost Structure in the Costing ribbon in DataPay).
All codes must be entered fully and correctly. Even if only the department is different, still enter Division and Cost Centre codes.
The timesheet can then be imported as normal, and when viewing the employee pay packet you will be able to see the Split Costing icon.