Amz Consultors logo Amz Consultors AutomationBook a free strategy call

Finance · Profit tracking & reports

Monthly profitability report

Once a month, go through every product's profit: confirm the best sellers, find the bleeders and why they bleed, and set each product's profit margin and TACOS target for the coming month.

Updated Oct 25, 20266 min readWho: Account owner, with a VA checking COGSHow often: Monthly, on the 5th

What it is and why

Once a month, check the profit report: the exact profit each listing generated, with all the revenue and expenses it generated by itself. Compare it with your profit goal for each listing to make sure you're on track.

The point is to take the time to go over every product in the brand: make sure nothing is bleeding or working differently than expected, and spot positive trends fast.

GoalsActions you'll take from it
Better financial control and a stronger business pulseSet the monthly TACOS range for every product
Find bleeding SKUs and markets, and why they bleed (marketing, refunds, etc.)Identify bleeding products and the reason, and add tasks to fix them
Identify the best-selling SKUsConfirm the best sellers and prioritize them in day-to-day work
Infrastructure for delegation and scale

How often: once a month. Check the monthly report in depth, dig into specific bleeding SKUs, and brainstorm the best actions to improve them.

One-time setup

  1. Sign up for Sellerboard and bookmark it
  2. Connect your Amazon store through the API

    Every Amazon marketplace you sell in should be connected. Then connect the PPC Ads API from inside Sellerboard, so it downloads the PPC data.

  3. Enter COGS for each active SKU on the Products page

    Cost type: by period/batch/marketplace.

  4. For FBM SKUs, enter the FBM shipping cost

    Products page → column FBM shipping cost: the estimated cost of shipping to a customer.

  5. Wait 1–2 days

    So the software downloads all the relevant past data.

Full setup: Sellerboard account and gross margin preparation.

The owner task

FieldValue
Task nameCheck monthly Profitability report
Due date and repeatEvery month on the 5th
SubtasksMake sure the VA filled the COGS correctly for the top ASINs · Analyze the report with the process below · Add every follow-up task from the analysis
Recurring task Check monthly Profitability report with the process in its description: macro level, bleeders, bestsellers and deciding TACOS levels.

1. Macro level

Go over all the products one by one. Apply the 80/20 rule and start with the best product. For each product, go through every column and understand where the expenses go.

2. Best sellers

Identify the 80/20 products, the biggest in the company. Make sure the whole team understands that for these products you will:

  • Spend more time analyzing and optimizing their PPC.
  • Keep a bigger inventory buffer, to allow growth and minimize the chance of running out of stock.
  • Check their markets often, know the niche keywords by heart, and know where the biggest competitors stand.

3. Bleeders

ASINs with a margin below 10–14% that aren't in the top 20% of products need to be addressed immediately and aggressively: they waste energy and don't make money.

Options
OptionWhen
Lower TACOS aggressively (PPC, deals, promo codes…)TACOS is the main bleeding point. See the Bleeders report.
Test a higher price and watch performanceThe core margin before PPC isn't good enough (below 28–32%)
Stop selling the SKULet the stock sell out and don't send more. Only if revenue or rating is very low.
Do nothingUsually a bad idea

4. Profit margin and TACOS targets for next month

Review every product one by one. Decide the profit margin % you'll aim for next month for each product: that sets the TACOS level to aim for.

17–25%Gross profit to aim forAfter all expenses
> 25%Likely leaving money on the table
< 17%Not healthyAnd a problem if you want to exit
ExampleSetting the margin target

Last month 14% → you want 17%: aim for 15.5% this month and 17% next month.

Last month 29% → you can decide to push and aim for 25% this month.

Once you know the margin target, look at last month's marketing spend: it's the biggest variable you control. Calculate last month's TACOS and adjust it to reach the margin you want.

Last month's marketing cost per product is the sum of:

CostWhere to find it in Sellerboard
PPCThe Ads column
Promo codes + Lightning Deal discountsThe Promo column (includes both)
Coupon redemption feesAccount data window at the top → More → Amazon fees → Coupon redemption fee. It covers the whole account: estimate how many redemptions each product had and split the fee.
Lightning Deal feesSame place → Lightning Deal fee
Any other ad spendOutside traffic, Amazon DSP, etc.

Divide the total marketing cost by the product's revenue: that's last month's TACOS.

CalculatorMonthly TACOS target

Last month's revenue, ads, promo, coupon and deal fees and profit margin to last month's TACOS and the TACOS that reaches your target margin next month.

Want these numbers for your own account? Get a free audit →
  1. Review last month's profit margin
  2. Decide the target profit margin for the coming month
  3. Calculate last month's TACOS
  4. Adjust that TACOS by the margin change you want

    That's the new target TACOS for the month.

  5. Note the target TACOS

    In the TACOS Targets tab of the finance tracking workbook ↓. Use the weekly meeting to monitor marketing and reach it.

If you don't follow this process

At least make sure that:

  • You can see your store's gross margin with at least 95% accuracy
  • You spend a few hours on your numbers at least every two months (monthly recommended)
  • You have a simple way to spot bleeding products and why they bleed
  • You review each product's advertising budget monthly and set budgets for the coming month(s)

Want this done for you?

We run advertising, listings and account health for Amazon, Walmart and eBay brands. Start with a free review of your account.