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.
The scan could not run.
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.
| Item | Units sold, 90 days | Daily rate | Supplier days | Buffer | Reorder point | Typed last year |
|---|---|---|---|---|---|---|
| Deck screws, 5 lb box | 900 | 10.0 | 14 | 40 | 180 | 100 |
| Caulk, 10 oz tube | 270 | 3.0 | 7 | 10 | 31 | 60 |
| Door hinge set | 90 | 1.0 | 28 | 10 | 38 | 25 |
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
- 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.
- 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.
- 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 scanMore from the stockroom
- Buying guide Wine Inventory Software for Shops and Importers
- Buying guide Inventory Keeper Software for Counting and Forecasting Stock
- Buying guide Salon Inventory Software for Retail and Backbar Reorders
- Buying guide Auto Parts Inventory Software for Stores and Parts Sellers
- Buying guide Plant Nursery Inventory Software for Seasonal Stock
- Buying guide Furniture Inventory Software for Long Lead Times and Variants
- Buying guide Apparel Inventory Management System Cost by Tool and Plan
- Buying guide SkuVault Pricing and What a Quote Costs per Month
- Buying guide Brightpearl Pricing and What the Quote Includes
- Buying guide Linnworks Pricing and How the Quote Works
- Buying guide Sortly Pricing and Cost per Plan
- Buying guide Cin7 vs Unleashed Pricing for Wholesalers
- Buying guide Fishbowl vs QuickBooks Enterprise Pricing
- Buying guide Lightspeed POS Pricing and Lightspeed Retail Cost per Plan
- Buying guide Sumtracker Pricing and Cost per Plan
- Buying guide Ordoro Pricing and Cost per Plan for Shipping and Inventory
- Buying guide StockTrim Pricing and Cost by Revenue Band
- Buying guide Prediko Pricing and Cost by Revenue Band with Add-Ons
- Buying guide Sellbrite Pricing, Sellbrite Cost, Plans and Order Limits
- Buying guide Finale Inventory Pricing and Contract Terms
- Buying guide SOS Inventory Pricing and What Add-ons Cost
- Buying guide Veeqo Pricing and Cost per Month by Order Volume
- Buying guide inFlow Pricing and What the App Costs
- Buying guide Unleashed Pricing and Cost per Month
- Buying guide Zoho Inventory Pricing and Order Limits
- Buying guide Katana Pricing and Katana MRP Advantage Plan Cost
- Buying guide Fishbowl Pricing and Software Add-on Costs
- Buying guide Cin7 Pricing for Core, Omni and Add-ons
- Working capital How to Value Inventory for Taxes (Methods, Rules and COGS)
- Practice Consignment Inventory and How It Works
- Practice Par Level Inventory and How to Set Par Levels
- Practice How to Reduce Supplier Lead Time (9 Practical Ways)
- Working capital What Is Landed Cost? Formula, Components and How to Calculate It
- Practice Just-in-Time Inventory (JIT) Explained
- Practice What Is a SKU? Stock Keeping Unit Meaning, Examples and How to Set One Up
- Metrics What Is a Good Inventory Turnover Ratio? (Benchmarks by Industry)
- Practice How to Reduce Inventory Carrying Cost (6 Practical Levers)
- Practice How Much Safety Stock Should You Hold? (Formula and Service Levels)
- Practice How to Sync Inventory Across Multiple Sales Channels
- Practice How to Reduce Inventory Without Causing Stockouts
- Metrics Days of Inventory on Hand (DIO) Formula, Benchmarks and How to Lower It
- Practice Inventory Optimization Techniques to Cut Stock Without Stocking Out
- Practice Perpetual vs Periodic Inventory Systems
- Working capital Inventory Shrinkage Formula, Causes and How to Reduce It
- Working capital Inventory Carrying Cost Formula, Percentage and How to Lower It
- Practice Cycle Counting Methods, What It Is and How Often to Count
- Metrics ABC Analysis in Inventory Management with XYZ Matrix and Worked Example
- Metrics Inventory Turnover Ratio Formula, Benchmarks and What Good Looks Like
- Formulas Economic Order Quantity (EOQ) Formula and When to Trust It
- Practice Inventory Management in Excel, How to Build It and When to Stop
- Formulas Reorder Point Formula and Min Max Inventory Levels
- Working capital Dead Stock and How to Clear It
- Lost sales Stockouts and How to Avoid Them in 7 Steps