The Amazon data problem: why payouts don't match profit
An Amazon payout is what is left after Amazon has taken its fees, refunds, ad spend and VAT, often across several marketplaces at once. It is not your revenue and it is not your profit. To get a true P&L you have to break each settlement report back into its parts and match them to the right month and the right product.
The parts add up quickly: the settlement report itself, FBA fulfilment fees, monthly and long-term storage fees, removal and disposal fees, inbound transport, returns and refund administration, advertising, and the marketplace-collected VAT lines, repeated for every marketplace. No native dashboard brings them together. We build that reconciliation once, then run it every month as part of your management accounts, so the payout in the bank ties back to the P&L line by line.
How do you calculate true profit per SKU on Amazon?
Allocate every fee, every return and every pound of PPC (pay-per-click advertising) to the ASIN, Amazon's product code, that caused it. What is left after the cost of the product is that SKU's contribution margin: what each sale really leaves you. This is ASIN profitability, and it usually looks very different from the catalogue average.
Many Amazon brands manage at catalogue level because that is what the platform shows them. Once the costs are allocated, the catalogue splits into products that make money, products that roughly break even and products that quietly lose it. The winners are often paying for the rest without the founder realising. We show that split every month, so the decision to cut, reprice or reposition a product is made on real numbers. Fjor, the D2C skincare brand William co-founded and ran as CFO and COO, raised gross margin to 80% on its best sellers through supplier renegotiation. Read the Fjor case study.
How do you show ad spend against profit in the monthly numbers?
Put ad spend next to the profit it brought in, product by product. The default ad metrics tell you what you spent to make a sale, but not whether that sale made money. The same ad cost can be profitable on a high-margin product and loss-making on a thin one.
In the monthly accounts we show, for each product, sales, ad spend, TACoS (total ad spend as a share of total sales, including organic sales) and contribution margin after ads. That turns the ad review into one question per product: is each pound of ad spend bringing back more profit than it costs? The answer feeds the budget and the board pack in our Fractional CFO service.
How do you forecast cash for stock and Amazon payouts?
Forecast stock purchases and payouts together. You pay suppliers and freight well before stock reaches an FBA warehouse, then Amazon pays out in instalments after the sale, net of fees and ad spend. Stock that sells slowly also builds up storage fees while it ties up cash.
We build a rolling 12-month cash forecast with every stock order, supplier deposit, freight cost and expected payout, then check it against actuals every month. You see how much cash the next stock order needs and when the pinch points arrive. This is part of our Fractional CFO service. When you raise stock finance or equity, or prepare to sell, the same numbers support debt and equity raising and exit readiness. See also fractional CFO for consumer brands and our service for Amazon sellers.