Gross value is not matching with the sum of gross_sales_money

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

: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:

Additional Documentation

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.

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.

What’s the location_id? :slightly_smiling_face:

Here’s the Location ID: L86JTNWFKC5PN