Hubdoc - Increase GST Rounding for accuracy
Hubdoc uses a different method of rounding in the "Transaction Details" section compared to the "Destination Section" which causes a "Line item tax amounts do not total to document tax amount' error
It is detailed in full within this post https://central.xero.com/s/question/0D53m00007FW4dwCAD/validation-error-in-hubdoc
It is due to a calculation error of rounding on the multiple split lines. The two values I have on an invoice are $20 and $3.70 including GST. Therefore 1.818182 and 0.336364 GST, if you sum these up it equals 2.154545. When rounded it equals 2.15 which is what my store receipt says and also what is within the hubdoc "Transaction details" section.
However in the "Destination" section of hubdoc when you split the lines, hubdoc is rounding on each individual line, therefore 1.82 and 0.34 in this case, which when summed together equals 2.16. Which is 1 cent out.
I do not see a way to resolve this unless I remove the multiple lines and code to a single line, then edit in Xero. It is clearly a mismatch in the way HubDoc are treating rounding.
I then edited the transaction within Xero and re-split into two lines. What is interesting is that Xero actually does the same rounding on each line and then sums together causing the GST total to be 1 cent out compared to the actual invoice.
-
Claudia McCarthy commented
This is a frequent problem for us and our 32 entities.
-
James Hindmarsh commented
Would be great if this could be resolved!!!
-
Sonja Feltham commented
I often have to record multiple line items and as described above the GST rounding issues mean I usually publish the transaction as a draft with a single line item and then edit again in Xero. If this could be addressed to avoid unnecessary double-handling it would be greatly appreciated!