How to export transactions from Stripe

1const stripe = require('stripe')(process.env.STRIPE_SECRET_KEY);
2
3const transactions = await stripe.balanceTransactions.list({
4  created: {
5    gte: Math.floor(new Date('2025-01-01').getTime() / 1000),
6    lte: Math.floor(new Date('2025-01-31').getTime() / 1000),
7  },
8  limit: 100,
9});
10
11for (const txn of transactions.data) {
12  console.log(
13    txn.id,
14    txn.type,
15    txn.amount / 100,
16    txn.fee / 100,
17    txn.net / 100,
18    txn.currency
19  );
20}

1async function exportAllTransactions(startDate, endDate) {
2  const allTransactions = [];
3  let hasMore = true;
4  let startingAfter = undefined;
5
6  while (hasMore) {
7    const batch = await stripe.balanceTransactions.list({
8      created: {
9        gte: Math.floor(new Date(startDate).getTime() / 1000),
10        lte: Math.floor(new Date(endDate).getTime() / 1000),
11      },
12      limit: 100,
13      starting_after: startingAfter,
14    });
15
16    allTransactions.push(...batch.data);
17    hasMore = batch.has_more;
18    if (batch.data.length > 0) {
19      startingAfter = batch.data[batch.data.length - 1].id;
20    }
21  }
22
23  return allTransactions;
24}

1const fs = require('fs');
2
3function transactionsToCSV(transactions) {
4  const header = 'ID,Type,Amount,Fee,Net,Currency,Created\n';
5  const rows = transactions.map((txn) =>
6    [
7      txn.id,
8      txn.type,
9      (txn.amount / 100).toFixed(2),
10      (txn.fee / 100).toFixed(2),
11      (txn.net / 100).toFixed(2),
12      txn.currency,
13      new Date(txn.created * 1000).toISOString(),
14    ].join(',')
15  );
16  return header + rows.join('\n');
17}
18
19const csv = transactionsToCSV(transactions.data);
20fs.writeFileSync('stripe-export.csv', csv);