What lives inside
the Chrome program.

Bar Inventory Master Sheet

Inside the Chrome program, this is the spreadsheet brain behind the admin panel. Setup builds the first version from the approved bar map, then each cycle updates it with counts, invoices, and POS exports.

What It Looks Like

• -Tabs for liquor, beer, wine, mixers, and future dry goods
• -Rows organized by physical location: wells, back bar, coolers, storage, and liquor room
• -Columns for product, bottle size, par, opening count, purchases, closing count, cost, and variance

How It Works

1. 01The customer maps the bar by voice during setup.
2. 02The system turns that map into the first XLS workbook.
3. 03After the customer audits and approves it, the workbook becomes the source for weekly reporting.

Quick Count Template

The Chrome program generates the sheet from your approved bar map, ordered bar → well → row → back bar → cooler → wine, so it always matches the real room. Download it as a printable PDF, or export to CSV to pull into your own apps.

What It Looks Like

• -A print sheet ordered by your real walking route, bar by bar and row by row
• -Blank count spaces beside every bottle, well, back bar, cooler shelf, and wine space
• -PDF for paper in hand, plus CSV/XLS exports for spreadsheets and mobile apps

How It Works

1. 01After the first map is built, download the count sheet as PDF or CSV.
2. 02Carry it on the second walk and count by the same order you spoke the first time.
3. 03Enter the results into Weekly Inputs so the admin panel updates the cycle.

Variance Calculator

Variance becomes part of the admin panel. All inputs feeds it with your count, purchases (typed, pasted, or optional invoice photos), and POS exports.

What It Looks Like

• -Opening inventory plus invoice purchases minus ending inventory
• -POS sales imported by the same weekly cycle
• -Category, bottle, and shift-level flags for unexplained gaps

How It Works

1. 01Add purchases — type them, paste invoice text, or optionally upload invoice photos with AI connected.
2. 02Upload the POS sales export for the same dates.
3. 03The system compares expected usage against actual count movement and updates the report.

Product Database

The database lives inside the program so voice notes, invoices, POS exports, and spreadsheet rows all resolve to the same product identity.

What It Looks Like

• -Common bar products with category, bottle size, pour size, and cost fields
• -Alias matching for voice transcription and invoice naming differences
• -Customer-specific additions created during setup and weekly corrections

How It Works

1. 01The setup flow starts with a standard product list.
2. 02Customer products are matched or added as the first bar map is reconciled.
3. 03Future invoice and count inputs update the database when new products appear.

Invoice Photo Reader

This is the only place AI ever enters the program, and only if you connect your own key. Skip it and you type or paste invoice text — the local parser handles that on its own, exactly as the system was field-tested.

What It Looks Like

• -A photo button on the invoice panel, clearly labeled "needs AI"
• -Type-or-paste always sitting right beside it as the default path
• -Read line items you confirm before they touch the weekly numbers

How It Works

1. 01Optional: add your own AI key in Settings — a private password stored on your Mac.
2. 02Snap the Southern Glazer's or Breakthru invoice on your phone and upload it.
3. 03Confirm the parsed line items; without a key, just type or paste instead.

Mobile Count View

This is the mobile side of the same Chrome/admin program. It follows the approved map and sends weekly counts back into the dashboard.

What It Looks Like

• -A section-by-section count screen ordered by the real bar walk
• -Large tap targets for bottle level, cases, loose bottles, and notes
• -A final review before the count becomes part of the weekly cycle

How It Works

1. 01Choose the section you are counting.
2. 02Enter bottle levels or case counts as you walk.
3. 03Submit the count into Weekly Inputs for reconciliation.