Spreadsheets like Google Sheets and Microsoft Excel Logos are Strong together

Every good business starts with spreadsheets

Your plant and equipment hire company is no different

Portrait avatar photo of Dylan Hrurukvit
Dylan Hrurukvit
Sep 6, 2022
6 min read (totally worth it)

Disclaimer: I'm a big fan of both Microsoft Excel and Google Sheets for their differing strengths, so beyond a few well earned jokes, consider this post equal parts 'helping you get organised' and 'constructive procrastination'.

As a startup founder with roots in the construction industry, my focus is hard and fast that the best solution always prevailing and often this involves a spreadsheet.

Not a day goes by that I don't learn of another hire company using a spreadsheet macro function or equation that I've never heard of.

Time is money and things need to just work.  

Excel holding up the entire global financial system meme
Source: "Richard in accounting approves of this meme" Reddit

To spreadsheet ..or not to spreadsheet? 🤔

If you're just starting out, the short answer is, yes. The long answer, do what works for you, and then learn how to use spreadsheets.

Chances are that if you're in the early stages of business you probably won't have dedicated software for managing your fleet yet.

Tracking orders, clients, jobs, billing and usage information throughout your rental fleet is critical, as staying organised is the backbone of any well run hire business.

When that phone rings at any given moment, your team needs to know your fleet's:

  • Availability 📅

  • Location 📍

  • Specifications 📏

  • Pricing ↕️ ; and

  • Delivery options 🚚

Not only that, but you as the Director / Fleet Manager / Admin need to understand your fleet's:

  • Billing 🧾

  • Performance 🏎️

  • Return on investment 💰

  • Maintenance requirements 🔧

  • Service condition ⚙️ ; and

  • Financial forecasting 📊

This is by no means an exhaustive list and although your plans may own nice plot of real-estate in the back of your mind 🧠, this information will never scale to new employees in future unless you've learnt how to communicate telepathically of course 🔮💆.

House on fire meme
Source: KC Green

When you think about it, every hire, from heavy plant and equipment to light vehicles and attachments is the 'same-same' but different.

You need to be able to apply processes and structure that can be repeated reliably, while handling all those moving parts and subtle differences.

This is where mere mortals like us can turn to spreadsheets.‍

🔄 = 💰

1. Excel vs Sheets 🥊

With thousands ↗️ of great resources online comparing the two products, I'd like you to take 10 seconds spot the difference below for a summary:

Screenshot of Google sheets
Google Sheets ↗️  using the Chrome Browser ↗️
Screenshot of Excel
Microsoft Excel

That right, they're practically the same (controversial opinion I know). Feel free to tell me otherwise. 💁

Yes, one is in your internet browser and one is dedicated software installed on your device; and yes one provides collaboration via said internet browser and the other through a cloud synchronisation -and yes, there are many more nuanced differences (🐝's ♠️).

Like the 'Windows vs Apple' or 'iOS vs Android' fight that will rage on for millennia to come, ultimately, they achieve the same outcome. 🍅 🥔

With large and growing communities that support both, you'll be sure to find solutions highly specific to your individual needs. Pick one and move on, we've got bigger fish to fry. 🐟

2. Alternatives 🚀

The last consideration needs to be:

How is your team going to use this system?

For fast-growing teams, structure and processes are key to keeping everybody on the same page and if a picture is worth thousand words, maybe these next images show you what software can do that spreadsheets can't:

StayOnHire tracking projects
Tracking assets and labour on a project/hire in StayOnHire 🔗

Once tracking your first few hundred hires, 10-50 plant and operators in spreadsheets, you'll know what these images are telling you 😛.

Mockup of StayOnHire product
Software can support provide structure to your operations both in the office and field

Book a free demo of StayOnHire here:

Book a demo

Choosing the software can be perfect but does require taking your administrative, business and financial processes seriously.

The heart of every good business is more money in than money out 😂. Obvious I know, but that's where you need to prioritise.

The faster you can get between providing a quality service and getting an invoice paid, the easier your life becomes. Time is money.

StayOnHire tracking invoices
Converting a project/hire into billable invoices in StayOnHire 🔗

Software that keeps all of your planners, admin, billing, site supervision and clients on the same page is a game changer for those that are ready to give it a shot.

3. Download templates 📎

Once you've picked a team (or decided to sit on the fence and get both), download a rental template below:

  1. Microsoft Excel ⬇️

  2. Google Sheets ⬇️

Once you've nabbed that bargain, sit back and relax, your business is saved. Like open-source software, the internet has provided another simple solution at the click of a 'free download' link.

Open source developers meme
Source: "What my friends think I do" Pinterest

4. Customising your spreadsheets 💪

Once you jump into the template, you'll notice that it's actually quite simple. A few columns and tabs that hold information and viola, you've now got foundations.

Like most things in life, simplicity is key for creating an effective tool. With every layer of complexity come the obligation to explain and fix moving parts.

Seal meme spreadsheets
Source: "It takes that cell and magic happens" Imgur #forumlas

I've seen my share of complex spreadsheet macros and far too many ERPs ↗️, but at the end of the day, all that matters is that your team know how to use it.

It's not hard to see why so many small businesses choose to ride it out on spreadsheets to manage their fleet.

5. Trouble in paradise 🏝️

For those of you who've been on the spreadsheet grind, this section is for you.

With as much praise as we sing for spreadsheets, the unfortunate reality is that while they will be your saviour early on, the more successful your business becomes, the more you'll discover that spreadsheets are equally BAD for growing hire and rental companies.

Here are a few key reasons why they aren't great when you get bigger:

  • Data Integrity
    The power of endless customisation comes at the cost of structure and rules. Unfortunately, spreadsheets are only as good as their editors -and last I checked, most of us are imperfect humans.

    Inefficient layouts, tabs, grids, formulas and duplicate data are a few just ways off the top of my head that can suck the hours right out of your day.

    Like your favourite employee, your newfound spreadsheet won't complain if you tell it to do a pointless exercise -and in this case, it's not good.

  • Human Error
    On the topic data integrity we touched on being imperfect humans and we're going to again.

    We can do all sorts of fancy things with these squishy brains of ours, but doing them over-and-over again robotically, doesn't always go so well.

    Formatted cells, data and formulas are no match for a human ready to break the mathematics, make a spelling mistake, select the wrong tick box or forget a step in your fancy new process.

  • Functionality
    Once we've trained our staff methodically, drilled the process into them and are continually completing hire with all of our moving parts in one perfectly organised spreadsheet.. then what?

    Now you need to hird party integrations that synchronise into a spreadsheet aren't exactly the easiest thing in world to build and maintain.


Standard conditions apply, including but not limited to:

1 Offer valid with a current invoice from any competitor.
1 Offer valid for StayOnHire annual plans.
1 Credit will be applied to a StayOnHire plan in an amount equal to the amount that is payable to the competitor as of the date of switching to StayOnHire, for the same number of users, for a maximum credit of two years of the selected StayOnHire service.


Standard conditions apply, including but not limited to:

2 Offer valid for new customer referrals with an annual subscription.
2 Credit will be issued in Australian Dollars ($AUD).
2 Credits can not be redeemed for cash or vouchers of any type.
2 Credits are not transferrable outside of your organisation.
2 Credit will be applied once the referral has completed their onboarding.