uk-smb-financial-analytics

## 📂 Datasets Used

| File | Rows | Description |

|------|------|-------------|

| General Ledger | 20 | Q1 2026 journal entries (Xero/Sage style) |

| Contacts | 7 | Customer & Vendor master table |

---

## 🔧 Tools & Skills

- **Power Query** — Data cleaning, column renaming, VAT calculation

- **Power BI** — Financial data modeling, DAX measures, interactive dashboard

- **DAX** — CALCULATE, SUM, FILTER

- **UK Accounting** — Double-Entry Bookkeeping, VAT (20%/5%/0%), UK Chart of Accounts

---

## 🧾 UK Chart of Accounts Used

| Account Code | Account Name | Type |

|-------------|--------------|------|

| 1200 | Bank | Asset |

| 2100 | Creditors | Liability |

| 4000 | Sales | Revenue |

| 7000 | Rent | Expense |

| 7300 | Marketing | Expense |

| 7500 | Office Supplies | Expense |

---

## 🧹 Data Cleaning (Power Query)

- Renamed columns to remove £ symbol for DAX compatibility

- Changed data types (Date, Whole Number, Decimal)

- Replaced null values in Debit/Credit with 0

- Added calculated columns:

- `Net Amount` = Debit - Credit

- `Transaction Type` = Debit / Credit

- `Account Category` = Revenue / Expenses / Bank / Creditors

- `VAT Amount` = (Debit + Credit) × VAT_Rate

---

## 📊 DAX Measures

```dax

Total Revenue = CALCULATE(SUM('General Ledger'[Credit]), Account Category = "Revenue")

Total Expenses = CALCULATE(SUM('General Ledger'[Debit]), Account Category = "Expenses")

Gross Profit = [Total Revenue] - [Total Expenses]

Total VAT = SUM('General Ledger'[VAT Amount])

Bank Balance = CALCULATE(SUM('General Ledger'[Debit]), Account Category = "Bank")

```

---

## 📈 Dashboard — UK SMB Financial Overview

- **KPI Cards:** Total Revenue · Total Expenses · Gross Profit · Total VAT · Bank Balance

- **Revenue vs Expenses by Month** (Clustered Bar Chart)

- **Transactions by Account Category** (Pie Chart)

- **Expenses Breakdown by Account** (Bar Chart)

- **Month Slicer** for time filtering