Inventory Variance / Stock-Take Discrepancy Report Template

In any warehouse or point of sale across the Saudi market, a silent gap exists between what shows up on the accounting system screen and what is actually sitting on the shelves. This gap is not visible at a glance, and it does not appear directly on the income statement, but it eats into the profit margin month after month. When the accountant closes the financial period and compares the book inventory balance to the physical count, numbers emerge that no one can fully explain: 1,250 units on the system against 1,187 units in reality, or an entire batch of 200 items that vanished without a single recorded sale.

The real problem is not the existence of discrepancies. Discrepancies are normal in every operation. The problem is the absence of a structured report that surfaces these discrepancies on a regular cycle, classifies their causes, values them in Saudi Riyals, and forces a documented accounting adjustment. Without this report, discrepancies pile up inside the inventory line on the balance sheet at inflated figures that do not reflect reality, and they flow directly into the cost of goods sold and into the net profit subject to Zakat and VAT filings with the Zakat, Tax and Customs Authority (ZATCA).

More critically, businesses that have entered Phase 2 of e-invoicing are now bound by a higher level of accounting linkage between purchase invoices, warehouse movements, and sales movements. Any disturbance in the inventory balance exposes the business to a tax review that is hard to defend without signed adjustment documents. This report solves the problem at its root: it compares, classifies, values, and documents.

What the Inventory Variance Report Is and What It Actually Reveals

An inventory variance report is an operational accounting document that compares two quantities for each item in the warehouse or point of sale: the book quantity recorded on the accounting system at a specific moment, and the physical quantity produced by manual or electronic counting on site. The difference between the two numbers, whether positive or negative, is what is known as variance, and it is valued in Saudi Riyals according to the costing policy adopted by the business.

This report is not just a numerical statement. It is a full governance tool. It uncovers leak points across the supply chain, identifies the items most exposed to loss, measures warehouse team efficiency, and provides an auditable trail for internal and external auditors. For businesses operating multiple branches across Riyadh, Jeddah, and Dammam, this report becomes the foundation for comparing branch performance and assigning responsibility fairly.

The Difference Between a Variance Report and a Regular Stock Count

A regular stock count only shows the physical quantities, meaning what was counted in the warehouse at the moment of the count. A variance report adds an analytical dimension: it automatically pulls the book quantity from the accounting system, calculates the difference, values it in Riyals, and classifies the cause. The difference between the two is the difference between a routine operational task and a real management decision tool.

When to Issue the Report

• At the end of every month: for high-turnover businesses such as restaurants, retail outlets, and pharmacies.
• Every quarter: for wholesale warehouses and industrial businesses with large item counts.
• Before preparing annual financial statements: no financial statement should be finalized without settling year-end inventory variances.
• Before any quarterly or annual tax filing: to ensure the cost of goods sold disclosed to ZATCA is built on a real inventory balance.
• When changing the warehouse keeper: handover and acceptance are not complete without a variance report signed by both parties.

The Management Value the Report Delivers

In the short term, the report protects the business from direct financial losses by surfacing theft and damage early. In the medium term, it builds a historical database that helps set a realistic tolerance threshold for each item and each sector. In the long term, this report becomes an input for negotiating with insurance companies and a supporting document in any legal dispute with an employee or supplier.

The Difference Between Physical and Book Inventory and Why Variance Happens

Book inventory is the accounting balance calculated mathematically inside the accounting system: opening balance plus purchases minus sales minus outbound returns plus inbound returns. This balance is theoretically accurate, but it depends entirely on input accuracy and the timing of recorded movements. Physical inventory, on the other hand, is the number counted by eye or by scanner on the shelves, reflecting the material reality of the business at a specific moment.

The variance between the two numbers is not an error in itself. It is a natural phenomenon in any human-driven operation. The real mistake is ignoring this variance or allowing it to accumulate without accounting adjustment. A mid-sized retail business in Riyadh that handles thousands of movements per month will normally see a variance of 1% to 2% of inventory value, but it needs to be tracked, explained, and adjusted in every cycle.

Main Causes of Variance

• Delayed recording of purchase invoices: goods reached the warehouse but the invoice has not yet been entered, so the physical count appears higher than the book count.
• Delayed recording of sales: point-of-sale transactions that were not posted to the accounting system due to connectivity outages or sync delays.
• Unit of measure errors: recording an item by carton instead of unit, or the reverse, producing a large numerical gap.
• Inter-branch transfers without documentation: goods moved from one branch to another without issuing an internal transfer note in the system.
• Internal or external theft: the most sensitive cause, requiring a separate set of procedures.
• Damage, breakage, and expiry: especially common in pharmacies, restaurants, and food industries.

When Variance Becomes a Serious Warning Sign

Variance becomes a real alarm when it repeats in the same items, concentrates in a specific branch or shift, exceeds the approved tolerance threshold, or appears in high-value items without an operational justification. In these cases, the report shifts from a routine accounting tool into an internal investigation that calls for management and internal audit intervention.

Types of Inventory Counting and When to Use Each

Choosing the right type of count determines the quality of the variance report. No single type fits every business. Each sector and operating size has its own best fit. Mixing types incorrectly or relying on a single type leaves the report unable to surface real variances.

Periodic Inventory

Conducted at the end of a defined period, monthly, quarterly, or annually, covering all items at once. Suitable for small and mid-sized businesses that can stop operations for several hours or an entire night to run the count. Its downside is that it reveals variances retroactively, after they have already accumulated.

Perpetual Inventory

The inventory balance is updated in real time with every purchase or sale movement in the system, alongside partial physical counts throughout the year. Suitable for large wholesale warehouses and multi-branch companies. It requires an integrated accounting system connected to point of sale.

Surprise Inventory

Conducted without prior notice to the warehouse keeper, targeting a sample of high-risk or high-value items. A core control tool in businesses facing concerns over operational integrity, usually executed under internal audit supervision.

Cycle Count

The inventory is divided into groups, with one group counted each week or each day, so the entire inventory is covered over the year without halting operations. Suitable for large pharmacies, retail chains, and logistics warehouses. It produces a continuous variance report that can be corrected on the spot.

Mandatory Columns in the Variance Report

An effective variance report contains a minimum set of fields that cannot be skipped. Any report missing one of these columns loses its ability to support an accounting or control decision. The table below shows the standard structure used in most mid-sized and large Saudi businesses.

Column	Description	Mandatory
Item code (SKU)	The unique identifier for each item in the system	Yes
Item name	The full commercial name of the item	Yes
Unit of measure	Piece, carton, kilo, liter, pack	Yes
Location or warehouse	Name of the branch, warehouse, or shelf	Yes
Book quantity	The balance recorded in the system at the moment of the count	Yes
Physical quantity	The quantity produced by the physical count	Yes
Quantity variance	Physical minus book, can be positive or negative	Yes
Unit cost	The cost adopted under FIFO or weighted average policy	Yes
Variance value in SAR	The quantity variance multiplied by unit cost	Yes
Variance percentage	The variance value over the book balance multiplied by 100	Yes
Classified cause	Damaged, missing, input error, natural shrinkage, etc.	Yes
Action taken	Accounting adjustment, internal investigation, unit-of-measure correction	Yes
Approver signature	Warehouse keeper, auditor, finance manager	Yes
Count date	Day, month, and year in a unified format	Yes
Adjustment voucher number	The reference number for the adjustment entry in the general ledger	Yes

Useful Optional Fields

• Last movement date: helps surface slow-moving items that need deeper inspection.
• Last supplier: useful when a variance is suspected to relate to a specific purchase batch.
• Batch number: practically mandatory in pharmacies and food products for tracking expiry dates.
• Item expiry: links variances to expired or near-expiry items.

How to Calculate the Variance Value

Valuing variances in Saudi Riyals is the most important step in the report, because it turns shortages or surpluses into financial figures that can be posted to the ledger and disclosed for tax purposes. The valuation method differs based on the business’s inventory costing policy. The two most common methods in the Saudi market are First In First Out (FIFO) and weighted average.

FIFO Method

Assumes that the first quantity to enter the warehouse is the first to leave. When valuing a shortage, the value is calculated using the cost of the oldest existing batch, and when valuing a surplus, it is priced at the cost of the most recent batch. Very suitable for products with limited shelf life such as medicines and food.

Weighted Average Method

Calculates the unit cost as a weighted average across all batches present in the warehouse. Simpler to compute and more stable in price, suitable for standard items unaffected by expiry. The table below shows a practical example.

Item	Book Quantity	Physical Quantity	Variance	Unit Cost (SAR)	Variance Value (SAR)	Valuation Method
Olive oil 1L	480	462	-18	22.50	-405	FIFO
Basmati rice 5kg	350	347	-3	68.00	-204	Weighted average
Water pack of 24 bottles	1,200	1,215	+15	14.75	+221	FIFO
Sugar 1kg	820	790	-30	4.20	-126	Weighted average
Shampoo 750ml	240	225	-15	31.40	-471	FIFO
Toothpaste	600	584	-16	9.80	-156.80	Weighted average
Bar of soap	1,500	1,492	-8	3.50	-28	Weighted average
Juice 1L	720	698	-22	7.25	-159.50	FIFO

The total variance value in this example is a net loss of roughly 1,330 SAR. For a mid-sized retail business running monthly counts, this figure becomes a baseline against which every branch and every shift is measured. Crossing it triggers intervention, and dropping below it is rewarded.

Valuing Positive Variances (Surpluses)

Positive variances are not always recorded as immediate income. They are handled with care. In most cases they result from a prior input error or an unrecorded return, and they need verification before being approved. Recording them as income before verification can inflate revenue and create downstream tax issues with ZATCA.

Classifying Variance Causes

A report that only displays numbers without classifying their causes loses half its value. Classifying the cause determines the next accounting action, assigns responsibility, and builds a database for analyzing leak patterns over time.

Internal Theft

The hardest cause to prove and the most sensitive. It is usually classified only after every other cause is ruled out and variances recur in the same shift or among the same group of employees. It calls for an internal investigation under HR and internal audit supervision.

Damage and Breakage

A legitimate and well-documented cause in most sectors, especially pharmacies, electronics, and glassware retailers. It requires an official damage report and direct manager approval before write-off.

Input Error

The most common cause in businesses that rely on manual entry. It is corrected through an adjustment entry after verifying the original document. Repeated occurrence calls for a review of training procedures and system controls.

Operational Loss

Applies particularly to factories and restaurants: frying oil evaporates, dough spoils, raw materials are lost during transformation. It must have a pre-approved natural threshold, and any excess is investigated.

Natural Food Shrinkage

Specific to restaurants, bakeries, and supermarkets. It includes evaporation, wilting, and expiry. Usually approved as a fixed monthly percentage by sector.

Receiving Discrepancies

Receiving smaller or larger quantities than the supplier invoice without documenting the deviation. It requires reviewing receiving notes and matching them against purchase invoices.

Undocumented Transfers

Goods that moved between branches without an internal transfer note. They appear as a shortage in one branch and a surplus in another, and are resolved through group-level branch reconciliation.

Acceptable Tolerance Threshold by Sector

The presence of variance does not automatically mean there is a problem. Each sector has a natural tolerance threshold, calculated as a percentage of inventory value or item count. Crossing this threshold is what calls for intervention. Staying within it is considered acceptable operational performance.

Sector	Tolerance (% of inventory value)	Recommended count frequency	Dominant causes
Restaurants and quick-service chains	3% to 5%	Weekly for fresh items, monthly for dry	Natural shrinkage, operational loss, damage
Pharmacies	0.5% to 1.5%	Monthly, cycle counts for high-value items	Expiry, damage, input error
Small retail outlets	1.5% to 2.5%	Monthly	Theft, input error, damage
Large retail chains	1% to 2%	Daily cycle counts plus annual full count	Theft, undocumented transfers, damage
Wholesale warehouses (B2B)	0.5% to 1%	Quarterly plus monthly cycle counts	Receiving errors, transfers, unit-of-measure variances
Factories	1% to 3%	Monthly for raw materials, weekly for work in progress	Operational loss, raw material shortage, production loss
Electronics retailers	0.5% to 1%	Monthly plus cycle counts for high-value items	Theft, damage, serial number errors
Construction materials and steel	2% to 4%	Quarterly	Weight variances, damage, measurement overshoot

How to Set Your Own Tolerance Threshold

Do not treat the percentages above as a rigid rule. Every business should build its own tolerance based on 6 to 12 months of historical data, while accounting for geographic location, customer profile, branch size, and the level of control in place. A business in a busy Riyadh district may justify a higher tolerance for objective reasons tied to traffic volume.

Accounting Procedures for Adjustment

After the report is issued and approved, the accounting adjustment phase begins. This phase converts variances from operational data into general ledger entries that flow into the financial statements. Any shortfall here keeps the inventory balance inflated or understated, distorting the accuracy of the balance sheet and the income statement.

Journal Entries for Shortage

When a real shortage is confirmed with a known value, the entry is recorded as follows: debit inventory shortage loss account (or stock count shortage expense), credit inventory account. If the shortage is the result of employee theft and is charged back, the entry becomes: debit receivables (employee), credit inventory. This distinction matters because it determines where the value appears in the financial statements.

Journal Entries for Surplus

When a real surplus is confirmed after verifying its causes, the entry is recorded as: debit inventory, credit other income (or inventory adjustment credits). Keep in mind that this surplus may be the result of an unrecorded purchase invoice. In that case, the correct entry is to book the invoice, not an income entry.

Approvals and Authorities

• Adjustments under 1,000 SAR: approval from the warehouse keeper and accountant is enough.
• Adjustments from 1,000 to 10,000 SAR: require finance manager approval.
• Adjustments above 10,000 SAR: require executive management and internal audit approval.
• Any adjustment related to theft: requires legal approval and HR review regardless of the amount.

Required Documentation

Every adjustment entry must be supported by: the approved variance report, photos or video where available for damage, an internal investigation report for theft cases, finance manager approval, and a sequential adjustment voucher number. Missing any of these documents exposes the business to objections from the external auditor during the annual review.

Impact of Variances on Financial Statements and Tax Filing

Every Riyal recorded as a shortage or surplus in inventory flows directly into the income statement through cost of goods sold or other expenses. This impact is dual: it reduces gross profit, and it reduces the tax base for VAT and corporate income tax or Zakat.

Impact on the Balance Sheet

The inventory line in current assets must reflect the real saleable value. Any overstatement makes the balance sheet look stronger than reality, and any understatement breaches the principle of fair disclosure. Adjusting variances is the only tool to ensure the inventory figure on the balance sheet is a defensible, real number.

Impact on the Income Statement

Cost of goods sold equals: opening inventory plus purchases minus ending inventory. Any error in ending inventory flows inversely into the cost. An inflated inventory reduces cost and lifts profit, and the reverse holds. This figure is what ultimately reaches the filing submitted to ZATCA.

Impact on VAT

Negative variances arising from loss, damage, or theft may not be eligible for automatic input VAT recovery, under the executive regulations of ZATCA. Any inventory adjustment must be reviewed for tax purposes to determine whether previously recovered input VAT must be repaid, especially in cases of negligence or theft without a police report.

Impact on Phase 2 of E-Invoicing

In Phase 2, sales invoices are transmitted in real time or within 24 hours all week long to the Fatoora platform. Any sales invoice for an item with a book balance of zero raises a question mark with the auditor. As a result, settling variances before sale has become an operational necessity, not just an accounting recommendation.

Variances Across Different Sectors

The nature of variances differs fundamentally from one sector to another. A variance report that fits a restaurant does not fit a pharmacy or a wholesale warehouse in the same form. Understanding the specifics of each sector makes the report more accurate and more actionable.

Restaurants and Food Chains

Strong focus on raw materials: meat, vegetables, oils, spices. Variances here are affected by temperature, expiry dates, and the size of prepared meals. The report must link material consumption to the number of meals actually sold. Explore the depth of this sector on the restaurants sector page.

Pharmacies

Expiry dates are a decisive factor. Any item nearing expiry must appear in a separate report within the variance report, even if its balance matches the system. Variances here tend to carry higher value because unit prices are higher.

Retail Outlets

Focus on theft-attractive items: perfumes, accessories, small electronics. The report in this sector needs integration with CCTV systems and the point-of-sale system.

Wholesale Warehouses

Massive quantities with multiple units of measure. The largest source of variance is the unit of measure: recording by carton instead of piece. The report here needs an extra column for unit conversion and verification.

Factories

Three layers of inventory must be counted separately: raw materials, work in progress, and finished goods. Each layer gets its own variance report, then everything is consolidated into a master report.

How Qoyod Helps You Generate the Variance Report Automatically

Building the variance report manually inside Excel or Google Sheets works for very small businesses, but it collapses once items pass 500 SKUs or once more than one branch is involved. Qoyod offers a full inventory management stack that generates the variance report automatically with no manual counting and no data transfer between systems. See the details on the inventory management system page.

Barcode-Based Electronic Counting

Using a scanner or the mobile app, the physical count flows directly into the system. Qoyod automatically compares physical against book and produces the variance report in seconds. The accountant does not need any data transfer or Excel formulas.

Automatic Variance Valuation

Qoyod stores the costing policy (FIFO or weighted average) for each item, and computes the variance value in Saudi Riyals immediately when the count report is issued. No manual math is needed to value shortages or surpluses.

Adjustment Entries Are Created Once

Once the variance report is approved inside Qoyod, the necessary journal entries are generated automatically and posted to the general ledger with no extra manual entry. This prevents any gap between the operational report and the accounting records.

Integration with Point of Sale and E-Invoicing

Every point-of-sale transaction updates inventory in real time, and every recorded purchase invoice closes the gap between book and physical. With Phase 2 of e-invoicing, this synchronization is a regulatory requirement, not an option.

Reports by Branch and Warehouse

A business with branches in Riyadh, Jeddah, Dammam, and Abha can pull a separate variance report for each branch and compare branch performance to identify the highest in shrinkage. This comparison cannot be done in Excel without hours of manual work.

Round-the-Clock Support

The Qoyod support team is available 24 hours all week long to help the business set its inventory valuation policy, configure variance reports by sector, and train warehouse keepers on electronic counting. To find the right plan, see the pricing page.

The Most Common Mistakes in Saudi Inventory Counting

Based on patterns observed across hundreds of mid-sized Saudi businesses, certain mistakes recur frequently and can be avoided through simple procedures. Fixing these mistakes often reduces the variance value by 30% to 50% without any additional investment.

Counting Without Halting Movement

Counting items while sales and purchases continue makes the numbers meaningless. The count must take place when all movements are stopped, even if only for an hour.

Relying on a Single Counter

Any count without dual verification is exposed to error or fraud. The rule: a primary counter, an independent reviewer, and an approver.

Delaying Variance Adjustments

Every day that passes without adjustment makes the entry harder, because new movements overlap with prior balances. Adjustments should be posted within 7 days of report approval.

Skipping Cause Classification

A report with numbers but no causes surfaces the problem but does not solve it. Every line needs a cause from a limited approved list of no more than 10 causes.

Merging Variances Across Branches

Consolidating all variances into a single business-wide number hides problems in weaker branches. The report must be broken down by branch, warehouse, and item.

Ignoring Small Variances

A 50 SAR variance per item may look minor, but it stacks up to thousands of Riyals across thousands of items. Every difference must be recorded and classified even if its value is low.

Failing to Document Damage with Photos

Writing off damaged items without photos or video puts the entry under doubt with the external auditor and with ZATCA. Every damage event must be photographed before write-off.

Not Reviewing Unit of Measure

An item purchased by carton and sold by piece needs an accurate conversion factor in the system. An error in this factor generates massive phantom variances without any real inventory issue.

Frequently Asked Questions

Is the variance report legally mandatory in Saudi Arabia?

There is no explicit text requiring a variance report in a specific format, but sound bookkeeping and ZATCA requirements demand an accurate, provable inventory balance. The variance report is the only tool to prove this accuracy.

How often should the report be issued?

At minimum, once a year before the financial statements. Quarterly is better for most businesses, and monthly for high-turnover sectors such as restaurants, pharmacies, and retail.

What is the difference between variance and shrinkage?

Shrinkage is an expected shortage approved within the tolerance threshold. Variance is a broader term that includes natural shrinkage plus abnormal deviations that need investigation. All shrinkage is variance, but not all variance is shrinkage.

Should shortages be charged back to the employee?

Only after proving negligence or misconduct through a documented internal investigation, and while observing the Saudi Labor Law and Ministry of Human Resources regulations. Charging the employee without proof exposes the business to labor disputes.

How do I handle positive variances?

Investigate first to rule out an unrecorded purchase invoice or a return that was not entered. After verification, record as an inventory surplus against other income or a discount adjustment on a prior purchase invoice.

Can input VAT be recovered on stolen goods?

Under ZATCA regulations, lost or stolen goods may not be eligible for input VAT recovery, and in some cases previously recovered VAT must be repaid. It is always advisable to consult a tax advisor when recording high-value theft.

How long does counting a mid-sized warehouse take?

A warehouse with 2,000 to 5,000 SKUs counted manually needs a team of 4 to 6 people for 8 to 12 hours. With a scanner and electronic counting, the same warehouse is counted in 3 to 5 hours.

What is a reasonable tolerance threshold for a new business?

For a new business with no historical data, start with a tolerance of 2% of inventory value, then adjust after 6 months based on actual data. The threshold should be reviewed at least once a year.