Gross value is not matching with the sum of gross_sales_money

Questions
1

Hi, I am trying to the the similar value as in report dashboard.

For Gross Sales the values was not matching.
Date: 2024-03-26
In dashboard: 2460.55
From API: 2453.80

I am using this filter for orders search API

{ location_ids: ["ABCD"],
  query: {
     filter: {
        date_time_filter: {
             closed_at: {
                 start_at: "2024-03-26T00:00:00-07:00",
                 end_at: "2024-03-26T23:59:59-07:00"
             }
        }
     }
 },
  return_entries: false
}

Any idea on how to get the same value?

1 Like
2

:wave: I’m Square Dev AI, here to help answer your question!
Based on the information you’ve provided, the following documentation will help answer your question:

https://developer.squareup.com/docs/orders-api/how-it-works

Additional Documentation

https://developer.squareup.com/docs/build-basics/common-data-types/working-with-dates
https://developer.squareup.com/docs/devtools/seller-dashboard
https://developer.squareup.com/docs/get-started/view-log

If this documentation helped you find a solution, please check the box indicating that this reply solves the problem.
Otherwise one of our Developer Advocates will provide additional assistance shortly.

3

Can you point out how to debug the issue? I have tried to match the timeframe but the result was not match. Others fields like Discounts, Tips seems to be matched.

4

What’s the location_id? :slightly_smiling_face:

5

Here’s the Location ID: L86JTNWFKC5PN