RAG Status Explained: Reading a Compliance Dashboard at a Glance
By Rovaryn Digital · June 3, 2026
What is RAG status — and why does it belong on a compliance dashboard?
It's Tuesday morning. You open a spreadsheet that tracks fourteen contractor licenses across four states. You scan down the expiration-date column looking for anything that's about to lapse. Two rows have dates that look close. One of them is in a state where the grace period is thirty days. Another is a license held by your lead technician — the qualifying party on your Florida permits. You do some mental arithmetic. You're not sure which one is actually urgent.
That mental arithmetic is the problem RAG status solves.
RAG is an acronym for Red / Amber / Green, a three-level visual classification used in project management and operations dashboards to communicate status at a glance — without requiring the reader to interpret raw dates or do arithmetic. In a compliance dashboard, each license, bond, insurance certificate, or CE-hour balance is assigned one of the three colors based on a calculated threshold: typically the number of days remaining before the item expires or a required action must be complete.
This article explains what each color means, how the thresholds are set, and why this classification system is the foundation of a portfolio that a busy office manager can actually act on.
Green, amber, red: what each signal means in practice
The three colors map to three operational states.
Green — current, no action needed. The item has enough runway that no immediate action is warranted. Standard practice puts the green threshold at 61 or more days to expiry, though some shops prefer a wider buffer for licenses that require CE hours to be completed before renewal can be submitted. When everything in your portfolio is green, you can spend Tuesday on something other than license tracking.
Amber — action window open. The item is not yet expired, but the renewal window — or the CE-completion window — is open and the clock is running. A common amber band is 31–60 days to expiry. At amber, the task has a clear owner and a firm deadline. Waiting is still technically fine; ignoring it is not. Amber is the signal that turns an upcoming renewal from a background item into a scheduled task.
Red — critical, immediate attention required. Either the item has 30 days or fewer remaining, or it has already expired. At red, the risk is real: in most states, a contractor cannot legally perform work while a license is expired, and many states impose escalating reinstatement fees for late renewals. (Texas HVAC licenses, for example, carry penalty fees at 1.5× the normal renewal cost if renewed within the first 90 days of expiry, and 2× the cost after that.) Anything red in your portfolio demands same-day attention, not a note for later in the week.
A RAG status is only as useful as the threshold it's built on. Know your renewal intervals and grace periods before you set your amber and red cutoffs.
How days-to-expiry becomes a color
The calculation is straightforward:
days_to_expiry = expiration_date − today
The compliance system evaluates that number against a pair of thresholds — a red threshold (e.g., ≤30 days) and an amber threshold (e.g., 31–60 days) — and assigns the color accordingly. Everything above the amber threshold is green.
Worked example. Suppose a shop tracks 12 licenses across three states. On a given day:
- 9 licenses have 90+ days remaining → Green
- 2 licenses have 35 and 48 days remaining → Amber
- 1 license has 22 days remaining → Red
The office manager opens the dashboard and sees one red row and two amber rows instantly, without reading dates or doing arithmetic. The remaining nine rows are background noise until the next review.
This is the core design principle: the dashboard surfaces the items that need attention and suppresses the items that don't, so the person responsible for compliance can direct effort rather than audit everything every morning.
Why threshold defaults matter — and when to customize them
Standard thresholds (≤30 days = red, 31–60 days = amber) work well for licenses with straightforward renewal processes — pay a fee, submit the form, receive the renewed certificate. But several common situations call for wider thresholds.
Continuing education (CE) requirements. Many states require a fixed number of CE hours to be completed before a license can be renewed. (Virginia requires a 3-hour CE course per discipline; North Carolina requires 8 hours annually, including a mandatory 2-hour course.) If a technician realizes at day 29 that their CE hours aren't done, "renew immediately" may not be possible — CE providers may have booking lead times, and some states only run approved courses on a limited schedule. For licenses with CE prerequisites, setting amber at 90 days rather than 60 gives the technician time to complete the hours before the renewal window becomes critical. You can read more about how renewal intervals affect your planning calendar.
Bond and insurance certificates. A lapsed surety bond can trigger a license suspension independent of the license's own expiration date. California, for example, requires every licensed contractor to maintain a $25,000 contractor license bond; if the bond lapses, the license becomes inactive immediately. Florida law allows a contractor's license to be suspended if a required surety bond expires or is cancelled. Bond and COI (certificate of insurance) expiry dates often don't align with license renewal dates — they run on separate renewal cycles and deserve their own RAG tracking with their own thresholds.
Multi-state portfolios. When a shop operates across multiple states, different items expire on different calendars. A compliance dashboard that applies a single static threshold to every item will either miss critical items or flag too many amber items to be useful. The practical solution is to set per-item or per-category thresholds — wider amber windows for CE-dependent licenses, standard windows for straightforward fee-and-form renewals — so that the dashboard's signal remains meaningful. Learn how this works across a full portfolio in the multi-state trade license compliance guide.
What RAG status does not tell you
Understanding the limits of a RAG signal is as important as understanding what it shows.
RAG is a countdown, not a checklist. A license showing amber at 45 days may require three separate actions: completing CE hours, submitting a renewal application, and uploading a new certificate of insurance. The color tells you the item needs attention; it does not tell you which step is pending or who owns it. A well-designed compliance system pairs RAG status with a renewal checklist that itemizes the actions per license type.
RAG reflects the data it's given. If an expiration date is entered incorrectly, or if a license was quietly renewed by an outside vendor without updating the system, the color is wrong. The dashboard is only as accurate as the records behind it. Periodic audits — even a quarterly check against the issuing board's public register — are necessary hygiene alongside any automated system. The how to track contractor license renewals across multiple states guide covers audit routines in detail.
RAG doesn't replace alerts. A color on a dashboard requires someone to open the dashboard. For licenses approaching critical deadlines, a dashboard check is not a substitute for proactive notifications. The two systems — visual status and scheduled alerts — are complementary. For a full treatment of how automated alerts layer with dashboard monitoring, see the automated license renewal alerts guide.
Connecting the dashboard to your compliance workflow
A RAG dashboard works best as the starting point of a daily or weekly compliance review, not a passive display. A practical workflow might look like this:
- Open the dashboard each Monday morning. Scan for any red items first; assign same-day owners.
- Review all amber items. Confirm that a renewal task is already in progress. If not, open one.
- Check the expiring-soon report. Items that will cross into amber within the next 30 days should be visible before they turn amber — this is the early-warning layer. The expiring-soon reports guide explains how that report complements the dashboard view.
- Log completions promptly. When a license is renewed or a CE course is finished, update the record. An amber item that stays amber after renewal has been submitted is a data-quality problem, not a compliance problem.
The features overview shows how these workflows are mapped inside Trade License Compliance Manager.
The single number that makes it all legible
RAG status compliance is ultimately a compression technique. A portfolio of 20 licenses, 20 bonds, and 15 CE-hour balances across five states is 55 individual data points. A compliance dashboard compresses those 55 points into three buckets — and on a good Tuesday, all three amber items are already assigned and the red bucket is empty.
That's the goal: a dashboard where the absence of red is the daily confirmation that the portfolio is under control, and the presence of red is an unambiguous instruction to act now.
Stay current on compliance concepts
Subscribe to the Trade License Compliance Manager newsletter for plain-English explanations of license requirements, renewal timelines, and compliance workflow — delivered once a month, no noise.
Stay sharp on trade licensing.
Practical guides delivered to your inbox.
Browse our compliance templates
Browse templates
