Report or Dashboard to show Sales Order balance due?

For large orders and customers that are not in the US - we will ask for a deposit before starting their order - balance due at Shipment.

We also have multiple releases/shipments on these order.

When we get payments we do:

1.) Cash receipt deposit
2.) Advanced Billing Invoice
3.) Advanced Deposit Invoice

We we do a Cash Deposit - the cash is in the bank.

We do the Invoices - they show up as deposits on the Sales Order Header but, they might not have been paid.

It would be nice to create something for our shipping department to let them know full payment has been received.

Does anyone have a tool, report or Dashboard that they use.

I am just having a problem figuring out how to show the balance due and paid.

Can you do this through payment terms and credit hold? Credit hold is meant to warn shipping from sending out product. I’ve even used some customization with that feature before.

We do payment terms and credit hold right now.

What we have trouble with is knowing the balance due - since Advanced and Deposit Billings Invoices show as a deposit on the Sales Order but, they can have a unpaid balance.