Irish Pub

Automation • Restaurants • Data Processing

Google Vertex

Toast

Python

Overview

This engagement automated the pub's daily payout process end-to-end, reducing manual effort and errors while improving clarity of daily reporting.

Automated polling of Toast data mart: Scheduled retrieval of sales, payments, and adjustments on a daily cadence.
Normalization and output: Cleaned, reconciled, and transformed Toast data into the pub’s preferred spreadsheet format.
Spreadsheet improvements: Enhanced formulas, structure, and protections to streamline use and support automation.

Result: Faster daily closeout with fewer errors and clear visibility into payouts.

Discuss a similar project