Speed
Fintech
Speed Cash Deposit Manager (CDM)
Automates Green Dot cash-deposit reconciliation, settlement tracking, and revenue reporting for finance teams.
THE CHALLENGE
Not available title-The Problem / Challenge
Before CDM, Speed's finance team reconciled Green Dot cash deposits manually across three disconnected sources: raw webhook payloads, daily SFTP CSV reports, and bank Advice-of-Credit statements. Amounts differed by design — reports showed gross amounts, wallets showed gross - $4 SpeedFix fee, and bank credits arrived on a T+2 schedule that shifted around weekends and US bank holidays. Every mismatch became a spreadsheet investigation.
Who was affected
Finance operations (daily recon), treasury (payout visibility to Green Dot), leadership (revenue clarity), and support (customer deposit disputes).
Previous process
Google Sheets pivoting three CSV exports, manual date-shifting for weekends/holidays, ad-hoc SQL against production, and Slack threads to trace individual dp_* IDs.
Cost of the problem:
• 6–8 hours per week per analyst spent on manual reconciliation • Recurring $4-per-transaction ghost mismatches after the SpeedFix fee launched • Missed/late settlement records (e.g. Apr 14 batch, webhook dp_mprc60m3NePIg8pe) invisible until month-end
The solution
Not Avilable-The Solution
CDM unifies every deposit signal — Green Dot webhooks, SFTP transmission reports, and bank settlement expectations — into one live dashboard. It auto-computes expected settlement dates using T+2 business-day logic that skips Saturdays, Sundays, and the full US bank holiday calendar, then flips each batch from "Unsettled" to "Settled" only after the 7 PM IST bank-credit cutoff. A dedicated Revenue view breaks down total earnings as Transaction Fee Revenue - Payable to Green Dot, and admin-only Settlement Reconciliation exposes daily/monthly history with weekend rollups. Role-based access, an alerts engine, and per-retailer/per-customer drill-downs round out the platform.
Key feature
Integrations & tech stack
The platform is built on a modern React + TypeScript frontend, a Lovable Cloud backend with Postgres and RLS, and edge functions for secure, advisory-locked operations.
Frontend
React 18, Vite 5, TypeScript 5, Tailwind, shadcn/ui, TanStack Query
Backend
Lovable Cloud (Postgres + RLS, Auth, Edge Functions)
Integrations
Green Dot Webhooks, Green Dot SFTP transmission reports, Bank Advice-of-Credit
What's clever
Not Available
Weekend/holiday-aware addBusinessDays utility drives every settlement date in the app — one function, zero drift
Not Available
Google Sheets pivoting three CSV exports, manual date-shifting for weekends/holidays, ad-hoc SQL against production, and Slack threads to trace individual dp_* IDs.
Not Available
$4 fee treated as a first-class reconciliation rule with a hard start date (8 Jun 2026) so historical rows stay clean
Results & Impact
The platform replaced multi-hour manual reconciliation with an always-on live dashboard. Highlights: