Bar inventory with SpotOn

SpotOn publishes several products (Restaurant POS, Express, Retail Dashboard, Connect). ExactPour does not ship a SpotOn connector, so this page only repeats export facts from SpotOn help.

Retail Dashboard help titled Export Reports to CSV File: from Reports, choose Trends, Sales Summary, Orders, or Items, set the date range, then Export CSV. Items can be grouped by item, category, channel, location, vendor, or staff.

Restaurant POS help for Accounting Summary: Reports, Accounting, Accounting Summary, then the Export icon. The CSV follows the date range and filters you applied. Product Mix on restaurantreports.spoton.com: Sales, Product Mix, then Print / Export as Excel or CSV.

Those exports are SpotOn's. A Product Mix or Items CSV is the honest sold-unit list to compare against an ExactPour count. A single gross-sales number is not recipe depletion.

Close an ExactPour count. Write the start and cutoff so they match the SpotOn report clock, not a vague weekend.

In SpotOn, export item-level sales for that window. Dashboard Items or Orders, Export CSV, is the path SpotOn documents for several dashboards. Restaurant POS rooms can use Product Mix Export Report, CSV or Excel, or Accounting Summary export if you only need totals. Prefer item-level.

ExactPour does not import that CSV. Match SpotOn items to recipes: a house margarita depletes tequila. Unmapped SpotOn items will look like missing product if you ignore them.

Repeat weekly. If you later move the room to Toast, Square, Clover, or GoTab, connect that POS. Until then, ExactPour does not ship a SpotOn connector.

Pick a night the room can repeat. Many bars use early Monday. Write the cutoff in ExactPour before anyone restocks the well. Then walk one route. The SpotOn side of the week is only useful if the physical count covers the same hours the tickets cover.

ExactPour does not ship a SpotOn connector, so nothing arrives on a schedule. After you close the ExactPour session, export SpotOn item sales for those dates. Sit the two lists next to each other. That is slower than Toast. It is still a real week.

Do not mix locations. If the group also rings Toast in another room, that room has its own ExactPour location and its own connector. A SpotOn sales total pasted onto a Toast well will make both rooms look dishonest. See POS integrations for the live four (Toast, Square, Clover, GoTab).

City liquor rules are not a SpotOn setting. License-state rooms photograph wholesaler invoices. Pennsylvania control-state rooms photograph PLCB and beer-distributor paper. The POS still only knows what rang. Use [city pages](/cities) for the buying story, and this page for the SpotOn story.

Poured versus sold is a recipe problem, not a SpotOn report setting. A house vodka soda that rings as one SpotOn item has to name the spirit in ExactPour. Soda is not liquor inventory. If the recipe is blank, ExactPour cannot deplete the bottle from that ticket, and the next count will look like theft.

Map the drinks that actually sell. Well vodka, well whiskey, well tequila, house gin and tonic, and the two signatures the room cannot stop ringing. Rare bottles can wait. A SpotOn menu with 200 items is not a reason to skip the well map. It is a reason to start with the rail.

When you compare a SpotOn export by hand, use the same recipe list you would map on Toast. A house margarita line depletes tequila (and orange liqueur if you inventory it). Do not subtract a dollar total from a bottle. Subtract ounces implied by the recipe from ounces counted.

Modifiers matter. A SpotOn ticket that adds an extra shot, a double, or a different spirit is a different depletion. If those modifiers are ignored, the well looks generous on paper and empty on the rail. ExactPour can only deplete what you mapped. SpotOn can only report what rang.

See poured versus sold for the formula and how to reduce liquor shrinkage for the coaching order: recipes, comps, waste, then theft. SpotOn does not change that order.

SpotOn does not replace receiving. A case that lands during the count window has to be received in ExactPour or the session is wrong. Photograph the distributor ticket (or the PLCB ticket in Pennsylvania). ExactPour extracts lines so bottle cost is the paper cost, not a memory.

A SpotOn sales mix cannot tell you that well vodka went up $4 a bottle last Tuesday. The invoice can. Keep both. Bar invoice management is the capture path. SpotOn remains the ticket path. ExactPour is the count path.

ExactPour prices in USD are Free, then Starter $69, Pro $99, and Scale $129 a month. POS sync is on Starter and up, plus the 14-day Pro trial. Confirm on /pricing. Invoice capture and counting exist without POS sync. Poured versus sold is the part that needs a SpotOn export plus your own recipe math. Do not skip invoices while you wait on a menu map.

ExactPour still counts the well while ExactPour does not ship a SpotOn connector. Scan barcodes. Tap fills. Receive invoices. Close the session. You will have usage. You will not have automatic projected usage from SpotOn tickets.

POS sync on Starter ($69) is for Toast, Square, Clover, and GoTab. A SpotOn room does not unlock a hidden SpotOn API by upgrading.

Use the liquor inventory template to line up ExactPour usage with SpotOn item sales for the same cutoff. See poured versus sold for the formula.

ExactPour prices in USD are Free, then Starter $69, Pro $99, and Scale $129 a month. POS sync is on Starter and up, plus the 14-day Pro trial. Confirm on /pricing.

SpotOn will not count the well for you. Item stock in a POS is a catalog unit, not a fill level on an open bottle. ExactPour is the fill. If someone promised a camera inside SpotOn that retires the rail walk, that is not what ExactPour ships and it is not what this page claims.

ExactPour does not ship a SpotOn connector, so it also cannot rewrite the SpotOn menu, take payments, or subscribe to SpotOn webhooks. Count in ExactPour. Export from SpotOn. Compare. That is the whole honest path until a connector exists.

Unmapped house pours are the usual failure. A SpotOn item named "Well" or "Rail" or "Vodka Soda" with no recipe will show as sold product that never left a bottle. Map it. Then recount. Then coach. Do not start with a theft meeting.

Comps, spills, and staff drinks need a code in ExactPour. SpotOn may already void or comp tickets. If those voids never become waste codes, the well still dropped and the sales side looks clean. Log the waste. The next SpotOn comparison will make sense.

For the physical walk, see bar stocktaking and bar inventory software. For a sheet you can print this afternoon, see the liquor inventory template. Those pages do not depend on SpotOn. This page does.

Give each address its own ExactPour location. A second SpotOn merchant, restaurant GUID, Square location, or Clover merchant is a second connect (or a second export ritual). Rollups compare reconciled dollars. They do not merge two wells into one clipboard.

If you can move this room onto Toast, Square, Clover, or GoTab, the live connector is less work than a weekly SpotOn export. If you cannot move, stay on the export. ExactPour does not ship a SpotOn connector either way, and upgrading to Pro ($99) or Scale ($129) does not add one.

Book a 20-minute walkthrough on /demo or /contact if you want the mapping reviewed. Bring one SpotOn location, not the whole group. Map the rail. Then copy the habit.

Do not wait for a connector that is not in the ExactPour codebase. A SpotOn export plus an ExactPour count is an honest week. A SpotOn sales total pasted into a cell with no item list is not. See the liquor inventory template if you need a sheet for the comparison, and poured versus sold for the formula.

ExactPour prices in USD are Free, then Starter $69, Pro $99, and Scale $129 a month. POS sync is on Starter and up, plus the 14-day Pro trial. Confirm on /pricing.

Toast, Square, Clover, and GoTab remain the live ExactPour connectors. If you can move this room onto one of those four, read POS integrations. If you are staying on SpotOn, stay on the export workflow on this page.