Interface: FIBU - ASCII entries Version 2007.00

Counter, sequential number

'I' = Version 2003, 2004 or 2005, 'J' = Version 2006.20, 2007

Journal date

Account or cost type

Contra account or contra cost type

Entry text line 1

Entry amount and total debit for a multiple entry

Entry text line 2

D/C code, must contain 'D' or 'C'

Specify CC if a cost type is specified for item 4

Specify CCC if a cost type is specified for item 5

Document number

Exchange rate for entries with foreign currency

If foreign currency 'A' (A = automatic, M = manual, B = entered by hand)

Amount in foreign currency

Identification for collective entry C = Summarisation (summarised to total) V = Summarisation (debit/credit summarised separately.) S = Item

Only for internal ABACUS use

D = Account Receivable invoice
d = Account Receivable payment
K = Account Payable invoices
k = Account Payable transfers
L = Payroll
G = G/L Light
F = General Ledger
E = External entry
N = Project Management
! = Profit entry
C = Consolidation
U = Allocation entry
X = WorX
Y = Electronic Banking
Z = Overhead cost entry
M = Assets Ledger
B = PPS stocktaking
b = PPS material/service
O = ORDE stocktaking
o = ORDE expenses
I = Interest entry
W = Rate adjustment entry
l = Payroll Light
H = AbaBuild
h = AbaBuild
R = Debit position (AbaImmo)
r = Heating and incidental costs settlement (AbaImmo)
A = Settlement of fees (AbaImmo)
y = Electronic Banking
J = AbaNinja invoice
j = AbaNinja payment
V = MyAbacus
v = AbaPos
S = Project Management Old
' ' = Unknown

The value date is required for the interest calculation, but may not be filled in subsequently by the system with document date=value date.

Only if item 16 has 'C', 'V' or 'S' 

If item 16 = 'C' or 'V', the number of the corresponding items must be entered. If item 16 = 'S', the counter no. of the summarisation entry to which the individual items belongs must be entered.

3-digit ISO (ISO 4217) code for account currency, e.g. CHF, EUR, USD

3-digit ISO code for contra account currency, e.g. CHF, EUR, USD

Only if entry with cost types in quantity

Quantity * rate = amount

Booking level 2, cost unit level 2

Cost unit on 2nd level, contra cost unit on 2nd level

For cash flow statement fund 1 (on left account)

For cash flow statement fund 2 (on right account)

Entry code

Code according to the VAT table of the client

VAT rate

I = inclusive, E = exclusive

VAT method: 
0 = No VAT 
1 = Agreed 
2 = Collected

VAT country specified on the code (item 36) - according to VAT table. 
CH for Switzerland

VAT liability. Usually 100.00. Specify corresponding rate for VAT exclusive entries with partial liability.

The left account of the VAT entry

The right account of the VAT entry

VAT debit or credit 0 = No account is VAT account, 1 = Left account is VAT account, 2 = Right account is VAT account

VAT amount in local currency

VAT amount in foreign currency

1 = Sales tax 
2 = Input tax
3 = Services 
4 = Original production 
5 = Import ST/IT

Number of the corresponding division

'0' = Actual figure 
' ' = Actual figure 
'1' = Target figures

Intercompany division no. (consolidation)

2nd exchange rate for entries with foreign currency to foreign currency. Addition to item 13.

Consolidation code (intercompany code)

Booking level 3 project number

Booking level 3 contra project number