When I run the sales order register , it shows total sales with x amount billed and then y amount as ‘pending fulfilment’ For our pending fulfilment orders, the majority will have a customer deposit applied to the sales order, but as we bill on despatch, it doesn’t show in this list. I’d like to be able to see our exposure, so if y is unbilled, how much have we already taken as a deposit, and what is the true value still to be invoiced Is there a report somewhere in netsuite I can run to get this info easily?

Within one report I think it would be difficult to see both. However, dumping that into excel and cross referencing in the list of deposits including which SO# they are tied to should give you that detail.