Webstore sales by payment method vs. payouts and bank

Files you need

• Webstore sales by payment method: What the store sold in the period per payment provider and method, net of refunds paid back through the provider.For example: Magento 2 sales by payment method, Shopify sales by payment gateway report, WooCommerce payment gateway totals.
• Expected payouts: Payout batches from each provider, with the fees it kept. Name each provider as in the store's sales report (e.g. Stripe, PayPal, Tabby, Cash on delivery).For example: Marketplace disbursement summary, Gateway payouts list, Courier remittance summary.
• Bank statement: Bank statement for the account that receives payouts.For example: Emirates NBD / ADCB / Al Rajhi / SNB statement (CSV or Excel), MT940 converted to CSV.

The Magento 2 / Adobe Commerce connector can fill: Webstore sales by payment method.

What Sawwi checks

• Sold, not yet paid out: The provider paid out less (before its fees) than the store sold through it: payouts still to come, or money missing.
• Paid out more than sold: The provider paid out more than the store sold through it: orders missing from the store export, or another period's sales.
• No payouts from this provider: The store sold through a provider that sent no payout in the period.
• Payouts from a provider with no sales: A payout from a provider the store's report doesn't name. Check the provider's name matches.
• Payout not credited: Provider says paid, but the bank shows no credit.
• Bank credit differs from the payout: The amount differs because of currency conversion or bank charges.
• Unidentified bank credit: Bank credit not linked to any payout.