Monthly sales and P&L dashboard in Excel

A one-page monthly view tells you whether the business is growing and where money goes.

Rows to track each month

Revenue by channel (marketplaces, own shop, other)
Refunds
Cost of goods
Fees, shipping, ads, software
Profit and margin
Fees % and ads % of revenue

Make it useful

Add a monthly target and show the difference.
Keep a year-to-date column.
Add a line chart of profit by month.
Set aside an estimate for tax in its own row (ask an accountant for your rate).

Reseller profit per item, after fees. Log each item and see net profit after fees and shipping, plus days to sell (Reseller Profit Tracker). Example data.

The Monthly P&L Dashboard and Reseller Profit Tracker are part of the Seller Sheets Bundle (€69).

Not affiliated with, endorsed or sponsored by Amazon or eBay. Excel and Google Sheets belong to their owners. Written with AI assistance. General information only, not tax, legal or financial advice; fee and rule examples as at Oct 2026 — check current fees and rules with the official source. No particular sales or profit result is promised.