QuickBooks SKU forecasting and order forecasting for every item you stock
QuickBooks knows what each item sold last quarter. It does not tell you how many units to order for next quarter. Export your sales by item, upload the file and get a forecast, a reorder point and a suggested order quantity per SKU.
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.
QuickBooks does not forecast demand per SKU or size supplier orders. It reports quantity on hand, sales by item and, if you type one in, a reorder point. Storekeeper adds the missing layer. You export the item list and sales by item from QuickBooks as CSV or XLSX and upload it. Each SKU gets a 14, 30, 60 or 90 day forecast, days of cover, a reorder point with safety stock and a suggested order quantity. Plans start at $49 a month. There is no connection to QuickBooks, so you re-upload for fresh numbers.
How SKU forecasting works with a QuickBooks export
Four steps, no integration to set up.
1. Export from QuickBooks
Run Sales by Product/Service Summary for the last 90 days and the inventory valuation or stock status list. Export both as CSV or XLSX.
2. Match the columns
Storekeeper needs sku and on_hand. Add units sold with the number of days, or a weekly sales figure, and optionally supplier, lead days and unit cost.
3. Read the verdicts
Every SKU is marked stockout risk, reorder, healthy or dead stock, with days of cover and the date you should order by.
4. Send the orders
On Growth, suggested quantities group into a draft PDF per supplier that you review and send yourself.
One SKU, from QuickBooks sales to an order quantity
Illustrative numbers for a distributor, not customer data.
A restaurant supply distributor sells stainless pans (SKU SP-12). Sales by Product/Service Summary for the last 90 days shows 540 units. The stock list shows 310 on hand. The supplier ships in 21 days. Orders to this supplier go out once a week.
| Step | Calculation | Result |
|---|---|---|
| Daily sales rate | 540 units / 90 days | 6.0 a day |
| Days of cover | 310 on hand / 6.0 | 52 days |
| Demand over lead time | 6.0 x 21 days | 126 units |
| Reorder point with a 30 unit buffer | 126 + 30 | 156 units |
| Order for a 60 day horizon | (6.0 x 60) + 30 - 310 | 80 units |
The same pan with a trend multiplier of 1.3 because a restaurant chain opened nearby sells 7.8 a day. Demand over lead time becomes 164 units, the reorder point 194, and the order for 60 days (7.8 x 60 + 30 - 310) is 188 units. Without a forecast the QuickBooks reorder point you typed last spring, say 120, would have fired about 9 days too late. Repeat that across 2,000 SKUs and it stops being a spreadsheet job.
QuickBooks reports, Storekeeper forecasts
Keep QuickBooks for the books. Use Storekeeper for the buying.
| Question | QuickBooks | Storekeeper from your export |
|---|---|---|
| What did this SKU sell? | Yes, sales by item reports | Reads it from the export |
| How many units will it sell in 30 or 60 days? | No per-SKU unit forecast | Yes, with an optional trend |
| When must I reorder? | A reorder point you type and maintain | Calculated from rate, lead time and buffer on every upload |
| How much should I order? | Not calculated | Suggested quantity per SKU, draft PO per supplier on Growth |
| Which stock is dead? | Only with a custom report | Flagged with the cash it ties up |
Storekeeper does not connect to QuickBooks, does not write back to it and does not use machine learning. The forecast is plain planning math on the numbers you upload. The wider QuickBooks inventory management page covers where QuickBooks inventory tracking stops, and the QuickBooks reorder point guide shows how to keep reorder points current.
Who benefits and who does not
Forecasting pays when ordering is the hard part.
It fits wholesalers, distributors and product sellers with hundreds to thousands of items who buy from a few suppliers with 2 to 12 week lead times and run QuickBooks Online or Desktop for the books. The file takes up to 20,000 rows. If you hold fewer than 30 SKUs and reorder by eye, QuickBooks alone is probably enough. For manufacturing, serial or lot tracking, or live stock sync you need an ERP, which our software comparison covers. Wholesalers can see the full workflow on the wholesale inventory page. Intuit documents the reports used here in its QuickBooks support center. Starter is $49 a month and Growth $149, compared on the pricing page.
QuickBooks forecasting questions, answered
Can QuickBooks forecast inventory by SKU?
How do I forecast orders from QuickBooks data?
Does Storekeeper connect to QuickBooks Online or Desktop?
Is the forecast AI?
How much does QuickBooks SKU forecasting cost?
More ways teams use Storekeeper
- Retail inventory software One stock picture across every store, with transfer suggestions.
- Ecommerce inventory management Plan stock across Shopify, Amazon and marketplaces from their sales exports.
- Warehouse inventory software Warehouse inventory management software for small business: forecasts, lead-time reorder points and drafted POs.
- Demand forecasting software Per-SKU forecasts that turn into reorder quantities, not charts.
- SKU management software Stock keeping unit software with per-SKU forecasts, reorder points and dead-SKU flags.
- Purchase order software Draft POs as PDF from forecasts, lead times and safety stock.
Turn your QuickBooks sales into orders
Create your account, upload your sales by item export and get a reorder point, a quantity and days of cover for every SKU.
One confirmation email, no spam, no card required.