Lookup
Search by rego, DD code, customer, policy, or Stripe ID.
Normalised key: USE127
View customer →Pay Advantage Direct Debits
3 rows
| code | rego_raw | status | customer_name | customer_code | recurring_amount | frequency | next_payment_date | live_checked_at | synced_at | Risk | Next Clash | Open |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| GUG6CC | USE127 | Cancelled | KETAV PATEL NATVARBHAI | KQ6QWC | $120.00 | monthly | 15 Oct 2026 | 15 Oct 2026, 4:42 pm AEDT | 01 Nov 2026, 4:00 pm AEDT | 0 | — | Open in Pay Advantage |
| HGRYHC | USE127 | Active | KETAV PATEL NATVARBHAI | KQ6QWC | $120.00 | monthly | 08 Nov 2026 | 01 Nov 2026, 4:00 pm AEDT | 01 Nov 2026, 4:00 pm AEDT | 4 | next clash: 08 Nov 2026 (7 days) | Open in Pay Advantage |
| J5RUWC | USE127 | Cancelled | KETAV PATEL NATVARBHAI | KQ6QWC | $120.00 | monthly | 15 Oct 2026 | 15 Oct 2026, 4:42 pm AEDT | 01 Nov 2026, 4: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 |
|---|---|---|---|---|---|---|---|---|---|---|
| USE127 | USE127 | MRC10912732 | KETAV PATEL NATVARBHAI | 70550000005198467 | Cancel | 05 Sep 2025 | 13 Oct 2026 | $120.00 | 01 Nov 2026, 4: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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| USE127 | Active | KETAV PATEL NATVARBHAI | 70550000005198467 | pm_1UWpUVRpoEUmWmwq4IIvQj68 | cus_Uv0UXh2VWlBEjM | Card | Waiting for next one | 08 Nov 2026 | $120.00 | — | Monthly | 13 Oct 2026 | — | — | 13 Oct 2026, 12:27 am AEDT | 01 Nov 2026, 4:20 pm AEDT | 4 | next clash: 08 Nov 2026 (7 days) | Open in Zoho (AssureUs) |
MRC Stripe Subscriptions
0 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| No rows found | |||||||||||||||||||||||
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
50 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01 Nov 2026, 4:07 pm AEDT | transition | au:70550000018679306 | USE127 | KETAV PATEL NATVARBHAI | status_change | assureus_transition_status | TRANSFERRED – AWAITING STRIPE | HIGH RISK – DOUBLE CHARGING | — | — | — | No | — | AssureUs transition status TRANSFERRED – AWAITING STRIPE → HIGH RISK – DOUBLE CHARGING | — |
| 01 Nov 2026, 3:20 pm AEDT | au | 70550000018679306 | USE127 | KETAV PATEL NATVARBHAI | updated | payment_status | PENDING SETUP | WAITING FOR NEXT ONE | 01 Nov 2026, 2:32 pm AEDT | 70550000005198467 | zoho_contact | No | — | Payment status PENDING SETUP → WAITING FOR NEXT ONE | — |
| 01 Nov 2026, 3:20 pm AEDT | au | 70550000018679306 | USE127 | KETAV PATEL NATVARBHAI | updated | payment_method | — | CARD | 01 Nov 2026, 2:32 pm AEDT | 70550000005198467 | zoho_contact | No | — | Payment method — → CARD | — |
| 01 Nov 2026, 3:20 pm AEDT | au | 70550000018679306 | USE127 | KETAV PATEL NATVARBHAI | updated | stripe_payment_id | — | IVQJ68 | 01 Nov 2026, 2:32 pm AEDT | 70550000005198467 | zoho_contact | No | — | Stripe Payment ID added (IVQJ68) | — |
| 15 Oct 2026, 7:10 pm AEDT | mrc | 70550000005198472 | USE127 | KETAV PATEL NATVARBHAI | removed | — | CANCEL | REMOVED | 13 Oct 2026, 12:27 am AEDT | 70550000005198467 | zoho_contact | No | — | MRC Policies record removed | — |
| 15 Oct 2026, 1:10 pm AEDT | mrc | 70550000005198472 | USE127 | KETAV PATEL NATVARBHAI | removed | — | CANCEL | REMOVED | 13 Oct 2026, 12:27 am AEDT | 70550000005198467 | zoho_contact | No | — | MRC Policies record removed | — |
| 15 Oct 2026, 12:12 pm AEDT | pa | GUG6CC | USE127 | KETAV PATEL NATVARBHAI | updated | schedule | / | 2026-10-15 / 860.22 | — | KQ6QWC | pa | No | — | Schedule / → 2026-10-15 / 860.22 | — |
| 15 Oct 2026, 12:12 pm AEDT | pa | J5RUWC | USE127 | KETAV PATEL NATVARBHAI | updated | schedule | / | 2026-10-15 / 270.12 | — | KQ6QWC | pa | No | — | Schedule / → 2026-10-15 / 270.12 | — |
| 15 Oct 2026, 10:01 am AEDT | pa | GUG6CC | USE127 | KETAV PATEL NATVARBHAI | removed | — | CANCELLED | REMOVED | — | KQ6QWC | pa | No | — | Pay Advantage record removed | — |
| 15 Oct 2026, 10:01 am AEDT | pa | J5RUWC | USE127 | KETAV PATEL NATVARBHAI | removed | — | CANCELLED | REMOVED | — | KQ6QWC | pa | No | — | Pay Advantage record removed | — |
| 15 Oct 2026, 10:01 am AEDT | pa | HGRYHC | USE127 | KETAV PATEL NATVARBHAI | removed | — | ACTIVE | REMOVED | — | KQ6QWC | pa | No | — | Pay Advantage record removed | — |
| 13 Oct 2026, 12:59 am AEDT | transition | pa:HGRYHC | USE127 | KETAV PATEL NATVARBHAI | status_change | pa_vs_mrc_status | OK | MIGRATED TO ASSUREUS | — | — | — | No | — | Pay Advantage vs MRC status OK → MIGRATED TO ASSUREUS | — |
| 13 Oct 2026, 12:52 am AEDT | mrc | 70550000005198472 | USE127 | KETAV PATEL NATVARBHAI | updated | cancel_date | 2026-09-22 | 2026-10-13 | 13 Oct 2026, 12:27 am AEDT | 70550000005198467 | zoho_contact | No | — | Cancel date 2026-09-22 → 2026-10-13 | — |
| 13 Oct 2026, 12:52 am AEDT | mrc | 70550000005198472 | USE127 | KETAV PATEL NATVARBHAI | status_change | stage | ACTIVE | CANCEL | 13 Oct 2026, 12:27 am AEDT | 70550000005198467 | zoho_contact | No | — | Stage ACTIVE → CANCEL | — |
| 13 Oct 2026, 12:52 am AEDT | au | 70550000018679306 | USE127 | KETAV PATEL NATVARBHAI | created | status | — | ACTIVE | 13 Oct 2026, 12:28 am AEDT | 70550000005198467 | zoho_contact | No | — | AssureUs record created | — |
| 12 Oct 2026, 1:21 pm AEDT | pa | HGRYHC | USE127 | KETAV PATEL NATVARBHAI | removed | — | ACTIVE | REMOVED | — | KQ6QWC | pa | No | — | Pay Advantage record removed | — |
| 12 Oct 2026, 1:21 pm AEDT | pa | GUG6CC | USE127 | KETAV PATEL NATVARBHAI | removed | — | CANCELLED | REMOVED | — | KQ6QWC | pa | No | — | Pay Advantage record removed | — |
| 12 Oct 2026, 1:21 pm AEDT | pa | J5RUWC | USE127 | KETAV PATEL NATVARBHAI | removed | — | CANCELLED | REMOVED | — | KQ6QWC | pa | No | — | Pay Advantage record removed | — |
| 08 Oct 2026, 1:26 am AEDT | mrc | 70550000005198472 | USE127 | KETAV PATEL NATVARBHAI | updated | cover_type | RIDE SHARE | COMPREHENSIVE CAR COVER | 24 Sep 2026, 1:25 am AEST | 70550000005198467 | zoho_contact | No | — | cover_type RIDE SHARE → COMPREHENSIVE CAR COVER | — |
| 08 Oct 2026, 1:10 am AEDT | mrc | 70550000005198472 | USE127 | KETAV PATEL NATVARBHAI | updated | cover_type | — | RIDE SHARE | 24 Sep 2026, 1:25 am AEST | 70550000005198467 | zoho_contact | No | — | cover_type — → RIDE SHARE | — |
| 04 Oct 2026, 6:34 pm AEDT | pa | HGRYHC | USE127 | KETAV PATEL NATVARBHAI | updated | schedule | / | 2026-11-08 / 120.42 | — | KQ6QWC | pa | No | — | Schedule / → 2026-11-08 / 120.42 | — |
| 02 Oct 2026, 7:00 pm AEST | pa | HGRYHC | USE127 | KETAV PATEL NATVARBHAI | updated | schedule | 2026-11-08 / 120.42 | / | — | KQ6QWC | pa | No | — | Schedule 2026-11-08 / 120.42 → / | — |
| 02 Oct 2026, 6:37 pm AEST | pa | HGRYHC | USE127 | KETAV PATEL NATVARBHAI | updated | schedule | / | 2026-11-08 / 120.42 | — | KQ6QWC | pa | No | — | Schedule / → 2026-11-08 / 120.42 | — |
| 02 Oct 2026, 12:39 pm AEST | pa | HGRYHC | USE127 | KETAV PATEL NATVARBHAI | updated | schedule | 2026-11-08 / 120.42 | / | — | KQ6QWC | pa | No | — | Schedule 2026-11-08 / 120.42 → / | — |
| 02 Oct 2026, 12:36 pm AEST | pa | HGRYHC | USE127 | KETAV PATEL NATVARBHAI | updated | schedule | / | 2026-11-08 / 120.42 | — | KQ6QWC | pa | No | — | Schedule / → 2026-11-08 / 120.42 | — |
| 02 Oct 2026, 7:01 am AEST | pa | HGRYHC | USE127 | KETAV PATEL NATVARBHAI | updated | schedule | 2026-11-08 / 120.42 | / | — | KQ6QWC | pa | No | — | Schedule 2026-11-08 / 120.42 → / | — |
| 02 Oct 2026, 6:35 am AEST | pa | HGRYHC | USE127 | KETAV PATEL NATVARBHAI | updated | schedule | / | 2026-11-08 / 120.42 | — | KQ6QWC | pa | No | — | Schedule / → 2026-11-08 / 120.42 | — |
| 02 Oct 2026, 1:00 am AEST | pa | HGRYHC | USE127 | KETAV PATEL NATVARBHAI | updated | schedule | 2026-11-08 / 120.42 | / | — | KQ6QWC | pa | No | — | Schedule 2026-11-08 / 120.42 → / | — |
| 02 Oct 2026, 12:34 am AEST | pa | HGRYHC | USE127 | KETAV PATEL NATVARBHAI | updated | schedule | / | 2026-11-08 / 120.42 | — | KQ6QWC | pa | No | — | Schedule / → 2026-11-08 / 120.42 | — |
| 01 Oct 2026, 7:00 pm AEST | pa | HGRYHC | USE127 | KETAV PATEL NATVARBHAI | updated | schedule | 2026-11-08 / 120.42 | / | — | KQ6QWC | pa | No | — | Schedule 2026-11-08 / 120.42 → / | — |
| 01 Oct 2026, 6:36 pm AEST | pa | HGRYHC | USE127 | KETAV PATEL NATVARBHAI | updated | schedule | / | 2026-11-08 / 120.42 | — | KQ6QWC | pa | No | — | Schedule / → 2026-11-08 / 120.42 | — |
| 01 Oct 2026, 1:01 pm AEST | pa | HGRYHC | USE127 | KETAV PATEL NATVARBHAI | updated | schedule | 2026-11-08 / 120.42 | / | — | KQ6QWC | pa | No | — | Schedule 2026-11-08 / 120.42 → / | — |
| 01 Oct 2026, 12:36 pm AEST | pa | HGRYHC | USE127 | KETAV PATEL NATVARBHAI | updated | schedule | / | 2026-11-08 / 120.42 | — | KQ6QWC | pa | No | — | Schedule / → 2026-11-08 / 120.42 | — |
| 01 Oct 2026, 7:01 am AEST | pa | HGRYHC | USE127 | KETAV PATEL NATVARBHAI | updated | schedule | 2026-11-08 / 120.42 | / | — | KQ6QWC | pa | No | — | Schedule 2026-11-08 / 120.42 → / | — |
| 01 Oct 2026, 6:40 am AEST | pa | HGRYHC | USE127 | KETAV PATEL NATVARBHAI | updated | schedule | / | 2026-11-08 / 120.42 | — | KQ6QWC | pa | No | — | Schedule / → 2026-11-08 / 120.42 | — |
| 01 Oct 2026, 1:00 am AEST | pa | HGRYHC | USE127 | KETAV PATEL NATVARBHAI | updated | schedule | 2026-11-08 / 120.42 | / | — | KQ6QWC | pa | No | — | Schedule 2026-11-08 / 120.42 → / | — |
| 01 Oct 2026, 12:35 am AEST | pa | HGRYHC | USE127 | KETAV PATEL NATVARBHAI | updated | schedule | / | 2026-11-08 / 120.42 | — | KQ6QWC | pa | No | — | Schedule / → 2026-11-08 / 120.42 | — |
| 30 Sep 2026, 6:40 pm AEST | pa | HGRYHC | USE127 | KETAV PATEL NATVARBHAI | updated | schedule | 2026-11-08 / 123.64 | / | — | KQ6QWC | pa | No | — | Schedule 2026-11-08 / 123.64 → / | — |
| 30 Sep 2026, 6:35 pm AEST | pa | HGRYHC | USE127 | KETAV PATEL NATVARBHAI | updated | schedule | / | 2026-11-08 / 123.64 | — | KQ6QWC | pa | No | — | Schedule / → 2026-11-08 / 123.64 | — |
| 30 Sep 2026, 1:01 pm AEST | pa | HGRYHC | USE127 | KETAV PATEL NATVARBHAI | updated | schedule | 2026-11-08 / 123.64 | / | — | KQ6QWC | pa | No | — | Schedule 2026-11-08 / 123.64 → / | — |
| 30 Sep 2026, 12:37 pm AEST | pa | HGRYHC | USE127 | KETAV PATEL NATVARBHAI | updated | schedule | / | 2026-11-08 / 123.64 | — | KQ6QWC | pa | No | — | Schedule / → 2026-11-08 / 123.64 | — |
| 30 Sep 2026, 7:01 am AEST | pa | HGRYHC | USE127 | KETAV PATEL NATVARBHAI | updated | schedule | 2026-11-08 / 123.64 | / | — | KQ6QWC | pa | No | — | Schedule 2026-11-08 / 123.64 → / | — |
| 30 Sep 2026, 6:35 am AEST | pa | HGRYHC | USE127 | KETAV PATEL NATVARBHAI | updated | schedule | / | 2026-11-08 / 123.64 | — | KQ6QWC | pa | No | — | Schedule / → 2026-11-08 / 123.64 | — |
| 30 Sep 2026, 1:00 am AEST | pa | HGRYHC | USE127 | KETAV PATEL NATVARBHAI | updated | schedule | 2026-11-08 / 123.64 | / | — | KQ6QWC | pa | No | — | Schedule 2026-11-08 / 123.64 → / | — |
| 30 Sep 2026, 12:35 am AEST | pa | HGRYHC | USE127 | KETAV PATEL NATVARBHAI | updated | schedule | / | 2026-11-08 / 123.64 | — | KQ6QWC | pa | No | — | Schedule / → 2026-11-08 / 123.64 | — |
| 29 Sep 2026, 7:00 pm AEST | pa | HGRYHC | USE127 | KETAV PATEL NATVARBHAI | updated | schedule | 2026-11-08 / 123.64 | / | — | KQ6QWC | pa | No | — | Schedule 2026-11-08 / 123.64 → / | — |
| 29 Sep 2026, 6:35 pm AEST | pa | HGRYHC | USE127 | KETAV PATEL NATVARBHAI | updated | schedule | / | 2026-11-08 / 123.64 | — | KQ6QWC | pa | No | — | Schedule / → 2026-11-08 / 123.64 | — |
| 29 Sep 2026, 1:57 pm AEST | pa | HGRYHC | USE127 | KETAV PATEL NATVARBHAI | updated | schedule | 2026-11-08 / 123.64 | / | — | KQ6QWC | pa | No | — | Schedule 2026-11-08 / 123.64 → / | — |
| 29 Sep 2026, 1:29 pm AEST | pa | HGRYHC | USE127 | KETAV PATEL NATVARBHAI | updated | schedule | / | 2026-11-08 / 123.64 | — | KQ6QWC | pa | No | — | Schedule / → 2026-11-08 / 123.64 | — |
| 29 Sep 2026, 12:42 pm AEST | pa | HGRYHC | USE127 | KETAV PATEL NATVARBHAI | updated | schedule | 2026-11-08 / 123.64 | / | — | KQ6QWC | pa | No | — | Schedule 2026-11-08 / 123.64 → / | — |