Stripe holds the payment truth for SaaS and e-commerce clients — but month-end close, investor updates and client reporting still happen in Excel. Exporting balance transactions and rebuilding fee rollups for each client every month is repetitive, and one wrong filter makes the numbers disagree with the payout.
Ilka automates the pack: connect the client's Stripe account with a restricted read key, design the payout summary once, and deliver a .xlsx whose totals are copied from Stripe and reconciled on every run.
What Ilka does (and does not do)
Ilka does:
- Pull recent balance transactions on the day you choose
- Fill your locked layout — summary by week or type plus the full detail — with the exact amounts
- Add a Source check sheet comparing each total with Stripe
- Deliver by email, client portal, SharePoint, Drive or signed webhook
Ilka does not:
- Replace Stripe as the payments system
- Build live SaaS analytics dashboards (see Ilka vs Power BI if that is your goal)
Recommended layout
Start from the Stripe payout summary template:
- Summary by week with gross, fees and net
- Detail sheet: date, type, gross, fee, net, payout ID
- Source check proving gross, fee and net totals match Stripe
Connect Stripe
- In Client packs, add the client and choose Stripe
- Create a restricted key in the Stripe Dashboard with read-only access to Balance
- Choose the lookback window (up to 365 days)
- Describe the pack in a sentence, check the preview filled with the real transactions, and lock it
Details: Stripe integration page.
Schedule patterns that work
| Cadence | Typical use |
|---|---|
| Weekly (Monday) | Reconciliation against bank deposits |
| Monthly (5th, after close) | Management pack or investor update supplement |
| Monthly per client | Fractional CFO retainer deliverable, sent under your firm's name |
For automation stacks, read webhook Excel delivery.
Combine with other sources
If the client's revenue lives in several tools, keep Stripe for payouts and add a Sheet or Airtable pack for the rest of the ledger today (Xero / QuickBooks connectors — rolling out as a second pack). For tools without a native connector, the custom API and push API sources accept any JSON or CSV.
For cash runway, pair payout detail with the 13-week cash flow template.
Honest limits
- Deliveries go out within about 30 minutes of the scheduled time
- Rotate Stripe keys on your security policy — update the source in Ilka when you do
- Multi-currency accounts show amounts in each transaction's currency; group by currency in the layout if needed
Next steps
- Build a pack free with sample data
- For fractional CFOs
- Pricing — per client, not per seat