Recurring charges for memberships - both migrated and new memberships sold - are automatically charged around 12:05 am of the renewal date (based on your studio's local time). Depending on the volume of the queue, some of the charges may finish processing shortly after midnight.
If the renewal charges are successful, they'll appear in the Orders report immediately.
If a customer is in payment failure and updates their card, they'll be charged immediately.