← Back to work
DatabaseBackend only

Multi-Tenant Bookkeeping Database

PostgreSQL schema for merchants, settlements, VAT, and webhooks.

What they needed

A bookkeeping SaaS MVP needed a Postgres design for merchants, payments, settlements, VAT, and webhook events from Salla/Zid-style platforms.

What I delivered

  • PostgreSQL dump with merchants, transactions, settlements, vat_reports, webhook_events
  • Payment method enums aligned to regional gateways
  • Indexes plus a VAT summary function
  • ERD and developer documentation (including revisions)

Why it helped

Backend work can proceed on a multi-tenant ledger model instead of inventing tables under pressure.

Tech in the build

PostgreSQL

Access

Backend-only (database design — no public UI)