Each order in Shopify is automatically created a Sales Receipt in QBO via integration with SOS.
The current process of reconciling the Shopify and TikTok payouts to the sales receipts in QBO is by matching them to each sales receipt. However, a surge in Retail orders has made the reconciliation very difficult since you have to identify many sales receipts included in one payout.
What is the best way to match or reconcile the Shopify payouts with the Sales Receipts for each order in QBO?
We would love to explore plug-ins or any process to streamline this concern.
I would stop trying to match one payout directly to individual QBO sales receipts in the bank feed. Treat each Shopify/TikTok payout as a payout-level reconciliation first, then bridge it back to orders/receipts.
The read-only fields I would line up are: payout ID, payout date, net deposit, gross sales, fees, refunds, adjustments, order IDs in the payout, Shopify transaction IDs, QBO sales receipt IDs, and the bank deposit reference. Once those are side by side, it is much easier to see whether the problem is missing orders, fees/refunds posted outside the receipt, timing differences, or simply a many-orders-to-one-deposit matching issue.
I would not post real order numbers, customer data, bank details, or live payout amounts publicly. A fake-row example or just the column headers is enough to map the workflow safely.