I will build bar inventory and pour cost spreadsheets and automations

United States

I speak English

Restaurant Manager turned Builder

I build automations and web tools that take repetitive work off your plate: Google Sheets and Apps Script automations, Make and n8n workflows, web scraping, and custom web apps. I come out of the res...
About this Gig

I've spent 15 years managing restaurants: kitchen, bar, floor and GM. I've done bar inventory with a clipboard at 2 AM, and I've built my own tools so I don't have to anymore.

I'll build you a bar inventory and pour cost system in Google Sheets or Excel, set up for your bar: your bottles, your pars, your pour sizes.

What I can build:

  • Liquor, beer and wine inventory with counts in tenths of a bottle
  • Pour cost by category, and usage from one count to the next
  • Cocktail costing: cost per drink and a price that hits your target
  • Order sheets built from your par levels
  • Automations: low-stock alerts, weekly pour cost emails, POS sales import

You'll get a sheet your bartenders can actually use on a Sunday night, not one only an accountant can read.

Food cost and recipe costing are available too. Message me.

Not sure which package fits? Send me what you're using now, even if it's a notebook, and I'll tell you.

Programming language:

SQL

•

Other

Technology:

Excel

•

Google Data Studio

•

Google Sheets

•

Other

Analysis Type:

Quantitative Analysis

•

Descriptive Analysis

Expertise:

Alerts

•

Business Insights

•

Trends

•

Forecasting