error

Still using Excel for your staff rosters?

February, 2016

Still using Excel for your staff rosters?

Spreadsheets are the go-to problem solver for many businesses and can be great for many simple tasks such as cashflow projections, asset lists and purchase orders.

However while it may be an quick and easy fix, in many situations a spreadsheet just doesn’t measure up.  This is especially true when performing business critical tasks such as managing your financial and operational data and when you need multiple users to collaborate on a multi-step process.

This includes your staff rosters!

Many hospitality and retail businesses now realise the important role efficient staff rostering plays in their overall success. Using more effective methods of creating and sharing rosters enables businesses to be more efficient, provide their staff with better information and gain valuable insights into their operating performance.

Here’s a number of reasons why it’s time to move away from Excel.

Spreadsheets don’t support a collaborative workflow

Excel spreadsheets (and even cloud spreadsheet programmes like Google Sheets) can get messy when several contributors are involved and issues can arise such as multiple copies of the same file, security and privacy of information and ensuring a repeated workflow from one user to the next.

Contrast this with the built-in collaborative features of modern cloud based technologies permits interaction from all employees within a defined workflow and streamlines the process from start to finish/

Potential for human error

Here’s a hypothetical situation; Angela from accounts has spent Monday morning setting up a great spreadsheet, formulas and all – only to find the following morning that Jack, the Duty Manager from the previous evening, accidentally deleted one of the her formulas and all the figures for the day are now wrong and staff start turning up for the wrong shifts (or worse, not turning up at all!).

Too much human interaction can lead to increases in potential for error. Spreadsheets place too much dependency on the user’s skill and accuracy.

Record keeping

Whilst Excel does provide a form of record keeping, it isn’t as meticulous or robust as is necessary when attending to important management- or finance-related information.  Modern organisations need to ensure the correctness of all of their information and good change logs /  auditing processes form a part of this.

Visualisation of your data

live-costingWhose eyes don’t glaze over when presented with a multi-page spreadsheet full of tiny rows of numbers? While Excel does support custom charts these require high user skills to master and can be prone to error as well. Better visualisation of your data will lead to being able to make better, more informed decisions.

Tools that are built for a specific purpose will always out-do Excel in presenting relevant information in a useful and meaningful way.  Businesses should always be testing and measuring their key performance indicators and using the best possible tools to visualise that information.

SPECIAL OFFER

goRoster is a simple, easy to use and cost effective online solution which helps you spend less time on paperwork and more time on what’s really important to your business. If you’re ready to get off Excel spreadsheets, we have a special offer: Sign up for a full year’s subscription before March 15th and get two months free. PLUS we have our knowledgeable, friendly team of rostering experts who can help you get up and running quickly! Get started on your free, no obligation trial here.

Quit getting it wrong and eliminate human error

March, 2015

Capture1You would think with the continual developments in technology today that the possibility of human error would have been eliminated. It’s certainly a nice thought to entertain.

But it’s just not the case.

A number of businesses still hold tight to their old fashioned ways and I hate to say it – but Microsoft Excel, is most certainly one of those. Why is it that often we hate to get rid of the things we’ believe’ serve us so well, but we ‘know’ to be outdated.

We develop this close bond with them and they create what we call a safety net for our business.

Let’s be honest. There will come a time in the near future where you’re investment in current software is going to leave you in the dust of your competition. It’s up to you to decide if you’re going to jump ship before it sinks, or whether you’re going down with it.

Here are some quick tips to help you begin your journey towards rightly accounting for those employee costs:

  1. Incorporate ALL the additional costs for your employees each week (superannuation, annual leave, insurance). Doing this weekly ensures you don’t get any surprises come end of the financial year
  2. Communicate these figures with your head office and always work to a weekly budget
  3. Highlight your most important metrics (e.g. wage cost)
  4. Use indicators and warnings to identify when you’re getting close to your budget.

goRoster helps to gain much more clarity with respect to where you’re sitting financially and can aid you in trimming back the excess from those employee costs. Click here to give our free trial a go, and lets see how we can help you gain back control over your costs again.

Mobile Analytics goRoster is proudly built by Global Office
Back To Top