GST Rounding with 4 Decimal Places
under review
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 :)
Riz Ybañez
Hi all! Quick update.
We've fixed two precision bugs that were causing small cent-level discrepancies on some sales orders.
The main one: when a discount was applied to a line with fractional quantities (like 4.005 units) or unit prices with extra decimals (like $12.588), the line total could land 1-2¢ off, and saving the order (whether new or being edited) could trigger a "prices don't match" error. We also fixed a related precision issue affecting certain discount percentages (12%, 34%, 66%, and 88%), which produced the same save error in those cases. Line totals now calculate correctly.
One thing to keep in mind: Factory uses line-by-line rounding when calculating totals, which is standard behaviour across Xero, QuickBooks, and most accounting systems. Because each line is rounded individually, orders with multiple line items may occasionally have small cent-level variances between the summed lines and the order total. This isn't a bug or a new issue. MYOB applies rounding differently at the invoice level, which can result in small variances between the two systems.
On MYOB specifically, this fix doesn't close the Factory-to-MYOB gap that started this thread - it's a separate issue. MYOB adds the tax across all your line items first, then rounds the total. Factory (along with Xero and QuickBooks) rounds each line first, then adds them up. That difference can produce a 1¢ gap on some invoices. It's a quirk of how MYOB works, not an error on Factory's side.
This post is staying open. The team's actively reviewing options for MYOB users, including the rounding line item idea raised earlier in this thread.
Thanks for the detail in this thread, it's helped us understand the impact.
Paul Lutkajtis
marked this post as
under review
Paul Lutkajtis
Merged in a post:
Rounding to account for GST
D
Dusk blue Quail
I think it would be great to add a "Rounding" amount down the bottom of PO's SO's, the same as the Delivery Fee is. This would be used when GST is making it hard to match the correct totals. e.g. this invoice, we quoted at $830INC. The amounts in the order made it very difficult to get it to exactly $830, it was either $829.99 (which is what was invoiced), or $800.01. Not a big issue with Sales Orders, but when receiving PO's, we need to be able to match the Suppliers Invoice exact.
I got the idea from Xero.
Photo Viewer
View photos in a modal
I
Interested Bass
However, we actually need 5 decimals in Factory as the kit unit price doesn't match the line item price total. i added an example based on our order 592. We have issues converting orders due to the rounding.
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.