Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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)

...

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 

...

ModeDescription
By SheetOne line exported per timesheet or expense item
By Pay ElementOnce line is exported for each pay element.
By Worker

One line exported per worker

By RateOne line exported per rate

Xero

Example Client Portal Output File

...