Hi there, 1anngm.
It could be that the past eight months of transactions are still not having the tracking you've set up. You can try to review several transactions belong to this period and check if they obtained your desired sorting.
If they did, then this might have been caused by data damage. Let’s run the Verify utility to identify the components affecting the issue. Once done, run the Rebuild utility to fix every issue found by the system.
Here’s an article for the detailed steps on how to perform this process: Resolve data damage on your company file.
Get in touch if you have further questions or you need assistance while working with QuickBooks.