Reza Salmanian

Command Palette

Search for a command to run...

All projectsFinance · Analytics

Finance Platform

Financial Operations & Executive Insights Platform

The Finance Platform turns raw financial documents and transactions into forecasts, KPIs, and executive-ready reporting without manual reconciliation.

Timeline

  1. Phase 1

    Ingestion

    Built OCR-based document capture pipeline

  2. Phase 2

    KPI layer

    Standardized shared KPI definitions and data model

  3. Phase 3

    Forecasting

    Added versioned, trend-based forecasting

  4. Phase 4

    Reporting

    Shipped executive reporting and dashboards

Executive Summary

A finance module that automates the path from source documents to executive insight: OCR-based capture, standardized KPI tracking, forecasting, and reporting, built to remove manual reconciliation from the monthly close cycle.

Business Problem

Finance teams at growing companies spend a disproportionate amount of time on manual data entry and reconciliation — retyping invoices, cross-checking spreadsheets, and rebuilding the same reports every month. That manual work delays the numbers leadership needs to make decisions and introduces avoidable error.

Project Goals

  • Automate document capture so invoices and statements don't require manual re-entry
  • Standardize KPI definitions so every report uses the same underlying calculation
  • Provide forecasting based on historical trends rather than a rebuilt spreadsheet each cycle
  • Give executives a reporting view that updates continuously instead of at month-end

Solution Overview

Documents are captured and parsed through an OCR pipeline into structured records, which feed a KPI layer with standardized definitions shared across dashboards, forecasts, and exports. Forecasting models run against historical actuals to project forward, and an executive reporting layer packages the results without a manual rebuild step.

Architecture Decisions

  • Separated document capture (OCR/ingestion) from KPI computation, so improving one doesn't require touching the other
  • Defined KPIs once in a shared calculation layer consumed by every dashboard and export, eliminating the classic problem of two reports disagreeing on the same metric
  • Built forecasting as a scheduled, versioned process so historical forecasts remain auditable rather than being overwritten

Screenshots

Illustrative interface

Finance overview

Synthetic data · not production numbers

Monthly recurring revenue

$482K

12.4% vs. last period

Active client workspaces

1,284

8.1% vs. last period

Forecast accuracy

94.2%

2.3% vs. last period

Open exceptions

7

18% vs. last period

Monthly recurring revenue

$0K$250K$500KJanMarMayJulSepNov$482K

Alerts

  • Reconciliation variance above threshold — Vendor AP batch #4471

    Critical · Finance · 12 min ago

  • 3 invoices pending approval for more than 5 days

    Warning · Accounts payable · 1 hr ago

  • Forecast confidence dropped below 90% for APAC region

    Serious · Forecasting · 3 hrs ago

  • Month-end close completed on schedule

    Resolved · Finance · Yesterday

Recent activity

AccountModuleAmountStatusDateDrill down

Acme Logistics

Invoice #10432

AR$18,400ClearedJun 12

Meridian Retail Group

Purchase order #2291

AP$6,120PendingJun 11

Northwind Vendors

Reconciliation batch #4471

Reconciliation$42,900FlaggedJun 11

Summit Health Partners

Invoice #10419

AR$9,750ClearedJun 10

Blue Harbor Freight

Forecast adjustment

ForecastingPendingJun 9

Architecture Diagram

Finance platform data pipeline

Document ingestion & OCR
Human-in-the-loop review (low confidence)
Shared KPI calculation layer
Forecasting engine & executive reporting

Technical Challenges

  • Handling inconsistent source-document formats reliably enough that OCR output could be trusted without manual review of every line
  • Designing KPI definitions general enough to serve multiple report types without duplicating logic
  • Balancing forecast responsiveness (reacting to recent trends) against stability (not swinging wildly on noisy data)

Engineering Decisions

  • Added a human-in-the-loop review step for low-confidence OCR extractions rather than forcing full automation on day one
  • Built the KPI layer as a queryable data model rather than pre-baked reports, so new report types could be added without new pipelines

My Responsibilities

  • Designed the data pipeline from document ingestion through KPI computation to reporting
  • Built the forecasting architecture and its versioning approach
  • Owned the executive reporting layer and its data visualization strategy

Technology Stack

TypeScriptReactNext.jsNode.jsPostgreSQLGoogle Cloud PlatformCloud StorageCloud Functions

Results

  • Cut manual data entry time on recurring financial documents substantially
  • Reduced discrepancies between reports by standardizing KPI definitions in one place
  • Moved leadership reporting from a month-end event to a continuously current view

Lessons Learned

  • Full automation of document capture was less valuable than automation plus a fast human review step for edge cases — trust mattered more than speed alone
  • Centralizing KPI definitions early avoided a much more expensive migration later, once multiple teams had built reports on inconsistent calculations

Next project

CRM Platform

Continue