Implementing cycle count

Hi MM Experts,

I have to implement SAP cycle count at material(inventory)level in my organisation.

Each material is to be counted atleast once a year.

To do this I know that I have to set the cycle count indicator in the material master plant data view.

As I have about 10000 materials, I want them to be distributed equally amongst the working days of my organisation.

For example if we have 10000 materials and 250 working days - 10000 / 250 = 40

Which gives 40 materials to be counted each day.

As the base count date is set to the last counted date, is there a way that I can change the last counted manually that I'll be able to distribute the total number of materials equally amongst the total working days.

If there is a method where I can prepare an excel sheet and upload it to the system, can someone please guide me on how to do it.

Thanks in advance.

Regards,

Randi