Blog · Board and management reporting · Sales teams
Build a Google Sheets sales dashboard that compares net sales with targets by product and region. Use the worked layout, monthly controls and reconciliation checks to turn an export into a reliable sales review.
A Google Sheets sales dashboard compares actual sales with targets for the same month, product and region. Build it from a sales tab, a target tab and a calculation tab, then display the checked results. The layout below is a workbook you can recreate directly; it does not require a separate download.
This example follows a fictional US distributor's posted net invoice sales for February 2026. Returns and discounts are already included in the amounts, and all figures use USD. The target uses the same revenue definition.
Create tabs named Sales, Targets, Controls, Calc and Dashboard. Keep imported transaction rows on Sales and budget rows on Targets. Do not put targets on every invoice line: each segment's monthly target belongs in one target row.
The sales dashboard examples help decide what different readers need to see. Here, the manager's question is narrower: which product-region combinations explain the shortfall against target?
Enter this sales export in Sales!A1:E9. Column A contains real dates and column E contains numbers, with a currency display format if wanted.
| Date (A) | Line ID (B) | Product (C) | Region (D) | Net sales (USD) (E) |
|---|---|---|---|---|
| February 2, 2026 | I201-1 | Core | East | 12,000 |
| February 7, 2026 | I202-1 | Core | East | 10,000 |
| February 4, 2026 | I203-1 | Core | West | 9,000 |
| February 18, 2026 | I204-1 | Core | West | 11,000 |
| February 12, 2026 | I205-1 | Plus | East | 6,000 |
| February 24, 2026 | I206-1 | Plus | East | 7,000 |
| February 10, 2026 | I207-1 | Plus | West | 5,000 |
| February 26, 2026 | I208-1 | Plus | West | 4,000 |
Enter the approved monthly targets in Targets!A1:D5. The month field is a real first-of-month date, displayed below in full.
| Month (A) | Product (B) | Region (C) | Target (USD) (D) |
|---|---|---|---|
| February 1, 2026 | Core | East | 25,000 |
| February 1, 2026 | Core | West | 18,000 |
| February 1, 2026 | Plus | East | 12,000 |
| February 1, 2026 | Plus | West | 10,000 |
Add new rows when a new month is approved; retain prior months so changing the reporting period does not overwrite the historical target.
Put the reporting month in Controls!B1, initially February 1, 2026. Put the next month's start in B2:
=DATE(YEAR(B1),MONTH(B1)+1,1)
The date window includes the start and excludes the next month's start. This also works when imported dates include times. Use Data > Data validation > Add rule to restrict B1 to a list of approved month-start dates. Google's dropdown instructions explain lists from a range and invalid-entry controls. Keep the list entries as dates, not typed month names.
Set Calc columns A:F to Product, Region, Actual, Target, Variance and Attainment. Enter the product-region combinations shown below in A2:B5. Include every combination appearing in sales or targets, including new products that have no approved budget yet.
In C2, calculate actual sales with SUMIFS, which sums a range using multiple criteria:
=SUMIFS(Sales!$E$2:$E,Sales!$C$2:$C,$A2,Sales!$D$2:$D,$B2,
Sales!$A$2:$A,">="&Controls!$B$1,Sales!$A$2:$A,"<"&Controls!$B$2)
In D2, retrieve the target for that exact month and segment:
=SUMIFS(Targets!$D$2:$D,Targets!$B$2:$B,$A2,
Targets!$C$2:$C,$B2,Targets!$A$2:$A,Controls!$B$1)
In E2 and F2, calculate the gap and attainment:
=C2-D2
=IF(D2=0,"",C2/D2)
Fill C2:F2 down through row 5. Format attainment as a percentage with one decimal place; calculate from full values before rounding the display.
| Product | Region | Actual (USD) | Target (USD) | Variance (USD) | Attainment |
|---|---|---|---|---|---|
| Core | East | 22,000 | 25,000 | -3,000 | 88.0% |
| Core | West | 20,000 | 18,000 | 2,000 | 111.1% |
| Plus | East | 13,000 | 12,000 | 1,000 | 108.3% |
| Plus | West | 9,000 | 10,000 | -1,000 | 90.0% |
| Total | 64,000 | 65,000 | -1,000 | 98.5% |
In row 6, sum C2:C5, D2:D5 and E2:E5. Calculate F6 as =IF(D6=0,"",C6/D6). The company attainment is 64,000 / 65,000, displayed as 98.5%; averaging the four segment percentages would give each target the same weight.
Run an independent monthly sales total:
=SUMIFS(Sales!E2:E,Sales!A2:A,">="&Controls!B1,
Sales!A2:A,"<"&Controls!B2)-Calc!C6
It must return zero. Also check the target total:
=SUMIFS(Targets!D2:D,Targets!A2:A,Controls!B1)-Calc!D6
That must also return zero. Finally, =Calc!C6-Calc!D6-Calc!E6 must return zero, proving that actual minus target equals the displayed variance.
These totals do not detect every missing target. In Calc G2, add a target-row check and fill down:
=COUNTIFS(Targets!A$2:A,Controls!B$1,Targets!B$2:B,A2,
Targets!C$2:C,B2)
Each example segment returns 1. Zero means no target row; a larger count means duplicate target rows under this template's one-row rule. Review both before interpreting attainment.
If you need to explore sales dimensions before fixing a dashboard layout, use the Google Sheets sales pivot guide. A broader KPI dashboard can carry other business measures alongside sales.
Link Dashboard cells to Calc's total actual, target, variance and attainment. Display the month and revenue definition beside them. Add the four segment rows, sorted by dollar variance, so the manager can see that Core East's $3,000 shortfall is the largest adverse gap.
Select the segment labels, actuals and targets, then choose Insert > Chart. Use a column chart with actual and target as separate series. Google's chart guide explains changing the chart type and source range. Keep dollar amounts and attainment percentages in separate views because they use different units.
The chart establishes where to investigate. The CFO's sales questions help frame the follow-up, while a sales forecast template handles expectations for future periods separately.
Covirage is not affiliated with Google.
Bring your sales export or Google Sheet and the matching target file with a clear month, product and region. Covirage maps the columns, and its tools compute and check the figures; the external AI model explains the results with every figure traced to its rows. Create a free Covirage account and bring a sample of your own data; creating the account takes about a minute.
See Covirage for sales teams for the business context.
Start with net sales, target, dollar variance and target attainment for one defined period. Add a product-region table that explains the total. Keep the reporting dates and sales basis visible so the reader knows whether the figures represent invoiced revenue, orders or another measure.
Keep targets in a separate table at their original grain, such as one month, product and region. Repeating a monthly target on every transaction multiplies it when summed. Calculate actual sales and targets separately, then compare them in a shared calculation table.
Show the actual sales and flag the missing target for review. Leave attainment blank when the target is zero instead of forcing a percentage. Check whether the target was omitted or intentionally set to zero before including that segment in management conclusions.