Other than a lack of consistency, I see no problems with the information.  The last invoice is partially paid.  Of course I had to do that with some visual and mental math, but that is not your fault, it is the design of the report.  Depending on your boss' requirements, you could run the report with Zero paid invoice days so that only the last two lines show.  You could do the last 30 or 60 as well if you wanted a little more detail.

The consistency I am referring to is your PYMT APPLIED and APPLY DEPOSITS references.  I do very few of these and used to use the cheque numberPMT as the payment source (the original deposit would have the cheque number and a short reason for the payment showing on this report).  Now with all the different payment methods, I use PMTSYearMonthDay.  If I was applying the payments today I would use PMTS20190508 instead of your APPLY DEPOSITS.  That way each invoice/deposit applied against each other has the same reference that will always change when posting new ones.

OK, I had to re-read what you were saying a couple of times. I get what you are saying and that makes sense. It will flow and I will be able to see it a bit cleaner.

It is more my boss who hates this back an forth in and out. He would rather that I just do up a deposit invoice and apply for the payment. Then when he gives me the $21,000 invoiced to create, I would just minus all the payment from that invoice. I know that I can do this, I also know from experience deposit amounts can get missed/forgotten about. He says also will help customers to understand. I prefer to do with as a deposit so it sits there and I see the credit they have on their account.

Thank you so much for your help

Yes, what he is describing is what QB does.  It's all manual and when you look at a customer record, you don't see that amount showing as a credit, so sometimes they are missed (especially if more than one bookkeeper is involved).

To alleviate any problems with the "I know they should know that they already made a payment or two but should I be blatant about telling them now on the final invoice not to pay what they already paid" kind of concept, you can add some notes to the invoice.  I do.

I handle it this way if you are not using the Total Paid option on the invoice printout (because, to be honest, the bookkeepers at each company don't really always get the information needed, so it helps the other company if you do something like this):

OMG, you are so brilliant, Why didn't I think of that LOL I think I I was just so upset with my boss not understanding and him making me do so many different things. I could not see past my brain LOL 

This is so helpful

Cheers

Sherry