How to track Amazon revenue by month

What counts as revenue, how to read seasonal trends, and how to query it from Seller Central

Definition

What it is

Amazon monthly revenue is the total product sales amount for a given calendar month, net of returns and before Amazon fees. It is the starting point for all Amazon financial analysis — the gross revenue figure that all fees, costs, and margin calculations build from. Tracking it month-over-month and year-over-year reveals growth trend, seasonality patterns, and the impact of pricing or inventory changes.

Formula

Monthly Revenue Formula

Formula

Monthly Revenue = SUM(order_amount) WHERE order_month = target_month AND status != 'Cancelled'

Use order date, not shipment date, for consistency. Exclude cancelled orders. For a true net revenue figure, also subtract refunded amounts in the same period. Year-over-year comparison: divide current month revenue by the same month in the prior year, subtract 1, and multiply by 100.

Business impact

Why it matters

Monthly revenue is the single most-tracked metric for any Amazon business, but raw revenue growth is misleading without context. A 20% revenue increase in December is expected due to Q4 seasonality; the same increase in February is genuinely significant. Tracking revenue with a year-over-year comparison strips out seasonality and reveals true business momentum. Month-over-month tracking catches sudden drops that may indicate listing suppression, inventory stockouts, or competitive pressure.

The challenge

How most teams track this today

Seller Central shows monthly revenue in the Sales Dashboard and Payments reports, but the built-in views don't support custom date ranges or year-over-year comparison in the same view. Sellers typically export monthly reports and build comparison tables in Excel.

Run it on your data

Calculate this automatically with Taptic Data

Connect your Amazon Seller Central account and Taptic generates this calculation from plain English against your actual data — no Excel exports, no manual joins. The SQL runs against your real schema, your real tables, your real numbers.

SQL query for Amazon revenue by month →Connect Amazon Seller Central →Try Free — $29.99/mo

FAQ

Common questions

Should I track Amazon revenue by order date or ship date?

Order date is the standard for revenue reporting — it matches the customer decision point and aligns with most accounting conventions for accrual-basis revenue recognition. Ship date matters more for fulfilment and logistics reporting.

How does seasonality affect Amazon revenue trends?

Q4 (October–December) is consistently 30–60% higher than Q1 for most product categories due to holiday shopping. Prime Day (typically July) creates a secondary peak. Year-over-year comparison is more meaningful than month-over-month for most Amazon businesses because it controls for this seasonality.

Does Amazon revenue in Seller Central include VAT?

For US marketplaces, Amazon sales are typically reported excluding sales tax. For EU and UK marketplaces, the order amount in Seller Central includes VAT. The settlement report shows the VAT-inclusive sale and a separate tax line item. Taptic imports the amounts as provided by the SP-API for each marketplace.

Can I compare Amazon and Shopify revenue in the same query in Taptic?

Yes. Taptic imports both Amazon and Shopify order tables into the same workspace. The combined revenue query uses a UNION ALL to merge both sources with a channel column, so you can see total revenue and channel split in one view.

Analytics hub

All Amazon queries, use cases, and SQL examples in one place.

Amazon Analytics hub — queries, use cases, and SQL examples →

Stop calculating this in spreadsheets

Connect Amazon Seller Central to Taptic Data and run this calculation automatically from plain English — against your real data, on a schedule, delivered to your team.

Start Free — $29.99/mo Try the Live Demo