Before reusing a customer reporting setup, check what each source counts. The North Quay data shows one row per order. Marshfield records each parcel separately. For a Marshfield order split across two parcels, use the date the final parcel went out, once dispatch is complete. That order contributes once to the weekly count.
Use the date promised to the customer. Marshfield’s planned ship date serves internal planning. If the promised date changed, agree which date to use before you count late orders. Keep branch codes tied to the customer, since code 01 can mean different places.