Contractor Time Tracker

Log contractor hours against projects, approve timesheets and see billable totals per contractor at their own hourly rate.

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

Trackers

Tables

Contractors, Time Entries

Fields

20

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.

Contractors

9 fields · 4 sample rows

  • Contractors (Grid)
ContractorTextCompanyTextEmailEmailPhonePhoneTradeSingle selectHourly rateCurrencyTime entriesLink to another tableHours loggedRollupAmount dueRollup
Suresh YadavYadav Electricals[email protected]+91 98110 44556Electrician₹600Rewired conference room, Installed pantry lighting11.5₹6,900
Maria LopezFreelance[email protected]+34 612 555 019Developer₹3,500Checkout API integration, Bug triage call7.0₹21,000
Imran ShaikhShaikh Woodworks[email protected]+91 99200 77889Carpenter₹500Built reception desk, Extra shelving (not in scope)12.0₹6,000
Nandini RaoStudio Nandini[email protected]Designer₹2,500Window display concepts5.0₹12,500
Field details
Contractor · Text
Company · Text
Email · Email
Phone · Phone
Trade · Single select
Electrician, Plumber, Carpenter, Developer, Designer
Hourly rate · Currency
INR
Time entries · Link to another table
Links to Time Entries
Hours logged · Rollup
sum of Hours via Time entries
Amount due · Rollup
sum of Amount via Time entries

Time Entries

11 fields · 7 sample rows

  • Timesheet (Grid)
  • Approvals (Kanban)
  • Calendar (Calendar)
  • Log hours (Form)
  • Billing (Dashboard)
Work performedTextContractorLink to another tableProjectSingle selectDateDateHoursNumberBillableCheckboxRateLookupAmountFormulaApprovalSingle selectInvoicedCheckboxNotesLong text
Rewired conference roomSuresh YadavOffice fit-out13 Nov 20267.5Yes₹600₹4,500ApprovedYes
Installed pantry lightingSuresh YadavOffice fit-out17 Nov 20264.0Yes₹600₹2,400Submitted
Checkout API integrationMaria LopezWebsite rebuild16 Nov 20266.0Yes₹3,500₹21,000Approved
Bug triage callMaria LopezWebsite rebuild18 Nov 20261.0₹3,500₹0ApprovedGoodwill — not billed.
Built reception deskImran ShaikhOffice fit-out15 Nov 20269.0Yes₹500₹4,500Approved
Window display conceptsNandini RaoShowroom refresh18 Nov 20265.0Yes₹2,500₹12,500Submitted
Extra shelving (not in scope)Imran ShaikhShowroom refresh19 Nov 20263.0Yes₹500₹1,500RejectedNeeds a change order first.
Field details
Work performed · Text
Contractor · Link to another table
Links to Contractors
Project · Single select
Office fit-out, Website rebuild, Showroom refresh
Date · Date
Hours · Number
Billable · Checkbox
Rate · Lookup
Hourly rate via Contractor
Amount · Formula
IF({Billable}, {Hours} * SUM({Rate}), 0)
Approval · Single select
Submitted, Approved, Rejected
Invoiced · Checkbox
Notes · Long text

Form view “Log your hours” asks for: Work performed, Contractor, Project, Date, Hours, Billable, Notes.

Contractor Time Tracker: 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