Python Requires Chilkat v11.7.0+
Python
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
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.")