Spreadsheets are enough for my business – move on

Spreadsheets are enough for my business – move on

Spreadsheets are wonderful. I have a load of them. Everything from personal ones that calculate my kg weight in stones and pounds (apologies to US readers) and my BMI through to things that help me calculate budgets and so on.

I even have transient data in them, when I am doing data imports, etc.

I do not run my business on them.

When I say this to fellow small business owners, I often get the response:

Of course you are against spreadsheets, you use CRMs all day.

I then show them my mastery of spreadsheets. For instance, if you have a first name and last name in one field of a spreadsheet there is a (relatively simple) formula to split them into two cells. I have seen people who live in spreadsheets doing this work manually… for thousands of entries.

I then show them how you can copy this formula to their entire spreadsheet with a few clicks.

To finish, I show them how you can autosize all of the columns in your spreadsheet in one single-click and two double-clicks.

I do not claim this as high-level mastery… but it is often what those same business owners are capable of.

They then show me how they keep all their accounts in a spreadsheet

I know that even in my small business, it causes ‘problems’ if I send out two invoices to different customers with the same number. I often use a laptop on the road and a desktop at home. Sometimes the sync isn’t as fast as I would like, so I would risk the spreadsheet getting out of date or corrupted.

Heaven knows what would happen if I had my accountant accessing it at the same time. (Did you know that AT LEAST as far back as 1995 you can put Excel spreadsheets in ‘multiuser mode’. You lose a few features, but you can safely have multiple people accessing it!)

So, for my accounts I use a simple, online accounting system. It auto-numbers my invoices. It automatically sends out my regular invoices. The data is held securely and, even better, my accountant can access it without bothering me.

People who run their business in spreadsheets are keeping personal data on their PC.

Why would this bother me? Well, I can ethically get into a laptop or PC in a few minutes by bypassing the password. There are legal, ethical tools on the internet to enable this.

I can even do this on enterprise servers. How? Microsoft document this process on their website. It is not illegal (as long as you have permission) and the information is freely available.

I have done this for clients when they were stuck. ‘Breaking into’ a corporate server took me about 15 minutes… and I was being slow and careful.

If I wanted the ‘quick and dirty’ way, I would just take the hard disks out and shove them in my disk reader. A process of a few minutes.

There is a preventative measure you can take and that is to encrypt your hard disks. When I ask small business owners, ‘are your hard disks encrypted’ they tend to look at me blankly. Basically, if they lost their laptop someone could be reading their data in under a minute.

This is the ethical, computer tech way of accessing data.

Cyber-criminals attack your computer while it is switched on. Disk encryption is no protection against this type of attack. For recent attacks most anti-virus/anti-malware software is useless. (With certain caveats.)

That is not to say that disk encryption is useless. It does protect against loss of laptop or theft of desktop in a burglary. I does not protect against many types of malware attack. 

If this is buzzing way above your head already, then you have answered the ‘why’ of why you should not be storing your business data on your local computer. It is a complicated subject and you do not have time in your business to work on this.

I am not here to convince my potential clients away from spreadsheets!

That sounds like a bold claim, but if people are ‘believers’ that a spreadsheet solution is sufficient then I do not have enough breath or, frankly, will to convince them otherwise. Where I have tried that in the past they tend to be suspicious that I am pulling a fast one to get them into a solution that does not involve spreadsheets. Every decision will have to be justified, repeatedly… and their mate down the pub says that I am just scaremongering.

I am fine with that. They are not in the required state of maturity to become clients.

I know that at every stage they will be trying to circumvent the safety measures I put in place. When they go down, they will be trying to bring me down as well. Like a petulant child they will spend their time trying to prove me wrong. Time that I could be using to help them improve their business processes.

Let me be clear:

I am not against people who use spreadsheets. My opinion is that they are not adequate for running a business.

So, I have usability concerns in terms of accounting. I also have security concerns when handling personal data. Frankly, the most compelling argument is that running a business through spreadsheets is so damned difficult. Keeping track of which spreadsheet holds the latest version of what, following arcane copy and paste procedures to create new invoices.

Why do a twenty stage process where any incorrect step can lead to disaster as opposed to a simple, single-click where the computer will hold your hand and guide you?

The point of online accounting and CRM systems is not that they are there to make things difficult. They are there to make things easy. Even for single-person operations this brings benefits that far outweigh their costs. It also means that if/when you sell your business or expand your business you have solid procedures in place that enable collaboration. 

Use spreadsheets to run your business if you want to stay small and vulnerable.

If you have an eye to growth, then you need something better, easier and more robust. You need something that will stand the rigours of due diligence and regulatory compliance. At that stage you need someone to help you take that next step. We are called consultants. When that nagging feeling that using a spreadsheet is not the right tool, come and talk. You will find that we are lovely and helpful. My job is not to convince you that spreadsheets are inadequate. That is your job. 

My job is to help you on your journey into a bigger, brighter world.

Breadwinner delivers Salesforce integration for Netsuite

Breadwinner delivers Salesforce integration for Netsuite

Back in 2015, I wrote a short article about Breadwinner and how this amazing product was integrating all of our Xero accounts into Salesforce. It seems to have made our lives so easy for so long. All our contacts in our accounting software match up EXACTLY with our Salesforce contacts. In that time it has been great to see Breadwinner continue to develop and add new features. At the time I said that Breadwinner was so good that it was a reason to purchase Salesforce.

If you were a Netsuite user, you had no such luck. You were left out in the cold with not proper 2-way integrations between your accounts/ERP and your Salesforce. Similarly, getting information from your Stripe account into Salesforce was ‘difficult’.

TODAY, I have heard that all that has changed.

Breadwinner is also launching integrations to connect Salesforce to Stripe, and another one to integrate Netsuite with Salesforce.

Breadwinner has brought out an integration for Netsuite. That has to be big news – your CRM and your Accounts/ERP package talking to each other. Using all the power of Salesforce reporting to give a real insight into how your business is doing.

Stripe talking with your Salesforce has to be big news, too! (But I am still more excited by the Netsuite news.)

So, what are you waiting for? I have always found Breadwinner to be super helpful, so why not find out more from the links.

 Salesforce to Stripe, and integrate Netsuite with Salesforce.

Lightning Strikes Salesforce! …and Quick Books Salesforce Integration

Salesforce has finally revealed its Lightning interface to the general population.

This is a massive upgrade to its usability. All the items that you need are on screen at the same time. It is a bit like moving from a complicated-looking remote control to a simpler-looking, but far more powerful smart phone.original-iphone-285637

Remote_control_2
The new interface still has a lot of limitations, in that it cannot deal with Custom Objects, but that is very close on the Salesforce road map. The Lightning interface presents a lot of information, very simply so that you can see the details of, for example, an opportunity and have a little road map to the right showing how it has progressed. Well done, Salesforce! (For those who like their change ‘gradual’, you can switch between the old and new interfaces and there are no plans to turn off the old interface.)

Salesforce is well-known for sticking to what it does well. Although it deals with Opportunities and Quotes and Products and Price books, it has not strayed into the accounting sector. It leaves that for experts like Xero and Quicken, so it is often frustrating not to have details to hand within Salesforce… Well, last year we let you know about Breadwinner’s amazing 2-way sync between Xero and Salesforce. Now we can let you know that they have performed the same magic for Salesforce and Quick Books Online. Look out for Quick Books Salesforce integration.

Whereas other products get your information from Salesforce into Xero, this flows against the tide and gets it from Xero to Salesforce. Awesome! And they also integrate QuickBooks Online with Salesforce too.

You heard it here first, or even if you didn’t, it is still worth checking out!

Social Media Auto Publish Powered By : XYZScripts.com