phantom amount showing on clients statement in the opening balance when it should be NIL

The statement you have attached shows two invoices and one payment but a balance of the $7 odd k

you say there are two but only one attached

the invoice 111  - have a look at it and see that it is just for the 44k not the larger amount

is it something to do with exchange rate? 
Hope that offers some help

Lisa

Hi Lisa,

The USD Statement is correct so I didn't attach it.

The statement I attached was the AUD statement and you will see a balance brought forward of $7,935.48. There is no previous transactions on the account though, so this is the problem. I searched back and there are no previous transactions.

WHilst the inv 111 was issued in AUD 44,002.64, the client paid it as USD, hence the overpayment and the subsequent refund.

So do you have two invoices one in aus dollars and one in usd ?

So you converted the USD amount to AUD dollars and received it against the invoice?

Can you go into the invoice send me a screenshot of the invoice and the history ( button on bottom left corner.

Thanks

Lisa

Hi Lisa,

I have now attached the USD Statement and a screen shot of the invoices to the company in question.

The found it too confusing to work in AUD, so the last 2 x invoices were issued in USD and the one partial payment to-date has been alloacted in USD.

As you will see from the USD Statement there was no opening balance.

The opening balance on the AUD ststament is prior to any invoices being issued or payments being received, but there are no transactions on file to create this balance.

Kind Regards,

Kirsty

Hi Kirsty

the only obvious thing I see is that there is no FX a info on the first invoice in your screenshot 

the US Statement doesn't show that invoice either

Hope that helps

Lisa

Hi Lisa,

The first invoice showing on the screen shot is the AUD invoice.

You need to look at both statements to get all of the invoices (there are only 3 - the first was issued in AUD and the next 2 in USD)

Kind Regards,

Kirsty

Hi Kirsty

what I would try is this

on the aud statement there is a payment. Of 58903.70 which is the total of the charges ( inv +FX)

I would delete the original payment and reissue against both those invoices in the same transaction 

you may need to redo the other USD payments if part of that original has been allocated to one of them

hopecthat is useful

Lisa

Sorry Lisa,

Deleting the payment and the subsequent refund has just made the opening balance on the statnt throw out more.

I am currently waiting on a call back from MYOB support after spending over 6 hours on hold trying to speak to them over the last 2 x days. It is obviously a technical issue, but I must say the lack of support from MYOB is very concerning!

Thank you for trying to assist me with this issue.

Kind Regards,

Kirsty

Hi Kirsty 

Did you reapply the 58k payment to Inv 111 and the INV OFX?  This equals the total payment of the 58k so there should not be left over 

I agree that the credit 114 should be deleted  - check that it has gone otherwise it will be on the statement

The only issue that I see is the payment for OFX is dated prior to that invoice so will through out the accounts receivable ( MYOB doesnt like prepayment of an invoice)

Agree that waiting for support can be frustrating - as is waiting for responses on the commumity at times too

Hope this helps 

Lisa