---
title: Giftson Tensingh | Expense Analytics - Dynamic CSV Data Engine
description: Dynamic CSV Data Engine and Expense Analytics dashboard built by Giftson Tensingh. Interactive financial visualization and transaction analysis.
image: https://giftson.fyi/favicon.png
---

# Expense Analytics & Dynamic CSV Data Engine

**Author:** Giftson Tensingh  
**URL:** [https://giftson.fyi/analyze.html](https://giftson.fyi/analyze.html)

---

## Overview

The **Expense Analytics Engine** is a high-performance, client-side data parsing and visualization tool engineered to ingest arbitrary bank statements, expense logs, and credit card CSV exports. It turns raw tabular transaction logs into actionable spending insights, anomaly detections, and categorical summaries without uploading sensitive data to any remote server.

---

## Core Capabilities

1. **Intelligent CSV Ingestion:**
   - Heuristic column mapping automatically detecting Date, Description/Narration, Category, Debit/Credit Amount, and Balance columns.
   - Robust handling of various currency formats, date separators (DD/MM/YYYY vs. MM/DD/YYYY), and quoted values.
2. **Dynamic Spending Categorization:**
   - Automatic regex-based tag assignment for common spend areas (Groceries, Utilities, Subscriptions, Dining, Travel, Healthcare).
   - Custom category override and rule addition in real-time.
3. **Statistical Aggregations & KPIs:**
   - Total Outflow, Total Inflow, Net Savings Rate, Daily Average Burn, Highest Single Expense, and Recurring Monthly Overhead.
4. **Interactive Visualizations:**
   - Monthly trend graphs, Category Pareto charts, and Day-of-week spend heatmaps.
5. **Zero-Trust Privacy:**
   - Parsing, transformation, and chart rendering execute 100% inside the browser Web Worker / DOM thread. No financial data leaves the local device.

---

## Technical Stack

- **Engine:** Vanilla JavaScript + Web Workers for non-blocking large dataset parsing (supporting 50,000+ CSV rows).
- **Visualization:** Canvas-based Chart.js and custom CSS data grids.
- **Styling:** Responsive utility CSS with full dark/light theme fidelity.

```json
{
  "@context": "https://schema.org",
  "@type": "WebApplication",
  "name": "Expense Analytics - Dynamic CSV Data Engine",
  "url": "https://giftson.fyi/analyze.html",
  "applicationCategory": "FinanceApplication",
  "operatingSystem": "All",
  "author": {
    "@type": "Person",
    "name": "Giftson Tensingh",
    "url": "https://giftson.fyi/"
  }
}
```