Storekeeper
For QuickBooks users who buy stock

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.

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.

The short answer

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.

From QuickBooks to an order

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.

Worked example

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 rate540 units / 90 days6.0 a day
Days of cover310 on hand / 6.052 days
Demand over lead time6.0 x 21 days126 units
Reorder point with a 30 unit buffer126 + 30156 units
Order for a 60 day horizon(6.0 x 60) + 30 - 31080 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.

What QuickBooks does and does not do

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 reportsReads it from the export
How many units will it sell in 30 or 60 days?No per-SKU unit forecastYes, with an optional trend
When must I reorder?A reorder point you type and maintainCalculated from rate, lead time and buffer on every upload
How much should I order?Not calculatedSuggested quantity per SKU, draft PO per supplier on Growth
Which stock is dead?Only with a custom reportFlagged 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.

Honest fit

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.

Frequently asked

QuickBooks forecasting questions, answered

Can QuickBooks forecast inventory by SKU?
No. QuickBooks reports what each item sold and what is on hand, but it has no per-SKU demand forecast. Storekeeper takes your sales by item and stock export, projects each SKU 14 to 90 days ahead from its sales rate and trend, and suggests an order quantity, from $49 a month.
How do I forecast orders from QuickBooks data?
Export sales by product and your stock list, divide units sold by the days in the period for a daily rate, multiply by supplier lead time, add safety stock and subtract stock on hand. Storekeeper does this for every SKU on upload and groups the results by supplier.
Does Storekeeper connect to QuickBooks Online or Desktop?
No. There is no sync and nothing to install. You export a CSV or XLSX from QuickBooks Online or Desktop and upload it, then re-upload when you want fresh numbers. The file can hold up to 20,000 rows.
Is the forecast AI?
No. It is transparent planning math: sales rate times an optional trend multiplier, days of cover, a reorder point with safety stock. You can check every number by hand, as the worked example above shows.
How much does QuickBooks SKU forecasting cost?
Starter is $49 a month and covers per-SKU forecasts, email reorder alerts and export. Growth is $149 a month and adds up to 5 locations, supplier lead times and draft purchase orders per supplier. See the pricing page for yearly rates.
Inventory forecasting

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.