Construction quote-to-cash system
A quote-to-cash system for the doors and hardware division of Crown Building Supplies. It runs every commercial job from bid invitation to purchase orders, billing and reports.
Crown PM dashboard and bid board
01 Overview
Crown PM is the quote-to-cash system for the doors and hardware division of Crown Building Supplies. The division prices and supplies doors and hardware for commercial construction jobs such as hospitals, schools and office campuses, where every job moves through bids, awards, purchase orders, change orders, deliveries and monthly billing.
That work was spread across two paid estimating tools, a master Excel billing workbook and a company ERP that was never built for project work. The division needed one place to follow a job from the emailed bid invitation to the last invoice. We designed and built the whole system.
02 The challenge
The division had the right people and processes, but its tools did not talk to each other, and problems surfaced late.
Estimating and bid tracking ran in two paid tools, while billing lived in a master Excel workbook beside an ERP not built for project work.
Bid invitations arrived by email and had to be copied out of the mailbox by hand.
Change orders, purchase order numbers and approvals had money rules that had to hold, with no system enforcing them.
A missed billing or a late delivery only came to light when someone happened to ask.
03 What we built
We built one Next.js and Supabase system for the division. It covers quoting, bidding, jobs, purchasing, billing, reports and a shared calendar, with permissions checked on every read and write.
A scheduled task reads the bid mailbox every 15 minutes and brings new invitations into the RFQ Inbox. Estimators stop copying bid requests out of email by hand.
Quotes are itemised with markup, overhead and tax, and every revision is kept. Estimators can download a quote as a PDF and always see what changed between versions.
Quotes move across New Requests, Accepted, In Progress and Submitted columns with the total value of each stage shown. The team sees the whole pipeline at a glance.
A won quote becomes a job with one action. Each job has tabs for purchase orders, change orders, RFIs and submittals, shop drawings, deliveries, schedule of values and billing.
Purchase order numbers come from a ledger seeded by the ERP export, so no number can repeat. Orders above a set amount wait on a PO Approvals screen until an approver signs off.
The Billing Tracker replaces the master workbook with a month-by-month grid per job, with export, bulk import and a scan button. Daily scans flag missed billings and late deliveries.
Reports cover vendor spend, vendor performance, per-PM rollup, customer profitability, billing aging, year-over-year billing, WIP schedule, cash-flow forecast and a PM scorecard. Managers get answers without building spreadsheets.
Each person has a task board, and a calendar shows task due dates, deliveries, billing milestones and lien deadlines. Admins define roles from thirty permission keys, enforced by row-level security.
04 The results
Crown PM now follows a job from the first emailed invitation through quote, award, purchase orders, change orders, billing and delivery in one system.
Telecom reseller platform
A platform for an Australian telecom reseller that sells NBN broadband, mobile and business connectivity under its own brand, with a customer portal, a staff back office and an API that ties them to the wholesaler.
Platforms: Website, Web App, Admin Dashboard
Grant consulting CRM
A grant management CRM for consultants who help Italian companies win public funding. It collects open calls, scores them against client projects and tracks each application.
Platforms: Web App
Records warehouse management system
A records storage system for a Riyadh provider that keeps clients' paper files in numbered boxes. It tracks every box, file and shelf, prints barcode labels and turns the activity into monthly VAT invoices.
Platforms: Web App