EN
Inventory and Products

How Do You Find and Close an Inventory Discrepancy? Training on the Count Difference Table, Inventory Movements Report, Discrepancy Types, Adjustment Entries and Unexplained Discrepancies

How do you find and close stock discrepancies? Count variance table, stock movements report, types of discrepancies and adjustment entries: an 8-lesson hands-on guide with examples.

Contents 14 sections
  1. What will you be able to do by the end of this training?
  2. Lesson 1: Why does a stock discrepancy matter?
  3. Lesson 2: What preparation is done before the count?
  4. Lesson 3: How do you prepare a discrepancy table?
  5. Lesson 4: How do you trace a discrepancy with the stock movements report?
  6. Lesson 5: What causes stock discrepancies?
  7. Lesson 6: How do you make an adjustment entry?
  8. Lesson 7: How do you manage an unexplained discrepancy?
  9. Lesson 8: How do you set up a routine that prevents discrepancies from recurring?
  10. What are the most common mistakes with stock discrepancies?
  11. How does NetKasam make tracking stock discrepancies easier?
  12. Mini quiz: Test what you have learned
  13. Conclusion: Count your ten fastest-moving products this week
  14. Frequently Asked Questions About Stock Discrepancies

You counted the warehouse: a product showing 4,800 units in the system came out at 4,704 units on the shelf. Ninety-six units are missing. Is this theft, a recording error, or goods that were sold but never invoiced? If the answer isn't known, the discrepancy is either quietly written off or comes back as a bigger problem at the next count. A count discrepancy is a result; the real job is finding where that discrepancy came from and closing it.

This article is not a narrative but an 8-lesson practical course. We will answer the question how to find and close stock discrepancies with numbers through a sample warehouse of 4,800 units: what the discrepancy means, pre-count preparation, the discrepancy table, tracing back with the stock movements report, types of discrepancies, the adjustment entry, unexplained discrepancies and the routine that prevents them. At the end there is a mini quiz and an answer key. For how to do the count, see the article how to do a stock count; here we focus on resolving the discrepancy that emerges after the count.

What will you be able to do by the end of this training?

In short: You will lay out the count discrepancy in a table by product and cause, find its source with the stock movements report, make the correction with documents and set up a routine that prevents the discrepancy from recurring.

Course mapSix steps to resolve a stock discrepancy
  1. 01
    PreparationCut off records before the count.
  2. 02
    Discrepancy tablePut the system and the count side by side.
  3. 03
    Movement reportLook at the product's history.
  4. 04
    CauseBreak the discrepancy down by type.
  5. 05
    CorrectionClose it with documents.
  6. 06
    PreventionDo regular partial counts.

The 8 lessons of the course: (1) what a stock discrepancy means, (2) pre-count preparation, (3) the discrepancy table, (4) the stock movements report, (5) types of discrepancies, (6) the adjustment entry, (7) unexplained discrepancies, (8) the prevention routine.

Lesson 1: Why does a stock discrepancy matter?

In short: A stock discrepancy tells you that the goods you have differ from the records. An unclosed discrepancy means wrong orders, selling out-of-stock products and incorrect costs.

If the discrepancy isn't closedResult
A product showing too much in the system can't be found on the shelfCancellation of unfulfillable orders, rating loss
A product showing too little in the system is closed to salesLost sales
Cost stays wrongProfit is calculated incorrectly
The same discrepancy repeats at every countLoss of trust

For a multichannel seller, discrepancies grow quickly when stock isn't managed from a single source; in NetKasam, stock is managed from a single source and drops as orders come in. Still, physical errors (damage, wrong shelf, miscounting) happen in the warehouse. For the general framework of inventory management, see the inventory management page. Sample business: an apparel and accessories seller with a single warehouse that sells both in-store and through e-commerce.

Lesson 2: What preparation is done before the count?

In short: There should be no stock movement during the count: process pending receipts and issues, and set the count cut-off time. If the records are complete, the discrepancy is real.

PreparationControl
Pending receiptsHave incoming goods been recorded?
Pending issuesHave shipped orders been invoiced?
Store salesHas the day been closed?
Cut-off timeCount start time recorded in writing
Count listProduct, shelf, system quantity

List movements after the cut-off time (for example, an order arriving during the count) separately; don't mix them into the count. If your barcode routine is established, counting is both faster and less error-prone; see the article how to set up a barcode system. Entering opening stock by estimate is the most common mistake during the switchover; doing the count correctly from day one reduces all later discrepancies.

Lesson 3: How do you prepare a discrepancy table?

In short: For each product, write the system quantity, the counted quantity and the discrepancy side by side. Focus only on products that show a discrepancy.

Example: 120 products were counted, and 18 products showed a discrepancy. Total system stock is 4,800 units, the count 4,704 units.

ProductSystemStock countDifference
Product 1200188−12
Product 2150141−9
Product 390104+14
Other 15 products4.3604.271−89
Total (18 products)4.8004.704−96

The three products in the table are examples; the "other 15 products" row sums the remaining discrepancies. Check that the total discrepancy is correct: −12 −9 +14 −89 = −96. Also write the discrepancy as a percentage: 96 ÷ 4,800 × 100 = 2.0%. This rate is the benchmark for comparison with the next count; if it is falling, your record-keeping is settling in.

Lesson 4: How do you trace a discrepancy with the stock movements report?

In short: Read the receipt, issue and sales history of the product with a discrepancy from the stock movements report. Comparing the movements with the counted quantity shows where the discrepancy arose.

ReportsWhat do you look at it for?
Inventory movement reportThe product's receipt, issue and sales history; the cause of the discrepancy
Branch and warehouse inventory statusWhich location the stock is in
Cost and turnover rateThe TL value of the discrepancy, the product's speed

When tracing back product by product, ask these questions in order: how many units have come in since the last receipt? How many units were sold? After which date did the system and the shelf diverge? If a receipt is missing from the movements (there is a delivery waybill but no record) or an issue is extra (the same order was deducted twice), that is where the discrepancy starts. In NetKasam, no movement record can be deleted; so the possibility that "a movement was deleted later" is ruled out, which shortens the investigation. For movement records and permissions, see the user and employee management page.

Lesson 5: What causes stock discrepancies?

In short: Most discrepancies come from four causes: late-processed receipts, unrecorded sales or issues, unrecorded shrinkage and damage, and unexplained loss.

ChartThe 4,800 units in the system came down to the 4,704 units counted, by cause
  1. System stock4,800 units
  2. Late-processed receipt30 units
  3. Unrecorded store sales−45 units
  4. Unrecorded shrinkage and damage−52 units
  5. Unexplained−29 units
  6. Count4,704 units

Prepared with sample values. Net discrepancy −96 units.

ReasonCountSolution
Late-processed receipt+30Record the receipt with its document
Unrecorded store sales−45Link the sale to an invoice, check the cash register record
Unrecorded shrinkage and damage−52Open a shrinkage record, write down the reason
Unexplained−29Investigate (Lesson 7)
ChartMovements making up the discrepancy: shrinkage is the largest item
  1. Unrecorded shrinkage and damage52 units
  2. Unrecorded store sales45 units
  3. Late-processed receipt30 units
  4. Unexplained29 units

Prepared with sample values. Gross movement 156 units; unexplained share 18.6% (29 ÷ 156).

FormulaFour formulas for stock discrepancies
  1. Stock discrepancy = Counted quantity − System quantity
  2. Discrepancy rate = |Stock discrepancy| ÷ System quantity × 100
  3. Discrepancy value = Stock discrepancy × Unit cost
  4. Unexplained share = Unexplained ÷ Gross movement × 100

Prepared with sample values.

While the net discrepancy is −96 units, the gross movement is 156 units, because plus and minus causes partly cancel each other out (+30 − 45 − 52 − 29 = −96). That is why looking only at the net discrepancy is misleading: the net discrepancy may look small while large errors in opposite directions lie underneath. If the average unit cost is ₺150, the net discrepancy is −96 × 150 = −₺14,400. For the cost calculation, see the article how to calculate inventory cost.

Lesson 6: How do you make an adjustment entry?

In short: Correct a discrepancy with a known cause using its document and an explanation. Investigate a discrepancy with an unknown cause before correcting it; don't quietly write it off.

DifferenceCorrectionDocument
Late-processed receipt (+30)Record the receiptDelivery waybill or purchase invoice
Unrecorded sales (−45)Process the sale, link the invoiceCash receipt, invoice
Unrecorded shrinkage (−52)Write a shrinkage recordDamage report
Unexplained (−29)Wait until the investigation is completeReview note

The person making the correction and the date should remain on record; in NetKasam, every transaction is recorded and cannot be deleted. Which screen stock adjustments are made on and how may vary by version; for the steps, see the NetKasam support page. For shrinkage and damage, keeping a short report (what happened, how many units, who identified it) is useful for both internal control and the accountant; ask your certified public accountant (mali müşavir) about the tax treatment of damaged goods.

When resolving store sales discrepancies, also check the cash register: an unrecorded sale often shows that the amount is in the till but the stock deduction wasn't made. For this, the end-of-day check in the article how to do a daily cash count and cash register close is a useful complement.

Recommended ReadingHow Do You Do a Stock Count?

Lesson 7: How do you manage an unexplained discrepancy?

In short: An unexplained discrepancy can be reduced but not eliminated. Set a threshold: if it is below the threshold, record it and monitor; if it is above, investigate.

Unexplained rateInterpretationAction
Less than 10% of gross movementNormal count deviationRecord it, monitor
%10–%25NoteRecount the affected products
More than 25%There is a problemProcess review, permission and access control

In the example, the unexplained share is 18.6%, which puts it in the caution zone. These rates are a sample framework for interpretation; set your own threshold based on the volume of your business. In the caution zone, the first step is recounting the affected products: often part of the discrepancy comes from counting errors (wrong shelf, wrong variant). The second step is looking at who processed those products' movements; this is possible because the user of every movement is recorded.

If the unexplained discrepancy repeats, review the process: who has access to the shelves, is there a two-person check during the count, where are damaged goods set aside? Narrowing permissions per user and keeping records undeletable makes it easier to find the cause of the discrepancy. For permissions, see the article how to set user permissions.

Takeaways from the exampleFour numbers from the sample count
  • −96 unitsnet stock discrepancy (2.0%)
  • −₺14,400net discrepancy value (96 × ₺150)
  • 156 unitsgross movement (+30, −45, −52, −29)
  • 18.6%unexplained share of the discrepancy

Lesson 8: How do you set up a routine that prevents discrepancies from recurring?

In short: Instead of one big count a year, do frequent partial counts of fast-moving and valuable products. Small discrepancies are resolved while they are still small.

When?What to do?Who?
WeeklyPartial count of 10 fast-moving productsWarehouse manager
MonthlyCount of valuable products, critical stock checkWarehouse and accounting
QuarterlyDiscrepancy rate and cause breakdown are reviewedManagement
YearlyFull count, closing all discrepanciesWhole team

A weekly partial count takes half an hour for ten products and catches the discrepancy in the week it arises. Write down the discrepancy rate at every count: 2.0% in the example. If the rate is falling, your process is settling in; if it is rising, look for the cause in the discrepancy types. Setting a critical stock level (a notification comes when stock drops to the limit) and regularly checking the stock movements report reveal discrepancies without waiting for count day. For interpreting dead stock and turnover, see the article how to calculate inventory turnover.

If you have more than one branch or warehouse, pull the discrepancy table by location; if you see the discrepancy piling up in one warehouse, the solution starts there too. If there are gaps in transfer records between warehouses, the discrepancy comes from transfers; for the method, see the article how to transfer stock between warehouses.

Recommended readingHow to Transfer Stock Between Warehouses?

What are the most common mistakes with stock discrepancies?

  1. Making movements during the count. The discrepancy doesn't reflect the real discrepancy.
  2. Looking only at the net discrepancy. Errors in opposite directions are hidden.
  3. Quietly writing off the discrepancy. The cause isn't found, and it repeats.
  4. Making corrections without documents. The trail is lost.
  5. Counting all products at the same frequency. Valuable products aren't checked enough.
  6. Not recording shrinkage and damage. Stock and cost stay wrong.
  7. Counting once a year. Discrepancies pile up.

How does NetKasam make tracking stock discrepancies easier?

  • Stock movements report. The product's receipt, issue and sales history is tracked and the cause of a count discrepancy is found (inventory management).
  • Stock from a single source. Stock drops as marketplace and e-commerce orders come in.
  • Status by branch and warehouse. Stock is seen separately for each location (branch and warehouse management).
  • Critical stock. A lower limit is set, and a notification comes when the product drops to the limit.
  • Cost and turnover. The TL value of the discrepancy and the product's speed are reported.
  • Undeletable activity log. Who did what can be seen retrospectively.
  • Free bookkeeping. Bookkeeping, including inventory tracking, is free; for the scope, see the pricing page.

Mini quiz: Test what you have learned

In short: Answer the 5 questions below, then compare with the answer key. 4 or 5 correct shows you have completed the training.

  1. If the system shows 2,000 units and the count 1,950 units, what are the stock discrepancy and the discrepancy rate?
  2. If the unit cost is ₺80, what is the value of this discrepancy?
  3. If the discrepancy causes are +20, −45 and −25, what are the net discrepancy and gross movement?
  4. If −25 of the causes above is unexplained, what is the unexplained share?
  5. Why should no stock movements be made during the count?

Answer key:

  1. 1,950 − 2,000 = −50 units; 50 ÷ 2,000 × 100 = 2.5%.
  2. −50 × 80 = −4.000 ₺.
  3. Net: 20 − 45 − 25 = −50; gross: 20 + 45 + 25 = 90 units.
  4. 25 ÷ 90 × 100 = %27,8.
  5. If a movement happens after the count cut-off, the system and the count measure different moments; the discrepancy doesn't reflect the real discrepancy.

Frequently Asked Questions About Stock Discrepancies

How do you find a stock discrepancy?

Subtract the system quantity from the counted quantity; then look at the product's stock movements report and search for the cause of the discrepancy in receipt, issue and shrinkage movements.

Where do I track inventory movements?

From the inventory movement and cost reports, you can see which product moved when and through which transaction.

How is the stock discrepancy rate calculated?

Divide the absolute value of the discrepancy by the system quantity and multiply by one hundred: |Discrepancy| ÷ System × 100.

When does an unexplained discrepancy become a problem?

If it repeats at every count or makes up a large share of gross movement, a process review is needed; your business sets the threshold.

Can I track multiple warehouses separately?

Yes. The inventory status of branches and warehouses can be viewed separately.

Can movement records be deleted?

No. Every movement record is kept in the system and cannot be deleted; the full movement log of users can be tracked.

How do I find out before stock runs out?

A critical stock level is set, and a notification comes when the product drops to that limit.

How often should you count stock?

Weekly or monthly partial counts for fast-moving and valuable products, and at least one full count of the whole warehouse a year, is a good start.

Conclusion: Count your ten fastest-moving products this week

You don't have to count the whole warehouse. This week, pick your ten fastest-moving products, count them and compare with the system. If a discrepancy appears, look at the product's history in the stock movements report, break the discrepancy down by cause and correct it with documents. The following week, count the same ten products again; if the discrepancy is shrinking, the process is working. Write down the discrepancy rate each time: as the rate turns into a number that falls over time, your confidence in your stock records grows too.

Bookkeeping Is Now Completely Free

Manage your bookkeeping and e-Invoice operations with NetKasam without paying a thing. Customer and supplier accounts, inventory, collections and more in one panel, completely free.

Start FreeInventory Tracking

Read similar articles

19 free tools

Commission, shipping, VAT and profit calculations in your browser, no sign-up needed.

All tools