...
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 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. |
Sample InTime Sage 50 export file - sage50_InTimeSample.csv.
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
Xero
Sample Client Portal Output File