{"id":27859,"date":"2017-03-20T12:44:59","date_gmt":"2017-03-20T12:44:59","guid":{"rendered":"https:\/\/www.clearbooks.co.uk\/blog\/?p=27859"},"modified":"2018-08-24T12:44:41","modified_gmt":"2018-08-24T11:44:41","slug":"how-accountants-use-spreadsheets","status":"publish","type":"post","link":"https:\/\/www.clearbooks.co.uk\/blog\/how-accountants-use-spreadsheets\/","title":{"rendered":"How Do Accountants Use Spreadsheets (And What You Should Be Using Instead)"},"content":{"rendered":"

Some things just naturally seem to go together: peanut butter and jelly, night and day, and of course, accountants and spreadsheets. The second you picture an accountant, chances are you think of them crunching numbers in a complicated Excel document.<\/p>\n

And you might be absolutely right. Accountants do tend to use spreadsheets<\/a> a lot, and for good reason. They\u2019ve got a lot of functionality, and depending on when a person learned accounting, they might have learned to do much of their work on spreadsheets.<\/p>\n

But did you know that HMRC’s Making Tax Digital requires VAT registered businesses to keep digital records and submit returns online? This means spreadsheets alone are no longer compliant for business bookkeeping.<\/p>\n

In addition to spreadsheets, accountants can use online accounting software or online spreadsheets that are HMRC recognised as Making Tax Digital ready. The benefits go beyond compliance because…<\/p>\n

Clients may struggle to use spreadsheets<\/h3>\n

Clients entering data incorrectly or changing formulas can cause road bumps when they need to work together with the accountant.<\/p>\n

Spreadsheets can corrupt<\/h3>\n

Liike any type of offline technology, there\u2019s always the risk that your spreadsheet will crash or the file will get corrupted.<\/p>\n

But with a cloud-based accounting software, you don\u2019t have to worry about data getting lost or not having the latest version of the spreadsheet that you\u2019re working with, and you\u2019re able to control who has access to what data much more easily with an online system than with a offline document, or even a shared Google sheet.<\/p>\n

They’re not as user-friendly<\/h3>\n

Besides security and control of the data, cloud accounting is also much better for the administrative stuff. Unlike spreadsheets, cloud accounting software is typically designed to hold things like client contact details, and it\u2019s much easier to find information about your most recent payments or services rendered when you can just type in phrases in a search bar, rather than having to scroll or Ctrl-F your way through a spreadsheet. And of course, finding invoices is much easier when you use a program that\u2019s specifically designed to create, track, and organise them.<\/p>\n

\u2026 and they lack some advanced functionality<\/h3>\n

While the exact things that accounting software can do vary from program to program, generally speaking, a cloud based accounting software program should be robust enough to handle things like forecasting. Most will have some type of trend or forecast function built in so you can easily look at data through a number of lenses. If you\u2019re an accountant, this can save you lots of time and hassle. Instead of having to input the formula yourself and then translate the findings for your clients, you can often just click a button and get a graphic representation that\u2019s easier for clients to understand.<\/p>\n

Got you thinking about moving your accounting to the cloud? Here\u2019s a list of the four top things<\/a> to think about as you\u2019re choosing a cloud accounting software.<\/p>\n

And of course, we\u2019re always happy to answer any questions you have about cloud accounting. Just comment below, or get in touch with us here<\/a>!<\/p>\n","protected":false},"excerpt":{"rendered":"

Some things just naturally seem to go together: peanut butter and jelly, night and day, and of course, accountants and spreadsheets. The second you picture an accountant, chances are you think of them crunching numbers in a complicated Excel document. […]<\/p>\n","protected":false},"author":145,"featured_media":28175,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-27859","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry"],"yoast_head":"\nHow Do Accountants Use Spreadsheets (And What You Should Be Using Instead) | Clear Books<\/title>\n<meta name=\"description\" content=\"Excel is a well tested bookkeeping tool. HMRC's Making Tax Digital is causing Excel alternatives like online spreadsheets to gaining popularity. Learn more.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.clearbooks.co.uk\/blog\/how-accountants-use-spreadsheets\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How Do Accountants Use Spreadsheets (And What You Should Be Using Instead) | Clear Books\" \/>\n<meta property=\"og:description\" content=\"Excel is a well tested bookkeeping tool. HMRC's Making Tax Digital is causing Excel alternatives like online spreadsheets to gaining popularity. Learn more.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.clearbooks.co.uk\/blog\/how-accountants-use-spreadsheets\/\" \/>\n<meta property=\"og:site_name\" content=\"Clear Books\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/clearbooks\/\" \/>\n<meta property=\"article:published_time\" content=\"2017-03-20T12:44:59+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-08-24T11:44:41+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.clearbooks.co.uk\/blog\/wp-content\/uploads\/2017\/11\/spreadsheet-1024x565.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1024\" \/>\n\t<meta property=\"og:image:height\" content=\"565\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"David Carr\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@ClearBooks\" \/>\n<meta name=\"twitter:site\" content=\"@ClearBooks\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"David Carr\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.clearbooks.co.uk\/blog\/how-accountants-use-spreadsheets\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.clearbooks.co.uk\/blog\/how-accountants-use-spreadsheets\/\"},\"author\":{\"name\":\"David Carr\",\"@id\":\"https:\/\/www.clearbooks.co.uk\/blog\/#\/schema\/person\/5fa6f40060d196b7177b75079fb4a3b2\"},\"headline\":\"How Do Accountants Use Spreadsheets (And What You Should Be Using Instead)\",\"datePublished\":\"2017-03-20T12:44:59+00:00\",\"dateModified\":\"2018-08-24T11:44:41+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.clearbooks.co.uk\/blog\/how-accountants-use-spreadsheets\/\"},\"wordCount\":534,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.clearbooks.co.uk\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.clearbooks.co.uk\/blog\/how-accountants-use-spreadsheets\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.clearbooks.co.uk\/blog\/wp-content\/uploads\/2017\/11\/spreadsheet.png\",\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.clearbooks.co.uk\/blog\/how-accountants-use-spreadsheets\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.clearbooks.co.uk\/blog\/how-accountants-use-spreadsheets\/\",\"url\":\"https:\/\/www.clearbooks.co.uk\/blog\/how-accountants-use-spreadsheets\/\",\"name\":\"How Do Accountants Use Spreadsheets (And What You Should Be Using Instead) | Clear Books\",\"isPartOf\":{\"@id\":\"https:\/\/www.clearbooks.co.uk\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.clearbooks.co.uk\/blog\/how-accountants-use-spreadsheets\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.clearbooks.co.uk\/blog\/how-accountants-use-spreadsheets\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.clearbooks.co.uk\/blog\/wp-content\/uploads\/2017\/11\/spreadsheet.png\",\"datePublished\":\"2017-03-20T12:44:59+00:00\",\"dateModified\":\"2018-08-24T11:44:41+00:00\",\"description\":\"Excel is a well tested bookkeeping tool. HMRC's Making Tax Digital is causing Excel alternatives like online spreadsheets to gaining popularity. Learn more.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.clearbooks.co.uk\/blog\/how-accountants-use-spreadsheets\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.clearbooks.co.uk\/blog\/how-accountants-use-spreadsheets\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/www.clearbooks.co.uk\/blog\/how-accountants-use-spreadsheets\/#primaryimage\",\"url\":\"https:\/\/www.clearbooks.co.uk\/blog\/wp-content\/uploads\/2017\/11\/spreadsheet.png\",\"contentUrl\":\"https:\/\/www.clearbooks.co.uk\/blog\/wp-content\/uploads\/2017\/11\/spreadsheet.png\",\"width\":1500,\"height\":828,\"caption\":\"There are alternatives to using spreadsheets for bookkeeping\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.clearbooks.co.uk\/blog\/how-accountants-use-spreadsheets\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.clearbooks.co.uk\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How Do Accountants Use Spreadsheets (And What You Should Be Using Instead)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.clearbooks.co.uk\/blog\/#website\",\"url\":\"https:\/\/www.clearbooks.co.uk\/blog\/\",\"name\":\"Clear Books\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.clearbooks.co.uk\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.clearbooks.co.uk\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.clearbooks.co.uk\/blog\/#organization\",\"name\":\"Clear Books\",\"url\":\"https:\/\/www.clearbooks.co.uk\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/www.clearbooks.co.uk\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.clearbooks.co.uk\/blog\/wp-content\/uploads\/2017\/06\/clear-books-plc-icon-rgb-1.png\",\"contentUrl\":\"https:\/\/www.clearbooks.co.uk\/blog\/wp-content\/uploads\/2017\/06\/clear-books-plc-icon-rgb-1.png\",\"width\":400,\"height\":400,\"caption\":\"Clear Books\"},\"image\":{\"@id\":\"https:\/\/www.clearbooks.co.uk\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/clearbooks\/\",\"https:\/\/x.com\/ClearBooks\",\"https:\/\/www.linkedin.com\/company\/clear-books\",\"https:\/\/www.youtube.com\/user\/ClearBooksVideos\",\"https:\/\/en.wikipedia.org\/wiki\/Clear_Books\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.clearbooks.co.uk\/blog\/#\/schema\/person\/5fa6f40060d196b7177b75079fb4a3b2\",\"name\":\"David Carr\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/www.clearbooks.co.uk\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/69d8259a789425fdfff25c9ee1753a1cd0e9097e39923131700f863a2a0b2933?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/69d8259a789425fdfff25c9ee1753a1cd0e9097e39923131700f863a2a0b2933?s=96&d=mm&r=g\",\"caption\":\"David Carr\"},\"url\":\"https:\/\/www.clearbooks.co.uk\/blog\/author\/david\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How Do Accountants Use Spreadsheets (And What You Should Be Using Instead) | Clear Books","description":"Excel is a well tested bookkeeping tool. HMRC's Making Tax Digital is causing Excel alternatives like online spreadsheets to gaining popularity. Learn more.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.clearbooks.co.uk\/blog\/how-accountants-use-spreadsheets\/","og_locale":"en_GB","og_type":"article","og_title":"How Do Accountants Use Spreadsheets (And What You Should Be Using Instead) | Clear Books","og_description":"Excel is a well tested bookkeeping tool. HMRC's Making Tax Digital is causing Excel alternatives like online spreadsheets to gaining popularity. Learn more.","og_url":"https:\/\/www.clearbooks.co.uk\/blog\/how-accountants-use-spreadsheets\/","og_site_name":"Clear Books","article_publisher":"https:\/\/www.facebook.com\/clearbooks\/","article_published_time":"2017-03-20T12:44:59+00:00","article_modified_time":"2018-08-24T11:44:41+00:00","og_image":[{"width":1024,"height":565,"url":"https:\/\/www.clearbooks.co.uk\/blog\/wp-content\/uploads\/2017\/11\/spreadsheet-1024x565.png","type":"image\/png"}],"author":"David Carr","twitter_card":"summary_large_image","twitter_creator":"@ClearBooks","twitter_site":"@ClearBooks","twitter_misc":{"Written by":"David Carr","Estimated reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.clearbooks.co.uk\/blog\/how-accountants-use-spreadsheets\/#article","isPartOf":{"@id":"https:\/\/www.clearbooks.co.uk\/blog\/how-accountants-use-spreadsheets\/"},"author":{"name":"David Carr","@id":"https:\/\/www.clearbooks.co.uk\/blog\/#\/schema\/person\/5fa6f40060d196b7177b75079fb4a3b2"},"headline":"How Do Accountants Use Spreadsheets (And What You Should Be Using Instead)","datePublished":"2017-03-20T12:44:59+00:00","dateModified":"2018-08-24T11:44:41+00:00","mainEntityOfPage":{"@id":"https:\/\/www.clearbooks.co.uk\/blog\/how-accountants-use-spreadsheets\/"},"wordCount":534,"commentCount":0,"publisher":{"@id":"https:\/\/www.clearbooks.co.uk\/blog\/#organization"},"image":{"@id":"https:\/\/www.clearbooks.co.uk\/blog\/how-accountants-use-spreadsheets\/#primaryimage"},"thumbnailUrl":"https:\/\/www.clearbooks.co.uk\/blog\/wp-content\/uploads\/2017\/11\/spreadsheet.png","inLanguage":"en-GB","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.clearbooks.co.uk\/blog\/how-accountants-use-spreadsheets\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.clearbooks.co.uk\/blog\/how-accountants-use-spreadsheets\/","url":"https:\/\/www.clearbooks.co.uk\/blog\/how-accountants-use-spreadsheets\/","name":"How Do Accountants Use Spreadsheets (And What You Should Be Using Instead) | Clear Books","isPartOf":{"@id":"https:\/\/www.clearbooks.co.uk\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.clearbooks.co.uk\/blog\/how-accountants-use-spreadsheets\/#primaryimage"},"image":{"@id":"https:\/\/www.clearbooks.co.uk\/blog\/how-accountants-use-spreadsheets\/#primaryimage"},"thumbnailUrl":"https:\/\/www.clearbooks.co.uk\/blog\/wp-content\/uploads\/2017\/11\/spreadsheet.png","datePublished":"2017-03-20T12:44:59+00:00","dateModified":"2018-08-24T11:44:41+00:00","description":"Excel is a well tested bookkeeping tool. HMRC's Making Tax Digital is causing Excel alternatives like online spreadsheets to gaining popularity. Learn more.","breadcrumb":{"@id":"https:\/\/www.clearbooks.co.uk\/blog\/how-accountants-use-spreadsheets\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.clearbooks.co.uk\/blog\/how-accountants-use-spreadsheets\/"]}]},{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.clearbooks.co.uk\/blog\/how-accountants-use-spreadsheets\/#primaryimage","url":"https:\/\/www.clearbooks.co.uk\/blog\/wp-content\/uploads\/2017\/11\/spreadsheet.png","contentUrl":"https:\/\/www.clearbooks.co.uk\/blog\/wp-content\/uploads\/2017\/11\/spreadsheet.png","width":1500,"height":828,"caption":"There are alternatives to using spreadsheets for bookkeeping"},{"@type":"BreadcrumbList","@id":"https:\/\/www.clearbooks.co.uk\/blog\/how-accountants-use-spreadsheets\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.clearbooks.co.uk\/blog\/"},{"@type":"ListItem","position":2,"name":"How Do Accountants Use Spreadsheets (And What You Should Be Using Instead)"}]},{"@type":"WebSite","@id":"https:\/\/www.clearbooks.co.uk\/blog\/#website","url":"https:\/\/www.clearbooks.co.uk\/blog\/","name":"Clear Books","description":"","publisher":{"@id":"https:\/\/www.clearbooks.co.uk\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.clearbooks.co.uk\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https:\/\/www.clearbooks.co.uk\/blog\/#organization","name":"Clear Books","url":"https:\/\/www.clearbooks.co.uk\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.clearbooks.co.uk\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.clearbooks.co.uk\/blog\/wp-content\/uploads\/2017\/06\/clear-books-plc-icon-rgb-1.png","contentUrl":"https:\/\/www.clearbooks.co.uk\/blog\/wp-content\/uploads\/2017\/06\/clear-books-plc-icon-rgb-1.png","width":400,"height":400,"caption":"Clear Books"},"image":{"@id":"https:\/\/www.clearbooks.co.uk\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/clearbooks\/","https:\/\/x.com\/ClearBooks","https:\/\/www.linkedin.com\/company\/clear-books","https:\/\/www.youtube.com\/user\/ClearBooksVideos","https:\/\/en.wikipedia.org\/wiki\/Clear_Books"]},{"@type":"Person","@id":"https:\/\/www.clearbooks.co.uk\/blog\/#\/schema\/person\/5fa6f40060d196b7177b75079fb4a3b2","name":"David Carr","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.clearbooks.co.uk\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/69d8259a789425fdfff25c9ee1753a1cd0e9097e39923131700f863a2a0b2933?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/69d8259a789425fdfff25c9ee1753a1cd0e9097e39923131700f863a2a0b2933?s=96&d=mm&r=g","caption":"David Carr"},"url":"https:\/\/www.clearbooks.co.uk\/blog\/author\/david\/"}]}},"_links":{"self":[{"href":"https:\/\/www.clearbooks.co.uk\/blog\/wp-json\/wp\/v2\/posts\/27859","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.clearbooks.co.uk\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.clearbooks.co.uk\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.clearbooks.co.uk\/blog\/wp-json\/wp\/v2\/users\/145"}],"replies":[{"embeddable":true,"href":"https:\/\/www.clearbooks.co.uk\/blog\/wp-json\/wp\/v2\/comments?post=27859"}],"version-history":[{"count":7,"href":"https:\/\/www.clearbooks.co.uk\/blog\/wp-json\/wp\/v2\/posts\/27859\/revisions"}],"predecessor-version":[{"id":28512,"href":"https:\/\/www.clearbooks.co.uk\/blog\/wp-json\/wp\/v2\/posts\/27859\/revisions\/28512"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.clearbooks.co.uk\/blog\/wp-json\/wp\/v2\/media\/28175"}],"wp:attachment":[{"href":"https:\/\/www.clearbooks.co.uk\/blog\/wp-json\/wp\/v2\/media?parent=27859"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.clearbooks.co.uk\/blog\/wp-json\/wp\/v2\/categories?post=27859"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.clearbooks.co.uk\/blog\/wp-json\/wp\/v2\/tags?post=27859"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}