How to check pending payouts in Stripe

1require('dotenv').config();
2const stripe = require('stripe')(process.env.STRIPE_SECRET_KEY);
3
4async function getPayoutSummary() {
5  const balance = await stripe.balance.retrieve();
6
7  console.log('=== Balance Summary ===');
8  balance.available.forEach(b => {
9    console.log(`Available: ${(b.amount / 100).toFixed(2)} ${b.currency.toUpperCase()}`);
10  });
11  balance.pending.forEach(b => {
12    console.log(`Pending:   ${(b.amount / 100).toFixed(2)} ${b.currency.toUpperCase()}`);
13  });
14
15  // List recent payouts by status
16  const statuses = ['pending', 'in_transit', 'paid', 'failed'];
17
18  for (const status of statuses) {
19    const payouts = await stripe.payouts.list({ status, limit: 5 });
20    if (payouts.data.length > 0) {
21      console.log(`\n=== ${status.toUpperCase()} Payouts ===`);
22      payouts.data.forEach(p => {
23        const arrival = new Date(p.arrival_date * 1000).toLocaleDateString();
24        console.log(
25          `  ${p.id} | ${(p.amount / 100).toFixed(2)} ${p.currency.toUpperCase()} | ` +
26          `Arrives: ${arrival}${p.failure_message ? ' | FAILED: ' + p.failure_message : ''}`
27        );
28      });
29    }
30  }
31}
32
33async function getPayoutDetails(payoutId) {
34  const payout = await stripe.payouts.retrieve(payoutId);
35  console.log('Payout details:', {
36    id: payout.id,
37    amount: payout.amount / 100,
38    currency: payout.currency,
39    status: payout.status,
40    arrival_date: new Date(payout.arrival_date * 1000).toLocaleDateString(),
41    failure_message: payout.failure_message,
42    method: payout.method,
43    type: payout.type,
44  });
45  return payout;
46}
47
48module.exports = { getPayoutSummary, getPayoutDetails };
49
50// Run directly
51if (require.main === module) {
52  getPayoutSummary().catch(console.error);
53}