POS / Operations · 2025
Restaurant Management System
Multi-outlet back office that pulls sales from the QuickBill POS and purchases from Odoo into one database: closings, food cost, recipes, P&L, forecasts and vendor supply sheets.
- Client
- Restaurant outlets of the Ashwheelz group, Lahore
- Role
- Product design, build, integrations, hosting
- Stack
- Next.js 14 · TypeScript · Prisma 5 · PostgreSQL · Docker · Railway · WhatsApp Cloud API
Updated 14 Nov 2026
The problem
Sales lived in the POS, purchases in Odoo, cashier closings in WhatsApp photos. Food cost was a guess, the P&L arrived weeks late, and nobody could say which outlet was actually making money.
What I built
A Next.js app on Prisma/PostgreSQL that signs in to the POS and Odoo the way a person does (no API keys to leak), syncs sales and purchases on a schedule, and computes everything from one ledger: subtotal, delivery/rider/service charges, 13% GST, COGS by category, percentage charge rules and prorated fixed expenses. Cashier sheets are reconciled against portal sales line by line.
- Outlet dashboard: sales, payment split, variance vs cashier closing
- Recipes / bill of materials with food-cost variance and consumption sheets
- P&L per outlet with business-day cut-off hour
- Sales forecast: 56-day window, 30-day horizon, calendar-event aware
- Vendor demand and supply-chain sheets rendered to JPG and sent by WhatsApp Cloud API
- Item targets, vendor payments, fixed expenses, expense analysis
- Role-based access, activity log, scheduled sync, database backups
Outcome
43 data models and 34 screens replaced four spreadsheets and a WhatsApp group; food cost and P&L are per outlet, per day, the next morning.
Screens
Want this for your company?
The engagement is described on the Restaurant back office service page: who it is for, what you get, how it runs, and the questions I get asked.
Offered through Tech Solutions
This kind of system is delivered commercially by my company, Tech Solutions. The matching pages there:
Notes from this build
Have a process like this?
Send me the thing your team does by hand every week. I will tell you honestly whether it is worth automating, even when the answer is no.
