Report showing what youth are in which quorum/class next year

I am trying to figure out which youth will end up in which Aaronic Priesthood Quorum and YW class the start of next year. Anyone know of an easy way to build a custom report to automate this so I don't have to try to do the birthday math?

Last year while in the 4th quarter I was able to just use the attendance roll for the next quarter (1st quarter of the next year) to easily figure it out. This year those rolls are not correct. It has people list on the rolls of two different quorums and such.

I am a counselor in the Bishopric.

I don't have access to LCR to test, but see if you can print a class roll for January 2021.

Thanks for the response. I tried that, but they are not accurately showing who is in which class like I mentioned in my original post.

"Last year while in the 4th quarter I was able to just use the attendance roll for the next quarter (1st quarter of the next year) to easily figure it out. This year those rolls are not correct. It has people list on the rolls of two different quorums and such."

Obviously the best thing would be if those class rolls could be fixed.

Did anyone ever find a solution for this? Previously, our YM and YW specialists took care of this, but for various reasons we do not have specialists for this right now. I am the ward clerk. The action and interview list does not take into account the new rules for advancing in January. It only shows youth advancement on their birthdays. I can make custom reports, but I was hoping to find a report that already exists. It seems obvious to have one of these. The roll sheet option does not work because, like the OP stated, using the Q1 roll for the next year shows youth in multiple classes, so it doesn't help with identifying when they need to be interviewed. I guess you could assume that if a youth is listed in 2 classes, that means they will be advancing that year and need to be interviewed???

I just tried this today (12/5), and for us the "Next Quarter" roll correctly shows our YM advancing and not duplicating. I know there were other 2023 leadership items that earlier this year didn't work but then "synced" on December 1st, perhaps this also falls into that category. Maybe trying again will do the trick?