# enochemerald/personal_finance_tracker architecture

> Architecture diagram of the GitHub repository enochemerald/personal_finance_tracker, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2025-05-27). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/enochemerald/personal_finance_tracker
- Repository: https://github.com/enochemerald/personal_finance_tracker

## Overview

##### Project type and purpose
- This is not a traditional code‐based system but a data‐analysis/dashboard solution built entirely in Microsoft Excel.
- Purpose: ingest personal‐finance transaction data, categorize and aggregate it, then present visual dashboards and insights to help users analyze income, spending, savings, and budget trends.

##### “architecture” from the file structure & README
- Files:
- Personal Finance Tracker.xlsx – the core application, containing raw data, processing logic (formulas/pivot tables/macros), charts and dashboards.
- Personal Finance Tracker.pdf – likely a static export or report.
- README.md – describes problem, data, metrics, and recommendations.
- No backend services, no external APIs—everything lives in a single Excel workbook.

##### Main components
a. Data Input Layer
- Raw Transactions Sheet (user‐entered or imported CSV data)
- Parameter Tables (e.g., categories, budget thresholds)
b. Processing Layer (Excel Engine)
- Formula‐based Calculations (e.g., monthly totals, category aggregates)
- Pivot Tables / Power Pivot Data Model
- Macros or VBA (if used) for automating imports/categorization
c. Analytics & Insights
- Metrics calculation (Total Income, Total Spending, Available Balance)
- Trend Analysis engines (day‐of‐week, month‐over‐month comparisons)
d. Presentation Layer (Dashboard)
- Charts (bar, line, pie) for income vs. expenses, category breakdown
- Conditional formatting & sparklines
- Recommendation callouts
e. External Interfaces (optional)
- Manual CSV import from bank statements
- PDF export

##### Relationships & Data Flow
- User enters or imports raw data → Raw Transactions Sheet
- Excel formulas & macros pick up raw data → Processing Layer
- Pivot tables / data model aggregate & group by category/date → Analytics Layer
- Dashboard reads from pivot outputs → Presentation Layer
- User views charts & derives recommendations; may export to PDF

##### Architectural patterns & design principles
- Separation of Concerns: Raw Data vs. Calculations vs. Visualization
- Reusability: Parameter tables drive formulas and pivot logic
- Single Source of Truth: All data and logic resides in one .xlsx workbook

## Diagram (Mermaid)

```mermaid
flowchart TD
    %% External actor
    User["User"]:::external

    %% External data source
    ExternalCSV["Manual CSV Import"]:::external

    %% Layers
    subgraph "Data Input Layer"
        Input["Raw Transactions\n& Parameter Tables"]:::storage
    end

    subgraph "Processing Layer"
        Processing["Formulas\nPivot Tables\nVBA Macros"]:::computation
    end

    subgraph "Analytics & Insights"
        Analytics["Metrics Calculation\nTrend Analysis"]:::computation
    end

    subgraph "Presentation Layer"
        Presentation["Charts\nConditional Formatting\nRecommendation Callouts"]:::visual
    end

    %% External export and docs
    PDFExport["PDF Export"]:::external
    README["README"]:::documentation

    %% Data flow
    User -->|"Enter or Import Data"| Input
    ExternalCSV -->|"Import CSV"| Input
    Input -->|"Data Feeds"| Processing
    Processing -->|"Aggregate & Transform"| Analytics
    Analytics -->|"Provide Data"| Presentation
    Presentation -->|"Export Report"| PDFExport

    User -->|"Refresh Data"| Processing
    User -->|"View Documentation"| README

    %% Click Events
    click Input "https://github.com/enochemerald/personal_finance_tracker/blob/main/Personal Finance Tracker.xlsx"
    click Processing "https://github.com/enochemerald/personal_finance_tracker/blob/main/Personal Finance Tracker.xlsx"
    click Analytics "https://github.com/enochemerald/personal_finance_tracker/blob/main/Personal Finance Tracker.xlsx"
    click Presentation "https://github.com/enochemerald/personal_finance_tracker/blob/main/Personal Finance Tracker.xlsx"
    click PDFExport "https://github.com/enochemerald/personal_finance_tracker/blob/main/Personal Finance Tracker.pdf"
    click README "https://github.com/enochemerald/personal_finance_tracker/blob/main/README.md"

    %% Styles
    classDef storage fill:#ADD8E6,stroke:#333,stroke-width:1px
    classDef computation fill:#90EE90,stroke:#333,stroke-width:1px
    classDef visual fill:#FFA500,stroke:#333,stroke-width:1px
    classDef external fill:#D3D3D3,stroke:#333,stroke-width:1px
    classDef documentation fill:#F0E68C,stroke:#333,stroke-width:1px
```
