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
Run in Sidekick
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

  1. Copy the prompt above
  2. Open Shopify Sidekick in your Shopify admin
  3. Paste the prompt and replace the bracketed placeholders with your details
  4. Review Sidekick's response and apply the suggestions