Payment date and expiry date are different.
Auto-renewal billing can happen before the domain expires. Use the next charge date shown in your provider account, rather than guessing from the expiry date. If you cannot find it, leave it blank and ask the provider. A past date in the planner needs checking; it is not proof of an unpaid bill.