daework
Get started
← All Daes

Finance

Revenue report

Pulls MRR, new and lost subscriptions and failed payments from Stripe, and builds the dashboard.

  • Stripe
  • Canvas
  • Files
Revenue report
Revenue reportPulls MRR, new and lost subscriptions and failed payments from Stripe, and builds the dashboard.
Message Revenue report

Start it with

What it did

  • Listed subscriptions · Stripe
  • Listed invoices · Stripe
  • Listed failed payments · Stripe
  • Ran Python · computer
  • Made a page · Canvas

What waited for you

Nothing. It only read, worked and reported, so it needed no OK.

Every Monday at 8:00

Use this DaeA sample chat. Names and numbers are made up.
Read the whole chat
  1. You

    Every Monday at 8:00, pull last week's MRR, new and lost subscriptions and failed payments from Stripe. Make me a dashboard.

  2. Listed subscriptions · Stripe · 412 active
  3. Listed invoices · Stripe · last 12 weeks
  4. Listed failed payments · Stripe · 6 last week
  5. Ran Python · computer · MRR by week
  6. Made a page · Canvas
  7. Revenue, week 42
    • Week 42 · Oct 12 – Oct 18 · from Stripe
    • MRR: $48,210 (+$1,840 (4.0%))
    • New subscriptions: 23 (+$2,870 MRR)
    • Cancelled: 9 (−$1,410 MRR)
    • Failed payments: 6 ($985 still unpaid)
    • New: +$2,870
    • Upgrades: +$380
    • Cancelled: −$1,410
    • Pro: $27,960
    • Business: $10,410
    • Starter: $9,840
    • 14 of the 23 new teams chose Pro, the week SSO shipped.
    • 5 of the 9 cancellations were monthly Starter. 4 of them named the CSV export limit.
    • Failed payments doubled, 3 to 6. Two are paid again; Stripe retries the other 4 this week.
    • Still unpaid: Halcyon Labs, $420, Card expired, Oct 21; Fieldnote, $290, Insufficient funds, Oct 20; Brightwave, $180, Card declined, Oct 22; Okapi Studio, $95, Card expired, Oct 21
  8. Revenue report

    MRR is $48,210, up $1,840 (4.0%) on last week.

    • 23 new subscriptions added $2,870, and upgrades $380. 14 of the new teams chose Pro.

    • 9 cancelled, −$1,410. Five were on the monthly Starter plan.

    • 6 payments failed, $1,135 in all. Two are paid again. Halcyon Labs owes the most, $420; their card expired.

    The dashboard is in Canvas, and the raw table is in a File. Press Draft 4 reminders on it and I write them for your OK.

  9. revenue-week-42.csv
    • CSV · 412 rows
  10. Scheduled: Every Monday at 8:00. Next run Monday, Oct 26 at 8:00.

More Daes

FinanceGet paidFinds every unpaid invoice, works out why each is late, and drafts the right reminder. You press send.Use this DaeWatch it work →
FinanceBookkeepingMatches every card charge to a receipt, files the receipts in Drive for your accountant, and tells you what is missing.Use this DaeWatch it work →
FinanceCollect the vendor billsFinds vendor invoices in email and adds them to the expenses sheet.Use this DaeWatch it work →