Skip to main content

 

 

Coupa Success Portal

Account Statement Import - CSV Format

Format Description - Standard 27

PDF Version

# Name Type Mandatory Comment
1 Account Identification char - 50 Yes Field 25 in MT940
Unique for each account
(SWIFT or bank code/account no.)
2 Statement No. char - 12 Yes Field 28C in MT940
3 Starting Date date Yes Part of Field 60 in MT940
4 Starting Balance char - 50 Yes Part of Field 60 in MT940
5 Closing Date date Yes Part of Field 62 in MT940
6 Closing Balance   Yes Part of Field 62 in MT940
7 Value Date date Yes Subfield 1 in Field 61
8 Booking Date date Yes Subfield 2 in Field 61
9 Currency char - 3 Yes Part of Field 60 in MT940, currency as ISO code
10 Amount decimal Yes Negative amounts with leading minus (-)
11 SWIFT char - 11 No Part of Field 25 in MT940
12 BLZ char - 8 No Part of Field 25 in MT940
13 BC char - 3 No Part of Field 86 in MT940
14 BC Addendum char - 3 No Part of Field 86 in MT940
15 Payment Reference char - 255 No Key 20-29 in Feld 86
16 Order Reference char - 16 No Field 20 in MT940
17 Related Reference char - 16 No Field 21 in MT940
18 Booking Key char - 4 No Subfield 6 in Field 61
19 Reference in Transaction char - 16 No Subfield 7 in Field 61
20 Bank Reference char - 16 No Subfield 8 in Field 61
21 Original Amount char - 50 No Subfield 9 in Field 61
22 Prima Nota char - 10 No Key 10 in Field 86
23 Bank Code - Payer char - 15 No Key 30 in Field 86
24 Account Number - Payer char - 50 No Key 31 in Field 86
25 Name - Payer char - 100 No Key 32/33 in Field 86
26 Addenda to Payment Reference char - 100 No Key 60-63 in Field 86
27 Booking Text char - 27 No Key 00 in Field 86

Import Function

The import function is on Treasury > Cash ManagementEnter Account Statements.

In the Account Statement Format drop-down menu, select tm5 Standard 27.

The import function processes files in standard text formats:

  • ASCII
  • Unicode

Format Rules

The file may not contain any headers or format descriptions.

Each row in the file contains exactly one data set:

  • ASCII Code 13: carriage return denotes the end of a data set.
  • ASCII Code 10: new-line denotes the end of a data set.
  • The last data set concludes by an end-of-file (EOF).

In the table above, the value for “char” denotes how many characters is the maximum length for that field in the imported file.

Days and months are always 2-digit values, whereas years are 4 digits. The Enter Account Statements page allows you to define other format variables for the file:

  • Field Separator – semicolon (;), comma (,)
  • Date Separator – slash (/), period (.), comma (,), < none > 
  • Date Sequence – mdy, dmy, ymd
  • Decimal Marker – period (.), comma (,)
  • File Format – ASCII, Unicode

Example Data Sets

Empty fields are only marked by field separators. The sample dataset below contains empty fields.

DEUTESBB/001046581;023/01;01/14/2009;10500.40;01/15/2009;12700.00;

01/14/2009;01/14/2009;EUR;2000.00;;;;;;;;;;;;;;;;;

  • Was this article helpful?