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:-
Column | Field | Type | Size | Validation | Precision | Import Type |
A | Transaction Type | text | 2 | BP, BR, CP, CR, JC, JD, PA, PC, PI, SA, SC, SI, VP, VR |
| Standard/Extended |
B | Sales/Purchase/Bank Account Ref | text | 8 | Look up |
| Standard/Extended |
C | Nominal Code | text | 8 | Look up |
| Standard/Extended |
D | Department Number | Int | 3 | 1-999 |
| Standard/Extended |
E | Transaction date | Date | 10 | Date | Xx/xx/xxxx | Standard/Extended |
F | Transaction (invoice) ref | Text | 30 |
|
| Standard/Extended |
G | Transaction detail | Text | 60 |
|
| Standard/Extended |
H | Net Amount | Decimal | 11 |
| 8 digits + 2d.p | Standard/Extended |
I | Tax code | Int | 3 | T0-T99 |
| Standard/Extended |
J | Tax amount | Decimal | 11 |
| 8 digits + 2d.p | Standard/Extended |
K | Exchange rate | Decimal | 11 |
|
| Extended |
L | Extra Ref | Text | 30 |
|
| Extended |
M | Username | text | 32 |
|
| Extended |
Sage 200
Sample InTime Output File
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 |
Xero
Example Client Portal Output File