<#assign month = statement.trandate?string["MMM yyyy"]> <#assign total0 = 0> <#assign total1 = 0> <#assign total2 = 0> <#assign total3 = 0> <#assign totalold = 0> <#assign calcmonth = statement.trandate?string["M"]> <#assign calcmonthnum = calcmonth?number> <#assign calcyear = statement.trandate?string["yyyy"]> <#assign calcyearnum = calcyear?number> <#assign calcmonthnum1 = calcmonthnum - 1> <#if calcmonthnum1 = 0> <#assign strmonth1 = "Dec"> <#assign calcmonthnum1 = 12> <#assign calcyearnum1 = calcyearnum - 1> <#else> <#assign calcyearnum1 = calcyearnum> <#if calcmonthnum1 = 1> <#assign strmonth1 = "Jan"> <#if calcmonthnum1 = 2> <#assign strmonth1 = "Feb"> <#if calcmonthnum1 = 3> <#assign strmonth1 = "Mar"> <#if calcmonthnum1 = 4> <#assign strmonth1 = "Apr"> <#if calcmonthnum1 = 5> <#assign strmonth1 = "May"> <#if calcmonthnum1 = 6> <#assign strmonth1 = "Jun"> <#if calcmonthnum1 = 7> <#assign strmonth1 = "Jul"> <#if calcmonthnum1 = 8> <#assign strmonth1 = "Aug"> <#if calcmonthnum1 = 9> <#assign strmonth1 = "Sep"> <#if calcmonthnum1 = 10> <#assign strmonth1 = "Oct"> <#if calcmonthnum1 = 11> <#assign strmonth1 = "Nov"> <#assign calcmonthnum2 = calcmonthnum1 - 1> <#if calcmonthnum2 = 0> <#assign strmonth2 = "Dec"> <#assign calcmonthnum2 = 12> <#assign calcyearnum2 = calcyearnum1 - 1> <#else> <#assign calcyearnum2 = calcyearnum1> <#if calcmonthnum2 = 1> <#assign strmonth2 = "Jan"> <#if calcmonthnum2 = 2> <#assign strmonth2 = "Feb"> <#if calcmonthnum2 = 3> <#assign strmonth2 = "Mar"> <#if calcmonthnum2 = 4> <#assign strmonth2 = "Apr"> <#if calcmonthnum2 = 5> <#assign strmonth2 = "May"> <#if calcmonthnum2 = 6> <#assign strmonth2 = "Jun"> <#if calcmonthnum2 = 7> <#assign strmonth2 = "Jul"> <#if calcmonthnum2 = 8> <#assign strmonth2 = "Aug"> <#if calcmonthnum2 = 9> <#assign strmonth2 = "Sep"> <#if calcmonthnum2 = 10> <#assign strmonth2 = "Oct"> <#if calcmonthnum2 = 11> <#assign strmonth2 = "Nov"> <#assign calcmonthnum3 = calcmonthnum2 - 1> <#if calcmonthnum3 = 0> <#assign strmonth3 = "Dec"> <#assign calcmonthnum3 = 12> <#assign calcyearnum3 = calcyearnum2 - 1> <#else> <#assign calcyearnum3 = calcyearnum2> <#if calcmonthnum3 = 1> <#assign strmonth3 = "Jan"> <#if calcmonthnum3 = 2> <#assign strmonth3 = "Feb"> <#if calcmonthnum3 = 3> <#assign strmonth3 = "Mar"> <#if calcmonthnum3 = 4> <#assign strmonth3 = "Apr"> <#if calcmonthnum3 = 5> <#assign strmonth3 = "May"> <#if calcmonthnum3 = 6> <#assign strmonth3 = "Jun"> <#if calcmonthnum3 = 7> <#assign strmonth3 = "Jul"> <#if calcmonthnum3 = 8> <#assign strmonth3 = "Aug"> <#if calcmonthnum3 = 9> <#assign strmonth3 = "Sep"> <#if calcmonthnum3 = 10> <#assign strmonth3 = "Oct"> <#if calcmonthnum3 = 11> <#assign strmonth3 = "Nov"> <#list statement.lines as line> <#if line.datecol?length !=0 > <#if line.datecol?string["MMM"] = statement.trandate?string["MMM"] && line.datecol?string["yyyy"] = statement.trandate?string["yyyy"]> <#assign countLineCharge = line.charge?length> <#assign countLineRemaining = line.amountremaining?length> <#if countLineCharge gt 1 && countLineRemaining gt 1> <#assign total0 = total0 + line.amountremaining> <#assign countLinePayment = line.payment?length> <#assign countLineRemaining = line.amountremaining?length> <#if countLinePayment gt 1 && countLineRemaining gt 1> <#assign total0 = total0 - line.amountremaining> <#elseif line.datecol?string["MMM"] = strmonth1 && line.datecol?string["yyyy"] = calcyearnum1?string> <#assign countLineCharge = line.charge?length> <#assign countLineRemaining = line.amountremaining?length> <#if countLineCharge gt 1 && countLineRemaining gt 1> <#assign total1 = total1 + line.amountremaining> <#assign countLinePayment = line.payment?length> <#assign countLineRemaining = line.amountremaining?length> <#if countLinePayment gt 1 && countLineRemaining gt 1> <#assign total1 = total1 - line.amountremaining> <#elseif line.datecol?string["MMM"] = strmonth2 && line.datecol?string["yyyy"] = calcyearnum2?string> <#assign countLineCharge = line.charge?length> <#assign countLineRemaining = line.amountremaining?length> <#if countLineCharge gt 1 && countLineRemaining gt 1> <#assign total2 = total2 + line.amountremaining> <#assign countLinePayment = line.payment?length> <#assign countLineRemaining = line.amountremaining?length> <#if countLinePayment gt 1 && countLineRemaining gt 1> <#assign total2 = total2 - line.amountremaining> <#elseif line.datecol?string["MMM"] = strmonth3 && line.datecol?string["yyyy"] = calcyearnum3?string> <#assign countLineCharge = line.charge?length> <#assign countLineRemaining = line.amountremaining?length> <#if countLineCharge gt 1 && countLineRemaining gt 1> <#assign total3 = total3 + line.amountremaining> <#assign countLinePayment = line.payment?length> <#assign countLineRemaining = line.amountremaining?length> <#if countLinePayment gt 1 && countLineRemaining gt 1> <#assign total3 = total3 - line.amountremaining> <#else> <#assign countLineCharge = line.charge?length> <#assign countLineRemaining = line.amountremaining?length> <#if countLineCharge gt 1 && countLineRemaining gt 1> <#assign totalold = totalold + line.amountremaining> <#assign countLinePayment = line.payment?length> <#assign countLineRemaining = line.amountremaining?length> <#if countLinePayment gt 1 && countLineRemaining gt 1> <#assign totalold = totalold - line.amountremaining>

${month}	${strmonth1} ${calcyearnum1}	${strmonth2} ${calcyearnum2}	${strmonth3} ${calcyearnum3}	Older	Amount Due
${total0?string.currency}	${total1?string.currency}	${total2?string.currency}	${total3?string.currency}	${totalold?string.currency}	${statement.amountDue}