Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 17 Next »

You can upload timesheet data from a spreadsheet, by copying and pasting the spreadsheet's cells directly into InTime.

The standard InTime format is shown below. InTime also has the facility to import timesheet data from 3rd party systems. In order to do this an Import format must be created and configured to suit the data you wish to import.Whilst we have existing formats available, our experience is that these formats can differ. Any amendment and testing work which may be required would be charged on a time fee basis. We therefore recommend sample files are provided for analysis.

InTime Standard Format
Placement, Rate, Date, Unit, Comment
  • Placement: This should be the reference code for the placement (for example 'JB001').
  • Rate: This should be the exact name of the rate, as it appears in the timesheet (for example 'Day Rate').
  • Date: The day for which the timesheet data is being entered. The date format is dd/mm/yyyy (for example '18/05/2015').
  • Unit: The number of units that the contractor worked. For example, if the rate is 'Day Rate', you might enter '1'.
  • Comment: Any comment that you want to include for the entry.

When you enter timesheet data using this method, the timesheet will automatically be submitted and follow the approval route that has been set for the placement.

Add data to existing timesheets

Typically, you will use this method to submit complete timesheets. However, you can also use this method to enter data in timesheets that have already been submitted.

For example, a contractor might have worked an additional shift in a day, and you want to enter that information into his or her timesheet. If so, you would select the Add data to existing timesheets checkbox on the Upload Timesheet Data screen.

Note: If you select the option to add data to an existing timesheet, the timesheet entries that you import will be added to an existing timesheet even if that entry already exists in the timesheet. For example, if the timesheet already has an entry for 8 hours against the 12th May, and your spreadsheet data includes a duplication of this entry, this will result in the timesheet including an entry for 16 hours on the 12th May.

How do I import my timesheet data from a spreadsheet?

  1. From the menu bar, click  Batch>Import Timesheet.
  2. From the Format list, and select the format.
    Ensure that the format of your spreadsheet data adheres to the Standard import format. If you require a specific import format to be configured for you, please contact the RSM ESL support team (although please note that you may be charged for the configuration of a bespoke import format).
  3. Copy and paste your spreadsheet data into the form:

     
     
  4. If you are adding data to an existing timesheet, select Add data to existing timesheets.
    Note the on-screen warning that this will add data to a timesheet even if the data is duplicated.
  5. Click Upload.
    You are then given the opportunity to review the imported data.
  6. If you need to change any of the fields that you imported (placement, rate, date, unit and comment), click the cell and amend the entry. If you want to change the placement or worker name, begin typing the name of the placement or worker and InTime will offer auto-completion suggestions. If the imported data does not match the import format, the cell displays the 'undefined' message. You can amend the cells accordingly, or return to the import screen by clicking Start Again, amending your imported data, and trying again.
  7. If your data has been imported correctly, click Submit.
  8. A message asks you to confirm that you want to submit the data. Click OK and the import process begins.
    A message appears when the import process has been completed successfully.
  • No labels