I Built a Local AI Finance Coach for My Friend's Bubble-Tea Shop - No Cloud, No API Keys
Описание и применение
Создан локальный AI‑коуч для малого бизнеса, обрабатывающий банковские выписки без передачи данных в облако.
Задача
A small business owner needed a way to understand her monthly bank statement without uploading sensitive data to external services.
Результат
The tool produced a concise report confirming profitability, identifying key income and expense drivers, and recommending supplier negotiation and rent review.
Рабочий процесс
- Upload Excel/CSV file to local analyzer.py
- Analyzer auto‑detects date, description, income, expense columns using fuzzy matching
- Compute monthly income, expenses, net flow, top sources and categories, biggest transactions
- Output compact JSON summary to reporter.py
- Reporter invokes local llama.cpp with Qwen2.5‑3B‑Instruct to generate a 250‑350 word business report
- Display report and tables in Gradio UI
Доказательства
Bank statements are the last thing you want on a stranger's server. Here, the file, the statistics, and the model weights all live in one local process.
Feed it three months of a bubble‑tea shop's transactions and it produces a report like this...
- Дата записи: 2026-10-02T05:40:59.599Z