How do I track Shopify orders where I still owe a refund?

Shopify shows an owed refund on the individual order (it displays "refund owed to the customer" when a refund is saved but not completed), and Shopify Payments flags failed payouts as "Refund pending" with a banner on the Orders page. What it does not give you is one filterable, store-wide list of every order still carrying an owed or failed refund. For that, a transaction-level report that isolates pending refund status and totals the amount owed does the job.

A refund you have promised but not paid out is a real liability, not a rounding error. Missing one means a customer waits, your cash-flow picture is wrong, and reconciliation gets messy. Shopify's native views are per-order or, for Shopify Payments negative balances, a single banner total. Neither gives you an ongoing, filterable ledger of what is outstanding across the store.

A dedicated report closes that gap by reading individual transactions, both sales and refunds, along with each refund's status. Status is what separates a fully processed refund from one still pending, so the report can match each pending refund back to its original sale and calculate the amount still owed, whether the refund is full or partial. It can be dated by order date, transaction date, or refund initiation date (refund initiation date is usually the most useful for seeing how long a customer has waited), filtered to pending or outstanding refunds only, grouped by customer, order, or gateway, sorted by amount owed, and scheduled to your inbox. Report Pundit builds this to your requirements at no extra cost; contact the team with the fields and grouping you want.