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

Python
import sys
import chilkat2

success = False

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

curl = chilkat2.HttpCurl()
cmd = chilkat2.StringBuilder()
json = chilkat2.JsonObject()

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

selectedPayout = "po_SELECTED_BANK_DEPOSIT"

expectedAmount = ""
currency = ""

pageSuffix = chilkat2.StringBuilder()
more = True
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):
        print("No HTTP response. Chilkat failure code: " + str(curl.FailReason))
        sys.exit()

    success = curl.GetResponseJson(json)
    if ((curl.StatusCode != 200) or (success != True)):
        print("Stripe HTTP " + str(curl.StatusCode) + "  Request-Id: " + curl.GetResponseHeaderField("Request-Id"))
        if (success == True):
            print(json.StringOf("error.message"))

        sys.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"))
        if (json.StringOf("data[i].id") == selectedPayout):
            if ((json.BoolOf("data[i].automatic") != True) or (json.StringOf("data[i].reconciliation_status") != "completed")):
                print("Select an automatic payout with completed reconciliation.")
                sys.exit()

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

        i = i + 1

    more = json.BoolOf("has_more")
    if (more == True):
        next = json.StringOf("data[i].id")
        if ((count < 1) or (next == "") or (next == cursor)):
            print("Invalid pagination cursor.")
            sys.exit()

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

if (expectedAmount == ""):
    print("The selected payout was not in this date range.")
    sys.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 = chilkat2.StringBuilder()

pageSuffixTxn = chilkat2.StringBuilder()
moreTxn = True
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):
        print("No HTTP response. Chilkat failure code: " + str(curl.FailReason))
        sys.exit()

    success = curl.GetResponseJson(json)
    if ((curl.StatusCode != 200) or (success != True)):
        print("Stripe HTTP " + str(curl.StatusCode) + "  Request-Id: " + curl.GetResponseHeaderField("Request-Id"))
        if (success == True):
            print(json.StringOf("error.message"))

        sys.exit()

    iTxn = 0
    countTxn = json.SizeOfArray("data")
    while (iTxn < countTxn) :
        json.I = iTxn
        print(json.StringOf("data[i].id") + "  " + json.StringOf("data[i].net"))
        if (json.StringOf("data[i].currency") != currency):
            print("Currency mismatch.")
            sys.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)
                sys.exit()

            if (entryNet > 0):
                if (totalNet > (2147483647 - entryNet)):
                    print("Total exceeds the supported int range.")
                    sys.exit()

            if (entryNet < 0):
                if (totalNet < ((0 - 2147483647) - (entryNet + 1))):
                    print("Total exceeds the supported int range.")
                    sys.exit()

            totalNet = totalNet + entryNet

        iTxn = iTxn + 1

    moreTxn = json.BoolOf("has_more")
    if (moreTxn == True):
        nextTxn = json.StringOf("data[i].id")
        if ((countTxn < 1) or (nextTxn == "") or (nextTxn == cursorTxn)):
            print("Invalid pagination cursor.")
            sys.exit()

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

number.IntValue = totalNet
print("Settlement net: " + str(totalNet) + "  Bank payout: " + expectedAmount + " " + currency)
if (number.GetAsString() == expectedAmount):
    print("Payout reconciled.")
else:
    print("Investigate the difference.")