SpendFlow Platform

A high-performance full-stack personal finance and expense management platform built with Next.js 16 App Router, serverless PostgreSQL on Neon (verify-full SSL), CSV bank statement data import wizard, category budget caps, and audited REST API specifications.

https://expense.marco-romero.com

Monthly Income

+$7,950.00

Monthly Expenses

-$2,968.80

Budget Progress (Food & Groceries)23% Used ($184.50 / $800)

Target Latency

< 90ms

Neon Serverless Pool

Data Import Wizard

CSV + JSON

Statement Parser

Security

verify-full SSL

Encrypted Database Pool

Lighthouse Score

100/100 A11y

Mobile FAB & Zero Shifts

Latest Release Updates (v1.4.0)

CSV & JSON Import Wizard

Massive statement parser for bank CSV exports & automated JSON backup restoration.

PostgreSQL verify-full SSL

Strict SSL certificate verification for Neon database pooling drivers.

Mobile Floating Action Button

Fixed mobile FAB for instant expense logging & zero lateral overflow on small viewports.

System Specifications & Architecture

Explore financial system diagrams, relational PostgreSQL database design, and OpenAPI specs.

Full-Stack Data Flow & Cashflow Engine

Client Dashboard

Next.js 16 + React 19

➔ REST API / Bearer ➔

Route Handlers

JWT Auth & Input Sanitizer

➔ SQL / Mock ➔

Neon PostgreSQL

Pooled Database Client

1. Financial Metrics: Server aggregates income vs expense totals and calculates savings rate % dynamically.

2. Budget Engine: Real-time budget progress tracking triggers alert indicators when spending caps exceed 80% or 100%.

3. Hybrid Persistence: Operates seamlessly with Neon serverless Postgres DB or in-browser localStorage mock mode.

Transaction Register

Paginated filtering by category, type, cleared status, search query, and date ranges.

Custom SVG Charts

Lightweight zero-dependency SVG charts for monthly cashflow trends and category breakdowns.

1-Click Recruiter Demo

Instant demo guest mode pre-loaded with sample financial data for evaluation.