Jump to content



Spreadsheet with interest


Please note that this topic has not had any new posts for the last 561 days.

If you are trying to post a different story then you should start your own new thread. Posting on this thread is likely to mean that you won't get the help and advice that you need.

If you are trying to post information which is relevant to the story in this thread then please flag it up to the site team and they will allow you to post.

Thank you

Recommended Posts

  • 2 weeks later...
  • Replies 1.6k
  • Created
  • Last Reply

Top Posters In This Topic

You will need to print it out and send a copy each to the court and the bank. The court address should be on the Moneyclaim site - it's in Northampton I believe.

Jeep (The Wife & I)

Halifax joint a/c (£3800 charges + £40 interest on charges over 11 years) - paid in full 23/06/06

Halifax joint a/c new charges £1100 - LBA sent 02/08/06

Halifax 2nd a/c (£1500 charges + £150 interest on charges) - partial payment received 13/07/06 (no s69 interest) - AQ filed 07/08/06 - Court awarded 50% of s69 interest (Bank didn't turn up!)

Halifax Visa (#1) Data Protection Act sent - statements arrived - £350 so far

Halifax Visa (#2) Data Protection Act sent - refunded £170

DONATE - Support this site, it supported you!

Follow the route: FAQs > Template Library > Parachute Account > Bank Forums > Spreadsheet

All advice given in good faith and without prejudice or liability, to be taken at your own risk!

Link to post
Share on other sites

Hi,

Just to get sure I was understanding things right. I doubled check your spreadsheet with the interest calculator from Bank Action Group. When entering a £10 charge incurred on the 31/03/02, BAnk Action Group finds £2.64 interest whereas your spreadsheet find £2.90 (both calculators show the same numbers of days) It's no big deal but I thought you might want to know.

Link to post
Share on other sites
Thankyou - I have found the address and it is northampton and will send it.

 

Do i need to say anything specific in the copy I send to the bank?

 

Thanks again

Put your account number and claim number on it.

Jeep (The Wife & I)

Halifax joint a/c (£3800 charges + £40 interest on charges over 11 years) - paid in full 23/06/06

Halifax joint a/c new charges £1100 - LBA sent 02/08/06

Halifax 2nd a/c (£1500 charges + £150 interest on charges) - partial payment received 13/07/06 (no s69 interest) - AQ filed 07/08/06 - Court awarded 50% of s69 interest (Bank didn't turn up!)

Halifax Visa (#1) Data Protection Act sent - statements arrived - £350 so far

Halifax Visa (#2) Data Protection Act sent - refunded £170

DONATE - Support this site, it supported you!

Follow the route: FAQs > Template Library > Parachute Account > Bank Forums > Spreadsheet

All advice given in good faith and without prejudice or liability, to be taken at your own risk!

Link to post
Share on other sites

Sorry if this has been asked before but I cant see it anywhere. Apparantly it is important to use the correct spreadsheet depending on where you live. I`m in Scotland and the spreadsheet example is different from the google one, so which one do I use. Also the google one has a bit that says "DATE OF JUDGEMENT OR PAYMENT". Do I just leave this bit blank when filing my claim at the sherriff court.

Any advice would be great as I`m tearing my hair out. Thanks

Link to post
Share on other sites

Sorry if this has been stated before , but it has just occoured to me.

If when filling in the intrest side of spreadsheet and your account is in credit, you might be paid intrest on this, Howerver you should get far more intrest than you did due to the charges that were taken from you. Should we not look at a way to get this back also? I think it would definatly be agreable to a judge .But might be too complicated to work out , not impossible though

Tesco Personal Finance Due to File in Court 03/04/07

 

Barclays 13/03/07 Paid in full £1998.78 :D

 

MBNA 10/10/06 Paid in full £1507.69 (inc 751.69 intrest):D

Link to post
Share on other sites

Hi,

I am new to all this and have been reading as many posts as I can, but im even more confused now and probably very very thick!!!

 

Ok, I have clicked on the excel spreadsheet on the first page and got a sheet which was alrady filled in as a sample I assume. Should I be using this sheet or am I missing something and should be using something else? I have all my statements which I got successfully (hurrah, that bit wasnt so hard) and have entered all the o/d fees, excess o/d fees and DD recalls which comes to a tidy amount over the past 4 years. BUT, how do I calculate days since offence and am I supposed to add interest? I thought that was to be added only if it went to court?

 

Sorry for waffling, but I am getting confused now and starting to get a little frustrated.

 

Thanks for bearing with me

 

Clare

Link to post
Share on other sites
Hi,

I am new to all this and have been reading as many posts as I can, but im even more confused now and probably very very thick!!!

 

Ok, I have clicked on the excel spreadsheet on the first page and got a sheet which was alrady filled in as a sample I assume. Should I be using this sheet or am I missing something and should be using something else? I have all my statements which I got successfully (hurrah, that bit wasnt so hard) and have entered all the o/d fees, excess o/d fees and DD recalls which comes to a tidy amount over the past 4 years. BUT, how do I calculate days since offence and am I supposed to add interest? I thought that was to be added only if it went to court?

 

Sorry for waffling, but I am getting confused now and starting to get a little frustrated.

 

Thanks for bearing with me

 

Clare

 

Clare the days actually calculate automatically from the date you enter - have you overtyped the info on the spreadsheet or did you delete/clear the info first? You should always overtype as if you delete you will delete the formulas in the spreadsheet which calculates for you.

 

You only add the 8% stat interest to your claim when you go to court - depending which sheet you are using you may decide to claim upfromt the interest charged on the charges incurred. Lots of people (myself included) are also claiming Contractual interest too which is basically charging the bank for borrowing your money & charging at the rate they would have charged you ... it's your choice!

 

- hope this helps answer your Q ... ?

links to my current claims ...

My claim - Yorkshire Bank Visa

chezt V RBS Mastercard

Chezt v RBS Joint Account

chezt v Abbey Credit Card

 

Settled ...

chezt V Duet Card/Creation Finance

chezt v's Studio Cards

chezt v's Littlewoods Catalogue

 

Next ...

Abbey Joint a/c & Single a/c

Barclaycard (Mine & Hubby's)

Anyone else I can think of ...! :rolleyes:

Link to post
Share on other sites

I have just attempted a different tach. I have made my own spredsheet and entered all my transactions, payments and re calculated the interest they should have charged, omiting the late payment and overlimit fees that they have charged. This has meant that I am now claiming interest from them for all the months I should have been in credit. It seems to me that it is only fair that I should be back into the position I would have been in, had they not aplied these unlawful charges, and if they can charge me 2.2% per month for being in debit then it's only fair that they should pay the same rate to me if they have collected to much money from me.

Creation Financial Services--S.A.R - (Subject Access Request) sent 18 Oct

Statements received 28 Oct

PAR sent 30 Oct for £910 Credited £282 as Good will Offer

LBA sent 28 Dec for £730

N1 filled out, but they phoned and settelled in full 19 Jan:D

GE Capital--S.A.R - (Subject Access Request) sent 18 Oct

Capital One---S.A.R - (Subject Access Request) sent 18 Oct

Great Universal(Littlewoods Shop Direct--S.A.R - (Subject Access Request) sent 18 Oct

PAR sent 19 Jan

 

Nat West--S.A.R - (Subject Access Request) sent 26 Oct

Received 27 Oct

Acknowledgement received 28 Oct

Link to post
Share on other sites
omiting the late payment and overlimit fees that they have charged.

 

Why have you omitted these? You can claim those too! Also, there are spreadsheets in the Vampiress chambers that calculate contractual interest too - there is also a compounded version ..

 

VAMPIRESS'S CHAMBER OF "CONSUMER ACTI...

 

you just have to sign up to google first but it's free.

 

Hope this helps - may be worth compairing the results to your own sheet :)

links to my current claims ...

My claim - Yorkshire Bank Visa

chezt V RBS Mastercard

Chezt v RBS Joint Account

chezt v Abbey Credit Card

 

Settled ...

chezt V Duet Card/Creation Finance

chezt v's Studio Cards

chezt v's Littlewoods Catalogue

 

Next ...

Abbey Joint a/c & Single a/c

Barclaycard (Mine & Hubby's)

Anyone else I can think of ...! :rolleyes:

Link to post
Share on other sites

am I right in saying, that if you claim the contractual interest, from the begining, when it comes to filing the mcol, you do NOT add the statutory interest too? its one or the other? you only add the 8% if you haven't already done the contractual interrest? Has anyone won with the contratual interest? My over limit interest rate is 29% that makes a big difference in interest compared to the 8% rate, infact over £1000.

Link to post
Share on other sites
I have just attempted a different tach. I have made my own spredsheet and entered all my transactions, payments and re calculated the interest they should have charged, omiting the late payment and overlimit fees that they have charged. This has meant that I am now claiming interest from them for all the months I should have been in credit. It seems to me that it is only fair that I should be back into the position I would have been in, had they not aplied these unlawful charges, and if they can charge me 2.2% per month for being in debit then it's only fair that they should pay the same rate to me if they have collected to much money from me.

 

What your doing is actually working with contractual interest rate.

Alliance & leicester:Settled 8/9/06 http://www.consumeractiongroup.co.uk/forum/alliance-leicester-successes/19700-tamadus-l.html?highlight=tamadus

Capital One:Settled 22/9/06 http://www.consumeractiongroup.co.uk/forum/capital-one/16644-tamadus-capital-one.html?highlight=tamadus

MBNA 2 accounts:Settled 22/9/06 http://www.consumeractiongroup.co.uk/forum/other-institutions-successes/13831-tamadus-mbna-i.html?highlight=tamadus

Smile:Settled 15/11/06

Egg Card:S.A.R - (Subject Access Request) sent 2/10/06

GE Money:S.A.R - (Subject Access Request) sent3/8/06 LBA sent 26/9/06

Abbey:ERC prelim sent 14/9/06. LBA sent 2/10/06. Now it's getting interesting so keep watching

Barclaycard:In criminal default watch this space

Lloyds TSB:In criminal default watch this space

 

If my comments have been useful please click the scales and let me know.

Link to post
Share on other sites
am I right in saying, that if you claim the contractual interest, from the begining, when it comes to filing the mcol, you do NOT add the statutory interest too? its one or the other? you only add the 8% if you haven't already done the contractual interrest? Has anyone won with the contratual interest? My over limit interest rate is 29% that makes a big difference in interest compared to the 8% rate, infact over £1000.

 

It's one or the other I'm afraid. If you use contractual interest you cannot claim sec. 69 interest.

 

I work all my claims using contractual interest and have settled 5 claims now :D

Alliance & leicester:Settled 8/9/06 http://www.consumeractiongroup.co.uk/forum/alliance-leicester-successes/19700-tamadus-l.html?highlight=tamadus

Capital One:Settled 22/9/06 http://www.consumeractiongroup.co.uk/forum/capital-one/16644-tamadus-capital-one.html?highlight=tamadus

MBNA 2 accounts:Settled 22/9/06 http://www.consumeractiongroup.co.uk/forum/other-institutions-successes/13831-tamadus-mbna-i.html?highlight=tamadus

Smile:Settled 15/11/06

Egg Card:S.A.R - (Subject Access Request) sent 2/10/06

GE Money:S.A.R - (Subject Access Request) sent3/8/06 LBA sent 26/9/06

Abbey:ERC prelim sent 14/9/06. LBA sent 2/10/06. Now it's getting interesting so keep watching

Barclaycard:In criminal default watch this space

Lloyds TSB:In criminal default watch this space

 

If my comments have been useful please click the scales and let me know.

Link to post
Share on other sites
It's one or the other I'm afraid. If you use contractual interest you cannot claim sec. 69 interest.

 

I work all my claims using contractual interest and have settled 5 claims now :D

 

Thanks for that, when I sent my charges to Natwest first, I used the contractual interest rate, On Friday, I filled in my MCOL against them, but was scared to use the contractual rate, so changed to the sec. 69 interest, would it be too late for me to get intouch with the courts and have it changed?

Link to post
Share on other sites
Thanks for that, when I sent my charges to NatWest first, I used the contractual interest rate, On Friday, I filled in my MCOL against them, but was scared to use the contractual rate, so changed to the sec. 69 interest, would it be too late for me to get intouch with the courts and have it changed?

 

If you filled in moneyclaim on friday (after 4pm) it wont be processed until monday morning at, I think 10am. I did something similar on one claim and phoned them up. If you phone before they issue it they will probably cancel the claim and refund (by cheque) the fee. You can then issue another claim using the contractual interest. Best thing now is phone them first thing monday and if it's not been issued ask about cancelling it.

 

Several people have claimed contractual interest and settled their cases now so I would go for that.

Alliance & leicester:Settled 8/9/06 http://www.consumeractiongroup.co.uk/forum/alliance-leicester-successes/19700-tamadus-l.html?highlight=tamadus

Capital One:Settled 22/9/06 http://www.consumeractiongroup.co.uk/forum/capital-one/16644-tamadus-capital-one.html?highlight=tamadus

MBNA 2 accounts:Settled 22/9/06 http://www.consumeractiongroup.co.uk/forum/other-institutions-successes/13831-tamadus-mbna-i.html?highlight=tamadus

Smile:Settled 15/11/06

Egg Card:S.A.R - (Subject Access Request) sent 2/10/06

GE Money:S.A.R - (Subject Access Request) sent3/8/06 LBA sent 26/9/06

Abbey:ERC prelim sent 14/9/06. LBA sent 2/10/06. Now it's getting interesting so keep watching

Barclaycard:In criminal default watch this space

Lloyds TSB:In criminal default watch this space

 

If my comments have been useful please click the scales and let me know.

Link to post
Share on other sites
Will do thanks very much, it makes a big differnece to my claim!

 

It makes a huge difference, One claim I did was for about £900 in charges over 6 years and about £1500 in interest :)

 

I found the court at Northampton very helpfull when I phoned them about the claim I needed to cancel but you do have to phone before the time they stipulate on the MCOL site. In my case I actually totalled the claim wrongly (had a senile moment) and was claiming too much :rolleyes:

Alliance & leicester:Settled 8/9/06 http://www.consumeractiongroup.co.uk/forum/alliance-leicester-successes/19700-tamadus-l.html?highlight=tamadus

Capital One:Settled 22/9/06 http://www.consumeractiongroup.co.uk/forum/capital-one/16644-tamadus-capital-one.html?highlight=tamadus

MBNA 2 accounts:Settled 22/9/06 http://www.consumeractiongroup.co.uk/forum/other-institutions-successes/13831-tamadus-mbna-i.html?highlight=tamadus

Smile:Settled 15/11/06

Egg Card:S.A.R - (Subject Access Request) sent 2/10/06

GE Money:S.A.R - (Subject Access Request) sent3/8/06 LBA sent 26/9/06

Abbey:ERC prelim sent 14/9/06. LBA sent 2/10/06. Now it's getting interesting so keep watching

Barclaycard:In criminal default watch this space

Lloyds TSB:In criminal default watch this space

 

If my comments have been useful please click the scales and let me know.

Link to post
Share on other sites
Know what you mean, the 8% means £370 interest, the contractual rate means £1534, big big difference!!!!! mmmmm which would I prefer!!!! bet you can't guess!

 

Bet I can lmao :lol:

Alliance & leicester:Settled 8/9/06 http://www.consumeractiongroup.co.uk/forum/alliance-leicester-successes/19700-tamadus-l.html?highlight=tamadus

Capital One:Settled 22/9/06 http://www.consumeractiongroup.co.uk/forum/capital-one/16644-tamadus-capital-one.html?highlight=tamadus

MBNA 2 accounts:Settled 22/9/06 http://www.consumeractiongroup.co.uk/forum/other-institutions-successes/13831-tamadus-mbna-i.html?highlight=tamadus

Smile:Settled 15/11/06

Egg Card:S.A.R - (Subject Access Request) sent 2/10/06

GE Money:S.A.R - (Subject Access Request) sent3/8/06 LBA sent 26/9/06

Abbey:ERC prelim sent 14/9/06. LBA sent 2/10/06. Now it's getting interesting so keep watching

Barclaycard:In criminal default watch this space

Lloyds TSB:In criminal default watch this space

 

If my comments have been useful please click the scales and let me know.

Link to post
Share on other sites

I am just about to send my claim to RBOS but am not sure what I should put as the date of service on the spreadsheet. I am using the excel simple Scotland one. Should I use the date the last charge was incurred (19/02/03), the date the account was closed (27/02/06) or the date I am sending the claim? Thanks

Link to post
Share on other sites
I am just about to send my claim to RBOS but am not sure what I should put as the date of service on the spreadsheet. I am using the excel simple Scotland one. Should I use the date the last charge was incurred (19/02/03), the date the account was closed (27/02/06) or the date I am sending the claim? Thanks

 

The date of service is usually the date the court paperwork is served on them, so use the date you send in the claim.

Alliance & leicester:Settled 8/9/06 http://www.consumeractiongroup.co.uk/forum/alliance-leicester-successes/19700-tamadus-l.html?highlight=tamadus

Capital One:Settled 22/9/06 http://www.consumeractiongroup.co.uk/forum/capital-one/16644-tamadus-capital-one.html?highlight=tamadus

MBNA 2 accounts:Settled 22/9/06 http://www.consumeractiongroup.co.uk/forum/other-institutions-successes/13831-tamadus-mbna-i.html?highlight=tamadus

Smile:Settled 15/11/06

Egg Card:S.A.R - (Subject Access Request) sent 2/10/06

GE Money:S.A.R - (Subject Access Request) sent3/8/06 LBA sent 26/9/06

Abbey:ERC prelim sent 14/9/06. LBA sent 2/10/06. Now it's getting interesting so keep watching

Barclaycard:In criminal default watch this space

Lloyds TSB:In criminal default watch this space

 

If my comments have been useful please click the scales and let me know.

Link to post
Share on other sites
Why have you omitted these? You can claim those too! Also, there are spreadsheets in the Vampiress chambers that calculate contractual interest too - there is also a compounded version ..

 

VAMPIRESS'S CHAMBER OF "CONSUMER ACTI...

 

you just have to sign up to google first but it's free.

 

Hope this helps - may be worth compairing the results to your own sheet :)

 

Sorry Chezt, you seem to have misunderstood my post. What I have done is to recalutate all of the statements as I believe they should have been done, without the late payment fees and overlimit fees, so that I can show exactly what interest I should have been charged without the guess work, and demonstrate to the company, and the courts that I am only seeking to be restored the the position I would have been in if they had not impossed these unlawful charges in the first place. Since this has led to me paying more money to them than I needed to, my account should have been in credit for much of the time, therefore I shall be claiming back interest at the rate they have charged me, ie 29%APR. I believe this is known as contractual interest. I started with VAMPIRESS'S spreedsheet but found the calculation of interest a bit arbitrary. Having said that the difference wasn't great, but mine was slightly better and, I think, easier to demonstrate the accuracy to the court.

Creation Financial Services--S.A.R - (Subject Access Request) sent 18 Oct

Statements received 28 Oct

PAR sent 30 Oct for £910 Credited £282 as Good will Offer

LBA sent 28 Dec for £730

N1 filled out, but they phoned and settelled in full 19 Jan:D

GE Capital--S.A.R - (Subject Access Request) sent 18 Oct

Capital One---S.A.R - (Subject Access Request) sent 18 Oct

Great Universal(Littlewoods Shop Direct--S.A.R - (Subject Access Request) sent 18 Oct

PAR sent 19 Jan

 

Nat West--S.A.R - (Subject Access Request) sent 26 Oct

Received 27 Oct

Acknowledgement received 28 Oct

Link to post
Share on other sites

Please note that this topic has not had any new posts for the last 561 days.

If you are trying to post a different story then you should start your own new thread. Posting on this thread is likely to mean that you won't get the help and advice that you need.

If you are trying to post information which is relevant to the story in this thread then please flag it up to the site team and they will allow you to post.

Thank you

Guest
This topic is now closed to further replies.
  • Recently Browsing   0 Caggers

    No registered users viewing this page.


  • Have we helped you ...?


×
×
  • Create New...