⏰

Inventory Management

Batch Tracking & Expiry Management: Never Sell Expired Products Again

Selling expired products damages your reputation, wastes money, and can land you in trouble with the FDA. Learn how batch tracking and expiry management in SyncBooks protects your business and your customers.

Efua OwusuJul 14, 20259 min read

If you sell food, beverages, pharmaceuticals, cosmetics, or any perishable product in Ghana, batch tracking and expiry management are not optional — they are essential for your business survival. One expired product reaching a customer can destroy years of trust, trigger FDA action, and cost you real money.

Why Batch Tracking Matters

The Business Case

Every year, Ghanaian businesses lose millions of cedis to:

•Expired stock write-offs — products that sat too long on shelves

•Customer returns — expired items discovered after purchase

•Regulatory fines — FDA Ghana conducts regular inspections

•Reputation damage — one viral social media post about expired goods can tank your business

•Waste — no visibility into which items are approaching expiry

The Compliance Angle

The Food and Drugs Authority (FDA) Ghana requires businesses dealing in regulated products to:

•Maintain records of batch numbers for all products

•Implement First-In-First-Out (FIFO) stock rotation

•Remove expired products from shelves before expiry date

•Provide traceability in case of product recalls

•Keep records available for inspection for at least five years

Non-compliance can result in product seizures, fines, and in serious cases, prosecution. Batch tracking in your inventory system is not just good practice — it is your compliance documentation.

How SyncBooks Handles Batch Tracking

Assigning Batches on Receiving

When you receive goods from a supplier (via GRN — Goods Received Note), SyncBooks prompts you to enter batch information for products that have batch tracking enabled:

•Batch number — the manufacturer's batch or lot number

•Manufacturing date — when the batch was produced

•Expiry date — when the batch expires

•Quantity in batch — how many units in this specific batch

•Cost per unit — purchase cost for this batch (important when prices fluctuate between deliveries)

You can receive multiple batches of the same product in a single delivery — each tracked independently.

FIFO Deduction (First-In, First-Out)

When a sale is made — whether at the POS or through an invoice — SyncBooks automatically deducts stock from the oldest batch first. This ensures:

•Products closest to expiry are sold first

•You minimize waste from expired goods

•Your stock rotation is automatic, not dependent on warehouse staff manually pulling older items

•Cost of Goods Sold (COGS) reflects actual purchase costs per batch

The FIFO deduction happens behind the scenes. Your cashier simply sells the product — the system handles batch allocation.

Expiry Alerts

SyncBooks monitors expiry dates across all your batches and alerts you proactively:

•30 days before expiry — early warning to plan promotions or transfers

•14 days before expiry — urgent alert to discount or return to supplier

•On expiry date — item flagged as expired in the system

•Custom thresholds — set your own alert windows per product category

Alerts appear in your dashboard and can be sent via email or SMS so you never miss them.

Expiry-Based Actions

When products approach expiry, you have several options in SyncBooks:

1.Discount for quick sale — apply a promotional price to move near-expiry stock

2.Transfer to a clearance location — move to an outlet or clearance warehouse

3.Return to supplier — if your agreement allows returns of near-expiry items

4.Write-off — record the loss properly in your books with the correct journal entry

Write-Offs for Expired Stock

When products expire, SyncBooks handles the write-off cleanly:

1. Select the expired batch

2. Initiate a write-off with a reason (expired, damaged, recalled)

3. System removes the quantity from your stock

4. A journal entry is posted automatically: debit Expired Goods Expense, credit Inventory

5. Full audit trail maintained for FDA compliance

Industries That Need Batch Tracking

Food and Beverages

•Dairy products with short shelf lives

•Canned goods and packaged foods

•Beverages with expiry dates

•Fresh produce with use-by dates

Pharmaceuticals

•Prescription medications

•Over-the-counter drugs

•Supplements and vitamins

•Medical supplies

Cosmetics and Personal Care

•Skincare products

•Hair products

•Perfumes and fragrances

•Cleaning chemicals

Agricultural Inputs

•Fertilizers with efficacy periods

•Pesticides with active ingredient degradation

•Seeds with viability timelines

Real-World Example: Mensah's Pharmacy

Mensah runs a community pharmacy in Kumasi. He stocks over 2,000 pharmaceutical products, many with expiry dates within 12-24 months of manufacture. Before SyncBooks, his team conducted manual shelf checks every week — a process that took 3-4 hours and still missed items tucked in the back of the storeroom.

After implementing batch tracking in SyncBooks:

•Every delivery is received with batch numbers and expiry dates

•The system automatically sells oldest batches first (FIFO)

•A weekly expiry report highlights items approaching their date

•Write-offs are documented properly for FDA inspection records

•His pharmacists spend zero time on manual shelf-life checks

•He has not sold a single expired product in over a year

Setting Up Batch Tracking

Enabling batch tracking in SyncBooks is simple:

1. Edit the product and enable "Track Batches"

2. Optionally enable "Track Expiry Dates"

3. Set your expiry alert thresholds (days before expiry)

4. Start receiving — the system prompts for batch details on every GRN

Products without batch tracking enabled continue to work normally — you only add complexity where it is needed.

Protect Your Business and Your Customers

Expired products hurt everyone — your customers, your reputation, and your bottom line. Batch tracking and expiry management in SyncBooks gives you automated protection against these risks. Start your free 14-day trial and gain full visibility into every batch in your inventory.

Ready to try SyncBooks?

Start your 14-day free trial. All features unlocked. No credit card required.