+1 to going through your reservations and using Modify to find how your points are currently used.
More longterm, I'll advocate for spreadsheets. Everyone has their own approaches here!
While I do have spreadsheet tabs for each contract to track more of a financial aspect (which has basic usage data), I don't love them for 'what's the state of my points' type of tracking.
I also have a 'Stays' tab that lets me track, in a single tab, all the usage across all contracts. But it's more focused on enabling analysis of how points are used (room type, home resort vs. not, rack rates at various resorts for the same dates, etc.). Still not great for 'what's the state of my points' type of tracking.
I also have a 'future planning' tab that lets me map out usage for multiple years ahead, making sure I don't run out or let points expire. It has a condensed version of the Stays tab (as it's important to know the history to build off of) plus per-contract points availability.
As I also have many contracts, this 'future planning' tab ended up being my best version of a condensed view of where points went in the past, what points are available 'now', and what points will be available in the future. This is my go-to tab for 'what's the state of my points' type of tracking.
Here's a screenshot from my 'future planning' tab of some of my prior stays and 7 of my contracts (max I could fit in the window width, even at 75% zoom):
Other than the color coded cells in the middle, it has basically no formulas and I find pretty easy to maintain
once you get your baseline built. Building the baseline might be a chore, though...