Journal: GBAT10

The fields are separated by a semicolon, not a fixed column width. The figures specified under Max length indicate the maximum number of characters allowed in each field.

‘StdReg_xxx.xls’:‘StdReg_xxx.xls’: Read more in Default Values in Mamut Business Software.

Description	Column no.	Column in Excel	Max length	Comments	Required
Identification	0	A	6	Always: GBAT10	Yes
Journal number	1	B	8	Numeric (Used to separate journals from each other)
Journal date	2	C	8	Date (format: YYYYMMDD)	Yes
Journal type	3	D	3	Numeric (StdReg_xxx.xls)	Yes
Period	4	E	2	Numeric (no decimals)	Yes
Accounting year	5	F	4	Numeric (no decimals)	Yes
Account number	6	G	7	Numeric (no decimals)	Yes
VAT code	7	H	5	Numeric (StdReg_xxx.xls)	Yes
Balance	8	I	15	Numeric (to decimals)	Yes
Customer number	9	J	9	Numeric (no decimals) *For journal entries. Must be entered if the contact is new or if the existing name is to be overwritten	Yes*
Supplier number	10	K	9	Numeric (no decimals)	Yes*
Contact name	11	L	30	Text **Customer number must be entered if the comparison is based on numbers	Yes**
Address	12	M	200	Text
Postcode	13	N	30	Text
City	14	O	30	Text
Invoice number	15	P	25	Text
<not used>	16	Q	30	Text
Due date	17	R	8	Date (format: YYYYMMDD)
<not used>	18	S		The space/field must be used but the value can be blank
Bank account	19	T	20	Text
Ledger description	20	U	100	Text
Customer/Supplier description	21	V	100	Text
Factoring rate	22	W	1	Numerical: 1=No interest 2=Always 3=Only over 30 days
Project	23	X	6	Numeric (StdReg_xxx.xls) or blank for none
Department	24	Y	4	Numeric (StdReg_xxx.xls)
Payment terms	25	Z	4	Numeric (StdReg_xxx.xls)
Gross	26	AA	1	Blank, True (T) or False (F)
Gross sum	27	AB	20	Numeric (2 decimals)
IBAN	28	AC	50	Alphanumeric
SWIFT/BIC	29	AD	50	Alphanumeric

There are two alternative methods of importing VAT:

Import a specific VAT line for each journal
The VAT code must be set to 1 (no VAT deducted) on every line.
Do not populate the two final fields in the format (‘Gross’ and ‘Total Gross’).
The tax statement will then not be correct.
Import with Gross sum and let Mamut Business Software calculate the VAT journal entry.
This is the recommended method.
When using this procedure it is necessary to use the last two fields in the format. The first of these is set to T (True) or F (False) The other is numerical to three decimal places and shall contain the gross sum (including VAT). Here you can set the VAT code 1 on the 1100 lines and relevant VAT code on, for example, the 4000 lines.

Special notes for the Gross field:

This field can have one of the following 3 different statuses per journal entry:

<blank>	If blank, the line will be imported with the sum from the Balance field.
<T>	If set to T (True), the line will be imported with Total Gross (including VAT) from the field ‘Sum’ that follows directly after.
<F>>	Lines with a value of F (False) will not be imported. An example of this would be a specific VAT journal entry that will be ignored by the import.

Journal import:

When Skip over double invoice numbers when importing journals is crossed off, there is a risk that invoice numbers that are already in use will be copied (and, consequently, overwritten). The journals will be imported to journal registration and a journal list will be printed when the journals are posted to the nominal ledger.