I am trying to set up the amortization schedule for a home loan.

Interest is 2.69% and is calculated daily, charged monthly

loan is 19 years 4 months

payments every fortnight (about 26/year)

I have included the file.

sheet1 actual payments and interest upto end of december.

Sheet 2 calulation test page

Sheet 3 amortization schedule.

I have looked at a few sheets online and don't quite fit.

my schedule (sheet 3) isn't quite meeting the same figures as sheet 1 so I'm wondering where I'm going wrong

**EDIT**

I have uploaded an aditional file.

I got a lot sort but having trouble with consistancies.

formulas not being consistant, rounding not the same....

can someone please have a look at it for me