Prorated Amount Match with Actual Amount
Please consider below
Bill Cycle Day is 1st of Month. Lets say I have monthly price is set up as X USD. Start Date is in middle of the month and ends in middle of the month too (say term is 12 months) so both first and last month is prorated. Rest of the month are full months hence billed for X USD.
Problem I am facing is first month prorated amount + last month prorated amount is not X USD. No matter what setting I use, this will never be true for all variations. I have attached a sheet explaining the same.
Has anyone faced same problem.