Ecommerce P&L Template

Download the .xlsx file and open it in Excel or Google Sheets — no macros, no plugins, nothing to install. Start with the Monthly P&L sheet. Review the pre-loaded revenue and expense categories and adjust them to match your store's setup: rename the marketplace revenue lines if you only sell on one platform, add a revenue line for bundles if that's a meaningful part of your business, and remove anything irrelevant. Most ecommerce operators are up and running in 15–20 minutes.

Once the structure is set, enter your monthly revenue and expenses. Your Shopify or WooCommerce dashboard covers revenue and order counts; your ad platforms (Meta Ads Manager, Google Ads) provide spend by channel; and your payment processor or bookkeeping software handles fees and refunds. Fill in the SKU Margin Analysis sheet for your top products — this is where the template pays for itself fastest, because most operators discover that one or two SKUs are eating margin they thought they had. The sheet calculates contribution margin per unit automatically.

Come back monthly after each period closes — it typically takes 20–30 minutes once you're in the rhythm. Over time, the Annual P&L sheet becomes your most valuable view: you can see whether ad spend as a percentage of revenue is creeping up, whether your gross margin is stable across channels, and how Q4 compares to the previous year. Ecommerce operators who review their P&L monthly tend to catch ad spend efficiency problems and fee increases long before they show up as a year-end shortfall.

Ecommerce looks profitable on the surface — high gross margins, no storefront costs, global reach — but the gap between gross and net margin is where the business actually lives. Platform fees, payment processing, digital advertising, fulfillment, and returns can collectively consume 40–60% of revenue, and each one behaves differently depending on your channel mix. A store doing 50% of sales through Amazon will have a fundamentally different cost structure than a DTC-only brand, even at the same revenue level. Without a P&L that breaks these costs down explicitly, you're making decisions about pricing, advertising, and growth based on a number that doesn't reflect what the store actually keeps.

A proper ecommerce P&L structures costs in a way that maps to how online retail actually works. Revenue split by channel matters because each channel has different margin profiles: direct-to-consumer at full price is your best margin, marketplace sales net you less after referral fees and FBA costs, and wholesale typically runs 40–50% below DTC pricing. On the cost side, COGS should separate product cost from inbound freight, and operating expenses should break out digital advertising by platform so you can compare return on ad spend (ROAS) across channels. Listing those costs in a single 'marketing' bucket obscures which channel is actually working.

The most operationally useful part of an ecommerce P&L is the SKU-level margin analysis. Overall gross margin is a lagging indicator — it tells you what already happened. Per-product contribution margin tells you which products are worth scaling, which should be repriced, and which are quietly subsidizing the rest of your catalog. A product that looks fine in your aggregate P&L might have a 6% contribution margin after Amazon fees, ad allocation, and fulfillment — barely worth selling. This template surfaces that data so you're making inventory, advertising, and pricing decisions based on actual unit economics, not just top-line revenue.