14 Acres

14 Acres Winery needed a secure, reliable way for staff to count and register the cash till each night, log overages or shortages, and track cash across the whole property, all while integrating with their existing Clover POS system rather than working around it.

I built a custom web app with an HTML, CSS, and JS frontend backed by Supabase. The database schema centers on tables for till counts, overage records, tips, and employees, with employee accounts protected by passwords. There are two distinct interfaces, an employee panel and an admin panel, each password protected separately, so staff can log their nightly counts while managers get a separate view with broader access and oversight.

The system integrates directly with Clover for point of sale data. Each night, the app automatically calculates the expected cash on hand by taking the starting cash float, adding Clover's recorded cash sales, and subtracting any Clover cash refunds. That expected number gets compared against what staff actually count in the till. Anything over $300 off from that expected amount gets automatically flagged as an overage, and the app calculates exactly which bills and denominations make up that overage rather than just showing a raw dollar difference.

All of that logic lives in a custom API layer, with sensitive configuration like Clover credentials and Supabase connection details handled through environment variables rather than hardcoded anywhere in the app. Data access is read and write on demand rather than real time subscriptions, since a nightly till count doesn't need live updates the way a chat app or dashboard might, a straightforward request/response model was the simpler and more appropriate choice here.

Employees and managers now have a secure, consistent daily workflow for registering and tracking cash across the whole winery. The automatic expected cash calculation and overage detection means discrepancies get caught and quantified immediately instead of someone manually reconciling Clover reports against a paper till count after the fact.