Galico All articles
Finance & Cashflow

The Return Provision: A SKU-Level Cash Buffer for UK Online Retailers

Galico
The Return Provision: A SKU-Level Cash Buffer for UK Online Retailers

Photo: UK ecommerce warehouse returns parcels January refunds stock photo, via as2.ftcdn.net

Returns are often treated as a customer-service matter until January, when the cash leaves the business. For a UK online seller, the refund is only one line in the cost of a return. Payment processing fees may not be returned in full; outbound delivery is rarely recovered; the return label, warehouse labour, repacking and the occasional write-off all follow the parcel back. A returns reserve turns those scattered costs into a planned cash buffer.

A reserve, not an accounting provision

A returns reserve is a cash-management tool. It is not a substitute for an accounting provision, and it does not replace statutory records. The purpose is simpler: set aside enough liquid cash, or undrawn facility headroom, to meet the expected cost of returns from a defined trading period without disturbing stock purchases or payroll.

For a UK online retailer, the reserve should be held separately in the management accounts and reviewed alongside the cash-flow forecast. It should not be used to fund new stock, and it should not be released simply because January has passed. Release it only when the relevant return window has closed and refunds, courier charges and restocking costs have been processed.

Estimate return rates by SKU before peak

Start with twelve months of dispatch and return data. If twelve months are not available, use at least six and treat the result as provisional. Calculate the gross return rate as returned units divided by dispatched units. Then split the rate by reason: sizing or fit, damage in transit, not as described, late delivery, changed mind, and courier failure. The mix matters because a sizing return may be resaleable, while a damaged return may become a write-off.

New products need a proxy. Use the closest existing category, adjust for price band and presentation, and mark the estimate as unproven. For the 2026 peak season, weight the estimate towards the months in which the product will actually sell. A summer dress and a winter coat do not carry the same return profile simply because both are apparel.

The Galico returns reserve worksheet

Build one row per SKU. The worksheet should be simple enough to update weekly and detailed enough to expose the products that consume cash after the sale.

Column What to enter
SKU Product identifier
Peak units Forecast dispatched units for the peak window
Expected return rate SKU rate, or proxy rate with a note
Returned units Peak units multiplied by expected return rate
Refund value Returned units multiplied by average selling price
Payment fee lost Non-recoverable processor fee per refund
Return courier Label and collection cost per return
Restock labour Minutes multiplied by hourly cost
Damage write-off Expected proportion beyond resale
Reserve per return Sum of the cost lines
SKU reserve Reserve per return multiplied by returned units

The total of the SKU reserve column is the cash buffer for the peak trading period. Express it also as a percentage of forecast peak revenue. That percentage is easier to monitor than a single large number and can be compared with prior seasons.

Four cost lines the refund does not show

First, payment fees. Some processors return a portion of the fee when a transaction is refunded, and some do not. Use the actual statement, not an assumption. Second, outbound delivery. A refunded order rarely returns the original postage cost to the seller. Third, return logistics. The label, collection, sorting and temporary storage all carry a cost even when the item is resaleable. Fourth, value erosion. Repacking, cleaning, seasonal markdown and damaged stock reduce the amount eventually recovered.

VAT treatment can vary by circumstance. The reserve should be built on net cash cost and checked with an adviser where the position is unclear. Do not double count VAT if the business accounts for it separately.

Set the reserve and release it deliberately

Hold the reserve as cash or as committed undrawn headroom. If cash is tight, a facility can serve the same purpose, but the drawdown terms should be tested before peak, not in January. Review the reserve weekly during the return window. Compare actual returned units and costs with the worksheet, and update the SKU rates as evidence arrives.

Release the reserve only in stages. First, after the stated return period has ended. Second, after refunds and courier invoices have been matched. Third, after the remaining stock has been assessed for resale. Any surplus can return to general cash, but the SKU rates should be updated before the next peak forecast.

A rule for repricing or delisting

A product deserves attention when its return-adjusted contribution is weak. Calculate contribution after returns as net selling price minus cost of goods, outbound delivery, payment fees and expected return cost. Then apply a simple rule.

If a SKU has a return rate above 20% and a return-adjusted contribution margin below 10% for two consecutive review periods, reprice it, change the listing, or change the courier. If the return rate exceeds 35%, or the return-adjusted contribution is negative, delist the product until the root cause is fixed. The thresholds are starting points, not universal truths, but they force a decision before a slow-moving product absorbs another season of cash.

A January routine, planned in November

Before the 2026 peak fulfilment cut-off, complete the worksheet, agree the reserve figure and separate the cash. After January, reconcile actual returns against the reserve and record the variance by SKU. The exercise is not about predicting every parcel. It is about ensuring that the refund wave arrives as a managed cash event rather than a surprise.

All Articles

Related Articles

The Terminal’s Own Arithmetic: A Merchant Fee Audit for UK Card Statements

The Terminal’s Own Arithmetic: A Merchant Fee Audit for UK Card Statements

The Ledger Behind the Withdrawal: Director Advances and the 2026 Year-End File

The Ledger Behind the Withdrawal: Director Advances and the 2026 Year-End File

The Discount That Eats Itself: Testing a Bulk Offer Before the Stock Arrives

The Discount That Eats Itself: Testing a Bulk Offer Before the Stock Arrives