Toast Item Selection Details export: what's in it
A Toast Item Selection Details export is a line-item sales report that lists every menu item ordered in your restaurant over a chosen date range. It provides the transaction history needed to see how often each dish sells and how many dollars it brings in.
Here is how Toast formats the report, which five columns matter for menu review, and how line items add up.
Where to find the export
In Toast Web, the on-screen report is "Item details" (found under Reports > Menus > Item details, which requires the 4.2 Menu Reports permission; see the Toast Menu Reports Overview).
The file named Item Selection Details is part of Toast's automated nightly data export in the Sales/Finance group. It is configured in Toast Web under Reports > Settings > Data Exports with the 8.3 Data Export Config permission, and is delivered automatically over SFTP as documented in Toast Automated Nightly Data Export.
Columns in the native Toast export
A typical Item Selection Details file has these 22 columns. Toast lets each restaurant choose and rename the columns in its export, so yours may differ.
- Location: The name or ID of the restaurant location.
- Order Id and Order #: Toast's internal order identifier and daily order number.
- Sent Date and Order Date: Timestamps for when the order was entered and sent.
- Check Id: The unique identifier for the guest check.
- Server and Table: The staff member and table assigned to the check.
- Dining Area, Service, and Dining Option: Floor section, meal period, and order type (such as Dine-In or Takeout).
- Item Selection Id and Item Id: Database keys for that specific line item and the master menu item.
- Menu Item, Menu Group, and Menu: The name of the dish, its subcategory, and its parent menu.
- Sales Category: The accounting revenue bucket assigned in Toast.
- Gross Price: The menu price of the item before discounts.
- Discount: Dollar discounts applied directly to that item.
- Net Price: The actual item price after discounts, before tax and tip.
- Qty: The number of portions ordered on that line.
- Void?: Marked True or Yes if the item was voided during service.
The five columns RevenArc reads
Toast's export has more detail than a menu review requires. RevenArc's importer reads only five columns to build an accurate menu history. It accepts Toast's native header names or their standardized equivalents:
- check_id (Check Id in Toast): The unique number of the guest check. This connects separate dishes that were ordered on the same ticket.
- closed_at (Sent Date in Toast): The timestamp when the item was ordered or completed. This puts the sale into the right day, week, and service period.
- product_name (Menu Item in Toast): The exact name of the dish as it appears on your menu.
- quantity (Qty in Toast): How many portions of the dish were ordered on that line.
- item_net_amount (Net Price in Toast): The actual dollar amount collected for that dish after item discounts, excluding tax and tip.
If your export renames these columns, RevenArc may not be able to read the file. Keep Toast's default names for these five.
RevenArc does not read the Server column.
RevenArc also checks the Void? column. Any row where Void? is True or Yes is discarded automatically so voided dishes do not count toward your sales or order counts.
Example: how three rows add up
Because Toast records a new row for each item on a check, items ordered across different checks must be grouped to find total volume and sales.
Here is an example showing three rows of sales data from one lunch shift:
| Check ID | Date / Time | Dish | Qty | Net Price |
|---|---|---|---|---|
| chk-401 | 2026-10-20 12:15 | Fish Tacos | 1 | $16.00 |
| chk-402 | 2026-10-20 12:45 | Fish Tacos | 2 | $32.00 |
| chk-402 | 2026-10-20 12:45 | Chicken Sandwich | 1 | $15.00 |
Here is how the arithmetic adds up per dish:
- Fish Tacos: Orders: 1 order from check 401 plus 2 orders from check 402 = 3 orders. Net sales: $16.00 plus $32.00 = $48.00. Average collected price per dish: $48.00 divided by 3 = $16.00.
- Chicken Sandwich: Orders: 1 order from check 402 = 1 order. Net sales: $15.00. Average collected price per dish: $15.00 divided by 1 = $15.00.
- Totals: Total orders: 3 plus 1 = 4 orders. Total sales: $48.00 plus $15.00 = $63.00.
What the sales export misses
The Item Selection Details export tells you what sold, when it sold, and how many dollars came in. It does not tell you what the food cost to make.
Without recipe costs, sales numbers only show popularity. A dish that brings in $48.00 might leave strong dollars or very few, depending on what went onto the plate. To turn sales data into profit decisions, you combine this sales history with your recipe costs. Read our guide on how to calculate plate cost to work out your ingredient expense per dish.
Once you have plate costs and weekly orders, you can compare each dish's popularity against its dollar contribution. To see how these numbers sort dishes into the four groups, read our guide on menu engineering for a small restaurant.
If you use RevenArc, you upload this CSV export, and RevenArc groups rows into completed checks, calculates each dish's weekly orders and sales, and once you enter plate costs, shows each item's dollars per plate and which of the four groups it falls into in your weekly review.
See what a menu review looks like.
The sample shows how a review can bring an item's sales, missing information and next question together in one place. Its data is illustrative.
Questions operators ask
What is the Toast Item Selection Details export?+
It is a line-item sales export that lists each menu item ordered across guest checks for a chosen period.
Which columns does RevenArc need from the Toast export?+
RevenArc reads check_id, closed_at, product_name, quantity, and item_net_amount, and checks Void? to discard voided items.
Does RevenArc read server or staff names from the Toast export?+
No. RevenArc drops the Server column and does not score or track individual employees.
RevenArc
Menu decisions and restaurant intelligence
We build RevenArc for restaurant operators who want a clearer view of their menu and a useful place to start the next review.
Follow the next article.
Email updates aren't available yet. You can follow RevenArc in your feed reader to see new articles as they're published.
Open the RSS feedKeep reading
How to price add-ons and sides on a restaurant menu
How to price add-ons and sides on a restaurant menu comes down to margin dollars and attach rate rather than target food cost percentage. How portion costs, modifier pricing, and guest uptake shape your weekly menu contribution.
What to do when beef goes up 12 percent
What to do when beef goes up 12 percent is a question most operators face when protein markets tighten. How wholesale protein hikes hit different plates, and your three operational options as an owner.