ai bill to focus — Streamline AI billing conversions to…

Pitch

Description

Comments

About this project

Transform bills from Anthropic, OpenAI, and Together AI into FinOps FOCUS 1.4 CSV files directly on your machine. This tool checks any CSV against FOCUS rules 1.2 to 1.4, ensuring accuracy and compliance without ever uploading your data. Simplify your financial operations today.

The ai-bill-to-focus tool streamlines the process of converting bills from AI providers such as Anthropic, OpenAI, and Together AI into the FinOps FOCUS 1.4 CSV format. It also allows users to validate any CSV file against the established FOCUS 1.2, 1.3, and 1.4 guidelines directly from a local environment, ensuring data privacy as files remain on the user's machine.

Key Features

Conversion and Validation: Effortlessly convert your cost and usage CSV files using a simple command line interface:
```
npx ai-bill-to-focus convert cost.csv usage.csv -o focus.csv --check
```
This command outputs a FOCUS 1.4 compliant CSV file while validating the input against FOCUS rules.
Broad Compatibility: The tool supports data exports from different AI providers:
- Anthropic: Import cost and usage data from the Claude Console.
- OpenAI: Use the Cost data export and Completions activity export for token quantities.
- Together AI: Facilitate downloads directly from cost analytics.
Detailed Output Analysis: The generated FOCUS file includes vital daily metrics such as model performance and token usage metrics, formatted to precision. An example output column includes:

SkuMeter ConsumedQuantity ListUnitPrice ($/1M) BilledCost
Input Tokens 100000 3.00 0.30
Cache Write Input Tokens (5 min) 40000 3.75 0.15
Network Usage: While the tool generally operates offline, it can retrieve public model pricing when necessary, providing the flexibility to run operations without internet access as well.

SkuMeter	ConsumedQuantity	ListUnitPrice ($/1M)	BilledCost
Input Tokens	100000	3.00	0.30
Cache Write Input Tokens (5 min)	40000	3.75	0.15

Robust Command Options: The tool includes various commands for conversion, checking, and detection, allowing customized validation workflows and automation processes:

ai-bill-to-focus convert <export.csv>... [-o focus.csv] [--account-id ID] [--account-name NAME]  
ai-bill-to-focus check <file.csv> [-v 1.4|1.3|1.2] [-c ai|all|none|LIST] [--json] [--strict]  
ai-bill-to-focus detect <file.csv>...

Developer Friendly: The project supports easy development and testing, with provided test fixtures ensuring the reliability of CLI operations.

For individuals and organizations looking to manage and validate AI billing data efficiently, the ai-bill-to-focus tool offers a comprehensive solution that integrates seamlessly into existing workflows.