Sales brings in what you sold at your point of sale (POS), so it comes off your stock between counts. Upload a sales file from Square, Toast, or any POS that exports a CSV. Sales sits in the left-hand menu between Counts and Inventory Receipts.
Note: Uploading, mapping, and applying sales takes the Upload and apply sales permission. Inventory admins already have it, and an owner can give it to anyone else. See Inviting Your Team and Managing Access.
How to Upload a Sales File
- On the Sales page, click Upload Sales.
- Choose your Point of Sale: Square, Toast, or Other/Custom. The page tells you which export to use. For Toast, that's the Product Mix export or ItemSelectionDetails. For Square, it's the Item Sales Detail CSV (not the Item Sales Summary), because every row needs its own date. For Other/Custom, any CSV with item, quantity, and date columns works.
- Drop the CSV onto the upload area, or click browse. Files can be up to 50MB.
- On the Map Sales screen, set Period Start and Period End, check Day Starts at, and choose the Sales Area, the storage area your stock comes out of. For a Toast file, Day Starts at defaults to 4:00am, when Toast ends its business day.
- Under Uploaded Spreadsheet, choose what each column holds. Item and quantity are required. For Toast and Square exports, Inventory fills these in for you.
- Choose a Void Handling Mode. Already Net is recommended for Toast Product Mix. Choose Map Void Column if your file lists voids in their own column.
- Click Confirm Sales Upload. Inventory takes you to Mapping Review.
Note: A file with no dates, like Toast's Product Mix, has all of its sales dated to the period's last day.
Reviewing and Mapping What Sold
Mapping Review lists every item in the file with its category, sold quantity, and status, most sold first. The Sold Qty Mapped bar at the top shows how much of what sold is matched, for example 325 of 369 (88%).
To map an item, click Map on its row, search your products and recipes, pick what that item pours, and click Confirm. A mapped item shows what it pours under its name, such as Tito's Handmade Vodka · 1.5 fl oz. Selling a cocktail? Click New Recipe in the same drawer to build one. For anything that shouldn't come off stock, like food or merchandise, click Not Tracked. Not Tracked items stay in the total, so the bar can sit below 100% without anything being wrong.
Inventory remembers every map, so the next file that sells the same item arrives already mapped.
Toast beers in several sizes: a beer's sizes are grouped under one heading. Click Map all sizes to map every size with one pick. The ounces fill in from your venue's own pours, or from the size name (for example 16oz, or Growler as 64). A size that can't be read, like Pitcher, stays Needs attention and tells you how to finish it.
Toast sizes and modifiers: Mapping Review also offers Add Toast's Sizes and Modifiers. It's optional, but without it a pint and a pitcher of the same beer deplete the same amount. In Toast, go to Menus > Reports > Item details > Modifier details, set the same dates, and drop that CSV into the box.
Mapping Modifiers
A modifier, such as an extra shot, can be mapped like any other sold item.
- Spirit swaps: map a modifier like "make it Tito's" as Swaps the pour and pick the product it swaps in. When sales apply, the premium bottle comes off stock by the drink's own pour instead of the house spirit, and a Double on the same check moves with the swap. A swap you haven't mapped yet shows Needs attention.
- A different amount for one drink: set it from POS item mappings, in fl oz. It's saved relative to that drink's pour, so 96 fl oz on a 32 fl oz pour counts as three pours. The next imported day uses it, and nights already applied keep the amount they used.
How to Apply a Sales Period
Nothing comes off your stock until you apply the period.
- At the bottom of Mapping Review, click Apply This Period.
- Check the summary: the POS, the period, the sales area, and how much of what sold is mapped. Items that need attention and Not Tracked items won't deplete. Inventory also warns you if Toast's sizes and modifiers weren't added, or if a count is open.
- Click Confirm.
The period now reads Applied on the Sales page, with who applied it and when. Click it to see exactly what came off your stock, day by day. When Inventory had to open a case to cover singles, an Opened line shows that too, for example -2 × 24-Pack, +48 Containers. On an item's page, Expected on hand shows which count and which applied sales its quantity is built from.
Managing Your POS Item Mappings
POS item mappings, at the top of the Sales page, lists everything your POS has sold across every upload. Each row shows the POS, how it's mapped, what it maps to, when it last sold, how many sold in the last 30 days, and its status. Items that still need a decision sit at the top.
From any row you can Map it, mark it Not tracked, or open Modifier rules. Tick several rows and click Mark selected Not tracked to clear a batch at once, with Undo if you change your mind. Filters narrows the list by status, POS, beverage type, and recent sales. An item whose recipe was archived is flagged Needs attention.
Changed a map? When you map an item that was unmapped, or change a map, Inventory offers to apply that change to the item's sales since each sales area's last posted count. Stock comes back off the old product and goes onto the new one. Days a posted count already covers stay where your count put them, and an area with a count still open waits until you post or discard it. Apply to past sales stays available afterwards.