Stock Expiry and Obsolescence Management Guide

Guide to FEFO picking, QuickBooks expiry tracking, reporting, disposition, and ATP practices to reduce waste and prevent backorders.

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

Stock Expiry Management: From Receiving to Reliable Orders

How to use expiration dates for inventory in QuickBooks Desktop Enterprise

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.

Related Blog Posts

plans

Get Started

plans

plans

Related articles

Our platform is designed to empower businesses of all sizes to work smarter and achieve their goals with confidence.

How to Set Up Inventory Tracking in QuickBooks Desktop

Learn how to effectively set up and manage inventory tracking in QuickBooks Desktop, including enabling features, adding items, and utilizing reports.

Read full blog

7 Ways to Reduce Inventory Errors in Small Warehouses

Learn effective strategies to minimize inventory errors in small warehouses, enhancing accuracy and boosting operational efficiency.

Read full blog

FIFO vs FEFO: Which Inventory Method Is Right for You?

Compare FIFO and FEFO to select the best inventory rotation: FIFO for non-perishables, FEFO for expiry-sensitive items, plus tech needs and implementation tips.

Read full blog