How enochemerald/personal_finance_tracker works
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