How to reconcile loblaw POS data with payment remitances?

  • 1
  • Question
  • Updated 2 years ago
I get POS data from Loblaw for our consignment agreement. Then they pay us about a two week later. My challenge is to reconcile the payment with the POS data. The POS data for single day of transactions comes in from about 10 - 20 product activity reports where various UPCs and stores are reported. Then in the payment remittance we get only dollar amounts on a store level. My issue is I am not sure which product activity reports to use. Anything will help.
Photo of Jonathan Brotto

Jonathan Brotto

  • 70 Points

Posted 2 years ago

  • 1
Photo of Ryan Morrissey

Ryan Morrissey

  • 1,646 Points 1k badge 2x thumb
Hi Jonathan,

I would recommend reaching out to Loblaws and requesting that more detail be included on the Remittance Advice documents they send. If they are unable to provide additional detail on the EDI document, perhaps they can send a breakdown of what is being paid for via email?

If I understood your question correctly, this is something that will need to be taken up directly with Loblaws.

I hope this helps!