Shopify refund dates: why your order CSV and payouts disagree

If October looked profitable in Shopify but the payout to your bank was disappointing, the difference may be timing—not a broken dashboard. Orders, refund transactions, processing fees and payouts describe related but distinct events.

Three dates that should not be conflated

Order date is when the buyer placed the order. Refund processing date is when money was returned or the refund was processed. Payout date is when a payment processor sends funds to your bank. A September order can have an October refund and a November accounting adjustment; no single order-date filter necessarily captures all of them.

What to export

Shopify's Orders export can include transaction history; the current export controls offer Export orders or Export transaction histories. Shopify Payments also provides transaction and payout exports, which can include Amount, Fee and Net. Consult exporting orders and payout detail exports.

A defensible reconciliation method

1. Report orders by original date, one amount per order rather than one per product row.
2. Keep all refunds in a separate table with order identifier and refund processing date.
3. Match transaction records to the original order, explicitly identifying unmatched refunds from outside the order period.
4. Keep tax refunded as an explicit known value when possible; otherwise label any proportional estimate.
5. Use processor statement or payout reports to validate actual fees instead of assuming every order pays the same fee.

A small example

Suppose you sold a $100 item on September 28. The customer returned it October 5, and the $100 refund settled in October. A sales-by-order-date September report sees the $100 order and its refund status; a cash-flow October report sees money going out. Mixing the two methods without marking the dates can double-count or misallocate the $100.

What AfterCosts can and cannot do

AfterCosts reads selected Shopify CSVs locally and displays a refund timing bridge where the provided transaction-history format supports it. It does not reconcile bank statements automatically, verify Shopify payments remotely or replace your accountant.

Try the free AfterCosts demonstration and inspect exactly where your data quality is uncertain.

This article is independent educational content, not affiliated with Shopify. Estimates are not accounting or tax advice. Privacy · Terms.