---
title: "Weekly sales forecast dashboard template — make it with AI | Dashfridge"
description: "Closed won, commit and best case vs. quota by rep, with week-over-week commit changes. Run the Monday forecast call from one AI-made dashboard."
url: https://dashfridge.com/templates/sales-forecast-dashboard
site: Dashfridge (https://dashfridge.com)
---

[Templates](https://dashfridge.com/templates) · [RevOps & GTM](https://dashfridge.com/revops)

# Weekly sales forecast dashboard

Closed won, commit and best case vs. quota by rep, with week-over-week commit changes. Run the Monday forecast call from one AI-made dashboard. Below: the live dashboard, the prompt to make yours, and how to keep it current.

The Dashfridge team · Updated November 11, 2026

 Live sample with made-up numbers · runs locked down, like every dashboard on Dashfridge

## Who it's for

Sales leaders and RevOps running the weekly forecast call, and the CEO who wants one number.

## What's in it

* Quota, closed won, forecast (closed + commit) and upside (best case)
* A stacked bar per rep against a quota marker
* Each rep's commit change since last week
* Totals that tie out to the CRM

## The prompt

Works in Claude, ChatGPT, Gemini and Copilot. Fill in the \[brackets\], then paste your data under it.

Copy this prompt

Build a weekly sales forecast dashboard for [QUARTER] from the data below.
- By rep: quota, closed won, commit, best case. Forecast = closed won + commit. Upside = forecast + best case.
- Tiles: total quota, closed won, forecast and % of quota, upside and % of quota, and the change in total commit vs. last week.
- A horizontal stacked bar per rep (closed, commit, best case) with a marker at their quota and the forecast % at the end.
- A table with every number, a total row, and commit change vs. last week (green up, red down).
- Don't double count: an opportunity is in exactly one forecast category.

My data:
[paste this week's opportunity export, quotas, and last week's commit by rep]

Build it as ONE self-contained HTML file:
- Put all the data inside the file. No API calls, no fetch, no external data.
- Use plain HTML, CSS and JavaScript (inline SVG for charts is fine). If you need a chart library, load it from cdn.jsdelivr.net.
- Add a "data as of" date under the title.
- Make it readable on a laptop and print cleanly to one page if possible.

## Data you need

* Opportunities with owner, forecast category (commit / best case / pipeline), amount and close date
* Quota by rep
* Last week's commit by rep (or last week's dashboard)

## Make it and share it

1. **Gather the numbers** Export or copy: Opportunities with owner, forecast category (commit / best case / pipeline), amount and close date; Quota by rep; Last week's commit by rep (or last week's dashboard).
2. **Paste the prompt** Copy the prompt into Claude, ChatGPT, Gemini or Copilot, fill in the brackets and paste your data under it.
3. **Check it** Tie the totals back to your source reports before anyone else sees it.
4. **Put it on the fridge** Upload the HTML file to Dashfridge, or connect your AI and say "put this on the fridge". Publish it and invite your team.

## Keep it current

**How often:** Weekly, Monday morning before the forecast call. Update the same dashboard each time instead of sending a new file, so your team keeps one link and every past version is kept. Your AI can do the refresh for you: see [dashboards that update every week](https://dashfridge.com/guides/scheduled-refresh).

## Common questions

**What's the difference between commit and best case?**

Commit is what a rep is confident will close this period. Best case adds deals that could close if things go well. Most teams forecast closed won + commit and treat best case as upside.

**How do I track forecast changes week to week?**

Keep the forecast as one dashboard and update it every Monday. On Dashfridge each week becomes a version of the same dashboard, so you can see what the forecast said before any decision.

## Get new RevOps and GTM templates

A couple of emails a month for people who build dashboards with AI. No spam.

## Make it with any AI. Keep it here.

Your team signs in with their company email and always sees the current, certified version. Free for your first 3 dashboards.

[ Start free with your work email](https://dashfridge.com/sign-up)

## More templates

[Pipeline coverage dashboard Open pipeline vs. remaining quota by segment, stage and rep, with a 3× coverage line. Make it from a HubSpot or Salesforce export with any AI tool.](https://dashfridge.com/templates/pipeline-coverage-dashboard) [Pipeline generation by source New qualified pipeline created each week by source (inbound, outbound, partner, events) against a weekly target. Make it from your CRM export with any AI.](https://dashfridge.com/templates/pipeline-generation-dashboard) [Marketing funnel and CAC payback by channel Leads to closed-won by stage, plus CAC and payback months for each channel. Make it with Claude, ChatGPT, Gemini or Copilot from CRM, ad and billing data.](https://dashfridge.com/templates/funnel-cac-payback-dashboard)