2012 was a tough year for spreadsheets.<\/p>\n\n\n\n
First, the London Olympics accidentally sold 20,000 tickets to a swimming event that could only accommodate 10,000. According to The Telegraph<\/a>, \u201ca member of staff made a single keystroke mistake and entered \u201820,000\u2019 into a spreadsheet rather than the correct figure of 10,000 remaining tickets.\u201d<\/p>\n\n\n\n That same year, J.P. Morgan Chase lost over $2 billion due to a spreadsheet error, which was compounded because a single miscalculation was fed into other calculations.<\/p>\n\n\n\n For many small businesses, Excel is the default choice for bookkeeping. It\u2019s been around for ages, there are plenty of online tutorials and it\u2019s easy to find sample accounting formulas. Best of all, you probably already have it.<\/p>\n\n\n\n And while Excel is a great place to start, the risk of broken formulas, misplaced data and lost files increases as your business grows. The more time you have to spend in a spreadsheet, the less time you have to focus on your business and the harder it will be to keep your books in order.<\/p>\n\n\n\n There\u2019s a time and place for using spreadsheets, but if you\u2019re still using Excel for your accounting, it\u2019s time consider de-risking your bookkeeping.<\/p>\n\n\n\n The cost of a tool like Excel has nothing to do with the sticker price. It\u2019s all about how much time it requires to manage.<\/strong> Those hours are hard to quantify, but crucial to your sanity.<\/p>\n\n\n\n A lot of labor goes into small business accounting. A 2014 survey of small businesses found that while some companies are able to keep the amount of time spent on accounting down to a minimum, it\u2019s simply not the case for most companies. In fact, 40% of small businesses spend over 80 hours per year dealing with just<\/em> their federal taxes.<\/p>\n\n\n\n Let\u2019s say the person spending 10 days per year doing accounting makes an annual salary of $59,124 (approximately the 2018 average salary for employees with a bachelors degree in the US).<\/p>\n\n\n\n If they spend 10 days every month out of their year working on the books, then $27,288 of their salary goes towards accounting. And that doesn\u2019t even account for the missed opportunity costs of not being able to spend that time on sales, marketing and hiring.<\/p>\n\n\n\n In finance, time value of money is a concept that recognizes the relevant worth of future cash flows arising as a result of financial decisions by considering the opportunity cost of funds. <\/p>\n\n\n\n With better tools and\/or accounting professional assistance, the amount of hours spent on accounting goes down and the time-value cost decreases accordingly.<\/p>\n\n\n\n More than 80% of businesses that don\u2019t survive cite poor cash-flow management as a primary reason. It\u2019s not that these businesses aren\u2019t making money, it\u2019s that it gets increasingly harder to forecast and budget as the company grows. <\/p>\n\n\n\n When Michael Leung started SleepyPod, a company that manufactures pet carriers, it was easy to forecast how much money the company would have a few months down the line.<\/p>\n\n\n\n But as SleepyPod grew, Michael had more balls up in the air. He was selling to different retailers at different prices, shipping internationally, and managing a growing company.<\/p>\n\n\n\n This made cash-flow more complex, which made it harder to make major decisions about the business. When he started using an Accounting software (ie. Quickbooks), Michael could tell at a glance everything that was owed to the company and everything they owed. Nothing slipped through the cracks.<\/p>\n\n\n\n As he says, \u201cIt paints a really good picture so we can make our financial decisions, whether it\u2019s time to buy more inventory, move to a larger location, scale back, or whatnot.\u201d<\/p>\n\n\n\n One of the toughest problems with Excel usually isn\u2019t noticeable until it\u2019s too late: inconsistent spreadsheets.<\/p>\n\n\n\n This happens all the time<\/em>. Because Excel isn\u2019t a central hub for all your accounting, budgeting, and inventory needs, you need to manually add and change data in multiple places.<\/p>\n\n\n\n Businesses of all sizes face this problem. But the bigger a company gets, the more likely they are to encounter it. According to Ventana Research, around 44% of enterprise-sized companies grapple with inconsistent spreadsheets.<\/p>\n\n\n\n The real problem with numbers not adding up is that it\u2019s hard to spot the problem. While it is possible to reconcile two spreadsheets, if an error was made back a few months ago, it\u2019s difficult to know which spreadsheet is right and which is wrong.<\/p>\n\n\n\n Spreadsheet errors tend to have a waterfall effect.<\/p>\n\n\n\n If even one cell in your spreadsheet is wrong, it can have huge repercussions down the line. Mess up one input with a wrong digit, misplaced comma or decimal point, and your spreadsheet will use that to miscalculate other computations.<\/p>\n\n\n\n Back in 2003, a small spreadsheet error cost Canadian power generator TransAlta $24 million. According to The Register<\/em><\/a>, \u201cchief executive Steve Snyder said the snafu was \u2018literally a cut-and-paste error in an Excel spreadsheet.\u2019\u201d<\/p>\n\n\n\n Maybe you won\u2019t lose $24 million, but human error costs businesses real revenue all the time. The risk of underestimating your monthly inventory expenses or overstocking your inventory can create huge problems for small businesses.<\/p>\n\n\n\n Excel has lots of capabilities, can be a good tool for your business tool box and it might work when you first start your business. But as your company grows, things change\u2014you might change your prices, raise financing, roll out a few new products or hire a few people. Before you know it, your spreadsheet can\u2019t keep up.<\/p>\n\n\n\n There are plenty of business challenges you CAN control. This should be one of them.<\/p>\n\n\n\n If you need assistance in taking your business to the next level by saving time and adding accounting value, please contact us<\/a>. We can be the accounting and bookkeeping<\/a> solution to your business success and growth.<\/p>\n","protected":false},"excerpt":{"rendered":" 2012 was a tough year for spreadsheets. First, the London Olympics accidentally sold 20,000 tickets to a swimming event that could only accommodate 10,000. According to The Telegraph, \u201ca member of staff made a single keystroke mistake and entered \u201820,000\u2019 into a spreadsheet rather than the correct figure of 10,000 remaining tickets.\u201d That same year, J.P. […]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[67,23,7,71,115,74,65],"tags":[96,97],"yoast_head":"\nExcel is not as “free” as it seems<\/h2>\n\n\n\n
Account for the time-value of accounting<\/h4>\n\n\n\n
Spreadsheets can’t accurately predict cash flow<\/h2>\n\n\n\n
Get the decision-making help you need<\/h4>\n\n\n\n
You’ll wind up with dueling spreadsheets<\/h2>\n\n\n\n
Small errors compound<\/h4>\n\n\n\n
Spreadsheets don’t scale<\/h2>\n\n\n\n