View order and sales reports

I need the daily and month-to-date order and sales figures for our online store so I can confirm payroll and vendor payments this Friday. Pull yesterday's total orders, gross sales, net sales after discounts and refunds, average order value, and total number of transactions. Check any single-day anomalies and flag transactions over $1,000 for review before I sign off.

Before I show these numbers to finance, make it easy to scan: put yesterday's totals and month-to-date totals at the top, highlight net sales after refunds in green or red depending on trend, show average order value and orders count next, and list any days with a drop or spike over 15% with a one-line suspected cause if available (promo, refund, manual order).

Yesterday's sales were 25% higher than today and I don't know if it's seasonality, a tracking gap, or a promotional ending. The payments team expects payroll funds by Friday and I can't afford a false shortfall. Check for tracking outages, cancelled orders, large refunds processed after midnight, and whether the marketing campaign that drove yesterday's traffic stopped. Recommend the most likely cause and the single best immediate fix so I can tell finance.

Every month I spend a day reconciling reported orders to bank deposits because refunds, manual adjustments, and payment-processor timing keep shifting net sales. I lose credibility with finance and burn time hunting timestamps. Suggest one habit change and a single report or checkpoint to introduce that will cut my month-end reconciliation time and reduce surprises.