Report this item to Etsy

Citizens Insurance Florida Non-Renewal Takeout Client Tracker for Agents, Google Sheets Excel, Renewal Tracker, Client Letters

NowPrice:$0.99

Original Price: $1.98

Loading

50% off

•

Sale ends on November 30

Includes Etsy Purchase Protection

You can only make an offer when buying a single item

Highlights

  • Designed by SkynetLabs
  • Digital download
  • Digital file type(s): 1 File

Citizens Insurance non-renewal and takeout client tracker for Florida agents.

WHAT IT IS
A Google Sheets and Excel tracker for Florida independent agents who have Citizens Property Insurance clients getting non-renewal notices or takeout offers. For each client it tracks the notice, the Offer Form choice date, the Citizens expiration date, every carrier you ask, the quotes that come back, and the decision. A TODAY tab lists who to work on first and which letter to send.

SEE ONE SAMPLE
This is letter C05, the choice date reminder, shortened from the Word file:

Subject: Action needed by [Choice date]: your Citizens policy
Hi [First Name],
Your choice date for the Citizens policy at [Property Address] is [Choice date], which is [Number] days away.
Your three paths: take a private offer, stay with Citizens if your letter says you are eligible, or do nothing, in which case Citizens can assign your policy to the private company with the lowest estimated premium.

THE PERCENT IS YOURS TO SET
Two takeout percents are in use. Citizens' own agent pages say 20% for personal lines. A 2026 Florida law (SB 1028) sets 15% for commercial risks offered surplus lines coverage through a new commercial clearinghouse, and some press quotes 15% generally. So the percent is not hard-coded. It sits in an editable RULES tab, dated Oct 2026, with a reminder to confirm it with Citizens and the Florida OIR. The tracker warns you when your last check is more than 90 days old.

WHAT YOU GET (1 ZIP, 4 files)
- Tracker (.xlsx) with 6 tabs: START HERE, TODAY, CLIENTS, OFFERS, LETTERS and RULES. Dropdowns, colour-coded status, example rows to delete.
- Printable PDF guide (14 pages): the rules page, what each status means, and all 12 letters.
- Word file with 12 editable client messages: 8 emails, 2 texts, a call script and a file note. Yellow [brackets] mark what to fill in.
- READ-ME-FIRST.pdf: a 2-page quick start.

WHAT THE TRACKER DOES
- Works out each client's days to the choice date and to expiration, and when a non-renewal notice is expected.
- Adds your threshold percent to the Citizens renewal premium and shows where the lowest comparable offer sits against it.
- Ranks clients by urgency: deadline passed, deadline soon, expiry soon, bind, confirm stay, need decision, need quotes, watch.
- Logs every carrier, wholesaler or MGA you approach, and flags quotes that need a chase.
- Names the letter to send for each status (for example C05, the choice date reminder).

HOW IT WORKS
1. Download and unzip. Open RULES and confirm the percent and day counts.
2. Add each Citizens client on CLIENTS. Add the notice type, notice date and Offer Form choice date when the letter arrives.
3. Log every carrier you ask on OFFERS, declines too.
4. Open TODAY each morning and do what it says.

WHO IT'S FOR
- Florida independent P&C agents and small agencies with Citizens clients
- Agency staff who handle renewals and re-marketing
- Agents who want one place to see dates, offers and decisions

GOOD TO KNOW
- This is a spreadsheet, letters and a PDF. It is not software, it does not send messages, and it does not connect to Citizens.
- It flags where an offer sits against a percent you set. Whether coverage is comparable, and whether a policy can stay with Citizens, is decided in the Citizens process.
- Letters were drafted with AI assistance and edited by SkynetLabs. Please read each one and make it yours.
- Example clients and offers in the tracker are fake. Delete them before you start.
- Florida only. Editable template for tracking and documentation. Not legal advice and not insurance advice. Rules as of Oct 2026: confirm with Citizens and the Florida OIR, and have your compliance officer or E&O carrier review before use.

FAQ
Do I need Excel? No. It works in Google Sheets (free) or Excel.
Does it contain the current Citizens rules? It contains the rules as of Oct 2026 in an editable table, with pointers to where to check them. Rules change, so confirm them.
Can I change the words? Yes. Every letter and every status text is editable.
Can I resell it? No. Use is for your own agency only.
Is there a refund? Digital items are generally non-refundable. If a file has a problem, message me and I will fix it.

INSTANT DIGITAL DOWNLOAD. No physical item will be shipped. After purchase, your files are available on Etsy right away under Purchases and Reviews > Download Files.

Instant Download

Your files will be available to download once payment is confirmed.  Here's how.

Instant download items don’t accept returns, exchanges or cancellations. Please contact the seller about any problems with your order.

Etsy Purchase Protection
Shop confidently on Etsy knowing if something goes wrong with an order, we've got your back for all eligible purchases — see program terms

You may also like

Shoppers with similar taste loved these

Show more
Show more
Listed on Oct 20, 2026