A monthly profit and loss report for an Amazon seller, 21 months

The seller could see sales, but not what was left after Amazon's fees, refunds and reimbursements. Now 21 months sit in one sheet, down to gross profit.

Amazon USReportingJanuary 2022 to September 2023

months, one line each
21
monthly sales
$13,207.84 to $30,865.43
gross profit
24.99% to 60.21%

Founder, AVA INC. ยท

  1. At a glanceOf an Amazon seller's numbers in one monthly profit and loss report.Summary slide, no screenshot
  2. 21 months of sales, refunds and reimbursementsHighest month $30,865.43 in January 2022, lowest $13,207.84 in February 2023, with reimbursements tracked against refunds.Google Sheets, Profit and Loss Report tab. No names or IDs on this tab
  3. Down to gross profit, month by monthFurther right on the same tab: Amazon income, then gross profit for every month.Same tab, columns AD to AG and AJ. AH and AI left out because an old marker covered their digits

The problem

The seller could see sales, but not what was really left after Amazon's fees, refunds and reimbursements.

What we did

We built a profit and loss report in Google Sheets, one line per month: sales, sales tax, shipping credits, refunds, SAFE-T claims and FBA reimbursements, through to Amazon income and gross profit. It shares its sheet with tabs of Amazon FBA report data.

The result

21 months in one place, January 2022 to September 2023. Monthly sales ran from $13,207.84 to $30,865.43, and gross profit from 24.99% in the lowest month to 60.21% in the best.

Keep reading

Got a problem like this one?

Send us the notice or a screenshot. We will look at your account and tell you honestly what can be done, before you spend anything.

Get your free account review See our services

More case studies

All 38 case studies