Sample code for 30+ languages & platforms
JavaScript 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

Note
This example is intended for running within a Chilkat.Js embedded JavaScript engine. All Chilkat JavaScript examples require Chilkat v11.4.0 or greater.
JavaScript
var success = false;

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

var curl = new CkHttpCurl();
var cmd = new CkStringBuilder();
var json = new CkJsonObject();

var replaced;

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

var selectedPayout = "po_SELECTED_BANK_DEPOSIT";

var expectedAmount = "";
var currency = "";

var pageSuffix = new CkStringBuilder();
var more = true;
var cursor = "";
while ((more == true)) {
    //  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 !== true) {
        console.log("No HTTP response. Chilkat failure code: " + curl.FailReason);
        return;
    }

    success = curl.GetResponseJson(json);
    if ((curl.StatusCode !== 200) || (success !== true)) {
        console.log("Stripe HTTP " + curl.StatusCode + "  Request-Id: " + curl.GetResponseHeaderField("Request-Id"));
        if (success == true) {
            console.log(json.StringOf("error.message"));
        }

        return;
    }

    var i = 0;
    var count = json.SizeOfArray("data");
    while ((i < count)) {
        json.I = i;
        console.log(json.StringOf("data[i].id") + " | " + json.StringOf("data[i].amount") + " | " + json.StringOf("data[i].currency") + " | " + json.StringOf("data[i].reconciliation_status"));
        if (json.StringOf("data[i].id") == selectedPayout) {
            if ((json.BoolOf("data[i].automatic") !== true) || (json.StringOf("data[i].reconciliation_status") !== "completed")) {
                console.log("Select an automatic payout with completed reconciliation.");
                return;
            }

            expectedAmount = json.StringOf("data[i].amount");
            currency = json.StringOf("data[i].currency");
        }

        i = i+1;
    }

    more = json.BoolOf("has_more");
    if (more == true) {
        var next = json.StringOf("data[i].id");
        if ((count < 1) || (next == "") || (next == cursor)) {
            console.log("Invalid pagination cursor.");
            return;
        }

        cursor = next;
        pageSuffix.SetString("&starting_after=");
        pageSuffix.Append(cursor);
    }

}

if (expectedAmount == "") {
    console.log("The selected payout was not in this date range.");
    return;
}

var 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.
var number = new CkStringBuilder();

var pageSuffixTxn = new CkStringBuilder();
var moreTxn = true;
var cursorTxn = "";
while ((moreTxn == true)) {
    //  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 !== true) {
        console.log("No HTTP response. Chilkat failure code: " + curl.FailReason);
        return;
    }

    success = curl.GetResponseJson(json);
    if ((curl.StatusCode !== 200) || (success !== true)) {
        console.log("Stripe HTTP " + curl.StatusCode + "  Request-Id: " + curl.GetResponseHeaderField("Request-Id"));
        if (success == true) {
            console.log(json.StringOf("error.message"));
        }

        return;
    }

    var iTxn = 0;
    var countTxn = json.SizeOfArray("data");
    while ((iTxn < countTxn)) {
        json.I = iTxn;
        console.log(json.StringOf("data[i].id") + "  " + json.StringOf("data[i].net"));
        if (json.StringOf("data[i].currency") !== currency) {
            console.log("Currency mismatch.");
            return;
        }

        //  Exclude the bank withdrawal itself if it appears in this batch.
        if (json.StringOf("data[i].source") !== selectedPayout) {
            var netText = json.StringOf("data[i].net");
            var entryNet = json.IntOf("data[i].net");
            number.IntValue = entryNet;
            if (number.GetAsString() !== netText) {
                console.log("Entry exceeds the supported int range: " + netText);
                return;
            }

            if (entryNet > 0) {
                if (totalNet > (2147483647 - entryNet)) {
                    console.log("Total exceeds the supported int range.");
                    return;
                }

            }

            if (entryNet < 0) {
                if (totalNet < ((0 - 2147483647) - (entryNet+1))) {
                    console.log("Total exceeds the supported int range.");
                    return;
                }

            }

            totalNet = totalNet+entryNet;
        }

        iTxn = iTxn+1;
    }

    moreTxn = json.BoolOf("has_more");
    if (moreTxn == true) {
        var nextTxn = json.StringOf("data[i].id");
        if ((countTxn < 1) || (nextTxn == "") || (nextTxn == cursorTxn)) {
            console.log("Invalid pagination cursor.");
            return;
        }

        cursorTxn = nextTxn;
        pageSuffixTxn.SetString("&starting_after=");
        pageSuffixTxn.Append(cursorTxn);
    }

}

number.IntValue = totalNet;
console.log("Settlement net: " + totalNet + "  Bank payout: " + expectedAmount + " " + currency);
if (number.GetAsString() == expectedAmount) {
    console.log("Payout reconciled.");
}
else {
    console.log("Investigate the difference.");
}