Blue Dot Blog

Where do the jobs go in the digital economy?

Digital economyDigital disruption : Digital opportunity

We have a report we produce every quarter that tells us useful information about the previous twelve months. We’ve been producing the report each quarter for the last five or six years and every time we run it we learn important lessons about our business and we make changes for the better.

Here’s the story of the report.

Let’s start at the very beginning

The source data we need is very easy to obtain, there are two downloads into Excel we run from our bookkeeping program. Once we have the data, we paste it into an Excel workbook and then have to perform hundreds of “copy and paste” repetitions to get the data in to a format that produces the information we need.

Over the years the source data hasn’t changed but the process has.

To begin with we had to write the spreadsheet so it would crunch the copied & pasted data correctly and give us the information we wanted and then we added one page that summarised this information for easy use. We review the summary page and drill down to the detail when we want to know more about an area of interest.

Having figured out how the spreadsheet should work it then took someone almost a week to crunch the numbers and give us the information we were after.

It was worth it – the report is brilliant!

Since then we’ve got more efficient at producing the report and quickly got the time down to around four hours.

A brilliant report now produced more efficiently and cheaply.


But why is there any human data processing, you may ask?

This year we set about changing how the report is produced. We learnt some new Excel formulae, got our heads around pivot tables and the report now takes an hour to produce.

Half of that hour is spent downloading and formatting the same two reports from our bookkeeping system and the other half is spent updating some of the formulae and re-working the pivot table. Hey-Presto we have the report ready to use only one hour later (and it’s a bit better too).


Which is great for us. We have a better report, produced more quickly and cheaply. In theory we could run it more often but part of the benefit is to look at it quarterly and see a broader picture emerge.

But where did the job go?

My colleague who did the data processing doesn’t miss it in any way, so in this case it’s a win:win.

I’m all for businesses using technology and I’m definitely in favour of making the right Management information available to improve every business.

But should we not pause for thought and ask wider questions about the march of technology?

Who are the winners and losers and what might be the impact on both?








Bookkeeping is the bedrock of your business – EBook

Bookkeeping EBook

Good bookkeeping is the bedrock of every successful business.

As you can see from our illustration, bookkeeping is at the centre of every aspect of your financial management and you let it lapse at your peril.

However, we see too many businesses where the bookkeeping is not done well enough and in a lot of them the business owners don’t realise the problem – they don’t realise they are making decisions based on incorrect financial information.

We have produced a simple Bookkeeping EBook which shows you:

  • how important good bookkeeping is for profit and cashflow improvement
  • how your bookkeeping supports other financial functions
  • how to organise your business to get your bookkeeping right

It’s free to download, just click on any of the Bookkeeping EBook links on this page and off you go.

You can see how central good bookkeeping is to the entire financial management ecosystem of your business and we have blog articles on the other financial aspects which you might also find helpful.

Topics include:

Some business owners warm to numbers – others find numbers a complete anathema. Wherever you are on that spectrum it might be useful to get a bit of expert help where you need it.

Money – well spent.

Don’t forget to download the Bookkeeping EBook !



Need a little help with your bookkeeping and financial management? – let us know how we can help you:

Accountants aren’t always checking your accounts

checking accountsToo often we see examples of companies where the published accounts at Companies House bear little resemblance to the numbers in the client’s accounting software.

They should be the same.

How could they be different?

And what is the impact?

Continue Reading

Cloud accounting v Accounting in the cloud – travel from the right platform

Cloud accountingYou can’t move for cloud accounting marketing on social media – the providers of cloud accounting software and advocates for it are all over the place and you might think it’s the only game in town.

But think again – think about doing your accounting in the cloud. Then think more widely.

Think about running your entire business in the cloud, without being limited by cloud accounting software.

Continue Reading

Cloud accounting – We can work anywhere in #thecloudthatcounts

Growing in #thecloudthatcountsIt’s a strange feeling when you shrink with one hand and at the same time grow with the other. Courtesy of cloud accounting.

Shrink is not really the right word. We are simply took advantage of moving into the cloud to reduce our property costs in one location and at the same time open another office in Richmond.

Accountants in Fulham, accountants in Richmond. Accountants everywhere and anywhere, in fact.

It’s a period of change and opportunity for us, and a chance to stand back and remind people of what we do and why it works.

Continue Reading

Cloud accounting – using the software you like

Cloud pictureCloud accounting is becoming more entrenched as a business solution and although we still don’t think cloud accounting software is as good as some of the best desktop packages, it’s getting better all the time.

But what if you are very happy with the accounting software you use and have several years of data stored in it but you want to work in the cloud and gain the benefits of access from anywhere at any time?

Here are a couple of solutions.

Continue Reading

Management accounts makeover – clarity is everything

Management accounts - hit the profit buttonManagement accounts are vitally important for every business.

Not having management accounts is simply not an option and yet we continue to see companies, some with multi-million turnovers, that have nothing like the management information they need to run their businesses.

Sounds familiar?

Organise a management accounts makeover.

Continue Reading