Skip to main content

CSV transaction report

The CSV transaction report lists the transactions taken during a settlement day. Download the report from QuickStream using the REST API or the Export Transaction Reports page when you are signed-in.

Configure the report format

Use the REST API to generate a CSV transaction report each banking day. Tailor the report by providing optional parameters to the REST API to filter by success/decline, supplier business and source. You may also provide a list of column names to retrieve the report with only the information you need. See Download csv report for more.

Your staff can generate the CSV transaction report manually. Administrator users can configure the columns available in the report so that your staff see only required information.

Report formats

The following transaction report formats are available:

The reports are plain text using UTF-8 character encoding. All records except the last are separated by the CR LF end-of-line marker. Fields may be enclosed in double quotes. If double quotes enclose a field, then a double quote appearing inside a field is escaped by preceding it with another double quote.

There are two types of rows in the transaction export:

  1. Header row
  2. Transaction row

The header row is the first row in the file. It contains the column headings. For example:

Community Code,Business Code,Business Name

The header row is then followed by many transaction rows. A transaction row represents a single transaction attempt. For example:

TEST,BUSINESSONE,"Business One, New Park"

The transaction row contains details of your customer's payment, pre-authorisation or refund.

Handling additional columns

From time to time additional columns will be added to the format. To maintain backwards compatibility, use the columns parameter to list the columns you would like in the transaction export each time it's generated. Check the change-log for when new columns are added to the report.

CSV report version 2

Column Value Description
A Supplier Business Code The supplier business that the transaction went to.
B Supplier Business Name The name of the QuickStream Business that the transaction went to.
C Source A code indicating the source of the transaction. For example RESTAPI or BATCH.
D Transaction Type PAYMENT, REFUND, PREAUTH, CAPTURE or ACCOUNT_VERIFICATION.
E Receipt Number The unique receipt number allocated by QuickStream to the transaction.
F Payment Reference A payment level identifier for the transaction as passed to QuickStream by a product. For example, you may pass or ask your customer to enter a Payment Reference Number on your QuickWeb.
G Customer Reference Number A customer level identifier for the transaction as passed by QuickStream by a product. For example, you may pass or ask your customer to enter a Customer Reference Number on your QuickWeb.
H Principal Amount The principal amount of the transaction. This is the transaction amount before a surcharge has been applied.
I Surcharge Amount The surcharge amount of the transaction.
J Total Amount The total payment amount. This is Principal Amount, plus Surcharge Amount.
K Currency The currency code of the transaction.
L Status The status of the transaction. One of:
  • Declined - The transaction was declined by the other financial institution.
  • Approved - The transaction was approved.
  • Approved* - The transaction was sent to the other financial institution and waiting for a response.
  • Void - The transaction was cancelled before settlement.
  • Error - May indicate the transaction was not processed.
M Response Code Reason code for the status. See Response Codes.
N Response Description Reason description for the status.
O Summary Code Success indicator for the responseCode. See Response Codes.
P Settlement Date The day on which this transaction was considered to have been processed. DD MMM YYYY format.
Q Transaction Time Date and time (if known) when transaction processing was initiated. DD MMM YYYY HH:mm Z format.
R IP Address The IP address of the customer. For example, 192.168.42.184.
S Comment A comment for the transaction.
T FraudGuard Result The fraud guard result description. For facilities using Fraud Guard only.
U Original Receipt Number If a refund, the original payment. If a payment, the original PREAUTH or the automatically-retried payment.
V Soft Decline true if the transaction was a soft-decline. See Response Codes.
W Automatic Retry Date The date the transaction will be automatically retried. DD MMM YYYY format.
X Authorisation Code The authorisation code returned from the issuing bank for pre-auth transactions (at most 6 characters). Only for approved pre-auth transactions.
Y Authorisation Type INCREMENTAL, EXTENSION, REAUTHORISATION. For pre-authorisation transactions only.
Z Cancellation Type FULL or PARTIAL. For pre-authorisation cancellations only.
AA Login Name The login name of the user who made the transaction. QuickTerminal transactions only.
AB Full Name The full name of the user who made the transaction. QuickTerminal transactions only.
AC API Key The API key name. For REST API transactions.
AD Account Type The type of account used to make the transaction. One of CREDIT_CARD, BANK_ACCOUNT, NZ_BANK_ACCOUNT
AE Account Token The account token. For transactions against registered accounts.
AF Cardholder Name The cardholder name. For card transactions.
AG Card Number The card number, masked. For card transactions.
AH Expiry Date The card expiry date. For card transactions.
AI Card Type The card type. CREDIT, DEBIT. Note: This is only for VISA and MASTERCARD. Other card types may be added in the future.
AJ Card Scheme The card scheme for card transactions. One of:
  • VISA
  • MASTERCARD
  • AMEX
  • DINERS
  • UNIONPAY
  • UNKNOWN
  • JCB
AK Bank Account Name The payer's bank account name. For Australian bank account transactions.
AL Bank Account BSB The bank account BSB. For Australian bank account transactions.
AM Bank Account Number The bank account number. For bank account transactions.
AN NZ Bank Account Name The payer's bank account name. For New Zealand bank account transactions.
AO NZ Bank Account Bank Code The bank code. For New Zealand bank account transactions.
AP NZ Bank Account Branch Code The branch code. For New Zealand bank account transactions.
AQ NZ Bank Account Number The account number. For New Zealand bank account transactions.
AR NZ Bank Account Suffix The account suffix. For New Zealand bank account transactions.
AS Customer Id QuickStream's unique identifier for the customer.
AT Customer Number Your reference for the customer.
AU Payment Schedule Id QuickStream's unique identifier for the recurring payment. For recurring transactions.
AV Settlement Account For Australian payments, the BSB and account number of your settlement account. For New Zealand payments, the bank, branch and account numbers of your settlement account.
AW Ecommerce Identifier The ecommerce identifier description for the transaction. For card transactions.
AX Card Issuing Country The two digit ISO country code of the card issuer.
AY Wallet Provider Specifies the wallet provider from which the card details were obtained, if applicable. APPLE_PAY, GOOGLE_PAY
AZ Pan Type
  • FPAN (default) - the card number from a physical card. Also known as "Funding PAN".
  • DPAN - a digitised card number from a wallet provider or scheme tokenisation service. Also known as "Digital PAN".
BA Payment Schedule Code Your reference for this recurring payment schedule. For recurring transactions.

CSV report version 1

Column Value Description
A Community Code Your QuickStream Community Code. This code is your unique identifier for your QuickStream facility.
B Business Code The supplier business that the transaction went to.
C Business Name The name of the QuickStream Business that the transaction went to.
D Source The source of the transaction. For example QuickWeb or QuickBatch.
E Order Type The order type of the transaction. For example capture, refund or pre-auth.
F Receipt Number The unique receipt number allocated by QuickStream to the transaction.
G Customer Reference Number A customer level identifier for the transaction as passed by QuickStream by a product. For example, you may pass or ask your customer to enter a Customer Reference Number on your QuickWeb.
H Customer Number A customer level identifier for the transaction. This has a value only when you allocate a transaction to a customer record in QuickStream.
I Payment Reference A payment level identifier for the transaction as passed to QuickStream by a product. For example, you may pass or ask your customer to enter a Payment Reference Number on your QuickWeb.
J Payment Amount The total payment amount. This is Principal Amount, plus Surcharge Amount.
K Principal Amount The principal amount of the transaction. This is the transaction amount before a surcharge has been applied.
L Surcharge Amount The surcharge amount of the transaction.
M Currency The currency code of the transaction.
N Settlement Date The settlement date of the transaction.
O Transaction Date/Time The date and time QuickStream performed the transaction.
P Transaction Status The response code.
Q Summary Code The summary code for the given Transaction Status.
R Transaction Status Description The description of the given Transaction Status.
S Summary Description A short description about the Summary Code. One of:
  • Declined - The transaction was declined by the other financial institution.
  • Approved - The transaction was approved.
  • Approved* - The transaction was sent to the other financial institution and waiting for a response.
  • Void - The transaction was cancelled through QuickStream Portal or QuickGateway before settlement.
  • Error - May indicate the transaction was not processed. Use QuickStream Portal to query the transaction.
T Authorisation Code For a pre-authorisation transaction this is the authorisation code returned from the bank.
U Settlement Account Name The name of the settlement account. This is usually the Merchant ID for card transactions.
V Payment Instrument The payment instrument used to make the transactions.
W Account Type The type of account used to make the transaction. For example: differentiate between card and bank account transactions.
X Customer Account Business Code The customer account business code. Not used for all solutions.
Y Card Scheme The card scheme for card transactions. One of:
  • VISA
  • MASTERCARD
  • AMEX
  • DINERS
  • UNIONPAY
  • UNKNOWN
  • JCB
Z Card Number The card number, masked.
AA Card Expiry Date The card expiry date.
AB Cardholder Name The cardholder name.
AC Bank Account Name The payer's bank account name. For bank account transactions.
AD Bank Account BSB The bank account BSB. For Australian bank account transactions.
AE Bank Account Number The bank account number. For bank account transactions.
AF Bank Account Bank Code The bank code. For New Zealand bank account transactions.
AG Bank Account Branch Code The branch code. For New Zealand bank account transactions.
AH Bank Account Suffix The account suffix. For New Zealand bank account transactions.
AI Login Name The login name of the user who made the transaction. QuickTerminal transactions only.
AJ Full Name The full name of the user who made the transaction. QuickTerminal transactions only.
AK Comment The comment left by the user who made the transaction. QuickTerminal transactions only.
AL Related Transaction Receipt Number If you retry, complete or refund a transaction, the original receipt number appears here.
AM Fraud Guard Result The fraud guard result description. For facilities using Fraud Guard only.
AN Ecommerce Identifier The ecommerce identifier description for the transaction. For card transactions.
Disclaimer

The information contained in this publication is provided for learning purposes only and is subject to change. Revisions may be issued from time to time that encompass changes or additions to this module.

This is a guide only and it is not comprehensive. It does not impinge on or overrule any formal arrangement you may enter into with the Bank. The Bank and its officers shall not have any liability for any losses of any kind incurred in connection with any action, inaction or decision taken in reliance on the information herein or for any inaccuracies, errors or omissions. In this publication references to the "Bank" are to Westpac Banking Corporation ABN 33 007 457 141 and to any of its operating Divisions, including BankSA and St.George.