Search historical payouts

Use the searchPayouts method to extract information on the historical payouts issued by 2Checkout for your account.

You can retrieve information on the payment for a specific invoice, or search based on numerous filters such as payment status, transfer date, or payout method.

Search filters

Parameter	Type / Description
Reference	Optional/String InvoicePrefix (PREFIX) + InvoiceNo (00000) will search for transfers containing an invoice with prefix + number. The invoice reference is generated by 2Checkout and can be found in the Accounting area from your Control Panel.
Status	Optional/Array of strings Possible payout statuses: PAID - 2Checkout transfers successfully paid. PARTIALLY_PAID - 2Checkout transfers that partially covered invoice amounts. CANCELED - 2Checkout canceled transfers.
Currency	Optional/String 3 letter ISO currency code.
StartDate	Optional/String Start payment date. Format: Yyyy-mm-dd.
EndDate	Optional/String End payment date. Format: Yyyy-mm-dd.
PaymentType	Optional/String Possible payout methods: WIRE PAYPAL CHECK PAYONEER WEBMONEY
OrderBy	Optional/Array of objects Details below
OrderBy.Field	String Variable used for ordering the returned data. Possible values: TransferCompletionDate - payment remittance date.
OrderBy.Direction	String Order direction. Possible values: ASC - for ascending order. DESC - for descending order.
Pagination	Optional/Object Use this object for paginating the results. Default behavior is to display 10 results per page.
Pagination.Page	Integer Number of pages used for displaying results.
Pagination.Limit	Integer Limit the number of results.

Request sample

<?php

require('PATH_TO_AUTH');

$SearchOptions = new stdClass();
//$SearchOptions->Reference = 'FBV8572'; // search for a specific invoice
$SearchOptions->Status = ['PAID', 'CANCELED'];
$SearchOptions->Currency = 'USD';
$SearchOptions->StartDate = '2018-05-01';
$SearchOptions->EndDate = '2018-06-01';
$SearchOptions->PaymentType = 'WIRE';
$SearchOptions->OrderBy = [];
$orderBy = new stdClass();
$orderBy->Field = 'TransferCompletionDate';
$orderBy->Direction = 'DESC';
$SearchOptions->OrderBy[] = $orderBy;
$SearchOptions->Pagination = new stdClass();
//$SearchOptions->Pagination->Page = 1;
//$SearchOptions->Pagination->Limit = 200;

$jsonRpcRequest = array(
    'jsonrpc' => '2.0',
    'method' => 'searchPayouts',
    'params' => array($sessionID, $SearchOptions),
    'id' => $i++
);

var_dump("AccountPayouts", callRPC((Object)$jsonRpcRequest, $host));

Response parameters

Historical payout object

Parameter	Type / Description
Items	Array of objects Details below
PaymentInstance	Object Details below
PaymentInstance.TransferCompletionDate	String Payment date. Format: Yyyy-mm-dd.
PaymentInstance.PaymentType	String Payout method used for the transfer. Possible values: WIRE PAYPAL CHECK PAYONEER WEBMONEY
PaymentInstance.Amount	Float Amount transferred. Can be negative, for invoices deducted from your payment.
PaymentInstance.Currency	String Currency in which the amount was transferred. Three letters ISO currency code.
PaymentInstance.Status	String Payment status. Possible values: PAID - 2Checkout transfers successfully paid. NOT_PAID - 2Checkout unpaid balance amounts. PARTIALLY_PAID - 2Checkout transfers that partially covered invoice amounts. CANCELED - 2Checkout canceled transfers.
PaymentInstance.Invoices	Array of objects An object is created for each invoice part of the payment.
PaymentInstance.Invoices.Reference	String System generated invoice reference. Formed by InvoicePrefix (PREFIX) + InvoiceNo (00000).
PaymentInstance.Invoices.Amount	Float Invoice amount.
PaymentInstance.Invoices.Description	String Comments submitted on the invoice.
PaymentInstance.Invoices.Type	String Invoice type. Possible values: Period net sales Retain chargebacks Release chargeback Services
PaymentInstance.Invoices.Code	String Code used for identifying the invoice type. Possible values: PERIOD_NET_SALES DISPUTES_BALANCE_HOLD DISPUTES_BALANCE_RELEASE AFFILIATE_BONUSES AFFILIATE_BONUS_COMMISSION CANCELED_PO ROLLING_RESERVE_HOLD ROLLING_RESERVE_RELEASE CLOSED_CHARGEBACK_FEES OPEN_CHARGEBACK_FEES CUSTOM_FEE CHARGEBACK_FUND CHANNEL_MANAGER_SALES MONTHLY_FEE COMMITMENT_FEE OVERDUE_PO_PAYMENTS PENDING_PO_PAYMENTS RRT_FEES TRANSFER_FEE UNILOC_DISCOUNT
PaymentInstance.Invoices.Date	String Date the invoice was generated.
PaymentInstance.Invoices.PaidAmount	Float Invoice amount paid on this transfer.
PaymentInstance.Invoices.PaidDate	String Transfer date.
PaymentInstance.Invoices.PaidCurrency	String Currency of the transfer.
PaymentInstance.Summary	Object A summary of all the invoices included in this transfer.
PaymentInstance.Summary.ServicesAmount	Float Amount paid or retained for 2Checkout service invoices.
PaymentInstance.Summary.PurchaseOrdersAmount	Float Amount paid for purchase orders.
PaymentInstance.Summary.ChargeBacksAmount	Float Amount paid for chargebacks retained and released.
PaymentInstance.Summary.RollingReserveAmount	Float Amount paid for rolling reserves.
PaymentInstance.Summary.PeriodNetSales	Float Amount paid for period net sales.
PaymentInstance.Summary.VendorToVendor	Float Amount paid for vendor 2 vendor invoices.
PaymentInstance.Summary.ChargeBackFund	Float Amount paid for the chargeback fund.
PaymentInstance.Pagination	Object Details below
PaymentInstance.Pagination.Page	Integer Number of pages used for displaying the results.
PaymentInstance.Pagination.Limit	Integer Limitation of the result numbers.
PaymentInstance.Pagination.Count	Integer Total number of results.