Preventing accounting chaos in your product business with Xero

Published on the by Rachel Andrew. Rachel Andrew is a web developer, speaker and author. She is also co-founder of the really little CMS Perch, a simple yet effective content management system to support your online presence.

I frequently recommend online accounting package Xero to people on Twitter, however in 140 characters it is hard to get across why I think it is such a fantastic solution for people selling products.

Bookkeeping is harder once you have a product

If you are essentially a services company you most likely send a relatively small number of high value invoices per year.

With a product, in particular a digital download or SaaS application, you are likely to be recording a high number of small payments. The implications, if you are currently recording those payments by hand, is that you are going to spend a lot more time simply doing data entry – or you need to pay someone else to do that for you.

You may well also need to account for refunds if you have a refund policy, ensuring that the refund is correctly recorded in your accounts and that any VAT is also correctly adjusted.

Most people invoice for their services in their own currency, however with products it is quite usual that companies not based in the USA price in and accept dollars.You immediately find yourself with a currency conversion issue unless you are accepting payment directly into a bank account of that currency.

If you decide to accept payment in multiple currencies then you need to ensure that payments are correctly recorded in your books with the right currency.

If you are registered for VAT you need to be able to correctly charge VAT and again record this in your accounts. In the USA you may need to account for sales tax on purchases for some customers. Where VAT is concerned this can create a range of issues. In our case we are registered for VAT in the UK so we always charge VAT on purchases to other UK individuals and businesses, if they are VAT registered they claim in back through their return. We charge VAT to EU businesses as well – unless they have a valid VAT number in which case they can pay minus the VAT. when it comes to recording these transactions, which are usually in Euro, we need to know the GBPvalue of the transaction. Our EU VAT Return, a form that informs HMRC of the European VAT Registered business we have sold to, needs values in GBP even though we clear Euro directly into a EUR Bank account and therefore don’t actually do a currency exchange at the time of purchase.

You will also need to account for all of the fees involved in taking these payments. PayPal fees, bank charges, processor fees or percentages taken by Stripe and so on. These all need relating to your transactions both for profit and loss purposes but also so you can see if switching payment provider for example would save you money.

In our case we accept card and PayPal payments via UK PSP SagePay in GBP, USDand Euro. PayPal payments go into the correct PayPal currency account. Card payments are processed via our GB and International merchant accounts at BarclayCard and BarclayCard then transfers the funds to our bank accounts – we hold accounts in GBP, USD and Euro at the bank. So a single payment may end up in one of 6 actual accounts – PayPal GBP, USD or Euro or Bank GBP, USD or Euro.

There is also a time delay from the payment been processed and the funds being available. PayPal funds are immediately available, in our case GBP takes 3 working days to be in the end bank account, Euro and USD about 5 working days. If we were using Stripe there would be a 7 day rolling period before the funds would show up.

How Xero saved the day

I had moved our books to Xero before we launched Perch, after battling with Quickbooks for years. When we launched Perch we realised that even a modest amount of success would create bookkeeping mayhem and so we immediately looked at their API and saw that we could create each transaction via the API as it came in.

We have evolved this over the years as initially we only took payment in GBP. What happens now when someone buys Perch is that when we get the details of a cleared payment we send all of that information to Xero, putting the payment into the correct account in Xero. So, if a customer pays using PayPal in GBP the payment will be recorded as going into the PayPal GBP account in Xero.

If the payment is in a currency other than GBP we also log the Exchange Rate that we receive from the Xero API at the time of the payment being made. This is what we will use for our EU VAT reporting and to display on invoices as required by HMRC.

Xero knows the payment has been made long before the actual payments come through from PayPal or the bank. We then use the bank feed functionality in Xero to import automatically the bank statements for both PayPal and our bank accounts. Our bookkeeper then just needs to reconcile the invoice in Xero against the amount coming in on the feed, and account for any fees that have been deducted by creating an entry for them. If something goes wrong it is easy to spot as we end up with a mismatch – either a bank payment with no invoice or an invoice with no bank payment and we can then chase it up.

It works really well. We have a stream of payments in 3 currencies into 6 bank accounts, pretty much automated. The human check by our bookkeeper is just to make sure we catch any issues and the reconciliation view in Xero makes that as straightforward as it can be.

Other marvels

Xero makes my life easier in lots of other ways.

VAT Returns

If you are in the UK and VAT Registered then you will have experienced online VATfiling. It is an abysmal experience dealing with a site that seems to try and make it as hard as possible to send HMRC your data. Xero have always allowed you to create your VAT Return in the system, working out what needs to be entered into each section however recently they have added online VAT filing – right from inside Xero. You do not have to visit the horror that is the HMRC website. A marvel indeed!

Collaboration with my bookkeeper and accountant

We have an accountant who does our end of year and a bookkeeper who ensures everything is entered correctly and reconciled. They log into Xero from their own offices. I scan all our receipts and save them into Dropbox and the bookkeeper then checks that any outgoings from the company credit cards and accounts match up with a receipt. If the bookkeeper has a query as she goes through she can leave me a note on the transaction itself – it is then easy for me to scan down and locate a missing receipt or clarify what the expense was.

My accountant can add any journal entries directly into the system and I can just go take a look to check what has been changed. I love this – I did our own books for years and worried that by getting other people involved I would get out of touch. However Xero makes it easy for me to see what is being done so I can check if I don’t understand something.

Reporting and the Dashboard

The dashboard and the reports make it easy for me to get an overview of how the business is performing. Being able to do quick checks on how much we are spending on bank or other fees means I can make decisions about whether we might get a better deal switching to something else. This is really important as your product business grows – what makes sense if you are only doing a few transactions a week will be different to what is best at volume. You need to be able to keep track of this and Xero does that very well.

I haven’t hit the edges yet

There are lots of online accounting packages out there. The thing with Xero is that, despite having some fairly complex things going on, we haven’t bumped up against any limitations and my very traditional account seems able to do all the things he needs to do too. If you are launching a product, and especially if you are going to have VAT and multi-currency issues to deal with I would recommend you take a look.

Comments are closed.