一键导入
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.