Forum Discussion

17Lissa's avatar
17Lissa
Contributing User
10 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.

5 Replies

  • Mike_James's avatar
    Mike_James
    Ultimate Cover User
    5 months ago

    richard_css​ , my reply has errors, here is the corrected text (I am unable to edit my post now):

    this is an ongoing issue for users. Invoices posted from external systems are processed through the same 'engine' as if they were entered manually. AccountRight takes the supplied line value (as net or inclusive depending on the isTaxInclusive flag, I think) and calculates the GST. (The line GST amount is not provided in the content when posting invoices).

    The second issue is that AccountRight ensures, by adjusting the calculated GST line amount, that the GST calculated on the taxable total so far is correct. This is why the OP sees random varying net line amounts. 

     

  • Mike_James's avatar
    Mike_James
    Ultimate Cover User
    5 months ago

    richard_css​ , this is an ongoing issue for users. Invoices posted from external systems are processed through the same 'engine' as if they were entered manually. AccountRight does not just take the supplied line values (net/inclusive and GST) as given, it recalculates everything. (Part of the problem is that only two line values can be supplied).

    The second issue is that AccountRight ensures, by adjusting the GST line amount, that the GST calculated on the taxable total so far is correct. This is why the OP sees random varying net line amounts. 

    I suspect (haven't proven it yet) that Aroflo may be posting the invoices without the GST-inclusive flag set on. The result might be different if it was.

  • richard_css's avatar
    richard_css
    Trusted Cover User
    5 months ago

    Can we not have an option in MYOB to turn on or off GST rounding?

     

    We have one client who needs to have multiple lines in the invoice. We use Aroflo to invoice and send the invoice to the client. However when the sync to MYOB occurs, MYOB adds a GST rounding of 1c. When the client pays, i have to go into the invoice in MYOB, zero out the 1c, so the payment is correct.

     

    A number of their invoices are for $284.00, yest MYOB has it at $283.99. Its takes time to go through each payment and adjust, before being able to mark it off as paid!!!

     

     

  • 17Lissa's avatar
    17Lissa
    Contributing User
    10 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.