CorgiCafe — multi-location employee time tracker

Built a multi-tenant SaaS time-tracking platform for 5 cafes in Barcelona with PostgreSQL schema-per-tenant isolation. Real-time check-in/check-out, overtime detection, holiday tracking, role-based access, and Excel export for payroll.

A cafe chain owner managing 5 locations and 50+ employees in Barcelona needed to comply with Spanish mandatory time-tracking regulations (Real Decreto 8/2019) while getting real-time visibility into labor costs across all locations.

• Multi-tenant Flask application with PostgreSQL schema-per-tenant isolation
• Tablet-based check-in/check-out with PIN codes for each employee
• Automatic overtime detection based on Spanish labor law (40h/week, daily maximums)
• Holiday calendar with public holidays (Catalonia + national) and vacation tracking
• Role-based access: owners see all locations, managers see their location only
• One-click Excel export formatted for the payroll accountant

• 100% legal compliance with Spanish time-tracking law from day one
• Payroll preparation time cut by 75% — from 4 hours to under 1 hour
• Real-time labor cost visibility helped optimize shift scheduling, reducing overtime by 30%
• 50+ employees tracked daily across 5 locations
• EUR 600/month saved through better overtime management