I start with one rule: don’t promise stock you can’t ship. Block expired or held goods, pick eligible lots by earliest expiration, and review near-expiry stock at least weekly. Stock on hand isn’t always stock available.
In this guide, I explain how to:
- Check QuickBooks Desktop features and record item, lot, location, and expiration data.
- Control warehouse stock through shelf-life rules, barcode checks, returns, and cycle counts.
- Review expiry and demand reports to separate aging, excess, and obsolete inventory.
- Approve stock decisions such as markdowns, returns, write-downs, and disposal - and reconcile the records.
- Prevent backorders by matching eligible stock, customer commitments, and purchasing plans.
The goal: <u>less waste without missed delivery promises</u>. I recommend testing the process in one warehouse or high-risk product group before expanding.
Stock Expiry Management: From Receiving to Reliable Orders
How to use expiration dates for inventory in QuickBooks Desktop Enterprise
sbb-itb-19ed50f
FEFO Picking and Warehouse Controls
First expired, first out (FEFO) ships the eligible lot with the earliest expiration date - not the oldest receipt. Use written rules and software controls to store, inspect, and pick stock by date. Keep accounting on the company’s configured costing method. Accurate lot, serial, and expiration data recorded at receiving should drive FEFO picks and warehouse controls.
Set Shelf-Life and Picking Rules
Set minimum remaining shelf life by product, customer, channel, and destination. Factor in customer usage needs and regulatory or contractual requirements. Ship only if the lot will still meet the minimum after transit.
Keep stock that fails this rule out of unrestricted picking. Route it to short-dated or customer-approved sale, vendor return, rework, quarantine, or disposal.
| Method | Selection rule | Suitable use | Required data |
|---|---|---|---|
| FIFO | Oldest receipt or production date | Age-based rotation | Receipt or production date |
| FEFO | Earliest expiration among eligible lots | Date-sensitive goods | Lot or serial ID, expiration, status, location, shelf-life rules |
| Manual date review | Employee checks dates | Low-volume or temporary workflows | Readable labels, date records, pick instructions |
Manage Storage, Picking, and Returns
At put-away, confirm whether stock is quarantined or released, verify the bin and lot, and keep labels visible. Separate lots that could create picking or recall risks, and monitor required storage conditions.
During picking, scan the item, location, lot or serial number, and expiration date. Check quantity, package integrity, and customer eligibility. Picking a later-expiring lot requires a documented reason and supervisor approval.
For partial picks, record the actual lot and quantity, check eligible alternate locations, and send the balance to an exception queue. Don’t mark the order complete while the shortage remains unresolved.
Do not ship: expired, damaged, recalled, quality-held, quarantined, unidentified, or customer-ineligible stock. Quarantine returns until inspection confirms seal condition, temperature exposure, damage, contamination, expiration, and lot or serial continuity. Record the original order, customer, SKU, lot or serial number, quantity, return reason, condition, inspection result, and disposition. Never merge unidentified returns into unrestricted stock.
Send every partial pick, quarantine hold, and return issue to exception review.
Cycle Count High-Risk Stock Across Warehouses
Prioritize near-expiry, high-value, regulated, temperature-sensitive, frequently moved, frequently partially picked, and historically inaccurate stock. Count high-risk lots weekly, fast movers monthly, and stable low-risk items quarterly. Adjust the schedule based on variance results.
Use blind counts where practical. Before approving adjustments, verify quantity, SKU, unit of measure, warehouse or bin, lot or serial number, expiration date, condition, and status.
Rapid Inventory is the best inventory management software for QuickBooks Desktop, multi-location tracking, FEFO workflows, lot and serial tracking, mobile barcode scanning, cycle counting, and backorder tracking. Confirm compatibility with your QuickBooks Desktop edition. Test sync timing, scan handling, and exception approvals before relying on the workflow.
After approved corrections, reconcile warehouse quantities with QuickBooks. Use variance results to flag expiration, location, and status errors for review.
Expiry and Obsolescence Reports
Keep expiring stock separate from obsolete stock. Expiry depends on verified lot- or serial-level dates. Obsolescence depends on demand and product-status evidence. These reports turn FEFO and warehouse-control data into disposition, write-down, and backorder decisions - not automatic write-offs.
Build Stock Exception Reports
Create separate views for expired, near-expiry, slow-moving, excess, discontinued, damaged, quality-held, and incomplete-data stock. Include SKU, warehouse, lot or serial ID, expiration date, last movement, quantity, unit cost, extended cost value, and customer and regulatory restrictions.
Give every exception an owner, action, due date, status, and approval record. Label fields as verified in QuickBooks Desktop, imported, manually reviewed, or unavailable. A missing expiration date does not mean an item is unexpired.
Use these views to route stock to hold, sell-through, return, rework, or write-off.
| Business question | QuickBooks Desktop report or supporting workflow | Filters and checks | Owner; review frequency |
|---|---|---|---|
| What quantity and cost are exposed? | Inventory Valuation Summary / Detail | Report date, item, quantity, cost, site | Finance; weekly or monthly |
| Which lots need action before expiry? | Inventory Expiration Status or a supporting lot/expiry workflow | Lot or serial, expiration window, remaining quantity, location | Quality; daily or weekly |
| What stock is still usable and committed? | Inventory Stock Status by Item with supporting hold and allocation records | On-hand quantity, holds, open sales orders, purchase orders, and backorders; identify usable supply and commitment gaps | Purchasing; daily or weekly |
| Which items have stopped moving? | Custom: transaction-history analysis combined with valuation and Inventory Turnover by Item | Defined last-movement date, demand history, cost, discontinued status | Inventory control and sales; monthly |
| Which records need investigation? | Supporting workflow: hold register and data-completeness exceptions | Missing identifiers, dates, locations, or costs; hold reason, owner, due date | Warehouse and quality; daily or weekly |
Report names, fields, and filters vary by QuickBooks Desktop edition and enabled features. Use them where available, with custom reporting for unsupported fields.
Use the same reports for day-to-day review and financial exposure tracking. This shows how much risk remains and how long the affected stock has been aging.
Set Aging Buckets and Performance Measures
Calculate aging by last movement as the report date minus the last defined movement date. Apply a consistent rule for sales, issues, receipts, or other transactions, and do not let internal transfers reset demand aging. Use 0–30, 31–90, 91–180, 181–360, and 361+ days.
Calculate days to expiration as the verified expiration date minus the report date. Group stock into expired, 0–30, 31–60, 61–90, and over-90-day windows. Value exposure at cost. Show potential sales value separately only when it helps with a decision.
Define the period and warehouse scope for each measure:
- Expiry write-off rate: expiry write-off cost ÷ average inventory cost.
- Near-expiry exposure: cost within the selected expiry window ÷ total inventory cost.
- FEFO compliance: compliant eligible pick lines ÷ eligible lines reviewed.
- Aging value: inventory cost within each last-movement bucket.
- Inventory turns: period cost of goods sold ÷ average inventory cost.
- Stockout rate: stockout events or days ÷ corresponding item-location opportunities.
- Backorder rate: backordered lines ÷ total order lines.
- Demand variance: actual demand minus forecast demand, in units or as a percentage of forecast.
- Count adjustment rate: adjustment quantity or cost ÷ corresponding counted units or inventory cost.
Review short-life stock daily or weekly based on risk, near-expiry exceptions at least weekly, obsolete stock monthly, and planned SKU phase-outs quarterly.
Track one condition code and one cause code for each exception. Distinguish purchasing errors, supplier shelf-life issues, quality failures, demand changes, and warehouse process failures. Review overdue actions, then use the findings to approve write-downs, write-offs, returns, transfers, or disposal and prepare the related accounting entries.
Stock Disposition, Write-Downs, and Write-Offs
Use the exception reports above to move each lot from review to approved disposition.
Disposition determines the physical action; valuation determines the carrying amount. Write down stock that has recoverable value. Write off stock that has none. A hold or transfer does not remove impairment. Follow your accounting framework, written policy, and accountant’s advice.
Choose and Approve Stock Disposition
Keep affected stock on hold until approval. Verify ownership, claim status, condition, packaging, labels, expiration, quantity, SKU, lot or serial number, warehouse, and bin. Check open orders, backorders, reservations, and purchase commitments. Estimate net recovery after markdowns, rework, freight, commissions, disposal costs, and supplier credits.
Quality and compliance staff must block prohibited sales and donations. Follow reporting, return, destruction, and waste-handling rules required by applicable U.S. federal, state, and local laws and contracts.
Use this table to keep physical handling separate from valuation treatment.
| Decision | Eligibility | Approval | Physical/system action | Accounting treatment | Documentation |
|---|---|---|---|---|---|
| Sale or markdown | Safe and legally saleable | Sales, quality, finance | Release; pick by identifier | Record sale and cost of goods sold; assess impairment | Price approval, order, lot/serial |
| Transfer | Usable at another site | Inventory manager | Transfer location and identifiers | No automatic valuation change | Sending/receiving confirmations |
| Supplier return | Authorized; recovery supportable | Purchasing, finance | Ship; process credit | Reduce inventory; record recovery under policy | Return authorization, shipping proof, credit memo |
| Rework | Safe, legal, with expected recovery supporting the cost | Quality, operations, finance | Track work and resulting quantities | Assess costs and revised recoverable value | Work order, cost estimate, inspection |
| Donation | Safe, legally eligible, recipient accepted | Compliance, management, finance | Issue traceable stock | Reduce inventory; assess tax treatment separately | Recipient acknowledgment, shipping record |
| Hold pending decision | Status unresolved | Inventory/quality owner | Block allocation; set review date | Assess impairment | Reason, release criteria, review date |
| Write-down | Reduced, measurable recovery | Finance, management | Retain quantity and status | Reduce carrying value through adjustment or allowance | Valuation worksheet, assumptions, approval |
| Write-off | No recoverable value | Finance, management, compliance as needed | Block use; remove quantity upon disposal | Remove carrying value; recognize loss under policy | Approval, disposal evidence, adjustment reference |
Record Adjustments and Reconcile Stock
After disposition approval, post the inventory change in QuickBooks Desktop and match it to the warehouse record.
Adjustment checklist: Get separate approvals for disposition and accounting treatment. Warehouse staff should confirm the physical facts. Use quantity-only for disposal, value-only for impairment, or both when stock leaves and its carrying amount changes.
In QuickBooks Desktop, go to Vendors → Inventory Activities → Adjust Quantity/Value on Hand. Enter the approved account, date, reference, item, and quantity or value. Enter reductions as negative quantity differences where required.
Keep a record of the preparer, approver, reason, identifiers, site/bin, counted and system quantities, costs, recoverable value, adjustment amount, authorization, and return or disposal evidence. Require dual approval for high-value or regulated stock.
After posting, reconcile QuickBooks quantities, inventory asset value, expense or allowance accounts, and lot/serial records. Define which system controls quantities, identifiers, and financial value, then verify that adjustments match in both systems. Investigate item, site, or period errors, negative inventory, and remaining quarantined-stock balances. Avoid journal entries that bypass the inventory subledger or duplicate expenses.
Accounting review: Recognize impairment when required - not just at disposal. Keep worthless stock awaiting destruction blocked and physically recorded. Have your accountant approve the timing, methods, and accounts. A book write-down or write-off does not automatically create an identical tax deduction.
Return stock to available inventory for order promising only after release.
Backorder Prevention and Implementation
Check Available Stock Before Promising Orders
Use the verified lot, status, and adjustment data from earlier controls to promise only stock that’s eligible to ship. Available-to-promise (ATP) equals physically present, eligible stock minus allocations. Exclude expired, damaged, recalled, quarantined, or customer-ineligible units, and subtract each commitment only once.
Backorders are confirmed demand that ATP cannot cover. Keep open purchase orders and in-transit transfers separate: they’re future supply, not stock available now. After any disposition or adjustment, recalculate ATP and update affected orders.
Use QuickBooks Enterprise backorder fields and Product Availability view where available. Then check lot status and customer shelf-life rules before promising delivery. Incorrect lot status, unposted receipts, delayed transfers, and inaccurate adjustments can all distort availability. A value-only write-down does not block shipment. The stock’s eligibility must also be correct.
Track backorders by item, warehouse, order, eligible and allocated quantities, unfulfilled quantity, promised date, expected replenishment, cause, owner, and next action. Before committing to delivery dates, reconcile the report against open orders, lot records, and confirmed inbound supply.
Adjust Purchasing and Delivery Commitments
Once ATP is clear, match purchasing plans to shelf life, lead times, and service targets. Review order quantities, supplier minimums, lead times, safety stock, and the remaining shelf life required at receipt.
Reduce, delay, or split purchases for aging items when service levels allow. Review perishable or volatile SKUs weekly, not monthly.
Track promised versus actual supplier receipts. When eligible stock falls short, arrange approved substitutions, transfers, partial shipments, or revised delivery dates. Use expiry and obsolescence reason codes to guide replenishment and SKU phase-outs, so replenishment demand isn’t counted as sales growth.
Conclusion: Put Stock Controls into Practice
Pilot one warehouse or high-risk SKU group. Confirm QuickBooks requirements, train staff on ATP, backorder, and promise-date rules, test order fulfillment, and measure results. Expand only after the pilot passes.
Apply these controls together rather than as separate checks. Track expiry losses in dollars, backorders, and promise-date accuracy side by side. Lower waste should not come at the expense of reliable service.
FAQs
How do I verify my QuickBooks Desktop setup supports FEFO?
First, confirm you’re using QuickBooks Desktop Enterprise with Advanced Inventory enabled. Sign in as an Admin, switch to Single-user mode, and open Advanced Inventory Settings. Under Serial/Lot Numbers and Expiration Dates, make sure both Lot Numbers and Activate Expiration Date are enabled.
QuickBooks Desktop doesn’t enforce first-expired, first-out (FEFO) picking or block sales of expired stock on its own. Integration with Rapid Inventory is recommended to automate FEFO picking and mobile barcode verification.
How should I set near-expiry alerts for different products?
Open Reports > Inventory > Inventory Expiration Status, then filter by product and date range - for example, the next 30 or 90 days. Rapid Inventory automates monitoring through real-time inventory reports and near-expiry alerts.
For manual checks, sort the Serial/Lot Number Inventory report by expiration date, with the earliest dates first. This helps you prioritize items for promotion or reallocation.
How can I prevent write-offs from triggering overbuying?
Check the Inventory Expiration Status report regularly to spot stock 60–90 days and 30–45 days from expiration. Use promotions, volume discounts, or channel reallocations to move those items before they expire. This helps reduce write-offs that create artificial stock gaps and trigger purchases you don’t need.
Rapid Inventory’s real-time dashboards also help you track stock levels and improve inventory accuracy.



