Report Creation by End of Day

Hi all,

Is it possible for the bot to produce an excel report just at the end of the day - which would have the needed details for all transactions done during that particular day.

We need just one excel report per day, despite how many times the transaction happens on that day.

I am familiar with transaction excel report but not so sure on daily report.

Any help is appreciated.