I am struggling to match the numbers and transactions received from “search orders” API with what is shown on square dashboard. I have tried matching and checking the datetime but the number difference is too large, for some of the months API returns more transactions as compared to square dashboard whereas for some months opposite case is also observed. Can you help me understand why there is a difference or how can I get correct numbers
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
Square Dashboard
Orders API: How It Works
Square Developer Tools
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.
Is there a reason your not first getting all the payments from the Payments API and then pulling the order_ids from the payments to then call the Orders API to bring in all the order details? The payment response will also have a boolean that will tell you whether or not a payment was taken offline so you can accurately account for daily payments. 
Thanks for the suggestion! I tried using the Payments API first, but it only returns 58 order IDs for the given time frame. In comparison, the Orders API returns 568 IDs for the same period. When we total the amounts from just those 58 orders, the numbers are significantly off compared to what’s shown in the Square dashboard.
Are the orders paid for?
Yes, the orders are paid. As I mentioned earlier, the total amount shown on the Square Dashboard is about five times higher than the total I’m getting when summing the amounts from the order IDs returned by the Payments API.
Do you have some examples of orders that aren’t being returned from the Payments API but are in the Dashboard so we can take a look? Also are these offline payments?