Know what a HubSpot company really pays in Stripe

**Objective:** For the HubSpot company `{company}`, find its Stripe customers, then report each one's subscription status and monthly recurring revenue (MRR) next to the company's HubSpot owner, lifecycle stage and open deals.

**Step 1: Find the company in HubSpot**

Call `hubspot-get-companies` with `company-domain-name` = `{company}` if it looks like a domain (contains a dot and no spaces), otherwise with `company-name.contains` = `{company}`. If more than one company matches, list them (name, domain, record-id) and stop, asking which one is meant. If none match, say so and stop.

Note the company's `record-id`, `domain`, `company-owner` and `lifecycle-stage`.

**Step 2: Collect the company's contacts and open deals in HubSpot**

Call `hubspot-get-contacts` with `company-id` = the company's `record-id`, `max-records` 100. Keep every non-empty `email`.

Call `hubspot-get-deals` with `company-id` = the company's `record-id`. Treat a deal as open when its `deal-stage-name` is not a closed won or closed lost stage.

**Step 3: Carry the email domain and contact emails across to Stripe**

Call `stripe-get-customer` with `email.contains` = the company's `domain` (strip any `www.` and protocol first). Then, for each contact email not already covered, call `stripe-get-customer` with `email` = that address. De-duplicate the results by `customer-id`.

If no Stripe customer is found, report the company as present in HubSpot and absent from Stripe, show Step 1 and Step 2 facts, and stop.

**Step 4: Read subscriptions and work out MRR in Stripe**

For each Stripe `customer-id`, call `stripe-get-subscription` with `customer-id`, then `stripe-get-subscription-item` with `customer-id`.

MRR per subscription item = `price-unit-amount` x `quantity`, normalised by `price-recurring-interval`: month as is, year divided by 12, week x 52 / 12, day x 365 / 12. Count only items whose subscription `status` is active, trialing or past_due. Sum per currency; never add different currencies together.

**Step 5: Report**

1. Company: name, domain, HubSpot owner, lifecycle stage.
2. Table of Stripe customers: customer-id, email, delinquent, number of subscriptions.
3. Table of subscriptions: subscription-id, customer email, status, current period end, cancel at period end, MRR and currency.
4. Total MRR per currency.
5. Open HubSpot deals: deal-name, deal-stage-name, amount, close-date.
6. One-line verdict: healthy, at risk (any past_due, unpaid or cancel at period end) or not billing (no active subscription).

**Rules & Guidelines:**

* `hubspot-get-companies`, `hubspot-get-contacts` and `hubspot-get-deals` are on the hubspot server. `stripe-get-customer`, `stripe-get-subscription` and `stripe-get-subscription-item` are on the stripe server. Both servers must be connected.
* This prompt is read-only. Do not call any HubSpot add or update tool, including `hubspot-add-company-note`, `hubspot-update-company` and `hubspot-update-deal`.
* Match on email address and email domain only. Do not match on company name alone; if the only link is a similar name, list it as a possible match, not a confirmed one.

**Validation:**

* If HubSpot returns the company but no contacts and no domain, say there is nothing to match Stripe on and stop.
* If a Stripe customer's email domain differs from the HubSpot domain but the email belongs to a HubSpot contact, keep it and note the mismatch.
* If amounts look like minor units (cents), say so and divide by 100 consistently.