01 / Overview
From daily operations to owner-ready business insight.
Halfway by Heyday needed a clearer way to understand daily cafe performance beyond basic sales totals. The business needed staff shift accountability, receipt and submeter proof capture, POS sales parsing, product-level COGS analysis, and owner-facing decision briefs.
I designed a Finance Ops + Business Analyst System that combines n8n automation, Google Drive proof storage, Google Sheets logs, Hermes-assisted finance analysis, Utak POS import logic, and custom-made owner dashboards to turn daily cafe operations into actionable business insights.
02 / Problem
The business needed more than raw sales totals.
The operational mess was not one missing spreadsheet. It was the gap between staff reporting, owner review, POS exports, recipe costing, and daily decision-making.
Staff reports were scattered
Sales needed to be reconciled across cash and GCash
Cash expenses needed proof
