01
Store activity → Shopify net payout
Bring together payout detail for refunds, chargebacks, fees, and adjustments before deciding how that activity produced the net payout.
Shopify payout review kit
Make payout questions easier to hand off.
Ecom Ops Kits turns the messy gap between Shopify activity, a net payout, and a bank deposit into a focused review packet for your bookkeeper.
Available now — US$29 on Gumroad
View the US$29 kit on GumroadIncludes an Excel workbook, plain-English guide, worked synthetic examples, and a month-end checklist. Backed by a 30-day money-back guarantee.
Lower-cost workbook-only edition
Choose the editable workbook alone for US$9.
One editable .xlsx workbook separates Shopify payout activity from the bank-deposit check before bookkeeper review. It includes worked synthetic examples and a checklist tab.
View the US$9 workbook on GumroadThe standalone PDF guide and standalone checklist are only in the US$29 full kit. Manual entry only; no automatic imports or connections to Shopify, accounting software, or a bank. Shopify Payments only; keep rows paid out by PayPal or another third-party processor separate, while retaining any PayPal Wallet row proved inside the actual Shopify Payments payout. Delete the bundled synthetic sample rows before a real handoff. Differences up to 1.00 in the workbook currency stay visible but are labeled Ready. Use one workbook copy per currency. Requires an app that can open and recalculate Excel formulas; compatibility with Google Sheets, Apple Numbers, mobile apps, and browser-only editors is not verified.
The starting point
Keep two checks separate.
02
Shopify net payout → bank statement
Treat a remaining bank difference as its own question, supported by payout status, transfer timing, destination account, or bank evidence.
Practical guide
Follow the payout from either end.
Use a manual reverse lookup to narrow nearby Shopify Payments payouts by date, net amount, currency, destination account, and available transfer reference—without forcing an uncertain match.
Find a Shopify payout by bank reference or deposit amount →Start from a known Shopify Payments order, follow its transaction into the payout batch, and compare the payout—not the order total—to the bank.
See the Shopify order-to-payout process map →Close a period with the Shopify Payments activity report: explain balance movement first, then route sales and deposit questions to the right Shopify view.
Use the Shopify Payments activity report at month-end →Reconcile one Shopify Payments transaction export by confirming its payout scope, preserving signed Net values, and only then checking the bank deposit.
Reconcile a Shopify payout CSV to a bank deposit →Stop comparing an order-based sales total directly with one net payout. Separate report scope, Shopify Payments balance activity, the payout, and the bank deposit before investigating the remaining difference.
Understand why a Shopify payout differs from total sales →Walk through invented charges, fees, a refund, a dispute, a reserve, and an adjustment as they roll into an internally tied synthetic net-payout total before the separate bank check.
See a worked Shopify payout breakdown example →If the Shopify Connector is configured for this store and QuickBooks company, follow its current sequence: review imported activity, confirm the net payout, then match the connector-created Deposit instead of adding a second deposit. Otherwise, use the manual payout CSV workflow.
Reconcile Shopify payouts in QuickBooks Online without adding the deposit twice →Separate Shopify Payments from transactions actually paid out by PayPal before looking for the payout in QuickBooks Online, while retaining PayPal Wallet rows proved inside the Shopify Payments payout. The guide also covers Intuit's current limitation for Shopify-originated PayPal transactions.
Route Shopify Payments and PayPal Express Checkout separately in QuickBooks Online →When an accounting sync does not match Shopify or the bank, preserve the native payout, activity report, bank line, and current connector record before deleting, replaying, adding, or recategorizing anything. Then locate the first failed equality and hand off that evidence.
Use the Shopify accounting sync mismatch checklist →Free browser tool
Compare saved sitemap snapshots.
Check added, removed and metadata-changed URLs before and after a release. Compare XML locally and download a JSON report.
Open the free sitemap comparison →What the first kit is built to support
A cleaner bookkeeper review packet.
- One payout-by-payout view of the numbers already in your records.
- A visible variance instead of a forced match.
- Short, stage-specific questions for the person approving treatment.
A useful boundary
Review support only — not accounting, tax, or ledger advice.
The kit is designed to organize evidence and unresolved questions. A qualified bookkeeper or accountant makes the final accounting, tax, and ledger decisions.
Email updates
Get future Ecom Ops Kits notes by email.
Notes on clearer payout review and bookkeeper handoffs. Confirm your email to subscribe.