Activity and Settlement Reports
Both the Activity and Settlement reports contain summarized financial data for settled transactions. The information in the Activity report is based upon activity post date, while the Settlement report information is based upon the settlement transfer date. Worldpay produces this report either daily or for the previous calendar month.
Filename Syntax
The syntax of the report filename is either:
Financial_Summary_ActivityReport${rptCategoryId}_${organizationId}_${targetDay}
for the Activity report, or
Financial_Summary_SettlementReport${rptCategoryId}_${organizationId}_${targetDay}
for the Settlement report, where
-
rptCategoryIdis the ID of the Reporting Group to which the report applies. If the report is not filtered by Reporting Group, this value is replaced by a 0. -
organizationIdis the of the parent merchant organization -
targetDayis the date to which the data applies
Report Structure
The table below provides information about the fields included in the report. The report fields are in the order presented in the table.
A data type of Signed Decimal (17,2) with a Max Size of 21 is defined as: 17 digits + decimal point + 2 digits + sign.
The table below shows the Activity and Settlement report fields.
|
Field Name |
Data Type |
Max Size |
Description |
|---|---|---|---|
|
Reporting Group |
Alphanumeric |
50 |
The Reporting Group to which the transaction belongs. |
|
Reporting Group Type |
Alphanumeric |
50 |
The type of Reporting Group: Transactional, if this Reporting group is at a transaction level (the ones submitted with the transactions) or Rollup, if this contains child Reporting Group. |
|
Merchant |
Alphanumeric |
50 |
The name of the parent organization (or division) that submitted the transaction. |
|
Payment Type |
Alphanumeric |
50 |
The method of payment (Visa, MasterCard, etc.) for this transaction. |
|
Activity Date |
Date (MM/dd/yyyy) |
10 |
The original date of the transaction |
|
Settlement Date |
Date (MM/dd/yyyy) |
10 |
The date that Worldpay sent the settled funds to your merchant account. |
|
Settlement Currency |
Alphanumeric |
5 |
The currency used for the settlement, designated by a three-character abbreviation of the country. |
|
Net Settlement |
Signed Decimal (17,2) |
21 |
The total amount settled to the merchant. |
|
Settled Deposits |
Signed Decimal (17,2) |
21 |
The total dollar amount of the deposits summed for the Reporting Group. |
|
Settled Refunds |
Signed Decimal (17,2) |
21 |
The total dollar amount of the refunds summed for the Reporting Group. |
|
Chargebacks/Returns |
Signed Decimal (17,2) |
21 |
The total dollar amount of the chargebacks and Direct Debit returns summed for the Reporting Group. |
|
Vantiv Fees |
Signed Decimal (17,2) |
21 |
The total dollar amount of fees charged by Worldpay. |
|
Passthrough Fees |
Signed Decimal (17,2) |
21 |
The total dollar amount of the transaction fees charged by the network and passed through Worldpay. |
|
Reserve Activity |
Signed Decimal (17,2) |
21 |
The total dollar amount of reserve withheld by Worldpay in this Reporting Group. |
|
3rd Party Payments |
Signed Decimal (17,2) |
21 |
The total dollar amount of any third-party payments included in this Reporting Group. |
|
Count |
Numeric |
19 |
The total number of transactions included in this Reporting Group |
|
Presenter |
Alphanumeric |
15 |
The short name of the presenter. |
|
Merchant ID |
Alphanumeric |
50 |
The value of the merchantId element/attribute submitted in the cnpAPI transaction. |
|
Worldpay Transfer Id |
Numeric |
36 |
The unique transfer identifier for the transaction. |