# Budget Report

## ✅ Objective

Automate the manual Excel-based departmental spend reporting process using Power BI, allowing for comparison between actuals and budgets across departments, with drill-down capability and currency conversion.

---

## 📁 Data Sources

### 1. **Budget 2025–2026 (One-Off Upload)**

- Finalized and static prepared by finance team.
- Contains:
    - Cost categories per department
    - Monthly figures for FY 2025–2026

### 2. **Monthly Actuals from Xero**

- Exported monthly across all Truvi entities.
- Raw data may contain inaccuracies in:
    - Cost category
    - Department
- Mapping corrections that we can apply similar to the accounting aggregation levels:
    - Cost category
    - Mapping to Month End Level 1
    - Mapping to Month End Level 2
    - Department

---

## 🧩 Key Requirements for the Power BI Report

### 🔍 Filters (Slicers)

- **Month End Date**
- **Department**

### 📊 Report Layout (Table Format)

| Apr Actual | Apr Budget | Variance to budget (£) | Variance to budget (%) | Last Month Actual | Variance to Last Month (£) | Variance to Last Month (%) | YTD Actuals | YTD Budget | Variance (£) | Variance to budget (%) |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |

---

## 🧾 Drilldown Structure

### Level 1: **Month End Level 1**

E.g., **Entertaining**

### Level 2: **Month End Level 2**

- Client Entertaining
- Staff Entertaining

➡️ Users should be able to **drill down** from Level 1 to Level 2.

---

## 💷 Currency Conversion

- All amounts should be displayed in **GBP (excluding VAT)**
- Use **monthly exchange rates from Xero**
- Conversion based on **posting month**

---

## 📎 Attachments / Files

- ✅ Budget 2025–2026 File
    
    [Truvi Group Dept Analysis 2025-26 PBI Test.xlsx](Truvi_Group_Dept_Analysis_2025-26_PBI_Test.xlsx)