Shopify Payments payout reports are cryptic. Discounts, refunds, and Shopify fees create gaps between 'Gross Sales' and what hits your bank. Multi-currency stores multiply the confusion with FX fees buried in transaction costs.
Your first run is free - no card.
Get a ready-to-use file with everything you need
Payout vs bank deposits, shortage/excess
Orders that never reached the bank + reason
Contracted vs charged, overcharge flags
Batch→transaction drilldown, CSV export
Real outcomes for your Shopify business
Recover missed cash: Find payout mismatches & hidden fees-often meaningful dollars back each month
Save your weekend: 4-8 hours back each month from manual reconciliation
Be audit-ready: Line-by-line trail you can share with your accountant
Reduce audit risk: Complete transaction-to-payout audit trails and mismatch documentation
What this Excel Decision Kit tracks from your Shopify data
Match orders to exact payout batch ID from Shopify Payments
Separate Shopify subscription, transaction fees, and payment processing fees
Track how automatic/manual discounts reduce payout vs. order total
Identify refunds deducted from which payout batch
Handle FX fees and presentment currency vs. payout currency
From order totals to actual deposits, tracking every dollar
Definition: Transactions where expected payout ≠ actual deposit
Source: Order data vs. gateway payout reports
Granularity: Per-transaction, grouped by payout batch
Definition: Sum of all mismatched amounts + unexplained fee differences
Source: Expected fees vs. actual fees charged
Granularity: Per-payout period (weekly/monthly)
Definition: (Actual fees - Expected fees) ÷ Total revenue × 100
Source: Gateway fee schedules vs. actual charges
Granularity: By gateway, by transaction type
What makes Shopify different and how we handle it
financial_status: paid/refunded/partially_refunded
gateway: shopify_payments/stripe/paypal
payout.id: batch identifier for reconciliation
Shopify-specific setup in 7 steps
Authorize Spreadsheet Broccoli to read your Shopify orders and payout data (read-only OAuth2)
Choose payout period to reconcile (we recommend starting with last month)
One-time setup: enter your Shopify plan tier and payment gateway fees for accurate comparison
Click 'Generate' - we match every order to its payout batch in ~30 seconds
Excel sheet highlights discrepancies with root cause categories and $ amounts
Download complete transaction-to-payout trail ready for your accountant
Optional: Get weekly email when mismatches exceed your threshold
Start automating your Shopify reporting today and save hours every week.
Our report recipes are designed by e-commerce experts who understand what metrics matter most for your business decisions.
Connect your platforms in minutes, not hours. Our OAuth2 integration makes setup secure and simple.
Reports are delivered in perfectly formatted Excel files that work seamlessly with your existing workflow.
Our report recipes are designed to provide actionable insights and recommendations for your business.
Common questions for Shopify users
Shopify deducts transaction fees, refunds, chargebacks, and sometimes holds funds for fraud review. Our reconciliation breaks down every deduction so you see exactly where money went.
We automatically detect your payment gateway and apply the correct fee structure. Multi-gateway stores get separate reconciliation tabs per processor.
We handle presentment currency (what customer pays) vs. payout currency (what you receive) and show FX fees separately in the breakdown.
Yes, as long as Shopify still has the data (typically 90+ days). Historical reconciliation helps identify recurring fee issues.
Yes - map your custom NET 30/60 terms in settings and we adjust expected payout timing accordingly.
Shop Pay installment payouts are tracked separately with their unique fee structure and timing clearly documented.
"We were losing $800/month to hidden Shopify fees we didn't know existed. The reconciliation Excel showed us exactly which transaction types were leaking money."
Sarah Chen
Finance Director, Urban Apparel Co.
$9,600 annual savings identified
2 hours weekly saved on reconciliation
Other decision kits for your Shopify data
Connect your Shopify account and generate your first reconciliation in under 5 minutes. First report free.
No card • Keep the file forever • Cancel anytime