Weekly Sales Reporting Checklist
Weekly cadence for a multi-unit retail operations team to pull POS and e-commerce sales, calculate comp/UPT/ATV/SPLH, validate against the GL, and distribute the weekly sales recap to store managers and the leadership team.
6 sections
21 steps
1
Data Collection
-
Pull weekly Z-report totals from each store
-
Export e-commerce sales from Shopify
-
Reconcile BOPIS and ship-from-store orders
-
Confirm tender breakdown ties to deposits
-
Verify all stores have reported
2
KPI Calculation
-
Calculate comp sales versus prior year
-
Compute UPT, ATV, and conversion rate
-
Calculate sales per labor hour
-
Review markdown percentage and sell-through
3
Variance Investigation
-
Flag stores missing comp by more than 10%
-
Assess severity of comp variance
-
Request store-manager commentary on miss
-
Escalate severe variances to district manager
4
Report Build
-
Refresh the Looker weekly recap dashboard
-
Build top and bottom store rankings
-
Write the executive summary commentary
5
Quality Assurance
-
Tie net sales to the GL in QuickBooks
-
Sign off on the final weekly recap
6
Distribution
-
Send the weekly recap to store managers
-
Brief leadership on the weekly numbers
-
Archive the recap in the shared drive
Use this template
Copy it to your account, customize the steps, and run it with your team in minutes.
Sections
6
Steps
21
Category
Retail
Price
Free to start
Need a different process
Browse hundreds of free templates across every team and industry.
Back to template libraryRelated templates
More workflows your team can run.
Run Weekly Sales Reporting Checklist with your team
Customize the steps, assign roles, set a schedule, and keep a complete record for every run.