dunning-queue

name	dunning-queue
description	List all subscriptions currently in PAST_DUE or UNPAID status, ranked by MRR at risk. Use when the user wants to see which subscriptions are in trouble, past-due subs, or subscriptions with failed renewals. Do NOT use for invoice-level overdue (use /overdue-invoices) or dunning analysis.
when_to_use	Trigger on: "past due subscriptions", "which subs are past due", "subscriptions in trouble", "failed renewal subs", "unpaid subscriptions", "subscription payment issues".

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