Moving to the Cloud: Excel to Accounting Software

Jordan Macey

April 20, 2021

cloud accounting software guide

Free Download: Small Business Accounting Guide

Download Now ↓
Small Business Accounting

Introduction

With the rollout of Making Tax Digital (MTD) in April 2019, it has become mandatory for all VAT-registered businesses to keep their financial records in digital format, and submit their VAT returns using MTD-compatible software. 

While you can continue to use spreadsheets for your business records, you’ll need bridging software to make them MTD-compatible. Here’s a quick explanation of the term: bridging software is a tool that takes data from your spreadsheet, and “translates” the information digital in the correct format to HMRC’s system. 

Sounds complex?

Perhaps it’s time to look into online accounting solutions that can manage your VAT processes within a single system.

Reaping the benefits of online accounting solutions

In addition to being MTD-compatible, online accounting software offers important benefits to small business owners and self-employed persons.

These include: 

  • Immediacy: Your accounting data entry is kept up-to-date, which means that you’ll get an accurate view of your business finances at any time.   
  • Accuracy: The software performs the calculations, thereby reducing the occurrence of human error. 
  • Mobility: You’ll be able to access your accounts, and perform a wide range of functions over multiple devices and locations. 
  • Actionable reports: Unlike spreadsheets, reports can be quickly generated on accounting software due to its built-in reporting and analysis tools.  
  • Organisation and centralisation: Beyond accounting, your software is able to perform multiple functions, such as inventory management, payroll, customer relationship management and more.
  • It also ensures that all your data and information is stored securely within a single system. 

If you’re ready to make the switch, read on for our top tips for making your transition to the cloud a smoother process: 

Tips for switching from spreadsheets to online accounting

1. Pick the right time to transition to cloud accounting

The end of the financial year seems to be the obvious option for making the switch to an accounting software.

However, the year-end can be a busy time for small businesses—and this can make it challenging for business owners to allocate sufficient time to prepare their data and test out the new system. 

As such, a better option could be to make the switch during your slower months. This can be the month-end, quarter-end or an accounting period that offers a clean cutoff date between the two systems. 

2. Decide between moving your accounting history or entering opening balances

Should you import all your historical data, or start anew with opening balances? This can be complex, so if you’re unsure, it’s best to consult an accountant.

In most instances, it isn’t necessary to move your entire accounting history to your new software, as it’s unlikely that you’ll need to refer to past information often. Typically, it’s recommended that you export your accounting history to a backup file, and transfer only uncleared transactions to the new software. 

3. Prepare your data

Different accounting software support different formats, and your software of choice will have specifications for text limits, column headings, how the date is formatted, and more. 

You need to ensure that your data is free of error, and saved in the required format. Test this out by starting by transferring the first few rows of data, and check that your format is correct before you proceed with transferring the remaining data. 

But before you transfer your data, it’s important that you take the time to review and clean up your current accounting records. This includes duplicate vendor records, inventory errors, lost records, calculation errors and more. 

There are three steps to the cleanup process

  • Perform a thorough review: Review your chart of accounts, customer list, vendor list, inventory list, employee lists and other lists you may have to correct any duplicates or discrepancies.
  • Do an audit: Audit accounts on your trial balance.
  • Seek advice from a professional: By engaging an accountant to review your work, you’ll ensure that proper accounting procedures and regulations are being followed for your business, as well as gain advice on how you can keep your books clean moving forward.

4. Keep both systems running

Run your old and new accounting systems concurrently for a period of time, until you can be sure that your new system is running smoothly.

Depending on the size of your company and the complexity of your systems and processes, you may need to run both systems for a few days, a week or even longer.  

5. Make time to learn and test out your new accounting software

It’s essential that you carve out time from your schedule to get familiar with the new accounting software.

Review the training materials or guides published by your accounting provider, and don’t hesitate to get in touch with their support team if needed.

There will be new features and functions that you’re completely new to—but the more you invest in learning about the software, the more benefits you’ll reap for your business.

Small Business Accounting Guide

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
Small Business Accounting Guide

Small Business Accounting Guide

What's Inside:

  • When and why you may want to register a Limited Company
  • Advantages and disadvantages of a Limited company
  • Limited company alternatives
  • When to register for VAT
  • Advantages and disadvantages of VAT
  • How to take money out of your company
  • Dividend tax rates
  • Limited company expenses & corporation tax
  • Annual accounts and deadlines
  • Confirmation statements and deadlines
  • Self Assessment tax returns
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
Small Business Accounting Guide

What's Inside:

  • When and why you may want to register a Limited Company
  • Advantages and disadvantages of a Limited company
  • Limited company alternatives
  • When to register for VAT
  • Advantages and disadvantages of VAT
  • How to take money out of your company
  • Dividend tax rates
  • Limited company expenses & corporation tax
  • Annual accounts and deadlines
  • Confirmation statements and deadlines
  • Self Assessment tax returns

Read More Guides below:

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
Where can I find FreeAgent accountants? Guide

Where can I find FreeAgent accountants?

You can do so using FreeAgent's ‘Find an Accountant' resource.

Read Full GuideRead Full GuideCalculate Now

Download Now:

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
Moving to the Cloud: Excel to Accounting Software Guide

Moving to the Cloud: Excel to Accounting Software

With the rollout of Making Tax Digital (MTD) in April 2019, it has become mandatory for all VAT-registered businesses to keep their financial records in digital format, and submit their VAT returns using MTD-compatible software.

While you can continue to use spreadsheets for your business records, you'll need bridging software to make them MTD-compatible. Here's a quick explanation of the term: bridging software is a tool that takes data from your spreadsheet, and "translates" the information digital in the correct format to HMRC's system.

Sounds complex?

Perhaps it's time to look into online accounting solutions that can manage your VAT processes within a single system.

Read Full GuideRead Full GuideCalculate Now

Download Now:

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
What banks does FreeAgent integrate with? Guide

What banks does FreeAgent integrate with?

Presently, FreeAgent supports over 40 feeds from banks worldwide. You may refer to their resource to see which banks are listed, or search for your bank using the search tool in the Banking area of FreeAgent.

Read Full GuideRead Full GuideCalculate Now

Download Now:

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
Accounting Software Comparison Guide Guide

Accounting Software Comparison Guide

  • What can accounting software do
  • Why you may need accounting software
  • Benefits of accounting software
  • How to choose the right accounting software
Read Full GuideRead Full GuideCalculate Now

Download Now:

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
Is there a FreeAgent mobile app? Guide

Is there a FreeAgent mobile app?

Yes, FreeAgent offers a mobile accounting app.

Read Full GuideRead Full GuideCalculate Now

Download Now:

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
What banks does Xero integrate with? Guide

What banks does Xero integrate with?

Xero connects with most banks in the UK, including Barclays, HSBC, NatWest, RBS and more. You may view the full list of banks here.

Read Full GuideRead Full GuideCalculate Now

Download Now:

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
5 Key Benefits of Accounting Software when Self Employed Guide

5 Key Benefits of Accounting Software when Self Employed

As a self-employed person or small business owner, sing a spreadsheet to manage your accounting may once have sufficed in the initial stages of running your business.

But as your company grows, the following occurs: your financial data becomes increasingly complex, you're adding on new accounts and you may be bringing on additional staff. You now require a scalable solution-and you're wondering if it's time to transition from spreadsheets to accounting software.

If you're still on the fence, and unclear about the value that an accounting software brings to your business, here are five key benefits you'll reap if you make the switch:

Read Full GuideRead Full GuideCalculate Now

Download Now:

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
When do you need accounting software? Guide

When do you need accounting software?

In the early stages of starting up your company, managing your accounts via spreadsheets may suffice.

But as your business grows, you may find yourself spending an inordinate amount of time on getting your business finances and accounts sorted out.

Perhaps you're not entirely sure if you should stick with our current practices-or seek out a new way to handle your accounting.

We'll explore this in our article below, where we dive into five signs that indicate it's time for small business owners to make the switch:

Read Full GuideRead Full GuideCalculate Now

Download Now:

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
Best contractor accounting software Guide

Best contractor accounting software

Software can go a long way in assisting businesses and accountants alike. Often an accountant will have a preferred software that they use which could be something bespoke they have developed themselves or something they love and trust off of the shelves.

Our accountants at Forma have tried and tested many different solutions with FreeAgent being the clear winner in the contractor accounting tool.

Read Full GuideRead Full GuideCalculate Now

Download Now:

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
A self employed woman reviewing small business accounting software
Featured Article

When do you need accounting software?

We dive into five key signs indicating that it's time small business owners should make the switch to an accounting software.

Read more

Small Business Accounting Guide