consumer forums consumerforums Total Bank Charges Returned : £17,500,569 to 10384 people.

Bank Charges Refunds Survey | 'Buddy' System | Get an email address | Registration Problems | FAQ
The Consumer Forums  

CAG Products - We think that these will help you to make your claim or Reclaim your Right

These sales also help us to keep helping YOU and ensure this site will remain free to use!

Small Claims Kit-- Small Claims Court Guide
**New Edition**
Consumer Action Group envelope labels Last Will & Testament Kit Fight a Motoring Ticket
 
Alternatively you could purchase a CAG email address here, or maybe you'd prefer our address labels here


UPDATE: Consumer Forums ConsumerWiki is now LIVE - click here: ConsumerWiki

Patricia Pearl - Small Claims Procedure - A Practical Guide
An excellent guide for the layperson in how to use the County Court - a must if you are intending to start a claim.
£17.10 + £1 (P&P)

Lawpack - Small Claims Kit
Contains everything you need to sue your bank (or anyone else) including sample forms, instruction manual, templates, and an entire set of court forms in PDF format on CD Rom.
£10.99 + £1 (P&P)

Last Will and Testament Kit
Make a legally valid will without the fuss and expense of a solicitor - includes a full step-by-step guide.
£12.99 + £1 (P&P)

Fight a Motoring Ticket Kit
All the templates and documents that you need to challenge your speeding ticket, parking fine - with advice from one of the UK’s leading motor offence solicitors
£9.99 + £1 (P&P)


Go Back   The Consumer Forums > The Consumer Forums
The Bank Action Group - against unlawful bank charges
> General

  CAG Announcements
 
Welcome Guest
Please register
Registration is free
There are no charges for using any of the facilities of this website.
If this is your first visit, be sure to check out the FAQ. You will have to register before you can post. To start viewing messages, select the forum that you want to visit from the selection below.
You will also have to register to access our template letters and claims forms
registration is free
Are you being threatened over debts more than 6 years old?
This may be unfair
See our new Unfair Trading Guide
eBay buyer?
Buy more cheaply
Win more often
ConsumerSniper.com
Have you been defaulted?
Would you like to clean up your credit file?
Check it out
Ebay buyer?
ConsumerSniper
Free unlimited bids and eBay tools
Have you been defaulted?
Would you like to clean up your credit file?
Check it out
 
 

General Come here to discuss general issues in the unlawful charging by banks debate.
Any general issues about unfair bank charges.

Reply
 
LinkBack Thread Tools
Old 21st June 2006, 16:36   #41 (permalink)
Classic Account Customer
 
BlueRuby's Avatar
 
Have we helped you? Please help us by making a donation

Cagger since : Mar 2006
Posts: 232
BlueRuby Novitiate
Default Re: Spreadsheet with interest

Am I right in thinking that the interest part of the spreadsheet won't work for credit cards? The interest they charge is on the whole balance of course and I can't see how to work out what part of the interest is being applied to the penalty charges.
BlueRuby is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old 21st June 2006, 16:41   #42 (permalink)
Classic Account Customer
 
eBay user? Find misspellings and zero-bid items

Cagger since : May 2006
Posts: 351
Fred_Funk Novitiate
Default Re: Spreadsheet with interest

BlueRuby,

No, you're not. The spreadsheet does work for credit cards and, more to the point, you don't need to work anything out - just fill in the figures and let the spreadsheet do all the hard work for you.

You merely need to input the amounts you have been charged in interest - in the columns on the right - and the spreadsheet will calculate what proportion of this is attributable to unlawful charges.

Hope this helps?!

Fred_Funk
Fred_Funk is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old 21st June 2006, 17:09   #43 (permalink)
Classic Account Customer
 
BlueRuby's Avatar
 
Free trial on our eBay auction sniper

Cagger since : Mar 2006
Posts: 232
BlueRuby Novitiate
Default Re: Spreadsheet with interest

Thanks Fred! I started to worry because it kept giving me the whole amount of the interest charged, ie if Barclaycard charged 13.80 in interest, the spreadsheet put the whole amount in the penalty interest column. But if you say that's OK I'll take your word for it!
BlueRuby is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old 21st June 2006, 19:43   #44 (permalink)
Basic Account Customer
 
We need funds
Please donate something

Cagger since : May 2006
Posts: 3
mumsjustice Novitiate
Default Re: Spreadsheet with interest

Hi there

I am trying to download the spreadsheet but keep getting a page saying "You are not authorized to view this page". I have excel, I use internet explorer, and my security system is Zonealarm. I have tried to go through Opera instead of Internet explorer, but get the message "The object has been blocked" Have also tried to download the open office version but cannot open file.
Please help as I have looked everywhere for an answer but can't find anything. Am getting quite frustrated....

Thank you

Last edited by mumsjustice; 21st June 2006 at 20:27.
mumsjustice is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old 21st June 2006, 22:21   #45 (permalink)
Basic Account Customer
 
Have we helped you? Please help us by making a donation

Cagger since : Jun 2006
Posts: 10
baineth Novitiate
Default Re: Spreadsheet with interest

Hi and thanks for the spreadsheet. Because of the dates my bank uses to apply interest, my account is usually in credit on the date at the end of the period for which interest is 'due', so the 'interest on charges' column comes up as zero. Would it work to use a formula based on the maximum amount by which I was overdrawn during the period to which the interest applies? i.e.

_____________maximum overdrawn amount during period________________ x interest
(maximum overdrawn amount during period - cumulative charges to date)


I think this would give a fair proportion of the interest as it's saying "If you hadn't taken the charges out in the first place, I would have been x% less overdrawn so would have incurred x% less interest".

Also, do I need to provide the bank with an explanation of how I arrived at these figures to show that they are reasonable?

One final (possibly dim!) question - I keep seeing references to a 'step by step guide' but I can't see it listed in the forums, just the template letters. Could someone point me in the right direction please?

I'd be grateful for any advice.
Thanks
Baineth

Last edited by baineth; 21st June 2006 at 22:23.
baineth is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old 22nd June 2006, 00:04   #46 (permalink)
Platinum Account Customer
 
thewifeandI's Avatar
 
eBay user? Find misspellings and zero-bid items

Cagger since : May 2006
Posts: 2,325
thewifeandI InformativethewifeandI Informative
Default Re: Spreadsheet with interest

This sounds like the way I calculated my interest with Halif*x. I used the largest overdrawn figure in the month that the charges referred to (sometimes the same month, other times the month before that). I gave me a suitable figure, but without the computing power (and the original formulae that they use) there's no way we'll reach the same figure that the bank would. But it's close enough for me - I labelled it 'Best Estimate' in my Moneyclaim.

You will find the Step by Step Guide in the FAQ forum here http://www.consumeractiongroup.co.uk...isplay.php?f=5.
__________________
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!
thewifeandI is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old 22nd June 2006, 00:06   #47 (permalink)
Platinum Account Customer
 
thewifeandI's Avatar
 
Have we helped you? Please help us by making a donation

Cagger since : May 2006
Posts: 2,325
thewifeandI InformativethewifeandI Informative
Default Re: Spreadsheet with interest

Quote:
Originally Posted by mumsjustice
Hi there

I am trying to download the spreadsheet but keep getting a page saying "You are not authorized to view this page". I have excel, I use internet explorer, and my security system is Zonealarm. I have tried to go through Opera instead of Internet explorer, but get the message "The object has been blocked" Have also tried to download the open office version but cannot open file.
Please help as I have looked everywhere for an answer but can't find anything. Am getting quite frustrated....

Thank you
It sounds to me that you have some form of attachment blocking turned on - you might be able to disable it temporarily in ZoneAlarm, but I've not used that for a few years, so I can't help to much - sorry.
thewifeandI is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old 22nd June 2006, 08:37   #48 (permalink)
Classic Account Customer
 
Watch out, there are Claims Touts about!

Cagger since : May 2006
Posts: 351
Fred_Funk Novitiate
Default Re: Spreadsheet with interest

BlueRuby,

It's hard to say without being able to see your spreadsheet but it does sound as if you may have got something not quite right.

It's unlikely that, in the first instance, all of the interest you've incurred will be as a result of unlawful charges, though this may well be the case after some time, ie when the total of charges is equal to/more than the figure by which you're overdrawn and on which you are being charged interest.

Assuming you are using Vamp's excellent spreadsheet, you need to enter any interest you have been charged on the right-hand side in Column H. The spreadsheet should then calculate how much of this interest is attributable to unlawful charges in Column P.

Are you with me now?!

Fred_Funk
__________________
NatWest: seeking unlawful charges + interest incurred as a result of those charges of £4,292.82 and contractual interest (compounded) of £4,559.41. Court claim issued 16.01.08; acknowledgement of service filled by Cobbetts on 30.01.08
Fred_Funk is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old 22nd June 2006, 09:25   #49 (permalink)
Basic Account Customer
 
Our auction sniper is now live. Try it for free

Cagger since : Jun 2006
Posts: 10
baineth Novitiate
Default Re: Spreadsheet with interest

I'll see if I can explain by way of an example:

The bank charged me interest for the period 05/04/01 - 03/05/01 of 0.35.
During this period, the maximum amount of my overdraft was 55.23.
BUT 14.50 of that was charges from the previous month (the first month I had any charges), so if they hadn't imposed any charges, my overdraft would only have been 40.73.

The instructions on the spreadsheet say put the account balance for working out interest at the last day of the interest charging period i.e. 03/05/01 in this case. At that point, my account was in credit by 200.00+ so the spreadsheet shows zero for 'interest on penalties'.

What I want to do (and apologies - I got the fraction upside down before) is work out roughly what the interest on the 'legitimate' overdraft of 40.73 would be and reclaim anything over that as 'interest on penalties'. So my calculation is:

40.73 _ x 0.35 = 0.26 (this is the interest they should have charged)
55.23

In this case I can reclaim 0.09p interest that was charged on the illegal charges. (I know these figures are small but I picked the earliest example for simplicity and it soon adds up over the years)

In some later months, I would not have been overdrawn at all if they hadn't taken charges from my account for the previous month. Using this way of working it out would allow me to reclaim the whole amount of interest charged in those months.

Hope this is clear - it's not easy to explain at a distance!
Baineth
baineth is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old 22nd June 2006, 11:09   #50 (permalink)
Platinum Account Customer
 
thewifeandI's Avatar
 
Our auction sniper is now live. Try it for free

Cagger since : May 2006
Posts: 2,325
thewifeandI InformativethewifeandI Informative
Default Re: Spreadsheet with interest

Quote:
Originally Posted by baineth
I'll see if I can explain by way of an example:

The bank charged me interest for the period 05/04/01 - 03/05/01 of 0.35.
During this period, the maximum amount of my overdraft was 55.23.
BUT 14.50 of that was charges from the previous month (the first month I had any charges), so if they hadn't imposed any charges, my overdraft would only have been 40.73.

The instructions on the spreadsheet say put the account balance for working out interest at the last day of the interest charging period i.e. 03/05/01 in this case. At that point, my account was in credit by 200.00+ so the spreadsheet shows zero for 'interest on penalties'.

What I want to do (and apologies - I got the fraction upside down before) is work out roughly what the interest on the 'legitimate' overdraft of 40.73 would be and reclaim anything over that as 'interest on penalties'. So my calculation is:

40.73 _ x 0.35 = 0.26 (this is the interest they should have charged)
55.23

In this case I can reclaim 0.09p interest that was charged on the illegal charges. (I know these figures are small but I picked the earliest example for simplicity and it soon adds up over the years)

In some later months, I would not have been overdrawn at all if they hadn't taken charges from my account for the previous month. Using this way of working it out would allow me to reclaim the whole amount of interest charged in those months.

Hope this is clear - it's not easy to explain at a distance!
Baineth
As I said before, this is exactly the way I calculated my interest, so I'm agreeing with you!

The only trap to watch out for is where they use the 'Interest as previously notified' line - this is where they calculate the interest for May at the end of May and don't charge it until the end of June - at least Halif*x do it. In this case you need to go back to May to look for the lowest balance there. This might not be the case with your bank though.
thewifeandI is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old 22nd June 2006, 20:13   #51 (permalink)
Basic Account Customer
 
Your bank owes you an awful lot more money than you realise See here

Cagger since : Jun 2006
Posts: 5
trigger99 Novitiate
Smile Re: Spreadsheet with interest

Hello!

Thanks for the very helpful spreadsheet, started off my claim nicely.
Forgive any bad etiquette this is my first time!

When filing in the column for interest charged, do I include the interest charged ONLY on months when bank charges are made? There was one amazing year in six when they did not charge me bank charges (but they did interest!). Do I leave this period of interest charged out of the spreadsheet?

Thanks again,

Trigger.
trigger99 is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old 22nd June 2006, 21:34   #52 (permalink)
Basic Account Customer
 
Free trial on our eBay auction sniper

Cagger since : May 2006
Posts: 7
Lizbrind Novitiate
Default Re: Spreadsheet with interest

Hi,

I have been using this extremely helpful spreadsheet but had one query on the interest charges calculated using Vamp's enhancements.

This thread has answered a few queries I had already, but one outstanding question I have is related to how it handles the interest in a month when charges were levied on multiple days in the month. If the interest figures are entered on each charge then the sheet calculates a refund of interest each time. i.e. Charges on 3 different days equates to counting the interest as owed back 3 times.

Am I right in thinking this isn't right and I should just enter the interest figures against the last charge of the month?

Thanks!
Lizbrind is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old 23rd June 2006, 00:03   #53 (permalink)
Platinum Account Customer
 
thewifeandI's Avatar
 
eBay user? Find misspellings and zero-bid items

Cagger since : May 2006
Posts: 2,325
thewifeandI InformativethewifeandI Informative
Default Re: Spreadsheet with interest

Quote:
Originally Posted by trigger99
Hello!

Thanks for the very helpful spreadsheet, started off my claim nicely.
Forgive any bad etiquette this is my first time!

When filing in the column for interest charged, do I include the interest charged ONLY on months when bank charges are made? There was one amazing year in six when they did not charge me bank charges (but they did interest!). Do I leave this period of interest charged out of the spreadsheet?

Thanks again,

Trigger.
Still include the interest - it could be caused at least in part by the fact that your balance was lower than it would have been if previous charges hadn't been deducted - the spreadsheet will work out what percentage is due to charges.
thewifeandI is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old 23rd June 2006, 00:07   #54 (permalink)
Platinum Account Customer
 
thewifeandI's Avatar
 
We need funds
Please donate something

Cagger since : May 2006
Posts: 2,325
thewifeandI InformativethewifeandI Informative
Default Re: Spreadsheet with interest

Quote:
Originally Posted by Lizbrind
Hi,

I have been using this extremely helpful spreadsheet but had one query on the interest charges calculated using Vamp's enhancements.

This thread has answered a few queries I had already, but one outstanding question I have is related to how it handles the interest in a month when charges were levied on multiple days in the month. If the interest figures are entered on each charge then the sheet calculates a refund of interest each time. i.e. Charges on 3 different days equates to counting the interest as owed back 3 times.

Am I right in thinking this isn't right and I should just enter the interest figures against the last charge of the month?

Thanks!
If I understand what you are asking here correctly, then all you need to do is enter the interest debited from your account along with the date it was debited and the relevant balance at that time (or the lowest value for that month if it was in credit on that date).
thewifeandI is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old 23rd June 2006, 10:13   #55 (permalink)
Basic Account Customer
 
Watch out, there are Claims Touts about!

Cagger since : May 2006
Posts: 7
Lizbrind Novitiate
Default Re: Spreadsheet with interest

Quote:
Originally Posted by thewifeandI
If I understand what you are asking here correctly, then all you need to do is enter the interest debited from your account along with the date it was debited and the relevant balance at that time (or the lowest value for that month if it was in credit on that date).
It's more a case of how the sheet works when there are multiple charges in the same month. Take the following example:
- Charges are extorted on the 3rd, 15th and 25th March.
- Interest is applied on 30th April (Halifax). e.g. £6.

The spreadsheet will then have 3 lines for the 3 charges and then be claiming the interest back 3 time. i.e £18 interest claimed back rather than the £6 charged. While we can make the argument that the overdraft wouldn't be there if it wasn't for the charges, I suspect we'd struggle to claim it multiple times.

For now I'm going to go with only entering the interest figures against the last charge of the month.

Or do you think that's the wrong thing to do?
Lizbrind is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old 23rd June 2006, 12:04   #56 (permalink)
Platinum Account Customer
 
thewifeandI's Avatar
 
Try our eBay sniping service

Cagger since : May 2006
Posts: 2,325
thewifeandI InformativethewifeandI Informative
Default Re: Spreadsheet with interest

Quote:
Originally Posted by Lizbrind
It's more a case of how the sheet works when there are multiple charges in the same month. Take the following example:
- Charges are extorted on the 3rd, 15th and 25th March.
- Interest is applied on 30th April (Halifax). e.g. £6.

The spreadsheet will then have 3 lines for the 3 charges and then be claiming the interest back 3 time. i.e £18 interest claimed back rather than the £6 charged. While we can make the argument that the overdraft wouldn't be there if it wasn't for the charges, I suspect we'd struggle to claim it multiple times.

For now I'm going to go with only entering the interest figures against the last charge of the month.

Or do you think that's the wrong thing to do?
I think I know what's going on now...

What you need to do is to put the charges in on the left side of the sheet in date order, oldest first. Then go back through the statements putting in the interest debited in the righthand side of the sheet, but don't try to align it with the relevant charges, just list it down with the date and balance - this lot will (probably) be shorter than the list of charges - it doesn't matter.
thewifeandI is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old 23rd June 2006, 12:31   #57 (permalink)
Basic Account Customer
 
Watch out, there are Claims Touts about!

Cagger since : Jun 2006
Posts: 32
Debt Girl Novitiate
Default Re: Spreadsheet with interest

I'm not sure I've done this correctly. My interest on penalties is £212.19 and my total penalty charges are £2125. Does this look right?

Debt Girl is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old 23rd June 2006, 13:04   #58 (permalink)
Platinum Account Customer
 
thewifeandI's Avatar
 
Your bank owes you an awful lot more money than you realise See here

Cagger since : May 2006
Posts: 2,325
thewifeandI InformativethewifeandI Informative
Default Re: Spreadsheet with interest

Quote:
Originally Posted by Debt Girl
I'm not sure I've done this correctly. My interest on penalties is £212.19 and my total penalty charges are £2125. Does this look right?
Looks OK from here.
thewifeandI is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old 23rd June 2006, 13:50   #59 (permalink)
Basic Account Customer
 
Where else can you earn 8% interest on your money?
Start your County Court claim NOW!!!

Cagger since : Jun 2006
Posts: 32
Debt Girl Novitiate
Default Re: Spreadsheet with interest

^ thanks so much - just needed to make sure
Debt Girl is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old 23rd June 2006, 14:02   #60 (permalink)
Basic Account Customer
 
Our auction sniper is now live. Try it for free

Cagger since : May 2006
Posts: 14
happymummy Novitiate
Default Re: Spreadsheet with interest

Can anyone help? I cant get the template to open, just keeps coming up with file format invalid. I dont have a clue what I'm doing!!

I'm not claiming any interest back as I dont have an OD, but I can charge them 8% on what they've charged me is that right?
happymummy is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools


Similar Threads
Thread Thread Starter The Consumer Forums Replies Last Post
Spreadsheet/Interest Sally_RF Welcome to the Consumer Forums 4 11th April 2007 21:41
Interest Spreadsheet Amy1471 First Direct 2 20th March 2007 13:22
Spreadsheet interest tinaandalan General 0 23rd January 2007 09:24
interest and charges spreadsheet??? jemmains Welcome to the Consumer Forums 1 10th October 2006 11:25
interest/spreadsheet help? gem1875 HSBC Bank 4 24th September 2006 22:25






Reclaim the Right Ltd. - reg.05783665 in the UK reg. office:- 923 Finchley Road London NW11 7PE