Mobilefish.com - Online SEPA XML message generator for business payments orders and direct debits orders help

Online SEPA XML message generator for business payments orders and direct debits orders help

Setting

Remark

CSV data

After you have converted an Excel file into a CSV file, you must upload the data. If you use the Firefox 3.6 or Google Chrome 7.0 browser you can load the CSV file using the "Upload the CSV file" functionality. With other browsers, this functionality is not shown. In the latter case you must open the CSV file with the Notepad program and then copy the entire content. Then paste the content into the CSV data entry field.

The CSV data contains one or more lines which are called items.

CSV data example with 2 items:

Greenpeace;5.00;NL31INGB0000000044;INGBNL2A;1234-4321-5678-8765;

Greenpeace Donation;Jollemanhof 15-17;1019 GW Amsterdam
Bakkerij Top;135.20;NL91ABNA0417164300;ABNANL2A;;

Jubilee Klaasen;Zuiddijk 17;1501 CA Zaandam

The CSV data can contain the following information:

Name payer / name beneficiary (Max 70 characters)
The name payer / name beneficiary is mandatory.
For business payments, it is the beneficiary name.
For direct debits, it is the payers name.
Amount (Max 999999999999999999 euros)
The amount is mandatory and all amounts are in the Euro currency.
You can use the point or the comma as the decimal separator.

Examples:
- 1367,10 is correct
- 1367.10 is correct
- 23 is correct
- 0,23 is correct
- 23,1 is correct
- 573,12345 is correct
- 23, is correct
- ,23 is correct
IBAN number (Max 34 characters)
The IBAN (International Bank Account Number) is mandatory.

Examples:
- NL91ABNA0417164300
- BE68539007547034
- DE89370400440532013000
For business payments, it is the beneficiary IBAN number.
For direct debits, it is the payers IBAN number.
Payment reference (Max 25 characters).
The payment reference is optional.

Example:
1234-1234-1234-1234 or
RF 70 1234 1234 1234 1234
Description (Max 140 characters).
The description is optional.
If both payment reference and description is specified then these values are joined together with a space as a separator.

Example:
Payment reference = "1234-1234-1234-1234"
Description = "Energy bill March"

The complete description is: "1234-1234-1234-1234 Energy bill March" (Max 140 characters)
Street and number payer / Street and number beneficiary (Max 70 characters)
Street and number is optional.
Zip and place payer / Zip and place beneficiary (Max 70 characters)
The zip and place is optional.

This online service has set the following limits:

Up to 350 items per batch.
The SEPA XML file can contain up to 2 batches.

The characters you can use in the "name payer / name beneficiary", "payment reference", "description", "street and number payer / street and number beneficiary" and "zip and city payer / zip and city beneficiary" can be found below.

The following characters are allowed:

Character	Description
A - Z	upper case
a - z	lower case
0 - 9	digits
	space
.	full stop
(	left bracket
)	right bracket
+	plus
:	colon
-	hyphen
/	slash
,	comma
?	question mark
'	single quotation mark

If you use other characters they will be converted using the character conversion table below.

From		To
ASCII value	Character	ASCII value	Character
32		32
33	!	32
34	"	32
35	#	32
36	$	32
37	%	32
38	&	32
39	'	39	'
40	(	40	(
41	)	41	)
42	*	32
43	+	43	+
44	,	44	,
45	-	45	-
46	.	46	.
47	/	47	/
48	0	48	0
49	1	49	1
50	2	50	2
51	3	51	3
52	4	52	4
53	5	53	5
54	6	54	6
55	7	55	7
56	8	56	8
57	9	57	9
58	:	58	:
59	;	32
60	<	32
61	=	32
62	>	32
63	?	63	?
64	@	32
65	A	65	A
66	B	66	B
67	C	67	C
68	D	68	D
69	E	69	E
70	F	70	F
71	G	71	G
72	H	72	H
73	I	73	I
74	J	74	J
75	K	75	K
76	L	76	L
77	M	77	M
78	N	78	N
79	O	79	O
80	P	80	P
81	Q	81	Q
82	R	82	R
83	S	83	S
84	T	84	T
85	U	85	U
86	V	86	V
87	W	87	W
88	X	88	X
89	Y	89	Y
90	Z	90	Z
91	[	32
92	\	32
93	]	32
94	^	32
95	_	32
96	`	32
97	a	97	a
98	b	98	b
99	c	99	c
100	d	100	d
101	e	101	e
102	f	102	f
103	g	103	g
104	h	104	h
105	i	105	i
106	j	106	j
107	k	107	k
108	l	108	l
109	m	109	m
110	n	110	n
111	o	111	o
112	p	112	p
113	q	113	q
114	r	114	r
115	s	115	s
116	t	116	t
117	u	117	u
118	v	118	v
119	w	119	w
120	x	120	x
121	y	121	y
122	z	122	z
123	{	32
124	\|	32
125	}	32
126	~	32
127		32
128	€	69	E
129		32
130	‚	32
131	ƒ	102	f
132	„	32
133	…	32
134	†	32
135	‡	32
136	ˆ	32
137	‰	32
138	Š	83	S
139	‹	32
140	Œ	32
141		32
142	Ž	90	Z
143		32
144		32
145	‘	32
146	’	32
147	“	32
148	”	32
149	•	32
150	–	32
151	—	32
152	˜	32
153	™	32
154	š	115	s
155	›	32
156	œ	32
157		32
158	ž	122	z
159	Ÿ	89	Y
160		32
161	¡	105	i
162	¢	99	c
163	£	32
164	¤	32
165	¥	32
166	¦	32
167	§	32
168	¨	32
169	©	32
170	ª	32
171	«	32
172	¬	32
173		32
174	®	32
175	¯	32
176	°	32
177	±	32
178	²	32
179	³	32
180	´	32
181	µ	32
182	¶	32
183	·	32
184	¸	32
185	¹	32
186	º	32
187	»	32
188	¼	32
189	½	32
190	¾	32
191	¿	32
192	À	65	A
193	Á	65	A
194	Â	65	A
195	Ã	65	A
196	Ä	65	A
197	Å	65	A
198	Æ	32
199	Ç	67	C
200	È	69	E
201	É	69	E
202	Ê	69	E
203	Ë	69	E
204	Ì	73	I
205	Í	73	I
206	Î	73	I
207	Ï	73	I
208	Ð	32
209	Ñ	78	N
210	Ò	79	O
211	Ó	79	O
212	Ô	79	O
213	Õ	79	O
214	Ö	79	O
215	×	32
216	Ø	79	O
217	Ù	85	U
218	Ú	85	U
219	Û	85	U
220	Ü	85	U
221	Ý	89	Y
222	Þ	32
223	ß	32
224	à	97	a
225	á	97	a
226	â	97	a
227	ã	97	a
228	ä	97	a
229	å	97	a
230	æ	32
231	ç	99	c
232	è	101	e
233	é	101	e
234	ê	101	e
235	ë	101	e
236	ì	105	i
237	í	105	i
238	î	105	i
239	ï	105	i
240	ð	111	o
241	ñ	110	n
242	ò	111	o
243	ó	111	o
244	ô	111	o
245	õ	111	o
246	ö	111	o
247	÷	32
248	ø	111	o
249	ù	117	u
250	ú	117	u
251	û	117	u
252	ü	117	u
253	ý	121	y
254	þ	32
255	ÿ	121	y