AI Spend Reconciler
Turn OpenAI and/or Claude API cost exports into a client billing worksheet in 60 seconds. Works with a single provider (OpenAI-only or Claude-only) or both together — no API keys, no server uploads.
Import your cost files (1 or 2 providers)
All parsing runs locally in this browser tab (0 network uploads). Load OpenAI only, Anthropic only, or both USD cost exports together. Include last month for month-over-month change.
Supported columns and sample files
Supported headers include date / usage_date / start_time (ISO date, timezone timestamp, or UNIX epoch seconds), cost_usd / cost_in_usd / amount_value (with USD currency column), project_id / workspace_id / project, model, line_item, and line_id.
The mapping file uses provider,project,client where provider is OpenAI or Anthropic. You can also assign unassigned projects inline below and download a reusable client-mapping.csv for next month.
Month-end worksheet
Use control totals for the same scope and month as the exports. Totals differ when invoices include adjustments or tax outside that scope.
Assign Projects to Clients (Reusable Next Month)
Assign client names to any unassigned project/workspace below, apply to recalculate instantly, and export your reusable client-mapping.csv.
Want Your Agency's Month-End AI Close Configured & Audited in 48 Hours?
Designed for agencies running multiple client workflows under shared OpenAI and/or Claude accounts (up to 10 projects/workspaces):
- Project & API Key Tagging Guide: Clean structure so every client call maps deterministically with zero billing leakage.
- Custom Reusable Mapping Rules: Verified
client-mapping.csv+ normalized export workflow tailored to your exact CSV columns. - First-Month Close & Unassigned-Spend Audit: Full client allocation CSV, control-total tie-out, and unassigned-row audit.
- Permanent Handoff: Next month your team runs the same browser-local workflow in under 3 minutes with no recurring lock-in.
Zero-risk compatibility check: Send just 3 anonymized header/sample rows first — we verify exact CSV compatibility before you pay anything.