Xero Nightmares

Blood Lust

Free Member
Sep 7, 2011
977
138
We introduced Xero in January and our choice was based on its claimed automation abilities as well as integration with Storefeeder. It has been constant unresolvable and near unresolvableproblems, and we are at the end of our wits. Please help.

1st Problem: We started Xero off, we integrated into Storefeeder, and boom, rather than just pulling in our current financial year invoices, it pulled them all in going back years. By the time we got Storefeeder to stop, 20,000 customer invoices had fed through. I really cannot believe that a modern day accounting package lacks the ability to bulk void or delete historic invoices. I mean, that is a mountain of invoices to go through one by one. Storefeeder and Xero would not void or delete them for us, luckly after a couple of months we found the Xero API, what a week that was waiting for it to crawl through all the invoices, and still leave 2000 for manual voiding and deleting due to errors.

2nd Problem: We made a simply mistake when linking our bank account to Xero, we forgot to enter an opening balance. No problem, we thought, we`ll simply do it now. Wrong, it requires all unpaid invoices to be credited off, 20,000 or them! At least by this time the stress had subsided and we started getting the giggles.

3rd Problem: We were mightly impressed with Xero having cashflow management capabilities, unfortunately we have never been able to get into it to try it. Thats right, if you have more than 5000 unpaid invoices it doesn`t work. We had hoped when we had cleared the 20,000 invoices using the API that we would get in. Nope, with Storefeeder sending in about 8000 Amazon invoices per day, and with Amazon paying up several days later, those lovely 8000 invoices are sat there as unpaid. Too many, over the 5000 limit!

4th Problem: Hubdoc doesnt work unless the invoices has a single itemised line on it. When there are 10, 20, or even 50 lines on it then it aggregates them into one line. Soo much for our automated dream of it feeding in itemised lines to Xero!

5th Problem: We decided to do batch payments, paying a small fee for each one. What does Xero do? It puts the payment amount into approved transactions matching it against the invoices, separates off the transaction fee as another line, and shows them as reconcilied. Yet, when we then look in the bank reconciliation screen the payment is still waiting their to be reconcilied, and we cannot reconcile it against the invoices as they have already been taken on the approved transactions side. I mean, what is the point in charging a transaction fee for a bulk payment, when it breaks the service. We pay 20p, we end up with more work sorting out the mess that what we would have had just doing payments one by one, and we paid for that!

Joke software, laughable, promises the Earth with its AI and Automation, only capable of delivering on half of the expectations. Can anyone give advice on sorting out this mess?
 

FreddyG

Free Member
Feb 19, 2025
356
172
My guess is that you went from something like Sage to Xero and there is an expression involving a frying pan and a fire that springs to mind! All these magic programmes that promise that you can run huge multi-billion companies from a smartphone and simultaneously link them to HMRC, the banks and Mrs Millie Tooley of 17, Oil Drum Lane are, shall we say, over-promising!

We struggled with Sage because that was all the person responsible for the bookkeeping knew. Thankfully, she fell by the wayside and we went to some rather expensive bespoke solution - sadly, no longer available, but we are still using that, warts and all (with a few patches to keep up with rubbish like 'Make Tax Digital').

But there really is no programme that covers all the possible and future needs of an SME and is cheap. If you are prepared to get your hands dirty, you could go to GnuCash, but that involves configuring more or less everything yourself. It is a proper double-entry programme that allows you to do all the stock-keeping, runs customer accounts, does multiple currencies, puts out charts and graphs for anything and everything and probably (according to its fanbase) is able to juggle with rats. The up-side is GnuCash is free and has a massive user base and you can get all kinds of extensions, patches and plugins for it. The downside is that it only allows for one single entry point. https://www.gnucash.org/features.phtml

But if you are a Me, Myself & Eye and you have already managed to make a total Horlicks of Xero, GnuCash is possibly not for you. Everything depends on two factors - (1) How much can you spend on a proper programme? And (2) How good/clever/patient is the person operating the software?

If you can de-trouser a few thousand and you have big plans for the future, I would talk to SAP. Prices start at £1k (one-off payment) but may be overkill for a Me, Myself & Eye operation.

Other options -
  • For the most idiot-proof option: FreshBooks or Wave.
  • For an easy but more powerful choice: QuickBooks Online.
  • For a UK-specific solution with VAT handling: KashFlow.
Good luck!
 
Upvote 0

Paul Carmen

Business Member
Business Listing
Jan 27, 2018
871
1
431
Newport Pagnell
insiteweb.co.uk
We use Xero and it's OK, but we work on large projects and the invoicing side is manual and we don't generate anywhere near the volume of the OPs invoices.

I'd historically built my own spreadsheets and APIs/macros to run our accounting. I loved it, but the accountant hated it, and it wasn't MTD compliant.
 
Upvote 0

Paul Carmen

Business Member
Business Listing
Jan 27, 2018
871
1
431
Newport Pagnell
insiteweb.co.uk
Xero has benefits in managing/creating repeat invoices, linking to payment providers and reconciling fees. But even our accountant doesn't use some elements, as they are clunky; e.g. he runs our monthly payroll on a separate system! Many of our back office processes are now clunkier than our in house old process.

Hubdoc is poor, it can't handle multi line, or digital billing in US or EU currencies, the time spent messing about in Hubdoc means we manually import most complex invoices.

In our experience, Xero is not a good solution for big quantities of external invoices, bills, or ecommerce. I'd suggest your use case requires a large scale ERP, probably with some customisation and workflows built for your processes.
 
  • Like
Reactions: FreddyG
Upvote 0

David Griffiths

Free Member
  • Jun 21, 2008
    11,553
    3,669
    Cwmbran
    I've used Xero for many years with next to no problems both for my own records and a large number of clients. I don't know how Xero positions itsself these days, but my initial thought is that it simply is not designed for the volume of transactions that has been mentioned. I wouldn't have dreamed of recommending it to a client who wanted to process 500 invoices a day, let alone 5000.

    It's far from being joke software. Before I started using it I actually ran three or four other online programs with a couple of months of data, and Xero was the best by far. That was a long time ago now but it's generally kept at the head of the field. For me the problem has been expecting it to do something that it wasn't designed to do.

    I'm not sure how the problem of omitting the opening bank balance was approached, but I've dealt with that before and it was very straightforward - again, it might be a volume problem.

    I do agree that Xero's payroll system is awful, though. Used it for one year and gave up.
     
    Upvote 0

    Daybooks

    Business Member
  • Sep 29, 2017
    749
    4
    329
    Your first problem was probably believing Xero could do what it claims; at least without testing. Xero is arguably the ‘Ronseal’ of accounting solutions.

    Sorting the problem out probably means changing accounting software. I would secure the current data by either extracting it from Xero or probably better securing it from the primary sources; sooner rather than later.

    Rewind to prior implementation and revisit your specification. You can probably improve the Spec. based on your newly found experiences.

    Next it depends upon what your budget is. You may find the only software providers willing to demonstrate that their software can meet your requirements will come at a premium price and they’ll charge your for consultancy and implementation. But at least they should be able to demonstrate it will work for you.

    You do tend to get what you pay for. In my view the better products are not the ones that say they integrate with X, Y and Z but those that have a ‘transaction brokering’ system whereby you can effectively hook up to anything and control the input to your accounting system. Good luck.
     
    Upvote 0

    Blood Lust

    Free Member
    Sep 7, 2011
    977
    138
    Thanks all

    Yep, years on Sage, and my God where is everything, why are there posting nominals missing (no water, no utilities, just heat, lighting, etc). What is with the naming schemes. Where are the bulk credits, bulk voiding, bulk deleting. The API kind of helps, but wont do all bulk actions and it regularly throws errors.

    I think I beat it! I created a dummy bank account, put some dummy payments in, to get rid of all those old invoices that remain. Now what do I do about 10,000 live Amazon invoices lol. My plan after finding all the import CSVs is to dummy payment them in the dummy account. Seeing as I cannot reconcile an actual Amazon payment to 10,000 invoices anyway. Treat the Amazon payment separate and it comes from the actual bank account.

    Pretend the Amazon payments are matched to the Amazon invoice, note it all up, let the accountants have the headache at the end of the year lol.

    Finally, I think I will need a new mouse every month if I have to click 300,000 Amazon invoices to allocate them to dummy payments every month!!!
     
    Upvote 0

    FreddyG

    Free Member
    Feb 19, 2025
    356
    172
    Thanks all

    Yep, years on Sage,
    Thought so!
    Finally, I think I will need a new mouse every month if I have to click 300,000 Amazon invoices to allocate them to dummy payments every month!!!
    If you are doing 300,000 Amazon transactions a month, you are going to have to use something like SAP's ERP package. (Other ERP packages are available) Xero is for the local plumber who gets two jobs on a good day.
     
    • Like
    Reactions: nelioneil
    Upvote 0

    AlanJ1

    Free Member
    Jul 25, 2018
    970
    283
    Do you need the actual invoice in for every customer on Xero?

    We used to just bring in the 2 week statement (you can use a connector for this) and then keep a record of the Amazon invoices elsewhere. (We didn't use Xero for anything to do with stock taking, that was held elsewhere and inputted for financial year etc).
     
    • Like
    Reactions: Blood Lust
    Upvote 0

    LPB 123

    Free Member
    Sep 29, 2016
    432
    91
    Xero has a soft limit of 1000 invoices a month. It's not built for what you are trying to do.

    QBO would be better at handling this but really you need a proper ERP solution at your invoice levels.

    How good is the direct integration from Storefeeder to your accounting software?

    In our experience the connector apps that connect directly from the marketplaces and carts are more customisable so we can pull in the data as we want and its what they specialise in so it works as intended. So they'd connect your Amazon and presumably other channels directly.

    For us this means importing all orders as sales receipts and ignoring fees. Each marketplace has its own "bank account" e.g "Amazon bank account" in our accounting software and each order is pulled in to the relevant "bank account".

    Each payout in to your actual bank account is a transfer from your "Amazon bank account". You then just deal with fees at the end of the month as one fee e.g Amazon fees March 2025.

    That's if you want to import at invoice level.

    If you want to import at a batch level, again, is the storefeeder integration the best at this or is one of the batch payment connector apps better?
     
    Upvote 0

    Latest Articles