Pages Navigation Menu

How To Use Spreadsheets And Cell Phone Apps To Streamline Your Courier Business

As a courier business owner, you rely on quick and accurate delivery to satisfy your customers. However, if you’ve been using a hand-written delivery tracking system, you may be making mistakes that decrease your efficiency. Spreadsheets and cell phone apps can streamline your business and bring you into the 21st century.

Add Relevant Fields

When you’re setting up your spreadsheet, you need to create relevant fields that track your important delivery information. Just a few examples include:

  • Type of delivery
  • Payment for that delivery type
  • Item delivered
  • Who sent it and who is receiving it
  • How long it took to deliver
  • Who delivered it
  • Customer satisfaction

Adding these fields is as simple as clicking on “Add” on your spreadsheet software and clicking “New Field.” Click on the field, input the name, and you’re ready to go. The field will run vertically on your spreadsheet.

“Rows” will run horizontally, and here you can input your individual drivers. Add these by clicking “New Row” instead of “New Field” in the “Add” menu. In this way, you can create as many rows and fields as you need.

Creating Simple Calculations

Most spreadsheet programs use simple calculations to automatically gauge important information. To add calculations to a specific cell, do the following:

  1. Type “=” to indicate you are starting a formula
  2. Select the cell that contains the value you want calculated
  3. Input the proper mathematical symbol (+, -, * and /) to indicate the operation
  4. Add the next the cell you wanted included in the calculation
  5. Press the “Enter” key to input your formula
  6. Copy and paste this formula to all other relevant cells

For example, if you wanted to calculate how much time a specific driver has taken on their deliveries in a month, you could input the value of all of his time cells (such as A1, A2, etc.) with “+” signs in between each value. This formula could be placed in a cell entitled “Total Time.” Once you’re finished adding all of your value, press “Enter” and their time will be calculated.

Using This Spreadsheet With Reporting Apps

There are a variety of courier apps that your delivery drivers can use in order to track their deliveries and report them back to you. They will automatically track much of the information you need for your spreadsheet and present it to you in an easy-to-understand format.

However, if you don’t want to spend extra money investing in courier phone apps, you can also have your drivers text you the relevant information to your cell phone. Have them practice texting to you using simple short-hand phrases (such as “succ deliv” for “successful delivery”) and use programs like auto-correct, word prediction, and voice-to-text to streamline texting.

With this simple process, you can increase the efficiency of your courier business and make your deliveries quicker. Speed is crucial for a successful courier business, but accuracy is just as important, and using this method can increase both for your business.