Rounding Errors Persist

[PhatPixel]

I highlighted Blesta's rounding issues some months ago and have since switched to using the exclusive tax method in the hope that these problems would diminish.  Sadly, I continue to battle this problem daily, with rounding errors on invoice lines, invoice totals and when reconciling payments to invoices.

 

Please refer to the attached image an an example, where you can see I am reconciling one payment against five invoices.  I have entered the payment amount at the top (which is the amount the client had deposited) and checked the invoices to which this payment is being applied.  If you add up the totals of each invoice, they do add up to the amount deposited -- but Blesta refuses to accept it.  After some trial and error, I was able to record the payment by changing the payment amount at the top to be $3,809.99

 

The problem, as far as I can tell, is that Blesta is constantly performing the calculation of taxes rather than accepting the rounded two-decimal total for each invoice.

 

Rounding should be performed once only (and I would suggest this happens at the line total).  Once that rounded figure is calculated, all future calculations should work with the rounded figure.

 

I really do like Blesta, but there are these niggling issues that deeply impact the software's integrity that need to be resolved.  I hope that one day I can return to inclusive tax calculations which is how we should rightly be operating for GST in Australia. 

[Cody]

Can you narrow this down to one specific invoice, and provide steps to duplicate? Or at a minimum the values recorded for said invoice under the invoices table?

[PhatPixel]

Here's an example of one of the calculation errors in invoice #3309:

 

0.5 x 72.7273 should equal 36.36365 (not displayed)

2 x 72.7273 should equal 145.4546 (not displayed)

 

Sub total 181.81825 (rounds to 181.82)

Tax 10% of the non-rounded sub total = 18.181825 (rounds to 18.18, but 18.19 is shown)

A 0.01 error is introduced.

 

If the system is using tax-exclusive pricing, you should only need to round the Sub Total and Tax.  The Total should be the sum of the rounded sub total and the rounded tax total.

 

The way the system works with tax-inclusive pricing is actually quite terrible because on the PDF, the Unit Price shown is tax-exclusive, the Cost is tax-inclusive then the Sub Total is tax-exclusive again!  Everything should be tax-inclusive, the Sub Total is therefore unnecessary and should just be called Total.  The Tax line should indicate that it is included in the Total above.