All work
TypeScript // Fintech

OmniReview

A review and tipping platform for multi-location businesses, built around a prepaid, append-only credit ledger and idempotent payment webhooks.

Highlight
Integer-cent ledger with overdraft protection
Role
Design & engineering
Status
In development
Stack
TypeScriptNext.jsReactPrismaPostgreSQLStripeTwilioInngest

The problem

Businesses with many locations want more good reviews online, want to hear about bad experiences privately, and want an easy way for customers to tip the staff who served them.

How it works

Organizations are modeled as a hierarchy — client organization, location, employee — so each location has its own credit balance and branding.

  1. An employee sends a customer a review request by SMS. A background job deducts the SMS cost from the location's prepaid credits, sends the message through Twilio, and marks the request as sent.
  2. The customer opens a personal link and rates their visit.
  3. A 1–3 star rating goes privately to the location's admin as feedback. A 4–5 star rating offers an optional tip, then sends the customer on to leave a public Google review.
  4. Payments run through Stripe Checkout; a webhook records credit top-ups and tips and closes the request.

Key decisions

The ledger is the truth. Credits live in an append-only ledger of integer-cent entries; zero and fractional amounts are rejected. A cached balance on each location is updated in the same database transaction, but the real balance is always the sum of the ledger.

No overdrafts. Every deduction re-checks the balance inside its transaction and fails cleanly if it would go negative.

Webhooks are idempotent. Stripe signatures are verified on every event. A top-up is applied only once, checked against an audit log in the same transaction, and tips are keyed on Stripe's payment ID, so a retried webhook can never create a second tip.

Durable background jobs. SMS sending runs as retryable steps on Inngest — deduct, send, update — so a failure partway through can resume instead of double-charging.

What's next

OmniReview is still in development. Next up are real authentication, a production PostgreSQL database, and Stripe Connect payouts so tips route directly to employees.