YTD Reporting-Best Practices

Hello!  I am working on a monthly and yearly sales report and I have run into a hiccup. 

Scenario: I have a record that is a booking ("sale") that is made in Jan 2025 and then in Mar 2025 the booking is cancelled.  The way I have it now is that when the booking is made, the status field changes from quote to booking and then when cancelled, the same field changes to cancelled. 

In my YTD report, this  is causing the booking made in Jan 2025 to not show up due to the cancel in Mar 2025.  I understand it is a wash, but I still need the booking to show up in Jan 2025 and then the cancel show in Mar 2025. 

So, this is what I am thinking for a solution:  Create a date field unrelated to the status field that will populate when a cancel occurs and have the report pull of the booking date/status and also from the cancel date report and that should then show both transactions OR create a separate table that will hold the numbers at month end for each month and pull the YTD report from that table?  

I would just like any input/advice from someone more knowledgeable than myself.  I am hoping I am thinking about this in the right way.

Thank you,

Kim