Lookup
Search by rego, DD code, customer, policy, or Stripe ID.
Normalised key: 2BJ3PQ
View customer →Pay Advantage Direct Debits
2 rows
| code | rego_raw | status | customer_name | customer_code | recurring_amount | frequency | next_payment_date | live_checked_at | synced_at | Risk | Next Clash | Open |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9NRBPC | 2BJ3PQ | Cancelled | NNV Pty ltd | T6BHKA | $100.00 | monthly | — | — | 01 Nov 2026, 6:00 pm AEDT | 0 | — | Open in Pay Advantage |
| Q6KNDC | 2BJ3PQ | Cancelled | NNV Pty ltd | T6BHKA | $100.00 | monthly | 29 Oct 2026 | 27 Oct 2026, 12:08 pm AEDT | 01 Nov 2026, 6: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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 2BJ3PQ | 2BJ3PQ | MRC10909816 | Ranjeet Singh | 70550000001888057 | Cancel | 26 Dec 2025 | 16 Oct 2026 | $110.00 | 01 Nov 2026, 6: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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2BJ3PQ | Active | Ranjeet Singh | 70550000001888057 | pm_1UUefnRpoEUmWmwqMuuH3fga | cus_Uv0NFyWLcwHhfK | Card | Waiting for next one | 29 Nov 2026 | $100.00 | — | Monthly | 16 Oct 2026 | — | — | 16 Oct 2026, 12:36 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
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 29 Oct 2026, 2:20 am AEDT | au | 70550000018966642 | 2BJ3PQ | Ranjeet Singh | updated | schedule | 2026-10-29 | 2026-11-29 | 29 Oct 2026, 2:03 am AEDT | 70550000001888057 | zoho_contact | No | — | Schedule 2026-10-29 → 2026-11-29 | — |
| 27 Oct 2026, 12:28 pm AEDT | transition | au:70550000018966642 | 2BJ3PQ | RANJEET SINGH | status_change | assureus_transition_status | HIGH RISK – DOUBLE CHARGING | TRANSFERRED – CLEAN | — | — | — | No | — | AssureUs transition status HIGH RISK – DOUBLE CHARGING → TRANSFERRED – CLEAN | — |
| 27 Oct 2026, 12:04 pm AEDT | pa | Q6KNDC | 2BJ3PQ | NNV Pty ltd | status_change | status | ACTIVE | CANCELLED | — | T6BHKA | pa | No | — | Status ACTIVE → CANCELLED | — |
| 27 Oct 2026, 11:20 am AEDT | au | 70550000018966642 | 2BJ3PQ | RANJEET SINGH | updated | schedule | 2026-11-29 | 2026-10-29 | 27 Oct 2026, 11:10 am AEDT | 70550000001888057 | zoho_contact | No | — | Schedule 2026-11-29 → 2026-10-29 | — |
| 26 Oct 2026, 5:52 pm AEDT | transition | au:70550000018966642 | 2BJ3PQ | RANJEET SINGH | status_change | assureus_transition_status | HIGH RISK – FLEET AUTHORISED | HIGH RISK – DOUBLE CHARGING | — | — | — | No | — | AssureUs transition status HIGH RISK – FLEET AUTHORISED → HIGH RISK – DOUBLE CHARGING | — |
| 26 Oct 2026, 5:20 pm AEDT | au | 70550000018966642 | 2BJ3PQ | RANJEET SINGH | updated | payment_status | PENDING SETUP | WAITING FOR NEXT ONE | 26 Oct 2026, 5:05 pm AEDT | 70550000001888057 | zoho_contact | No | — | Payment status PENDING SETUP → WAITING FOR NEXT ONE | — |
| 26 Oct 2026, 5:20 pm AEDT | au | 70550000018966642 | 2BJ3PQ | RANJEET SINGH | updated | payment_method | — | CARD | 26 Oct 2026, 5:05 pm AEDT | 70550000001888057 | zoho_contact | No | — | Payment method — → CARD | — |
| 26 Oct 2026, 5:20 pm AEDT | au | 70550000018966642 | 2BJ3PQ | RANJEET SINGH | updated | stripe_payment_id | — | UH3FGA | 26 Oct 2026, 5:05 pm AEDT | 70550000001888057 | zoho_contact | No | — | Stripe Payment ID added (UH3FGA) | — |
| 26 Oct 2026, 3:32 pm AEDT | transition | au:70550000018966642 | 2BJ3PQ | RANJEET SINGH | status_change | assureus_transition_status | TRANSFERRED – AWAITING STRIPE | HIGH RISK – FLEET AUTHORISED | — | — | — | No | — | AssureUs transition status TRANSFERRED – AWAITING STRIPE → HIGH RISK – FLEET AUTHORISED | — |
| 16 Oct 2026, 1:26 am AEDT | transition | pa:Q6KNDC | 2BJ3PQ | NNV Pty ltd | status_change | pa_vs_mrc_status | AMOUNT MISMATCH | MIGRATED TO ASSUREUS | — | — | — | No | — | Pay Advantage vs MRC status AMOUNT MISMATCH → MIGRATED TO ASSUREUS | — |
| 16 Oct 2026, 12:46 am AEDT | mrc | 70550000002161173 | 2BJ3PQ | RANJEET SINGH | updated | cancel_date | — | 2026-10-16 | 16 Oct 2026, 12:36 am AEDT | 70550000001888057 | zoho_contact | No | — | Cancel date — → 2026-10-16 | — |
| 16 Oct 2026, 12:46 am AEDT | mrc | 70550000002161173 | 2BJ3PQ | RANJEET SINGH | status_change | stage | ACTIVE | CANCEL | 16 Oct 2026, 12:36 am AEDT | 70550000001888057 | zoho_contact | No | — | Stage ACTIVE → CANCEL | — |
| 16 Oct 2026, 12:46 am AEDT | au | 70550000018966642 | 2BJ3PQ | RANJEET SINGH | created | status | — | ACTIVE | 16 Oct 2026, 12:36 am AEDT | 70550000001888057 | zoho_contact | No | — | AssureUs record created | — |
| 15 Oct 2026, 7:10 pm AEDT | mrc | 70550000002161173 | 2BJ3PQ | RANJEET SINGH | removed | — | ACTIVE | REMOVED | 29 Dec 2025, 2:45 pm AEDT | 70550000001888057 | zoho_contact | No | — | MRC Policies record removed | — |
| 15 Oct 2026, 1:10 pm AEDT | mrc | 70550000002161173 | 2BJ3PQ | RANJEET SINGH | removed | — | ACTIVE | REMOVED | 29 Dec 2025, 2:45 pm AEDT | 70550000001888057 | zoho_contact | No | — | MRC Policies record removed | — |
| 15 Oct 2026, 10:01 am AEDT | pa | 9NRBPC | 2BJ3PQ | NNV Pty ltd | removed | — | CANCELLED | REMOVED | — | T6BHKA | pa | No | — | Pay Advantage record removed | — |
| 15 Oct 2026, 10:01 am AEDT | pa | Q6KNDC | 2BJ3PQ | NNV Pty ltd | removed | — | ACTIVE | REMOVED | — | T6BHKA | pa | No | — | Pay Advantage record removed | — |
| 12 Oct 2026, 1:21 pm AEDT | pa | 9NRBPC | 2BJ3PQ | NNV Pty ltd | removed | — | CANCELLED | REMOVED | — | T6BHKA | pa | No | — | Pay Advantage record removed | — |
| 12 Oct 2026, 1:21 pm AEDT | pa | Q6KNDC | 2BJ3PQ | NNV Pty ltd | removed | — | ACTIVE | REMOVED | — | T6BHKA | pa | No | — | Pay Advantage record removed | — |
| 08 Oct 2026, 1:26 am AEDT | mrc | 70550000002161173 | 2BJ3PQ | RANJEET SINGH | updated | cover_type | RIDE SHARE | COMPREHENSIVE CAR COVER | 29 Dec 2025, 2:45 pm AEDT | 70550000001888057 | zoho_contact | No | — | cover_type RIDE SHARE → COMPREHENSIVE CAR COVER | — |
| 08 Oct 2026, 1:10 am AEDT | mrc | 70550000002161173 | 2BJ3PQ | RANJEET SINGH | updated | cover_type | — | RIDE SHARE | 29 Dec 2025, 2:45 pm AEDT | 70550000001888057 | zoho_contact | No | — | cover_type — → RIDE SHARE | — |
| 04 Oct 2026, 6:34 pm AEDT | pa | Q6KNDC | 2BJ3PQ | NNV Pty ltd | updated | schedule | / | 2026-10-29 / 101.4 | — | T6BHKA | pa | No | — | Schedule / → 2026-10-29 / 101.4 | — |
| 02 Oct 2026, 7:00 pm AEST | pa | Q6KNDC | 2BJ3PQ | NNV Pty ltd | updated | schedule | 2026-10-29 / 101.4 | / | — | T6BHKA | pa | No | — | Schedule 2026-10-29 / 101.4 → / | — |
| 02 Oct 2026, 6:37 pm AEST | pa | Q6KNDC | 2BJ3PQ | NNV Pty ltd | updated | schedule | / | 2026-10-29 / 101.4 | — | T6BHKA | pa | No | — | Schedule / → 2026-10-29 / 101.4 | — |
| 02 Oct 2026, 12:39 pm AEST | pa | Q6KNDC | 2BJ3PQ | NNV Pty ltd | updated | schedule | 2026-10-29 / 101.4 | / | — | T6BHKA | pa | No | — | Schedule 2026-10-29 / 101.4 → / | — |
| 02 Oct 2026, 12:36 pm AEST | pa | Q6KNDC | 2BJ3PQ | NNV Pty ltd | updated | schedule | / | 2026-10-29 / 101.4 | — | T6BHKA | pa | No | — | Schedule / → 2026-10-29 / 101.4 | — |
| 02 Oct 2026, 7:01 am AEST | pa | Q6KNDC | 2BJ3PQ | NNV Pty ltd | updated | schedule | 2026-10-29 / 101.4 | / | — | T6BHKA | pa | No | — | Schedule 2026-10-29 / 101.4 → / | — |
| 02 Oct 2026, 6:35 am AEST | pa | Q6KNDC | 2BJ3PQ | NNV Pty ltd | updated | schedule | / | 2026-10-29 / 101.4 | — | T6BHKA | pa | No | — | Schedule / → 2026-10-29 / 101.4 | — |
| 02 Oct 2026, 1:00 am AEST | pa | Q6KNDC | 2BJ3PQ | NNV Pty ltd | updated | schedule | 2026-10-29 / 101.4 | / | — | T6BHKA | pa | No | — | Schedule 2026-10-29 / 101.4 → / | — |
| 02 Oct 2026, 12:34 am AEST | pa | Q6KNDC | 2BJ3PQ | NNV Pty ltd | updated | schedule | / | 2026-10-29 / 101.4 | — | T6BHKA | pa | No | — | Schedule / → 2026-10-29 / 101.4 | — |
| 01 Oct 2026, 7:00 pm AEST | pa | Q6KNDC | 2BJ3PQ | NNV Pty ltd | updated | schedule | 2026-10-29 / 101.4 | / | — | T6BHKA | pa | No | — | Schedule 2026-10-29 / 101.4 → / | — |
| 01 Oct 2026, 6:36 pm AEST | pa | Q6KNDC | 2BJ3PQ | NNV Pty ltd | updated | schedule | / | 2026-10-29 / 101.4 | — | T6BHKA | pa | No | — | Schedule / → 2026-10-29 / 101.4 | — |
| 01 Oct 2026, 1:01 pm AEST | pa | Q6KNDC | 2BJ3PQ | NNV Pty ltd | updated | schedule | 2026-10-29 / 101.4 | / | — | T6BHKA | pa | No | — | Schedule 2026-10-29 / 101.4 → / | — |
| 01 Oct 2026, 12:36 pm AEST | pa | Q6KNDC | 2BJ3PQ | NNV Pty ltd | updated | schedule | / | 2026-10-29 / 101.4 | — | T6BHKA | pa | No | — | Schedule / → 2026-10-29 / 101.4 | — |
| 01 Oct 2026, 7:01 am AEST | pa | Q6KNDC | 2BJ3PQ | NNV Pty ltd | updated | schedule | 2026-10-29 / 101.4 | / | — | T6BHKA | pa | No | — | Schedule 2026-10-29 / 101.4 → / | — |
| 01 Oct 2026, 6:40 am AEST | pa | Q6KNDC | 2BJ3PQ | NNV Pty ltd | updated | schedule | / | 2026-10-29 / 101.4 | — | T6BHKA | pa | No | — | Schedule / → 2026-10-29 / 101.4 | — |
| 01 Oct 2026, 1:00 am AEST | pa | Q6KNDC | 2BJ3PQ | NNV Pty ltd | updated | schedule | 2026-10-29 / 101.4 | / | — | T6BHKA | pa | No | — | Schedule 2026-10-29 / 101.4 → / | — |
| 01 Oct 2026, 12:35 am AEST | pa | Q6KNDC | 2BJ3PQ | NNV Pty ltd | updated | schedule | / | 2026-10-29 / 101.4 | — | T6BHKA | pa | No | — | Schedule / → 2026-10-29 / 101.4 | — |
| 30 Sep 2026, 6:40 pm AEST | pa | Q6KNDC | 2BJ3PQ | NNV Pty ltd | updated | schedule | 2026-10-29 / 101.4 | / | — | T6BHKA | pa | No | — | Schedule 2026-10-29 / 101.4 → / | — |
| 30 Sep 2026, 6:35 pm AEST | pa | Q6KNDC | 2BJ3PQ | NNV Pty ltd | updated | schedule | / | 2026-10-29 / 101.4 | — | T6BHKA | pa | No | — | Schedule / → 2026-10-29 / 101.4 | — |
| 30 Sep 2026, 1:01 pm AEST | pa | Q6KNDC | 2BJ3PQ | NNV Pty ltd | updated | schedule | 2026-10-29 / 101.4 | / | — | T6BHKA | pa | No | — | Schedule 2026-10-29 / 101.4 → / | — |
| 30 Sep 2026, 12:37 pm AEST | pa | Q6KNDC | 2BJ3PQ | NNV Pty ltd | updated | schedule | / | 2026-10-29 / 101.4 | — | T6BHKA | pa | No | — | Schedule / → 2026-10-29 / 101.4 | — |
| 30 Sep 2026, 7:01 am AEST | pa | Q6KNDC | 2BJ3PQ | NNV Pty ltd | updated | schedule | 2026-10-29 / 101.4 | / | — | T6BHKA | pa | No | — | Schedule 2026-10-29 / 101.4 → / | — |
| 30 Sep 2026, 6:35 am AEST | pa | Q6KNDC | 2BJ3PQ | NNV Pty ltd | updated | schedule | / | 2026-10-29 / 101.4 | — | T6BHKA | pa | No | — | Schedule / → 2026-10-29 / 101.4 | — |
| 30 Sep 2026, 1:00 am AEST | pa | Q6KNDC | 2BJ3PQ | NNV Pty ltd | updated | schedule | 2026-10-29 / 101.4 | / | — | T6BHKA | pa | No | — | Schedule 2026-10-29 / 101.4 → / | — |
| 30 Sep 2026, 12:35 am AEST | pa | Q6KNDC | 2BJ3PQ | NNV Pty ltd | updated | schedule | / | 2026-10-29 / 101.4 | — | T6BHKA | pa | No | — | Schedule / → 2026-10-29 / 101.4 | — |
| 29 Sep 2026, 7:00 pm AEST | pa | Q6KNDC | 2BJ3PQ | NNV Pty ltd | updated | schedule | 2026-10-29 / 101.4 | / | — | T6BHKA | pa | No | — | Schedule 2026-10-29 / 101.4 → / | — |
| 29 Sep 2026, 6:35 pm AEST | pa | Q6KNDC | 2BJ3PQ | NNV Pty ltd | updated | schedule | / | 2026-10-29 / 101.4 | — | T6BHKA | pa | No | — | Schedule / → 2026-10-29 / 101.4 | — |
| 29 Sep 2026, 1:57 pm AEST | pa | Q6KNDC | 2BJ3PQ | NNV Pty ltd | updated | schedule | 2026-10-29 / 101.4 | / | — | T6BHKA | pa | No | — | Schedule 2026-10-29 / 101.4 → / | — |
| 29 Sep 2026, 1:29 pm AEST | pa | Q6KNDC | 2BJ3PQ | NNV Pty ltd | updated | schedule | / | 2026-10-29 / 101.4 | — | T6BHKA | pa | No | — | Schedule / → 2026-10-29 / 101.4 | — |