Please include a € amount column in “Outgoing invoices”, where you can enter the “Expected payment amount”. Sometimes it is already known that the bill is not paid in full. You could enter this here and thus get a realistic number for “open net” or “open gross”.

There is also an “expected payment date”.