What it is
A retailer that accepts returns recognizes revenue net of the returns it expects. The expected amount is a refund liability, and the cost of the goods expected to come back is a separate asset. This workbook builds both from the return history, month by month, and applies the rate to sales still inside the return window.
The Return history tab gives the weighted average rate and lets you exclude unusual months with a reason. The Reserve tab adds a rate override and a qualitative adjustment, and calculates the liability and the recovery asset. The True-up tab compares last period’s reserve with actual returns and ties to the ledger.
When to use it
- At each period end for retailers, e-commerce sellers and manufacturers that sell with a right of return.
- During the audit of revenue, when the returns estimate is a significant judgment.
- After a change in return policy, product mix or sales channel.
What’s inside
- Return history tab: 36 months of sales and final returns with the return rate and an include flag
- Reserve tab: rate used, refund liability and asset for the right to recover goods
- True-up tab: prior reserve against actual returns with an investigate trigger
- Ledger tie of the liability and the recovery asset
Standard cited
This template follows ASC 606. It is written in our own words, except for phrases the standard requires the document to contain, with [bracketed placeholders] for client details, amounts in USD and dates as MM/DD/YYYY. Check it against the current standard and your firm’s methodology before use.
Questions
Why are the liability and the asset not netted?
The refund liability is the revenue side and the right to recover goods is the cost side. The standard asks for them separately, so the balance sheet shows both.
Can I exclude a month with a high return rate?
Only for a documented reason, such as a recall or an unusual promotion. Excluding a month only because its rate was high is bias, and the file should show the reason for every excluded month.
What does the true-up test show?
Whether last period’s estimate was close to what customers actually returned. A large difference in either direction means the rate needs another look, and a persistent gap points to a biased estimate.
Related templates
- Retail Gift Card Liability and Breakage Schedule
- Audit Program: Retail and E-commerce
- ASC 606 Revenue Recognition Schedule
- Cutoff Testing Workpaper (Sales, Purchases, Inventory)
Last updated 11/05/2026. All free templates.