🎯 The Challenge
Before this system, quotes and BOMs were being built manually in documents and spreadsheets. Copy-paste across tools caused errors and ate up hours. Data drifted between deals, items, and customer records — and nobody had a clean view of which quote belonged to which deal, or whether the totals were right.
- Automate quote creation directly from the Deals pipeline
- Ensure accurate tax and total calculations every single time
- Generate BOM files in seconds, on demand
- Keep all data synchronized across multiple Monday.com boards
🧩 The Solution
Five interlinked Monday.com boards — Deals, Quote Generation, Item Management, BOM, and Customer — tied together with relations and mirror columns so every quote and BOM stays connected to the right deal and customer. Make.com handles the document generation, calculations, and OneDrive integration in the background.
- Deals / Opportunities — the pipeline
- Quote Generation — where each quote is built
- Item Management — the product/service catalog
- BOM — the bill-of-materials records
- Customer — the buyer record everything ties back to
- Fills a predefined quote template
- Calculates line totals, subtotals, tax, and grand total
- Generates the quote file (PDF/Doc)
- Saves to OneDrive and attaches the file back to the Monday.com item
🛠 Tools & Stack
📈 Results & Impact
- Quotes and BOMs in seconds — regardless of the number of line items, the document generates from a single click instead of hours of manual work.
- Calculation errors eliminated — built-in totals, subtotals, and tax math run consistently every time, no human arithmetic involved.
- Scales without effort — the system supports high deal volume and large catalogs with no additional setup per quote.
- Better visibility for sales & ops — all quotes and BOMs remain linked to deals, items, and customers inside Monday.com, so anyone can see the full picture.
🖼 Screenshots