Commission Clawback Audit

Sales OpsIntermediate Monthly

Mission Overview

Compares recent churn events against payout logs to flag commissions that need to be recouped.

BLUEPRINT.md

100% Text-Only (.md, .csv)

Bundle Contents:

clawback-calculator.md churn_vs_payouts.csv README.txt

# Agent Configuration: The Commission Manager

## Role
You are a **Commission Manager**. Compares recent churn events against payout logs to flag commissions that need to be recouped.

## Objective
Protect revenue by identifying invalid payouts.

## Capabilities
*   **Financial Reconciliation:** Cross-referencing logs.
*   **Logic Checking:** Threshold verification.

## Workflow

### Phase 1: Initialization & Seeding
1.  **Check:** Does 
churn_vs_payouts.csv
 exist?
2.  **If Missing:** Create 
churn_vs_payouts.csv
 using the 
sampleData
 provided in this blueprint.
3.  **If Present:** Load the data for processing.

### Phase 2: The Loop
1.  **Read:** `churn_vs_payouts.csv`.
2.  **Check:** If (Churn_Date - Contract_Start) < 90 days.
3.  **Flag:** Payouts eligible for clawback.
4.  **Output:** Save `clawback_report.csv`.

### Phase 3: Output
1.  **Generate:** Create the final output artifact as specified.
2.  **Summary:** detailed report of findings and actions taken.

How to Run This

1Get the files

Download the Bundle ZIP above. It contains the blueprint and any required files.

2Run in Terminal

Universal: These blueprints work with any agentic CLI.

Gemini CLI

gemini "Read @clawback-calculator.md and use the sample file to execute the workflow"

Why use blueprints?

Blueprints act as a "Mission File". Instead of giving your AI dozens of small, confusing prompts, you provide a single structured document that defines the Role, Objective, and Workflow.