INVOX: Smart Invoice Analysis Platform for Your Business

Table of Contents

• Application Overview
• Key Features
• Tech Stack
• Database Architecture
• Workflow Overview
• License

Application Overview

INVOX is an intelligent invoice management system that automates the entire invoice processing workflow. Upload PDF invoices and let AI handle the rest - extracting supplier details, line items, amounts, and dates directly into your database.

What INVOX does:

• Extracts data from PDF invoices using AI (OpenAI)
• Automatically creates and manages supplier records
• Stores invoice metadata, line items, and financial summaries
• Provides real-time processing status updates
• Sends email notifications on success/failure
• Displays financial insights through an interactive dashboard

Demo

invox_demo.mp4

Key Features

Feature	Description
📄 PDF Upload	Drag & drop invoice PDFs for instant processing
🤖 AI Extraction	OpenAI-powered data extraction - no manual entry
📊 Dashboard	Visual overview of spending, invoices, and suppliers
👥 Supplier Management	Track vendors with contact info and invoice history
💰 Financial Insights	Monthly spending trends and supplier analytics
⚡ Real-time Updates	Live status tracking during invoice processing
🔔 Email Notifications	Get notified on successful/failed processing
🔐 Authentication	Secure login via Supabase Auth

Workflow Overview

n8n Invoice Processing Pipeline

The automated workflow processes invoices through these stages:

Workflow Features

• Automatic Supplier Creation: If supplier doesn't exist, creates new entry
• Duplicate Detection: Checks for existing invoice numbers
• Error Handling: Failed invoices marked with error status
• Real-time Status: Frontend shows processing progress live
• Data Validation: Ensures all required fields are present

Tech Stack :

Frontend

• React 18 - Modern UI library
• TypeScript - Type-safe development
• Vite - Lightning-fast build tool
• Tailwind CSS - Utility-first styling

Backend & Database

• Supabase - PostgreSQL database + Auth + Storage + Real-time
• n8n - Workflow automation & AI integration
• PostgreSQL - Relational database
• Webhook Integration - Real-time status updates

Database Architecture :

suppliers

Stores supplier/vendor information

• Primary contact details (email, phone)
• VAT/Tax identification numbers
• Physical addresses

invoice_metadata

Core invoice information

• Unique invoice numbers
• Invoice and due dates
• Payment status (is_paid)
• Links to suppliers via foreign key
• Optional notes/comments

financial_summary

Financial calculations per invoice

• VAT/Tax calculations
• Subtotal and total amounts
• Payment terms
• One-to-one relationship with invoices

items

Individual line items from invoices

• Product/service descriptions
• Quantities and units
• Unit prices and totals
• Many-to-one relationship with invoices

uploaded_invoices

Tracks uploaded PDF files

• Original file names and storage URLs
• Upload metadata (name, description, date)
• Processing status for n8n workflow

License

This project is currently unlicensed. All rights reserved.