Order# and payout reference on the same report?

[suzanneharte]

I'm trying to find a report that shows me orders and the corresponding payout. As it is I can't find even a unique identifier to pull the two together in Excel. Orders don't show what batch they're in, and Payouts don't show which orders are included.

How do y'all reconcile cash to sales if you can't connect the sales to the cash?

Shopify has an ugly business model where they provide the barest skeleton of a POS and charge extra for the services and apps that it should have included as default--like basic financial statements--is this one of those situations?