Forum Discussion

17Lissa's avatar
17Lissa
Contributing User
3 months ago

GST calculations vary by 1c

Hi there,

I recently changed an item amount for invoicing and I now have varied gst calculations and this affects the overall total on the invoice.

For example we went from $88/hr labour charge to $95/hr. The invoice shows the Unit price ex GST, the Total Ex GST and the Total amount Incl GST. In the Unit price ex GST it shows the price as $86.36 but will show the ex GST as $86.37 in some lines depending on the labour amount (2 hours and 1.5 hours labour on a recent invoice). This then affects the next column for Total Ex GST and the Total amount Incl GST and gives me a different Final total by a 2 or 3 cents less.

Initially I had the 6 decimal place issue when updating the labour price and I fixed that by using the EX PRICE 2 and INC PRICE 2 in customise forms. I have also used customise forms to remove the Ex GST columns and it does not help.

I have manually edited the Total amount Inc GST on individual invoices and although this gives me my correct overall invoice total, it still shows variations in Unit price ex GST and also a 1cent difference in GST for the invoice, so not a great fix.

Is there a way to round to just 1 decimal point and not 2 and this may fix my issues? I am running Account Right Standard 2025.1.0 offline.

Thanks.

2 Replies

  • 17Lissa's avatar
    17Lissa
    Contributing User
    3 months ago

    Hi Sai,

     

    Thanks for you reply. I did look into this post but don't believe it is the issue. My 1 cent rounding issue is not consistent. It will occur randomly on an invoice. For example recently there were lots of 1 hour labour billed and one 1 hour labour showed as $86.36 ex GST and one showed as $86.37 ex GST. It will mostly show as $86.36 per unit ex GST, with the odd labour charged showing $86.37 ex GST. I understand it is a rounding issue, however it is not consistent. It randomly rounds up here and there through an invoice which will have 10 or more lines of labour charges. I have managed to fix the overall labour charge including GST with the actual selling price through the card and I have also managed to fix the overall total GST at the end of the invoice. So Total amounts are at least correct, it just isn't the best look to clients that the figure for ex GST will vary.

    I will look into contacting live support.

     

    Thanks.

Looking for something else?

Search the Community Forum for answers or find your topic and get the conversation started!

Community home

Dig into MYOB Academy for free courses, learning paths and live events to help build your business with MYOB.