Daily Stock Count Template: Track Inventory and Cut Losses

A mid-sized Saudi retail business loses between 1.5% and 3% of total annual sales to inventory discrepancies that only surface during the monthly or annual count. The percentage looks small on paper, but for a store selling 2 million SAR per year that is 30,000 to 60,000 SAR quietly vanishing every year between internal theft, sales errors, spoilage, and quantities received without being recorded. The cause is usually not bad intent but the absence of a simple tool: a daily stock count template that refreshes the balance at the end of every shift and exposes the gap before it compounds.

The daily count template is not a formality filled in at end of day and filed away. It is an operational tool that links actual item movement (purchases, sales, branch transfers, damage, samples, returns) to the book balance in the accounting system. The gap between the two balances, the available and the actual, is the single most important indicator of how healthy your operations are and how accurate your financial statements will be at period end.

In this practical guide we explain the daily stock count from scratch: the concept and its types, the difference between it and longer cycles, the components of the template, inventory valuation methods used in the Kingdom, how to treat variances accounting-wise, numerical examples for a restaurant and a retail store, common mistakes in manual application, Zakat, Tax and Customs Authority (ZATCA) inventory requirements, and how Qoyod turns all of this into an automated multi-branch cycle.

What is the daily stock count and why does it cut losses more than any other action?

The daily stock count is the process of physically counting inventory quantities available in the warehouse or branch at the end of the working day and comparing them to the balance that should be available based on that day’s book movement. The central idea: you shrink the time gap between an error happening and being discovered to twenty-four hours instead of thirty days.

A business that detects a shortage of five milk cartons four days after it happened can review the supplier invoice, the surveillance footage, the sales activity during the relevant shift, and identify the person or cause. The same business after thirty days can do nothing other than record the gap as a loss. The daily count does not prevent errors, but it converts them from a certain loss into a solvable problem.

The businesses that benefit most from a daily count share one feature: high turnover, thin margin, and many SKUs. This combination is found in restaurants (perishable ingredients, multiple shifts), pharmacies (high-value items with expiry dates), grocery retail (hundreds of SKUs with an average margin of 8%), fuel stations (fuel plus a convenience store), and spare parts warehouses (thousands of items with irregular movement).

The benefit is not limited to detecting loss. The daily count produces three additional outcomes a business cannot do without:

• Sharper purchasing decisions: by end of day you know which item is approaching its reorder point, so you avoid stockouts and reduce capital tied up in slow-moving items.
• Smart pricing: you know your live margin per item based on the cost of the latest receipt, so you adjust pricing quickly to keep up with market swings.
• Cleaner financial statements: the month ends with a small, easily reconciled variance instead of a large gap that distorts cost of goods sold and gross profit.

The difference between daily, weekly, monthly, and annual counts

Inventory counting is not a single procedure but four different cycles, each with its own purpose, paperwork, and execution style. The common mistake is to assume a business only needs one cycle, choosing the annual count to save time, and ending up with an information gap throughout the year.

The four cycles work together, not as substitutes. The daily count controls fast-moving items in each branch; the weekly reviews slow movers; the monthly reconciles actual to book for a clean month-end close; and the annual produces a comprehensive count of every SKU and warehouse to prepare financial statements. Any serious business runs all four, just with different scope and detail.

A small business may not be able to count 500 SKUs daily, so it falls back on cycle counting by ABC category: A items (20% of SKUs that represent 80% of value) are counted daily; B items (30% of SKUs representing 15% of value) are counted weekly; C items (50% of SKUs representing 5% of value) are counted monthly. This approach balances information accuracy with operating cost.

Inventory types: Perpetual and Periodic

Financial accounting recognizes two main approaches to organizing inventory records, and the difference between them shapes the nature of the daily count in your business.

1) Perpetual Inventory

The balance is updated after every transaction: every sales invoice drops the quantity instantly, every return adds it back, every transfer between branches is logged the same moment. The book balance is available at any instant. Cost of goods sold (COGS) is calculated automatically on every sale. This approach is the default in modern POS systems and in Qoyod.

When does it fit? Any business with point-of-sale terminals connected to an accounting system, or one running an integrated cloud platform. The daily count here becomes a verification of the system’s accuracy, not a rebuild of the balance from zero.

2) Periodic Inventory

The balance is updated only at the end of the period (daily, weekly, monthly). During the period only purchases are logged to a temporary inventory account, and at period end a physical count is done and cost of sales is calculated by the formula: opening inventory + purchases − closing inventory = cost of goods sold.

When does it fit? Businesses with very many low-value items where tracking every unit is impractical (stationery shops, bulk construction materials). Or businesses transitioning from paper records to digital.

In the Saudi context, the dominant direction since e-invoicing (ZATCA) rolled out is perpetual inventory, because every sales invoice and every purchase invoice is logged in real time to an approved electronic system. Paper-invoice businesses are shrinking fast.

Components of the daily stock count template: what should it actually contain?

The ideal template is not a long sheet with forty columns. The ideal template is a short, focused sheet that fills out in under thirty minutes at end of shift and gives an instant snapshot of inventory health. The essential columns are nine, and any extra column must justify its place.

The nine essential columns

• Item code (SKU): a unique code per item, kept consistent across the accounting system, the POS, and the warehouse.
• Item description: the commercial name as employees know it, not the formal name on the invoice.
• Unit of measure: piece, kilogram, liter, pack, carton. Failing to standardize the unit is the number one cause of count variances.
• Opening balance: the quantity at the start of the day (carried over automatically from the previous day’s closing).
• Inbound during the day: purchase invoices, transfers received from other branches, customer returns.
• Outbound during the day: sales, transfers out to other branches, damage, samples, internal consumption.
• Available balance (book): opening + inbound − outbound. This is what should be in the warehouse.
• Actual balance (counted): what the employee actually counts in the warehouse or on the shelf.
• Variance: actual balance − available balance. Negative means a shortage, positive an overage, zero a match.

Useful additional columns appear in the advanced template: unit value based on latest cost, variance value in SAR, variance percentage relative to available balance, a notes field (reason for shortage or overage), and signatures from the counting employee and the approving manager.

The single-field rule for accountability

Every row in the template must end with a responsible party field. Who counted this item? Who signed off on the variance? Without this field, the template becomes a document with no legal or accounting value at audit.

Inventory valuation methods: FIFO, LIFO, and Weighted Average

When you record the daily outbound in the template, the central question is: at what cost are we releasing the quantity? The same SKU may have entered through multiple purchases at different prices, so which price do we use in the cost of sales formula? IFRS standards adopted in the Kingdom allow three main methods, and each produces a different number for cost of sales and gross profit.

Numerical example: three methods, three results

Item 16-liter cooking oil, inventory moved in January as follows:

• January 1: opening balance 100 cans at 80 SAR per can.
• January 10: purchase of 200 cans at 85 SAR.
• January 20: purchase of 150 cans at 90 SAR.
• Total sales for the month: 300 cans.

Under FIFO: the 300 cans are released at a cost of (100 × 80) + (200 × 85) = 8,000 + 17,000 = 25,000 SAR. Remaining balance 150 cans at 90 = 13,500 SAR.

Under Weighted Average: average cost = (100×80 + 200×85 + 150×90) ÷ 450 = (8,000 + 17,000 + 13,500) ÷ 450 = 38,500 ÷ 450 ≈ 85.56 SAR per can. Cost of sales = 300 × 85.56 = 25,667 SAR. Remaining balance 150 × 85.56 = 12,833 SAR.

The gap between the two methods is 667 SAR on a single SKU in a single month. In a store with 500 SKUs the cumulative impact runs into the tens of thousands on the financial statements.

Choosing the method in Saudi Arabia

The Capital Market Authority (CMA) and the Zakat, Tax and Customs Authority (ZATCA) both follow IFRS, which permits FIFO and Weighted Average only. LIFO is not allowed for formal financial reporting. The practical recommendation:

• Restaurants, pharmacies, and food items: FIFO (matches the actual physical flow of items).
• General retail, spare parts, and homogeneous items: Weighted Average (simplifies calculations and dampens price swings).

What matters: the chosen method must be applied consistently and not switched between periods without a justification disclosed in the notes to the financial statements.

How are inventory variances treated in accounting?

The gap between actual and book balances does not stay open. It must be cleared through a journal entry that reflects the nature of the variance, and that is where separating the four types of variances starts to matter.

1) Normal Shrinkage

Every sector has an accepted natural loss rate: 1 to 2% in grocery retail, 3 to 5% in fruit and vegetables, 0.5 to 1% in spare parts. This shrinkage is booked as an expense within cost of goods sold or to a normal inventory loss account inside operating expenses. The entry:

Dr. Cost of sales (or normal loss)  ×××
Cr. Inventory  ×××

2) Abnormal Loss

If the shortage exceeds the normal range, it is treated as an abnormal loss and booked to a separate account inside other expenses, with mandatory documentation of the cause (theft, accident, negligence). The entry is the same, but charged to an abnormal inventory loss account.

3) Count overage

An actual quantity above book may mean an earlier recording error, an unbooked purchase invoice, or an unrecorded return. It is cleared with a reverse entry:

Dr. Inventory  ×××
Cr. Inventory adjustment (or purchase invoice payable)  ×××

4) Damage and expiry

Expired or damaged goods are removed with a separate entry, and a signed destruction record is kept. This is especially important for pharmacies and food items to preserve the right to deduct input tax in the ZATCA return.

Dr. Damage and loss expense  ×××
Cr. Inventory  ×××

A daily count keeps these entries small and regular instead of one large reconciliation at month end that is hard to justify or tie back to its real causes.

Practical example 1: a fast-food restaurant

A restaurant in Riyadh runs two shifts and sells burgers, shawarma, and side dishes. Average daily sales are 8,000 SAR, and the kitchen carries 45 SKUs across meat, vegetables, sauces, and packaging. It adopted a simplified daily count on just ten key items: ground beef, chicken breast, bread, potatoes, sauce, cheese, tomato, lettuce, oil, and beverages.

On a Thursday, the template showed the following for the most important SKU (ground beef):

• Opening balance: 18 kg.
• Inbound (morning supplier invoice): 12 kg.
• Outbound per sales (180 burgers × 150 g): 27 kg.
• Available balance by book: 18 + 12 − 27 = 3 kg.
• Actual counted balance: 2.3 kg.
• Variance: −0.7 kg at a cost of 42 SAR per kg = −29.4 SAR.

Over a full month, the variance accumulated to −22 kg, worth 924 SAR. Investigation revealed that the meat grinder wastes 4% of every batch (acceptable normal loss), and the rest was due to staff family meals not being recorded. The fix: add an internal consumption column to the template, and convert staff meals into a formal expense line. The monthly variance dropped to 180 SAR.

Before the daily count, the restaurant only discovered this gap at the monthly count and recorded it as a direct cost with no understanding of the cause. After implementation, the loss shifted from 924 SAR of mystery to 180 SAR of explained activity.

Practical example 2: a grocery retail store

A neighborhood supermarket of 240 square meters in Jeddah, 1,400 SKUs, average daily sales of 12,000 SAR. Running a daily count across 1,400 SKUs is impractical, so the owner adopted ABC categorization: 80 high-value SKUs (meat, imported cheese, baby products, premium goods) counted daily; 320 SKUs weekly; the rest monthly.

In the first week, the daily count of the 80 SKUs uncovered variances of 540 SAR. The breakdown:

• 3 missing cans of infant formula (220 SAR): surveillance footage caught a theft during the evening shift; display policy was changed and the SKU moved behind the cashier.
• 14 extra bottles of water (28 SAR): a purchase invoice had been recorded at a lower quantity than received; the data entry error was corrected.
• 2 kg meat shortage (164 SAR): unrecorded damage; cleared with a destruction record.
• 3 missing chocolate bars (128 SAR): logged as normal shrinkage for the open display section.

540 SAR a week equals 28,000 SAR a year. Before the daily count, this amount disappeared in full. After implementation, part of it was recovered through display changes and immediate handling, and the rest was booked correctly into cost of sales instead of appearing as a surprise at year-end close.

Common mistakes in manual counting and how to avoid them

A daily count done with a paper template or an Excel sheet disconnected from the accounting system runs into recurring mistakes that turn it from a control tool into a source of confusion. The most prominent:

1) Inconsistent units of measure

An item is purchased by the carton and sold by the pack and the piece. A manual template easily mixes units, producing a phantom variance from conversion rather than a real shortage. Fix: define a base unit per SKU and a conversion factor to sub-units inside the system, and block free-text unit entry on the form.

2) Counting the same item twice

When an item lives in multiple places (display shelf, back warehouse, adjacent fridge), the count hits one location and skips another, or counts the same stock twice. Fix: divide the template into zones (rack or zone) before splitting it by item.

3) Delayed data entry

A daily template filled retroactively three days later loses all its value. The employee’s memory of the day’s activity is limited, so estimated figures replace real ones. Fix: lock in fifteen minutes before shift close as the mandatory window to complete the template.

4) Ignoring inter-branch transfers

Transferring five packs from the main branch to a satellite shows as outbound on one and inbound on the other. A manual template forgets this mirror, so a shortage appears in one branch and an equal overage in another, both counted as fake loss and gain. Fix: tie branch templates to a unified transfer reference and reconcile between branches daily.

5) Mixing variances without recording the cause

A template with a “variance” column but no “cause” column turns count data into dead numbers. Every variance with no probable cause has to be investigated. Fix: a dropdown of preset reasons (possible theft, damage, recording error, undocumented transfer, normal shrinkage, internal consumption).

6) Counting without segregation of duties

The employee who sells cannot be the same one who counts. This is the most basic internal control principle, and it is violated daily in small businesses. Fix: hand the count to someone who does not handle the SKU’s daily movement, or adopt a two-step process (employee counts, manager verifies).

7) Skipping the destruction record

Damaged stock thrown out without documentation is treated for tax as an unbilled sale, and may expose the business to ZATCA issues. Every destruction must be accompanied by a written record stating the item, quantity, cause, date of destruction, and two signatures.

Zakat, Tax and Customs Authority (ZATCA) requirements for inventory

Saudi Arabia rolled out e-invoicing in two phases starting December 2021 (generation) and January 2023 (integration and reporting). This framework imposes a set of inventory-related obligations on VAT-registered businesses:

1) Inventory ledger records

The Executive Regulation of the VAT system (Article 66) requires the taxpayer to keep inventory records for no less than six years. These include: inbound ledger, outbound ledger, physical count reports, and destruction records. All of them must be presentable electronically when ZATCA requests them.

2) Linking the e-invoice to inventory movement

Every electronic sales invoice issued through the ZATCA system must be matched by an actual balance reduction in the inventory ledger for the same quantity and SKU. A sales invoice with no corresponding inventory movement (or the other way around) flags a potential discrepancy in the Authority’s system and may open the door to a tax audit.

3) Treating damage and write-offs

Items destroyed or declared expired require a formal record kept in the tax file. The input tax on these items remains deductible in the VAT return provided a documented destruction record exists. Without the record, they are treated as unbilled sales and the business is asked to settle the full tax.

4) Mandatory annual count with report

Preparing the annual financial statements attached to the zakat and income tax return requires a full physical count of inventory at fiscal year-end, signed by the manager and a certified public accountant for businesses above the threshold for mandatory external audit.

5) Reconciling the ZATCA balance with the business system

From phase two of e-invoicing onward, every sales invoice is reported in real time (tax invoices) or within 24 hours (simplified) to the Authority’s platform. Any gap between your internal inventory balance and what ZATCA infers from your invoices generates a discrepancy flag on the business file. The daily count solves this at the root by ensuring the internal and external systems tell the same story.

How does Qoyod help you manage inventory and multi-branch counts?

The gap between a manual daily count and a digital one is not a gap in the tool, it is a gap in the nature of the information available for decision making. Qoyod, as a cloud accounting and inventory management system approved by the Zakat, Tax and Customs Authority, turns the counting cycle from a manual procedure into a live data flow linking point-of-sale, warehouses, branches, and invoices in a single system.

1) Real-time perpetual inventory across every branch

The inventory management module in Qoyod runs on perpetual inventory: every sale at the POS, every purchase invoice, every transfer between branches, every damage entry, updates the balance in real time. At any second you can open the available balance report for any SKU in any branch.

2) Daily count report in one click

The “daily count” report in Qoyod automatically generates a file with the nine essential columns for all SKUs or a defined subset (ABC class, branch, warehouse). The employee prints the report at shift end, counts, enters the actual balance, and the variance is calculated automatically and translated into a proposed adjustment entry.

3) Multi-warehouse and multi-branch management

A business with 10 branches cannot run a manual count. Qoyod supports multiple warehouses and branches with documented inter-branch transfer logic, independent balances per warehouse, and consolidated reports across the entire business.

4) POS system integration

Qoyod is connected to leading POS systems in the Saudi market. Every sale at the POS drops the inventory balance instantly, eliminating duplicate manual entry between the two systems.

5) Automated variance journal entries

When you adopt the daily count template, Qoyod produces an automatic adjustment entry (debit and credit) based on the type of variance you set (normal loss, damage, theft, recording error). See our complete inventory management guide for the details on each entry.

6) Built-in e-invoicing

Qoyod is wired directly to the ZATCA e-invoicing platform, so every sales invoice is reported to the Authority in real time and a matching inventory movement is recorded automatically, with no manual step.

7) Smart reports for decisions

Alongside inventory valuation reports using FIFO and Weighted Average, Qoyod generates inventory turnover reports, slow-moving SKU lists, automatic reorder points, and the value of dead stock, numbers that are impossible to extract from a manual count template.

8) Annual report ready for ZATCA

At fiscal year-end, Qoyod produces an annual inventory report aligned with the requirements of the zakat and income tax return, with quantities and values detailed and ready for review by a certified public accountant.

The bottom line: from a count sheet to a full operating system

The daily stock count template is not a document filled to please the manager or to close the month on paper. It is the first tool that turns inventory from a dark cost in the income statement into a managed asset with measurable numbers. The business that runs it with discipline pulls ahead of its competitors on three fronts: lower losses, faster purchasing decisions, and accurate financial statements.

Moving from paper to digital counts is no longer a technical luxury, it is a requirement set by e-invoicing and the integrated ZATCA framework. A ready Excel template handles the transitional stage, but the sustainable solution is an accounting system that connects POS, warehouses, branches, and tax returns in one flow. That is exactly what Qoyod delivers.