One moment please...
 
 
Exact Financials   
 

Connectivity Manual - General ledger accounts

Import name: grtbk.csv

Nr Field name Type Format Ref. Description Remarks Default
1 adm-nr INT N6 admdat Company - -
2 acc-nr CHAR A9 - Account Mandatory *
3 descr CHAR A30 - Description - -
4 search-code CHAR A9 - Search code Mandatory -
5 bal-sht-pl CHAR A1 - Balance sheet/P&L P/B P
6 deb-cred CHAR A1 - Debit/Credit D/C Credit
7 subtotal-acc CHAR A1 - Subtotal account J/N/L No
8 comp-code CHAR A3 comp Sub-classification - -
9 vat-code CHAR A3 vattrs VAT code - 0
10 acc-nr-project LOG J/N - Project account - No
11 acc-nr-cost-center LOG J/N - Cost center account - No
12 acc-nr-cost-unit LOG J/N - Cost unit account - No
13 qtys LOG J/N - Quantities - No
14 acc-nr-revenue CHAR A1 - Type of account J/O/N/K Neutral
15 block LOG J/N - Block - No
16 revalue LOG J/N - Revalue - No
17 compress LOG J/N - Compress - No
18 acc-nr-mdim LOG J/N - Multi Dimension Account - No
19 assets-acc LOG J/N - Assets account - No
20 acc-nr-cheques-be LOG J/N - Cheques/BE account - No
21 descr-ml-1 CHAR A30 - ML description 1 - -
22 descr-ml-2 CHAR A30 - ML description 2 - -
23 descr-ml-3 CHAR A30 - ML description 3 - -
24 descr-ml-4 CHAR A30 - ML description 4 - -
25 descr-ml-5 CHAR A30 - ML description 5 - -
26 perc-non-deduct-vat DEC N3,2 - Percentage non-deductible VAT. - -
27 acc-nr-non-deduct-vat CHAR A9 ledger Non-deductible VAT account. - -
28 acc-nr-type INT N1 - Type purchase VAT return. 1/2/3/4/5 Goods
29 note CHAR A2000 - Note - -

Clarification of the fields:

Field Clarification
1 This field is only a part of the import format, when the option 'Company number' is enabled. When this option is not enabled, this field should be skipped.
2 Although this field is marked as character field it is only possible to enter digits, for example 000010123.
5 'B' for balance sheet account, 'P' for Profit & Loss account.
6 'D' for debit account and 'C' for credit account. This indicates whether a general ledger account is a debit or a credit account.
7 'J' for Yes and 'N' for No, 'L' for empty. A subtotal account is only used for displaying purposes.
10 'J' for Yes and 'N' for No. Enter 'J' if you want to use this account in a link with Exact Project.
11 'J' for Yes and 'N' for No. Enter 'J' if you want to use this account as a cost center account.
12 'J' for Yes and 'N' for No. Enter 'J' if you want to use this account as a cost unit account.
13 'J' for Yes and 'N' for No. If you want to be able to enter quantities on this account, you should enter 'J' here.
14 This field can contain the following formats:

J: Yes (imported as turnover account)
O: Turnover account (imported as turnover account)
N: Neutral account
K: Cost account
15 'J' for Yes and 'N' for No. This option can be used to prevent an entry being made on a particular account.
16 'J' for Yes and 'N' for No. If you want to use this account for revaluation, you should enter 'J' here.
17 'J' for Yes and 'N' for No. If you want to enable this option, you should enter 'J' here.
18 'J' for Yes and 'N' for No. If you want to enable this option, you should enter 'J' here.
19 'J' for Yes and 'N' for No. If you want to enable this option, you should enter 'J' here.
20 'J' for Yes and 'N' for No. If you want to enable this option, you should enter 'J' here.
28 Non-deductible VAT account:
  1. Goods
  2. Services
  3. Investments
  4. No VAT update
  5. Always VAT update
Connectivity > Data import > Available import formats > Finance > General ledger accounts

 

     
 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.323.898
 Assortment: Exact Financials  Date: 02-10-2015
 Release:  Attachment:
 Disclaimer