This gets even better! No word of a lie, it has taken me about four hours to get down to this being the problem. Its this sort of nonsense that made me move away from Xero. Turns out the invoice editing screen can show one total and then when you save the invoice it calculates another total. Was this really on the functional requirements for the system or was it put into the work list for a burn down run? What's the solution to this one?
You might have guessed that I am expressing a lot of frustration here and that's because I have a, not unreasonable, expectation that an accountancy system will add up numbers correctly. These issues with rounding were resolved a long time ago in wider field of databases and software etc. Please accept my apologies if this winds you up - its not meant to do that. My frustration is driven purely by the fact that I can ill afford to spend time patching up the mistakes of a system that I'm starting to rely on.
Having said that, the system is helping me spot a number of issues with a very difficult client account which I am very please with and thank you for that.
Also, having worked on your side of the fence, I know how difficult it is when you're working hard to provide a great product and you get customers like me ranting and raving and callling your work into question. So, I do understand and any help you can give in resolving this will be appreciated.
The issue is:
I couldn’t get INV00002 to reconcile so I went into the invoice to check I had applied the recommended workaround correctly and yes I had because it was showing £658.72 which is what I wanted
Then when I saved the invoice, the total changed from £658.72 to £658.73. Because the system is rounding £355.42 on the edit screen into £355.43 in the total.