...
There are various export modes available for Sage 50 as described below. This export provides you with CSV files that can be uploaded into Sage. Where RSM InTime is used to process payments, payment lines will also be included in the export file.
| Mode | Description |
|---|---|
| One line per invoice | Each invoice is exported as a single line. |
| By Pay Element |
| One line is exported for each pay element. | |
| By Sheet | One line exported per timesheet or expense item |
| By Worker | One line exported per worker |
Sample RSM InTime Sage 50 export file - sage50_InTimeSample.csv.
Sage 50 Specification:-
| RSM InTime Field Mapped |
Column | Field | Type | Size | Validation | Precision | Import Type | |
sc = Client Credit, si = Sales Invoice, pc = Purchase Credit pi = Purchase Invoice, pa = Purchase payment line, pr = Purchase Credit payment line | → | A | Transaction Type | text | 2 | BP, BR, CP, CR, JC, JD, PA, PC, PI, SA, SC, SI, VP, VR |
Standard/Extended | ||||||
| Accounts Ref of the Client/Worker/Provider | → | B | Sales/Purchase/Account Ref | text | 8 | Look up |
Standard/Extended | ||||||
Sales: Timesheets - Nominal code on the client, Expenses: NominalCode on the expense type Purchase: Timesheet and Expenses Nominal code are on the worker or provider (depending who the invoice is for) Payment lines: value from 'Sage50PANominalCode' config. VAT only invoices value from 'Export.Sage50.VatOnlyNominal' config. | → | C | Nominal Code | text | 8 | Look up |
Standard/Extended | ||||||
Placement Purchase Cost Centre if it is the same for all placements. Left blank and creates warning if they differ. The value from the placement can be mapped to alternative values with the 'SageDepartmentMapping' config. Value of the 'ConsultantDepartmentNo' Tag on the Placement Consultant. 'ConsultantDepartmentNoOverride' config. | → | D | Department Number | Int | 3 | 1-999 |
Standard/Extended | ||||||||
| Invoice date | → | E | Transaction date | Date | 10 | Date | Xx/xx/xxxx | Standard/Extended |
| Invoice number | → | F | Transaction (invoice) ref | Text | 30 |
Standard/Extended | |||||
| limited to 60 characters | → | G | Transaction detail | Text | 60 |
Standard/Extended | |||||
| Net amount | → | H | Net Amount | Decimal | 11 |
8 digits + 2d.p | Standard/Extended | |||||
| Invoice VAT Code. "T" prefix removed if in AccPacc mode | → | I | Tax code | Int | 3 | T0-T99 |
Standard/Extended | |||||
| VAT amount | → | J | Tax amount | Decimal | 11 |
8 digits + 2d.p | Standard/Extended | ||||
| Exchange Rate between Invoice currency and Base currency | → | K | Exchange rate | Decimal | 11 |
Extended | |||||
| Blank (COLUMN ONLY APPEARS WITH PROJECTS MODE ENABLED) | → | L | Extra Ref | Text | 30 |
Extended | |||||
| Blank (COLUMN ONLY APPEARS WITH PROJECTS MODE ENABLED) | → | M | Username | text | 32 |
Extended | ||||
| Placement Sales Project (COLUMN ONLY APPEARS WITH PROJECTS MODE ENABLED) | → | N | projectRef | Text |
| Extended | ||||
| 'Export.Sage50.timesheetCostCode' value if configured and exporting a timesheet otherwise the Shift/Expense Item Pay Element Code (COLUMN ONLY APPEARS WITH PROJECTS MODE ENABLED) | → | O | costCode | Text |
| Extended |
If you require the sage 50 exporter to have the projects mode enabled please contact support.
Sage 200
Sample RSM InTime Output File
...
Note: Contained within RSM InTime 4.7.1 revision 35839 and above - The Sage 200 export now supports the following export modes:-
| Mode | Description |
|---|---|
| By Sheet | One line exported per timesheet or expense item |
| By Pay Element | Once line is exported for each pay element. |
| By Worker | One line exported per worker |
| By Rate | One line exported per rate |
Default values
| RSM InTime Field Mapped |
|---|
| Field | Value | Size | Example |
|---|
| Client/Worker/Provider Accounts Ref | → | AccountNumber | Client Accounts Ref | 8 | TC0001 |
| Value from 'CashBookAccountNumber' property otherwise "CashBookAcc" | → | cashBookAccountNumber |
| 8 | ||
| Blank | → | daysDiscountValid |
| Integer | ||
| Blank | → | discountValue |
| Decimal | ||
| Blank | → | discountPercentage |
| Decimal |
| Invoice Due Date | → | dueDate |
| dd/mm/yyyy | ||
| Gross amount in Client/Worker/Provider default currency | → | goodsValueInAccountCurrency |
| Decimal | ||
| Gross amount in Agency Base currency | → | saleControlnValueInBaseCurrency |
| Decimal | ||
| Exchange rate between Invoice currency and Agency Base currency | → | documentToBaseCurrencyRate |
| Decimal | ||
| Exchange rate between Invoice currency and Client/Worker/Provider default currency | → | documentToAccountCurrencyRate |
| Decimal |
Invoice Date | → | postedDate |
| dd/mm/yyyy | ||
| Blank | → | queryCode |
| 2 | |||||
| Invoice Number | → | transactionReference | Invoice Number | 20 | CI-00001 |
| Blank | → | secondReference |
| 20 | |||
1 = Sales, 2 = Purchase | → | source | 1 = sales, 2 = Purchase |
| Integer | |||
2 = Payment line, 4 = Invoice, 5 = Credit Note | → | sYSTraderTranType | 4 = Invoice, 5 = Credit, 2 = Payment |
| Integer | ||
| Invoice Date | → | transactionDate |
| dd/mm/yyyy | ||
| Blank | → | uniqueReferenceNumber |
| Integer |
| Value from 'Sage200UserNumber' property otherwise "123" | → | userNumber |
| Integer | ||
| VAT amount | → | taxValue |
| Decimal | ||
| Blank | → | sYSTraderGenerationReasonType |
| Integer |
| Gross amount in Agency Base currency | → | goodsValueInBaseCurrency |
| 13 | ||
| Net amount | → | nominalAnalysisTransactionValue1 |
| Decimal | |||||
Sales: Expenses: Nominal code from Expense Template Timesheets: Client Nominal Code Purchase: Expenses: Expenses Nominal code for Worker/Provider Timesheets: Nominal Code for Worker/Provider | → | nominalAnalysisNominalAccountNumber1 | Client Time/Expenses Nominal Code | 8 | 4001 |
| Placement Sales/Purchase Cost Centre if the same for all placements or 'SalesCostCentre'/'PurchaseCostCentre' if all empty. | → | nominalAnalysisNominalCostCentre1 | placement Sales CostCentre |
| 3 | |||
| Placement Sales/Purchase Department if the same for all placements or 'SalesDept'/'PurchaseDept' if all empty. | → | nominalAnalysisNominalDepartment1 | placement Sales Department |
| 3 | |||||
| Can be overridden with a script in the 'Sage200TransDetailScript' config. | → | nominalAnalysisNominalAnalysisNarrative1 | SI / SC <client name> | 60 | SI Test Client |
| Blank | → | nominalAnalysisTransactionAnalysisCode1 |
| 20 | ||
| Blank | → | nominalAnalysisTransactionValue2 |
| Decimal |
| Blank | → | nominalAnalysisNominalAccountNumber2 |
| 8 |
| Blank | → | nominalAnalysisNominalCostCentre2 |
| 3 | ||
| Blank | → | nominalAnalysisNominalDepartment2 |
| 3 |
| Blank | → | nominalAnalysisNominalAnalysisNarrative2 |
| 60 | ||
| Blank | → | nominalAnalysisTransactionAnalysisCode2 |
| 20 | ||
| Invoice VAT Code, "T" prefix removed of present. | → | taxAnalysisTaxRate1 |
| Integer |
| Net amount | → | taxAnalysisGoodsValueBeforeDiscount1 |
| Decimal | ||
| 0 | → | taxAnalysisDiscountValue1 |
| Decimal | ||
| 0 | → | taxAnalysisDiscountPercentage1 |
| Decimal | ||
| VAT amount | → | taxAnalysisTaxOnGoodsValue1 |
| Decimal | ||
| Blank | → | taxAnalysisTaxRate2 |
| Integer | ||
| Blank | → | taxAnalysisGoodsValueBeforeDiscount2 |
| Decimal | ||
| Blank | → | taxAnalysisDiscountValue2 |
| Decimal |
| Blank | → | taxAnalysisDiscountPercentage2 |
| Decimal |
| Blank | → | taxAnalysisTaxOnGoodsValue2 |
| Decimal |
Note: Contained within InTime 4.7.1 revision 35839 and above - The Sage 200 export now supports the following export modes:-
| Mode | Description |
|---|---|
| By Sheet | One line exported per timesheet or expense item |
| By Pay Element | Once line is exported for each pay element. |
| By Worker | One line exported per worker |
| By Rate | One line exported per rate |
Access Dimensions
...
Access Dimensions
If you have Access Dimensions you can benefit from system-to-system (API) integration between RSM InTime and the Access Dimensions platform.
For us to connect to your Access Dimensions system, we need:
- You need to purchase the Webservices API module from Access for your Dimensions system.
- You need to setup a URL (DNS), secured with an security certificate to access your Dimensions webservice.
- We require the below details to connect to your Dimensions system.
RSM InTime Required Information | Access Dimension Values |
AccessDimensionsUserID | |
AccessDimensionsPassword | |
AccessDimensionsDatabase (you may have multiple databases for separate legal entities for example) | |
AccessDimensionsSiteReference | |
AccessDimensionServer | |
AccessDimensionUserName | |
AccessDimensionWindowsAuth (This will be a yes or no answer whether your agency required Windows Authentication onto Access systems.) | |
AcessDimensionsDomain | |
AccessDimensionsLocation | |
AcessDimensionsVersion (either 1.3.6 or 1.3.7) |
Export to Access Dimensions - Covers Default mapping and typical export errors explained.
Twinfield
Clients who use our Twinfield accounting option benefit from system-to-system integration between RSM InTime and Twinfield.
Xero
Example Client Portal Output File
...
The AccountCode is set to one value for sales and one for purchase invoices in both files.
The difference between the two versions are the TrackingName1,TrackingOption1,TrackingName2, TrackingOption2, details
Note: The XERO exporter outputs a line per rate per timesheet on the invoice. This means will have multiple lines for an invoice if it includes multiple timesheets and / or rate on it.
Details of how these are set is below:-
Version 1:
AccountCode = 100 for sales, 200 for purchase
TrackingName1 = Always "Branch"
...
TrackingOption2 = From placement sales department financial tag
Version 2:
AccountCode = 100 for sales, 200 for purchase
TrackingName1 = Always "Client"
...
TrackingOption2 = From placement sales division financial tag
Version 3:
TrackingName1 = TBC
TrackingOption1 = TBC
TrackingName2 = TBC
TrackingOption2 = TBC
If you need anything other than the two versions above then we would would need to charge time and materials to customise the exporter to achieve your requirements.
Please submit your required accountCode, tracking details and export format, different from above, to us and we can quote to create this for you.
Netsuite
Please see this documentation page: RSM InTIME to Netsuite Integration