Lookup
Search by rego, DD code, customer, policy, or Stripe ID.
Normalised key: 1QG7NB
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 342SYC | 1QG7NB | Paused | Geoff SCHMAMAN | 24KBNA | $100.00 | monthly | 06 Nov 2026 | 08 Oct 2026, 4:01 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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 1QG7NB | 1QG7NB | MRC10915446 | Geoff Schmaman | 70550000000886194 | Cancel | 04 May 2026 | 24 Sep 2026 | $100.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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1QG7NB | Active | Geoff Schmaman | 70550000000886194 | pm_1UO713RpoEUmWmwq4zQh4adH | cus_Uv0NEYNsN3yfNg | Card | Waiting for next one | 06 Nov 2026 | $100.00 | — | Monthly | 24 Sep 2026 | — | — | 24 Sep 2026, 1:31 pm AEST | 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15 Oct 2026, 7:10 pm AEDT | mrc | 70550000012567248 | 1QG7NB | Geoff Schmaman | removed | — | CANCEL | REMOVED | 24 Sep 2026, 1:41 pm AEST | 70550000000886194 | zoho_contact | No | — | MRC Policies record removed | — |
| 15 Oct 2026, 1:10 pm AEDT | mrc | 70550000012567248 | 1QG7NB | Geoff Schmaman | removed | — | CANCEL | REMOVED | 24 Sep 2026, 1:41 pm AEST | 70550000000886194 | zoho_contact | No | — | MRC Policies record removed | — |
| 15 Oct 2026, 10:01 am AEDT | pa | 342SYC | 1QG7NB | Geoff SCHMAMAN | removed | — | PAUSED | REMOVED | — | 24KBNA | pa | No | — | Pay Advantage record removed | — |
| 12 Oct 2026, 1:21 pm AEDT | pa | 342SYC | 1QG7NB | Geoff SCHMAMAN | removed | — | PAUSED | REMOVED | — | 24KBNA | pa | No | — | Pay Advantage record removed | — |
| 08 Oct 2026, 4:14 pm AEDT | transition | au:70550000017708004 | 1QG7NB | Geoff Schmaman | status_change | assureus_transition_status | HIGH RISK – FLEET AUTHORISED | TRANSFERRED – CLEAN | — | — | — | No | — | AssureUs transition status HIGH RISK – FLEET AUTHORISED → TRANSFERRED – CLEAN | — |
| 08 Oct 2026, 4:11 pm AEDT | au | 70550000017708004 | 1QG7NB | Geoff Schmaman | updated | schedule | 2026-10-06 | 2026-11-06 | 08 Oct 2026, 3:43 pm AEDT | 70550000000886194 | zoho_contact | No | — | Schedule 2026-10-06 → 2026-11-06 | — |
| 08 Oct 2026, 4:11 pm AEDT | au | 70550000017708004 | 1QG7NB | Geoff Schmaman | updated | payment_status | PENDING SETUP | WAITING FOR NEXT ONE | 08 Oct 2026, 3:43 pm AEDT | 70550000000886194 | zoho_contact | No | — | Payment status PENDING SETUP → WAITING FOR NEXT ONE | — |
| 08 Oct 2026, 4:11 pm AEDT | au | 70550000017708004 | 1QG7NB | Geoff Schmaman | updated | payment_method | — | CARD | 08 Oct 2026, 3:43 pm AEDT | 70550000000886194 | zoho_contact | No | — | Payment method — → CARD | — |
| 08 Oct 2026, 4:11 pm AEDT | au | 70550000017708004 | 1QG7NB | Geoff Schmaman | updated | stripe_payment_id | — | QH4ADH | 08 Oct 2026, 3:43 pm AEDT | 70550000000886194 | zoho_contact | No | — | Stripe Payment ID added (QH4ADH) | — |
| 08 Oct 2026, 4:01 pm AEDT | pa | 342SYC | 1QG7NB | Geoff SCHMAMAN | status_change | status | ACTIVE | PAUSED | — | 24KBNA | pa | No | — | Status ACTIVE → PAUSED | — |
| 08 Oct 2026, 2:26 pm AEDT | transition | au:70550000017708004 | 1QG7NB | Geoff Schmaman | status_change | assureus_transition_status | TRANSFERRED – AWAITING STRIPE | HIGH RISK – FLEET AUTHORISED | — | — | — | No | — | AssureUs transition status TRANSFERRED – AWAITING STRIPE → HIGH RISK – FLEET AUTHORISED | — |
| 08 Oct 2026, 1:26 am AEDT | mrc | 70550000012567248 | 1QG7NB | Geoff Schmaman | updated | cover_type | RIDE SHARE | COMPREHENSIVE CAR COVER | 24 Sep 2026, 1:41 pm AEST | 70550000000886194 | zoho_contact | No | — | cover_type RIDE SHARE → COMPREHENSIVE CAR COVER | — |
| 08 Oct 2026, 1:20 am AEDT | au | 70550000017708004 | 1QG7NB | Geoff Schmaman | updated | cover_type | — | COMPREHENSIVE COVER | 01 Oct 2026, 4:44 pm AEST | 70550000000886194 | zoho_contact | No | — | cover_type — → COMPREHENSIVE COVER | — |
| 08 Oct 2026, 1:10 am AEDT | mrc | 70550000012567248 | 1QG7NB | Geoff Schmaman | updated | cover_type | — | RIDE SHARE | 24 Sep 2026, 1:41 pm AEST | 70550000000886194 | zoho_contact | No | — | cover_type — → RIDE SHARE | — |
| 06 Oct 2026, 9:02 am AEDT | pa | 342SYC | 1QG7NB | Geoff SCHMAMAN | updated | schedule | 2026-10-06 / 101.4 | 2026-11-06 / 101.4 | — | 24KBNA | pa | No | — | Schedule 2026-10-06 / 101.4 → 2026-11-06 / 101.4 | — |
| 02 Oct 2026, 11:01 pm AEST | pa | 342SYC | 1QG7NB | Geoff SCHMAMAN | updated | schedule | / | 2026-10-06 / 101.4 | — | 24KBNA | pa | No | — | Schedule / → 2026-10-06 / 101.4 | — |
| 02 Oct 2026, 11:00 pm AEST | pa | 342SYC | 1QG7NB | Geoff SCHMAMAN | updated | schedule | 2026-10-06 / 101.4 | / | — | 24KBNA | pa | No | — | Schedule 2026-10-06 / 101.4 → / | — |
| 02 Oct 2026, 10:50 pm AEST | pa | 342SYC | 1QG7NB | Geoff SCHMAMAN | updated | schedule | / | 2026-10-06 / 101.4 | — | 24KBNA | pa | No | — | Schedule / → 2026-10-06 / 101.4 | — |
| 02 Oct 2026, 10:49 pm AEST | pa | 342SYC | 1QG7NB | Geoff SCHMAMAN | updated | schedule | 2026-10-06 / 101.4 | / | — | 24KBNA | pa | No | — | Schedule 2026-10-06 / 101.4 → / | — |
| 02 Oct 2026, 10:45 pm AEST | pa | 342SYC | 1QG7NB | Geoff SCHMAMAN | updated | schedule | / | 2026-10-06 / 101.4 | — | 24KBNA | pa | No | — | Schedule / → 2026-10-06 / 101.4 | — |
| 02 Oct 2026, 10:44 pm AEST | pa | 342SYC | 1QG7NB | Geoff SCHMAMAN | updated | schedule | 2026-10-06 / 101.4 | / | — | 24KBNA | pa | No | — | Schedule 2026-10-06 / 101.4 → / | — |
| 02 Oct 2026, 10:39 pm AEST | pa | 342SYC | 1QG7NB | Geoff SCHMAMAN | updated | schedule | / | 2026-10-06 / 101.4 | — | 24KBNA | pa | No | — | Schedule / → 2026-10-06 / 101.4 | — |
| 02 Oct 2026, 10:39 pm AEST | pa | 342SYC | 1QG7NB | Geoff SCHMAMAN | updated | schedule | 2026-10-06 / 101.4 | / | — | 24KBNA | pa | No | — | Schedule 2026-10-06 / 101.4 → / | — |
| 02 Oct 2026, 10:01 pm AEST | pa | 342SYC | 1QG7NB | Geoff SCHMAMAN | updated | schedule | / | 2026-10-06 / 101.4 | — | 24KBNA | pa | No | — | Schedule / → 2026-10-06 / 101.4 | — |
| 02 Oct 2026, 10:00 pm AEST | pa | 342SYC | 1QG7NB | Geoff SCHMAMAN | updated | schedule | 2026-10-06 / 101.4 | / | — | 24KBNA | pa | No | — | Schedule 2026-10-06 / 101.4 → / | — |
| 02 Oct 2026, 9:24 pm AEST | pa | 342SYC | 1QG7NB | Geoff SCHMAMAN | updated | schedule | / | 2026-10-06 / 101.4 | — | 24KBNA | pa | No | — | Schedule / → 2026-10-06 / 101.4 | — |
| 02 Oct 2026, 9:24 pm AEST | pa | 342SYC | 1QG7NB | Geoff SCHMAMAN | updated | schedule | 2026-10-06 / 101.4 | / | — | 24KBNA | pa | No | — | Schedule 2026-10-06 / 101.4 → / | — |
| 02 Oct 2026, 9:01 pm AEST | pa | 342SYC | 1QG7NB | Geoff SCHMAMAN | updated | schedule | / | 2026-10-06 / 101.4 | — | 24KBNA | pa | No | — | Schedule / → 2026-10-06 / 101.4 | — |
| 02 Oct 2026, 9:00 pm AEST | pa | 342SYC | 1QG7NB | Geoff SCHMAMAN | updated | schedule | 2026-10-06 / 101.4 | / | — | 24KBNA | pa | No | — | Schedule 2026-10-06 / 101.4 → / | — |
| 02 Oct 2026, 8:25 pm AEST | pa | 342SYC | 1QG7NB | Geoff SCHMAMAN | updated | schedule | / | 2026-10-06 / 101.4 | — | 24KBNA | pa | No | — | Schedule / → 2026-10-06 / 101.4 | — |
| 02 Oct 2026, 8:24 pm AEST | pa | 342SYC | 1QG7NB | Geoff SCHMAMAN | updated | schedule | 2026-10-06 / 101.4 | / | — | 24KBNA | pa | No | — | Schedule 2026-10-06 / 101.4 → / | — |
| 02 Oct 2026, 8:01 pm AEST | pa | 342SYC | 1QG7NB | Geoff SCHMAMAN | updated | schedule | / | 2026-10-06 / 101.4 | — | 24KBNA | pa | No | — | Schedule / → 2026-10-06 / 101.4 | — |
| 02 Oct 2026, 8:00 pm AEST | pa | 342SYC | 1QG7NB | Geoff SCHMAMAN | updated | schedule | 2026-10-06 / 101.4 | / | — | 24KBNA | pa | No | — | Schedule 2026-10-06 / 101.4 → / | — |
| 02 Oct 2026, 7:27 pm AEST | pa | 342SYC | 1QG7NB | Geoff SCHMAMAN | updated | schedule | / | 2026-10-06 / 101.4 | — | 24KBNA | pa | No | — | Schedule / → 2026-10-06 / 101.4 | — |
| 02 Oct 2026, 7:27 pm AEST | pa | 342SYC | 1QG7NB | Geoff SCHMAMAN | updated | schedule | 2026-10-06 / 101.4 | / | — | 24KBNA | pa | No | — | Schedule 2026-10-06 / 101.4 → / | — |
| 02 Oct 2026, 7:24 pm AEST | pa | 342SYC | 1QG7NB | Geoff SCHMAMAN | updated | schedule | / | 2026-10-06 / 101.4 | — | 24KBNA | pa | No | — | Schedule / → 2026-10-06 / 101.4 | — |
| 02 Oct 2026, 7:24 pm AEST | pa | 342SYC | 1QG7NB | Geoff SCHMAMAN | updated | schedule | 2026-10-06 / 101.4 | / | — | 24KBNA | pa | No | — | Schedule 2026-10-06 / 101.4 → / | — |
| 02 Oct 2026, 7:01 pm AEST | pa | 342SYC | 1QG7NB | Geoff SCHMAMAN | updated | schedule | / | 2026-10-06 / 101.4 | — | 24KBNA | pa | No | — | Schedule / → 2026-10-06 / 101.4 | — |
| 02 Oct 2026, 7:00 pm AEST | pa | 342SYC | 1QG7NB | Geoff SCHMAMAN | updated | schedule | 2026-10-06 / 101.4 | / | — | 24KBNA | pa | No | — | Schedule 2026-10-06 / 101.4 → / | — |
| 02 Oct 2026, 6:19 pm AEST | pa | 342SYC | 1QG7NB | Geoff SCHMAMAN | updated | schedule | / | 2026-10-06 / 101.4 | — | 24KBNA | pa | No | — | Schedule / → 2026-10-06 / 101.4 | — |
| 02 Oct 2026, 6:18 pm AEST | pa | 342SYC | 1QG7NB | Geoff SCHMAMAN | updated | schedule | 2026-10-06 / 101.4 | / | — | 24KBNA | pa | No | — | Schedule 2026-10-06 / 101.4 → / | — |
| 02 Oct 2026, 6:02 pm AEST | pa | 342SYC | 1QG7NB | Geoff SCHMAMAN | updated | schedule | / | 2026-10-06 / 101.4 | — | 24KBNA | pa | No | — | Schedule / → 2026-10-06 / 101.4 | — |
| 02 Oct 2026, 6:01 pm AEST | pa | 342SYC | 1QG7NB | Geoff SCHMAMAN | updated | schedule | 2026-10-06 / 101.4 | / | — | 24KBNA | pa | No | — | Schedule 2026-10-06 / 101.4 → / | — |
| 02 Oct 2026, 5:18 pm AEST | pa | 342SYC | 1QG7NB | Geoff SCHMAMAN | updated | schedule | / | 2026-10-06 / 101.4 | — | 24KBNA | pa | No | — | Schedule / → 2026-10-06 / 101.4 | — |
| 02 Oct 2026, 5:17 pm AEST | pa | 342SYC | 1QG7NB | Geoff SCHMAMAN | updated | schedule | 2026-10-06 / 101.4 | / | — | 24KBNA | pa | No | — | Schedule 2026-10-06 / 101.4 → / | — |
| 02 Oct 2026, 5:02 pm AEST | pa | 342SYC | 1QG7NB | Geoff SCHMAMAN | updated | schedule | / | 2026-10-06 / 101.4 | — | 24KBNA | pa | No | — | Schedule / → 2026-10-06 / 101.4 | — |
| 02 Oct 2026, 5:01 pm AEST | pa | 342SYC | 1QG7NB | Geoff SCHMAMAN | updated | schedule | 2026-10-06 / 101.4 | / | — | 24KBNA | pa | No | — | Schedule 2026-10-06 / 101.4 → / | — |
| 02 Oct 2026, 4:30 pm AEST | pa | 342SYC | 1QG7NB | Geoff SCHMAMAN | updated | schedule | / | 2026-10-06 / 101.4 | — | 24KBNA | pa | No | — | Schedule / → 2026-10-06 / 101.4 | — |
| 02 Oct 2026, 4:29 pm AEST | pa | 342SYC | 1QG7NB | Geoff SCHMAMAN | updated | schedule | 2026-10-06 / 101.4 | / | — | 24KBNA | pa | No | — | Schedule 2026-10-06 / 101.4 → / | — |
| 02 Oct 2026, 4:16 pm AEST | pa | 342SYC | 1QG7NB | Geoff SCHMAMAN | updated | schedule | / | 2026-10-06 / 101.4 | — | 24KBNA | pa | No | — | Schedule / → 2026-10-06 / 101.4 | — |