You can upload expense data from a spreadsheet, by copying and pasting the spreadsheet's cells directly into RSM InTime. When you enter expense data using this method, the expenses will automatically be submitted and follow the approval route that has been set for the placement. This can be done for timesheets as well, go to import timesheet data for further information.
The standard RSM InTime format is shown below. RSM InTime also has the facility to import expense and 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. If you wish to have the default import format applied or would like us to scope a format for you please contact our support team.
Standard expense import format details
Additional timesheet import formats
Importing expense dataAnchor Importing expense data Importing expense data
| Importing expense data | |
| Importing expense data |
From the top menu go to import/export and select import expenses.
...
You have the option to tick add data to existing expenses. Please note:the on-screen warning that this will add data to a expenses even if the data is duplicated, we would advise you to use this with caution and check the existing expense claim.
Using the box provided, paste your expense data. Ensure that the data you are pasting matches the format of the import selected.
When ready click upload and validate.
Review and validating data
...
Anchor Review and validating data Review and validating data
| Review and validating data | |
| Review and validating data |
You will see a table of your imported date, any issues are highlighted in red and a textual description of the issue is given in the Errorand displays undefined, an error message will be shown in the error column. See below for common issues.
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 placement reference or worker name and RSM InTime will offer auto-completion suggestions.
...
You can amend the cells accordingly, or if you decide some of the data should not be imported or can not be corrected on the review page, click
...
start again and change or exclude the unwanted data when pasting from your spreadsheet.
For units, monetary amounts, tax rate figures etc you can click in the cell and over key.
Alternatively, if you wish to not import some lines from the expense import, you can untick the boxes in the select column. This will allow you to only import the lines that are ticked.
Once you are happy with the
...
data, clicksubmit
...
to import the data and create or update the timesheets.
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.
Failed imports Anchor Failed imports Failed imports
| Failed imports | |
| Failed imports |
If the import was unsuccessful, you will not get the green progress line or if it only imported some of the lines will display something like saved items 5/10 instead of 10/10. You will get the ability to review these.
Common import issuesAnchor Common import issues Common import issues
| Common import issues | |
| Common import issues |
...
If the import format includes a
...
worker name or reference and not a placement but the worker has more than 1 active placement for the date entered the user will have to select which placement the time should be uploaded to.
Sometimes the imported
...
expense does not exist on the placement or it has been spelt differently
...
Add data to existing timesheets
Typically, you will use the Timesheet importer to submit complete timesheets. However, you can also use this method to enter additional data to 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.
RSM 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' or if the rate is 'Hourly Rate', you might enter '7.5' or'-7.5'. - Comment: Any comment that you want to include for the entry.
...
, if a particular expense template has been assigned to the placement this will need to mirror what is on the import.
Standard expense import format detailsAnchor Standard expense import format details Standard expense import format details
| Standard expense import format details | |
| Standard expense import format details |
Placement Ref - The ID for the placement.
Receipt Date - Standard date formats are accepted.
Expense Template - This needs to be as it appears on the expense template.
Description - free text box, for example for a mileage claim you may type: Driving to meeting.
Units - How many, for example, 1 train ticket. Or if mileage 35 for 35 miles.
Unit Net Rate - Net amount per unit.
Net - The net amount this will be units x the unit net rate.
Sales Tax Rate - e.g. enter 0 for zero rated or 20 for 20%.
Sales Tax - The amount of tax to be paid.
Gross - Total amount.
Additional timesheet import formats Anchor Additional timesheet import formats Additional timesheet import formats
| Additional timesheet import formats | |
| Additional timesheet import formats |
We can develop custom timesheet import formats to match a spreadsheet / CSV file received from an external system. If you can supply support with a sample file and answers to the questions below, we will review and confirm a quote to develop.
- Can we get the placement reference that matches RSM InTime?
...
- Where can I get the worker from? Reference that matches RSM InTime ideally, or full name that matches RSM InTime.
...
- What expense details can we get. Does it have the standard data matching our standard import?
- Any extra data in file you want imported into the timesheets? Why and to where?