How do I match units recorded as sent against receipts at the destination and flag incomplete transfers?
Aggregate by transfer and SKU. A sent entry is required before any receipt can reconcile.
Open Transfer Pair ReconcilerTry the worked example
These are the example inputs from Transfer Pair Reconciler. Replace them in the tool to run your own case.
| Transfer | SKU | Entry | Units |
|---|---|---|---|
| T04 | NOTE | sent | 24 |
| T04 | NOTE | received | 21 |
| T05 | CARD | sent | 10 |
| T05 | CARD | received | 10 |
Example result
T04 / NOTE · In transit · 24 sent, 21 received. Difference 3 unit(s).
Who uses this?
Multi-location retailers. The free online tool runs the calculation in your browser. To edit the files and use the tools offline in one business, see the €49 offline edition.
Where the idea came from
Benchcraft adapted the reviewed supplier comparison and approval for repeat purchasing idea for multi-location retailers. The rules and fictional example here were created for this tool.
Original video