Lookup
Search by rego, DD code, customer, policy, or Stripe ID.
Normalised key: 1QH1NR
Pay Advantage Direct Debits
1 rows
| code | rego_raw | status | customer_name | customer_code | recurring_amount | frequency | next_payment_date | live_checked_at | synced_at | Risk | Next Clash | Open |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ZCJ9BA | 1QH1NR | Cancelled | Arjun Bhargav | 6CJ9BA | $120.00 | monthly | 15 Oct 2026 | 15 Oct 2026, 7:53 pm AEDT | 01 Nov 2026, 7:00 pm AEDT | 0 | — | Open in Pay Advantage |
MRC Policies
1 rows
| Name | Rego | Policy Number | Customer Name | Customer ID | Stage | Start Date | Cancel Date | Premium | Synced At | Open |
|---|---|---|---|---|---|---|---|---|---|---|
| 1QH1NR | 1QH1NR | MRC10908952 | Abhishek Bhargav | 70550000010516444 | Cancel | 05 Mar 2026 | 21 Oct 2026 | $120.00 | 01 Nov 2026, 7:10 pm AEDT | Open in Zoho (MRC Policies) |
AssureUs Policies
1 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1QH1NR | Active | Abhishek Bhargav | 70550000010516444 | pm_1UUx6tRpoEUmWmwqyNpGy0Fg | cus_U5kaXYyUrwvAi7 | Card | Waiting for next one | 20 Nov 2026 | $120.00 | — | Monthly | 21 Oct 2026 | — | — | 21 Oct 2026, 9:01 pm AEDT | 01 Nov 2026, 7:20 pm AEDT | 0 | — | Open in Zoho (AssureUs) |
MRC Stripe Subscriptions
2 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_1PPLHuDokh9Yo4OYfMXmibrW | canceled | cus_QFqzJPbK7QutMi | — | abhilove774@gmail.com | $120.00 | month | 2024-09-08T09:10:00.000Z | 08 Jun 2024, 7:10 pm AEST | 09 Aug 2024, 11:39 am AEST | 1Qh1nr | 1QH1NR | Rego | Active | Yes | Cancelled | ZCJ9BA | Cancel | MRC10908952 | No | 29 Oct 2026, 7:45 pm AEDT | 0 | — | Open in Stripe (MRC) |
| sub_1Q11QlDokh9Yo4OYmoYEDUMk | canceled | cus_Qsn0VanSGpGF9N | — | bhargavabhishek000@gmail.com | $120.00 | month | 2026-11-20T07:39:00.000Z | 20 Sep 2024, 5:39 pm AEST | 27 Oct 2026, 4:40 pm AEDT | 1qh1nr | 1QH1NR | Rego | Active | Yes | Cancelled | ZCJ9BA | Cancel | MRC10908952 | 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
17 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27 Oct 2026, 5:02 pm AEDT | transition | au:70550000019259405 | 1QH1NR | Abhishek Bhargav | status_change | assureus_transition_status | HIGH RISK – DOUBLE CHARGING | TRANSFERRED – CLEAN | — | — | — | No | — | AssureUs transition status HIGH RISK – DOUBLE CHARGING → TRANSFERRED – CLEAN | — |
| 27 Oct 2026, 5:02 pm AEDT | mrc_stripe | sub_1Q11QlDokh9Yo4OYmoYEDUMk | 1QH1NR | — | updated | schedule | 2026-10-20 | 2026-11-20 | 27 Oct 2026, 5:02 pm AEDT | CUS_QSN0VANSGPGF9N | stripe_customer | No | — | Schedule 2026-10-20 → 2026-11-20 | — |
| 27 Oct 2026, 5:02 pm AEDT | mrc_stripe | sub_1Q11QlDokh9Yo4OYmoYEDUMk | 1QH1NR | — | status_change | status | ACTIVE | CANCELED | 27 Oct 2026, 5:02 pm AEDT | CUS_QSN0VANSGPGF9N | stripe_customer | No | — | Status ACTIVE → CANCELED | — |
| 27 Oct 2026, 11:16 am AEDT | transition | au:70550000019259405 | 1QH1NR | Abhishek Bhargav | status_change | assureus_transition_status | TRANSFERRED – ON MRC STRIPE | HIGH RISK – DOUBLE CHARGING | — | — | — | No | — | AssureUs transition status TRANSFERRED – ON MRC STRIPE → HIGH RISK – DOUBLE CHARGING | — |
| 27 Oct 2026, 10:20 am AEDT | au | 70550000019259405 | 1QH1NR | Abhishek Bhargav | updated | payment_status | PENDING SETUP | WAITING FOR NEXT ONE | 27 Oct 2026, 10:15 am AEDT | 70550000010516444 | zoho_contact | No | — | Payment status PENDING SETUP → WAITING FOR NEXT ONE | — |
| 27 Oct 2026, 10:20 am AEDT | au | 70550000019259405 | 1QH1NR | Abhishek Bhargav | updated | payment_method | — | CARD | 27 Oct 2026, 10:15 am AEDT | 70550000010516444 | zoho_contact | No | — | Payment method — → CARD | — |
| 27 Oct 2026, 10:20 am AEDT | au | 70550000019259405 | 1QH1NR | Abhishek Bhargav | updated | stripe_payment_id | — | PGY0FG | 27 Oct 2026, 10:15 am AEDT | 70550000010516444 | zoho_contact | No | — | Stripe Payment ID added (PGY0FG) | — |
| 21 Oct 2026, 9:20 pm AEDT | au | 70550000019259405 | 1QH1NR | Abhishek Bhargav | created | status | — | ACTIVE | 21 Oct 2026, 9:02 pm AEDT | 70550000010516444 | zoho_contact | No | — | AssureUs record created | — |
| 21 Oct 2026, 9:03 pm AEDT | mrc | 70550000002158424 | 1QH1NR | Abhishek Bhargav | updated | cancel_date | 2026-04-26 | 2026-10-21 | 21 Oct 2026, 9:02 pm AEDT | 70550000010516444 | zoho_contact | No | — | Cancel date 2026-04-26 → 2026-10-21 | — |
| 21 Oct 2026, 9:03 pm AEDT | mrc | 70550000002158424 | 1QH1NR | Abhishek Bhargav | status_change | stage | ACTIVE | CANCEL | 21 Oct 2026, 9:02 pm AEDT | 70550000010516444 | zoho_contact | No | — | Stage ACTIVE → CANCEL | — |
| 15 Oct 2026, 7:10 pm AEDT | mrc | 70550000002158424 | 1QH1NR | Abhishek Bhargav | removed | — | ACTIVE | REMOVED | 26 May 2026, 10:29 am AEST | 70550000010516444 | zoho_contact | No | — | MRC Policies record removed | — |
| 15 Oct 2026, 1:10 pm AEDT | mrc | 70550000002158424 | 1QH1NR | Abhishek Bhargav | removed | — | ACTIVE | REMOVED | 26 May 2026, 10:29 am AEST | 70550000010516444 | zoho_contact | No | — | MRC Policies record removed | — |
| 15 Oct 2026, 12:12 pm AEDT | pa | ZCJ9BA | 1QH1NR | Arjun Bhargav | updated | schedule | / | 2026-10-15 / 720.42 | — | 6CJ9BA | pa | No | — | Schedule / → 2026-10-15 / 720.42 | — |
| 15 Oct 2026, 10:01 am AEDT | pa | ZCJ9BA | 1QH1NR | Arjun Bhargav | removed | — | CANCELLED | REMOVED | — | 6CJ9BA | pa | No | — | Pay Advantage record removed | — |
| 12 Oct 2026, 1:21 pm AEDT | pa | ZCJ9BA | 1QH1NR | Arjun Bhargav | removed | — | CANCELLED | REMOVED | — | 6CJ9BA | pa | No | — | Pay Advantage record removed | — |
| 08 Oct 2026, 1:26 am AEDT | mrc | 70550000002158424 | 1QH1NR | Abhishek Bhargav | updated | cover_type | RIDE SHARE | COMPREHENSIVE CAR COVER | 26 May 2026, 10:29 am AEST | 70550000010516444 | zoho_contact | No | — | cover_type RIDE SHARE → COMPREHENSIVE CAR COVER | — |
| 08 Oct 2026, 1:10 am AEDT | mrc | 70550000002158424 | 1QH1NR | Abhishek Bhargav | updated | cover_type | — | RIDE SHARE | 26 May 2026, 10:29 am AEST | 70550000010516444 | zoho_contact | No | — | cover_type — → RIDE SHARE | — |