Stocktake Discrepancies in Accounting Systems: How Do You Reconcile Inventory with the Books?

Stocktake Discrepancies in Accounting Systems: How Do You Reconcile Inventory with the Books?

📅 16/11/2026

In an integrated accounting system, do not start resolving stocktake discrepancies with a loss entry before identifying the source of the difference. Establish inventory movements as of the count time, review units of measure, transfers, returns, and costs, and then determine whether the difference concerns quantity, value, recording timing, or cost of goods sold.

An accountant at a wholesale trading company discovers that the warehouse counts 140 units while the system report shows 154 units, and at the same time the accounting value of inventory differs from the item valuation report. An integrated accounting system links inventory documents to their financial impact, but it does not prevent errors if item units, stocktake permissions, or cost allocation methods are not properly controlled. A correct adjustment is the result of a documented investigation, not simply a way to make the two reports agree.

This article explains a practical, step-by-step approach to diagnosing the problem, with examples from businesses operating in Saudi Arabia. It identifies the documents needed to resolve each issue and the testing criteria to apply after any correction. The article addresses a specific accounting problem in its operational context and does not treat technology as a substitute for professional judgment or original documentation.

How Do You Start Resolving Stocktake Discrepancies in an Integrated Accounting System?

Start by defining the date as of which the figures must be correct and the scope of the accounts, customers, or branches included in the review. Retain a copy of the initial report, then separate source records from accounting entries and aggregations. An integrated accounting system helps bring these references together when permissions, accounts, and data are properly configured, but generating a single report does not replace comparing both sides and verifying the reasons for exceptions.

Practical application: Book a practical demonstration of the resolution workflow in the accounting system

Steps for Resolving Stocktake Discrepancies and Reconciling Inventory with Accounts

1. Stocktake Timing and Inventory Reconciliation with Accounts

The situation may not seem significant at first: the quantity difference increases as the stocktake takes longer and the sales team continues issuing items. However, it reveals a potential weakness: the balance changes during the count without a common cutoff date. As such cases accumulate, they may affect another report or a collection or disbursement decision. It is preferable to isolate questionable transactions from valid ones and define the time range and responsible party before searching through thousands of entries. Use one document with a clear number as the unit of review, then roll the result up to the total account when finished.

To confirm or rule out the cause, obtain inventory movement reports before and after the stocktake, and issue and receipt vouchers. Match documents by invoice or voucher number, amount, and bank or inventory reference, where available, rather than by totals alone. The appropriate procedure in this case is to set a cutoff time, keep subsequent movements separate, and reconstruct the balance as of that time. If more than one explanation emerges, test each separately and retain a copy of the report before correction. Comparing the situation before and after correction helps ensure that the entry or allocation has not created an additional difference.

Practical example: A store operating multiple shifts counts its shelves in the morning and compares the count with the end-of-day balance. Case closure criterion: The expected balance agrees only with movements preceding the specified cutoff time. Do not approve the resolution before verifying the result in the detailed report and its associated document.

For more on this stage: A Guide to Warehouse Organization and Stocktaking

2. Correcting Item Units and Conversion Factors

The accounting question here is not merely why one figure does not equal another, but why the system displays cartons as the unit while the stocktake team counts individual pieces. This directs attention to an incorrect conversion factor or the use of a barcode for a different unit. If an external party such as a customer, bank, or supplier is involved, obtain its evidence; if the transaction is internal, retain the approval trail. Do not confuse an acceptable accounting explanation with an attempt to make the balance look better before submitting the report. A good correction can be explained months after it is made.

Do not start with a summary report without its details. The documents you need here are the item master record, conversion factor, barcode labels, and invoices. Use them to reconstruct the transaction history in chronological order, then review the number of units per package and standardize the references before recounting. Prioritize cases by material amounts, age, and transactions involving external parties. If an accounting entry is needed, link it to a document, approval, and user permission, while retaining the original entry information for subsequent tracking and review.

Practical example: A warehouse records 12 pieces as one carton, but the system is configured for a package of 10 pieces. Case closure criterion: The balance converts to the base unit with the same expected total value. Do not approve the resolution before verifying the result in the detailed report and its associated document.

For more on this stage: Sales and Purchases Accounting Details

3. Tracking Transfers Between Warehouses

The investigation starts with the warning sign the accountant encounters: there is a shortage in the main warehouse and an equivalent surplus in the branch warehouse. A common mistake is to jump to a correcting entry before understanding the source, because this may shift the difference to another account instead of resolving it. The suspected issue here is stock was issued from the source before the receiving location recorded receipt. Review the transaction date and the related branch or account, then ask whether the event actually occurred or was recorded in a different place or period. This distinction shortens the investigation and prevents the error from multiplying at closing.

The review requires more than a screenshot from the software. Use the transfer request, issue voucher, receipt voucher, and delivery dates. Allocate one column to the source of evidence, another to the financial impact, and a third to the reason accepted by management. Apply the following step: match transfer numbers, identify goods in transit, and do not automatically recognize a shortage. Do not delete the original transaction to make the records look clean. Instead, use a correction process that makes it possible to understand what happened, taking into account the documentation, invoicing, and internal control requirements relevant to the transaction.

Practical example: Thirty boxes are transferred to another branch and their dispatch is recorded without their receipt. Case closure criterion: Quantities reconcile between warehouses after pending movements are resolved. Do not approve the resolution before verifying the result in the detailed report and its associated document.

For more on this stage: Procurement System Functions

Try the Digital Business accounting system

Next step for your business: Compare system plans before moving away from manual spreadsheets

4. Reviewing Pending Sales and Returns

When reports indicate that an item was sold but the inventory reduction movement was not posted, start by describing the difference in writing rather than merely telling management that the figures do not match. The cause worth testing is a disconnect between the point of sale and the warehouse or an interruption in transaction synchronization. Do not treat it as a conclusion before reviewing the evidence; a data entry error may coexist with a legitimate timing difference. Identify the impact on revenue, expenses, assets, and liabilities, and determine whether the result changes a total account or only its underlying detail.

Start with a single auditable file containing point-of-sale reports, sales invoices, credit notes, and delivery vouchers. First rule out differences confirmed to belong to another period or account, then generate a list of unposted transactions and determine the status of each before adjustment. Place the document numbers side by side so that each item can be followed without searching again. Do not combine multiple errors in one reconciliation line when their causes differ; a solution that cannot be explained is not a sound basis for a reliable financial close.

Practical example: A store makes sales during a connection outage, then a batch of invoices is synchronized twice. Case closure criterion: Sales and return movements correspond to their inventory impact exactly once. Do not approve the resolution before verifying the result in the detailed report and its associated document.

For more on this stage: Organizing General Ledger Accounts and Reconciliations

5. Purchase Invoices and Partial Receipts

This step becomes important when you notice that the accounts show the value of purchases that have not fully arrived at the warehouse. Before changing any balance, ask how the data moved from the document to the report. The initial hypothesis is that the entire invoice was recorded despite partial delivery or delayed receipt approval; independent evidence is needed to support it. Correcting the final figure without correcting the procedure may cause the problem to recur the following month. Therefore, connect the diagnosis to the source of the transaction, the person who approved it, and its date, rather than merely to the amount of the difference.

Assemble the following evidence file: the purchase order, goods receipt records, supplier invoice, and inspection record. Ideally, every document should have an original number and date and be linked to the same transaction in the general ledger or system log. Then carry out the practical procedure: separate goods actually received from goods in transit and claims against the supplier. Record the comparison in a separate statement with columns for the amount, source date, and resolution status, and avoid personal notes that are difficult for the reviewer to understand. If a document is incomplete, keep the transaction under follow-up rather than assuming information that the relevant party has not confirmed.

Practical example: A supplier invoices 100 units, but only 85 units have arrived as of the stocktake date. Case closure criterion: The quantity increase is supported by a signed receipt, and valuation is based on accepted quantities. Do not approve the resolution before verifying the result in the detailed report and its associated document.

For more on this stage: Financial Reports Required from the System

Next step for your business: Create an account to try organizing your business data

6. Damaged and Expired Items

The situation may not seem significant at first: the warehouse counts damaged units as part of saleable stock. However, it reveals a potential weakness: goods are physically present but cannot be sold at their previous value. As such cases accumulate, they may affect another report or a collection or disbursement decision. It is preferable to isolate questionable transactions from valid ones and define the time range and responsible party before searching through thousands of entries. Use one document with a clear number as the unit of review, then roll the result up to the total account when finished.

To confirm or rule out the cause, obtain damage records, expiration reports, photographic evidence, and the write-off policy. Match documents by invoice or voucher number, amount, and bank or inventory reference, where available, rather than by totals alone. The appropriate procedure in this case is to classify unusable quantities and determine the accounting treatment after approval. If more than one explanation emerges, test each separately and retain a copy of the report before correction. Comparing the situation before and after correction helps ensure that the entry or allocation has not created an additional difference.

Practical example: A food store has 40 expired packages that have not been separated from sound goods. Case closure criterion: Inventory reflects the condition of the items and their verifiable value in accordance with policy. Do not approve the resolution before verifying the result in the detailed report and its associated document.

For more on this stage: A Guide to Reading Financial Reports

7. Additional Purchase Costs

The accounting question here is not merely why one figure does not equal another, but why the inventory value in the general ledger exceeds the value shown in the item quantity report. This directs attention to purchase expenses charged to the inventory account without allocation to individual items. If an external party such as a customer, bank, or supplier is involved, obtain its evidence; if the transaction is internal, retain the approval trail. Do not confuse an acceptable accounting explanation with an attempt to make the balance look better before submitting the report. A good correction can be explained months after it is made.

Do not start with a summary report without its details. The documents you need here are shipping, customs clearance, and insurance invoices, and the cost allocation policy. Use them to reconstruct the transaction history in chronological order, then review which expenses are included in cost and how they were allocated to purchase batches. Prioritize cases by material amounts, age, and transactions involving external parties. If an accounting entry is needed, link it to a document, approval, and user permission, while retaining the original entry information for subsequent tracking and review.

Practical example: An imported shipment is received at purchase value only, and transportation charges are then posted as a lump sum. Case closure criterion: Value at item and batch level agrees with the total balance. Do not approve the resolution before verifying the result in the detailed report and its associated document.

For more on this stage: Sales Operations Management

8. Inventory Valuation and Its Effect on Cost of Goods Sold

The investigation starts with the warning sign the accountant encounters: the item quantity is correct, but its average cost is negative or unreasonable. A common mistake is to jump to a correcting entry before understanding the source, because this may shift the difference to another account instead of resolving it. The suspected issue here is an issue before receipt or a backdated cost adjustment. Review the transaction date and the related branch or account, then ask whether the event actually occurred or was recorded in a different place or period. This distinction shortens the investigation and prevents the error from multiplying at closing.

The review requires more than a screenshot from the software. Use cost layers, returns, purchase invoices, and correcting movements. Allocate one column to the source of evidence, another to the financial impact, and a third to the reason accepted by management. Apply the following step: review the valuation method applied, transaction dates, and related effects. Do not delete the original transaction to make the records look clean. Instead, use a correction process that makes it possible to understand what happened, taking into account the documentation, invoicing, and internal control requirements relevant to the transaction.

Practical example: An item is issued before its supply invoice is recorded, resulting in a misleading average cost. Case closure criterion: The valuation report can be reconciled with the general ledger and contains no unexplained anomalous values. Do not approve the resolution before verifying the result in the detailed report and its associated document.

For more on this stage: Integrating Point-of-Sale Operations

Digital Business solutions for business management

Next step for your business: Request a demonstration of how to monitor controls and reports

9. Independent Counting and Recounting

When reports indicate that the warehouse keeper disputes a large initial discrepancy, start by describing the difference in writing rather than merely telling management that the figures do not match. The cause worth testing is human counting error, double-counting a shelf, or overlooking a storage location. Do not treat it as a conclusion before reviewing the evidence; a data entry error may coexist with a legitimate timing difference. Identify the impact on revenue, expenses, assets, and liabilities, and determine whether the result changes a total account or only its underlying detail.

Start with a single auditable file containing independent count sheets, signatures from two teams, barcode photographs, and the reconciliation record. First rule out differences confirmed to belong to another period or account, then recount items with material differences using a team that did not perform the first count. Place the document numbers side by side so that each item can be followed without searching again. Do not combine multiple errors in one reconciliation line when their causes differ; a solution that cannot be explained is not a sound basis for a reliable financial close.

Practical example: An item is stored on two shelves but is counted on only one. Case closure criterion: No adjustment is approved until the records agree or the discrepancy is explained. Do not approve the resolution before verifying the result in the detailed report and its associated document.

For more on this stage: Accounting Solution Features

10. Documenting Stocktake Corrections and Reviewing Accounting Adjustments

This step becomes important when you notice that the responsible person wants to enter a lump-sum adjustment to conceal discrepancies before month-end closing. Before changing any balance, ask how the data moved from the document to the report. The initial hypothesis is the absence of classification of shortages, surpluses, write-offs, and potential tax effects; independent evidence is needed to support it. Correcting the final figure without correcting the procedure may cause the problem to recur the following month. Therefore, connect the diagnosis to the source of the transaction, the person who approved it, and its date, rather than merely to the amount of the difference.

Assemble the following evidence file: the approved stocktake record, summary of discrepancies, valuation method, and reasons for the differences. Ideally, every document should have an original number and date and be linked to the same transaction in the general ledger or system log. Then carry out the practical procedure: make adjustments according to their causes, with supporting documents and approvals, and keep the audit trail of the amendment clear. Record the comparison in a separate statement with columns for the amount, source date, and resolution status, and avoid personal notes that are difficult for the reviewer to understand. If a document is incomplete, keep the transaction under follow-up rather than assuming information that the relevant party has not confirmed.

Practical example: An annual stocktake reveals a genuine shortage separate from a price difference supported by a purchase invoice. Case closure criterion: The general ledger inventory balance agrees with the valuation report after all valid adjustments. Do not approve the resolution before verifying the result in the detailed report and its associated document.

For more on this stage: Comparing Cloud and Traditional Accounting

Practical Example: Reconciling Inventory with Accounts Step by Step

An accountant at a wholesale trading company discovers that the warehouse counts 140 units while the system report shows 154 units, and at the same time the accounting value of inventory differs from the item valuation report. Do not assume that the first difference you identify explains all the figures. Create a working copy containing the balance or report before correction, then link it to the original document and the record of dates and users. If the review reveals two different causes, separate them into independent cases: one may require an accounting correction, while the other may be a timing difference that does not require a new entry.

Start with the highest-risk items and then complete the list in order: set a cutoff time, keep subsequent movements separate, and reconstruct the balance as of that time; generate a list of unposted transactions and determine the status of each before adjustment; review which expenses are included in cost and how they were allocated to purchase batches; make adjustments according to their causes, with supporting documents and approvals, and keep the audit trail of the amendment clear. After each step, generate a new detailed report rather than relying on a change in the total. Have the accounting manager or reviewer sign off on the reason for the correction and its effect on the period, and assign a follow-up owner to cases that do not yet have sufficient supporting documentation.

Summary Comparison Table: Before and After Correction

DifferenceDiagnostic QuestionAppropriate Approach
Initial observationThe quantity difference increases as the stocktake takes longer and the sales team continues issuing items.Set a cutoff time, keep subsequent movements separate, and reconstruct the balance as of that time.
Decisive evidencePurchase order, goods receipt records, supplier invoice, and inspection record.The quantity increase is supported by a signed receipt, and valuation is based on accepted quantities.
Status after correctionThe general ledger inventory balance agrees with the valuation report after all valid adjustments.Make adjustments according to their causes, with supporting documents and approvals, and keep the audit trail of the amendment clear.

Stocktake and Valuation Checklist Before Adjustment

• Define a single cutoff date and a list of accounts, branches, or suppliers included in the review.

• Retain the report and documents as they were before any amendment or posting.

• Match records at the individual transaction level, not merely at the total level.

• Classify each difference as a timing issue, a recording error, or a matter requiring professional judgment.

• Do not post a reconciliation entry without clear supporting documentation and approval from the authorized person.

• Regenerate the detailed report and entries, and document that the cause has been resolved.

• Assign an owner and review date to remaining cases, and record why they have not been closed.

• Keep a copy that can be rechecked when preparing or auditing financial statements.

Ready to Try the System?

Start your free trial or speak with the sales team to help choose the right solution.

Frequently Asked Questions

Does every stocktake shortage constitute theft?

No. It may arise from delayed posting, damage, a counting error, or an unauthorized transfer, and requires investigation.

Must inventory movements stop during a stocktake?

A cutoff time must be established for movements, and incoming and outgoing stock during the count must be controlled according to the business’s procedures.

Why does inventory value differ even when quantities agree?

This may be due to cost timing, the valuation method, purchase expenses, or item settings.

Can quantities be adjusted without a formal record?

This is not recommended. Document the count difference and the responsible person’s review, then document the adjustment’s impact on inventory and the books.

Why are units of measure important?

Confusing individual pieces with cartons or packages can explain large quantity differences without any actual loss.

Conclusion:

Success in resolving the problem is not measured by making a single difference disappear from the screen, but by the ability to trace every transaction, understand its impact, and prevent it from recurring. Use an integrated accounting system to bring accounts, documents, and reports together in a clear workflow, then link correction approval to a responsible person and a test. Most importantly, report results must be capable of being rechecked. This is the difference between a figure that looks correct and accounting data that can be relied on for operations and decisions.

If you would like to test this workflow using your own business data: Start a trial of the accounting solution that suits your team

Manage Your Business with Greater Flexibility

Try Digital Business for free. Start issuing electronic invoices designed to meet ZATCA requirements in minutes.

Free Trial Without a Credit Card
24-Hour Technical Support
Compatible with ZATCA Requirements