Sample code for 30+ languages & platforms
PHP ActiveX Requires Chilkat v11.7.0+

Stripe: Match an automatic bank payout to its transactions

See more Stripe Examples

Reconcile a selected automatic payout by comparing its amount with the sum of its settlement entries across all result pages.

Stripe documentation and cURL example

Chilkat PHP ActiveX Downloads

PHP ActiveX
<?php

$success = 0;

//  Requires an unlocked Chilkat bundle. See Global Unlock Sample.
//  Supply a restricted sandbox key from merchant-controlled configuration.
$apiKey = 'YOUR_STRIPE_TEST_KEY';

$curl = new COM("Chilkat.HttpCurl");
$cmd = new COM("Chilkat.StringBuilder");
$json = new COM("Chilkat.JsonObject");

//  Example UTC interval: 1 October 2026 inclusive through 1 November exclusive.
$fromTime = '1790812800';
$untilTime = '1793491200';

$selectedPayout = 'po_SELECTED_BANK_DEPOSIT';

$expectedAmount = '';
$currency = '';

$pageSuffix = new COM("Chilkat.StringBuilder");
$more = 1;
$cursor = '';
while (($more == 1)) {
    //  curl -X GET "https://api.stripe.com/v1/payouts?created%5Bgte%5D={fromTime}&created%5Blt%5D={untilTime}&limit=100" \
    //    -u "$STRIPE_API_KEY:" \
    //    -H "Stripe-Version: 2026-10-28.endive"
    $cmd->SetString('curl -X GET \'https://api.stripe.com/v1/payouts?created%5Bgte%5D=@FROM@&created%5Blt%5D=@UNTIL@&limit=100@CURSOR@\'');
    $cmd->Append(' -u \'@KEY@:\'');
    $cmd->Append(' -H \'Stripe-Version: 2026-10-28.endive\'');
    $replaced = $cmd->Replace('@CURSOR@',$pageSuffix->getAsString());
    $replaced = $cmd->Replace('@FROM@',$fromTime);
    $replaced = $cmd->Replace('@UNTIL@',$untilTime);
    $replaced = $cmd->Replace('@KEY@',$apiKey);
    $success = $curl->DoYourThing($cmd->getAsString());
    if ($success != 1) {
        print 'No HTTP response. Chilkat failure code: ' . $curl->FailReason . "\n";
        exit;
    }

    $success = $curl->GetResponseJson($json);
    if (($curl->StatusCode != 200) or ($success != 1)) {
        print 'Stripe HTTP ' . $curl->StatusCode . '  Request-Id: ' . $curl->getResponseHeaderField('Request-Id') . "\n";
        if ($success == 1) {
            print $json->stringOf('error.message') . "\n";
        }

        exit;
    }

    $i = 0;
    $count = $json->SizeOfArray('data');
    while (($i < $count)) {
        $json->I = $i;
        print $json->stringOf('data[i].id') . ' | ' . $json->stringOf('data[i].amount') . ' | ' . $json->stringOf('data[i].currency') . ' | ' . $json->stringOf('data[i].reconciliation_status') . "\n";
        if ($json->stringOf('data[i].id') == $selectedPayout) {
            if (($json->BoolOf('data[i].automatic') != 1) or ($json->stringOf('data[i].reconciliation_status') != 'completed')) {
                print 'Select an automatic payout with completed reconciliation.' . "\n";
                exit;
            }

            $expectedAmount = $json->stringOf('data[i].amount');
            $currency = $json->stringOf('data[i].currency');
        }

        $i = $i + 1;
    }

    $more = $json->BoolOf('has_more');
    if ($more == 1) {
        $next = $json->stringOf('data[i].id');
        if (($count < 1) or ($next == '') or ($next == $cursor)) {
            print 'Invalid pagination cursor.' . "\n";
            exit;
        }

        $cursor = $next;
        $pageSuffix->SetString('&starting_after=');
        $pageSuffix->Append($cursor);
    }

}

if ($expectedAmount == '') {
    print 'The selected payout was not in this date range.' . "\n";
    exit;
}

$totalNet = 0;
//  This portable example uses int for arithmetic. Reject an out-of-range entry
//  or sum before adding. A larger ledger can sum the exact strings using decimal arithmetic.
$number = new COM("Chilkat.StringBuilder");

$pageSuffixTxn = new COM("Chilkat.StringBuilder");
$moreTxn = 1;
$cursorTxn = '';
while (($moreTxn == 1)) {
    //  curl -X GET "https://api.stripe.com/v1/balance_transactions?payout={selectedPayout}&limit=100" \
    //    -u "$STRIPE_API_KEY:" \
    //    -H "Stripe-Version: 2026-10-28.endive"
    $cmd->SetString('curl -X GET \'https://api.stripe.com/v1/balance_transactions?payout=@PAYOUT@&limit=100@CURSOR@\'');
    $cmd->Append(' -u \'@KEY@:\'');
    $cmd->Append(' -H \'Stripe-Version: 2026-10-28.endive\'');
    $replaced = $cmd->Replace('@CURSOR@',$pageSuffixTxn->getAsString());
    $replaced = $cmd->Replace('@PAYOUT@',$selectedPayout);
    $replaced = $cmd->Replace('@KEY@',$apiKey);
    $success = $curl->DoYourThing($cmd->getAsString());
    if ($success != 1) {
        print 'No HTTP response. Chilkat failure code: ' . $curl->FailReason . "\n";
        exit;
    }

    $success = $curl->GetResponseJson($json);
    if (($curl->StatusCode != 200) or ($success != 1)) {
        print 'Stripe HTTP ' . $curl->StatusCode . '  Request-Id: ' . $curl->getResponseHeaderField('Request-Id') . "\n";
        if ($success == 1) {
            print $json->stringOf('error.message') . "\n";
        }

        exit;
    }

    $iTxn = 0;
    $countTxn = $json->SizeOfArray('data');
    while (($iTxn < $countTxn)) {
        $json->I = $iTxn;
        print $json->stringOf('data[i].id') . '  ' . $json->stringOf('data[i].net') . "\n";
        if ($json->stringOf('data[i].currency') != $currency) {
            print 'Currency mismatch.' . "\n";
            exit;
        }

        //  Exclude the bank withdrawal itself if it appears in this batch.
        if ($json->stringOf('data[i].source') != $selectedPayout) {
            $netText = $json->stringOf('data[i].net');
            $entryNet = $json->IntOf('data[i].net');
            $number->IntValue = $entryNet;
            if ($number->getAsString() != $netText) {
                print 'Entry exceeds the supported int range: ' . $netText . "\n";
                exit;
            }

            if ($entryNet > 0) {
                if ($totalNet > (2147483647 - $entryNet)) {
                    print 'Total exceeds the supported int range.' . "\n";
                    exit;
                }

            }

            if ($entryNet < 0) {
                if ($totalNet < ((0 - 2147483647) - ($entryNet + 1))) {
                    print 'Total exceeds the supported int range.' . "\n";
                    exit;
                }

            }

            $totalNet = $totalNet + $entryNet;
        }

        $iTxn = $iTxn + 1;
    }

    $moreTxn = $json->BoolOf('has_more');
    if ($moreTxn == 1) {
        $nextTxn = $json->stringOf('data[i].id');
        if (($countTxn < 1) or ($nextTxn == '') or ($nextTxn == $cursorTxn)) {
            print 'Invalid pagination cursor.' . "\n";
            exit;
        }

        $cursorTxn = $nextTxn;
        $pageSuffixTxn->SetString('&starting_after=');
        $pageSuffixTxn->Append($cursorTxn);
    }

}

$number->IntValue = $totalNet;
print 'Settlement net: ' . $totalNet . '  Bank payout: ' . $expectedAmount . ' ' . $currency . "\n";
if ($number->getAsString() == $expectedAmount) {
    print 'Payout reconciled.' . "\n";
}
else {
    print 'Investigate the difference.' . "\n";
}


?>