INTERNAL · CLAUDE SKILLS · LIVE

Recurring audits, turned into Claude Skills.

Every week Operations runs the same handful of audits — pull an export, eyeball the rules, build a findings file. We've started encoding those audits as Claude Skills, so the work runs in one prompt. The rules live in plain English. The output is the same workbook Ops was building by hand.

2 audits live more in flight ~1 hour saved per audit, per week
The pattern

An audit becomes a skill in four steps.

A Claude Skill is a small folder with a description of when to use it and the exact procedure to follow. For an audit, the procedure is the thing Operations would tell a new hire: where the export lives, which columns matter, what counts as a finding, what the deliverable looks like. Once it's written down once, it can run every week.

01
Watch it once
Sit with the person running the audit. Capture the inputs, the rules, the output, and the edge cases.
02
Write it down
A SKILL.md in plain English — the rules of the audit, not code. Anyone on the team can read it and edit it.
03
Verify against the past
Re-run last week's audit through the skill and compare. The findings should match — and any diffs should be explainable.
04
Hand it the prompt
From there on, the audit is one message: drop the export, get the findings workbook back. Same format, same column order.
AUDITS RUNNING TODAY · TWO EXAMPLES
01 · Activity Review
📋
Live · weekly
HawkSoft activity audit

Every week HawkSoft exports thousands of activity items. Most are fine; a small handful break the ARO/RFR agent-assignment conventions. The skill pulls just the flagged rows into a findings workbook, with the reason written in plain English in the Remarks column.

Input Raw HawkSoft activity export (.xlsx)
Output Findings workbook — flagged rows only, reasons in Remarks
Rules ARO/RFR agent-column conventions (N/O/P)
Runs In one prompt — no Salesforce lookup needed
02 · Policy Reconciliation
🔗
Live · weekly
Salesforce closed-won audit

Every new policy entered into HawkSoft should have a matching closed-won opportunity in Salesforce. The skill checks every row against Salesforce, flags policies with no closed-won, and adds advisory notes when the sold policy number is pending or doesn't quite match.

Input HawkSoft new-policy export (.xlsx)
Output Full export with Remarks + a "Without Closed Won" sheet
Looks up Salesforce Accounts & Opportunities via Brightpath
Runs Extract IDs → query Salesforce → build workbook
How it runs
Claude Skill (SKILL.md) One prompt
Inputs
HawkSoft export .xlsx
Lookups
Salesforce (via Brightpath)
Output
Findings workbook Original column order Remarks column

Audit Skills are an internal pattern at YourPolicy — codifying the recurring work so the team can spend the hour somewhere else. More audits, more skills, every month.