Introduction
For high-volume Amazon sellers running on NetSuite, the “Profit and Loss” statement often tells a misleading story. You see your top-line revenue, you see your total Amazon fees, and you see your overall net income. On paper, the business looks healthy.
But when you dig deeper, a critical question remains unanswered: Which specific products are actually making money?
Amazon is a “fee machine.” Between referral commissions, FBA fulfillment, monthly storage surcharges, aged inventory fees, and aggressive PPC spending, the cost of selling a single unit can easily consume 30-50% of its retail price. If your accounting system simply lumps these into broad categories like “Amazon Fees,” you are flying blind. You might be aggressively restocking and advertising a “top seller” that is actually losing money on every shipment after full cost allocation.
Achieving true Amazon product profitability in NetSuite requires more than just a data sync. It requires a system that bridges the gap between Amazon’s complex settlement data and NetSuite’s robust inventory and general ledger architecture.
This guide explains how to move from “blended margins” to precise, SKU-level profitability using real-time COGS and automated fee attribution.
Key Takeaways
Key Takeaways
- Blended Margins are Dangerous: Channel-level profitability hides “zombie SKUs” that look successful but erode your bottom line.
- NetSuite’s “Data Gap”: NetSuite natively tracks sales and inventory, but does not attribute Amazon-specific fees (FBA, Storage, PPC) to individual items.
- Actual COGS vs. Estimates: Profitability analysis is only as accurate as your Cost of Goods Sold; using NetSuite’s native FIFO layers is essential.
- The “Return Factor”: Refunds and refund administration fees must be deducted from the specific SKU’s margin to see the true cost of quality or fit issues.
- Automation is Mandatory: Manually allocating 14+ Amazon fee types across thousands of transactions is impossible at scale.
The Problem: Why NetSuite Doesn’t Show SKU Profitability Out of the Box
NetSuite is a world-class ERP, but it doesn’t “speak” Amazon natively.
When you ship an order, NetSuite records the sale and decrements inventory. However, the associated costs—the referral fee, the FBA “pick and pack” charge, and the advertising click that drove the sale—don’t arrive in the same data packet. They are buried in the bi-weekly Amazon Settlement Report.
Most basic integrations simply post these fees as a lump sum “Check” or “Journal Entry” at the end of the period. This keeps your bank account reconciled, but it destroys your product-level data. In your NetSuite reports:
- Revenue is tied to the SKU.
- COGS is tied to the SKU.
- Fees are tied to a generic “Amazon Expense” account.
The result? You can see your Gross Margin by product, but your Net Margin is a mystery.
The Five Pillars of Accurate Amazon Profitability
To build a reliable profitability engine in NetSuite, you must automate the tracking of five distinct data layers:
1. Accurate Sales & Revenue Recognition
Profitability starts with knowing exactly what you sold and for how much. This includes separating product revenue from shipping income and gift wrap fees, and correctly accounting for Marketplace Facilitator Taxes (which should be a “wash” and not inflated revenue).
2. Real-Time FIFO COGS
You cannot trust your margins if you are using a “standard cost” or a manually entered “buy cost.” NetSuite’s power lies in its FIFO (First-In, First-Out) costing. As you receive new inventory at different prices (due to supply chain fluctuations or shipping costs), NetSuite tracks those layers.
Your profitability report must pull the actual COGS recognized by NetSuite at the moment of sale. This ensures that if your container shipping costs doubled last month, your profitability report reflects that margin squeeze immediately.
3. Granular Fee Attribution
Amazon charges over 14 different types of fees. To see true SKU margins, you must allocate these at the item level:
- Referral Fees: The commission paid to Amazon.
- FBA Fulfillment Fees: The “pick and pack” cost.
- Storage Fees: Often overlooked, but critical for slow-moving or bulky items.
- Disposal/Removal Fees: Costs for unsellable inventory.
4. Advertising Spend (PPC) Attribution
For many brands, PPC is the second-largest expense after COGS. If you spend $5,000 a month on “Automated Campaigns” but don’t attribute that spend back to the products that actually sold, your high-volume SKUs will look much more profitable than they really are.
5. The True Cost of Returns
A high return rate can turn a 20% margin product into a loss-maker. When a customer returns an item, you don’t just lose the sale; you pay a Refund Administration Fee and often lose the original FBA Fulfillment Fee. A robust profitability system must “charge back” these costs to the specific SKU.
How Entriwise Automates Profitability in NetSuite
Entriwise was built to solve the “NetSuite Data Gap.” Instead of just syncing orders, it functions as a financial mapping engine that builds a “Fully Burdened” view of every SKU.
Daily SKU-Level Summaries
Entriwise imports Amazon data every day (not just every two weeks). It aggregates sales and—critically—associates every fee with the corresponding NetSuite Item.
Native COGS Integration
Because Entriwise posts native Cash Sales and Invoices into NetSuite, it triggers NetSuite’s internal inventory engine. This means the COGS data used for profitability is not an estimate; it is the official, audited FIFO cost from your NetSuite General Ledger.
The Profitability Dashboard
The result is the Profitability Analytics report. It combines:
- NetSuite Sales Data
- NetSuite COGS Data
- Amazon Fee Data (mapped at the SKU level)
You can finally run a report that shows:
Sales Price - FIFO COGS - Referral Fee - FBA Fee - Ad Spend = True Net Profit per SKU
Case Study: The “Best Seller” Trap
Consider two products in a typical seller’s catalog:
| Metric | SKU A (The “Hero”) | SKU B (The “Workhorse”) |
|---|---|---|
| Sales Price | $50.00 | $50.00 |
| Gross COGS | $15.00 | $20.00 |
| Referral Fee (15%) | $7.50 | $7.50 |
| FBA Fee (Size/Weight) | $12.00 (Bulky) | $5.00 (Small/Light) |
| Ad Spend (Per Unit) | $10.00 (Highly Competitive) | $2.00 (Niche) |
| Return Rate | 12% | 2% |
| True Net Profit | -$0.50 (Loss) | $14.50 (Profit) |
Without SKU-level fee and ad attribution in NetSuite, SKU A looks like a winner because of its high volume and $35.00 Gross Margin. SKU B looks less impressive due to higher COGS.
Only when you automate the attribution of “hidden” Amazon costs do you realize that your “Hero” product is actually a “Zombie SKU” destroying your cash flow.
What to Read Next If You Are Evaluating the Integration Layer
This profitability guide answers the margin question: which SKU is actually making money? But two adjacent questions usually come next:
- How should the broader Amazon NetSuite integration be structured so sales, fees, inventory, and FIFO COGS all land correctly in the ERP?
- If you are comparing platforms, why would a purpose-built connector outperform a general iPaaS? The Celigo alternative for Amazon to NetSuite integration guide covers that decision directly.
Read the Amazon NetSuite integration guide when you want the end-to-end accounting and inventory architecture. Read the Celigo comparison when you are pressure-testing which connector can actually support reliable SKU profitability instead of just moving data.
Conclusion: Data-Driven Growth
In the current Amazon landscape, “guessing” your margins is a recipe for failure. As your business scales into an ERP like NetSuite, the goal is to gain absolute clarity.
By moving away from broad fee summaries and embracing granular, native transaction posting, you transform NetSuite from a simple accounting tool into a strategic growth engine. You can confidently double down on high-margin products, optimize your FBA inventory levels, and cut underperforming SKUs before they drain your resources.
Ready to see your true margins? Explore how Entriwise automates Amazon SKU Profitability for NetSuite. If you are also selling on Shopify, see our Shopify NetSuite integration guide for multi-channel profitability.
Frequently Asked Questions (FAQ)
Can NetSuite calculate Amazon profitability natively?
NetSuite can calculate Gross Profit (Sales minus COGS) natively if your inventory is set up correctly. However, it cannot attribute Amazon-specific fees (Referral, FBA, Storage) to individual products without a specialized connector like Entriwise to map those costs at the SKU level.
Why is FIFO COGS important for Amazon profitability?
FIFO (First-In, First-Out) ensures that your profit calculations reflect the actual cost of the inventory you just sold. If your supplier raised prices or your inbound freight costs increased, FIFO captures this immediately, providing a more accurate margin than “Average Cost” which can lag behind reality.
Does Entriwise track Amazon Advertising spend in NetSuite?
Yes. Entriwise can pull advertising spend and attribute it back to the specific SKUs, allowing you to see your “ACOS-adjusted” net profit directly in your reports.
How do returns impact my profitability reports?
Returns are a major “hidden” cost. Entriwise records returns as native NetSuite Cash Refunds or Credit Memos, which reverses the income and accounts for the lost FBA fees and refund administration fees, ensuring your SKU profitability reflects the true net performance after returns.
Can I track profitability for other channels like Shopify?
Yes. While this guide focuses on Amazon, Entriwise provides the same level of granular fee and COGS mapping for Shopify. You can learn more in our complete guide to Shopify NetSuite integration.