Skip to main content
OpsHub NAV Hero Light

​
What is OpsHub NAV?

OpsHub NAV is a sophisticated investment fund validation platform built for investment operations professionals at mid-tier fund managers ($5-50B AUM). It provides an Excel-like interface for building ASIC RG94-compliant validation rules while automatically generating SQL queries and Python code.

Excel-Like Interface

Familiar spreadsheet interface powered by Univer.js with custom validation functions

ASIC RG94 Compliance

Built-in regulatory compliance with pre-built validation templates

AI-Powered Queries

Natural language to SQL conversion with visual query building

Temporal Workflows

Durable workflow orchestration with Temporal Cloud

​
Key Features

Excel-like grid powered by Univer.js with custom validation functions like NAV_COMPARE(), RECONCILE(), and BREACH_CHECK(). Real-time formula translation to SQL and Python.
ASIC RG94 compliant validation templates with tolerance-based checking (3bp NAV variance, zero cash tolerance). Real-time validation dashboard with automated breach reporting.
Natural language query understanding with GPT-4, context-aware suggestions, and automatic query optimization. Excel formula to SQL translation powered by OpenAI.
Drag-and-drop canvas for visual query building with auto-join detection, Excel-style calculations, and real-time preview in interactive spreadsheet.
Multi-level holdings with look-through analysis up to 5 levels deep, fee aggregation across fund layers, and Total Expense Ratio (TER) calculations.

​
Technology Stack

Frontend

  • Next.js 15.5.4
  • TypeScript
  • Tailwind CSS 4.0
  • Univer.js
  • React Flow

Backend

  • Supabase (PostgreSQL)
  • TimescaleDB
  • pgvector
  • Redis

Infrastructure

  • Temporal Cloud
  • Fly.io
  • Docker
  • OpenAI API

​
Target Users

  • Investment Operations Professionals - Daily NAV calculation and validation
  • Fund Administrators - Multi-fund portfolio management
  • Compliance Officers - Regulatory reporting and breach monitoring
  • Portfolio Managers - Performance attribution and analytics

​
Getting Started

Quickstart Guide

Get up and running in 5 minutes

Core Concepts

Learn the fundamentals of OpsHub NAV

API Reference

Explore the complete API documentation

Database Schema

Understand the data architecture

​
Need Help?

Support

Contact our support team

Community

Join our community Slack