How do you forecast demand from Square sales history?

To forecast demand for a Square business, export the Custom Item report for the last 12 to 36 months, total each item variation's units by month in a spreadsheet, and average recent months to get a daily rate. Multiply that rate by vendor lead time plus safety days for a reorder level, and add one review period's demand for an order-up-to level.

Does Square forecast demand for you?

Not item by item, as far as Square's help articles describe. The item sales, sell-through and aging inventory reports show what has happened; low stock alerts are thresholds you type in. The sell-through report's sales velocity column is the closest thing to a demand rate, and it is limited to Square for Retail Plus and Premium.

Square's Managerbot, an AI assistant in Square Dashboard, can answer questions about your sales and items and can create a purchase order from an invoice, packing list or order confirmation email. Its help article does not describe per-item demand forecasts, and Square asks you to check its answers for accuracy.

How do you get the sales history out of Square?

1. In Square Dashboard, go to Reports, then Custom, then Custom Item report.
2. Set the date range to the last 12 to 36 months and choose All Locations, or one location if you buy for each store separately.
3. Use Summary, then Monthly, to see sales by month.
4. Click Export at the top right, choose CSV or Excel, and select the data to include.
5. Export the item library too (Items, then Item library, then Actions, then Export library) for current stock per location and default vendors.

Our Square reports guide covers what each report contains.

How do you turn sales into a reorder level and order quantity?

Work at the variation level, since a size or colour that sells fast needs its own numbers. Use days throughout.

1. Daily demand = units sold in the last 12 months ÷ 365.
2. Reorder level = daily demand × (vendor lead time days + safety days). Enter this as the variation's low stock alert.
3. Order-up-to level = reorder level + daily demand × days between orders.
4. Order quantity = order-up-to level − stock on hand − stock already on order, rounded up to the vendor's case size. Order when on hand plus on order is at or below the reorder level.

Example with made-up data: Brightline Supply sold 1,095 units of a 12 oz ceramic mug from Ironwell Goods last year, so daily demand is 3. Lead time is 8 days, safety stock 4 days, and Brightline orders every 14 days. The reorder level is 3 × 12 = 36 and the order-up-to level is 36 + 42 = 78. With 30 on hand and none on order, it orders 48, which is exactly four cases of 12.

The low stock alert guide shows where to enter the reorder level in Square.

What goes wrong with a spreadsheet forecast?

• Renamed items. Square treats a renamed item as a separate entry in reporting, so join the old and new names before averaging.
• Seasonality. A yearly average under-orders before a peak and over-orders after it. For seasonal items, use the same months last year.
• Stockouts. Weeks with no stock show no sales and drag the average down. Leave them out.
• Rare sellers. An item that sold 20 in one order and nothing else is not steady demand. Plan around a typical order instead.
• Open orders. Subtract what is already on order, or you will order it twice.

How do you spot overstock from the same data?

Divide stock on hand by weekly demand to get weeks of cover. Anything far above its order-up-to level, or with stock and no sales in a year, is overstock. On Square for Retail Plus or Premium, the aging inventory report shows the same thing from the other side: average days in stock, the last received date and stock value, which you can filter by vendor.

Where does ReorderOwl fit?

ReorderOwl replaces the spreadsheet. It works in ChatGPT today, and Claude setup is coming shortly. Upload your Square item library and item sales exports, and it forecasts each item from its sales history, compares that with the quantity at each location, and returns a workbook of what to order, how much and from which vendor, showing how each number was worked out. When you ask, it builds the purchase order for you to send; nothing is written to Square. See ReorderOwl for Square.

Frequently asked questions

Can Square forecast inventory demand?

Square's help articles describe reports of past sales, sell-through and stock age, not per-item demand forecasts. Export item sales and forecast in a spreadsheet or another tool.

Which Square report has sales by month?

The Custom Item report under Reports, then Custom. Use Summary, then Monthly, to compare months, and Export for CSV or Excel.

How much Square sales history should I use?

Use 12 months for the daily rate and up to 36 months to see whether seasonal peaks repeat.

Should I forecast per item or per variation?

Per variation. Sizes and colours sell at different rates, and Square keeps stock and low stock alerts per variation and location.

What is the reorder level formula?

Daily demand times vendor lead time plus safety days. Order up to that level plus one review period's demand.

Sources

1. View item, category and modifiers sales reports, Square Support Center, accessed 2026-10-01
2. View sell-through reports, Square Support Center, accessed 2026-10-01
3. Run an aging inventory report, Square Support Center, accessed 2026-10-01
4. Use Managerbot to manage business tasks and insights, Square Support Center, accessed 2026-10-01
5. Create inventory alerts, Square Support Center, accessed 2026-10-01