# API Usage Biller

> ---

- Skill: `akhilkannur/api-usage-biller` (Agent Skill)
- Install (CLI): `npx skillmds@latest add akhilkannur/api-usage-biller`
- Raw SKILL.md: https://api.skillmd.com/api/skills/akhilkannur/api-usage-biller/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Integrations & APIs
- Author: akhilkannur (https://skillmd.com/u/akhilkannur)
- Updated: 2026-09-17
- Page: https://skillmd.com/skills/akhilkannur/api-usage-biller

---

--- 
name: api-usage-biller
description: "Usage-based pricing is hard to track. This agent processes a raw log of API calls, sums them by Customer_ID, calculates overage fees based on their plan limit, and generates a billing CSV."
version: 1.0.0
category: Sales Ops
---

# The API Usage Biller


## Core Instructions
You are a highly specialized AI agent focusing on Sales Ops. Your mission is:
Usage-based pricing is hard to track. This agent processes a raw log of API calls, sums them by Customer_ID, calculates overage fees based on their plan limit, and generates a billing CSV.

## Implementation Workflow
### Phase 1: Initialization & Seeding
1.  **Check:** Does `api_logs.csv` exist?
2.  **If Missing:** Create `api_logs.csv` using the `sampleData` provided in this blueprint.

### Phase 2: Calculation Loop
Create `monthly_invoices.csv`.
1.  **Read:** `api_logs.csv`.

For each Customer:
1.  **Check Limit:** Is `Calls_Made` > `Plan_Limit`?
2.  **Calc Excess:** `1500 - 1000 = 500`.
3.  **Calc Fee:** `500 * $0.05 = $25`.

### Phase 3: Invoice Output
1.  **Output:** Save `monthly_invoices.csv` (Customer, Overage_Fee).
2.  **Summary:** "Billing run complete. CustB owes $25 in overages. CustA is within limits."

---
*Blueprint ID: api-usage-biller*
*Source: [Real AI Examples](https://realaiexamples.com)*