Download the RMA form template
Both files carry the same nine fields. The PDF is for a counter, a warehouse desk or a customer who prefers paper; the Excel workbook adds a second sheet that logs every RMA number issued, so a small operation can run returns without any software at all.
If you want the reasoning behind each field, the RMA guide explains what a return merchandise authorisation is, how the number is generated and what the process looks like from request to resolution.
What a completed RMA form looks like
The nine fields once a warranty return has been submitted and approved: order #1042, one faulty drill battery out of a two-line order, coded as a warranty fault with photos and a serial number attached, and the RMA number issued.
- 1Order identifier The order number from the original purchase, matched loosely so punctuation does not block the customer.
- 2Customer email Verified before any order detail is shown; on paper, checked against the order.
- 3Items being returned Line by line with quantity, never free text, so the log can be reported on.
- 4Return reason A code from a fixed list: change of mind, damaged in transit, wrong item, faulty, warranty.
- 5Customer-reported fault The customer's words, kept separate from what the technician later finds.
- 6Photos and video Required for damaged, faulty and warranty reasons; optional for change of mind.
- 7Serial number For anything with a manufacturer warranty; re-checked when the item is received.
- 8Preferred resolution Refund, exchange, store credit or repair quote, limited to what the policy allows for the reason.
- 9Customer notes Free text for context, read by people and never reported on.
Blank RMA form template. Free to use and adapt; no email address required.
RMA number tracking: how to number and log returns
An RMA number is the identifier a merchant issues when a return is approved. It ties the customer's parcel to the order, the reason and the decision, and it is what the warehouse looks for on the box. A workable numbering scheme has three parts: a prefix that says what kind of case it is, the order number, and a suffix for the item or the attempt, for example RMA-1042-A. Sequential numbers with no order reference work too, but they make the log harder to reconcile against the store.
The tracking log in the Excel workbook has one row per RMA number with the columns a small operation needs: RMA number, date issued, order number, customer, items and quantity, reason code, current status, carrier and tracking number, date received, condition on receipt, resolution, and date closed. Status is the column that matters most. Keep it to a fixed list (issued, in transit, received, inspected, resolved, closed) so a glance at the sheet shows where every return is.
The failure mode of a spreadsheet log is not the numbering; it is the status column going stale once more than one person updates it. That is the point at which an RMA management system earns its keep: the status changes when the parcel is scanned or the refund is issued, not when someone remembers to edit a cell. The RMA process section of the guide walks through each state.
Issue the number at approval, not at request. A request that is declined should not consume an RMA number, or the log fills with cases that never shipped.
Put the number on the label and the packing slip. Receiving is where an unnumbered parcel costs the most time.
One row per item when resolutions differ. If one item is refunded and another replaced, split the row (RMA-1042-A and RMA-1042-B) rather than writing two outcomes in one cell.
Close the row. A log where nothing is ever marked closed cannot tell you how long returns take, which is the one number worth knowing.
When a form stops being enough
A printable form and a log sheet run a low-volume operation well. Three things tend to break them: volume (past roughly 100 returns a month the sheet is the bottleneck), evidence (photos and serial numbers cannot live in a cell), and warranty or repair work, where a return has a coverage decision, a diagnosis, parts and labour and possibly a supplier claim attached, none of which fit a status column.
At that point the form becomes a self-service returns portal that captures the same nine fields from the customer, verifies the order and email itself, and issues the RMA number automatically. Choosing that software is a separate decision; the returns management software buyer's guide sets out what to look for, and the Shopify returns app comparison lists the main options with entry prices.
Frequently asked questions
Is the RMA form template free?
Yes. Both the PDF and the Excel workbook are free to download and adapt, with no email address or sign-up. Add your logo, your policy text and any fields specific to your products.
What is an RMA number?
A return merchandise authorisation number is the identifier a merchant issues when it approves a return. It links the returned parcel to the original order, the reason and the decision, and it is what the warehouse uses to match a box to a case. A common format is a prefix, the order number and an item suffix, such as RMA-1042-A.
How do I track RMA numbers?
At low volume, a log sheet with one row per RMA number and a fixed status list (issued, in transit, received, inspected, resolved, closed) is enough; the Excel workbook here includes one. Once several people update it, or evidence and warranty decisions need to sit on the record, an RMA management system that updates status from scans and refunds is the reliable option.
Does Shopify generate RMA numbers?
Shopify records returns against an order but does not issue a separate RMA number in the way a returns system does. Merchants either log a number themselves, as this template does, or use a returns app that generates one, prints it on the label and tracks it through receiving.
Can I use this template for warranty claims?
For a simple claim, yes: choose the warranty reason code, attach photos and the serial number, and note the preferred resolution. Claims that involve diagnosis, repair, parts and labour or a supplier credit need fields the form does not have; the warranty management guide on this site covers what those cases require.
