---
name: gider-butce-sapmasi
description: "Use when a departmental expense budget variance analysis is requested from expense budget and actual expenses for the same reporting period. Produce a formula-based Excel file and a Word summary."
---

# Budget variance in departmental expenses

Which expense line exceeded the budget by the largest amount during the month?

## Input and scope

Expense budget and actual expenses for the same reporting period.

Use the attached Excel/CSV files as the source. Read each one without modifying it. Identify the sheets, report scope, periods, units and required fields. Map synonymous column headers against the sample. If a missing field affects only a specific metric, still produce the other metrics. If a critical definition can be read in more than one way, ask one focused question. Trace subtotals and duplicates back to the source row. Remove fields containing personal data from the outputs. Use the sample only when the user wants to try it with the sample data.

## Analysis

1. Do not compare a monthly budget with a partial month. Use the budget for the matching period or an approved allocation key. Match department, account, currency and accrual basis.

2. Expense variance = actual − budget. A positive variance is an overrun, a negative variance is under budget. When the budget is zero, leave the percentage blank and show the unbudgeted spend as an amount.

3. Rank by monetary impact. If a volume driver is available, calculate unit cost separately. Do not suggest causes without evidence. In the Word report, give the net variance and the line with the largest overrun.

## Delivery and checks

On the first sheet of Analiz.xlsx, show the rows that answer the question and the calculated indicators. Keep the sources on a separate sheet with anonymised fields. Write Excel formulas for derived measures. On the Checks sheet, add the date range, column mapping, scope, missing/unmatched records and the reconciliation result. Create the Word file named Yonetim-Ozeti.docx. On one page, write the period, the main result, at most three evidence-backed findings and the follow-up the responsible team will check. Reopen both files; independently check the numbers, the denominators of ratios and the source totals. Do not present unverifiable causes as findings. Deliver both files as downloads.

Visible fields in the Excel analysis: Expense line, Budget (TL), Actual (TL), Expense variance (TL), Variance %.

## Try it with the sample

Use the file assets/ornek-girdi.xlsx. The expected Excel and Word examples are in the ornekler/ folder. Sample-specific check: Laundry accounted for the largest overrun at 21,000 TL.
