FX write off not available on payment of multiple invoice

Problem reported by Burnham Savage 9 years ago

I have 3 invoices outstanding with one client - two are foreign currency, one is in GBP. The client has just paid the two foreign currency invoices in one GBP equivalent payment. There is an FX gain on the transaction. However, the system will not let me write off the FX gain, but rather forces me to allocate the remainder against the remainding outstanding GBP invoice.

What should I do?

10 Replies

Are you sure? Doesn't sound right to me. Let me do a screenshot quickly before I dash...

Hi Burnham - when explaining the bank receipt allocate the relevant sums to the two currency invoices as usual and then fill out the transaction box for the balance (ie the FX gain) using the appropriate account eg Forex Movement (make sure the VAT treatment & rate are outside scope and exclude from return) you can leave the Entity as the customer.

If you can't see the Forex Movement (or forex Gain/Loss) account then make sure it's ticked under Sales on the Account code list in Settings

Sorry K started before you P

Ok so we've got 2 USD invoices [$600 & $1200] which equate to £1264.63 and then a £900 invoice. The customer sends £1300 across to pay off the two USD invoices, with the remaining £35.37 going to FX instead of against the £900 invoice. The payment coming in should look like this:

file

I've put a cross through the VAT as the FX gain/loss should be excluded from the return [I couldn't be bothered to start again!]

Arrrggh...Paul beat me to it!

Yes but mine was boring :(

Thanks to both of you Paul and Kevin :) I must admit Kevin's example is indeed a work of art.

OK - Thanks for the enthusiastic response. In short, I effectively create another invoice, coded forex movement, and then allocate the gain against this rather than the outstanding invoice. That seems to have worked. I am now left with my original GBP invoice outstanding. Is this correct? I am assuming adding a new invoice is effectively the same as adding a new transaction...

It is, just a button or two more long winded.

Reply to this problem

Attach images by dragging and dropping or upload
 

Your comments will be public and can be answered by anyone in the Clear Books community.

Find out what we do and who we are