Search

Remittance Information

Date Range: Today → Today (settlement date)

Description

Reconciliation detail showing what was collected from consumers and how it maps to settlement activity for the current day. Bank account numbers in this report are unmasked to support reconciliation.

Columns

Column	Type	Description
`Company`	text	Merchant number of the sub-merchant.
`CompanyName`	text(50)	DBA name of the sub-merchant.
`Settlemented`	date	Settlement date — the date funds were settled. Format: `M/D/YYYY`.
`Credit`	currency	Total credit amount applied in this settlement.
`Debit`	currency	Total debit amount applied in this settlement.
`Collected`	currency	Total amount collected from consumers in this settlement.
`Disbursed`	currency	Total amount disbursed to the sub-merchant in this settlement.
`EED`	date	Effective Entry Date — the scheduled settlement date at the consumer's bank. Format: `M/D/YYYY`.
`EntryAmount`	text	Dollar amount of the individual ACH entry.
`RoutingNo`	text(20)	9-digit ABA routing number of the consumer's bank.
`AccountNo`	text(17)	Full bank account number (unmasked).
`IdentNum`	text	Reference number on the entry.
`EntryName`	text(30)	Name field on the entry (consumer or company name).
`EntryDescription`	text(15)	Description on the entry (up to 10 characters).
`Trace15`	text(15)	15-digit ACH trace number.
`Trans_Code`	text(2)	Transaction type code (e.g., `22` = checking credit, `27` = checking debit).
`OriginationStatus`	text	Whether the entry was successfully sent to the bank.
`ReturnDate`	date	Date the entry was returned by the bank. Format: `M/D/YYYY`. Blank if not returned.
`ReturnDescription`	text	Reason the entry was returned. Blank if not returned.
`ReturnCode`	text(3)	Return code (e.g., `R02` = Account Closed). Blank if not returned.
`TaileredFieldMID`	text(6)	WorldPay Merchant ID. Blank if not configured.
`TaileredFieldCGID`	text(30)	WorldPay Company Group ID. Blank if not configured.
`TaileredFieldSTW`	text	WorldPay Store/Terminal/Workstation code. Blank if not configured.
`ChainCode`	text	Sub-merchant chain code. Blank if not configured.
`ParentChainCode`	text	Parent merchant chain code. Blank if not configured.
`GlobalMID`	text(50)	WorldPay Global Merchant ID. Blank if not configured.
`ParentMID`	text(5)	10-digit parent merchant number.
`TheirReferenceNumber`	text	Merchant or customer reference number from the originating transaction.
`DateModified`	date	Date this remittance record was last modified. Format: `M/D/YYYY`.
`DiscountFee`	currency	Discount fee applied to this settlement entry. `0.00` if fees are not shown for this merchant.
`TransactionFee`	currency	Per-transaction origination fee applied. `0.00` if fees are not shown for this merchant.
`ReturnFee`	currency	Return fee applied if this entry was returned. `0.00` if fees are not shown for this merchant.