Use the Square Orders API search endpoint to retrieve and reconcile closed orders for a Square for Restaurants location over a specified date range

Steps

1. Authenticate to the Square API using a valid OAuth token for the merchant and confirm the token has Orders:Read permission
2. POST to /v2/orders/search with a query object containing a filter that specifies the location_id, a date_time_filter with the created_at range for your target period, and a state_filter set to COMPLETED (or CANCELED if reconciling voids)
3. Parse the response array of order objects, extracting total_money, tax_money, tip_money, and the fulfillments array for each order to build your reconciliation dataset
4. Handle pagination by checking for a cursor field in the response and re-issuing the search request with the cursor value in the next request body until no cursor is returned
5. Cross-reference the order total_money values against the corresponding payment records by querying /v2/payments with the same date range and matching on order_id to verify tender amounts and tip allocations
6. Export the reconciled dataset to your reporting system, flagging any discrepancies between order totals and payment totals for manual review