Inspiration

Inspiration Growing up, I watched a family member run a small business. I saw firsthand the constant stress they faced trying to keep track of money coming in and going out. They were incredible at running their business, but when it came to managing finances, they were trapped between two terrible options: spending hours wrestling with overly complex accounting software built for accountants, or relying on messy spreadsheets that quickly became outdated and broken.

They didn't fail because they lacked a great product or hard work; they struggled because standard tools never clearly answered basic, vital questions: "When will we run out of cash?", "Which vendor quietly raised their prices?", or "Can we actually afford to make this next hire?"

I built CashFlow360 to solve this exact problem. It is designed as a lightweight, intelligent financial operating system that gives small business owners complete, actionable financial visibility—without requiring a finance degree or a full-time accounting department.

What it does

CashFlow360 turns raw transaction, invoice, vendor, budget, and account data into a single workspace for daily cash management and forward planning:

Overview Command Center: Displays real-time Cash Balance, Net Cash Flow, Active Risk Alerts, and Projected Cash Runway.

Smart Alert Center: Detects critical runway drop-offs, vendor expense spikes, high burn rates, low balances, and duplicate charges, pushing real-time payloads via webhooks to Slack, Discord, or Zapier.

What-If Scenario Sandbox: Allows business owners to simulate hiring employees, purchasing machinery, or losing clients to immediately test financial impacts without modifying actual transaction logs.

Invoices and Client Analytics: Tracks accounts receivable, generates pre-filled reminder emails for overdue balances, and computes Client Lifetime Value (LTV) alongside retention metrics.

Vendor Intelligence and Price Creep Detection: Tracks supplier costs over time and automatically flags hidden price increases.

Multi-Account Reconciliation: Identifies internal transfers between checking, savings, credit, and tax reserve accounts, excluding them from revenue and expense totals to prevent artificial burn distortion.

How we built it

We designed CashFlow360 with a modular architecture focused on fast dynamic updating, low overhead, and deterministic financial calculations:

Frontend: Built with semantic HTML5, modern CSS3 (featuring custom light/dark themes and responsive mobile menus), and vanilla JavaScript to keep the interface fast and dependency-free.

Backend Engine: Powered by Python to handle data validation, server-side business logic, financial math routines, and custom webhook dispatching.

Database and Security: Utilized SQLite for lightweight relational storage of user accounts, transaction ledgers, vendor metadata, and invoice records. Passwords are salted and securely hashed using bcrypt prior to storage.

Testing and Logic Verification: Built a custom Node test runner to validate ledger mathematical equations, runway corner-cases, and reconciliation matching logic across test transaction suites.

Key mathematical formulas implemented in the engine include:

Net Cash Flow = Total Inflows - Total Outflows

Average Daily Burn Rate = (Total Expenses During Last 30 Days) / 30

Runway Days = Current Cash Balance / Average Daily Burn Rate

Price Creep Percentage = ((Current Price - Historical Average) / Historical Average) * 100

Tax Reserve = max(0, Taxable Net Profit) * Tax Rate

Challenges we ran into

Internal Transfer Matching and Reconciliation: Distinguishing true business operational spending from simple internal transfers between accounts (e.g., shifting money from checking to tax savings) was difficult. If unmanaged, transfers double-count as expenses or revenue. We built a reconciliation engine that checks opposite inflow/outflow directions, matching amounts, non-identical account IDs, and close date windows.

Handling Zero/Negative Burn Runway States: Dividing cash balance by zero burn rate or handling net-positive periods initially caused mathematical edge cases. We updated the model to dynamically evaluate cash-flow states and return an "Indefinite / Cash Flow Positive" flag when burn rate is non-positive.

Price Creep Baseline Drift: Simple historical averages caused false alerts when tracking price creep over long periods. Establishing thresholds that evaluate recent baseline trends without flagging regular recurring adjustments required strict parameter tuning.

Accomplishments that we're proud of

Built a complete end-to-end financial system featuring zero synthetic mockup dependencies—every metric on the workspace updates directly from live CSV imports or manual transaction entries.

Developed a zero-friction What-If Scenario Sandbox that lets non-technical founders model high-risk financial decisions in seconds before committing capital.

Implemented clean webhook payload generation allowing external integration into automation workflows like Zapier, Make, and Slack.

Designed an accessible, calm design theme with responsive mobile navigation and automatic state persistence.

What we learned

Financial UX demands simplicity over complexity: Founders care less about double-entry journal entries and more about actionable answers to core questions: "When do I run out of money?" and "Can I afford this new hire?"

Data hygiene drives trust: Edge cases in transfer matching or duplicate charge alerts destroy user trust instantly if they result in false financial numbers.

Strict security standards are non-negotiable: Even in a prototype, financial tools demand proper password salting/hashing, session isolation, and clean authorization boundaries.

What's next for CashFlow360

Net Burn Refinement: Update default runway metrics to evaluate Net Burn (Total Outflows - Total Inflows) alongside trailing median price creep detection to eliminate baseline skew.

PostgreSQL and Cloud Infrastructure: Migrate backend storage from SQLite to PostgreSQL to support write concurrency, encrypted database connections, and session scaling.

Direct Plaid / Open Banking Integration: Move beyond manual CSV/JSON bank statement uploads by connecting directly to bank feeds for real-time transaction syncing.

Automated Vendor Renegotiation: Auto-generate pre-filled pricing negotiation email templates backed by historical price creep metrics whenever a vendor raises fees.

Share this project:

Updates

Submission history