PowerShell Requires Chilkat v11.7.0+
PowerShell
Stripe: Export a period of account activity
See more Stripe Examples
Export account activity for a UTC date range to CSV, including transaction references, fees, net amounts, and currencies.
Stripe documentation and cURL example
Chilkat PowerShell Downloads
Add-Type -Path "C:\chilkat\ChilkatDotNet47-x64\ChilkatDotNet47.dll"
$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 = New-Object Chilkat.HttpCurl
$cmd = New-Object Chilkat.StringBuilder
$json = New-Object Chilkat.JsonObject
# Example UTC interval: 1 October 2026 inclusive through 1 November exclusive.
$fromTime = "1790812800"
$untilTime = "1793491200"
$ledger = New-Object Chilkat.Csv
$ledger.HasColumnNames = $true
$outputRow = 0
$ledger.SetColumnName(0,"id")
$ledger.SetColumnName(1,"created")
$ledger.SetColumnName(2,"source")
$ledger.SetColumnName(3,"reporting_category")
$ledger.SetColumnName(4,"amount")
$ledger.SetColumnName(5,"fee")
$ledger.SetColumnName(6,"net")
$ledger.SetColumnName(7,"currency")
$pageSuffix = New-Object Chilkat.StringBuilder
$more = $true
$cursor = ""
while (($more -eq $true)) {
# curl -X GET "https://api.stripe.com/v1/balance_transactions?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/balance_transactions?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 -ne $true) {
$("No HTTP response. Chilkat failure code: " + $curl.FailReason)
exit
}
$success = $curl.GetResponseJson($json)
if (($curl.StatusCode -ne 200) -or ($success -ne $true)) {
$("Stripe HTTP " + $curl.StatusCode + " Request-Id: " + $curl.GetResponseHeaderField("Request-Id"))
if ($success -eq $true) {
$($json.StringOf("error.message"))
}
exit
}
$i = 0
$count = $json.SizeOfArray("data")
while (($i -lt $count)) {
$json.I = $i
$ledger.SetCell($outputRow,0,$json.StringOf("data[i].id"))
$ledger.SetCell($outputRow,1,$json.StringOf("data[i].created"))
$ledger.SetCell($outputRow,2,$json.StringOf("data[i].source"))
$ledger.SetCell($outputRow,3,$json.StringOf("data[i].reporting_category"))
$ledger.SetCell($outputRow,4,$json.StringOf("data[i].amount"))
$ledger.SetCell($outputRow,5,$json.StringOf("data[i].fee"))
$ledger.SetCell($outputRow,6,$json.StringOf("data[i].net"))
$ledger.SetCell($outputRow,7,$json.StringOf("data[i].currency"))
$outputRow = $outputRow + 1
$i = $i + 1
}
$more = $json.BoolOf("has_more")
if ($more -eq $true) {
$next = $json.StringOf("data[i].id")
if (($count -lt 1) -or ($next -eq "") -or ($next -eq $cursor)) {
$("Invalid pagination cursor.")
exit
}
$cursor = $next
$pageSuffix.SetString("&starting_after=")
$pageSuffix.Append($cursor)
}
}
$success = $ledger.SaveFile("stripe-balance-transactions.csv")
if ($success -eq $false) {
$($ledger.LastErrorText)
exit
}
$("Exported rows: " + $outputRow)