Revenue & payouts dashboard

What this dashboard tracks

Pull your Stripe charges and balance transactions into Excel to monitor gross revenue, refunds, fees, and net payouts without leaving your spreadsheet.

Build the dashboard

1. Insert a LinkyFlow query, pick stripe, and choose the Charges query to load transactions.
2. Add the Balance Transactions query on another sheet to reconcile fees and net amounts.
3. Pick All results to load the full period, or filter by type before loading.

Useful KPIs

• Gross revenue — sum the amount column (divide by 100 to convert cents to currency).
• Refunded — sum the amount_refunded column.
• Net revenue — gross minus refunds; cross-check against the net column of balance transactions.
• Fees — sum the fee column of balance transactions.

Reconcile payouts

Use the Payouts query to list payouts to your bank account, with their amount, status, and arrival date — then match them against the balance transactions that funded them.

All amounts are in the smallest currency unit (cents). Divide by 100 in your formulas to show a currency figure.