Shopify refund reconciliation
Check that every refund you approved was refunded once, in full, and nothing more.
Load your approved refunds and your Shopify Payments transactions export as CSV. RefundMatch keeps only the refund transactions, adds up partial refunds per order and currency to the cent, and shows where Shopify refunded less, more or nothing, with the source rows behind every number.
Match refunds Try the demo Download CSV templates
- Files never leave your browser. Matching runs on your device; CSV files and your store name are never uploaded.
- First 25 order/currency matches free, with CSV. Month-wide totals always free. No account.
- $49 once per store and month for every match, the full CSV, a printable report and re-matches with corrected exports.
| Approved | #1001, once | $85.00 |
|---|---|---|
| Shopify refunds | $85.00 + $85.00 | $170.00 |
| Refunded above approval | $85.00 |
- Refunded more than approved Two refund rows of $85.00 with no transaction ID are two refunds
- No refund found Approved $60.00, no refund row for #1004 in the file
- Matched #1003: $25.00 + $15.00 approved, $25.00 + $15.00 refunded
- No approval found #1009 refunded $35.00 with no approval in the file
Example figures from the demo; your results depend on your files. A finding describes the two files, not proof of what happened.
Match your refunds
Loading…
How it works
- Pick the store and the month. One project is one Shopify store and one reporting month. The month is an approval cohort: the refunds you approved in that month.
- Export two CSV files. Your approved refunds (
order,approved_date,amount; start from the approved refunds template) and the Shopify Payments transactions export with its own headers (Transaction Date,Type,Order,Payout Status,Amount,Fee,Net, …) or the normalized transactions template. - Match on your device. Only rows whose Type is
refundcount. Orders match on the Order value, trimmed and without a leading#, plus the currency. Partial approvals and partial refunds are added up in exact cents. - Review and send. Every order shows its approvals, its refund rows and the raw lines they came from. Export later in the month again, re-match, and hand the CSV or printable report to whoever issues refunds.
What RefundMatch reports
No refund found and Refunded less than approved
An approved order has no refund row in the transactions file, or its refund rows add up to less than the approved total. A refund approved late in the month may simply be in next month’s export; RefundMatch says when the file ends too soon after the approval.
Refunded more than approved
The refund rows add up to more than what was approved. Equal amounts are separate refunds: two $85.00 refund rows are $170.00 unless an explicit transaction ID shows the same transaction twice.
No approval found
A refund in the month for an order that has no approval anywhere in your approvals file. It may have been approved somewhere the file does not cover; it is listed, not judged.
Invalid or ambiguous
Rows with missing orders, dates that are not YYYY-MM-DD, numbers that are not plain decimals (45.OO, 1.200,50), refund-related types that are not refunds, or an explicit ID that repeats with different content. They are flagged and excluded from confirmed totals, never guessed.
Matched
The refund rows for the order and currency add up exactly to the approved total.
Strict on purpose
- Payout status is not refund status. A refund on a pending payout is still a refund, and a paid payout proves nothing about an approval. Payout columns are shown for reference only.
- Charges, adjustments, chargebacks and other non-refund types are never counted. Every source row is kept and shown next to the order it belongs to.
- All money math uses exact integer cents. Text from your files is shown as plain text, and the CSV export neutralizes spreadsheet formulas.
Pricing
Free
$0
- Unlimited matching on your device
- Month-wide totals and result counts
- The first 25 order/currency matches in detail, plus a CSV of those 25
- Demo store, sample files and CSV templates
Full month report
$49 USD, once per store and month
- Every order/currency match on screen and in the CSV
- Printable report with the settlement cutoff explained (print or save as PDF)
- Re-match the same store and month with corrected or later exports
- No subscription; pay with card (Square) or PayPal
A purchase is bound to the store and reporting month of its project through a one-way SHA-256 fingerprint computed in your browser. Another store or month needs its own purchase.