Sales and inventory reconciliation across two systems
- The situation
An outdoor gear shop sells through a store register and an online store, and each keeps its own product list and stock counts. The online store kept selling items that were gone from the shelf, and items sold in the store stayed listed online. Every month the sales totals and the bank deposits differed, and nobody could say why.
- What was built
509 register items and 515 online listings are lined up as 522 products, including SKUs written in different ways and listings with no SKU at all. Each product's quarter is rebuilt from both systems' records, what should be on the shelf is worked out, and every difference gets a named cause. Every card batch, online payout and cash slip is matched to the sales it pays for, and the gap is explained week by week. The two records show side by side with the differences marked, the suggested fix, and a list of fixes applied.
- The result
117 stock differences and a $5,299.22 deposit gap, each traced to a cause.
- What the client received
A matching script, the eight exports it reads, its log, and a working reconciliation workspace.
Try it Open Products and pick a row to see both records.
Describe your project and we will send you a fixed-price quote.