A 70 seat independent restaurant, second year of trading
21 vendors, 920 invoices and $603,000 of purchases rebuilt from the bank forward, then refreshed daily.
Alder Consulting LLC · Arvada, Colorado
I rebuild what a restaurant owes from the bank forward, hand the owner one page to read each morning, and keep it current without anyone typing. I fix Toast, Restaurant365 and QuickBooks when they stop talking to each other, cost your recipes so the kitchen and the bar know what every plate and pour earns, and build wine lists that make money, plus the tools that keep all of it running: dashboards, trackers, study guides and references that stay with you after the job. All of it comes down to the same habit: every number gets checked against the document it came from.
Who this is for
The owner sees the books once a month and does not trust them. Vendors call about invoices that show paid. The bank balance and the ledger disagree and nobody can say why.
Restaurants, hotels and retailers that need a list built, audited or costed, a by the glass program that earns its space, pairings for a new menu, or staff who can sell what is on the page.
A cellar that has outgrown the spreadsheet. You want to know what you own, what it is worth, what to drink now, what to buy next without overpaying, and what to pour at the dinner you are hosting next month.
The books
Nothing is estimated. If a figure cannot be sourced, the cell says so.
What you hand overA bank export, the accounting inbox, vendor statements, portal access.
What comes backEvery payable rebuilt vendor by vendor from the bank, not from the vendor list. Statements set the open balance. A fix list for your bookkeeper: stale open bills, mispostings, duplicate vendors, wrong due dates, clearing account errors.
What you hand overThe repaired workbook.
What comes backOne page: total owed, past due, due within seven days, paid by hand versus automatic draft, and who pays what. Plain English. It refreshes itself every morning.
What you hand overPoint of sale deposits, payroll dates, rent, the sales tax calendar.
What comes backA week ahead forecast by day of the week, set against everything going out, so you see which days go negative and why before they arrive.
What you hand overYour accounting system's vendor list.
What comes backContacts sourced from the vendors' own invoices, names matched exactly to your payment platform, duplicates merged, mispostings reclassed. An approval sheet comes first. Nothing is written until you say yes.
What you hand overRead only access to the point of sale and the bank.
What comes backA daily or weekly email that writes itself: last night's sales by category against the same night last week, what is due, what is past due, and what to forward to the bookkeeper.
What you hand overLogins to Toast, Restaurant365 or QuickBooks Online, and the problem in one sentence: sales not posting, deposits not matching, vendors doubled, reports nobody trusts.
What comes backThe integration fixed and documented: sales and tips landing in the right accounts, deposits matched to the bank, vendor and item lists cleaned so the three systems agree. If you are setting one of them up for the first time, I set it up the way the books will need it.
What you hand overYour recipes, your menu, your vendor invoices and a sales mix export.
What comes backEvery plate and every pour costed from the invoice price, with yield and waste built in, so the menu price is a decision and not a guess. Cost of goods targets by category, a weekly count that takes an hour, and the reports that show the kitchen and the bar where the money is going. Built for both sides of the pass: back of house for prep and portioning, front of house for pours, comps and the glass.
The wine list
An Advanced Sommelier pin, years on the floor and in the cellar, and a wine program that Wine Spectator profiled.
What you hand overThe current list, cost sheet and a sales mix export.
What comes backPour cost and margin by section, dead stock, pricing that is out of step with the room, what to cut, what to add, and a corrected list with every producer, appellation and accent right.
What you hand overThe glass list and the menu it sits beside.
What comes backPours priced against your own menu, pour cost and profit per bottle for each, with distributor availability confirmed before anything is proposed.
What you hand overThe list and an hour with the staff.
What comes backRegional guides with maps, producer profiles, tasting sheets and a short training the floor can use that night. Built for a new list rollout, a staff tasting, or a certification push.
What you hand overAccess to the cellar, any receipts, what you like to drink, and your CellarTracker export if you keep one.
What comes backA full inventory with current market value and drinking windows, what to open this year and what to hold, and a buying plan for the gaps. I source the wine through trade channels, including allocated bottles that never reach a shop shelf, and I keep the cellar managed after that: quarterly reviews, restocking, and a record of every bottle in and out. Staff trainings come with it: whoever pulls bottles for you, house staff, a chef, a steward, learns the map, the bins and the windows, so the right bottle comes up and the count stays true.
What you hand overThe menu, the occasion and the guest list. Or just the occasion.
What comes backA wine selection for a tasting menu, a dinner, a wedding or a collector's evening, with a pairing note for each course the host can read aloud. Pulled from your cellar when you have one, sourced when you do not, with pour quantities, service order and glassware worked out in advance.
What you hand overYour inventory export.
What comes backA sommelier level reference for every producer you carry, with history, vineyards, in stock wines and pricing, laid out for the shop floor or the training room.
Tools
Every engagement ends with something you keep: a page on your phone, a workbook, a guide. These are the ones clients ask for again, and each can be ordered on its own.
The morning page: what is owed, past due and due this week, on your phone, refreshed daily.
A payables tracker that rebuilds itself every night from the inbox and the bank.
A week ahead cash forecast workbook by day of the week.
A vendor contact master, sourced from invoices, ready to import into your accounting system.
A daily sales and payables email that compares last night to the same night last week.
Help with Toast, Restaurant365 and QuickBooks when they stop agreeing with each other, and recipe costing for the kitchen and the bar so cost of goods is controlled from the invoice up.
Study guides with interactive maps for a region, a list, a staff tasting or a certification exam.
Tasting sheets and training packets the floor can use that night.
Producer references and portfolio guides with history, vineyards and current pricing.
Pour cost and by the glass calculators, and a price check against the shops around you.
For retailers: a map of the store, location by location, with a separate inventory for the floor, the cold box and the backstock, so every rep knows where their product is placed and every shelf price moves when the case price does. A count is a walk with a phone: tap a location, count what you see, scan the shelf tag, and the reorder builds itself by supplier from the pars you set. Your Excel sheet goes in and comes back out in your own columns. A guest view with prices only for a tablet by the door. A study mode so staff learn where everything is and what it costs.
For collectors: an interactive cellar on your phone, searchable by region, producer, vintage and drinking window, with value, what to open next, and the bottles pulled for tonight's menu. Upload your CellarTracker export and every bottle lands on the map. A monthly note tells you what enters its window, what is in its last year and what is past it. One click prints a valuation report for your insurer. Your own tasting notes stay on each bottle.
Click a country, a region, a village, a bottle. See the label, the place and what it pairs with. Search by grape, producer or bottling, star your favorites, build a dinner and present it to your guests. Upload your CellarTracker cellar or build a new one! Every bottle lands on the map with its window and value; a monthly note says what to open, and one click prints a valuation report for your insurer. This is an example cellar. Yours drops in the same way.
Still running inventory in Excel? Receiving new product without updating the shelf price? Case pricing changed on a distributor invoice and you found out when the margin moved? This fixes all three. A separate inventory for every location in the building, the floor, the cold box, the backstock, the warehouse, on a plan of your own room. Pick a supplier and their locations light up with facings counted. Click a location to see what sits on it and on which shelf. Type the margin you want and see what to charge, in one step. Every rep knows where their product is placed, and every price on the shelf traces to the invoice it came from. If your system is Excel, I work in your Excel. If you want something more modern and efficient, this is it, and it reads your sheet to start.
A grape, a country, a price, a location. Type it and the bottle lights up on the floor plan with the shelf count, what is in back and what it sells for. Walk the store location by location to see what sits where. Reps find their product, staff find the guest's bottle, and nobody walks the store twice. The same plan runs the count (tap a location, count, scan a tag), the reorder (pars by item, cases by supplier, one click to copy or download), a guest view with prices only, a study mode for new staff, and the Excel round trip: your sheet in, your sheet out, your column order.
Your spreadsheet goes in as it is, a POS export, a distributor sheet or a count sheet, nothing retyped. Then a photo of the room: the bins populate on the photo by themselves, named from your inventory, and you drag them to where they really sit. The finder, the count and the margin tracking all follow the plan you drew. Works for a cellar, a wine room or a whole store. If you want to stay on Excel, the sheet stays the system of record and the map reads from it.
The mapping engagement
Every tool above starts the same way: I come in, count what is actually there, and draw it. What you get back is a map your staff can use on day one, an inventory that stays current because the count lives on the map, and a team trained to sell what is on it. One fixed fee, one week, yours to keep. Thirty day check in included; ongoing counts and updates on a retainer if you want them. If your system is Excel, I cater to it. If you want something more modern and efficient, I design it.
Every bottle on a world map, down to the vineyard where the records exist. Racks and bins numbered so anyone in the house can find a bottle.
The list, the cellar and the by the glass program on one map, with cost, pour cost and pairings attached to every line.
The whole building drawn bin by bin and location by location: floor, cold box, backstock, warehouse. Every product placed, every price traced to its invoice.
Half a day on site. Every rack, bin, cooler and back room counted and photographed against your own signs and tags.
The map is built from the count: world map for a cellar or list, floor plan for a shop. Prices, costs and windows attached to every line.
Two sessions with the staff, on the map. Where things are, what they are, how to sell them. A short quiz they can run themselves.
The map, the inventory and the training are yours. Counting is a walk with a phone. I check in at thirty days and the count stays honest.
How it works
A 30 minute call and read only access to the evidence: bank export, accounting inbox, vendor statements, point of sale, the list.
A written work order inside a week. What is wrong, how big it is, what it takes to fix, what can be left alone. Fixed fee.
The rebuild. Scoped off the diagnostic. Nothing is written into your systems without an approval sheet first.
The morning page, the fix list for your bookkeeper or the corrected list for your floor, and a walk through.
Optional. Monthly. The reports refresh on their own, with a review call each month. Cancel any month.
On every job, in writing.
Proof
Clients are anonymous and the dollar figures are substituted. The relationships between the numbers are real.
21 vendors, 920 invoices and $603,000 of purchases rebuilt from the bank forward, then refreshed daily.
A 125 producer portfolio turned into reference material the trade can use.
The shop's full inventory turned into reference material for the floor.
About
Nick Alder
Advanced Sommelier, Court of Master Sommeliers. Founder, Alder Consulting LLC.
I have sat on every side of a restaurant's money: on the floor selling it, in the cellar buying it, in the office paying for it, and now on the distributor's side of the table.
Contact
Based in Arvada, Colorado. Working across Denver, Boulder and the Roaring Fork Valley, and remotely anywhere. References are available upon request.