An open sales order doesn’t always mean a stock shortage. I check remaining customer demand against usable stock at the fulfillment site, then review incoming purchase orders separately. If an order needs 100 units and only 60 are available, today’s shortage is 40 units - even if more stock is due tomorrow.
In this guide, I explain how to:
- Check sales orders, invoices, receipts, and item records so quantities line up.
- Compare demand, available stock, and unreceived PO balances by item and location.
- Track late deliveries, backorder age, and fill rates using consistent dates and rules.
- Assign each issue an owner, next action, and deadline.
- Check QuickBooks Desktop and Rapid Inventory data before making customer commitments.
My rule: <u>verify stock before promising it</u>. Keep today’s shortage separate from future supply, and use daily, weekly, and monthly checks to keep reports accurate.
QuickBooks Desktop Backorder Reporting Workflow
QuickBooks - Back Orders 2017
sbb-itb-19ed50f
Match Open Sales Orders With Available and Incoming Stock
After checking item records and location assignments, use the reports below to separate stock shortages from gaps that incoming supply may cover. For each SKU and location, compare open customer demand, usable on-hand inventory, and remaining PO supply.
Keep today’s shortage separate from future coverage. A PO may fill the gap later, but it doesn’t make stock available now. Classify each line as covered, uncovered, inbound, partially received, or received but unallocated.
Customize Open Sales Orders by Item
In QuickBooks Desktop, go to Reports > Sales > Open Sales Orders by Item, then select Customize Report. Columns vary by edition. Where supported, include the item, description, sales-order date and due date, sales-order number, customer or job, ordered quantity, invoiced quantity, backordered quantity, available quantity, and location or site fields.
Use an item view for purchasing analysis and a customer or due-date view for shipping. Linked invoices reduce backordered quantity. Fully invoiced or closed orders should drop off the report.
Export to Excel, match SKUs and locations across reports, and reconcile totals. Use the report’s available quantity as-is. Then check whether incoming PO supply can cover the remaining gap.
Reconcile Remaining Purchase Order Supply
Use the built-in Open Purchase Order Detail report to review ordered, received, and remaining quantities by SKU and location. Count only the unreceived balance as incoming supply - not the original PO quantity. Check vendor commitments before treating that balance as coverage.
| PO status | Remaining supply | Receipt status | Reporting action |
|---|---|---|---|
| Unreceived | Ordered quantity less cancellations | No receipt recorded | Confirm vendor and expected receipt date |
| Partially received | Ordered quantity minus receipts and cancellations | Some units received | Count only the unreceived balance as incoming |
| Received | Zero | All units received | Remove from incoming; check allocation or shipment status |
| Closed or canceled | No expected usable supply | Receipt dates and quantities vary | Exclude from coverage; review demand depending on it |
Record receipts first so inventory and the linked PO update correctly. Don’t count received goods as both on-hand and incoming.
Find Overdue Purchase Order Lines
Build a late PO line list that includes the vendor, PO number, SKU, line number, location, promised receipt date, remaining quantity, receipt dates and quantities, and affected sales orders.
Confirm whether the promised date applies to the whole PO or individual lines. If line-level dates aren’t reliable, keep a dated vendor schedule.
For outstanding quantities, calculate overdue days as as-of date minus promised receipt date. Future dates aren’t overdue; keep missing dates in a separate exception group. For completed deliveries, compare promised dates with actual receipt dates - not PO closure dates.
Prioritize follow-up by delay, shortage units, and customer impact. Assign an owner and next follow-up date, then use these late lines to explain the shortages and fill-rate gaps tracked next.
Measure Item Shortages, Location Gaps, and Fill Rates
After matching open orders with incoming supply, measure the remaining gap by item and site.
Build an Item Shortage Report
Build a point-in-time shortage report that includes SKU, customer, outstanding demand, required date, on-hand, allocated, available, on-order, shortage, and expected availability date. Count only demand still uncovered after valid allocations and receipts.
Calculate immediate shortage = max(0, outstanding demand − inventory available to that order). Keep dated incoming supply separate. It may cover future demand, but it cannot reduce today’s shortage.
Match allocations to the same demand set so reserved stock isn’t counted twice. Check quantities against Inventory Stock Status by Item and values against Inventory Valuation Summary and Inventory Valuation Detail. Include sales value, estimated margin, and backorder age. Rank exceptions by customer impact, due date, units, margin, and how certain replenishment is.
Compare Demand and Supply by Location
Group demand, on-hand stock, available inventory, incoming supply, and transfer needs by SKU and site. Compare demand with supply at the fulfillment site, rather than using companywide totals.
Location-level detail depends on the QuickBooks Desktop edition, enabled inventory management software for QuickBooks Desktop, and clean item, warehouse, and transaction records. Classes and custom location fields do not track inventory by site.
Before transferring stock, reconcile site totals with company totals. Protect the sending site’s commitments, and confirm that incoming stock or transfers can reach the receiving site by its required date.
| Field | Source and meaning |
|---|---|
| SKU | QuickBooks item name or item number used to identify the product |
| Location | Warehouse, site, or inventory location assigned to the item or transaction |
| Customer | Customer associated with the eligible sales-order line |
| Order date | Date the customer order was entered |
| Required date | Requested, promised, or internally assigned fulfillment date |
| Ordered | Quantity originally ordered on the eligible line |
| Backordered | Quantity still unfulfilled at the reporting cutoff |
| On order | Unreceived quantity on purchase orders assigned to the location |
| Received | Quantity received against the purchase order by the cutoff |
| Status | Open, partially fulfilled, overdue, received, canceled, or closed according to documented rules |
Track Fill Rates and Backorder Age
Calculate trends in Excel using a fixed order cohort and fulfillment cutoff. Line fill rate is fully fulfilled eligible lines ÷ eligible lines × 100%; unit fill rate is fulfilled eligible units ÷ eligible ordered units × 100%.
Document how you handle cancellations, substitutions, partial shipments, and late fulfillment. To compare trends, apply the same cutoff rule to every cohort. Label whether fulfillment means shipped by the required date or eventually shipped.
| Trend field | Calculation or reporting rule |
|---|---|
| Period | Order-date cohort; show dates as MM/DD/YYYY |
| Eligible lines | Count after documented exclusions |
| Ordered units | Eligible units in that same cohort |
| Fulfilled units | Cohort units shipped by the cutoff |
| Unfulfilled units | Eligible ordered units minus fulfilled units |
| Line fill rate | Fully fulfilled eligible lines ÷ eligible lines × 100% |
| Unit fill rate | Fulfilled eligible units ÷ eligible ordered units × 100% |
| Average delay | State the basis and population, such as calendar days from required date to shipment for completed late lines |
For open demand, current backorder age equals report date minus order date. Days overdue measures lateness past the required date. Group backorder age into 0–7, 8–14, 15–30, and 31+ days, and show financial exposure in a consistent format, such as $1,250.00.
Use these trends to distinguish purchasing, receiving, inventory accuracy, demand, and warehouse issues, then route each exception to the right owner.
Turn Backorder Reports Into Assigned Actions
Use the shortages, delay signals, and fill-rate gaps above to create a daily exception queue. Make each exception a tracked work item with a priority, owner, next action, due date, and last customer update date.
Review urgent orders daily. Check overdue PO lines and supplier delays weekly, then review fill rates and location performance monthly.
Assign Owners to Backorder Exceptions
Send demand without supply coverage and overdue PO lines to purchasing. Assign received stock awaiting entry or put-away to receiving, and available stock awaiting allocation or shipment release to fulfillment.
Inventory control handles negative balances, unexpectedly low on-hand quantities, and stale sales-order statuses. Customer service handles revised commitments. Even when several teams are involved, assign one accountable owner and require a specific next action and deadline.
Keep customer priority separate from FIFO/FEFO picking. Priority determines which order gets scarce stock. FIFO or FEFO determines which stock to pick after allocation. Record both decisions.
When sales-order-to-PO linking is enabled in QuickBooks Desktop, check Linked PO and Item Received to confirm that incoming supply is tied to demand.
With owners assigned, validate the warehouse data before release.
Connect Warehouse Reports With Rapid Inventory
Warehouse teams need live fulfillment data to carry out these assignments. Rapid Inventory adds two-way sync, multi-location tracking, FIFO/FEFO picking, lot and serial tracking, mobile barcode scanning, real-time inventory reports, and backorder tracking for QuickBooks Desktop.
Check Report Accuracy Before Taking Action
Before promising stock or closing an exception item, use this release checklist:
- Verify the as-of date, refresh time, and sync status.
- Confirm linked sales orders, POs, receipts, invoices, and shipments.
- Reconcile quantities and locations.
- Review aging and stale statuses.
- Confirm the owner, deadline, and follow-up.
QuickBooks Desktop and warehouse records must match before you act. If you correct any records, refresh the report before taking action.
Conclusion: Keep Backorder Reports Accurate
Use daily, weekly, and monthly checkpoints to compare remaining demand on open sales orders with on-hand stock and open PO balances by item and location. Document report definitions, filters, cutoff times, and ownership rules.
Archive a weekly snapshot that includes the cutoff time, filters, location scope, and owner so you can compare reviews over time. Keep fill-rate formulas fixed to distinguish actual improvement from changes in reporting. Each month, check for duplicate or inactive items, canceled orders, location mappings, open purchase orders, and sync errors.
For teams that need more warehouse control in QuickBooks Desktop, Rapid Inventory adds backorder tracking, multi-location visibility, and real-time inventory reports. Verify filters and sync settings before relying on those reports. Test a sales order, partial invoice, PO receipt, and location change to confirm that each event appears correctly in both systems.
FAQs
Why does my backorder report show shortages when stock is available?
QuickBooks tracks backorders as unfulfilled quantities on open Sales Orders. Stock committed to other orders isn’t available, so available stock = on-hand stock − committed stock. Quantities stay backordered until they’re invoiced or fulfilled.
Check Open Sales Orders by Item and Inventory Stock Status by Item. Compare available stock with on-hand quantities to see whether stock committed to other orders explains the shortage or whether another location has stock.
How should I allocate limited stock across backorders?
QuickBooks Desktop doesn’t automatically assign received stock to backorders. Assign it manually to the oldest open Sales Order lines first. Check quantities due in Open Sales Orders by Item, then use the Inventory Site filter to confirm available stock.
For partial deliveries, adjust the PO receipt quantities to match what arrived. Invoice only what you can ship, and leave the remaining quantities open on the same Sales Order. Reorder stock or transfer it from another site.
How can I verify backorder accuracy after a sync error?
Click Refresh in your reports or the Sales Order Fulfillment Worksheet to see current data. Reopen the Sales Order and check the backordered quantity to help avoid billing errors. Then compare unfulfilled quantities in the Open Sales Orders by Item report.
If the numbers still don’t match, use Rapid Inventory’s two-way sync to reconcile transactions and inventory levels between warehouse activity and QuickBooks Desktop.
