Sub-Merchant Financial Summary Report

The Sub-Merchant Financial Summary report is a Managed Payout report containing financial data for funds transfers to Sub-merchants. The information in the report is based upon the settlement transfer date. Worldpay produces the report daily and only applies to PayFacs using the Managed Payout solution.

Filename Syntax

The syntax of the report filename is:

SubMerchant_Financial_Summary_Report_${organizationId}_${targetDay}

where

organizationId is the of the parent merchant organization
targetDay is 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.

Field Name	Data Type	Max Size	Description
Activity Date	Date (yyyy-mm-dd)	10	The original date of the transaction
Settlement Date	Date (yyyy-mm-dd)	10	The date that Worldpay sent the settled funds to your merchant account.
Merchant Id	Alphanumeric	50	The value of the merchantId element/attribute submitted in the cnpAPI transaction.
PayFac Submerchant Id	Alphanumeric	32	The Payment Facilitator supplied identifier string for the Sub-merchant within the Payment Facilitator’s systems.
Merchant Name	Alphanumeric	50	The name of the organization submitting the transaction.
Routing Number	Number	9	The routing number associated with the Sub-merchant’s account.
Account Number	Number	17	The account number of the Sub-merchant.
Settlement Currency	Alphanumeric	50	The currency used for the settlement, designated by a three-character abbreviation of the country.
VI Deposit Count	Long	19	The number of deposits associated with Visa transactions.
VI Deposit Amount	Decimal	18	The total dollar amount of the deposits associated with Visa transactions.
MC Deposit Count	Long	19	The number of deposits associated with MasterCard transactions.
MC Deposit Amount	Decimal	18	The total dollar amount of the deposits associated with MasterCard transactions.
DI Deposit Count	Long	19	The number of deposits associated with Discover transactions.
DI Deposit Amount	Decimal	18	The total dollar amount of the deposits associated with Discover transactions.
AX Deposit Count	Long	19	The number of deposits associated with American Express transactions.
AX Deposit Amount	Decimal	18	The total dollar amount of the deposits associated with American Express transactions.
eCheck Deposit Count	Long	19	The number of deposits associated with Direct Debit transactions.
eCheck Deposit Amount	Decimal	18	The total dollar amount of the deposits associated with Direct Debit transactions.
VI Refund Count	Long	19	The number of refunds associated with Visa transactions.
VI Refund Amount	Decimal	18	The total dollar amount of the refunds associated with Visa transactions.
MC Refund Count	Long	19	The number of refunds associated with MasterCard transactions.
MC Refund Amount	Decimal	18	The total dollar amount of the refunds associated with MasterCard transactions.
DI Refund Count	Long	19	The number of refunds associated with Discover transactions.
DI Refund Amount	Decimal	18	The total dollar amount of the refunds associated with Discover transactions.
AX Refund Count	Long	19	The number of refunds associated with American Express transactions.
AX Refund Amount	Decimal	18	The total dollar amount of the refunds associated with American Express transactions.
eCheck Refund Count	Long	19	The number of refunds associated with Direct Debit transactions.
eCheck Refund Amount	Decimal	18	The total dollar amount of the refunds associated with Direct Debit transactions.
VI Chargeback Count	Long	19	The number of chargebacks associated with Visa transactions.
VI Chargeback Amount	Decimal	18	The total dollar amount of the chargebacks associated with Visa transactions.
MC Chargeback Count	Long	19	The number of chargebacks associated with MasterCard transactions.
MC Chargeback Amount	Decimal	18	The total dollar amount of the chargebacks associated with MasterCard transactions.
DI Chargeback Count	Long	19	The number of chargebacks associated with Discover transactions.
DI Chargeback Amount	Decimal	18	The total dollar amount of the chargebacks associated with Discover transactions.
AX Chargeback Count	Long	19	The number of chargebacks associated with American Express transactions.
AX Chargeback Amount	Decimal	18	The total dollar amount of the chargebacks associated with American Express transactions.
eCheck Returns Count	Long	19	The number of Direct Debit returns associated with Direct Debit transactions.
eCheck Returns Amount	Decimal	18	The total dollar amount of the Direct Debit returns associated with Direct Debit transactions.
Net Settled Sales	Decimal	18	The total dollar amount of sales less any refunds and chargebacks/returns.
PayFac Fees	Decimal	18	The total dollar amount of PayFac Fees as determined by the Sub-merchant Funding Profile assigned by the Payment Facilitator.
Net Settlement	Decimal	18	The total dollar amount of Net Settled Sales less the PayFac Fees.