Analytics
π Built for Sidekick
β‘ Sidekick does this for you
shopify
sidekick
analytics
payouts
Report Payout Reconciliation
Match each Shopify Payments payout to the underlying orders, fees, and refunds so the deposited amount ties out.
π Prompt
Reconcile my Shopify Payments payouts for [LAST 30 DAYS / LAST MONTH]. Per payout: Payout date and amount deposited Gross order revenue included in the payout Total processing fees deducted Total refunds deducted Any chargebacks or adjustments included Reconciled total = gross revenue β fees β refunds β adjustments (should match the deposited amount) Flag: Any payout where the reconciled total doesnβt match the deposited amount, with the gap size Average processing fee as a % of gross revenue across all payouts in the period Total refunds and chargebacks deducted from payouts this period, as a standalone number Output format: Table: payout date, deposited amount, gross revenue, fees, refunds, adjustments, reconciled total, match/mismatch flag Deliverables: The table A summary line: total deposited, total fees paid, total refunds processed, over the full period Call out any mismatched payout by name/date so it can be investigated before books are closed for the period
How to Use
- Copy the prompt above
- Open Shopify Sidekick in your Shopify admin
- Paste the prompt and replace the bracketed placeholders with your details
- Review Sidekick's response and apply the suggestions