Prepaid accounts need to be recorded from start to end terms. I have tried to solve two of them and showed the formulas in the last picture.

I need help on Monthly amortization, prior amortization, balance at 12/31/2013, additions, amortizations and the balance at 12/31/2014

Thank you for your time and help.

TERM Start End Invoice Amount Monthly Amortization Prior Amortization Balance at 12/31/2013 Balance at Amortization 12/31/2014 Additions 11/30/2013 10/31/2015 69,500.00 S 3,021.74 $ (3,021.74) S 66,478.26 $ S(36,260.87) 30.217.39 8/1/2013 8/1/2014 7/31/2014 7/31/2015 1,000.00 1,000.00 $ 83.33 $ S $ 1,000.00 $ 416.67 583.33 3/11/2014 12/18/2014 12/19/2013 12/18/2014 1,166.67 5,800.00 5/29/2014 5/28/2015 7,600.00 12/26/2013 7/26/2014 7/25/2014 7/25/2015 500.00 750.00 1/1/2014 12/31/2014 4,200.00 3/6/2014 3/6/2013 3/6/2015 3/6/2014 4,670.00 4,670.00 3/7/2014 3/7/2013 3/7/2015 3/7/2014 10,000.00 9,000.00 3/31/2014 3/30/2015 1,500.00 4/1/2014 5/23/2014 4/1/2015 3/31/2015 3,228.00 10,416.00 1/1/2014 12/31/2014 1,000.00 Balance at Balance at Monthly Amortization Prior Amortization 41639 Additions Amortization 42004 =G10/23 -3021.74 =G10+110 0 =-H10*12 =J10+K10+L10 =G14/12 0 0 =G14 =5*H14 =J14+K14-L14