Switching from Sage 50 to Xero Accounting Software

For once, here is a non-technical post from me. I’ll describe my experiences of changing from Sage 50 to Xero accounting software. In particular I’ll highlight a number of pitfalls that you might wish to be aware of prior to switching to Xero.

Background

Skip this bit if you don’t like politics.

HMRC (the UK tax authority) is imposing a policy called Making Tax Digital (MTD) from 1 April 2019. The policy applies to most companies whose turnover exceeds the VAT registration threshold of £85000 per annum. Therefore, a large number of small business are caught by it.

Let me say straight away that IMO, MTD is a bad, unnecessary policy. I have no issue with the requirement to submit VAT returns online instead of on paper – I have been doing that for many years. What I take issue with is the requirement for companies to use approved accounting software that sends VAT returns direct to the HMRC. You can no longer use a spreadsheet to do your accounts and calculate VAT, then log on to the HMRC portal and enter the figures. For now it’s still permitted to use a spreadsheet, but you must use approved bridging software to load that data directly from the spreadsheet and transmit it to HMRC. What is the purpose of this? The chances of someone entering an incorrect figure in the VAT form – which he/she will surely check before submitting it – must be tiny compared to the chances that an error has been made somewhere in transferring the data from paper or PDF invoices into the spreadsheet in the first place.

I’m very disappointed that the Federation of Small Businesses hasn’t opposed MTD.

None of this should have mattered to me, because I was using Sage 50 to manage my accounts and submit the data directly to HMRC. Unfortunately, Sage is a classic example of a company abusing monopoly power. Back in the late 1980s and early 1990s, there were several UK-developed accounting software packages to choose from. But over several years, Sage bought up all the competition and acquired a near-monopoly in small business accounting software suitable for UK-based businesses. Accounting software from overseas was generally unsuitable for use in the UK because either it didn’t understand VAT or it was in the wrong language.

My company was using Sage 50 Accountant Plus. This package was somewhat more powerful than I needed at the time, but it was affordable because I didn’t need continuous support, so I could avoid paying the annual support fee. About once every 4 years I would buy an upgrade to the latest version, costing around £600. So I was paying on average about £150 per annum.

Two factors made this approach no longer viable. First, would software that was MTD-approved when I purchased it still be approved 3 to 4 years later? Secondly, Sage started using aggressive tactics to try to force me to pay around £600 every year for support, such as sending me bills for annual support that I hadn’t ordered, threatening to use debt collectors if I didn’t pay, and changing the license terms. On top of this, Sage software had shown hardly any significant improvement over the 20 years I had been using it, and they started pushing customers to use Microsoft Office 365 in conjunction with their software – but I ditched the bloated and overpriced MS Office years ago for a mixture of Libre Office and Google Docs.

So I had reason to despise Sage and to look for alternatives.

Choosing a new accounting software package

The leading small business accounting software solutions are all cloud based. When I started looking, the popular choices appeared to be Xero, QuickBooks, and KashFlow. Sage made a belated entry into this market with Sage One, later renamed Sage Business Accounting.

The factors on which I made my decision were:

  • Did the package have all the features that I needed?
  • Could it import my existing data from Sage 50?
  • What was the monthly cost?
  • Could it import statements directly from my bank?
  • Was my accountant able to produce annual accounts from it easily?
  • Did existing users recommend it?

Regarding costs, all of them came in around £22 to £25 per month (most also had a more basic option at lower cost that didn’t meet my needs). Further research suggested that KashFlow was probably too basic for my business. Xero and QuickBooks both looked adequate, but UK-based accountants who were familiar with both tended to prefer Xero (including my own accountant). Xero would import my Sage 50 current year and previous year data at no charge. Incredibly, Sage doesn’t provide any facility to transfer data from Sage 50 to Sage Business Accounting.

So I chose Xero.

Making the switch to Xero

I chose to switch right after submitting my VAT return at the end of a VAT quarter. Switching at the end of an accounting year was not possible because my financial year ends after the MTD compliance deadline.

Converting the data was done using movemybooks.com. Xero pays for the conversion of up to two years of data. You can have additional years converted for £60 each. The first time I tried to do the conversion, there was a problem with a couple of transactions. A quick search of the help explained the problem. I fixed those transactions in Sage, tried again, and the conversion succeeded.

Later, I found that I needed to make some manual changes to the imported data.

Flag all bank transfers in the imported data as reconciled

When I came to reconcile bank statements with bank transactions, all my previous bank transfers in the current and previous year showed up as not reconciled, despite having been reconciled in Sage. This means they were offered as possible matching transactions to un-reconciled bank statement lines. To prevent this, I had to open each bank transfer transaction individually and then tell Xero to flag it as reconciled. Tedious because there wasn’t an option to select transactions in bulk and flag them all as reconciled. But at least I shouldn’t have to do it again.

For each supplier account, enter their credit terms

When I started entering purchase invoices (“bills to pay”) in Xero, it insisted that I enter a Due Date before it would accept the invoice. But then I realised that Xero allows you to set up the credit terms provided by each supplier, and once you have done that it will populate the Due Date automatically.

Correct the VAT number and country in records for overseas customers

Some of my EU customers had the VAT number imported correctly. Others showed a VAT number without the 2-character country prefix and the VAT country shown as “EU country”. For these I had to enter the correct country and insert the 2-character country prefix. Otherwise the VAT number isn’t be shown correctly on invoices to that customer, and the EC Sales List data contains invalid VAT numbers.

Xero: the good points

Using Xero has been mostly painless. The bank feed integration works well and bank reconciliation is generally much easier than it was with Sage 50. Having fetched the transactions from my bank, it lists the unreconciled bank transactions. For some of them, Xero suggests a transaction to match it against, for example an unpaid sales or purchase invoice. Otherwise, you can search for transactions to match it against, or enter a new transaction.

I have found Xero support responds quickly, although they were not always able to provide solutions to the problem I was having.

Xero: the bad points

As Sage 50 was much more powerful than my business justified, and Xero had such good reports, I was expecting Xero to do everything I needed with the exception of departmental analysis (which I knew that the Xero packages I subscribed to wouldn’t do, but decided I could manage without). So a few things came as a nasty shock.

Xero assumes that you don’t manufacture your inventory, you purchase it

I manufacture electronic parts for 3D printers, and I wanted to track my inventory. Nothing complicated like a bill-of-materials, I just need a means to tell Xero that I have manufactured X items at a total cost of £Y each. But I can’t enter an item cost without Xero assuming that I must have purchased the items from someone. So I’m having to enter the cost price as zero, which of course means that the stock valuation is completely wrong.

Xero doesn’t have a good facility to print packing slips/delivery notes

This is truly incredible, it’s such a basic feature that many (perhaps most) businesses need. To create a packing slip in Xero, you need first to create custom invoice branding. The problem for me is that this has to be a .docx file and it can only be created in Microsoft Word. I ditched the overpriced MS Office years ago in favour of Libre Office. Xero does provides a .docx template to print both an invoice and a packing slip. Like many businesses I send packing slips with the goods and invoices by email, so I wanted the packing slip without the invoice. I tried editing their .docx template in Libre Office, but then Xero won’t import the .docx file written by Libre Office.

To their credit, when I reported this problem to Zero, they sent me a modified version of the template that prints just the packing slip. That is what I now use. But I am unable to add my company logo to it without buying MS Word. To print a packing slip, I have to select the invoice, switch the branding to “Custom branding”, then print it. Then remember to switch the branding back to Standard before I email the invoice. Come on Xero, printing packing slips/dispatch notes is such a basic function that it’s crazy that you don’t provide a separate “Print packing slip” button.

When entering a purchase invoice, you can’t amend the VAT amount

When you enter a purchase invoice, you tell Xero which VAT category it falls into and it calculates the VAT for you. You can enter the invoice line amount as VAT-inclusive or VAT-exclusive. But either way, you have to accept the VAT amount calculated by Xero.

Unfortunately, suppliers sometimes calculate the VAT amount incorrectly, or round the amount in a different way. So the VAT amount shown by Xero may not match the VAT amount shown on the purchase invoice. Now, my understanding of VAT law it that as a VAT-registered trader, I can reclaim the VAT amount shown on the invoice and no more. So if I accept Xero’s calculation of VAT and it is higher than the amount shown on the invoice, I will be guilty of committing a “careless or deliberate error” in VAT parlance and could be fined. Maybe not for a single error of £0.01, but over a year or more those pennies mount up.

You can’t enter bank transactions directly, you can only import them from statements

The bank feed took some time to set up, so when I came to reconcile my first set of bank transactions, there were about 6 weeks of bank transactions listed on bank statements that were not included in the bank feed, and therefore unknown to Xero. No problem I thought, I’ll enter them manually as I would have done in Sage. But there is no facility to enter a bank transaction manually. The only way to get bank transactions into Xero is to import them, for example in a .csv file. In case you want to enter them manually, Xero provides a .csv template that you can populate in a spreadsheet. I tried this but found it a pain to use. Fortunately, I was able to get a .csv file listing those transactions from my bank’s online service, and even after sorting out the columns, that was probably quicker than entering them all manually would have been.

If Xero doesn’t support direct feeds from your bank, and you are unable or unwilling to get a bank statement in .csv form, then this will be a severe disadvantage to you.

Bank reconciliation doesn’t take account of credit notes

When bank reconciliation in Xero works well, it is a joy to use. But it ignores credit notes, which is bizarre. I had two supplier accounts which each contained multiple unpaid invoices and a credit note. For each one, I had made a bank payment to pay of the net amount due. When attempting to reconcile those transactions, in each case Xero found the matching invoices, but it ignored the credit notes. So it refused to reconcile them because the totals of the invoices didn’t match the bank payment. But if I went to the supplier account, the total outstanding amount shown matched the bank payment. I had to allocate the credit note against one or more invoices manually; then the outstanding invoice total matched the bank payment and I was able to reconcile it. Why doesn’t Xero allow credit notes to be included in the reconciliation?

Xero won’t submit EC Sales Lists direct to HMRC

I was used to having Sage list my EC sales and then submit them for me direct to the HMRC portal. But Xero can’t do this. It will list the EC sales for the period you choose, but then you have to log on to HMRC and enter them manually. Fortunately I only sell my products in bulk these days, so the number of EC sales I make is small enough that copying them across manually isn’t to tedious. However, if you make a large number of sales to EU VAT-registered companies, then this could be a compelling reason not to use Xero.

Xero doesn’t allow negative stock

Xero won’t let you invoice a customer for stock items unless it thinks you have enough stock. In an ideal world I would always book items into stock before I dispatch them to customers; but sometimes I need to ship goods to customers as soon as I have received and inspected or tested them. But Xero forces me to adjust the stock first, which is a nuisance – especially when I am not ready to book the entire batch into stock because I have only tested the units that I needed to ship urgently.

Summary

From my perspective, the difference between Sage 50 and Xero is this. Sage 50 is fully-featured accounting software, but lacks the ease-of-use of Xero. Whereas Xero has a much better user interface, but is less mature in terms of the features it offers.

Overall, I’m happy that I made the switch, because I am paying less than it would have cost me to continue using Sage 50, I like the Xero user interface, and Xero appears to be a responsive company. I’m still fairly new to Xero, so I’ll update this blog entry as I learn more – and hopefully, as Xero continues to improve.

Advertisements
Posted in Accounting | Tagged | Leave a comment

Improving the Robotdigg SCARA printer

In the first post in this series I described how I strengthened the bad T-frame of the printer and added adjustable levelling feet. These improvements made it possible to produce prints. The conversion to Duet electronics described in my second post improved print quality and provided faster print speed. However, the large amount of backlash in the distal arm joint drive remained, along with the lesser but still serious backlash in the proximal joint drive. If I was ever to get good prints from this printer, the backlash in both joints would need to be addressed. Continue reading

Posted in 3D printing | Tagged | 3 Comments

Converting the Robotdigg SCARA printer to Duet electronics

In my previous post I described the Robotdigg SCARA Arm 3D printer in its original form. This post covers the conversion to Duet Ethernet electronics. It may seem odd to use top-of-the range electronics with budget mechanics, and I am not suggesting that it would make sense for other owners of this printer. In my case it made sense because I needed a test bed for testing and maintaining SCARA support in RepRapFirmware, the firmware that runs on the Duets. Continue reading

Posted in 3D printing | Tagged , | Leave a comment

Testing the Robotdigg SCARA Arm 3D printer

A colleague spotted this Robotdigg SCARA Arm 3D Printer which sells at just US$280 + shipping and import VAT. As I was working on SCARA printer support in RepRapFirmware, this seemed an ideal low-cost platform to test it on. So we bought one.

In this blog entry, I describe my experiences with this printer as it arrived and what I needed to do before I could try printing with it. A subsequent entry will describe the conversion to Duet Ethernet electronics. Continue reading

Posted in 3D printing | Tagged | Leave a comment

Time to rebuild my large Kossel

It’s more than a year and a half since I published my large Kossel build blog entry. Since then I have upgraded it many times. Several people have built 3D printers based on this design, and some have asked for a more complete bill of materials. So I decided to create a page on this printer as it is now, including yet more upgrades. Continue reading

Posted in 3D printing | Tagged , | 63 Comments

More Delta Printer upgrades: WiFi and Silence!

Some of you may already know that I have been working on a new version of the Duet 3D printer electronics. The new board is called the Duet WiFi, and it a joint venture between my own company Escher3D and Think3DPrint3D. The first pre-production board arrived a few days ago. After bench testing it, the time came to install it in a 3D printer. I chose to install it in my delta printer, which is more demanding of the electronics than my Ormerod. Continue reading

Posted in 3D printing | Tagged , , | 4 Comments

Print bed surface roundup

This time I will discuss the various print surfaces I have used and my experiences with them. Your results may differ. Continue reading

Posted in 3D printing | Tagged , , , | 22 Comments