원클릭으로
insurance-audit
Find insurance payments, total annual premiums, and compare to benchmarks.
Codex 또는 Claude로 설치 이 Prompt를 복사해 Codex, Claude 또는 다른 어시스턴트에 붙여 넣으면 Skill 페이지를 검토하고 설치를 진행할 수 있습니다.
메뉴
Find insurance payments, total annual premiums, and compare to benchmarks.
Codex 또는 Claude로 설치 이 Prompt를 복사해 Codex, Claude 또는 다른 어시스턴트에 붙여 넣으면 Skill 페이지를 검토하고 설치를 진행할 수 있습니다.
SOC 직업 분류 기준
Calculate break-even revenue by separating fixed and variable costs.
Project future cash flow using historical trends and recurring patterns.
Analyze revenue and costs per client to find your most profitable accounts.
Monitor 1099 contractor payments and flag $600 threshold.
Track unpaid invoices by age bucket and flag overdue payments.
Run a monthly bookkeeping close checklist with reconciliation.
| name | insurance-audit |
| description | Find insurance payments, total annual premiums, and compare to benchmarks. |
Identifies all insurance-related transactions in your history, calculates your total annual insurance spend, breaks it down by type (health, auto, home/renters, life, etc.), and compares your costs to typical ranges so you can spot overpaying.
transaction_search — find all insurance premium payments across your accountsRun transaction_search with query: "insurance OR premium OR Geico OR State Farm OR Allstate OR Progressive OR USAA OR Liberty Mutual OR Nationwide OR MetLife OR Aetna OR UnitedHealth OR Cigna OR Blue Cross OR Kaiser" and months: 12 to capture all insurance payments over the past year.
Group results by merchant/description and classify each into an insurance type:
For each type, calculate: payment frequency (monthly, quarterly, semi-annual, annual), per-payment amount, and total annual cost.
Present the insurance summary:
INSURANCE AUDIT
══════════════════════════════════════════════════
Type Frequency Payment Annual
──────────────── ────────── ──────── ────────
Auto Insurance Monthly $145 $1,740
Renters Ins. Monthly $18 $216
Health (direct) Monthly $380 $4,560
Life Insurance Monthly $42 $504
══════════════════════════════════════════════════
TOTAL ANNUAL INSURANCE COST: $7,020
% of Annual Income: X.X%
Compare each line to typical cost ranges:
Flag any insurance type significantly above the typical range.
Suggest action items: get comparison quotes for flagged policies, check for bundling discounts, review coverage levels and deductibles.
=SUM(C2:C7).=TotalPremiums / AnnualIncome * 100.