Ecommerce Budgeting Template
A free Excel budget for ecommerce that rolls sales by channel, COGS, expenses, and payroll into a monthly P&L with budget vs. actual tracking.
What's inside
Income budget by channel
Plan monthly sales for up to three sales channels, with separate rows for discounts, refunds, and fees, so each channel's net revenue rolls into one income total.
Cost of goods sold budget
Estimate product costs with a simple percent-of-sales method or your own calculated numbers. Then add shipping, fulfillment, and merchant fees to see your full cost of goods sold.
Operating expense planner
Budget month by month across 15 common expense categories, from advertising and software to rent, insurance, and professional fees, with payroll pulled in automatically.
Payroll cost calculator
Enter hourly wages and weekly hours or annual salaries, and the template adds employer taxes and benefits to show the true monthly cost of each employee.
Budget vs. actual P&L
Everything rolls into a monthly profit and loss statement, and a budget vs. actual view with a variance tab shows where real results are beating or missing your plan