Spreadsheet with interest

[bram stoker]

I have used your spreadsheet for calculation of penalty charges and interest but have noticed when I deleted the unnecessary rows of cells up to row 777 so as not to print them it altered the total of my interest on penalties figure?

It shouldn't do this. I'm not sure what's gone wrong here, but it's been fine for everyone else so far. Can you please try again.?

[bram stoker]

2. Is correct sent list of charges if you want to, but also not necessary.

Although not necessary, it is very much advised as the banks are more than likely to request this.

[speedy]

Hi there.

 

Ive used the basic spreadsheet to work out my interest. I gather i have to replace your figures and dates with mine. My problem is that when i get to the end of what you have written the totals dont move down so get replaced. Ive never used a spreadsheet before so what am i doing wrong.

 

Thanks

 

steve

[bram stoker]

You need to insert some lines above the total. When you do, make sure the total includes every cell you wish to add in to the total.

 

If you want to send it to me to check, please do so at [email protected]

 

Good luck.

[pettal]

Hi guys,

 

thanks for ALL ur help so far been a very good read all round and found out the answers to all my questions!

 

BUT! got a problem. I get that I have to take the balance at the time the interest is taken out and if that balance is positive I take the worst overdrawn balance of that month, and I get if I've been charged more than once in a month I only put the interest in once, but I've noticed on my statements (although it dose not say it) that they charge interest in arreas i.e period of 9th april - 9th may I was charged interest in june!!?? I only noticed this because I was'nt charged any interest between 9th april - 9th may even though I was overdrawn, but I was charged interest in june but I was in credit. Dose this mean I have to start again and put in the interest that was charged in june and june's balance or do I just continue putting in the interest charged in the month the unlawful charge was applied?

 

This is getting so confusing, just as I think I've got it something else creeps up:confused: been at it 2 weeks now HELP!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

[thewifeandI]

Hi guys,

 

thanks for ALL ur help so far been a very good read all round and found out the answers to all my questions!

 

BUT! got a problem. I get that I have to take the balance at the time the interest is taken out and if that balance is positive I take the worst overdrawn balance of that month, and I get if I've been charged more than once in a month I only put the interest in once, but I've noticed on my statements (although it dose not say it) that they charge interest in arreas i.e period of 9th april - 9th may I was charged interest in june!!?? I only noticed this because I was'nt charged any interest between 9th april - 9th may even though I was overdrawn, but I was charged interest in june but I was in credit. Dose this mean I have to start again and put in the interest that was charged in june and june's balance or do I just continue putting in the interest charged in the month the unlawful charge was applied?

 

This is getting so confusing, just as I think I've got it something else creeps up:confused: been at it 2 weeks now HELP!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

Hi pettal - I got round this by using the highest overdrawn figure for the month in question.

[pettal]

cool, what about the interest do I put down the interest of the month in question (the month the unlawful penalty was applied) even if no interest was charged??

[thewifeandI]

Only put in an interest debited figure where it occurs - don't leave blank or zero rows - the interest side doesn't have to line up with the charges and will usually end up as a shorter list.

[pettal]

lovely thanks for that! I'm sure u havent seen the last of me!!

[e28bigalbexley]

Sorry but im a carpenter and not used to spreadsheets i am trying to do a sheet for a credit card i have read through previous posts and listed charges in correct cells (left hand side/date order/oldest first) then i open a new s/s in a new window copy and paste just the blue boxes into charges side and start entering interest, thing is most of mine are late charges and a lot of the time i was not over my limit with the card i was just late and i may have had up to £500/600 left on credit,so when i enter the balance the interest does not change i.e. £0.00 at the start and the end thats after 26 entries.

 

I suppose i am asking because its a credit card do i enter the balance as a debit i.e. credit limit £2000................balance £1450.00 ..........amount available.......£550.

 

therefore my balance on the spreadsheet should read -£1450 in the interest collum.

 

thanks

[thewifeandI]

The balance on a credit card would (almost) always be negative, as you owe them money. It would be extremely rare for a card with charges to be in credit.

[marksteps]

So sorry to post but for some reason when i download the spreadsheet, numerous times, i cant get it to work. God knows what im doing wrong. Im hoping that if i supply the info, someone can calculate the interest....

 

19/11/03 £25 late fee

19/11/03 £25 Overlimit fee

 

19/08/04 £25 overlimit fee

19/08/04 £25 late fee

 

20/09/04 £25 late fee

20/09/04 £25 overlimit fee

 

17/12/04 £25 late fee

 

Thank you kindly, i put into the small claims tomorrow...

[bram stoker]

MarkSteps,

 

Send an email to [email protected] and I'll send you the spreadsheet you require.

[marksteps]

email sent.

 

Thank-you

[hatcho]

Hi,

 

Think I am probably just being thick. But if I am trying to get the bank to give me my money back which spread sheet am I using the one with the yellow and turquoise on or the other one.

 

Can anyone enlighten me?

 

Quite confused!!! :o)

[thewifeandI]

You use the coloured one if you are going to reclaim the interest on the bank charges. This one can calculate the interest the bank has charged you on the proportion of the overdraft that is due to charges. It also does the 8% s69 interest that is ONLY claimed when the claim reaches the Moneyclaim stage. The other spreadsheet only does the 8% bit.

 

Both of them obviously add up your charges for you.

[Cola]

Hello,

Sorry newbie here. I have read through the interest posts but am still unsure as to whether I ass the interest when requesting my charges cash back or if I only do so if they do not pay me them back within 14 days?

Thanks for all help, and I will be donating when I DO get my charges back! Looking at about 1500!

Cola

[thewifeandI]

There are a number of elements that make up your claim: -

 

1. Unlawful bank charges.

2. Interest on the portion of the overdraft that is due to accumulated unlawful bank charges.

3. When you raise a court claim you are entitled to claim 8% 's69 Interest' on the value of the claim at this point only.

 

Some people don't bother with the second item as it can be complicated and might not be enough to bother about.

 

 

The coloured spreadsheet will work out all of this for you but you are advised to have a good read through this thread before using it.

[ArthurC]

Can anyone tell me how to calculate the 8% interest from the date I filed in Moneyclaim to the date the bank refunded me my charges and the 8% interest up to when I filed in Moneyclaim? If you try yo use the spreadsheet it will use todays date automatically.

The answer to you question Cola is you can claim the interest back that the bank has charged on any overdrawn balance caused by the charges but you can only charge the 8% interest on the total claim when you file your moneyclaim

[Cola]

Hello!Thanks very much for the prompt reply.Okay, for number 1, I have a list of all the charges made on my account that equal 1500 pounds.

2, I have a ‘free’ overdraft of 250 pounds. I have added up all the interest that has been debited from my account but guessing that will be for me being overdrawn etc as well. I’m guessing if I go through the coloured spreadsheet this will work out this particular interest. Is that correct? If so I can then send off my letter with the correct interest.

For number 3, got ya! That’s only if I go to court… or at least have to threaten to!Cheers, you loves! Told all my friends about this site. I’ve been a silent watcher for a while!

 

.. Oh and cheers also to you Arthur! I see you got a fair whack of interest (good for you!) Was that as you had to file a claim and thus got the 8%too?

[thewifeandI]

You multiply the total of your claim excluding court fees by 0.00022 which will give you a figure of for example 0.352 which is 35 pence. The amount in pence (or £ & p) is put in the claim as the daily rate. It is applicable to the period from the date the claim is filed until it is settled and should be paid to you on top of the basic amount of the claim and court costs.

[thewifeandI]

Hi Cola - Just fill in the righthand turquoise columns of the 'Charges and Interest' sheet with the details of the interest paid. There's loads of info on doing this if you go back to page three of this thread and start reading through from there.

[bram stoker]

Hi Cola - Just fill in the righthand turquoise columns of the 'Charges and Interest' sheet with the details of the interest paid. There's loads of info on doing this if you go back to page three of this thread and start reading through from there.

Hi all. Please remember also that there are notes within the spreadsheet itself.

[m.bentley]

can anyone tell me ? when you fill in the spreadsheet do you include the interest charged for going overdrawn that month i.e. £10.79 as well as the overdraft charges and other charges

[bobinramsey]

Hi I am probably hijacking a thread here and will get told off but......

 

Vampiress and Seminole. I just wanted to thank you publicly for the time and effort that you both went to, to assist me in sorting out my spreadsheet problems. You are both very very very nice people:-)