Their quarter has ended, and they still have until the deadline before this is actually late. A softer, earlier nudge, not an overdue notice.

These clients are marked "Reliable filer" (Contacts) and normally never need a nudge — skipped from the regular grace-period reminder above. This one's cutting it close, so it's worth a check.

Nothing is selected by default — check the ones you want to send. Rows showing "No recipient found" need an email typed into that row's Recipient field before they can actually be sent — if left blank, they'll be skipped and flagged rather than sent.

Every question a client has asked and not yet had answered. A row closes itself once a reply goes out in that Outlook thread, whether it was sent from here or typed straight into Outlook — and if you answered on the phone, say so, because nothing in a mailbox will ever show that.

These clients said they'd send a figure by a date that's now passed. Nothing is selected by default — check the ones you want to chase now.

Figures filed into the ledger that the insurer hasn't been told about yet. Goes to that insurer's Renewal contact unless you pick someone else from the Recipient dropdown on the line (renewal, risk underwriter, claim, other, or type an address) — rows showing "No recipient found" need one chosen or typed first. A row disappears once its declaration has actually been sent.

All four quarters are declared for the year and the declared turnover has earned brokerage above the minimum commission — so there is a supplementary commission still to invoice. Goes to Aurelien and the account manager, not to the client or the insurer. A row disappears once the email has gone; it comes back if the amount changes afterwards.

These are NOT in the lists above because a reminder has already gone out and the client is still inside the 14-day window to answer it. Nothing to send — each one comes back into its own list automatically if the declaration still hasn't arrived by then. Worth a phone call rather than another email if it's urgent.

A client already told us when to expect this — nothing to do here, just confirmation it's being tracked. The plain reminder for these is suppressed until the promised time passes; if it does with nothing received, it moves to "Promised, but overdue" above automatically.

Late by 30+ days with at least 2 reminders already sent for that quarter. Two separate actions: an escalation email to the client (CC'd to their Decision maker contact, when one's confirmed), and an internal note flagging the account manager that this one may need a phone call instead of another email.

Already escalated a while ago with no reply or declaration since — more email likely won't help here. Dismiss once you've picked it up some other way (e.g. a call), so it stops appearing.

These clients have filed every declared quarter on time, on their own, without ever needing a reminder. Marking one skips the early grace-period nudge for them going forward (see Contacts).

These lines have no Policy Starting date on file, so TOD Eros can't work out a deadline for them at all — they never appear in any of the lists above, even if genuinely overdue. Add a start date to bring them under tracking.

Nothing is selected by default — check the ones you want to send. Rows showing "No contact on file" need an insurer contact email set first (Admin → Insurer contacts) or typed directly into that row.

A renewal was requested but the insurer hasn't sent terms yet, and expiry is close or has already passed. Nothing is selected by default — check the ones you want to escalate now.

Already chased, not yet due for an escalation. Mark one received once the insurer actually sends terms (e.g. read via "Scan renewal offer"), so it stops being tracked here.

These policies expired with no later row on file for the same client — either the renewal hasn't been added to the ledger yet, or the client didn't renew. Dismiss the ones that are genuinely not renewing so they stop appearing here.

Searches Outlook for replies to a renewal request this app sent. A matching reply is automatically marked received (no approval needed — nothing is sent, nothing financial is written); if it has an attachment, it's kept ready to review below instead of you having to download and re-upload it into "Scan renewal offer".

No email either direction in over 90 days, and nothing else currently needs chasing (no late declaration, broken promise, or renewal issue) — a good candidate for a friendly check-in rather than another nag. Nothing is selected by default.

Searches Outlook for a client asking to increase a buyer's credit limit. Confirm the client if it wasn't matched automatically, then select and send to the insurer's underwriters — nothing is selected by default.

Searches Outlook for the underwriters' reply and records their decision automatically (no approval needed — nothing is sent, and this is just a record of what the insurer decided, not their own system of record for the limit). An underwriter who answers by phone, or who never answers at all, leaves nothing for that search to find — so type what they granted straight into the row instead. Anything waiting more than a week is flagged for chasing.

The insurer has responded — select and send to let the client know the outcome as fast as possible. Nothing is selected by default.

Every credit limit request on record and what came of it — what the client asked for, what the insurer granted, how we found that out, and when. Newest first.

More reliable for a per-buyer breakdown with many rows and no single total cell — this sums every row itself with real arithmetic instead of an AI estimate from reading the sheet. Download the attachment from the client's email first, then upload it here.

Each row is one reply — a figure ready to file, a promise to send one later, a question/dispute that needs your own attention, or a credit limit the client has asked for. Check the matched policy and details, then file the ones you trust. Nothing is written to the ledger until you click File.

A thank-you for anything filed, or a request for clarification for anything skipped. Review and edit before sending — nothing goes out until you click Send.

A question or a dispute — these need an actual answer, not an AI's best guess, so nothing is auto-drafted here. Reply to these yourself directly in Outlook.

Click "Scan all clients" to check everyone, or pick one client above — this hasn't been run yet.

Which ledger client is this claim for? Required before scanning, so the claim is linked correctly from the start.

When was this overdue account actually reported to the insurer? Required upfront — this drives the KPI delay calculation, so it's entered directly rather than relying on the document to state it clearly.

Notification, invoices, statement of account — select multiple at once if your file picker allows it, or click "Choose claim file(s)" again to add more one at a time. Accepts PDF, images, Excel (.xlsx/.xls), CSV, or an Outlook .eml (including any attachments saved inside it).

Used to check the claim's dates against the policy period and waiting period.