Accounting and Bookkeeping for SMEs

Detecting a Duplicate Supplier Invoice Through Inventory and Ledger Reconciliation

During a monthly review a supplier invoice did not match stock movements. Comparing documents with the warehouse revealed a duplicate and distinguished it from a valid price adjustment.

Client
Inventory-intensive trading company · connected warehouse and accounting systems
Practice area
Accounting and Bookkeeping for SMEs
Focus
Bookkeeping & statutory accounts, Management reporting
Services
Accounts payable review, Bookkeeping controls, Financial reporting, Inventory reconciliation, Management accounting

Initial situation

In businesses with frequent stock movements and supplier invoices, a posting can look technically valid in the accounting system while still being commercially wrong. During a monthly review, a supplier invoice did not reconcile as expected to the stock flow. A separate document also appeared without the usual goods-receipt relationship. Left unresolved, such exceptions can overstate costs or liabilities, distort gross margin and weaken confidence in management reporting.

Our solution

We challenged the exceptions rather than simply booking around them. We compared supplier documents with inventory movements and asked the client to verify the source-system entries. That review established that one supplier invoice had been created twice and required correction; another apparent mismatch was explained as a price adjustment that correctly had no physical goods receipt. The distinction mattered: one item was an error, while the other reflected valid commercial substance. Both were documented before the monthly figures were treated as final.

Result

The duplicate invoice was identified and corrected before it could continue to distort the accounts, while the legitimate price adjustment was retained with a clear explanation. Management received a more reliable cost and margin picture, and the exercise demonstrated the value of integrating bookkeeping controls with inventory reconciliation rather than reviewing the general ledger in isolation.

Facing a similar situation? Do not hesitate to contact us

Learn more about the service Contact us