By choosing the Excel Spreadsheet option in the Format drop-down of the report parameters page you can make your own calculations using Microsoft Excel.
The generated output of the Get Statement report is made up of:
This shows you the parameters that were chosen for the report.
To learn more about the field descriptions, click here.
This shows you details for the column headings (fields) based on the Saved Report Format setting chosen in the drop-down of the Manage Report Column Configurations part of the report parameters page. The default configuration is 'Statement'. See Make your own Reports to learn more.
Be aware that certain fields are only filled in at certain payment statuses. For example, the Transfer Currency and Transfer Amount fields are only populated once a payment has reached the SETTLED payment status.
To learn more about the field descriptions, click here.
This gives you summary information (totals) for the payments displayed in the Details section of the report. Summary information is displayed only for certain payment statuses.
The table below shows which fields to refer to for summary details. For example, if you report on CAPTURED payments for a particular time period, then the total payment amount of the captured payments is displayed in the In Process Captured Amount field in the Summary section. For other payment statuses, for example CANCELLED or REFUSED, totals are not displayed and you will need to refer to the Payment Amount field in the Details section of the report and make your own calculations, if required.
|
|
By choosing the Excel Spreadsheet option in the Format drop-down of the report parameters page you can make your own calculations using Microsoft Excel. |
For details of payment statuses:
if you are a Business Gateway user, click here.
if you are a Business Gateway Plus user, click here.
This table shows where to find summary information (total amounts).
|
Payment Status (in Report) |
Payment Status (on Customer Transactions page) |
Payment Amount Field |
In Process Authorised Field |
In Process Captured Amount Field |
Dispute Reserve Amount Field (where activated) |
Transfer Amount Field |
|
AUTHORISED |
Authorised |
- |
Yes. (+) Positive value displayed. |
- |
|
- |
|
REFUSED |
Refused |
Yes. (+)Positive value displayed. |
- |
- |
|
- |
|
EXPIRED |
Auth Expired |
Yes. (+)Positive value displayed. |
- |
- |
|
- |
|
CAPTURED |
Captured |
|
-- |
Yes. (+)Positive value displayed. |
|
- |
|
CANCELLED |
Cancelled |
Yes. (+)Positive value displayed. |
|
- |
|
- |
|
SENT_FOR_REFUND |
Refund Started |
Yes. (+)Positive value displayed. Refer to Note. |
- |
- |
|
- |
|
REFUNDED |
Refunded |
|
- |
Yes. (+)Positive value displayed. |
|
Yes.(-) Negative value displayed. |
|
SETTLED |
Settled or With Acquirer |
|
|
|
|
Yes. (+)Positive value displayed. |
|
INFORMATION_REQUESTED |
Info Requested |
Yes. (+)Positive value displayed |
|
|
Yes.(+)Positive value displayed |
|
|
INFORMATION_SUPPLIED |
Info Supplied |
Yes. (+)Positive value displayed |
|
|
Yes.(+)Positive value displayed |
|
|
CHARGED_BACK |
Charged Back |
|
|
|
Yes.(-) Negative value displayed. |
Yes.(-) Negative value displayed. |
|
CHARGEBACK_REVERSED |
Chargeback Reversed |
|
|
|
|
Yes. (+)Positive value displayed. |
|
* Note: You need to access the Payment and Order Details pop-up box in order to check the amount sent for refund. In the output of the report (webpage format only), you are able to access the Payment and Order Details pop-up box by clicking the Payment Amount link for the relevant payment. |
Provides summary information for payments at SETTLED payment status.
|
|
|
