Rounding issue - credit due of .005

[AMXComputers]

I got a credit remaining on an invoice of -$0.005 (not sure how it arrived at that).

Nothing I can do to fudge it or get get rid of it, it shows as .01 outstanding when I go to pay it - even i try pay that amount, I can as MYOB comes up with a rounding error and wont let me.

Any ideas?

[Liz_A]

Hi @AMXComputers 

I hope you have more luck than me - I posted a rounding error enquiry in May and have never had a response. The Payroll Clearing account is still out by one cent. Apparently the calculations don't round properly.

Cheers

Liz

[SamaraM]

Hi @AMXComputers and @Liz_A 

Sorry to hear that no one has replied to you yet, but I can explain what's happening there.

There is a situation we are aware of where if the total of an invoice comes out to 3 decimal places and the last digit is a 5, it can incorrectly round up. For example, if the line total is $0.565 it will incorrectly be rounded to 0.56 instead of 0.57 and this will create what you're seeing with the 0.01 outstanding amount.

The work around for this is to manually update the unit price by $0.001 so that the final line total doesn’t end in 0.005. i.e. in the above example, you would type $0.57 over the field that is calculating as $0.565.

Hope that helps.

If my response has answered your enquiry please click "Accept as Solution" to assist other users find this information.

[Liz_A]

Hi @SamaraM 

Please see my original post https://community.myob.com/t5/AccountRight-Staffing-and/Payroll-Clearing-rounding-balance/td-p/76012... as it is the Payroll Clearing Account not anything to do with Sales or Purchases.

Regards

Liz

PS I have also sent a private message to @Tracey_H, regarding another client's reconciliation corruption, as requested and it hasn't been read, let alone replied to. Very frustrating.