Comparing Order data to Sales Summary Report

Questions
2

Just for net amounts, you can go through all Orders and:

  1. Check if the order has any tenders or refunds:
  2. If it’s not a refund: Add the order->total_money->amount to the total.
  3. If it’s a refund: Subtract the order->refunds->refund->amount_money->amount from the total

That’s it, that should get you your “net sales”. If you want gross sales, then you need to it slightly different:

  1. If the order has tenders, refunds, or is in a COMPLETED state (100% discounted order) then…
  2. Add the following to the total: total money, tip money, and discount money

Let me know if that helps at all.