Sample code for 30+ languages & platforms
PHP ActiveX Requires Chilkat v11.7.0+

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 PHP ActiveX Downloads

PHP ActiveX
<?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';

$ledger = new COM("Chilkat.Csv");
$ledger->HasColumnNames = 1;
$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 COM("Chilkat.StringBuilder");
$more = 1;
$cursor = '';
while (($more == 1)) {
    //  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 != 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;
        $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 == 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);
    }

}

$success = $ledger->SaveFile('stripe-balance-transactions.csv');
if ($success == 0) {
    print $ledger->LastErrorText . "\n";
    exit;
}

print 'Exported rows: ' . $outputRow . "\n";

?>