Thanks Dx - so just thinking about the fact that a starting balance will complicate the spreadsheet, is it best to set say October's payment against September's spend? As otherwise I'll be showing a credit balance when I didn't have one? Thank you again! Pinny

Also, looking at how Santander (or Giro as they were back then) lay this out, where do I put the starting balance on the spreadsheet please? As it seems to make a difference if I'm not starting from zero? Sorry to bother you with what must seem like perfectly obvious questions. Thanks again Pinny

Dear Dx Thanks very much for this - am just sitting down to do it now. Going through the statements, not all of them say anywhere what the interest rate is per month or per year. Presumably where it states a monthly rate, I add all the months together for that year to get to the annual rate? How do I work it out where no info is given - would I for instance take a starting balance of £1661.79, take away the payment of £384 to give an outstanding balance of £1277.79 and then work out that the £19 in interest is a monthly interst rate of 1.49% so making the annual rate 17.84%? Thanks again Pinny

Hello CAG I'd be so grateful if anyone could look at the spreadsheet and advise whether I've worked out the interest correctly? Santander have made me an offer. Now I've got the breakdown, if I agree with their methodology, I get to about the same figure. While I'd love to hold out for the compound interest am not sure that I'll get it and talking to the Ombudsman it can take 2 years for them even to look at whether the redress has been correctly calculated, quite apart from the fact that they don't seem to support compound interest. I don't have time/money to go to court at the moment and badly need the funds in my account right now. Are there any other arguments I can use that would be accepted by the bank and supported by the Ombudsman? Thank you so much for any help. Pinny