← Shopify Reporting Community
Payouts & Transactions

How do I retrieve the payout amount for a whole month of sales in bulk when payout timing differs per order?

✓  Report Pundit Answer
Updated
QUICK ANSWER

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.

Main Question

How do I retrieve the payout amount for a whole month of sales in bulk when payout timing differs per order?

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.

Was this answer helpful?

Follow-up questions

COMMUNITY COMMENTS

Comments

Approved merchant comments appear here after review by the Report Pundit team.

No items found.

Leave a comment

Comments are reviewed by the Report Pundit team before they appear publicly. Your email will not be displayed.

Thanks — your comment has been submitted for review. It will appear on this answer page only after Report Pundit approves it.

Oops! Something went wrong while submitting the form.