Complete Ecommerce Business Management Sheet

A formula-driven workbook for revenue, marketing, customer economics and inventory.

Workbook coverage

Monthly dashboard with revenue, ad spend, ROAS, MER, CAC, AOV, COGS, gross profit and net operating profit.

Channel inputs distinguish attributed revenue from total business revenue.

Inventory schedule tracks opening stock, receipts, units sold and closing stock.

Customer acquisition and repeat-order measures use consistent period inputs.

How to use it

Choose one currency and reporting period. Enter amounts excluding sales taxes and net of refunds consistently.

Keep attributed channel revenue distinct from total revenue to avoid double counting.

Enter new customers and repeat orders from your commerce platform. Review the formula definitions before making decisions.

Blank inputs remain blank; no example performance is presented as your results.

Anika Mehendiratta · Original resource