EN
Inventory and Products

How to Do a Stock Count? A Guide to Count Differences, Inventory Accuracy, Cycle Counting and Accounting Entries

How is an inventory count done? A step-by-step counting routine, calculating count differences, inventory accuracy rate, a cycle count plan, accounting entries in accounts 197 and 397, and common mistakes.

Contents 11 sections
  1. What is an inventory count and why is it done?
  2. What are the types of inventory counts?
  3. How is an inventory count done step by step?
  4. How is a count difference calculated?
  5. What is the inventory accuracy rate, and what should it be?
  6. How do you prepare a cycle count plan?
  7. What causes count differences most often?
  8. How are count differences recorded in the accounts?
  9. What are the most common mistakes in inventory counts?
  10. How are inventory records kept with NetKasam?
  11. Frequently Asked Questions About Inventory Counts

A product that shows 120 units in the system turning out to be 118 units on the shelf looks like a small difference. But when this difference repeats across hundreds of products, you sell products you do not have in stock, you have to cancel orders, your store rating drops and, at the end of the period, your profit looks higher on paper than it really is. An inventory count is the work of comparing recorded inventory with the actual inventory in the warehouse to find and correct differences. The answer to how an inventory count is done is not just "counting the products": preparing for the count, stopping movements during the count, finding the reasons for differences and reflecting the result correctly in the accounts are all part of the same job.

In this guide we explain, with examples, the types of counts, a step-by-step counting routine, how the count difference and inventory accuracy rate are calculated, the cycle count plan, the most common causes of differences and the accounting entries for count differences. At the end you will find common mistakes, frequently asked questions and how inventory records are kept in NetKasam.

What is an inventory count and why is it done?

In short: An inventory count is counting the products actually present in the warehouse and store one by one and comparing them with the inventory records in the system. The goal is to bring the records in line with reality, find the reasons for differences and calculate closing inventory value correctly.

Inventory records change every day with dozens of movements: purchases, sales, returns, warehouse transfers, shrinkage. When one of these movements is missed or entered incorrectly, the records drift from reality and the difference does not fix itself. A count brings these accumulated errors to light. It has four results:

  • Sellable inventory looks right. The stock quantities sent to marketplaces and your e-commerce site reflect reality; products you do not have are not sold.
  • Profit is calculated correctly. Closing inventory value directly determines the cost of goods sold and therefore profit.
  • Loss and shrinkage become visible. Problems such as breakage, loss or wrong shipments show up by product and by warehouse.
  • The legal obligation is met. Existing inventory is determined at the end of the period and the result is reflected in the books.

For the general framework of inventory management, see our article what you need to know about inventory management; for the benefits of real-time tracking, see our article real-time inventory and warehouse tracking.

What are the types of inventory counts?

In short: There are three basic types: the full (year-end) count, in which all products are counted at once; the cycle count, in which products are counted piece by piece on a set schedule; and the spot count, done on a suspicious product or shelf.

Count typeWhen is it done?AdvantageDisadvantage
Full (year-end) countOnce a year, at the end of the periodAll inventory is determined at once, and closing value is finalizedSales and shipping stop, and differences have built up for a year
Cycle countEvery day or week, on predetermined product groupsOperations do not stop, and differences are caught earlyRequires a regular schedule and discipline
Spot countWhen there is a doubt: a canceled order, a missing shipment, a complaintThe problem is solved immediatelyNot sufficient on its own
Handover countWhen the warehouse manager or the warehouse changesResponsibility is handed over with a clean figureThere is a risk of additional differences during the move

For most e-commerce businesses, the best routine is to keep the year-end full count and do cycle counts throughout the year. That way the year-end count becomes a check, not a surprise.

How is an inventory count done step by step?

In short: The count date and cutoff time are set, pending receipts and dispatches are closed, the warehouse is divided into zones, products are counted without seeing the recorded quantity, items with differences are recounted by a second person, the reasons for differences are investigated and the records are corrected.

Step by stepSix steps to an error-free inventory count
  1. 01
    Set the cutoff timeEnter all purchases, sales, returns and transfers before the count into the system.
  2. 02
    Stop movementsHold shipping and goods receipt in the area being counted until the count is finished.
  3. 03
    Assign zones and teamsDivide the warehouse into zones by shelf or aisle, and assign two people to each zone.
  4. 04
    Do a blind countDo not show the recorded quantity on the count sheet; the counter writes down only what they see.
  5. 05
    Recount the differencesHave a different person count items outside tolerance a second time.
  6. 06
    Find the cause, correct the recordInvestigate whether there is an unprocessed document, a variant mix-up or shrinkage, and update the record.

Any orders that come in during the count are held in a separate area and processed after the count is finished.

The most critical step is the first. An invoice issued before the count but not deducted from inventory, or a return accepted but not entered into the system, appears as a "difference" in the count. Closing pending documents before the count can eliminate half of the differences before counting even starts. To process the returns flow correctly, see our guide how to issue a return invoice.

For products with variants, the count should be done by variant code (size, color), not by product code. "T-shirt: 215 units" may be right, but if size S has a surplus and size M a shortage, you will sell the wrong size on the marketplace. Our article how to manage products with variants on marketplaces helps with this.

How is a count difference calculated?

In short: The count difference is found by subtracting the recorded quantity from the counted quantity. A negative result means there is a shortage; a positive result means there is a surplus. The difference amount is calculated by multiplying the difference quantity by the product's unit cost.

FormulaFive formulas used in inventory counts
  1. Count difference (units) = Counted quantity − Recorded quantity
  2. Difference amount = Count difference × Unit cost
  3. Net difference amount = Value of surpluses − Value of shortages
  4. Value-based difference rate = Net difference amount ÷ Recorded inventory value × 100
  5. Inventory accuracy rate = Number of items with no difference (within tolerance) ÷ Number of items counted × 100

The unit cost used is not the selling price but the purchase cost calculated with the costing method the business uses.

Let's calculate with an example. Suppose five items with differences and one item with no difference among the products counted in a warehouse are as follows (the figures are sample values chosen only to illustrate the method):

ProductRecordedCountedDifferenceUnit costDifference amount
T-shirt black S120118−2150 ₺−300 ₺
T-shirt black M9597+2150 ₺+300 ₺
Ceramic mug240236−460 ₺−240 ₺
Wireless headphones3533−2900 ₺−1.800 ₺
Notebook400410+1025 ₺+250 ₺
Portable charger50500500 ₺0 ₺

The recorded value of these six products is ₺113,150. Total shortages are ₺2,340, total surpluses are ₺550, and the net difference is −₺1,790. The move from recorded value to counted value is as follows:

Count resultFrom ₺113,150 recorded inventory to ₺111,360 counted inventory
  1. Recorded inventory value₺113,150
  2. T-shirt black S (−2 units)−₺300
  3. Ceramic mug (−4 units)−₺240
  4. Wireless headphones (−2 units)−₺1,800
  5. T-shirt black M (+2 units)₺300
  6. Notebook (+10 units)₺250
  7. Counted inventory value₺111,360

Prepared with sample values; amounts are calculated at purchase cost, excluding VAT.

When reading the table, look at the item differences, not the net difference. The T-shirts are 2 short in size S and 2 over in size M; this is most likely a variant mix-up, meaning the wrong size was shipped or put on the wrong shelf. The net effect is zero, but a customer may have received the wrong product. The 10 extra notebooks are usually an unprocessed return or goods receipt. The real loss in value is in a single item, the high-value headphones: 2 units, 77% of total shortages. That is why high-value products are counted more often.

Recommended ReadingHow Do You Calculate Inventory Cost?

What is the inventory accuracy rate, and what should it be?

In short: The inventory accuracy rate shows how many of the counted items match the records (or fall within the accepted tolerance). In the example, 1,104 of 1,200 items have no difference, so the rate is 92%; businesses that do regular cycle counts usually aim for above 95%.

The value-based difference rate and the inventory accuracy rate measure different things. For the six products in the example, the net difference is only 1.6% (1,790 ÷ 113,150), so in value terms it looks small. But the accuracy rate shows how many items are wrong, and that is what really matters on the sales side: every wrong item is a product showing the wrong stock on the marketplace.

Takeaways from the exampleOne count, four key numbers
  • 92%inventory accuracy rate (1,104 of 1,200 items with no difference)
  • −₺1,790net count difference across six products
  • 77%share of a single high-value product in total shortages
  • 18 itemsto count per working day in the cycle count

Setting a tolerance also matters. Small differences are normal for screws, buttons or products sold by weight; these products are given a tolerance of, for example, 1–2%. For high-value products sold by unit, the tolerance is zero: if one pair of headphones is missing, it is missing.

How do you prepare a cycle count plan?

In short: Products are divided into classes A, B and C by value; high-value A products are counted often and C products rarely. The number of items to count each day is found by dividing the total annual number of counts by the number of working days.

The logic of a cycle count is simple: instead of counting the whole warehouse on one day a year, you count a small part of it every day. A product's value determines how often it is counted. For the method of classifying products, see our article how to do an ABC analysis.

Count scheduleHow many times a year a product is counted, by class
  1. Class A (120 items, every month)12 times
  2. Class B (360 items, every quarter)4 times
  3. Class C (720 items, every six months)2 times

Sample warehouse with 1,200 items. Each class adds up to 1,440 counts a year; a total of 4,320 counts divided over 240 working days is 18 items a day.

In the example, class A products are only 10% of the items but are counted every month. Class C products are 60% of the items but are counted only twice a year. In the end, the warehouse team's daily workload is 18 items; this is a half-hour job at the start or end of the shift and does not stop shipping.

Also add these items to the cycle count: products whose stock drops to zero or goes negative, products in canceled orders and products that had returns in the past month. These are where differences show up most often. To time replenishment correctly for products whose stock level is approaching zero, see the guide how to calculate safety stock.

What causes count differences most often?

In short: Most differences come not from theft or loss but from recording errors: unprocessed returns and goods receipts, the wrong variant being shipped or put on the wrong shelf, unrecorded shrinkage and errors in the count itself.

Suppose that in a sample year-end count, the total difference of ₺48,000 breaks down by cause as follows:

CausesBreakdown of count differences by cause
  • Unprocessed document (return, goods receipt, transfer)₺16,80035%
  • Variant or product mix-up₺12,00025%
  • Unrecorded shrinkage and breakage₺9,60020%
  • Loss and theft₺7,20015%
  • Counting error₺2,4005%

Prepared with sample values; the breakdown varies by business and sector.

The message of this breakdown is that reducing count differences is usually a matter of process, not security cameras. Each cause has a solution:

ReasonHow do you spot it?Prevention
Unprocessed documentThe difference equals the quantity of a return or goods receipt on a specific dateGoods receipts and returns are entered into the system before the product is shelved
Variant mix-upIn the same product, one variant is short and another is over by the same quantityA separate barcode for each variant, scanning barcodes during picking
Unrecorded shrinkageConstant small shortages in fragile and perishable productsShrinkage and damaged product write-offs are recorded the same day
Loss and theftUnexplained shortages in small, high-value productsLocked area, frequent cycle counts, restricted permissions
Counting errorThe difference disappears on the second countBlind count, two-person count, barcode scanner

Businesses that sell on marketplaces have one more cause: an order being deducted in one channel but not in another. For how stock is kept in sync across channels, see our article how to do marketplace stock synchronization.

How are count differences recorded in the accounts?

In short: Shortages whose cause cannot be determined right away are recorded in account 197 Count and Receipt Shortages, and surpluses in account 397 Count and Receipt Surpluses. The cause is investigated; if it is not found by the end of the period, shortages are transferred to an expense account and surpluses to an income account.

In the Turkish Uniform Chart of Accounts, count differences are tracked in temporary accounts. When there is a shortage in merchandise inventory, the inventory account is reduced and the difference is recorded in account 197; when there is a surplus, the inventory account is increased and the difference is recorded in account 397. For the count in the example, the entries are as follows:

SituationDebitCreditAmount
Recording shortages197 Count and Receipt Shortages153 Merchandise2.340 ₺
Recording surpluses153 Merchandise397 Count and Receipt Surpluses550 ₺
Closing a shortage whose cause was not found689 Other Extraordinary Expenses and Losses197 Count and Receipt ShortagesRemaining amount
Closing a surplus whose cause was not found397 Count and Receipt Surpluses679 Other Extraordinary Income and GainsRemaining amount

Differences whose cause is found are corrected directly with the relevant entry. In the example, the shortage in size S and the surplus in size M of the T-shirts are a variant mix-up; the two amounts offset each other. If the surplus of notebooks is an unprocessed return, the missing return entry is made and the difference comes out of account 397.

There are two issues you need to review with your certified public accountant (mali müşavir). First, in cases of loss such as goods going missing or being stolen, the VAT previously deducted on those goods may need to be adjusted. Second, normal shrinkage and undocumented loss are treated differently for tax purposes; it is important to keep records showing that shrinkage is in line with the sector average. For the method used to determine the period-end value of inventory, see the glossary page what are the inventory valuation methods; for what a digital inventory record is, see the page what is e-inventory.

What are the most common mistakes in inventory counts?

In short: The most common mistakes are counting while there is movement, counting while seeing the recorded quantity, not recounting items with differences, counting the main product instead of the variant, and recording a difference without investigating its cause.

  1. Counting while shipping continues. A box that goes out during the count shows up as short or over in both the count and the records; no difference can be trusted.
  2. Starting without closing pending documents. Unprocessed returns, goods receipts and transfers create false differences in the count.
  3. Having people count while showing them the recorded quantity. When the counter sees the expected number, they do not "find" the difference; that is why a blind count is done.
  4. Counting the main product instead of the variant. The total comes out right, but you cannot see which size or color is short.
  5. Not counting items with differences a second time. A counting error is mistaken for a real difference and recorded, and the next count shows a difference in the opposite direction.
  6. Correcting a difference without looking for its cause. The record is balanced, but the same process error keeps producing new differences every month.
  7. Counting only once a year. A difference that builds up over a year both grows and can no longer be traced to a cause; that is why cycle counts are necessary.

How are inventory records kept with NetKasam?

An easy count depends on keeping inventory records properly throughout the year. In NetKasam, inventory, sales and invoices are in the same system, so the problem of pending documents before a count is minimized:

  • Inventory by variant and warehouse. With inventory management you can create unlimited variants and track the stock of each variant separately; the detailed inventory movements report shows which document a product came in and went out with. This report is where you turn when looking for the cause of a count difference.
  • Multiple warehouses and branches. With branch and warehouse management you can create as many warehouses as you like, transfer stock between warehouses, report on each warehouse separately and define separate users and permissions for each warehouse.
  • Barcode sales and critical stock. On the in-store POS screen, sales are made with the product, variant or case barcode; when a product's stock drops to the critical stock level you set, the system warns you.
  • All channels from one inventory. With marketplace integration, orders are collected on a single screen and stock is updated across all channels from one center; stock you correct with a count is reflected in every channel.
  • Bookkeeping is free. e-Invoice, e-Archive invoice, customer and supplier accounts, inventory, cash, bank and expense tracking are always free; details of the integration plans are on the pricing page.

Frequently Asked Questions About Inventory Counts

How is an inventory count done?

Before the count, all documents are entered into the system, movement in the area being counted is stopped, products are counted without seeing the recorded quantity, items with differences are counted a second time, the reasons for differences are investigated and the records are corrected.

How often should inventory be counted?

Legally, inventory is determined at the end of the period. In addition, a cycle count in which high-value products are counted every month, mid-value products every quarter and low-value products every six months catches differences before they build up.

How is a count difference calculated?

Count difference = Counted quantity − Recorded quantity. A negative result means a shortage, a positive result means a surplus. The difference amount is found by multiplying the difference quantity by the unit cost.

What is a blind count?

It is a method in which the person counting writes down only what they count, without seeing the quantity in the system. Not knowing the expected number prevents the counter from overlooking a difference or "correcting" it.

What is the inventory accuracy rate?

It is the share of counted items that match the records (or fall within tolerance). If 1,104 of 1,200 items have no difference, the rate is 92%; businesses that do regular cycle counts usually aim for above 95%.

Which account is an inventory shortage recorded in?

Shortages whose cause cannot be determined right away are tracked in account 197 Count and Receipt Shortages, and surpluses in account 397 Count and Receipt Surpluses. Shortages whose cause is still not found by the end of the period are transferred to an expense account, and surpluses to an income account.

What happens to orders that come in during the count?

Shipment of products in the area being counted is held until the count is finished. In a cycle count only the shelf being counted is affected, so shipping usually does not stop; the count is done before the day's shipping starts or after it ends.

How are products with variants counted?

Each variant (size, color) is counted as a separate item with its own barcode. Even if the total for the main product is correct, there may be shortages and surpluses between variants; this usually indicates that the wrong product was shipped.

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