Skip to main content

‘Spreadsheet,’ the word alone can strike fear into the strongest among us. Starting out in business or planning to get an idea off the ground there is an automatic assumption that you know, understand and can manipulate spreadsheets. Those of you that have been in this situation understand only too well how disadvantageous this false assumption is to running a successful business.

Why? Well, straight out of the blocks is the key advice that your business should generate cash as quickly as possible. In other words, get money in the door ASAP. The expression cash is king holds true here. There is no Excel spreadsheet that can raise and email an invoice for you.

True, the spreadsheets (if only the data was in one spreadsheet) contain the data but getting the data into the invoice template, making sure that you are invoicing for the correct amount and then printing /emailing the invoice is a time consuming and error prone task.

Also, all too often the copying and pasting from Excel into a word template looks awful and is a poor reflection on your company brand.

Why bother with this antiquated way of carrying out such a critical business function when online accounting software makes invoicing easy, error free and efficient.

I referenced error prone above. Spreadsheets were never intended to be an accounts production package but over time they have morphed into one and you should avoid this trap at all costs. Online accounting packages will provides checks and balances that help you spot errors which you can amend there and then.

Spreadsheets on the other hand don’t and you can make business decisions based on inaccurate information and any financial advisor, your accountant included, will tell you that this is not advisable.

It’s easily avoided. Your online accounting solution will facilitate the export of your up-to-date and most accurate accounting data. Now you can use spreadsheets for the one thing they are great at – analysis of the accounting data produced by your accounts package.

There was a time when it was perfectly ok to be chained to your PC. Prior to the Internet you had no capability to share data other than by downloading onto a floppy disk and mailing or delivering in person to your accountant.

In 2015 the chains have long disappeared and cloud based accounting systems mean that you can access your accounts and update them from anywhere. At home, on the road, in your office or sitting in your car waiting to meet a customer.

Yes, you can also access your spreadsheets in the cloud but all you’ve really done is bring those Excel headaches into the cloud with you.

One of the biggest issues facing small businesses is that the critical spreadsheets are normally held on the owner’s laptop and this is for the obvious reason of security. Taking annual leave is a nightmare.

How do you ensure that the spreadsheets are updated and that only specific data is exposed to your staff?

Any competent accounts solution for small businesses will allow you to restrict access to the data that is for your eyes only. Your staff can input the necessary data and operate the business as per normal.

Running your own business is tough enough. Being able to down tools and take a well-earned vacation safe in the knowledge that your accounts are in order is a big plus.

Marc O'Dwyer

After completing a Graduate program in Marketing, Marc’s impressive sales career began at Allied Irish Banks, Pitney Bowes and Panasonic where he received numerous Irish and European sales performance awards and consistently exceeded targets and expectations. In 1992, Marc’s entrepreneurial spirit led him to set up his own business, Irish International Sales (IIS). Initially, this company was a reseller for Take 5 Accounts and Payroll software. Within four years, IIS became the largest reseller of Take 5 in Ireland, acquiring four other Take 5 resellers. He also found time to set up two mobile phone shops under the Cellular World brand and a web design company offering website design services for small businesses. In 2001, he bought the majority share in a small Irish software business, Big Red Book. At that time, the company was losing money. The company became profitable within two months, and Marc then acquired a payroll company to compliment Big Red Books Accounting products. In 2003, IIS were appointed as Channel Partners with SAP for their new SME product, SAP Business One. Marc sold his Take 5 business and concentrated on developing this new market for SAP As a result, by 2007, IIS was recognised as the largest Channel Partner for SAP in EMEA (Europe Middle East and Africa). In 2008, the IIS Sales Manager bought the Company from Marc in an MBO. He launched Big red cloud in June 2012, the online version of big red book, to date the company successfully converts 59% of trials into sales and the number of customers is growing rapidly. Marc continues to run both Big Red Book and Big Red Cloud which now support 75,000 businesses. He is a very keen sportsman, having played rugby for 20 years, represented Leinster at under 16 and under 20 levels, and league squash with Fitzwilliam Lawn Tennis Club for 10 years. Marc has competed in 11 Marathons, including the London and Boston Marathons, and has completed several Triathlons and Half Ironman races. He has also completed six Ironman Races in Austria(x2), Frankfurt (Germany), Nice (France) , Mallorca (Spain) and Copenhagen (Denmark)

This site is registered on as a development site. Switch to a production site key to remove this banner.