PHP ActiveX Requires Chilkat v11.7.0+
PHP ActiveX
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
$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";
}
?>