zoho Past Due Subscriptions
List all PAST_DUE and UNPAID subscriptions ranked by MRR at risk.
Setup
Resolve org ID via ZohoBilling_List_all_Organizations.
Fetch (run in parallel)
| # | Tool | Params |
|---|---|---|
| 1 | ZohoBilling_List_all_Subscriptions |
filter_by: SubscriptionStatus.PAST_DUE, per_page: 200 |
| 2 | ZohoBilling_List_all_Subscriptions |
filter_by: SubscriptionStatus.UNPAID, per_page: 200 |
Paginate while has_more_page: true.
Output
Past Due & Unpaid Subscriptions — [date]
Total MRR at risk: $XXX,XXX across N subscriptions
──────────────────────────────────────────────────────────
# Customer Plan MRR Status
──────────────────────────────────────────────────────────
1 Acme Corp Pro Annual $4,200 PAST_DUE
2 Northwind Traders Starter $ 490 UNPAID
...
──────────────────────────────────────────────────────────
PAST_DUE: N subs $X MRR
UNPAID: N subs $X MRR
For each subscription show: customer name · plan name · MRR · status · subscription ID. Sort by MRR descending within each status group.
Constraints
- PAST_DUE and UNPAID are distinct — show them in separate groups
- MRR = plan amount / billing frequency months (approximate if not available)
- Propose-only: no subscription changes
Edge cases
- Zero results: "No past-due or unpaid subscriptions 🟢"
- Same customer appears multiple times: group their subs together, show subtotal