SAP Multicash statement format

The SAP Multicash format is comprised of two (2) export formats:

Balances(AUSZUG.TXT)
Transactions(UMSATZ.TXT)

Both the balance and transaction exports must be imported into your general ledger system. The exports are complimentary.

Format overview

Field delimiters

Each field in the SAP Multicash file is delimited with a semicolon (;).

Record termination

Each record is terminated by a CR/LF end-of-line pair.

Leading zeros

All leading zeros within file extracts will be provided, including the following leading zeros;

Transaction Codes (e.g. 001, 099 etc).
Account Numbers (e.g. 032-000, 000007, 032000000016).

File specification

Balances

#	Field Name	Field Description / Characteristics	Data Format (length)	Mandatory / Optional
1	Bank Key	Populated with the BSB of the current account. For Example `032-000`	Alphanumeric (7)	Mandatory
2	Bank Account Number	Populated with the account number. For Example `136465`	Numeric (6)	Mandatory
3	Statement Number	Statement Number is represented as a date formatted as `YYNNN` where `NNN` is the Julian date. For Example `17002`	Numeric (5)	Mandatory
4	Statement Date	Statement Date formatted as `DD.MM.YY`	Date (8)	Mandatory
5	Currency	Currency code will be represented as a valid ISO 4217 currency code. For Example `AUD`	Alpha (3)	Mandatory
6	Opening Balance	Account Opening Balance. Signed amount formatted to 2 decimal places. For example: `13.41`, `-13.41`	Numeric	Mandatory
7	Debit Total	Sum of all debit transactions for the current statement represented as an absolute value.	Numeric	Mandatory
8	Credit Total	Sum of all credit transactions for the current statement.	Numeric	Mandatory
9	Closing Balance	Account Closing Balance. Signed amount formatted to 2 decimal places. For example: `13.41`, `-13.41`	Numeric	Mandatory
10	Bank Account Holder	Represents an alias for the current bank account. For example: `Receivables Account`	Alphanumeric	Optional
11	Special Account Name	Intentionally left blank	Empty	Omitted
12	Life Start	Intentionally left blank	Empty	Omitted
13	Life End	Intentionally left blank	Empty	Omitted
14	Not Used	Intentionally left blank	Empty	Omitted
15	Not Used	Intentionally left blank	Empty	Omitted
16	Not Used	Intentionally left blank	Empty	Omitted
17	Not Used	Intentionally left blank	Empty	Omitted
18	Number of Records in Statement	Count of all transactions (Credit and Debit) for the current statement.	Number	Mandatory

Transactions

#	Field Name	Field Description / Characteristics	Data Format (length)	Mandatory / Optional
1	Bank Key	Populated with the BSB of the current account. For Example `032-000`	Alphanumeric (7)	Mandatory
2	Bank Account Number	Populated with the account number. For Example `136465`	Numeric (6)	Mandatory
3	Statement Number	Statement Number is represented as a date formatted as `YYNNN` where `NNN` is the Julian date. For Example `17002`	Numeric (5)	Mandatory
4	Statement Date	Statement Date formatted as `DD.MM.YY`	Date (8)	Mandatory
5	Primary Note Number	Intentionally left blank	Empty	Omitted
6	Note to Payee 1	Contains the first 27 characters of the transaction narrative	Alphanumeric (27)	Optional
7	Bank Posting Text	Intentionally left blank	Empty	Omitted
8	Not Used	Intentionally left blank	Empty	Omitted
9	Text Key	Intentionally left blank	Empty	Omitted
10	Serial Number	Transaction serial code. For Cheque deposits this will contain the cheque number.	Alphanumeric (16)	Optional
11	Transaction Amount	Signed amount formatted to 2 decimal places. For example: `13.41`, `-13.41`	Numeric	Mandatory
12	Not Used	Intentionally left blank	Empty	Omitted
13	Not Used	Intentionally left blank	Empty	Omitted
14	Posting Date	Intentionally left blank	Empty	Omitted
15	Not Used	Intentionally left blank	Empty	Omitted
16	Not Used	Intentionally left blank	Empty	Omitted
17	Note to Payee 2	Contains the next 27 characters of the transaction narrative	Alphanumeric (27)	Optional
18	Note to Payee 3	Contains the next 27 characters of the transaction narrative	Alphanumeric (27)	Optional
19	Note to Payee 4	Contains the next 27 characters of the transaction narrative	Alphanumeric (27)	Optional
20	Note to Payee 5	Contains the next 12 characters of the transaction narrative	Alphanumeric (12)	Optional
21	Note to Payee 6	Contains the next 28 characters of the transaction narrative	Alphanumeric (28)	Optional
22	Note to Payee 7	Contains the next 28 characters of the transaction narrative	Alphanumeric (28)	Optional
23	Note to Payee 8	Contains the next 28 characters of the transaction narrative	Alphanumeric (28)	Optional
24	Note to Payee 9	Intentionally left blank	Empty	Omitted
25	Note to Payee 10	Intentionally left blank	Empty	Omitted
26	Note to Payee 11	Intentionally left blank	Empty	Omitted
27	Note to Payee 12	Intentionally left blank	Empty	Omitted
28	Note to Payee 13	Intentionally left blank	Empty	Omitted
29	Note to Payee 14	Intentionally left blank	Empty	Omitted
30	Business Partner	Intentionally left blank	Empty	Omitted
31	Business Partner	Intentionally left blank	Empty	Omitted
32	Bank Key of the Partner's Bank	Intentionally left blank	Empty	Omitted
33	Bank Account Number of the Partner	Intentionally left blank	Empty	Omitted
34	Business Transaction Code	A three digit transaction Westpac assigned transaction code	Alphanumeric (3)	Mandatory
35	Not Used	Intentionally left blank	Empty	Omitted
36	Not Used	Intentionally left blank	Empty	Omitted
37	Not Used	Intentionally left blank	Empty	Omitted

Format variations

This file format represents the BankRec implementation of the SAP Multicash specification. As such, there may be minor differences between this file format and COL/WIBS-AI sourced statements.

Enrichment support

If you receive a data-enriched (bulked, reconciled, debulked or enriched) statement there will be some modifications to the Transaction file.

Bulked/Reconciled enrichment

For bulked and reconciled enrichment, the following modifications will be applied to the Transactions file:

Note to Payee 1: This field will be populated with the Payment Reference.
Note to Payee 2: This field will be populated with a unique, BankRec-generated transaction identifier.

Note: All subsequent Note to Payee fields (3~14) will be empty.

Debulked recievables enrichment

For debulked recievables enrichment, the following modifications will be applied to the Transactions file:

Each line that previously represented a bulk settlement record will be replaced with multiple lines that represent the individual payments that formed part of the bulk settlement.
Note to Payee 1: This field will be populated with the Customer Reference Number.
Note to Payee 2: This field will be populated with the Payment Reference.
Note to Payee 3: This field will be populated with a unique, BankRec-generated transaction identifier.

Note: All subsequent Note to Payee fields (4~14) will be empty.

Debulked payables enrichment

For debulked payables enrichment, the following modifications will be applied to the Transactions file:

Each line that previously represented a bulk settlement record will be replaced with multiple lines that represent the individual payments that formed part of the bulk settlement.
Note to Payee 1: This field will be populated with the Payer Reference.
Note to Payee 2: This field will be populated with the Payee Reference.
Note to Payee 3: This field will be populated with a unique, BankRec-generated transaction identifier.

Note: All subsequent Note to Payee fields (4~14) will be empty.

External entry enrichment

For external entry enrichment (i.e, transactions enriched with information from an external EFT feed), the following modifications will be applied to the Transactions file:

Note to Payee 1: This field will be populated with the Customer Code.
Note to Payee 2: This field will be populated with the Remitter Name.

Note: All subsequent Note to Payee fields (3~14) will be empty.

If you require further enrichment (transaction code manipulation, alternate reference values, etc.), you should discuss this during your implementation.

Sample files

The following files are intended to be examples only.

NPP sample transactions

Download the NPP sample SAP Multicash Transactions file.

This file contains examples of all NPP transaction codes, and how they will appear in a standard SAP Multicash Transactions statement.