GST Rounding with 4 Decimal Places
E
Exact Emu
We are currently having major issues due to the differences in GST calculation between Factory and MYOB. Upon further investigations and discussions with the team, we understand that Factory calculates GST rounding based on 2 decimal places per line, however, MYOB calculates based on 4 decimal places.
Our problem arises when the invoice or bill prepared in Factory is sent to MYOB, as MYOB is reading the totals and recalculating the GST. This, in turn, means some of our invoices are 1 or 2 cents different to the actual invoice. Whilst this doesn’t sound like a big deal, it means when completing the reconciliation, we have to go in to each invoice or bill in MYOB and adjust accordingly or the totals won’t match the actual invoice sent to the customer or the bill received from the supplier.
We would really like to be reviewed and adjusted accordingly, as this is causing major delays in our bookkeeping processes, as well as making our invoices look incorrect to our suppliers (as the GST is clearly not always 1/11th of the total value). We would appreciate the help on this one, as it is proving very time consuming and frustrating.
Thanks :)
Paul Lutkajtis
This is unfortunately such a tough one :( Of all the accounting packages that our customers use, MYOB is the lone accounting package that calculates tax differently (Xero, QuickBooks etc. all follow the same standardised method for tax calculation that marries up with Factory perfectly). As we can't calculate tax in more than one way on an order, we have to pick the path that accommodates the largest number of businesses in market. We'll revisit this topic once again and see what's possible!
For what it's worth, we're seeing more and more customers move from MYOB to Xero due to it's ease of use, performance and huge number of marketplace apps. If that's something you'd ever like to consider, we'd be happy to discuss helping you make that transition also :)
E
Exact Emu
Paul Lutkajtis Thanks Paul - I understand it's a tough one to fix!
I'm not sure if the directors would consider a change any time in the near future (one software change is definitely enough for now haha) but I will keep it in mind.
S
Specified Limpet
I too would love the invoices to be the same in both Factory and MYOB. However, our way around this is we have incorporated a process of what we call "checking our 1 cent's". Whoever is invoicing out of Factory then goes over to MYOB and adjusts at that time. It ensures the statements match the customer's invoices and when payments are made reconciliation is spot on.
E
Exact Emu
Specified Limpet This is a great idea - thanks for the suggestion. We will implement similar and hopefully there is an easier work around at some point in the future.
Factory Issue rounding