One moment please...
 
 
Exact Financials   
 

Connectivity Manual - Financial entries (Exact Financials format)

A = All journal types
S = Sales
C = Cash
I = Giro
P = Purchase
B = Bank
G = General

File name: fentry.csv

No Field name Type Format H/S/B Ref. Description Remarks Default Jrnl
1 line-nr INT N4 B   Line number Mandatory - A
2 adm-nr INT N6 H eadmin Company number - * A
3 fin-yr INT N4 H   Financial year - * A
4 period INT N3 H   Period - * A
5 journal-nr INT N3 H journl Journal number - * A
6 entry-nr INT N8 B   Entry number - * A
7 date DATE DDMMYYYY B   Date - * A
8 descr CHAR A25 B   Description - - A
9 acc-nr CHAR A9 S ledger Account Mandatory - A
10 debtor INT N8 B debtor Debtor - - SCBIG
11 creditor INT N8 B credit Creditor - - PCBIG
12 curr-code CHAR A3 B curren Currency - * A
13 EXTRA-exch-rate-type INT N1 H   Exchange rate type 0/1 * A
14 exch-rate DEC N5,6 B   Exchange rate - * A
15 amt-curr DEC N15,2 B   Amount in currency Mandatory - A
16 vat-code CHAR A3 S vattrs VAT code - * SPCBI
17 vat-amt-curr DEC N15,2 S   VAT amount in currency - - SPCBI
18 rev-entry LOG Y/N B   Reversal entry - No A
19 cost-center CHAR A8 S ccent Cost center - - A
20 cost-unit CHAR A8 S cunit Cost unit - - A
21 qty DEC N10,2 S   Quantity - - A
22 mcode1 CHAR A8 S mdim1 Multi dimension 1 - - A
23 mcode2 CHAR A8 S mdim2 Multi dimension 2 - - A
24 mcode3 CHAR A8 S mdim3 Multi dimension 3 - - A
25 mcode4 CHAR A8 S mdim4 Multi dimension 4 - - A
26 mcode5 CHAR A8 S mdim5 Multi dimension 5 - - A
27 nature-movement CHAR A8 S boenom Nature of movement - - B
28 PRO-cost-center CHAR A8 S ccent Project cost center - - A
29 PRO-cost-cat-code CHAR A8 S prccat Project cost category - - A
30 PRO-project-code CHAR A8 S prmst Project code - - A
31 PRO-description CHAR A30 S   Project description - - A
32 PRO-result-type INT N6 S   Project result type 400501/400502 * A
33 pay-ref CHAR A20 B   Payment reference - - A
34 due-date-invoice DATE DDMMYYYY B   Due date invoice 1 - * A
35 due-date-surch-1 DATE DDMMYYYY B   Due date payment charge/discount 1 - * A
36 surch-disc INT N1 B   Payment charge/discount 1/2 * A
37 amt-credit-surch-1 DEC N15,2 B   Amount payment charge/discount 1 - * A
38 invoice-nr INT N8 S   Invoice number - * CBIG
39 diff-code INT N2 S   Difference code 1/2/3/4/5 * CBIG
40 pay-method INT N1 B   Payment method 1/2/3/4/5/6/7/8/9/10/11 * A
41 pay-condition CHAR X(4) B paycon Payment condition - * A
42 EXTRA-paycon-calc LOG Y/N H   Calculation payment condition 0/1 * SP
43 amt-acc-nr-blocked DEC N15,2 H   Amount blocked account - * SP
44 amt-credit-surch-2 DEC N15,2 B   Amount payment charge/discount 2 - * A
45 amt-credit-surch-3 DEC N15,2 B   Amount payment charge/discount 3 - * A
46 amt-credit-surch-4 DEC N15,2 B   Amount payment charge/discount 4 - * A
47 amt-credit-surch-5 DEC N15,2 B   Amount payment charge/discount 5 - * A
48 due-date-surch-2 DATE DDMMYYYY B   Due date payment charge/discount 2 - * A
49 due-date-surch-3 DATE DDMMYYYY B   Due date payment charge/discount 3 - * A
50 due-date-surch-4 DATE DDMMYYYY B   Due date payment charge/discount 4 - * A
51 due-date-surch-5 DATE DDMMYYYY B   Due date payment charge/discount 5 - * A
52 perc-1 DEC N3,2 H   Percentage 1 - * SP
53 perc-2 DEC N3,2 H   Percentage 2 - * SP
54 perc-3 DEC N3,2 H   Percentage 3 - * SP
55 perc-4 DEC N3,2 H   Percentage 4 - * SP
56 perc-5 DEC N3,2 H   Percentage 5 - * SP
57 empty - - - - - - - SP
58 invoice-nr-type INT N2 S   Invoice number type 1/3 * CBIG
59 curr-code-extra CHAR A3 S curren Currency code outstanding item - * CBIG
60 exch-rate-2 DEC N5,6 S   Exchange rate outstanding item - * CBIG
61 amt-curr-extra DEC N15,2 S   Amount outstanding item - * CBIG
62 EXTRA-journal-type INT N2 H   Journal type 1/2/3/4/7/8 * A
63 open-bal DEC N15,2 H   Opening balance - * CBI
64 final-bal DEC N15,2 H   Closing balance - * CBI
65 nr_periods_allocation INT N3 S   Number of allocation  periods - 0 A
66 start_year_allocation INT N4 S   Start year for period allocation - * A
67 start_period_allocation INT N3 S   Starting allocation period - * A

Clarification of the fields:

Field Clarification
1 0 for a headline, >0 for sub lines (1 for the first line, 2 for the second line etc.)
2 Enter a valid company number, if this field is left empty the current company will be used
3 If this field is left empty, the default financial year will used
4 If this field is left empty, the default period of the date field (field 6) will be used, according the date/period table is used from the date field
5 If this field is left empty, the EXTRA-journal-type (field 62) must be filled In that case the first available journal of the entered journal type will be used.
6 If this field is left empty, a new entry number is generated. Only used for Cash journal
7 If this field is left empty, the system date will be used. Not applicable in sales and purchase entries.
10 Only needed if acc-nr (field 8) is linked to a sales journal (debtor outstanding item), otherwise ignored. Only used in the sales journal
11 Only needed if acc-nr (field 8) is linked to a purchase journal (creditor outstanding item), otherwise ignored. Only used in the purchase journal.
12 If not given the default currency is used
13 If you want to use Anglo-Saxon notation (Euro notation) for exchange rates you should enter 1, if you want to use the 'old' exchange rate enter 0. If this field is left empty, the settings you defined in the financial preferences in [Finance: File, Company settings, Financial preferences] on the 'Miscellaneous' tab will be used.
14 If this field is left empty, the rate of the day is used (field 7). Type is depending on the EXTRA-exch-rate (field 13) in the header line.
16 If this field is left empty, '0' is filled (no vat). The VAT amount (field 17) is inclusive or exclusive the amount (field 15) according the definition in Exact (See: Maintenance VAT codes).
18 Default is no
32 If this field is left empty, it will automatically be filled according the given amount and journal type (field 5) in the header.

400501 = Expenses
400502 = Revenues

The field value is determined as follows:

If the journal type is purchase or general journal, the default will be expenses. If the journal type is sales, cash or bank, then the default will be revenue. If the journal type is not sales or purchase and the amount is <0 then the type will be reversed (rev to exp, exp to rev). If this field is filled with a type that does not match the default, the project amount will be reversed. (neg. to pos., pos. to neg.).
34 If this field is left empty, then a due date is calculated according the date (field 7) and the payment condition (field 41).
35 If EXTRA-paycon-calc (field 42) is Y then it will be automatically filled.
36 1 = Surcharge
2 = Discount

If this field is left empty, Surcharge (1) is used and if EXTRA-paycon-calc (field 42) is Y then the default is taken from the payment condition.
37 If EXTRA-paycon-calc (field 42) is Y then this field will automatically be filled
38 Invoice number of the outstanding item. If invoice-nr-type( field 58) is prepayment(3) and this field is left empty, then the first free number will be used.
39 1 = Do not write off
2 = Discount
3 = Surcharge
4 = Difference in payment
5 = Combination

If this field is left empty, 1 (do not write off) is used.
40 If not specified then the payment method linked to the debtor (field 10) or creditor (field 11) is used.

1 = Cash
2 = Bank
3 = Giro
4 = Collection
5 = Acceptgiro
6 = Cheques
7 = BACS
8 = Remittance
9 = Bill of Exchange
10 = Bill of Exchange bank
11 = Periodic Collection
41 If this field is left empty, the payment condition linked to the debtor (field 10) or creditor (field 11) will be used, if no payment condition is linked to the debtor or creditor, the payment condition of the financial preferences will be used.
42 If set to Y then the payment calculation according to the given payment condition will be used.
44 If EXTRA-paycon-calc (field 42) is Y, then this field will be filled automatically.
45 If EXTRA-paycon-calc (field 42) is Y, then this field will be filled automatically.
46 If EXTRA-paycon-calc (field 42) is Y, then this field will be filled automatically.
47 If EXTRA-paycon-calc (field 42) is Y, then this field will be filled automatically.
48 If EXTRA-paycon-calc (field 42) is Y, then this field will be filled automatically.
49 If EXTRA-paycon-calc (field 42) is Y, then this field will be filled automatically.
50 If EXTRA-paycon-calc (field 42) is Y, then this field will be filled automatically.
51 If EXTRA-paycon-calc (field 42) is Y, then this field will be filled automatically.
52 If EXTRA-paycon-calc (field 42) is Y, then this field will be filled automatically.
53 If EXTRA-paycon-calc (field 42) is Y, then this field will be filled automatically.
54 If EXTRA-paycon-calc (field 42) is Y, then this field will be filled automatically.
55 If EXTRA-paycon-calc (field 42) is Y, then this field will be filled automatically.
56 If EXTRA-paycon-calc (field 42) is Y, then this field will be filled automatically.
58 Type of invoice

1 = Normal
3 = Prepayment

If this field is left empty, 1 (normal) is used.
59 The currency code of the outstanding item. If this field is left empty, the currency code is taken from the outstanding item. This field is only used if an existing outstanding item is modified NOT if a new outstanding item is created, then it will be ignored.
60 The exchange rate of the outstanding item (type is according the EXTRA-exch-rate-type field 13 of the header). Field curr-code-extra (field 59) must be filled otherwise, this field will be ignored
61 The amount in the currency of the outstanding item. Field curr-code-extra (field 59) must be filled, otherwise this field will be ignored.
62 If journal (field 5) is not filled then this field will be used to find the journal according the given type (always the lowest journal number).

1 = Cash journal
2 = Bank journal
3 = Giro journal
4 = General journal
7 = Purchase journal
8 = Sales journal
63 If this field is left empty, for cash journal 0 is used and for Bank and Giro journal the final-bal from the last financial entry.
64 If this field is left empty, the final balance will be calculated.

Connectivity > Data import > Available import formats > Finance > Financial entries (Exact Financials format)

     
 Main Category: Support Product Know How  Document Type: Support - On-line help
 Category: On-line help files  Security  level: All - 0
 Sub category: Details  Document ID: 18.324.800
 Assortment: Exact Financials  Date: 19-06-2015
 Release:  Attachment:
 Disclaimer

Attachments
fentry.csv 1.3 KB Download