Business

Ad spend deducted from a marketplace payout: tracking it as a cost

Separate sponsored-ad charges from commission and shipping on your marketplace payout, work out ad cost per sale and see if each product still earns after ads.

Editorial illustration for Ad spend deducted from a marketplace payout: tracking it as a cost

When a marketplace takes ad charges out of your payout, record them on their own line, apart from commission and shipping. Then divide each product's ad charge by the units it sold to get ad cost per sale, and subtract that from the profit the product makes before ads. If the result is below zero, the product is losing money once advertised.

Why keep ads separate from commission and shipping?

Commission and shipping come with every sale and are hard to change. Ad spend is a choice you can raise, cut or stop. If all three are lumped together as marketplace charges, you cannot tell whether a slow month came from higher ads or from higher returns. A separate ad line also shows how much of your sales you are effectively buying.

How do you split the payout lines?

On your payout statement, find the lines for sponsored ads or promotions and copy them to a sheet with the date, the product if it is named, the amount and the period. Check the statement labels, because names differ and a promotional charge may not be the same as a commission. Where ad charges are only shown in an ad dashboard, take the amount from there and check it against the deduction.

What is profit before ads?

Take a made-up product sold at ₹599. Commission is ₹90, shipping ₹70 and cost of the product ₹280.

  • 599 - 90 - 70 - 280 = ₹159 before ads.
  • That ₹159 is the most you can spend on ads per sale and still break even.

Does the product earn after advertising?

Now look at a month for two made-up products.

ItemProduct 1Product 2
Units sold5020
Profit per unit before ads₹159₹120
Ad charge in the month₹3,500₹3,000
Ad cost per unit sold₹70₹150
Profit per unit after ads₹89-₹30
Total for the month₹4,450-₹600

Product 1: 50 x 159 = 7,950, minus 3,500 = ₹4,450. Product 2: 20 x 120 = 2,400, minus 3,000 = -₹600. The second product is losing ₹30 on every unit once the ad charge is counted, even though it looks profitable before ads.

What decisions come out of it?

  • If ad cost per sale is close to the profit before ads, pause or lower the spend.
  • If a product earns well after ads, check whether more spend gives more sales at similar cost.
  • If sales fall as soon as you stop, treat the ads as a permanent cost when you price.
  • Review each product at least monthly, since costs and competition shift.

How do you log it in practice?

Use one row per product per month with columns for units, price, commission, shipping, product cost, ad charge and profit after ads. If you categorise your bank and card entries in SpendixAI, you can keep a separate category for advertising on any ad spend paid from your accounts. Charges taken straight from the payout will still need a line in your sheet.

It also helps to track ad spend as a share of sales for each product. In the example, Product 1 spent 3,500 on sales of 50 x 599 = ₹29,950, which is about 11.7 per cent. Product 2 spent 3,000 on 20 x 599 = ₹11,980, about 25 per cent. A product where ads eat a quarter of the sales value is one to question, even before you work out profit.

Start with this

  1. Pull last month's payout statement and mark the ad lines.
  2. List units sold per product.
  3. Work out profit before ads and ad cost per sale.
  4. Pause or cut any product whose result is below zero.
  5. Repeat next month.
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports