Accountra — Multi-Tenant Double-Entry Accounting Platform

Context & Goals

SAP/Oracle-grade multi-tenant accounting SaaS, built from a single YAML schema that generates the Prisma schema, migrations, TypeScript enums, and Zod validation in one pipeline run. Double-entry general ledger, AR/AP, procurement, and RBAC — currently in active private development.

Constraints & Challenges

Multi-tenant accounting platforms live or die on ledger integrity and tenant isolation — every posting must balance to the cent, every tenant's data must be provably walled off, and the schema has to evolve constantly (new modules, new enums, new tables) without hand-edited drift between the database, the API contracts, and the frontend types.

Solution & Approach

Built a YAML-first single source of truth (packages/db/datamodel.yaml) that a three-phase pipeline validates, then compiles into the Prisma schema, runs the migration, and generates shared TypeScript enums and Zod schemas — so the API, frontend, and database can never drift out of sync. Multi-tenancy is enforced at the guard layer via an x-tenant-id header rather than trusted client state. Auth uses JWT access tokens with rotated refresh tokens and optional TOTP 2FA. Redis + BullMQ run background jobs — recurring invoices, payment-term reminders — inside the API process.

Shipped the SaaS foundation, module entitlement system, and full general ledger, then built out Accounts Receivable and Accounts Payable on shared abstractions. The standalone Procurement module is complete end-to-end across all 10 planned phases — requisitions, supplier catalogs, RFQ/quote evaluation, contracts and blanket POs, PO amendments with 3-way match, purchase planning, and analytics dashboards. Banking and year-close modules are in active development, with RBAC-driven permissions and navigation manifests gating every route.

Technology Stack

Results & Impact

• →YAML-first schema pipeline — one command regenerates Prisma schema, migrations, TS enums, and Zod validation from a single source of truth
• →Procurement module complete across all 10 phases: requisitions, RFQ/quotes, contracts, 3-way match, purchase planning, and analytics
• →Multi-tenant isolation enforced at the guard layer via x-tenant-id, with JWT + rotated refresh tokens and optional TOTP 2FA
• →Redis + BullMQ background workers power recurring invoices and payment-term discount reminders
• →575+ commits since bootstrap (mid-July 2026) across General Ledger, AR, AP, Procurement, and RBAC modules