Lookup
Search by rego, DD code, customer, policy, or Stripe ID.
Normalised key: 1CQ5JD
View customer →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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| UZ95AC | 1CQ5JD | Error | SUNIL KUMAR REHAN | MXTAZC | $165.00 | monthly | 22 Nov 2026 | 22 Oct 2026, 6:01 am AEDT | 01 Nov 2026, 5:01 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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 1CQ5JD | 1CQ5JD | MRC10916110 | SUNIL KUMAR REHAN | 70550000015517139 | Cancel | 22 Jul 2026 | 13 Oct 2026 | $165.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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1CQ5JD | Active | SUNIL KUMAR REHAN | 70550000015517139 | — | cus_Uviql0II2moHW1 | — | Pending Setup | 22 Oct 2026 | $165.00 | — | Monthly | 13 Oct 2026 | — | — | 13 Oct 2026, 12:48 am AEDT | 01 Nov 2026, 5:20 pm AEDT | 0 | — | 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
16 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 22 Oct 2026, 6:08 am AEDT | transition | au:70550000018673421 | 1CQ5JD | SUNIL KUMAR REHAN | status_change | assureus_transition_status | TRANSFERRED – AWAITING STRIPE | TRANSFERRED – NO PAYMENT | — | — | — | No | — | AssureUs transition status TRANSFERRED – AWAITING STRIPE → TRANSFERRED – NO PAYMENT | — |
| 22 Oct 2026, 6:04 am AEDT | pa | UZ95AC | 1CQ5JD | SUNIL KUMAR REHAN | updated | schedule | 2026-10-22 / 165.42 | 2026-11-22 / 335.37 | — | MXTAZC | pa | No | — | Schedule 2026-10-22 / 165.42 → 2026-11-22 / 335.37 | — |
| 22 Oct 2026, 6:01 am AEDT | pa | UZ95AC | 1CQ5JD | SUNIL KUMAR REHAN | status_change | status | ACTIVE | ERROR | — | MXTAZC | pa | No | — | Status ACTIVE → ERROR | — |
| 15 Oct 2026, 7:10 pm AEDT | mrc | 70550000015517170 | 1CQ5JD | SUNIL KUMAR REHAN | removed | — | CANCEL | REMOVED | 13 Oct 2026, 12:48 am AEDT | 70550000015517139 | zoho_contact | No | — | MRC Policies record removed | — |
| 15 Oct 2026, 1:10 pm AEDT | mrc | 70550000015517170 | 1CQ5JD | SUNIL KUMAR REHAN | removed | — | CANCEL | REMOVED | 13 Oct 2026, 12:48 am AEDT | 70550000015517139 | zoho_contact | No | — | MRC Policies record removed | — |
| 15 Oct 2026, 10:01 am AEDT | pa | UZ95AC | 1CQ5JD | SUNIL KUMAR REHAN | removed | — | ACTIVE | REMOVED | — | MXTAZC | pa | No | — | Pay Advantage record removed | — |
| 13 Oct 2026, 12:59 am AEDT | transition | pa:UZ95AC | 1CQ5JD | SUNIL KUMAR REHAN | 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 | 70550000015517170 | 1CQ5JD | SUNIL KUMAR REHAN | updated | cancel_date | — | 2026-10-13 | 13 Oct 2026, 12:48 am AEDT | 70550000015517139 | zoho_contact | No | — | Cancel date — → 2026-10-13 | — |
| 13 Oct 2026, 12:52 am AEDT | mrc | 70550000015517170 | 1CQ5JD | SUNIL KUMAR REHAN | status_change | stage | ACTIVE | CANCEL | 13 Oct 2026, 12:48 am AEDT | 70550000015517139 | zoho_contact | No | — | Stage ACTIVE → CANCEL | — |
| 13 Oct 2026, 12:52 am AEDT | au | 70550000018673421 | 1CQ5JD | SUNIL KUMAR REHAN | created | status | — | ACTIVE | 13 Oct 2026, 12:48 am AEDT | 70550000015517139 | zoho_contact | No | — | AssureUs record created | — |
| 12 Oct 2026, 1:21 pm AEDT | pa | UZ95AC | 1CQ5JD | SUNIL KUMAR REHAN | removed | — | ACTIVE | REMOVED | — | MXTAZC | pa | No | — | Pay Advantage record removed | — |
| 09 Oct 2026, 6:34 am AEDT | pa | UZ95AC | 1CQ5JD | SUNIL KUMAR REHAN | updated | schedule | 2026-10-09 / 497.4 | 2026-10-22 / 165.42 | — | MXTAZC | pa | No | — | Schedule 2026-10-09 / 497.4 → 2026-10-22 / 165.42 | — |
| 08 Oct 2026, 6:34 am AEDT | pa | UZ95AC | 1CQ5JD | SUNIL KUMAR REHAN | updated | schedule | / | 2026-10-09 / 497.4 | — | MXTAZC | pa | No | — | Schedule / → 2026-10-09 / 497.4 | — |
| 08 Oct 2026, 5:00 am AEDT | pa | UZ95AC | 1CQ5JD | SUNIL KUMAR REHAN | created | — | — | CREATED | — | MXTAZC | pa | No | — | Pay Advantage record created | — |
| 08 Oct 2026, 1:26 am AEDT | mrc | 70550000015517170 | 1CQ5JD | SUNIL KUMAR REHAN | updated | cover_type | RIDE SHARE | COMPREHENSIVE CAR COVER | 23 Jul 2026, 5:39 pm AEST | 70550000015517139 | zoho_contact | No | — | cover_type RIDE SHARE → COMPREHENSIVE CAR COVER | — |
| 08 Oct 2026, 1:10 am AEDT | mrc | 70550000015517170 | 1CQ5JD | SUNIL KUMAR REHAN | updated | cover_type | — | RIDE SHARE | 23 Jul 2026, 5:39 pm AEST | 70550000015517139 | zoho_contact | No | — | cover_type — → RIDE SHARE | — |