Video tutorial · 4K

Plan jobs and tasks with a free template

Plan service jobs and tasks with a free CSV template for Excel or Google Sheets. Link the job to its source, assign tasks and a visit time, and record completion with one row per task.

Chapters

  1. Prepare the visit
  2. Open your working copy
  3. One job, three tasks
  4. Customer and references
  5. Who, when and where
  6. Prepare the visit
  7. Do the work and check
  8. The case in Cuotaro
  9. Your next job

Transcript

00:00 Let's organise a job with Cuotaro's free template. At Panadería Norte, we need to replace a tap and check that it doesn't leak. We'll prepare Alex's visit, the tasks and a short note about the result. That gives us a clear record to return to as the work progresses.

00:20 On the Resources page of the Cuotaro website, download the job and task planning template. Open it in your spreadsheet application and save a working copy. You can replace the fictional examples with your own. If everything appears in one column, choose a comma as the separator and U T F eight encoding when importing.

00:43 Use one row for each task. Our example has three: prepare the replacement tap and tools, replace the tap, and check for leaks. All three rows share the same job reference, T R zero zero one. Each task also has its own reference, so we can find it again and update it as the work progresses.

01:07 Enter Panadería Norte as the customer and add the job description. Keep the references for the request and quote we've prepared. When we return to the sheet, we can connect the visit with what was agreed. If your service doesn't need a quote, you can leave that reference blank and continue with the other details.

01:28 Alex will handle the visit on the fourteenth of October, from nine to ten. Enter the owner, date and time window in all three rows for this job. Set the job status to Scheduled and the tasks to Pending. We can now review what needs to be ready before setting off for the customer's premises.

01:50 On the thirteenth, Alex prepares the replacement tap and tools. In that row, change the task status to Completed and record the completion date. Replacing the tap and checking it are still planned for the fourteenth. Leave those actions and their follow-up date in the corresponding rows, ready for the visit.

02:12 During the visit, set the job to In progress. After replacing the tap, carry out the final check. Mark those two tasks Completed with the fourteenth as their completion date, and update the job to Completed in all three rows. Add a short note: tap replaced and no leaks found. The preparation keeps its date of the thirteenth.

02:37 We've prepared the same case separately in Cuotaro. The job record brings together the customer, request, quote and assigned person. It also shows the date, time window and task list. Here, we record the result in Completion notes and leave the status as Completed. The template and the app are used independently.

03:02 The visit is organised, the tasks are checked and the result is recorded. Start with one job from your business and complete the sheet at your own pace. You'll find the template and the user manual on the Cuotaro website. Thanks for joining us; the chapters are there if you'd like to revisit a step.