---
title: "Budget vs. actual dashboard template — make it with AI | Dashfridge"
description: "A monthly budget vs. actual (BvA) dashboard by department with variance, % and the owner's explanation. Copy the prompt into Claude, ChatGPT, Gemini or Copilot."
url: https://dashfridge.com/templates/budget-vs-actual
site: Dashfridge (https://dashfridge.com)
---

[Templates](https://dashfridge.com/templates) · [Finance](https://dashfridge.com/templates#finance)

# Budget vs. actual dashboard

A monthly budget vs. actual (BvA) dashboard by department with variance, % and the owner's explanation. Below: the live dashboard, the prompt to make yours, and how to keep it current.

The Dashfridge team · Updated November 10, 2026

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

## Who it's for

FP&A, controllers and department heads at the monthly business review.

## What's in it

* Revenue and operating expenses vs. budget
* Variance in $ and %, favorable in green
* A bar per line showing actual as a share of budget
* One-line commentary from each owner

## The prompt

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

Copy this prompt

Build a budget vs. actual dashboard for [MONTH] from the data below.
- Tiles: revenue vs. budget (%), operating expenses vs. budget (%), operating income, and year-to-date opex vs. budget (%).
- Table: Revenue first, then each expense line (cost of revenue, sales, marketing, R&D, G&A or my departments), with budget, actual, variance ($), variance (%), a small bar showing actual as a share of budget with a marker at 100%, and a "why" column.
- Favorable variances in green, unfavorable in red (for expenses, under budget is favorable).
- Total operating expenses row at the bottom.

My data:
[paste budget and actuals by line, plus a note on each big variance]

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

* Budget by department for the month (and year to date)
* Actuals from the close
* A short explanation for each material variance

## Make it and share it

1. **Gather the numbers** Export or copy: Budget by department for the month (and year to date); Actuals from the close; A short explanation for each material variance.
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:** Monthly, right after the close. 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 is a budget vs. actual report?**

A comparison of what you planned to earn and spend with what actually happened, line by line, with the variance in dollars and percent and a short explanation of anything material.

**How do I share a budget vs. actual dashboard with department heads?**

Put it in one place each department head signs in to, mark the final version as certified after the close, and keep last month's as a version. Avoid emailing spreadsheets that drift.

## Get new finance 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

[13-week cash flow forecast A direct-method 13-week cash flow dashboard you can make with Claude, ChatGPT, Gemini or Copilot from your bank balance, AR, AP and payroll. Copy the prompt.](https://dashfridge.com/templates/13-week-cash-flow) [Weekly cash position dashboard A one-screen weekly cash dashboard: cash today, AR and AP due, payroll, line of credit and ending cash by week. Copy the prompt into any AI tool.](https://dashfridge.com/templates/weekly-cash-dashboard) [AR aging and collections dashboard An AR aging dashboard with current, 1–30, 31–60, 61–90 and 90+ buckets, DSO and the largest past-due accounts. Make it with any AI tool from your aging report.](https://dashfridge.com/templates/ar-aging-dashboard)