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 26th June 2006, 15:28   #81 (permalink)
Platinum Account Customer
 
thewifeandI's Avatar
Default Re: Spreadsheet with interest

Quote:
Originally Posted by ROB_5
Cool, only taken 4 days so far !!!!

So just to confirm i'm doing it right ---
Put all of the interest charges one after the other - there shouldn't be any gaps in either list, and there is no need for the charges to align with the interest. You will almost certainly end up with the right hand list being shorter that the lefthand one. That's OK.
thewifeandI is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old 26th June 2006, 15:35   #82 (permalink)
Platinum Account Customer
 
thewifeandI's Avatar
 
Free trial on our eBay auction sniper

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

Quote:
Originally Posted by thewifeandI
Put all of the interest charges one after the other - there shouldn't be any gaps in either list, and there is no need for the charges to align with the interest. You will almost certainly end up with the right hand list being shorter that the lefthand one. That's OK.
When you delete an entry, only delete what's in the blue boxes otherwise you will lose the formula that calculates the amount of interest. Best bet is to open a brand new copy of the spreadsheet in a new window, then copy and paste the blue box entries from left side of the old sheet to the new one - don't copy anything that isn't in a blue box. Once you've done that start entering your interest data into the right side of the new sheet, starting from the first blue row and entering each item on a new line directly below the previous one. Once this is all done save this version of the sheet with a new name and use this one from now on. The old one can be deleted once you have all the data in the new sheet and it has been saved.
__________________
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 26th June 2006, 16:23   #83 (permalink)
Basic Account Customer
Default Re: Spreadsheet with interest

Quote:
Originally Posted by thewifeandI
When you delete an entry, only delete what's in the blue boxes otherwise you will lose the formula that calculates the amount of interest.
Haha Spot on. Done that twice already.

Anyway thanks for your help again. Got to pop out for a bit but i'll post up a bit of what ive done later if you wouldnt mind taking a quick look.

Cheers


Rob
ROB_5 is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old 26th June 2006, 16:51   #84 (permalink)
Basic Account Customer
 
Kai-Boshed's Avatar
 
Have we helped you? Please help us by making a donation

Cagger since : May 2006
Posts: 59
Kai-Boshed Novitiate
Lightbulb Re: Spreadsheet with interest

Hi all,

I'm struggling to figure out how to get around the issue of the blank interest field if my account is in credit at the end of the month!

ie: Period ending 30/03/2001 - Interest charged £17.41 - End Balance £420.60

But the interest field remains blank??!!!



Can anyone give me a deffinative answer to this? I'm getting balder by the minute

Ta very much

Last edited by Kai-Boshed; 18th April 2008 at 12:04.
Kai-Boshed is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old 26th June 2006, 16:59   #85 (permalink)
Platinum Account Customer
 
thewifeandI's Avatar
 
Where else can you earn 8% interest on your money?
Start your County Court claim NOW!!!

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

Quote:
Originally Posted by Kai-Boshed
Hi all,

I'm struggling to figure out how to get around the issue of the blank interest field if my account is in credit at the end of the month!

ie: Period ending 30/03/2001 - Interest charged £17.41 - End Balance £420.60

But the interest field remains blank??!!!



Can anyone give me a deffinative answer to this? I'm getting balder by the minute

Ta very much
I have done this by looking back through the month in question and entering the highest overdrawn balance in that month. If there isn't one, then your interest may be charged a month in arrears (does it say something like 'Interest Debited as Notified' on your statement?), in which case it itsn't the current month but the previous one that you have to look at.
thewifeandI is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old 26th June 2006, 17:02   #86 (permalink)
Basic Account Customer
 
Our auction sniper is now live. Try it for free

Cagger since : Apr 2006
Posts: 81
ROB_5 Novitiate
Default Re: Spreadsheet with interest

Quote:
Originally Posted by thewifeandI
If there isn't one, then your interest may be charged a month in arrears (does it say something like 'Interest Debited as Notified' on your statement?), in which case it itsn't the current month but the previous one that you have to look at.
Bugger !! Time to start again!!!
ROB_5 is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old 26th June 2006, 17:03   #87 (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 ROB_5
Bugger !! Time to start again!!!
Sorry, I don't make the rules...
thewifeandI is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old 26th June 2006, 17:27   #88 (permalink)
Basic Account Customer
 
Kai-Boshed's Avatar
 
Is your bank avoiding its debts
Data disclosure poll

Cagger since : May 2006
Posts: 59
Kai-Boshed Novitiate
Default Re: Spreadsheet with interest

thanks for that....... job done!

Next question........... in the following months I do not appear to have inccured any charges, however I still seem to have paid interest........ but int the interest column, it seems to have stopped working out the total and duplicating the amount instead;

30/01/2001 15.13 -975.80 3.95 02/02/2001 16.67 -1,116.92 3.81 30/03/2001 17.41 -1,116.92 4.60 30/04/2002 0.45 -36.72 0.45 30/05/2002 0.44 -37.16 0.44 01/07/2002 0.43 -37.59 0.43 30/07/2002 0.45 -38.04 0.45
Any Ideas??

Kai-Boshed is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old 26th June 2006, 17:28   #89 (permalink)
Basic Account Customer
 
Kai-Boshed's Avatar
 
Free trial on our eBay auction sniper

Cagger since : May 2006
Posts: 59
Kai-Boshed Novitiate
Default Re: Spreadsheet with interest

oopps lost spreadsheet data....... will try again....... sorry
Kai-Boshed is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old 26th June 2006, 17:30   #90 (permalink)
Basic Account Customer
 
Kai-Boshed's Avatar
 
Try our eBay sniping service

Cagger since : May 2006
Posts: 59
Kai-Boshed Novitiate
Default Re: Spreadsheet with interest

30/01/2001 15.13 -975.80 3.95
02/02/2001 16.67 -1,116.92 3.81
30/03/2001 17.41 -1,116.92 4.60
30/04/2002 0.45 -36.72 0.45
30/05/2002 0.44 -37.16 0.44
01/07/2002 0.43 -37.59 0.43
30/07/2002 0.45 -38.04 0.45
Kai-Boshed is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old 26th June 2006, 17:39   #91 (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 Kai-Boshed
30/01/2001 15.13 -975.80 3.95
02/02/2001 16.67 -1,116.92 3.81
30/03/2001 17.41 -1,116.92 4.60
30/04/2002 0.45 -36.72 0.45
30/05/2002 0.44 -37.16 0.44
01/07/2002 0.43 -37.59 0.43
30/07/2002 0.45 -38.04 0.45
That looks OK. When your overdraft reduced almost all of it would have been due to charges, whereas when there was a far larger overdraft, only a small part was due to charges (if you see what I mean). You can check this by looking at the running total of charges where the charge date is after 30/04/2002 for the first time - this will almost certainly be more than the size of the overdraft (more than £36.72) - if so, all is OK.
thewifeandI is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old 27th June 2006, 13:52   #92 (permalink)
Basic Account Customer
 
Watch out, there are Claims Touts about!

Cagger since : Apr 2006
Posts: 81
ROB_5 Novitiate
Default Re: Spreadsheet with interest

Another prob:





Think im doing it right but, whatever amount i put into the "interset charged" column it transfers it across to the "interest on penalties" column ??

Help !!!
ROB_5 is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old 27th June 2006, 14:00   #93 (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: 141
taylormandy Novitiate
Default Re: Spreadsheet with interest

Hi I also need some help with the spreadsheet. I am filing my moneyclaim today and am having trouble with the 8% interest page as shown here:
00/01/190000/01/19000.000.0000/01/19000.000.0017.02.2000cheque card misuse fee17.50#VALUE!00/01/19000.000.0017.02.2000unpaid direct debit fee25.00#VALUE!00/01/19000.000.0018.02.2000unpaid direct debit fee25.00#VALUE!00/01/19000.000.0029.02.2000unauthorised o/d fee 10.00#VALUE!29.2.20000.00#VALUE!31.3.2000unauthorised o/d fee 10.00#VALUE!31.3.20000.00#VALUE!

Please can you tell me what I am doing wtong. Thank You.
taylormandy is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old 27th June 2006, 14:02   #94 (permalink)
Platinum Account Customer
 
thewifeandI's Avatar
 
Where else can you earn 8% interest on your money?
Start your County Court claim NOW!!!

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

From the first line of interest I would expect to see about 13p being due to charges (£30 out of £90). By 28th Feb, all of the overdraft is due to charges, so the rest looks OK. For the sake of 30p I wouldn't worry about it too much - you can always overwrite the result for the first row with 13p to 'fix' it. I'm not sure why the calculation isn't working though.

You could try highlighting the righthand blue and yellow columns from a blank line lower down and copying it to the top line. Re-enter the values for the top line and see if that fixes the calculation - it might have been corrupted for some reason.
thewifeandI is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old 27th June 2006, 14:04   #95 (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 taylormandy
Hi I also need some help with the spreadsheet. I am filing my moneyclaim today and am having trouble with the 8% interest page as shown here:
00/01/190000/01/19000.000.0000/01/19000.000.0017.02.2000cheque card misuse fee17.50#VALUE!00/01/19000.000.0017.02.2000unpaid direct debit fee25.00#VALUE!00/01/19000.000.0018.02.2000unpaid direct debit fee25.00#VALUE!00/01/19000.000.0029.02.2000unauthorised o/d fee 10.00#VALUE!29.2.20000.00#VALUE!31.3.2000unauthorised o/d fee 10.00#VALUE!31.3.20000.00#VALUE!

Please can you tell me what I am doing wtong. Thank You.
Hi - it looks like the problem is due to the dates not being filled in, although it is very hard to tell from the way it is pasted into your post. All your dates are showing as 00/01/1900 - overwite these with the date the charge came out on your statements.
thewifeandI is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old 27th June 2006, 14:48   #96 (permalink)
Basic Account Customer
 
eBay user? Find misspellings and zero-bid items

Cagger since : Apr 2006
Posts: 81
ROB_5 Novitiate
Default Re: Spreadsheet with interest

Quote:
Originally Posted by thewifeandI
From the first line of interest I would expect to see about 13p being due to charges (£30 out of £90). By 28th Feb, all of the overdraft is due to charges, so the rest looks OK. For the sake of 30p I wouldn't worry about it too much - you can always overwrite the result for the first row with 13p to 'fix' it. I'm not sure why the calculation isn't working though.

You could try highlighting the righthand blue and yellow columns from a blank line lower down and copying it to the top line. Re-enter the values for the top line and see if that fixes the calculation - it might have been corrupted for some reason.
Thanks for reply.

I've noticed that if i do the rows 1 at a time right the way across then the final "interest on penalties" is right (13p on 1st row),, but when i add the next penalty (17 jan - £30) and (25 jan - 35) because the culmalative charges go up, then the "interest on penalties" goes up.

So, the actual charges for Jan were £95. The highest i was overdrawn in Dec (the month previous) was -£90.06.

This sound right?

Rob

Last edited by ROB_5; 27th June 2006 at 14:50.
ROB_5 is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old 27th June 2006, 14:57   #97 (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

Hi Rob, just looked at your sheet again - it's all OK. My fault for not looking hard enough!

The first interest charge is on 31st Jan. By this time you have £95 in charges, more than the overdraft, therefore it is all down to charges. Sorry to have mislead you!
thewifeandI is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old 27th June 2006, 16:11   #98 (permalink)
Basic Account Customer
 
Free trial on our eBay auction sniper

Cagger since : Apr 2006
Posts: 81
ROB_5 Novitiate
Default Re: Spreadsheet with interest

Thanks Jeep.

Ive done 6 months worth and basically all the interest charges are down to the penalties.

Only 40 pages to do

Rob
ROB_5 is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old 27th June 2006, 22:49   #99 (permalink)
Basic Account Customer
Default Re: Spreadsheet with interest

Hi

I have filled out my excel spreadsheet with my charges and dates etc. I have now come to the point where I need to fill out the interest (NOT the 8%). I have been whitling away through my nice stack of Data Protection Act requested bank transactions and putting them into the spreadsheet.

I did a handful then had the niggling feeling I am doing it wrong. Looking at what I am entering goes something like "27/07/2001 charged 1.97 and my balance at that time was -102.32" (not exact or correct format but you get what I am saying).

Whats bothering me is, in one month my bank charges have never put me in the overdraft. The bank is charging me negative interest based on my account being in an agreed overdraft.

The bank gives me interest when i am in credit, so surely they are right to be able to take the same amount for periods when I am in negative credit.

I am unsure if I should be putting these interest payments into the spreadsheet.

What criteria do the interest charges apply in these cases, or do you just put in any negative interest charges, that seems a little unfair to be honest ( but I will gladly claim it back :P )

cheers,
P
Peyote is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old 27th June 2006, 22:57   #100 (permalink)
Platinum Account Customer
 
thewifeandI's Avatar
 
Is your bank avoiding its debts
Data disclosure poll

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

See this thread (especially #4) for an explanation. http://www.consumeractiongroup.co.uk...ment-help.html
thewifeandI 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