Here you are acting as logicstics company as well as money collector. And all money comes to your bank account and moves to your customers. So it's came into your bank and moves to them.
So you need to invoice only for $10 USD and from payments you need a little modification to record the received 50 USD and 10 will be your accountable. And 40 has to transfer to the customers account. And this customer account has to be balanced with accounts receivables. This way you can process it.
Because the money reached your bank. So you need to record it in your system. And debit it from your bank and credit it on customers account. May be with that you can retain balance of multiple payments and make the payment to your customers at one entry. Till that it will be only your bank balance. So keep the GL entries to handle it..
So, I tested the method by putting a $10 in sales for the customer. Then I input an entry to debit bank and credit customer with $40. it was a succus as in the customer balances it showed me $-40.
But now there are orders with zero amounts for the items and the fees is $10. So, I have put it $10 in sales. So, again the customer balance is coming correctly however we have remaining $10 in customers payments to allocate in the system and by doing so. we will have incorrect customer balance.
Before second Payment
https://ibb.co/b5LpQvK customer balance correct
https://ibb.co/pWNyS5g remaining for the customer to pay (shouldn't be anything left)
After second Payment
https://ibb.co/4gyd4SR customer Balance Incorrect
Please advise me on what to do.
Thank you so much for the reply
Best regards