Dear Camilla, 
Thank you for your question. 

Do you have a separate accounting category for no-shows? 
If so, then the best option would be using the Accounting report, if you set the filter to: 
→ Group by - Accounting category
→ Accounting category - No-show

you will be able to views all the revenue that was booked for this accounting category under the Revenue field and all the payments taken under the Payments field. If you run a report in a Detailed mode, you will be able to view each bill where these items have been booked. 

Please let me know if this helps. And if you have any questions, please also do let me know!

Warm regards, 
Elena