Okiela LogoOkiela
FeaturesHow It WorksProfit MapPricingBlogLive on Product Hunt
Profit Leak Map
Reporting / Excel

Shopify dashboard does not match bank payouts

Community signal

The store dashboard shows gross sales, but the bank receives sales minus fees, refunds and reserves, so the two never agree.

In real life: The dashboard says one revenue figure; the payout is noticeably lower after processing fees and refunds.

Shopify / DTC

Data you need

  • requiredPayout report. Gross, fees, refunds, adjustments, net.
  • requiredOrder export for the period. To tie payouts to sales.

Formula

Payout reconciliation
Net Payout = Gross Sales - Fees - Refunds - Reserves/Adjustments

Each line explains part of the gap.

Key insight

  • The gap is fees, refunds and reserves, not an error.
  • Reconciling once builds trust in every later number.

Action checklist

  1. 1Pull the payout report · easy · 15 min
    The source of the real cash figure.
  2. 2Bridge dashboard sales to net payout · medium · 45 min
    List each deduction.
  3. 3Use net, fee-aware numbers for decisions · easy · ongoing
    Stop deciding on gross.

Money impact · Improve clarity

Explains the dashboard-to-bank gap so decisions use the real cash figure, not gross sales.

Common mistakes

  • Treating dashboard gross as cash.
  • Assuming the gap is a mistake to chase.

How Okiela helps

Fee + refund reconciliationlive

Okiela accrues fees and refunds so its profit ties toward the payout.

Trust & sources

  • Community signalDashboard-vs-payout mismatch is widely reported

Last reviewed 2026-06-22 · Confidence 4/5

Related leaks

Platform fees are unclearExcel profit tracking is breakingRefunds distort profit
Request a free Profit Leakage AuditUpload a sample file
Okiela LogoOkiela

Profit clarity for Shopify founders. See true profit clearly — without spreadsheet chaos.

Okiela - Profit & pricing insights in 30 seconds, not 30 hours | Product Hunt

Product

  • Features
  • Pricing
  • FAQ
  • Roadmap

Free Tools

  • Profit Leak Map
  • Profit Calculator
  • Free Profit Audit

Company

  • About
  • Blog
  • Help Center
  • Careers
  • Contact

Legal

  • Privacy Policy
  • Terms of Service
  • Security
  • GDPR
  • Billing Promise

© 2026 Okiela. All rights reserved.

Made with care for ecommerce founders

|Featured on Product Hunt