Next Month revenue/sold report, excluding booking dates that are not in next month

[preeyanooch.heis]

I need a report to show revenue total on next month, excluding the dates that goes over the next month.

Currently I got the closest result with filtering the report
Check In From: Next month
Check In To: Next Month

This filter will give me the right bookings but the total is wrong as some of the booking goes over the next month. Meaning I would need to separate some of the booking into two months and only calculate the total of next month.

[melburyexeter]

If you use the “Monthly Invoice Charges (Invoice charges averaged per night)” report, I believe this does the booking values on a pro-rata basis. It still might not be exact, because it’s averaging the price by the number of nights rather than the actual price of each night. However, it will ignore any nights after the report end date.