Oare Arene
← Back to Projects

OpenBooks

Community finance tracker for groups and co-ops

Role
Solo dev — design, architecture, frontend & backend
Timeframe
2025 — Ongoing
View Live
OpenBooks screenshotOpenBooks screenshot

Overview

OpenBooks is a community finance tracker that makes group accounting transparent, auditable, and easy. It focuses on role-based access, simple transaction management, and visual reporting for community treasurers and members.

Problem

Small organizations and community groups struggle to keep transparent ledgers without heavy accounting tools. Existing apps are either too technical or lack trust and clarity for shared finances.

Goals

  • Lightweight, mobile-first ledger for non-accountants
  • Role-based access and privacy through Supabase RLS
  • Attachments (receipts) and exportable reports

Solution

Built with Next.js + Supabase using Row Level Security for per-org isolation. Transactions, reports, and attachments are unified in one clean interface designed for clarity and auditability.

Architecture / Approach

  • Next.js App Router for SSR/ISR + smooth UX
  • Supabase Auth & Postgres with RLS policies per org
  • Storage for receipt uploads, served via signed URLs
  • Charting & reports via lightweight client components

Key Screens

Organization dashboard — balances and quick stats
Organization dashboard — balances and quick stats
Transactions list with filters and receipt icons
Transactions list with filters and receipt icons
New transaction form
New transaction form
Reports view showing time-scoped breakdown
Reports view showing time-scoped breakdown

Outcomes

  • MVP delivered with clear UX and secure defaults
  • Community-ready foundation for transparent finance

Next Steps

  • Public read-only links for transparency
  • Org-scoped and user-scoped customisable themes
  • Bank CSV import and reconciliation tools

Tech Stack

Next.jsSupabaseRLSTailwindShadcn
← Back to Projects