Storekeeper

QuickBooks Reorder Point Formula and Software for Stale Numbers

Buying guide · 6 min read

Create your account in a minute · no card required

Nothing you paste is stored.

SKU On hand Cover

SKUs, scroll for the rest

A live preview of Storekeeper's forecasting engine on fictional sample dataon the rows you pasted. In your account the same engine runs on the stock and sales export you upload, and checks it again every day.

A QuickBooks reorder point is a number you type for each inventory item. QuickBooks compares it with the quantity on hand and flags the item when stock falls to it. It does not calculate the number, and it does not update when your sales or your supplier's delivery time change. For a few dozen steady items that is fine. For hundreds of SKUs the typed numbers go stale, and the fix is to recompute them from sales data on a schedule or with forecasting software from $49 a month.

This guide is for owners and buyers who run their inventory in QuickBooks Online or Desktop and keep stocking out of some items while overbuying others. It shows the formula, a worked example from a sales export, how fast typed reorder points go wrong and when it is worth moving the calculation out of QuickBooks. Menu names vary by edition, so check Intuit's current documentation for where the field lives in yours.

What a reorder point in QuickBooks does

You enter a reorder point on each product. When quantity on hand reaches it, QuickBooks shows the item in its low stock alerts and reports, and in some editions it can start a draft purchase order. That is all. It has no idea how fast the item sells or how long your supplier takes, so it cannot tell you whether 20 units is two days of stock or two months.

The formula to put in that field

reorder point = (daily sales rate × lead time in days) + safety stock

The first term is what you sell while the order is on its way. The second is a buffer for uneven weeks. The general method is explained in the reorder point guide, and the buffer in how much safety stock to hold.

Worked example from a QuickBooks sales report

A building supply seller runs Sales by Product/Service Summary for the last 90 days. Three items come out like this. The numbers are illustrative.

ItemUnits sold, 90 daysDaily rateSupplier daysBufferReorder pointTyped last year
Deck screws, 5 lb box90010.01440180100
Caulk, 10 oz tube2703.07103160
Door hinge set901.028103825

The typed numbers are wrong in both directions. Deck screws will run out before the order arrives, with 100 typed against 180 needed, so the shelf is empty for about 8 days per cycle. Caulk ties up double the stock it needs. The hinge set has a 28 day lead time, so a point that looks sensible on the shelf is 13 units short. Nothing in QuickBooks tells you this, because each number was reasonable on the day somebody typed it.

How quickly typed reorder points go stale

  • Seasonality. If deck screws sell 16 a day in May, the point should be about 264, not 180. Nobody retypes 600 items every month.
  • Supplier drift. The supplier quoted 14 days and the last five deliveries averaged 19. Use the real figure.
  • Price and pack changes. A new pack size changes both the rate in units and the order multiple.
  • Dead stock. An item that stopped selling still holds a point and keeps asking for stock.

Three ways to keep reorder points current

  1. A spreadsheet. Export sales by item every month, apply the formula, paste the results back. Cheap and workable up to a few hundred SKUs, but it depends on one careful person.
  2. An add-on or inventory system connected to QuickBooks. These sync stock and orders with QuickBooks and are priced from tens to hundreds of dollars a month. Check each vendor's own pricing and what the sync actually writes back.
  3. A planning tool that works from your export. Storekeeper takes the item list and sales by item you export from QuickBooks and upload, recalculates every reorder point and days of cover on each upload, and suggests order quantities. It does not connect to QuickBooks or write back, so you still enter the final number in QuickBooks if you want the alert there. Plans are $49 and $149 a month, and the QuickBooks SKU forecasting page walks through one SKU end to end.

Which option fits which business

Under about 50 items and one supplier, type the points and review them each quarter. Between 50 and 300 items, the monthly spreadsheet works if someone owns it. Past that, or when lead times run beyond four weeks, the cost of a wrong point (a stockout on a fast item or cash tied up in a slow one) usually exceeds the subscription. A supplier of home care equipment selling to caregiver agencies and marketplaces such as Aides sees the same pattern, because a few consumables sell steadily while a long tail sits. Wholesalers can read how this plays out in wholesale inventory software, and the full picture of what QuickBooks covers is on the QuickBooks inventory management page. Intuit's own help center lists the inventory reports you will export: QuickBooks support.

Questions buyers ask about QuickBooks reorder points

How do I set a reorder point in QuickBooks Online?

Open the product or service, enter a number in the reorder point field and save. QuickBooks then flags the item when quantity on hand reaches it. Calculate the number first as daily sales times lead time plus safety stock, because QuickBooks will not do it for you.

Does QuickBooks calculate reorder points automatically?

No. It uses the number you enter and compares it with the quantity on hand. Calculating the point from sales history and supplier lead time has to happen outside QuickBooks, in a spreadsheet or in forecasting software.

Can QuickBooks create purchase orders automatically?

Some editions can draft a purchase order when an item reaches its reorder point, using the quantity you set. The quantity is fixed, so it does not adapt to demand. Storekeeper's Growth plan drafts purchase orders per supplier from the forecast as PDFs you send yourself.

How much does reorder point software for QuickBooks cost?

Storekeeper is $49 a month on Starter and $149 on Growth, with forecasting and reorder points on every plan. Connected add-ons are priced by their vendors, so compare current prices on the pricing page and theirs.

See this math run itself

The free stock scan computes cover, safety stock and verdicts per SKU on sample data or rows you paste. No signup.

Run the stock scan

More from the stockroom

Inventory forecasting

Reading about it is step one

Step two is a system that does this arithmetic for every SKU, every day. Create your account.

One confirmation email, no spam, no card required.