Cafe Sales Dashboard
2025Automated daily reconciliation. Was 45 minutes of manual work every night. Now zero.
PROBLEM:
Cashier reconciled from receipt stacks. No reports, no error tracking, no per-item visibility. Mistakes caught end-of-week.
SOLUTION:
Laravel API + MySQL. Composite index on (date, product_id). Next.js dashboard auto-refreshes every 5 min. PWA works from phone. Manual reconciliation: zero.
Client project. Code is private. Architecture documented above.