Amazon Seller Monthly P&L Template

Every Amazon seller needs a monthly P&L. Not the "I think I'm making money" gut feeling, but a real, line-by-line breakdown of where your revenue comes from and where it goes. The problem? Amazon doesn't give you one. You have to build it yourself from 6+ different reports scattered across Seller Central.

This guide gives you a complete P&L template with every line item you need, shows you exactly where to pull each number in Seller Central, and walks you through building your first monthly report in about 30 minutes. You'll also learn where this manual approach hits its limits and what to do when your catalog outgrows a spreadsheet.

The Complete Amazon P&L Template

Here's the full P&L structure every Amazon seller should use. It covers all revenue adjustments, Amazon-specific fees, COGS, marketing costs, and overhead. Each line item includes the Seller Central report where you find that number.

How to Pull Each Number from Seller Central

The hardest part of building a monthly P&L isn't the math. It's finding the right numbers in Seller Central's maze of reports. Here's exactly where to go for each section:

Revenue Numbers

Start with Payments > Date Range Reports. Generate a report for your target month. This gives you a consolidated view of all transactions: sales, refunds, fees, and adjustments. For gross sales broken down by SKU, use the Business Report > Detail Page Sales and Traffic by Child Item Report.

Amazon Fee Breakdown

The Date Range Report lumps fees together. To get granular breakdowns (referral vs FBA vs storage), download the Transaction View from Payments and filter by transaction type. You'll see each fee category separately. For a $1 to all available Seller Central reports, check our Seller Central reports guide.

Advertising Spend

Pull PPC data from Advertising > Campaign Manager > Reports. Download the "Campaigns" report for your date range. This gives you total spend by campaign type (Sponsored Products, Brands, Display). For SKU-level ad allocation, you'll need the "Advertised Product" report. This is essential if you want to build a per-product PPC ROI view.

COGS (The Part Amazon Can't Tell You)

This is where most sellers struggle. Amazon has no idea what you paid your supplier. You need to maintain your own COGS records with:

• Supplier invoices: per-unit product cost for each SKU
• Shipping records: Freight/courier costs divided by units shipped
• Customs documentation: Duty rates applied to each product category
• Prep costs: Labeling, polybagging, bundling costs per unit

The cleanest approach is maintaining a COGS spreadsheet per SKU with a landed cost per unit that you update every time you place a new purchase order. Multiply that by units sold (from the Business Report) to get total COGS for the month.

Building Your First Monthly P&L: 30-Minute Walkthrough

Here's the exact sequence to build your first P&L. Set aside 30 minutes and have Seller Central open in another tab.

Where Spreadsheet P&Ls Break Down

Manual P&Ls work until they don't. Here are the five failure points that push sellers from spreadsheets to automated solutions:

1. Multi-SKU Attribution

When you have 50+ SKUs, attributing shared costs (storage, advertising, overhead) to individual products becomes a nightmare. Which product "owns" the Sponsored Brands campaign that advertises three ASINs? How do you split the monthly storage fee across 200 units of Product A and 50 units of Product B? Spreadsheets can do this math, but maintaining the formulas across 50+ rows with changing inventory levels is where errors creep in.

2. Daily or Weekly Granularity

Monthly P&Ls tell you what happened. They don't help you react in time. If a fee increase hits on the 3rd and you don't build your P&L until the 1st of next month, you've lost 27 days of potential optimization. The daily metrics that matter for operational decisions require daily P&L updates, which manual spreadsheets simply can't sustain.

3. Multi-Marketplace Complexity

Selling on Amazon US, UK, and DE? Each marketplace has different fee structures, different currencies, and different settlement schedules. Your P&L needs currency conversion at the transaction level, not just an end-of-month exchange rate. That's a separate data source you need to integrate. Our multi-marketplace analytics guide Covers this complexity in detail.

4. Delayed Fee Posting

Amazon can post fees weeks after the associated transaction. Long-term storage fees appear quarterly. Returns processing fees hit when the return is processed, not when the original sale occurred. A Seller Central help article on payments timing Notes that some adjustments can post 45+ days after the original transaction. Your monthly P&L is always a moving target until these delayed entries settle.

5. Fee Structure Changes

Amazon updates its fee schedule regularly. The 2026 FBA fee changes Included new inbound placement fees, adjusted storage rates, and updated size tier thresholds. Each change means updating your spreadsheet formulas. Miss one, and your P&L is silently wrong for months.

Manual Template vs Automated P&L: Honest Comparison

There's no shame in using spreadsheets. Every seller starts there. But it's worth understanding the tradeoffs so you can make an informed decision about when to upgrade.

The inflection point for most sellers is around 20 SKUs or $50K/month in revenue. Below that, a well-maintained spreadsheet works fine. Above it, the time cost of manual reporting usually exceeds the cost of an analytics subscription. If you're at that point, explore what a dedicated P&L dashboard looks like in practice.

P&L Analysis: What to Look For Each Month

Building the P&L is step one. Reading it correctly is where the value lives. Here are the key patterns to watch:

Your Next Step

Download your Seller Central reports for last month and build your first P&L using the template above. Even an imperfect P&L with estimated COGS is better than flying blind. Once you see your actual margins, you'll know immediately whether to focus on cost reduction, pricing optimization, or ad spend efficiency.

If you're past the spreadsheet stage and want automated P&L tracking with daily updates, explore how a connected analytics platform Handles the heavy lifting. The goal is the same: clear financial visibility. The method just scales better.