Payroll Tracking
Small Business
Client: Truck Driver
Timeline: Two weeks
Tools: Airtable
The Problem
This client needed to hire an additional driver as a contractor for their trucking business, but was having trouble tracking hours and calculating payroll. As a person who was not comfortable with complex technology, they needed a very simple system that they could access and update from their phone.
The Solution
A simple Airtable base that allowed their contractor to submit their hours via a three question form. The back end included weekly tracking for hours worked, hourly wage, and weekly pay calculations. It also rolled up this pay into quarterly statements and annual statements, and emailed them to the business owner so they could be used for reporting and tax purposes.
The Process
-
I met with the business owner to talk about what system they were currently using (paper) and the problems they were facing. They wanted a place the employee could submit hours directly so they were accurate, and one that would do payment math for them to avoid mistakes.
-
I reviewed Airtable with them to see if it was something they’d be comfortable with using. If not, we would use a Google Sheet instead. They preferred Airtable due to the clear column colors and automated email options, which meant they didn’t need to go into the data backend as often.
-
I built the base for them the same day, as it was an urgent need. It included tabs for Quarter and Year for reporting purposes.
-
We took time with training, as this business owner needed extra support navigating online tools. I checked in with them every week for the first month as they checked the payroll to make sure it was working correctly.
-
I sent them a text message with the basic instructions of how to use the base, so they’d be able to easily find it and navigate any issues.
Are you interested in a payroll tracker for your business’s contractors?