A newer version of this app has been shared with the team. Since artifacts can't update themselves automatically, please refresh this page — or ask whoever shared the latest version for the current link — to make sure you're working from the same data and features as everyone else.
You sell love — everybody is looking for attention: wife, husband, kids, and clients. Going the extra mile for your clients will make a huge difference.
Alert
✓
Account Manager
Guy name
Guy to chase
Policy No.
Insurer
Group
Client
Policy start
Policy expiry
Q1
Q2
Q3
Q4
Total declared
Insurable turnover
Commission %
Premium %
Paid premium
Min. commission
Supp. commission
Remarks
Policy doc
Loading your data — if a permission prompt appears, click Allow to continue…
Totals, premiums and commissions are calculated live from what you enter — they're not stored as separate numbers, so they can't drift out of sync the way they can in a spreadsheet. Data here is shared live with everyone logged in to this app.
TOD Agent
Finds every policy with an overdue quarterly turnover declaration and lets you send reminder emails in one batch.
Grace period — declaration due soon
Their quarter has ended, and they still have until the deadline before this is actually late. A softer, earlier nudge, not an overdue notice.
Client
Policy No
Quarter
Deadline
Recipient
Subject / body
Status
No overdue turnover declarations right now — everything's on time or already completed.
Uncheck any you don't want to include. 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.
Client
Policy No
Quarter
Days late
Recipient
Subject / body
Status
Promised, but overdue
These clients said they'd send a figure by a date that's now passed. Uncheck any you don't want to chase yet.
Client
Quarter
Promised by
Days overdue
Recipient
Subject / body
Status
Turnover figures found in replies
Read from clients' email replies — review and correct anything before filing it into the ledger.
Or upload a TOD file directly
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.
No turnover figures found in any recent replies.
Each row is one reply — a figure ready to file, a promise to send one later, or a question/dispute that needs your own attention. Check the matched policy and details, then file the ones you trust. Nothing is written to the ledger until you click File.
From
Type
Matched policy
Quarter
Turnover value / date
From the email
Status
Reply to these clients
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.
To
Type
Subject / body
Status
Needs your personal attention
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.
Send email
Sends via your Outlook (Microsoft 365 connector) — review before sending
Log in
TO Declarations Ledger — AU Group
Team access
Manage who can log in and the shared passcode
Shared passcode
Team members
Scan a claim
Upload the claim document(s) and the policy, so the timeline can be checked against the contract
1. Client
Which ledger client is this claim for? Required before scanning, so the claim is linked correctly from the start.
2. Date of notification
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.
3. Claim document(s)
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), or CSV.
No files selected yet
4. Policy document
Used to check the claim's dates against the policy period and waiting period.
No file selected yet
Raw response (for debugging)
Declare by month
The three months are added together to give the quarter's total
Export
Downloads are blocked in this view — copy the data below instead and paste it into Excel or Google Sheets. It will split into columns automatically.
Scan renewal offer
Which client is this renewal offer for?
Renewal comparison
Compare the expiring policy against renewal offers from other insurers
Edit claim
Changes are saved as an override on top of the imported record
Claims
Imported from Claims.xlsx — linked to client policies where the name could be matched with confidence
Alert
Insurer
Existing client
Year
Date of Notification
Group
Client (from claims file)
Linked ledger client
Buyer
Country
Open/Closed
Limit
OVD amount
Eligible
Deductible
Recoveries
Cheque bounced
Oldest invoice
Due date
MEP
Last day for NOA
Last day RFI
Submitted by PH
KPI OVD notif. delay
Claim submission delay
Reason
Possible indemn.
Actual indemn.
Comments
Status
Reading the documents…
Extracting dates, premium rate and brokerage from the files.
Adding Client
Upload the policy and credit note — Claude reads them and pre-fills the line
1. Policy document
Click to choose the policy PDF
2. Credit note (brokerage)
Click to choose the credit note
New policy line
Policy period & rate
Brokerage (from credit note)
Client
Confirm
Client
Claims summary only
Client
Client & policy
Premium & brokerage
Cover
Claims
Claim timeline (for checking claim validity)
Terms
Download Excel file
Your file is ready. Click the button below to download it.