Track clients from first site visit to signed contract, keep a vetted contractor roster with insurance expiry, and schedule every job.
Sign in with your Edesy account, then click Use template in the preview to copy the base, with its sample rows, into your workspace.
Category
Tables
Clients, Contractors, Jobs
Fields
33
Views
grid, kanban, form, timeline
The 3 linked tables in this template, with their real columns, field types and sample rows. Copy the template to edit them in Edesy Tables.
12 fields · 5 sample rows
| ClientText | PhonePhone | EmailEmail | Site addressAddress | Project typeSingle select | Estimated valueCurrency | SourceSingle select | StageSingle select | Next follow-upDate | JobsLink to another table | Contracted valueRollup | NotesLong text |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Mr. & Mrs. Bhosale | +91 98220 31313 | [email protected] | Plot 18, Baner, Pune, Maharashtra, India | New build | ₹95,00,000 | Architect | Contracted | Bhosale villa — structure, Bhosale villa — interiors | ₹1,16,00,000 | ||
| Café Mocha Koregaon Park | +91 98500 42424 | [email protected] | Interior fit-out | ₹28,00,000 | Negotiation | 21 Nov 2026 | ₹0 | ||||
| Rebecca Hughes | +91 97600 53535 | [email protected] | Renovation | ₹14,00,000 | Referral | Estimate sent | 24 Nov 2026 | ₹0 | |||
| Shinde Warehousing | +91 98810 64646 | Commercial | ₹2,20,00,000 | Website | Site visit | 20 Nov 2026 | ₹0 | ||||
| Vivek Malhotra | +91 99220 75757 | Extension | ₹18,00,000 | Site board | Contracted | Malhotra first-floor extension | ₹17,50,000 |
Form view “Request a site visit” asks for: Client, Phone, Email, Site address, Project type, Notes.
11 fields · 4 sample rows
| ContractorText | TradeSingle select | Contact personText | PhonePhone | Licence no.Text | Insurance expiryDate | InsuranceFormula | Day rateCurrency | RatingRating | JobsLink to another table | Active jobsCount |
|---|---|---|---|---|---|---|---|---|---|---|
| Volt Electricals | Electrical | Sanjay Pawar | +91 98230 11111 | MH-EL-22/4471 | 7 Jun 2027 | Valid | ₹4,500 | 5/5 | Bhosale villa — structure | 1 |
| AquaFix Plumbing | Plumbing | Rafiq Shaikh | +91 98230 22222 | 7 Dec 2026 | Expiring soon | ₹3,800 | 4/5 | Bhosale villa — structure | 1 | |
| WoodCraft Interiors | Carpentry | Joseph Pereira | +91 98230 33333 | 9 Nov 2026 | Expired | ₹4,200 | 4/5 | Malhotra first-floor extension, Bhosale villa — interiors | 2 | |
| ColourPro Painters | Drywall & painting | Ganesh Jadhav | +91 98230 44444 | 5 Oct 2027 | Valid | ₹2,800 | 3/5 | Malhotra first-floor extension | 1 |
10 fields · 3 sample rows
| JobText | ClientLink to another table | ContractorsLink to another table | Project managerText | StartDate | FinishDate | Duration (days)Formula | Contract valueCurrency | StatusSingle select | Service notesLong text |
|---|---|---|---|---|---|---|---|---|---|
| Bhosale villa — structure | Mr. & Mrs. Bhosale | Volt Electricals, AquaFix Plumbing | Nikhil | 5 Oct 2026 | 2 Feb 2027 | 120 | ₹92,00,000 | In progress | |
| Malhotra first-floor extension | Vivek Malhotra | WoodCraft Interiors, ColourPro Painters | Ayesha | 29 Nov 2026 | 13 Jan 2027 | 45 | ₹17,50,000 | Scheduled | |
| Bhosale villa — interiors | Mr. & Mrs. Bhosale | WoodCraft Interiors | Nikhil | 7 Feb 2027 | 29 Mar 2027 | 50 | ₹24,00,000 | Scheduled |
Yes. Copy the template, then import a .csv, .tsv or .xlsx file into any of its tables and map the columns. Delete the sample rows first if you do not need them.
Yes. An automation runs when a record is created, updated or matches a filter, when a form is submitted, on a schedule or when a date arrives, and can update or create records, call a webhook or post to a connected Slack channel.
Line up subcontractor bids for each work package side by side — price with tax, duration, warranty and score — and award the best one.
2 tables · 24 fieldsBid Tabulation TemplateA classic bid tab: each BOQ line priced by three bidders against the engineer’s estimate, with extended totals and the lowest bidder per line.
1 table · 15 fieldsBill of Materials TemplateEvery component needed for a build with quantity, unit cost, extended cost and order status, tied to suppliers and their lead times.
2 tables · 23 fieldsClient List TemplateA tidy list of every client for any service business — contact details, visits, spend and how long since you last saw them.
1 table · 16 fieldsConstruction Budget TemplateCost-code budget for a build: original budget plus change orders, committed and actual cost from invoices, and overrun warnings per line.
2 tables · 21 fieldsConstruction ChecklistPhase-by-phase site checklist from pre-construction to handover, with owners, due dates, required inspections and photo proof.
1 table · 10 fields