If you have a lot of transactions though, one thing you can do is for individual (or all) products is undertake stock counts, and adjust your records to store an updated starting point for the stock calculation.
if you struck a balance at say 1st August 2025, then you only have to sum 1 months...