Lookup
Search by rego, DD code, customer, policy, or Stripe ID.
Normalised key: KHU5H1
View customer →Pay Advantage Direct Debits
0 rows
| code | rego_raw | status | customer_name | customer_code | recurring_amount | frequency | next_payment_date | live_checked_at | synced_at | Risk | Next Clash | Open |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| No rows found | ||||||||||||
MRC Policies
1 rows
| Name | Rego | Policy Number | Customer Name | Customer ID | Stage | Start Date | Cancel Date | Premium | Synced At | Open |
|---|---|---|---|---|---|---|---|---|---|---|
| KHU5H1 | KHU5H1 | MRC10907199 | Ranjit Singh Sanga | 70550000002079709 | Cancel | 10 Dec 2025 | 24 Jan 2026 | $0.00 | 01 Nov 2026, 5:10 pm AEDT | Open in Zoho (MRC Policies) |
AssureUs Policies
0 rows
| Rego | Status | Customer Name | Customer ID | Stripe Payment ID | Stripe Customer ID | Payment Method | Payment Status | Next Payment Date | Final Premium | Amount | Premium Period | Start Date | Cancel Date | Cancel Type | Created Time | Synced At | Risk | Next Clash | Open |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| No rows found | |||||||||||||||||||
MRC Stripe Subscriptions
1 rows
| Subscription ID | Status | Customer ID | Customer Name | Customer Email | Amount | Interval | Next Bill | Created | Canceled/Ended At | Rego Raw | Rego | Match Type | AssureUs Status | AssureUs Stripe | Pay Advantage DD Status | Pay Advantage DD Code(s) | MRC Stage | MRC Policy Number | Double Paying | Imported At | Risk | Next Clash | Open |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| sub_1OIN8EDokh9Yo4OY4xOoR57g | canceled | cus_P6aIlzD4097sW0 | — | dave07_10@yahoo.com | $135.00 | month | 2026-02-01T03:11:00.000Z | 01 Dec 2023, 2:11 pm AEDT | 27 Jan 2026, 12:51 pm AEDT | KHU5H1 | KHU5H1 | Rego | — | No | — | — | Cancel | MRC10907199 | No | 29 Oct 2026, 7:45 pm AEDT | 0 | — | Open in Stripe (MRC) |
Past Actions
0 rows
| Timestamp | Action | DD Code | Rego | Customer Name | Status Before | Status After | Reason | Result | Error | Batch ID | Open |
|---|---|---|---|---|---|---|---|---|---|---|---|
| No rows found | |||||||||||
Timeline
4 rows
| Detected At | Source | Record ID | Rego | Customer | Event | Field | Old Value | New Value | Source Modified At | Customer Key | Customer Source | Noise | Noise Reason | Change | Open |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15 Oct 2026, 7:10 pm AEDT | mrc | 70550000002148381 | KHU5H1 | Ranjit Singh Sanga | removed | — | CANCEL | REMOVED | 24 Jan 2026, 9:40 pm AEDT | 70550000002079709 | zoho_contact | No | — | MRC Policies record removed | — |
| 15 Oct 2026, 1:10 pm AEDT | mrc | 70550000002148381 | KHU5H1 | Ranjit Singh Sanga | removed | — | CANCEL | REMOVED | 24 Jan 2026, 9:40 pm AEDT | 70550000002079709 | zoho_contact | No | — | MRC Policies record removed | — |
| 08 Oct 2026, 1:26 am AEDT | mrc | 70550000002148381 | KHU5H1 | Ranjit Singh Sanga | updated | cover_type | RIDE SHARE | COMPREHENSIVE CAR COVER | 24 Jan 2026, 9:40 pm AEDT | 70550000002079709 | zoho_contact | No | — | cover_type RIDE SHARE → COMPREHENSIVE CAR COVER | — |
| 08 Oct 2026, 1:10 am AEDT | mrc | 70550000002148381 | KHU5H1 | Ranjit Singh Sanga | updated | cover_type | — | RIDE SHARE | 24 Jan 2026, 9:40 pm AEDT | 70550000002079709 | zoho_contact | No | — | cover_type — → RIDE SHARE | — |