Auto Body Repair Estimate Template

Quote collision and body work per vehicle with parts, labour hours and paint, insurance claim details and an auto-calculated total.

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

36

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

28 fields · 4 sample rows

  • All estimates (Grid)
  • Pipeline (Kanban)
  • Calendar (Calendar)
  • Request an estimate (Form)
  • Dashboard (Dashboard)
EstimateTextClientTextEmailEmailPhonePhoneJob addressAddressVehicleTextModel yearNumberRegistration noTextDamage areasMultiple selectInsurance claimCheckboxInsurer & claim noTextStatusSingle selectEstimate dateDateValid untilFormulaDays to expiryFormulaLine itemsLink to another tableItemsCountSubtotalRollupDiscountCurrencyTax ratePercentTaxFormulaTotalFormulaDeposit %PercentDeposit dueFormulaPrepared byTextPhotosAttachmentNotes & termsLong textClient signatureSignature
EST-2041 · Swift front-endRohit Malhotra[email protected]+91 98111 23456Drop-off at workshop, Gurugram, IndiaMaruti Suzuki Swift ZXi2,021HR26 DK 4412Front bumper, Bonnet, HeadlampsYesICICI Lombard · CLM-88213Sent16 Nov 20261 Dec 202612Front bumper (OEM), Headlamp assembly, LH, Bonnet denting & alignment, Paint – bonnet & bumper4₹21,20018.00%₹3,816₹25,016Imran (service advisor)
EST-2042 · Creta door dentAnanya Krishnan[email protected]+91 99000 11223Drop-off at workshop, Gurugram, IndiaHyundai Creta SX2,023DL8C AF 0921DoorsAccepted11 Nov 202626 Nov 2026Paintless dent removal, RR door, Blend & polish door2₹3,80018.00%₹684₹4,48430%₹1,345Imran (service advisor)
EST-2043 · Civic rear bumperJames Fernandes[email protected]+91 98200 44556Pickup from DLF Phase 3, Gurugram, IndiaHonda Civic2,019HR26 BZ 7710Rear bumperDraft19 Nov 20264 Dec 2026Rear bumper repair & refinish, Parking sensor recalibration2₹5,700₹50018.00%₹936₹6,136Neha (estimator)
EST-2038 · Nexon hail damageSanjay Gupta+91 97170 99887Drop-off at workshop, Gurugram, IndiaTata Nexon EV2,022Roof, BonnetYesDeclined30 Oct 202614 Nov 2026Roof PDR (hail)1₹7,20018.00%₹1,296₹8,496Customer chose insurer's network garage.
Field details
Estimate · Text
Client · Text
Email · Email
Phone · Phone
Job address · Address
Vehicle · Text
Model year · Number
Registration no · Text
Damage areas · Multiple select
Front bumper, Rear bumper, Bonnet, Doors, Fenders, Windshield, Roof, Headlamps
Insurance claim · Checkbox
Insurer & claim no · Text
Status · Single select
Requested, Draft, Sent, Accepted, Declined, Expired
Estimate date · Date
Valid until · Formula
IF({Estimate date}, DATEADD({Estimate date}, 15, '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 “Get a body repair estimate” asks for: Client, Email, Phone, Job address, Vehicle, Model year, Registration no, Damage areas, Insurance claim, Insurer & claim no, Photos, Notes & terms.

Line items

8 fields · 8 sample rows

  • By estimate (Grid)
  • By category (Grid)
ItemTextEstimateLink to another tableCategorySingle selectQuantityNumberUnitSingle selectUnit priceCurrencyLine totalFormulaDetailsText
Front bumper (OEM)EST-2041 · Swift front-endParts1.00each₹6,800₹6,800
Headlamp assembly, LHEST-2041 · Swift front-endParts1.00each₹5,400₹5,400
Bonnet denting & alignmentEST-2041 · Swift front-endLabour4.00hrs₹650₹2,600
Paint – bonnet & bumperEST-2041 · Swift front-endPaint & materials2.00panel₹3,200₹6,400
Paintless dent removal, RR doorEST-2042 · Creta door dentLabour2.50hrs₹800₹2,000
Blend & polish doorEST-2042 · Creta door dentPaint & materials1.00panel₹1,800₹1,800
Rear bumper repair & refinishEST-2043 · Civic rear bumperPaint & materials1.00panel₹4,200₹4,200
Parking sensor recalibrationEST-2043 · Civic rear bumperSublet1.00each₹1,500₹1,500
Field details
Item · Text
Estimate · Link to another table
Links to Estimates
Category · Single select
Parts, Labour, Paint & materials, Sublet
Quantity · Number
Unit · Single select
each, hrs, set, panel
Unit price · Currency
INR
Line total · Formula
ROUND({Quantity} * {Unit price}, 2)
Details · Text

Auto Body Repair 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