If you’re considering whether accounting software would be right for you and your clients – especially if you think spreadsheets have been working just fine – here’s some accounting spreadsheet myth busting to help with your decision making.
The 5 big spreadsheet myths
Myth 2: Spreadsheets are more secure and more flexible than the cloud
Busted: Spreadsheets are less secure for you and your clients.
When you keep files on your own server or computer, behind a personal login name and password, it’s easy to feel secure. Unfortunately, that’s probably not the case.
In addition to the question of computer and server security, one of the main issues with accounting spreadsheets is that the information needs to be shared. And that’s usually by email. This is where things get vulnerable. Sure, your data may be secure, but how secure is the person you’ve just emailed? And how do you know the data will retain its integrity when passed to someone else?
Not only is this data transferring a security risk, but it’s how mistakes creep in. It’s also how you end up with productivity-destroying back-and-forth. Do filenames like “client_information_final-v2-08_FINAL.xlsx” seem familiar?
Using the cloud can make these concerns a thing of the past. Once data’s entered, there’s a single source of truth for all accounting. Clients can keep their finances up to date without nearly as many emails, and every employee in the practice can see the same information – and be granted permissions as appropriate.
This security also makes it easy to access your files from anywhere. Because it’s kept in the cloud, you can work wherever, and whenever, you want.
Myth 4: Spreadsheets work well for accounting
Busted: Spreadsheets aren’t designed for accounting – but they are useful, in other ways.
There are a host of problems with spreadsheets when they’re used to run an accounting practice. Setting them up takes time – or money, if you need to go to an outside agency to do the heavy lifting. There’s no audit trail, and it’s easy to introduce human error or even fraud. Performing simple functions of accounting software with a spreadsheet requires an in-depth knowledge of macros and scripts, which usually aren’t accessible or understood by anyone except expert users.
But no-one expects accountants to stop using spreadsheets altogether. Rather than taking the full weight of a practice, you can use spreadsheets as a bridge, or as a stopgap solution, when warranted. They’re still useful for all sorts of tasks, but even those tasks can be coupled with the power of the cloud.
Easy ways to step away from spreadsheets
If you're running or working in a spreadsheet-heavy practice, there are a few simple actions you can take to help reduce that reliance.
Watch and share videos of accounting software in action. Choose a couple of software products and have a look at how they work. You and your colleagues will quickly see how quick tasks become when everything’s online.
Start to reduce the use of spreadsheets for non-accounting work. For example, if you use a spreadsheet to monitor visitors in and out of the office, consider using a dedicated app for the task. This will help set a precedent for moving away from spreadsheets.
If you struggle to get people into the mindset of moving on from spreadsheets, ask them to jot down memorable cases of when a spreadsheet has caused a problem – i.e. data corruption, version control, lost files, etc. Chances are that each of these challenges could have been overcome with cloud software.
Make sure your practice is set up with the right technology for employees to use. Consider investing in second monitors for each team member so they have more screen real estate for comparing different digital documents without having to move or minimise windows.