Skip to content
FoodSaver Restaurant operations

Toast Product Mix by day of week in Excel

A weekday PMIX view helps answer a narrow question: what usually sells on this kind of operating day? It is more useful for prep than an all-days average, provided the date coverage is honest.

The problem

Grouping sales by weekday is easy. Building a trustworthy comparison is harder. A four-Monday sample should not be compared with five Fridays as raw totals. Closed holidays should not silently behave like zero-demand days. Refunds and report definitions also need review.

Example Toast CSV columns

business_date,menu_group,item_name,quantity_sold,net_sales
2026-06-01,Entrees,Chicken Bowl,38,456.00
2026-06-08,Entrees,Chicken Bowl,42,504.00
2026-06-15,Entrees,Chicken Bowl,35,420.00

Add helper columns in Excel:

weekday = TEXT([@business_date],"dddd")
week_start = [@business_date]-WEEKDAY([@business_date],2)+1

Use a real date value, not a text label that merely looks like a date.

Build the PivotTable

  1. Put item_name in Rows.
  2. Put weekday in Columns or Filters.
  3. Put quantity_sold in Values.
  4. Show both Sum and Average.
  5. Add a distinct operating-date count outside the PivotTable if needed.
  6. Divide total quantity by included open dates for a per-day average.

Keep zero sales separate from “restaurant closed” and “missing export.” Those states mean different things.

Screenshot and demo

Synthetic Toast export preview with business dates and item rows

The preview step is where you should catch mismatched locations, periods, and file types before building the weekday table.

Free sample workbook

Download the Excel-ready weekday PMIX sample and download the prep conversion template.

The sample has three Mondays so you can compare total, average, minimum, and maximum quantities without using restaurant data.

Pricing

The FoodSaver workbook generator includes three free successful generations per UTC day within free limits. Pro costs $19/month or $190/year for larger files, saved mappings, report history, email delivery, and 90-day retention.

Review pricing.

Frequently asked questions

Does Toast PMIX already show day of week?

The Toast PMIX report supports selected date ranges and day-to-day item views, but an exported analysis may still need a weekday helper column depending on the file you downloaded.

Should holidays be included?

Flag them. Include them only when the target service is comparable.

Is average enough?

No. Review sample size, range, recent trend, sell-outs, promotions, and known events. Average is a baseline, not a forecast.

Do refunds reduce PMIX quantities?

Toast documents that menu reports, including Product Mix, are not reduced by refunds. Confirm the report behavior against the operational question you are answering.

Sources

Next: turn POS sales into a prep list.

Try the free Toast Prep + OneCSV workbook generator.

Tags: