ok i have got my dunces hat on here and would be gratful for sum advice from anybody who understands numbers....im trying to work out how to fill in the speadsheet i've got the basic idea but on my list of trans actions there maybe 2 unpaid direct debits then a unpaided stantding order, then 5 or 6 interest charged items i.e.
Type Date Inc Date Applied Charge Amount Trans on amount Aval bal
RC 12/05/06 05/06/06 35.00 96.25 OD
UC 09/05/06 31//05/06 35.00 144.04 38.14
RC 09/05/06 31/05/06 35.00 96.25
Information Commissioner 31/3/06 17/05/06 0.38 1,702.56
UC 10/04/06 04/05/06 35.00 72.02 67.20
UC 03/04/06 26/04/06 35.00 777,75 292.18
Information Commissioner 28/02/06 17/04/06 0.09 2,205.86
Information Commissioner 31/01/06 20/03/06 0.22 1.667.78
Information Commissioner 31/12/05 16/02/06 0.04 1,679.06
Information Commissioner 30/11/05 16/01/06 0.31 2,384.33
RC = RETURNED CHQ. UC= UNPAYED DD Information Commissioner=INTEREST CHARGED
OK the rc's dd's and unpayed standing orders are all in crono order and i understand when the chare was applied to my account, but the interest is all over the place do i list it as they have sent it or do i need to identify which bit of interest is related to whatever charge(if you get my meaning) or should i just addup the charges and forget the interest but add 8% at the end , although the interest over 6 years is probably about £100.
