Expense Tracker

Expense Tracker

Telegram bot for expense tracking. Send text or photo to bot, Claude Haiku parses it, stores in D1.

When to use

• User asks about expenses, spending, budget
• User wants to deploy or update the expense bot
• User wants to see expense summary or export data
• User asks to sync expenses locally

Dependencies

• External: Cloudflare Workers (wrangler), Node.js
• Services: Telegram Bot API, Claude API (Haiku), Cloudflare D1

Paths

How to execute

Deploy

cd ~/expense-bot && npx wrangler deploy

Set webhook (after first deploy)

curl "https://api.telegram.org/bot$TELEGRAM_BOT_TOKEN/setWebhook?url=https://expense-bot.<subdomain>.workers.dev/webhook"

Apply schema

cd ~/expense-bot && npx wrangler d1 execute expense-db --file=schema.sql

Check expenses via API

curl -H "Authorization: Bearer $TOKEN" "https://expense-bot.<subdomain>.workers.dev/api/summary?month=2026-03"

Sync expenses locally

curl -H "Authorization: Bearer $TOKEN" \
  "https://expense-bot.<subdomain>.workers.dev/api/export?month=2026-03" \
  > $DATA_PATH/personal/expenses_2026_03.csv

Set secrets

cd ~/expense-bot
npx wrangler secret put TELEGRAM_BOT_TOKEN
npx wrangler secret put ANTHROPIC_API_KEY
npx wrangler secret put API_AUTH_TOKEN
npx wrangler secret put ALLOWED_USERS

Setup (first time)

1. Create bot via @BotFather on Telegram
2. cd ~/expense-bot && npx wrangler d1 create expense-db
3. Update database_id in wrangler.toml
4. npx wrangler d1 execute expense-db --file=schema.sql
5. Set secrets (see above)
6. npx wrangler deploy
7. Set webhook (see above)

Bot commands

Architecture

Telegram -> CF Worker /webhook -> Claude Haiku (parse) -> D1 (store) -> TG reply
                                  /api/* (JSON/CSV export, auth by Bearer token)

Cost

~$0.30/month (Claude Haiku API only, everything else is free tier)