Skip to main content

International response CSV

This page provides a specification for the PaymentsPlus International CSV response file format. Use this file specification to reconcile International payments.

Version

The current version is 1.

File format specification

The file format is a CSV (Comma Separated Value) file consisting of a single header row followed by a number of payment records.

A field may be encapsulated in quotes (") to ensure that formatting notation present in fields does not interrupt the file (e.g. if the field contains a comma).

A valid quote character (') in a field will be encoded as a double quote (").

A CSV remittance file will be produced for each input file provided into PaymentsPlus. Additional remittance files may be produced to update payments which have been subsequently declined by other financial institutions.

Field Field Name Format Description
1 Pay From Account Alphanumeric The payee account that payments were made from.
2 Your Bank Reference Alphanumeric The buyer bank reference that the payment was included in. Payments to recipients will be bulked debited per payment type against the buyer according to the payment file they were contained in.
3 Payment Type Alphanumeric The payment instrument of the payment. E.g. Cheque, Direct Entry or BPay.
4 Remittance Type Alphanumeric The remittance type of the payment. E.g. None, Email, Fax, Post.
5 Buyer Reference Alphanumeric A buyer provided reference to uniquely identify the payment.
6 Bank Ref/Cheq# Alphanumeric A recipient reference for the payment which will appear as the cheque number or lodgement reference for the recipient.
7 Success 0, 1 or blank A code to indicate the success or failure of the payment. 0 = failed 1 = successful Blank = response not yet received from external system
8 Status Code Alphanumeric A unique code identifying the status of the payment. Refer to Payments Status Codes page for further information.
9 Status Description Alphanumeric A description more elaborately describing the status of the payment.
10 Payment Date Date dd mmm yyyy The date that the payment was made.
11 Recipient Code Alphanumeric The payee/recipient name that the payment was made to.
12 Recipient Name Alphanumeric The payee/recipient name that the payment was made to.
13 Recipient Account Alphanumeric The account that the payment was made to.
14 Currency Alphanumeric The currency of the payment.
15 Amount Number N,NNN.NN The amount of the payment in dollars. E.g. 1,234.45.
16 Addressee Name Alphanumeric The remittance addressee name.
17 Recipient Address 1 Alphanumeric The first address line.
18 Recipient Address 2 Alphanumeric The second address line.
19 Recipient Address 3 Alphanumeric The third address line.
20 Recipient City Alphanumeric The recipient city.
21 Recipient State Alphanumeric The recipient state.
22 Recipient Post Code Alphanumeric The recipient postal code.
23 Recipient Country Alphanumeric The recipient country name.
24 Recipient Fax Number N The recipient fax number for the recipient.
25 Recipient Email Email The recipient email address.
26 Funding Currency Alphanumeric The funding currency of the payment.
27 Funding Amount Number N,NNN.NN The funding amount of the payment in dollars. This is the amount provided by the customer and not the converted amount.
28 Exchange Rate Number NNN.NNNNN The currency exchange rate. This is the amount provided by the customer and not necessarily the rate used to exchange the currency.
29 Exchange Reference Alphanumeric The currency exchange dealer reference, if provided.

Sample File

Pay From Account,Your Bank Reference,Payment Type,Remittance Type,Buyer Reference,Bank Ref/Cheq#,Success,Status,Status Description,Payment Date,Recipient Code,Recipient Name,Recipient Account,Currency,Amount,Addressee Name,Recipient Address 1,Recipient Address 2,Recipient Address 3,Recipient City,Recipient State,Recipient Post Code,Recipient Country,Recipient Fax,Recipient Email,Funding Currency,Funding Amount,Exchange Rate,Exchange Reference
032-000 000007,BATCH001,Direct Entry,None,PAYMENT001,PAYMENT001,1,Success,Approved or completed successfully,14 Nov 2011,,Example Customer,032-000 00015,USD,"1,000.00",Example Customer,Level 1,Wallsend Plaza,,Wallsend,NSW,2290,Australia,0249510055,example@example.com,AUD,"1,000.00",1.0000,XCREF123
Westpac Privacy Statement

Privacy Statement (for individuals whose personal information may be collected - in this clause referred to as "you"). All personal information we collect about you is collected, used and disclosed by us in accordance with our Privacy Statement which is available at Privacy Statement or by calling us through your relationship manager or Westpac representative. Our Privacy Statement also provides information about how you can access and correct your personal information and make a complaint. You do not have to provide us with any personal information but, if you don't, we may not be able to process an application or a request for a product or service.