Prorated Refund Calculator
Calculate a prorated refund for annual subscriptions
Copy templates to use them anywhere:
Prorated Refund Calculator
Calculating a prorated refund for an annual subscription can be challenging. If you're in Customer Support for a software company, you're likely needing to calculate these types of refunds frequently.
This calculator makes it simple to figure out how much of a refund is due back with a few simple inputs.
Prorated refund calculator
{note: trim=yes}1) Enter full amount to prorate: ${formtext: name=fullamount}
2) Enter the service start date: {formdate: YYYY-MM-DD; name=startdate}
3) Select start date of the partial refund: {formdate: YYYY-MM-DD; name=prorationdate}
4) Select end date for the partial refund: {formtoggle: name=annual subscription (adds 1 year to start date); default=yes}{endnote}{if: `annual subscription (adds 1 year to start date)`}{enddate={time: YYYY-MM-DD; at={=datetimeadd(datetimeadd(startdate, 1, "Y"), -1, "D")}}}{else} Enter subscription end-date: {formdate: YYYY-MM-DD; default={time: YYYY-MM-DD; shift=+1M}; name=enddate}{endif}{fullterm=datetimediff(startdate, enddate, "D")}{prorationperiod=datetimediff(prorationdate, enddate, "D")}{if: datetimediff(startdate, prorationdate, "D")<0}{error: Partial refund date must be after the service start date; block=yes}{elseif: datetimediff(prorationdate, enddate, "D")<0}{error: End date of partial refund must be after the partial refund date; block=yes}{else}{note: trim=left} The prorated refund amount is {endnote}{=(fullamount/fullterm)*prorationperiod; format=$.2f}{endif}
2) Enter the service start date: {formdate: YYYY-MM-DD; name=startdate}
3) Select start date of the partial refund: {formdate: YYYY-MM-DD; name=prorationdate}
4) Select end date for the partial refund: {formtoggle: name=annual subscription (adds 1 year to start date); default=yes}{endnote}{if: `annual subscription (adds 1 year to start date)`}{enddate={time: YYYY-MM-DD; at={=datetimeadd(datetimeadd(startdate, 1, "Y"), -1, "D")}}}{else} Enter subscription end-date: {formdate: YYYY-MM-DD; default={time: YYYY-MM-DD; shift=+1M}; name=enddate}{endif}{fullterm=datetimediff(startdate, enddate, "D")}{prorationperiod=datetimediff(prorationdate, enddate, "D")}{if: datetimediff(startdate, prorationdate, "D")<0}{error: Partial refund date must be after the service start date; block=yes}{elseif: datetimediff(prorationdate, enddate, "D")<0}{error: End date of partial refund must be after the partial refund date; block=yes}{else}{note: trim=left} The prorated refund amount is {endnote}{=(fullamount/fullterm)*prorationperiod; format=$.2f}{endif}
_
