Discrepancy in invoice Amount in MYOB.
Hi MYOB, We are integrating the MYOB with our CRM (BQE CORE) while we send the invoices to Myob from our CRM, we see penny discrepancy in the total amount of invoices in Myob. Example, We have ...
Forum Discussion
Hi Dev_Integration , your GST amounts are calculated in the CRM system according to each line, and are both rounded up:
Services Amount = 4409.25 + 440.93 = 4850.18
Expense Amount = 442.75 + 44.28 = 487.03
Total = 4852.00 + 485.21 = 5337.21 (technically inaccurate in total)
MYOB recalculates the GST on the total so far, and adjusts the line GST accordingly:
Services Amount = 4409.25 + 440.93 = 4850.18
Expense Amount = 442.75 + 44.28 = 487.03 (initial calculation)
Check 4852.00 * 1.1 = 485.20 therefore line 2 GST is reduced by 1 cent.
Expense Amount = 442.75 + 44.27 = 487.02
Total 4852.00 + 485.20 = 5337.20 (accurate in total)
This calculation procedure cannot be amended during the posting or import process.
Thank you Mike_James, I appreciate your valuable time and expertise, I was of the same opinion that Myob calculates GST on Total amount, not on the Line amount. But I was not sure.
