Ecommerce Income Statement Template

Start by downloading the .xlsx file and opening it in Excel or Google Sheets — no macros or add-ins required. Open the Monthly Income Statement sheet and adjust the revenue and expense categories to match your business. Remove channels you don't sell through (wholesale if you're DTC-only, for example), and add any platform-specific fee lines you track separately. Most ecommerce businesses spend 10–15 minutes customizing the structure on first use and then keep it consistent going forward. The Channel Margin Analysis sheet has a configuration section at the top where you set how shared overhead is allocated — set these percentages once based on your current channel mix.

Each month, pull your figures from your ecommerce platform (Shopify, WooCommerce, or your marketplace dashboards) and your ad platform reports. Enter revenue by channel, then work down through COGS, platform fees, ad spend, fulfillment, and returns. The order matters: entering returns accurately is especially important because they hit both revenue (if you track net revenue) and potentially COGS (if you count returned inventory as recovered). Gross profit, gross margin percentage, and net income all calculate automatically. Once the monthly sheet is complete, the Annual Summary and Key Ratios sheets update without any additional steps.

The Key Ratios sheet is where ongoing management happens. For ecommerce, the two numbers to watch most closely are gross margin percentage and advertising cost as a percentage of revenue. Gross margin compression usually traces to one of three causes: rising product costs, a shift in product mix toward lower-margin SKUs, or increasing return rates. Ad cost as a percentage of revenue rising over time signals that you're spending more to acquire each dollar of revenue — which is sustainable only if average order value or repeat purchase rate is also rising. Most ecommerce operators who review this monthly catch these trends early enough to adjust before they compound into a cash flow problem.

Ecommerce businesses often look profitable on top-line revenue but lose money once all the costs specific to online selling are properly accounted for. Platform fees of 3–15% depending on channel, outbound shipping at 8–15% of revenue, advertising that can run 15–30% of revenue for growth-stage brands, and return rates of 15–30% in categories like apparel all erode margins that look healthy at the gross product level. Without an income statement that separates these costs explicitly, it's easy to confuse revenue growth with profit growth — especially when scaling quickly on a channel like Amazon where fees are embedded in payouts rather than invoiced separately.

A proper ecommerce income statement follows the cost structure of online retail, not the generic template most accounting software produces by default. Revenue should be separated by channel because DTC and marketplace sales have fundamentally different economics: a DTC sale through your own Shopify store might cost 2.9% in payment processing and whatever you spent on the ad that drove it; that same sale through Amazon costs 8–15% in referral fees plus FBA fulfillment on top. Returns and refunds need their own line — not folded into revenue as a deduction — because they represent an operational metric (return rate) and a financial one (recovered cost of goods). Advertising belongs in operating expenses, not COGS, but it's the highest-leverage line item in the whole statement and deserves its own group rather than being buried in a catch-all.

The income statement becomes most useful when you run it monthly and use it to drive channel and product decisions. If the Channel Margin Analysis shows that your Amazon channel is contributing 40% of revenue but only 15% of contribution margin after fees and fulfillment, that's a strategic input: should you push customers toward your DTC store, or is the volume on Amazon covering enough fixed overhead to justify the margin sacrifice? If gross margin is compressing quarter over quarter, trace it to either COGS (negotiate with suppliers, adjust your product mix, audit your return handling costs) or revenue mix (are you discounting more heavily to hit growth targets?). Ecommerce operators who treat the income statement as a decision-making tool rather than a reporting formality tend to build businesses that can survive the inevitable slowdown in paid acquisition efficiency as they scale.