Exporting - What systems are supported?

RSM can provide exports to the following systems. If the samples do not match your requirement or you have a requirement for a format we do not list, please provide us with the import specification from your supplier for evaluation. Any development, amendment and testing work which may be required would be charged on a time cost basis.

Access Dimensions

Clients who have taken our Access Dimensions service benefit from system-to-system integration between InTime and our Access Dimensions platform.

Twinfield

Clients who use our Twinfield accounting option benefit from system-to-system integration between InTime and Twinfield.

Sage Line 50

We conform to the Sage CSV file structure (audit Trail Transactions)

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 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	Once 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 InTime Sage 50 export file - sage50_InTimeSample.csv.

Sage 50 Specification:-

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
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	→	L	Extra Ref	Text	30			Extended
Blank	→	M	Username	text	32			Extended
Placement Sales Project	→	N	projectRef	Text
'Export.Sage50.timesheetCostCode' value if configured and exporting a timesheet otherwise the Shift/Expense Item Pay Element Code	→	O	costCode	Text

Sage 200

Sample InTime Output File

Sage 200 Specification

Sage 200 Sales Example

Sage 200 Purchase Example

Default values

	Field	Value	Example
→	SYSTraderTranType	4 = Invoice, 5 = Credit, 2 = Payment
→	Source	1 = sales, 2 = Purchase
→	TransactionReference	Invoice Number	CI-00001
→
→	SALES TRANSACTIONS
→	AccountNumber	Client Accounts Ref	TC0001
→	NominalAnalysisNominalAccountNumber/1	Client Time/Expenses Nominal Code	4001
→	nominalAnalysisNominalAnalysisNarrative1	SI / SC <client name>	SI Test Client
→	nominalAnalysisNominalCostCentre1	placement Sales CostCentre
→	nominalAnalysisNominalDepartment1	placement Sales Department
→
→	PURCHASE TRANSACTIONS
→	accountNumber	worker Accounts Ref / Provider Accounts Ref	AW1234
→	nominalAnalysisNominalAccountNumber1	worker / provider nominal Code	5001
→	nominalAnalysisNominalAnalysisNarrative1	PI / PC <supplier name> <date> <item>	PI A.Worker 02/01/2016 TS-54321
→	nominalAnalysisNominalCostCentre1	placement Purchase CostCentre
→	nominalAnalysisNominalDepartment1	placement Purchase Department

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