Ecommerce Reporting: What to Track and How Often
There are two kinds of ecommerce businesses. Ones that make decisions based on data, and ones that find out they lost money six months after it happened. The difference is not having data. Everyone has data. The difference is having the right reports, reviewing them at the right frequency, and acting on what they show.
This guide covers the reports every ecommerce business should have, what each one tells you, and how often you should look at them.
Daily Reports
Daily Revenue and Orders Summary
What it shows: total revenue, total orders, average order value, and refunds for the day. Compare to the same day last week and last month.
Why daily: revenue fluctuations are normal, but catching a sudden drop immediately (broken checkout, payment processor down, ad account suspended) saves you from losing days of sales.
What to look for: is today in line with the trend? If revenue is down 30 percent from the same day last week with no known reason, investigate immediately.
Daily Ad Spend and ROAS
What it shows: how much you spent on ads today across all platforms and what return you got.
Why daily: ad platforms can overspend if budgets are set wrong, audience targeting shifts, or a creative stops performing. Catching an underperforming campaign today instead of next Monday saves real money.
Weekly Reports
Weekly Profit and Loss Summary
What it shows: revenue minus COGS, minus ad spend, minus shipping, minus payment processing fees, minus operating expenses. The bottom line: did you make money this week?
Why weekly: daily P&L swings too much (one big order or one big refund skews the day). Weekly smooths the noise and shows the real trend.
What to look for: is your net margin positive? Is it trending up or down week over week? If margin is shrinking while revenue is growing, your costs are growing faster than your sales.
Weekly Product Performance
What it shows: top and bottom performing products by revenue and margin. Units sold, return rate, and margin per product.
Why weekly: product trends emerge over a week. A product that sells well Monday might have high returns by Friday. Weekly gives you the complete cycle.
What to look for: products with high revenue but low margin (you are busy but not profitable). Products with high return rates (quality issue or misleading listing). Products with zero sales that are tying up inventory and ad spend.
Weekly Cash Position
What it shows: current bank balance, accounts receivable (money owed to you), accounts payable (money you owe), and estimated cash runway.
Why weekly: cash flow problems build gradually. Checking weekly lets you spot a downward trend before it becomes a crisis.
Monthly Reports
Monthly Financial Statement (P&L)
What it shows: the complete picture. Total revenue, COGS, gross profit, every operating expense category, and net income. This is the report your accountant uses to prepare taxes and the report an investor would ask for.
Why monthly: monthly is the standard accounting period. It gives you enough data to see real patterns without the noise of daily and weekly fluctuations.
Monthly Marketing Report
What it shows: total ad spend by platform, blended ROAS, cost per acquisition, new customer count, and customer acquisition cost. Campaign-level breakdown for each platform.
Why monthly: monthly gives you enough data to evaluate campaign performance fairly. Optimizing daily leads to over-reacting to noise. Monthly shows the signal.
What to look for: which platform has the best ROAS and the lowest CPA? How much of your revenue came from paid vs organic channels? Is your customer acquisition cost sustainable relative to your customer lifetime value?
Monthly Customer Report
What it shows: new customers, repeat customers, repeat purchase rate, customer lifetime value (based on actual purchase history), and customer geography.
Why monthly: customer patterns take time to emerge. A customer acquired in January might not make their second purchase until March.
What to look for: is your repeat purchase rate improving? Is LTV growing? Where are your customers concentrated geographically? Are there markets you should focus on or expand into?
Quarterly Reports
Quarterly Business Review
What it shows: a three-month summary that combines financial performance, marketing efficiency, product portfolio health, and customer trends. This is the "zoom out" report that shows whether your business is heading in the right direction.
What to include:
- Revenue trend (are you growing?)
- Profit trend (are you growing profitably?)
- Marketing efficiency trend (is it getting cheaper or more expensive to acquire customers?)
- Cash position trend (is your cash reserve growing or shrinking?)
- Top 5 actions for next quarter
Quarterly Inventory Report
What it shows: slow-moving inventory, dead stock, inventory turnover rate, and cash tied up in unsold products.
Why quarterly: inventory cycles are slow. A product ordered in January might not sell out until April. Quarterly is the right cadence for inventory decisions.
What to look for: products sitting for more than 90 days with low sales velocity need action. Either markdown, bundle, or stop reordering.
Automating Your Reports
The biggest barrier to good reporting is not knowing what to track. It is the time it takes to pull numbers from five platforms into a spreadsheet every week. Most store owners start with good intentions and stop within a month because the process is too manual.
Automated reporting means connecting your data sources once and having reports generated automatically. Nummbas does this by pulling data from your ecommerce platform, ad accounts, accounting software, and operations tools into one dashboard with automated daily, weekly, and monthly summaries. The AI assistant (Nummbas-FO) reviews the data and highlights what needs your attention so you do not have to scan every number yourself.