Hisaab EZ BYOK Setup Guide
Use this once per company. Netlify hosts the frontend. Each company connects its own Supabase project.
Step 1: Create Supabase Project
Who: Company owner or IT person
- Go to Supabase dashboard and create a project.
- Open Project Settings -> API.
- Copy:
- Project URL
- Anon public key
Step 2: Connect in App
Who: Company owner or first admin
- Open your Hisaab EZ app URL.
- In setup Step 1, paste URL + anon key.
- Click Connect & Check Schema.
Step 3: Initialize Database Schema
Who: Company owner or IT person
- In setup Step 2, click Open Supabase SQL Editor.
- Copy SQL from app (Copy SQL button) or open
supabase/schema.sql.
- Paste and run SQL in Supabase SQL Editor.
- Return to app and click Re-check Schema.
Step 4: Activate Project License
Who: Company owner
- In setup Step 3, click Buy One-Time License (Stripe) or paste a signed key.
- Complete payment and return to app.
- App validates key and project binding automatically.
Step 5: Create First Account
Who: Company owner
- In setup Step 4, click Sign Up.
- The first account automatically becomes superuser/admin.
- Other team members can sign in from any PC using the same Supabase project credentials.
Important Notes
- Never put service-role key in browser.
- Only Project URL + anon key are used in frontend.
- License private key stays in Netlify env vars only.
- Each new PC/browser must connect once (saved locally in that browser).
- Optional prefilled link format:
?hez_url=...&hez_anon=...
- For Stripe setup details, open
LICENSE_SETUP.md.
Troubleshooting
If you see an RLS sync error for app_records:
- Run latest schema SQL again in Supabase SQL Editor (
supabase/schema.sql).
- Or run migration
supabase/migrations/003_fix_next_ids_rls_and_schema_version.sql.
- Back in app, click Re-check Schema.