Importing Invoices from file ROUNDING errors
Why can we not in 2026 still not import invoices into MYOB with true TAX INCLUSIVE pricing? It's hard not to get emotional about something when you've just spend the good part of 24 hours straight tr...
Forum Discussion
You are right that only net amounts matter on import, GST amounts are ignored/recalculated.
The attached jpg explains how MYOB is recalculating GST on imported transactions. (It does this in the core program too but you can't see it happening).
The process ensures that after every line is imported, the GST applied to the net total so far is correct. The result is that individual line GST-inclusive amounts will never agree to your source document, but the inclusive invoice total and the net line amounts always will.
This applies to mixed-GST rate invoices as well.
Are you suggesting that imports via the API do not have this problem?
Reading invoices via the API presents the problem in reverse - the endpoints only give you the net or inclusive amounts (depending on the GST-inclusive setting) and the GST rate. In some situations we have to repeat their calculations to agree exactly with MYOB's transactions.
Whilst I appreciate the response, and with all due respect – this is a politician’s answer. It neither acknowledges that there is a problem, nor does it proffer any solutions. The ATO accepts two methods of applying the GST: either taxable supply method or total invoice. There is no real reason for MYOB to be recalculating the GST for the entire invoice as each line is being imported – especially not if I have already explicitly passed through an already pre-calculated GSTamount . I mean if the GST field were left blank in the import file for MYOB to determine and apply the GST, then sure – knock yourself out. But what is the point of passing through a line rate and a GST amount only to then have MYOB ignore both and run some funky process that not only ignores the amount of GST you have passed through but then also recalculates the line rate to some absurd level of precision. Who would voluntarily exculpate this?If it absolutely must validate line by line, then validate the GST amount being passed through from the import file to ensure it is within some sort of acceptable level of rounding tolerance.
But again, to reiterate the original point – sometimes people just need to be able to import invoice pricing that is inclusive of the GST. If I go to McDonalds and buy myself a Happy Meal, I am forking over $6.45 – not $5.86 (ex.) or as MYOB would have you occasionally believe $6.4500222 (inc.).
As it stands, the INCLUSIVE flag seemingly serves no other purpose other than to forcibly trigger the corresponding click event on the box in the editor upon completion of the import. Surely, a more apt use of field would be to allow inclusive prices to be truly imported – put an X into the inclusive field, set $6.45 as the rate and then have MYOB do whatever it needs to do to ensure the inclusive amount remains at $6.45 when the line is imported. To be clear - the flaw is in the import routines, not anything that is occurring once that transaction is in the editor. If you go and create a manual invoice with 1 lot of something and bill it at $49, the editor is more than capable of maintaining the correct product rate, line GST and total invoice GST - even after multiple edits. But export that same invoice and then reimport it back in and it all goes pear shaped.
Just so I know - are we the only idiots in the country that have opted to charge $49 inc. for something?
Hi JohnSeytabla , my post clarifies how MYOB processes invoice line amounts, and demonstrates that it is not currently possible to match GST-inclusive values in the source transaction. This is a failure in the program design.
The import process in the former V19 versions allowed inclusion of exclusive, GST and inclusive values, which was a far better design.
