What should I reorder this week?

What QuickBooks gives you

Inventory Stock Status by Item lists every item with quantity on hand, on purchase order, and the reorder point, and puts a check mark next to anything under the point. The reorder point is a number someone typed when the item was set up. On most files it was typed once and never revisited.

The report has no idea of pace. An item with twenty on hand that sells two a week is fine. An item with twenty on hand that sells ninety a week runs out on Wednesday, and the report shows both as above the point.

What the reorder list needs

Three things. The stock count, the sales lines, and the supplier’s lead time. The count is the weekly stock report from QuickBooks, or a physical count if the QuickBooks quantities are not trusted. The sales lines are already in the database. The lead time comes off the supplier’s price sheet.

From those, each item gets a pace, weeks of cover, an order-by date, and a suggested quantity. The list is kept every Monday from the week the count starts. It does not pretend to know last spring.

Three questions from a fictional company

The Monday list, the opposite question, and whether last Monday’s list was acted on. The last one is the standing report the weekly email carries.

select r.yard, i.name as item, r.on_hand, r.on_order,
       r.weekly_velocity as per_week, r.weeks_of_cover, r.reorder_by, r.suggested_qty
from reorder_report r
join items i on i.id = r.item_id
where r.week = '2026-07-27'
order by r.weeks_of_cover, r.on_hand

with pace as (
    select i.canonical_id as item_id, t.class as yard, sum(l.qty) / 12.0 as per_week
    from txn_lines l
    join txns t on t.id = l.txn_id
    join items i on i.id = l.item_id
    where t.date >= '2026-05-04' and t.date < '2026-07-27'
    group by i.canonical_id, t.class),
price as (
    select item_canonical_id as item_id, unit_cost
    from item_costs c
    where effective_date = (select max(effective_date) from item_costs x
                            where x.item_canonical_id = c.item_canonical_id
                              and x.effective_date <= '2026-07-27'))
select s.yard, i.name as item, s.on_hand,
       round(coalesce(p.per_week, 0) * 10) / 10 as per_week,
       round(s.on_hand / p.per_week) as weeks_of_stock,
       round(s.on_hand * pr.unit_cost) as tied_up_at_cost
from stock_snapshots s
join items i on i.id = s.item_id
join price pr on pr.item_id = s.item_id
left join pace p on p.item_id = s.item_id and p.yard = s.yard
where s.week = '2026-07-27' and s.on_hand > 0
  and (p.per_week is null or s.on_hand / p.per_week > 12)
order by tied_up_at_cost desc

select r.yard, i.name as item, r.suggested_qty as list_said,
       coalesce((select sum(l.qty)
                 from po_lines l
                 join purchase_orders p on p.id = l.po_id
                 join items li on li.id = l.item_id
                 where li.canonical_id = r.item_id and p.yard = r.yard
                   and p.date >= '2026-07-20' and p.date < '2026-07-27'), 0) as ordered_that_week
from reorder_report r
join items i on i.id = r.item_id
where r.week = '2026-07-20'
order by ordered_that_week desc, list_said desc

Northgale Building Products is a fictional company. Every name, figure and supplier on this page is made up, built to behave like a real three-and-a-half-year QuickBooks Desktop file so we can show real screens without showing anyone’s real numbers. Data as of the 2026-07-27 refresh; the last invoice in the file is dated 2026-07-24.

Short answers

• Does QuickBooks Desktop have a reorder report?It has Inventory Stock Status by Item, which flags items under their reorder point. It does not say how much to order or by when.
• What if the quantities in QuickBooks are wrong?Then the count comes from a weekly physical count instead, and the list shows where the two disagree.
• How far back does the reorder history go?To the week the counts start. The list is kept from then on and never backfilled.

Related questions

• Write a purchase order from what you’ve used
• Are we paying more for windows than last year?
• Your systems, joined