Report that captures cancellations and refunds?

I submit an invoice monthly to my clients for my commission. Last month I had a number of canceled bookings, some which were partially refunded and others that were not refunded at all. I'm entitled to my commission on the amount kept on those bookings but can't find a good way to capture that in a report on OwnerRez.
I typically use the Line Item report to categorize rents and cleanings and manipulate these in excel to get the data I want. I can check "include canceled bookings" but this report doesn't identify which bookings were canceled. Furthermore it doesn't report refunds.
Anyone have any suggestions?

Hi Pedro,

You should adjust the charges on those cancelled/refunded bookings to be whatever the guest actually paid. So if the booking start at $1,000 but then dropped to $200 (ie. the guest has to pay 200 for the cancellation) then the final charges on the booking should show the 200. You would then put your commission on that. The fact that a booking is cancelled should not impact the finances or reports. You can have cancelled bookings with charges and payments, and they will show up on reports.

That makes sense. I'll need to do that manually though?
And you're saying to record a refund in the booking, correct?
In the Line Item Detail Report I generally use for this after I record the refund I don't see it reported in this report. Which would you suggest I use?

Yes, that's right, because you know what the charges really should be / were.

sorry, I edited my message above to add a few more questions you probably didn't see before replying.
You're saying to record a refund in the booking, correct?
In the Line Item Detail Report I generally use for this after I record the refund I don't see the refund reported in this report. Which report would you suggest I use?

At this point I think it's probably better for you to write in to the Helpdesk with the specific booking you're trying to sort out.