How do you forecast demand from QuickBooks Online sales history?

To forecast demand from QuickBooks Online, export Sales by Product/Service Detail for the last one to three years, total each item's units by month in Excel, and average recent months to get a demand rate. Multiply that rate by lead time plus safety stock to get a minimum, and add a review period's demand for a maximum.

Does QuickBooks Online forecast inventory demand?

The standard sales and inventory reports in QuickBooks Online report history; none of the ones in Intuit's reporting guide projects future demand. Reorder points are numbers you enter, so any forecast behind them is one you make.

The good news is that the history is all there. Sales by Product/Service Detail lists every sale by item and date, which is everything a basic forecast needs.

How do you get the sales history into Excel?

Export one detail report covering a long enough window. Three years lets you see whether a peak repeats.

1. Go to Reports > Standard reports and open Sales by Product/Service Detail.
2. Set the period to the last 12 to 36 months.
3. Select Export/Print > Export to Excel and save the file.
4. In Excel, select Enable Editing if the data looks incomplete.
5. Also export Inventory Valuation Summary for quantity on hand and Open Purchase Order Detail for quantity on order.

Our purchasing reports guide explains what each export contains.

How do you calculate min and max in Excel?

Build one row per item with a demand rate, then apply four formulas. Use days consistently so lead time and safety stock share a unit.

1. Add a Month column to the sales export, then build a pivot table with items as rows, months as columns and quantity as values.
2. Daily demand = units sold in the last 12 months ÷ 365.
3. Min (reorder point) = daily demand × (vendor lead time days + safety stock days).
4. Max = min + daily demand × days between reviews.
5. Order quantity = max − quantity on hand − quantity on order, rounded up to the vendor's case or pack size. Order only when on hand plus on order is at or below min.

Example: Brightline Supply sold 730 units of an Ironwell Tools socket set in the last year, so daily demand is 2. Lead time is 14 days, safety stock 7 days, and the buyer reviews weekly. Min is 2 × 21 = 42, max is 42 + 14 = 56. With 30 on hand and none on order, order 26, rounded to a case of 12 makes 36.

Enter the min as the item's reorder point in QuickBooks Online so the low stock alert matches your sheet. The reorder point guide shows where.

What are the common mistakes with a spreadsheet forecast?

A flat yearly average is a fine start, but it fails in predictable ways. Check these before you trust the sheet.

• Seasonality. A yearly average under-orders before the peak and over-orders after it. For seasonal items, use the same months last year instead.
• Lumpy items. An item that sold 50 units in one order and nothing else looks like steady demand. Count how many months had any sales; if it is only a few, plan around a typical order instead of an average.
• Stockouts. Months with zero stock show zero sales, which drags the average down. Leave those months out.
• Stale numbers. Min and max drift as sales change. Refresh the sheet monthly or quarterly.
• Ignoring open POs. Always subtract what is already on order.

How do you spot overstock from the same data?

Compare stock on hand with demand. Any item holding far more than its max, or with stock and no sales in the past year, is overstock.

Weeks of cover is the simplest measure: quantity on hand ÷ weekly demand. Multiply the excess units by average cost from Inventory Valuation Summary to see how much cash is tied up, and stop reordering those items until they fall back toward max.

Where does ReorderOwl fit?

ReorderOwl replaces the spreadsheet. It is free to start and works right in ChatGPT: attach your Product/Service List, Sales by Product/Service Detail for the last 36 months and, optionally, Open Purchase Order Detail.

It tests each item's sales pattern. Items that sell most months get a trailing 12-month average, and items that sell only now and then get a method built for intermittent demand. The default forecast is not seasonal, so review items with strong seasonal peaks by hand. You get an Excel workbook of what to order and how much, with the forecast method for each line. There is no direct connection to QuickBooks and it does not create POs there. See the ReorderOwl for QuickBooks Online page.

Frequently asked questions

Can QuickBooks Online forecast inventory?

Its standard sales and inventory reports show history, not projections. Export Sales by Product/Service Detail and forecast in Excel or another tool.

What is the min max inventory formula?

Min equals daily demand times lead time plus safety stock days. Max equals min plus daily demand times the days between reviews. Order up to max when stock reaches min.

How much sales history should I use?

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

How do I handle items that sell rarely?

Averages understate their orders. Plan to keep about one typical order in stock, and review them by hand.

Does QuickBooks Online have a max stock field?

Intuit's help describes a reorder point field on products. Keep max in your spreadsheet and use it to set order quantities.

Sources

1. Use reports to see your sales and inventory status, Intuit QuickBooks, accessed 2026-10-01
2. Export reports to Excel, Intuit QuickBooks, accessed 2026-10-01
3. Set up low stock alerts, Intuit QuickBooks, accessed 2026-10-01