> ## Documentation Index
> Fetch the complete documentation index at: https://docs.upstackdata.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Refund Amount (by Refund Date): Track When Refunds Are Issued

> Track refund amounts by the date refunds were issued. Monitor cash flow impact, identify refund spikes, and understand when returns actually process.

<Tip>
  Refund amounts attributed to the date the refund was issued, showing when money actually left your account rather than when the original order was placed.
</Tip>

## Formula

<Info>
  **Refund Amount (by Refund Date)** = **SUM** ( Refund Value ) **GROUPED BY** Refund Issue Date
</Info>

| Metadata        |                             |
| --------------- | --------------------------- |
| **Type**        | Currency                    |
| **Data Source** | [Shopify](/sources/shopify) |
| **Aggregation** | Sum                         |

***

## Example

Your store processed **\$18,450 in refunds** during March, despite variable order volumes:

| Date     | Refunds Issued | Amount  | Notes                      |
| -------- | -------------- | ------- | -------------------------- |
| March 5  | 23             | \$2,890 | Post-February sale returns |
| March 15 | 47             | \$8,340 | Batch processing day       |
| March 28 | 31             | \$4,120 | End-of-month spike         |

The March 15 spike indicates a batch processing event rather than a sudden quality issue.

***

## How It Works

This metric groups refunds by when they were processed, not when orders were placed. A January order refunded in March appears in March's totals. This shows the actual cash flow impact of refunds on any given day or period.

***

## When to Use

| Scenario                     | Action                                              |
| ---------------------------- | --------------------------------------------------- |
| Cash flow forecasting        | Predict when refund outflows will hit your account  |
| Refund processing monitoring | Detect unusual spikes in daily refund activity      |
| Operations planning          | Staff appropriately for high-refund processing days |
| Reconciliation               | Match refund totals with bank statement debits      |

***

## Related Metrics

| Metric                                                                                             | Relationship                              |
| -------------------------------------------------------------------------------------------------- | ----------------------------------------- |
| [Refund Amount (by Order Date)](/reference/metrics/orders/adjustments/refund-amount-by-order-date) | Refunds attributed to original order date |
| [Refund Amount](/reference/metrics/orders/adjustments/refund-amount)                               | Total refund amount                       |
| [Refund Count](/reference/metrics/orders/adjustments/refund-count)                                 | Number of orders with refunds             |
| [Net Revenue](/reference/metrics/orders/revenue/net-revenue)                                       | Gross revenue minus refunds and discounts |

[See all Adjustments metrics →](/reference/metrics/orders/adjustments)