Monthly Sales Variances in Excel (PY-AC and AC-PL)
Zebra BI for Excel
Overview
This Excel template is a two-page template for tracking monthly sales variances: the actual (AC) vs the previous year's results (PY), and the actual vs planned results (PL). On each page, there is a visualization with Zebra BI Charts which features automatic variance calculations and integrated dynamic comments.
Get started in 3 steps
1
Download & Open
Download the .xls file and open it in Excel
2
Connect Your Data
Replace sample data with your CRM, ERP, or database source
3
Customize & Publish
Adjust KPIs, colors, and branding, then publish to Power BI Service
Fill out the form and get the Excel template
20,000+ users have downloaded this template
