Returns and Refunds Tracker

A return costs more than the refund. You may also pay for return shipping, handling and repacking, lose fees the platform does not give back, and write off goods that cannot be resold. Spread over many orders this is a large, invisible cost, and claims against suppliers for faulty goods are often forgotten until the claim window has closed.

Log each return with its date, order, channel, product, quantity, cost and selling price, the reason, and what happens to the goods: restock, write off, or claim from the supplier. Add the refund, its status, return shipping, handling and fees you could not recover. The app works out the net cost of every return and reports it by product, channel, reason, supplier and month. Enter units sold per product and it shows the return rate and flags products above the rate you choose. The Supplier claims tab lists what is still to file, what is filed and what credit has come back, with days left in your claim window.

What is inside:

• Log returns, Reports, Supplier claims, Settings and How it works tabs
• Return reasons and channels are lists you edit
• Import returns and units sold from CSV, export everything to CSV
• A worked example of 10 invented returns and EXAMPLE-DATA files

The claim window and the alert rate are settings: use your supplier agreement for the first. The app does not contact suppliers or customers and does not give legal advice on refunds or consumer rights. It is not tax or legal advice, not an FTA-approved system, and no platform or courier endorses it.

How it differs from the stock and reorder workbooks in the catalogue: those count stock. This tracks why goods come back, what each return truly cost and which claims to chase.

Tested: every calculation was compared with an independent Python (Decimal) calculation on randomised cases, CSV edge cases (quotes, commas, Arabic text, byte order mark) were run through the importer, and the screens were driven in a headless Chromium browser at phone and desktop widths. It has not been tested on a real phone, in Safari, Firefox or Edge.