MSAII LLC logo mark MSAII LLC

Can you tell which products made money last month?

A five-minute self-audit for owners who keep their numbers in a point of sale export, a marketplace seller account and a spreadsheet.

Check Yes or No on each line. Yes is 1 point, No is 0. Answer from memory first, then check the two you were least sure about.


1. Where your numbers live

  1. 1. I can name every place my sales come in without looking it up. Square, Shopify, Amazon Seller Central, Stripe, my marketplace accounts. Do today: write each one on its own line and keep that list by your desk.

  2. 2. This month's point of sale export and marketplace report are saved in one folder. Do today: make one folder called Numbers and drop this month's exports into it.

  3. 3. Sales and costs sit next to each other in the same file. Do today: add a Costs column beside Sales before this month closes.

2. What your numbers can tell you

  1. 4. I can name my top three products by profit for last month. Do today: sort last month's export by sales, take the top ten rows, and subtract the cost of each.

  2. 5. I can name my best and worst month this year, and say roughly why. Do today: put the twelve months across one row and drop each month's total under it.

  3. 6. My costs include the fees that eat the margin: marketplace commission, payment fees, shipping. Do today: add three columns named Marketplace fee, Payment fee and Shipping.

  4. 7. I know my margin, not just my sales. Do today: margin is sales minus costs, divided by sales. Work out last month's figure now.

3. The monthly rhythm

  1. 8. My monthly report is ready before the next month's numbers arrive. Do today: pick a fixed date, such as the fifth, and put it in your calendar.

  2. 9. Whoever builds my report knows exactly what I need it to answer. Do today: send one message: "I need my top products by profit, and my best month."

  3. 10. I actually read the report, because it is short. Do today: ask for one page only: sales, costs, margin, top products, by month.

Your score: out of 10

Made by MSAII LLC - S. Kumar, s.kumar@msaii.com