Admin Cost Dashboard
A unified operations dashboard that tracks all costs associated with running a SaaS product — from AI services to infrastructure to payment processing fees.
The Problem
- •Running a SaaS requires 10-15+ vendor subscriptions
- •Costs scattered across billing portals and invoices
- •Hard to see total operational costs at a glance
- •No easy way to compare costs vs revenue
The Solution
- •One dashboard for all 13+ vendor costs
- •Automatic API fetching for supported services
- •Color-coded categories for quick understanding
- •Revenue vs costs with profit margin calculation
5 Cost Categories
Every expense is categorized for clear visibility into where money goes.
AI Services
API usage: input tokens, output tokens, cost per model
Infrastructure
Functions, bandwidth, compute hours, storage
Data Providers
API call quotas, subscription tiers
Developer Tools
CI/CD minutes, error events, licenses
Payments
Transaction fees, revenue, MRR/ARR
13+ Vendor Integrations
API-enabled services fetch automatically; others support manual entry.
Vercel
APIUsage breakdown with tiered pricing calculations
Anthropic
APIOrg-level usage with Claude Code filtering
OpenAI
APIDaily cost aggregation by model
Stripe
APIRevenue, fees, MRR/ARR from subscriptions
Neon
APICompute hours, storage, data transfer
GitHub
APIActions minutes by runner type
Sentry
APIEvent counts and quota tracking
Clerk
ManualFixed monthly auth service cost
FMP
ManualStock data API subscription
Polygon
ManualOptions data subscription
Cursor
ManualIDE license
Resend
ManualEmail service
PDFShift
ManualPDF generation
Dashboard Features
Real-Time Summary
Total costs, revenue, net profit, and margin at a glance
Category Breakdown
Visual pie chart showing cost distribution by category
Service Cards
Individual cost display with detailed metadata per service
Historical Trends
Line charts showing costs and revenue over 3-12 months
Manual Cost Entry
Add/edit fixed monthly subscriptions with notes
Auto-Fetch Cron
Daily automated cost fetching at 00:05 UTC
How Data Flows
Daily Cron
00:05 UTC trigger
API Fetch
7 parallel requests
Database
Neon PostgreSQL
Dashboard
Next.js + Recharts
Tech Stack
Next.js 14
App Router with TypeScript
Tailwind CSS
Dark mode, responsive design
Recharts
Trend visualization
Neon
Serverless PostgreSQL
Vercel
Deployment + cron jobs
Stripe SDK
Revenue tracking
TypeScript
Type-safe throughout
React 18
Server components
Business Value
Financial Clarity
Know exactly where every dollar goes. No more spreadsheet chaos.
Profitability Tracking
See revenue vs costs instantly. Know your margins in real-time.
Vendor Optimization
Identify which services drive costs. Negotiate or replace intelligently.
Historical Analysis
Track trends over months. Budget better with real data.
Need cost visibility?
I can build custom dashboards that consolidate your vendor costs, track revenue, and give you the financial clarity you need to run your business.