Retrieving a full month of Shopify payouts is hard because orders settle on different dates. Native Payouts filtering gives the totals, but matching payouts to specific orders across gateways needs third-party reconciliation reporting.
Official answer
Shopify groups settled transactions into payouts by settlement date, not order date, so a month of orders never maps to a single deposit. In Shopify admin, open Finances then Payouts and filter by date range to pull every payout that landed in the month, each already net of fees, refunds, and adjustments. Export that list for the month's true cash total. Tying those payouts back to the specific orders that generated them is where native reporting stops.
Shopify's own answer to the per-order timing problem is the payout reference: each order in the Finances reports carries the payout ID it settled into. Matching a full month of orders to their payouts by hand through those references is accurate but slow, and it does not roll up cleanly when more than one gateway is involved, since PayPal, Stripe, and others each settle on their own schedule with their own fee logic.
Report Pundit's Payout Report handles that join automatically. It ties each payout to its underlying orders, transactions, and fees in one export, and can run by payout date for a chosen day, week, or month, so a month of sales reconciles against what actually reached the bank without chasing payout timing order by order. For stores on multiple gateways, the report can be configured to match each provider's payout structure so everything reconciles in one place.
Questions & Solutions
Explore Shopify reporting questions and expert solutions from Report Pundit. Ask a follow-up question, and we'll notify you by email once your answer is published.
Ask a Follow-up Question
Need more clarity? Submit your follow-up question below, and our team will review it and provide a solution.
Thanks — your comment has been submitted for review. It will appear on this answer page only after Report Pundit approves it.