Toast restaurant sales report from your item selection details
Toast's data exports include a file with every item rung up. Superlytix turns it into a report for your weekly meeting: sales against last year, how food, beer, wine and liquor split, which servers lift the average check and what sells.
Free to try · Pay only when you download your report · No card needed
Net sales by month, vs last year
Net sales by Sales Category
Average check by Server
Items sold by Menu Item
What the report shows
- Net sales, checks, average check and items sold
- Net sales by month against the same month last year
- Net sales by sales category
- Average check by server and best-selling menu items
How to export it from Toast
- Get the ItemSelectionDetails.csv file from your Toast data exports.
- Use one file that covers the whole period you want to see (at least 13 months to compare with last year).
- If your exports come as one file per day, combine them into one file first.
- Upload it to Superlytix. Voided items are kept out of items sold.
Columns in a typical export
You don't need to rename or remove anything. Superlytix works out what each column is, and you can correct it.
LocationOrder IdOrder #Order DateCheck IdServerDining AreaServiceDining OptionMenu ItemMenu GroupMenuSales CategoryGross PriceDiscntNet PriceQtyTaxVoid?Every number explained
Each number in your report comes with its definition and a worked example from your own data.
| Net sales | Net Price |
| Items sold | Qty where Void? is “false” |
| Checks | Count of distinct Check Id |
| Average check | Net sales ÷ Checks |
Questions
Can I see lunch versus dinner?
Yes. The service column (lunch, dinner, brunch) is there to break any number down by.
How is the average check calculated?
Net sales ÷ number of distinct checks, for whatever you're looking at: a server, a day, a month.
Does it handle several locations?
Yes. When your file covers several locations, the location column becomes a filter on every page.
Try it with your own Toast export
About 10 minutes from file to report. Free until you download.
Related templates
Toast is a trademark of its owner. Superlytix is not affiliated with or endorsed by Toast; it reads the files Toast lets you export. The numbers above come from a made-up sample file.