Job Estimate Template

A general-purpose quote for any service business: itemise labour, materials, equipment and travel, then track each estimate to a yes.

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

Estimates

Tables

Estimates, Line items

Fields

34

Views

grid, kanban, calendar, form, dashboard

Tables, columns and sample rows

The 2 linked tables in this template, with their real columns, field types and sample rows. Copy the template to edit them in Edesy Tables.

Estimates

26 fields · 4 sample rows

  • All estimates (Grid)
  • Pipeline (Kanban)
  • Calendar (Calendar)
  • Request an estimate (Form)
  • Dashboard (Dashboard)
EstimateTextClientTextEmailEmailPhonePhoneJob addressAddressJob typeSingle selectStart dateDateEst. hoursNumberAssigned toTextStatusSingle selectEstimate dateDateValid untilFormulaDays to expiryFormulaLine itemsLink to another tableItemsCountSubtotalRollupDiscountCurrencyTax ratePercentTaxFormulaTotalFormulaDeposit %PercentDeposit dueFormulaPrepared byTextPhotosAttachmentNotes & termsLong textClient signatureSignature
Q-1101 · Solar inverter serviceGreen Leaf Farms[email protected]+91 94220 11223Survey 88, Nashik Road, Nashik, IndiaMaintenance22 Nov 20266.0KiranSent18 Nov 202618 Dec 202629Inverter diagnostics & cleaning, Travel (round trip)2₹8,04018.00%₹1,447₹9,487Meera
Q-1102 · CCTV install, 8 camerasHotel Blue Lagoon[email protected]+91 832 245 6677Calangute Beach Road, Goa, IndiaInstallation26 Nov 202616.0ArjunAccepted13 Nov 202613 Dec 20264 MP dome cameras, 16-channel NVR with 4 TB, Cabling & installation3₹55,30018.00%₹9,954₹65,25450%₹32,627Meera
Q-1103 · Network auditLumen Design Studio[email protected]+91 20 6712 3344Baner IT Park, Pune, IndiaConsulting12.0Draft19 Nov 202619 Dec 2026Network assessment & report1₹24,00018.00%₹4,320₹28,320
Q-1095 · AC servicing, 12 unitsSunrise Clinic+91 22 2876 5432Andheri East, Mumbai, IndiaService10.0Declined29 Oct 202628 Nov 2026Split AC wet service1₹7,80018.00%₹1,404₹9,204
Field details
Estimate · Text
Client · Text
Email · Email
Phone · Phone
Job address · Address
Job type · Single select
Service, Installation, Maintenance, Repair, Consulting
Start date · Date
Est. hours · Number
Assigned to · Text
Status · Single select
Requested, Draft, Sent, Accepted, Declined, Expired
Estimate date · Date
Valid until · Formula
IF({Estimate date}, DATEADD({Estimate date}, 30, 'days'), BLANK())
Days to expiry · Formula
IF(AND({Estimate date}, {Status} = 'Sent'), DATETIME_DIFF({Valid until}, TODAY(), 'days'), BLANK())
Line items · Link to another table
Links to Line items
Items · Count
Subtotal · Rollup
sum of Line total via Line items
Discount · Currency
INR
Tax rate · Percent
Tax · Formula
ROUND(({Subtotal} - {Discount}) * {Tax rate}, 2)
Total · Formula
{Subtotal} - {Discount} + {Tax}
Deposit % · Percent
Deposit due · Formula
IF({Deposit %}, ROUND({Total} * {Deposit %}, 2), BLANK())
Prepared by · Text
Photos · Attachment
Notes & terms · Long text
Client signature · Signature

Form view “Request a quote” asks for: Client, Email, Phone, Job address, Job type, Start date, Photos, Notes & terms.

Line items

8 fields · 7 sample rows

  • By estimate (Grid)
  • By category (Grid)
ItemTextEstimateLink to another tableCategorySingle selectQuantityNumberUnitSingle selectUnit priceCurrencyLine totalFormulaDetailsText
Inverter diagnostics & cleaningQ-1101 · Solar inverter serviceLabour6.00hrs₹1,200₹7,200
Travel (round trip)Q-1101 · Solar inverter serviceTravel60.00km₹14₹840
4 MP dome camerasQ-1102 · CCTV install, 8 camerasMaterials8.00each₹3,200₹25,600
16-channel NVR with 4 TBQ-1102 · CCTV install, 8 camerasEquipment1.00each₹18,500₹18,500
Cabling & installationQ-1102 · CCTV install, 8 camerasLabour16.00hrs₹700₹11,200
Network assessment & reportQ-1103 · Network auditLabour12.00hrs₹2,000₹24,000
Split AC wet serviceQ-1095 · AC servicing, 12 unitsLabour12.00each₹650₹7,800
Field details
Item · Text
Estimate · Link to another table
Links to Estimates
Category · Single select
Labour, Materials, Equipment, Travel, Other
Quantity · Number
Unit · Single select
hrs, each, day, km, lump sum
Unit price · Currency
INR
Line total · Formula
ROUND({Quantity} * {Unit price}, 2)
Details · Text

Job Estimate Template: questions

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.

Related templates