Lookup
Search by rego, DD code, customer, policy, or Stripe ID.
Normalised key: BRJ968
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 |
|---|---|---|---|---|---|---|---|---|---|---|
| BRJ968 | BRJ968 | MRC10907196 | Hardikkumar Patel | 70550000010436554 | Cancel | 04 Mar 2026 | 06 Oct 2026 | $120.00 | 01 Nov 2026, 5: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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| BRJ968 | Active | Hardikkumar Patel | 70550000010436554 | pm_1US5cHRpoEUmWmwqhYZutn3s | cus_U5MNgzwA3znO9k | Card | Waiting for next one | 20 Nov 2026 | $120.00 | — | Monthly | 06 Oct 2026 | — | — | 06 Oct 2026, 5:53 pm AEDT | 01 Nov 2026, 5:20 pm AEDT | 0 | — | Open in Zoho (AssureUs) |
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_1OI8MrDokh9Yo4OY3uC6hNYs | canceled | cus_P6L2ynVXRsQN5X | — | hardikpatel_28689@yahoo.com | $120.00 | month | 2026-10-30T11:25:00.000Z | 30 Nov 2023, 10:25 pm AEDT | 19 Oct 2026, 12:55 pm AEDT | BRJ968 | BRJ968 | Rego | Active | Yes | — | — | Cancel | MRC10907196 | 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
19 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:70550000018274160 | BRJ968 | Hardikkumar Patel | 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_1OI8MrDokh9Yo4OY3uC6hNYs | BRJ968 | — | status_change | status | ACTIVE | CANCELED | 27 Oct 2026, 5:02 pm AEDT | CUS_P6L2YNVXRSQN5X | stripe_customer | No | — | Status ACTIVE → CANCELED | — |
| 20 Oct 2026, 11:20 am AEDT | au | 70550000018274160 | BRJ968 | Hardikkumar Patel | updated | schedule | 2026-10-20 | 2026-11-20 | 20 Oct 2026, 10:48 am AEDT | 70550000010436554 | zoho_contact | No | — | Schedule 2026-10-20 → 2026-11-20 | — |
| 19 Oct 2026, 1:55 pm AEDT | transition | au:70550000018274160 | BRJ968 | Hardikkumar Patel | 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 | — |
| 19 Oct 2026, 1:20 pm AEDT | au | 70550000018274160 | BRJ968 | Hardikkumar Patel | updated | payment_status | PENDING SETUP | WAITING FOR NEXT ONE | 19 Oct 2026, 12:53 pm AEDT | 70550000010436554 | zoho_contact | No | — | Payment status PENDING SETUP → WAITING FOR NEXT ONE | — |
| 19 Oct 2026, 1:20 pm AEDT | au | 70550000018274160 | BRJ968 | Hardikkumar Patel | updated | payment_method | — | CARD | 19 Oct 2026, 12:53 pm AEDT | 70550000010436554 | zoho_contact | No | — | Payment method — → CARD | — |
| 19 Oct 2026, 1:20 pm AEDT | au | 70550000018274160 | BRJ968 | Hardikkumar Patel | updated | stripe_payment_id | — | ZUTN3S | 19 Oct 2026, 12:53 pm AEDT | 70550000010436554 | zoho_contact | No | — | Stripe Payment ID added (ZUTN3S) | — |
| 15 Oct 2026, 7:10 pm AEDT | mrc | 70550000002148375 | BRJ968 | Hardikkumar Patel | removed | — | CANCEL | REMOVED | 06 Oct 2026, 5:58 pm AEDT | 70550000010436554 | zoho_contact | No | — | MRC Policies record removed | — |
| 15 Oct 2026, 1:10 pm AEDT | mrc | 70550000002148375 | BRJ968 | Hardikkumar Patel | removed | — | CANCEL | REMOVED | 06 Oct 2026, 5:58 pm AEDT | 70550000010436554 | zoho_contact | No | — | MRC Policies record removed | — |
| 08 Oct 2026, 1:26 am AEDT | mrc | 70550000002148375 | BRJ968 | Hardikkumar Patel | updated | cover_type | RIDE SHARE | COMPREHENSIVE CAR COVER | 06 Oct 2026, 5:58 pm AEDT | 70550000010436554 | zoho_contact | No | — | cover_type RIDE SHARE → COMPREHENSIVE CAR COVER | — |
| 08 Oct 2026, 1:20 am AEDT | au | 70550000018274160 | BRJ968 | Hardikkumar Patel | updated | cover_type | — | COMPREHENSIVE COVER | 07 Oct 2026, 3:38 am AEDT | 70550000010436554 | zoho_contact | No | — | cover_type — → COMPREHENSIVE COVER | — |
| 08 Oct 2026, 1:10 am AEDT | mrc | 70550000002148375 | BRJ968 | Hardikkumar Patel | updated | cover_type | — | RIDE SHARE | 06 Oct 2026, 5:58 pm AEDT | 70550000010436554 | zoho_contact | No | — | cover_type — → RIDE SHARE | — |
| 07 Oct 2026, 9:09 pm AEDT | transition | au:70550000018274160 | BRJ968 | Hardikkumar Patel | status_change | assureus_transition_status | TRANSFERRED – NO PAYMENT | TRANSFERRED – ON MRC STRIPE | — | — | — | No | — | AssureUs transition status TRANSFERRED – NO PAYMENT → TRANSFERRED – ON MRC STRIPE | — |
| 07 Oct 2026, 9:01 pm AEDT | transition | au:70550000018274160 | BRJ968 | Hardikkumar Patel | status_change | assureus_transition_status | TRANSFERRED – ON MRC STRIPE | TRANSFERRED – NO PAYMENT | — | — | — | No | — | AssureUs transition status TRANSFERRED – ON MRC STRIPE → TRANSFERRED – NO PAYMENT | — |
| 06 Oct 2026, 6:01 pm AEDT | au | 70550000018274160 | BRJ968 | Hardikkumar Patel | created | status | — | ACTIVE | 06 Oct 2026, 6:00 pm AEDT | 70550000010436554 | zoho_contact | No | — | AssureUs record created | — |
| 06 Oct 2026, 6:01 pm AEDT | mrc | 70550000002148375 | BRJ968 | Hardikkumar Patel | updated | cancel_date | — | 2026-10-06 | 06 Oct 2026, 5:58 pm AEDT | 70550000010436554 | zoho_contact | No | — | Cancel date — → 2026-10-06 | — |
| 06 Oct 2026, 6:01 pm AEDT | mrc | 70550000002148375 | BRJ968 | Hardikkumar Patel | status_change | stage | ACTIVE | CANCEL | 06 Oct 2026, 5:58 pm AEDT | 70550000010436554 | zoho_contact | No | — | Stage ACTIVE → CANCEL | — |
| 06 Oct 2026, 5:53 pm AEDT | au | 70550000018274160 | BRJ968 | Hardikkumar Patel | created | status | — | ACTIVE | 06 Oct 2026, 5:53 pm AEDT | 70550000010436554 | zoho_contact | No | — | AssureUs record created | — |
| 04 Oct 2026, 4:20 am AEDT | mrc_stripe | sub_1OI8MrDokh9Yo4OY3uC6hNYs | BRJ968 | — | updated | schedule | 2026-09-30 | 2026-10-30 | 04 Oct 2026, 4:20 am AEDT | CUS_P6L2YNVXRSQN5X | stripe_customer | No | — | Schedule 2026-09-30 → 2026-10-30 | — |