International response CSV
This page provides a specification for the PaymentsPlus International CSV response file format. Use this file specification to reconcile International payments.
St. George customersThis file format is not available to customers of St. George.
The current version is
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.
|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.
|4||Remittance Type||Alphanumeric||The remittance type of the payment. E.g.
|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.|
||A code to indicate the success or failure of the payment.
|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.|
||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.|
||The amount of the payment in dollars. E.g.
|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.|
||The recipient fax number for the recipient.|
|25||Recipient Email||The recipient email address.|
|26||Funding Currency||Alphanumeric||The funding currency of the payment.|
||The funding amount of the payment in dollars. This is the amount provided by the customer and not the converted amount.|
||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.|
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,firstname.lastname@example.org,AUD,"1,000.00",1.0000,XCREF123