A stock status report gives you a single number: how many units are on hand. If this number is correct, there is no problem. The trouble begins when the number looks wrong.
At that point, a status report is useless because it does not show how that number came to be. A statement shows precisely that: every single movement, in order.
In this article, we explained how to read a statement, what each column means, and the steps to follow when searching for discrepancies.
Table of Contents
What is a statement, and how does it differ from a status report?
A stock status report is a photograph: what is on hand right now. A statement is a movie: what happened from the beginning of the period until today.
In a statement, every line represents a movement. Inflows, outflows, transfers, count corrections, and waste appear separately. At the end of each line, the balance at that exact moment is displayed.
Thanks to this structure, you can see which movement changed the balance. Observations such as "There were thirty units on Tuesday, it dropped to fifteen on Wednesday" can be made directly.
What do the columns tell us?
Date. The day the movement took place. Statements are read in chronological order; disrupting the order makes interpretation difficult.
Document type and number. The basis of the movement. This column allows you to trace back from a questionable line to the actual document.
Current account. The counterparty. Customers appear for sales, suppliers for purchases, and warehouse information appears for transfers.
Inflow and outflow quantity. The direction and magnitude of the movement. Keeping these two columns separate simplifies reading.
Balance. The remaining quantity after the movement. If the balance drops below zero at any intermediate point, it is a sign of an issue during data entry.
Movement types
Every line in a statement has a source, and knowing the source speeds up interpretation.
Purchase movements originate from supplier dispatch notes or invoices; you can check the manufacturer dispatch note article.
Sales movements come from dispatch notes or invoices. Cash register sales also fall here; see the cash register stock integration article.
Transfer movements show transitions between warehouses; they do not change total stock, but they alter warehouse balances.
Correction and waste movements occur after inventory counts or write-off records. The frequency of these lines serves as an indicator of quality.
Production movements include raw material consumption and finished goods entry; we discussed this in the production receipt article.
Steps to follow when searching for discrepancies
If a product's balance differs from expectations, reading the statement from the beginning is a waste of time. There is a faster method.
First, locate the last point you know to be correct, which is usually the latest inventory count date. Examine the movements from that date to today.
Next, look for unusual lines: quantities of atypical magnitude, records entered during night hours, or movements generated twice from the same document.
Duplicate entries are the most common cause. Processing the same dispatch note twice silently corrupts the balance.
Once a discrepancy is found, classify the cause before making adjustments; we covered this methodology in the inventory count discrepancy article.
Warehouse-based reading
In a multi-warehouse structure, reading the statement over totals is misleading. Since transfers do not change the grand total, they remain invisible.
When a warehouse filter is applied, transfers become clearly visible: an outflow in one warehouse and an inflow in another. Quantities stuck in transit are also noticed this way.
We addressed warehouse structures in the multi-warehouse stock management article.
In multi-company setups, users see only the scope they are authorized for; the multi-company model ensures this.
Weekly control routine
Opening the statement only when a problem arises means catching issues too late. A short weekly check is sufficient.
A checklist could look like this: products with negative balances, cards that have undergone excessive correction movements, and items sitting in stock with no movement at all.
The latter group serves as the starting point for dead stock analysis; you can check the inventory turnover rate article.
Statements and status reports come ready in the stock module; data is powered by the entries made by operations, and no separate set is maintained. You can find the general approach on the reporting page.
An example discrepancy investigation
Let's look at a concrete example. Thirty-two units were counted for a product that should have had forty in the warehouse; there is a discrepancy of eight units.
The first step is to find the last known correct point. The count from three months ago showed no discrepancy, meaning the issue developed within those three months.
The second step is to scan the movements during that period. If you are looking for a variance of eight units, lines with quantities equal to eight or multiples of eight stand out; if a box contains eight units, a unit error is highly probable.
The third step is to check for duplicate entries. The appearance of the same document number twice indicates that the same dispatch note was processed twice.
If it cannot be found, the difference is treated as a physical loss and closed with a correction receipt; however, the reason field must be filled out. We covered this recording discipline in the inventory count discrepancy article.
Reading alongside other reports
A statement is a powerful tool on its own, but when combined with other reports, it tells you much more.
When compared with the sales report, it reveals whether outflow movements truly originated from sales or another source; check out the sales reports article.
When read alongside the purchasing report, inflow movements are verified. A stock entry without an invoice points to a matching deficiency.
The warehouse status report provides an instant snapshot; the statement explains how that snapshot was formed. Used together, they answer both "what is there" and "why is it there."
In manufacturing businesses, bill-of-materials consumption also appears on the statement; higher-than-expected consumption indicates an increased waste rate. You can check the production cost article.
Frequently asked questions
Why does a balance drop below zero?
Usually because an outflow record was processed before the inflow. The issue resolves once chronological ordering is corrected.
Does the statement include cost information?
It depends on report preferences. Cost visibility should be subject to authorization; see the report authorizations article.
Does a deleted movement appear in the statement?
If a movement is deleted, it drops off the statement; however, the transaction can be tracked in the log records. You can check the audit trail article.
Can a statement be pulled based on lots?
Yes, if lot tracking is enabled; see the batch and lot tracking article.
The statement is the most useful yet least utilized report in stock management. Learning how to read it cuts discrepancy searching times from hours down to minutes.
By consulting with the EQLEM team, you can set up your stock reporting workflow.