Kaizen Internal

Internal management tool for finance tracking.

Overview

Property	Value
Framework	Next.js
Database	Supabase (PostgreSQL)
Purpose	Finance tracking

Features

• Transaction tracking - Income and expenses
• Monthly summaries - Automated reports
• Balance tracking - Running balance

Database Schema

transactions table

CREATE TABLE transactions (
    transaction_id SERIAL PRIMARY KEY,
    date_time TIMESTAMP DEFAULT now(),
    is_income BOOLEAN NOT NULL,
    amount_rupiah INTEGER NOT NULL,
    description TEXT,
    current_balance INTEGER DEFAULT 0
);

Key Functions

• get_monthly_summaries() - Returns monthly income/expense totals

Access

Internal tool - restricted access.

File Location

websites/kaizen-internal/
├── src/
├── supabase-schema.sql   # Database schema
└── package.json