SKU Profit Analyzer: profit for every product and channel, with fixes

Fees change often and differ by category and price, so any rate we filled in could be wrong for your product. Copy the fee % and fixed fee from your own rate card into the sheet, or type them once per channel under "Fees by channel". The Try an example button fills in made-up rates only to show how the tool works.

A return is a parcel the buyer received and sent back. An RTO (return to origin) never reached the buyer, for example because it was refused or the buyer could not be reached, and goes back to you. Both mean no sale, both shipping legs and sometimes stock you cannot resell, so the tool takes one rate for both per row. To see why your products come back, use the Returns and RTO Reason Analyzer.

Profit rises in a straight line with the price, so the break-even price is the costs that do not change with the price divided by what each rupee of price leaves after GST, the fee % and ads charged as a % of sales. For the made-up palazzo at ₹299 in the example, about ₹238 of costs per order sent and about 73 paise left from each rupee give a break-even price of ₹328. The target price works the same way, keeping your target margin as profit.

Ad spend per order is best: your total ad spend for the SKU in a month divided by all its orders in that month. If you only have a percentage, type ad spend divided by total sales (what Amazon Ads calls TACoS) in the "Ads % of sales" column. The ACoS from an ad report divides spend by ad sales only, so using it counts every order as an ad order and shows a higher cost.

Under section 16 of the CGST Act, a registered person can take input tax credit on goods and services used in the business only when the conditions are met, such as holding the supplier's tax invoice and the supplier reporting it. A person who is not registered cannot claim it. Tick "I claim that GST back" only if your CA confirms it; untick it to count that GST as a cost.