# Budget vs Actual Variance Commentary Worksheet

> Source: https://netray.co/tools/budget-vs-actual-variance-commentary-worksheet
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

Line-by-line budget versus actual with computed variance, percent variance and a commentary column for month-end review.

## Category

cost-finance

## Audience

- Controller
- Cost accountant
- Operations manager

## Tool

**Kind:** worksheet

**Mode:** editable

**Currency:** $

**Columns:**

#### Cost line

**Key:** line

**Type:** text

#### Budget

**Key:** budget

**Type:** number

**Format:** currency

#### Actual

**Key:** actual

**Type:** number

**Format:** currency

#### Variance (actual - budget)

**Key:** variance

**Type:** number

**Expr:** actual - budget

**Format:** currency

#### Variance %

**Key:** var_pct

**Type:** number

**Expr:** if(eq(budget,0),0,(actual-budget)/budget*100)

**Format:** percent

#### Driver

**Key:** driver

**Type:** select

**Options:**

- Volume
- Price
- Mix
- Efficiency
- Timing
- One-off
- Error

#### Owner

**Key:** owner

**Type:** text

#### Commentary

**Key:** comment

**Type:** text

**Rows:**

**Line:** Direct material

**Budget:** 412000

**Actual:** 438500

**Driver:** Price

**Owner:** Purchasing

**Comment:** Aluminum plate price increase from March

**Line:** Direct labor

**Budget:** 126000

**Actual:** 131200

**Driver:** Efficiency

**Owner:** Production

**Comment:** Overtime on rework in cell 3

**Line:** Manufacturing overhead

**Budget:** 98000

**Actual:** 94300

**Driver:** Timing

**Owner:** Controller

**Comment:** Maintenance invoice due next month

**Line:** Freight out

**Budget:** 21000

**Actual:** 27400

**Driver:** Mix

**Owner:** Logistics

**Comment:** Expedited shipments to two customers

**Line:** Scrap and rework

**Budget:** 15000

**Actual:** 22800

**Driver:** Efficiency

**Owner:** Quality

**Comment:** Fixture wear on op 20

**Totals:**

#### Total budget

**Key:** budget

**Agg:** sum

**Format:** currency

#### Total actual

**Key:** actual

**Agg:** sum

**Format:** currency

#### Total variance

**Key:** variance

**Agg:** sum

**Format:** currency

**Summary:**

#### Total variance %

**Key:** total_pct

**Expr:** if(eq(sum_budget,0),0,(sum_actual-sum_budget)/sum_budget*100)

**Format:** percent

**Notes:** Cost lines: a positive variance means actual cost is above budget (unfavorable). For revenue lines, flip the reading. Set a materiality rule, for example comment on every line over 5 percent or a fixed currency amount.

## Content

**Intro:** Variance commentary is where the controller adds value, and where time disappears. This worksheet calculates the variance for you and gives every line a driver, an owner and a sentence of explanation.

**Sections:**

#### How to use it

**Body:** Paste or type budget and actual by cost line from your ERP trial balance or cost report. Variance and percent variance compute automatically. For every line beyond your materiality threshold, choose a driver, name an owner and write one plain sentence. Export to Excel or PDF and attach it to the month-end pack so executives read explanations rather than raw numbers.

#### Choosing the driver

**Body:** Most manufacturing variances fall into a few buckets. Naming the bucket keeps commentary honest and makes trends across months visible.

**Bullets:**

- Volume: more or fewer units than budget
- Price: rate paid differs from standard
- Mix: different product or customer mix
- Efficiency: usage, labor hours, scrap, rework
- Timing: cost landed in a different period
- One-off or error: needs correction or disclosure

#### Good commentary and common mistakes

**Body:** Good commentary says what happened, why, whether it will repeat and what is being done. Weak commentary restates the number. Avoid blaming 'timing' without naming the transaction. When the same driver appears three months running it is no longer timing. Make sure budget and actual are on the same basis, for example the same allocation of overhead and the same currency rate, or the variance will be an artifact.

**Cta:** If your team spends the first week of every month assembling variance data, Netray can help automate the pull from your ERP read-only, so people only write the commentary.

**Faq:**

#### What variance threshold should I use?

**Answer:** A common rule is to explain any line that is over 5 percent and above a fixed amount that matters to your size of business. Use both tests so tiny lines with large percentages do not waste time.

#### Is a positive variance good or bad?

**Answer:** For costs, positive means spending above budget, which is unfavorable. For revenue, positive means above budget, which is favorable. Label the sign convention at the top of the pack.

#### Should I analyze price and volume separately?

**Answer:** Yes for material and revenue lines. Price variance is the rate difference times actual quantity, and volume variance is the quantity difference times budget rate. This worksheet gives the total, and the driver column records the main cause.

#### How often should variance be reviewed?

**Answer:** Monthly at minimum, and weekly for volatile lines like freight, overtime and scrap. Faster review lets you fix causes while they still matter.

## Search terms

budget vs actual variance template, variance commentary template, monthly variance analysis excel, budget variance report manufacturing, variance explanation worksheet, month end variance review

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json