Spreadsheets
Contents
Spreadsheets
SPREADSHEETS to assist with your claim
If you send the bank a letter before you have given them time to pay up (and are not claiming contractual interest), demanding the statutory interest of 8% APR they will know that you do not know what you are doing and this will more than likely end up with you NOT getting your money back.
YOU SHOULD send a SCHEDULE OF CHARGES with your preliminary and LBA letters. We suggest using the interest calculation spreadsheets, and removing the interest column (if its not for contractual interest) before printing to send.
All charges and dates are ficticious, but here are some spreadsheet templates to help you calculate the interest. Simple versions will calculate the 8% APR only, to be used when filing court claim. Advanced spreadsheets will also help you to calculate the overdraft interest you have been charged by your bank, which you can request at the preliminary stage.
Please choose the spreadsheet relevant to your claim - there are different versions depending on if you are in England or Scotland, which spreadsheet package you use, and also whether you are claiming for a bank account or credit card.
Bank Accounts
England Simple:
England Advanced:
Scotland Simple:
Scotland Advanced:
Credit Cards
England Simple:
England Advanced:
Scotland Simple:
Online Simple Spreadsheet
If you don't have Excel, Works or OpenOffice, or you don't like spreadsheets, there is an easy to use Simple 8% spreadsheet here
You can save the file and go back in x days or months and add new or remove incorrect items as need be. The program will then recalculate the charges and interest which can be printed out or saved.
The program will save any number of files, so it is possible to do one file for each account i.e. credit card or bank account