Your bills will be stored in Supabase — a free cloud database. Setup takes about 5 minutes.
2
Once the project loads, go to SQL Editor and paste and run this SQL to create your tables:
CREATE TABLE bills (
id BIGSERIAL PRIMARY KEY,
date TEXT NOT NULL,
vendor TEXT,
bill_no TEXT,
payment TEXT,
note TEXT,
total NUMERIC,
created_at TIMESTAMPTZ DEFAULT NOW()
);
CREATE TABLE bill_lines (
id BIGSERIAL PRIMARY KEY,
bill_id BIGINT REFERENCES bills(id) ON DELETE CASCADE,
cat_id TEXT,
cat_name TEXT,
cat_color TEXT,
description TEXT,
qty NUMERIC,
unit TEXT,
rate NUMERIC,
amount NUMERIC
);
CREATE TABLE categories (
id TEXT PRIMARY KEY,
name TEXT,
color TEXT,
unit TEXT,
sort_order INT DEFAULT 0
);
CREATE TABLE budgets (
cat_id TEXT PRIMARY KEY,
amount NUMERIC
);
ALTER TABLE bills ENABLE ROW LEVEL SECURITY;
ALTER TABLE bill_lines ENABLE ROW LEVEL SECURITY;
ALTER TABLE categories ENABLE ROW LEVEL SECURITY;
ALTER TABLE budgets ENABLE ROW LEVEL SECURITY;
CREATE POLICY "allow_all_bills" ON bills FOR ALL USING (true) WITH CHECK (true);
CREATE POLICY "allow_all_lines" ON bill_lines FOR ALL USING (true) WITH CHECK (true);
CREATE POLICY "allow_all_cats" ON categories FOR ALL USING (true) WITH CHECK (true);
CREATE POLICY "allow_all_budgets" ON budgets FOR ALL USING (true) WITH CHECK (true);