Our own back office, with the morning's admin automated

We needed one place for quotations, invoices, payments, staff pay and partner shares, with figures nobody could quietly change and a clear answer to what the business earned this month.

Database first. Totals, numbering, paid status and permissions are Postgres functions and row-level security, so they hold even if someone calls the API directly. Every change is written to an append-only audit log by database triggers.

Quotations and invoices start from service packages. Payments and refunds can be undone safely, repeating invoices raise themselves, and expenses go through approval against monthly budgets.

Payroll produces printable statements, partners see their share of the profit, and reports can be printed, shared as PDF or emailed. Admins create roles and choose exactly what each one can do.

One job runs at 07:00 Sri Lanka time and does the morning's admin: repeating expenses and invoices, payment reminders and quotation follow-ups by SMS, report emails to each partner on their chosen schedule, and a full backup to Cloudflare R2. Each step runs on its own, so one failure never blocks the rest.