interst charges

[davep1270]

hi guys

just a quick question, i recieved my statements friday and need some advice on using the spreadsheet.

heres an example of my statement

 

30 jun 200

fees excess borrowing

2nd may - 4 jun

6 excess days

3.50 per day 21.00

fees

service fee

2nd may - 4 jun

6.00 per period 6.00

 

interest due

interest

2nd may - 4 jun 6.53

 

as you can see theyve gharged me three different times for the same dates.

can i claim all three of them back?

and what category do i put them under in the spreadsheet?

thanks dave p

[davep1270]

me again

shall i just put them down as cleared transactions?

or do i keep the interest charges seperate?

[housls]

can you help - just registered and can't find the spread sheet please help[email protected]

 

hi guys

just a quick question, i recieved my statements friday and need some advice on using the spreadsheet.

heres an example of my statement

 

30 jun 200

fees excess borrowing

2nd may - 4 jun

6 excess days

3.50 per day 21.00

fees

service fee

2nd may - 4 jun

6.00 per period 6.00

 

interest due

interest

2nd may - 4 jun 6.53

 

as you can see theyve gharged me three different times for the same dates.

can i claim all three of them back?

and what category do i put them under in the spreadsheet?

thanks dave p

[elppa]

hi davep1270

i wasn't sure about that either, but i did my using the spreadsheet template from this forum, i have changed it slightly. i broke them all down into more details.

 

1) i have changed the first column to statement number

2) inserted 2 or 3 columns after the first column for od charge, excessive charge, dd charge, etc.

3) added a [sum formula] on the 'amount', so that the 'amount' is the total sum of all the different charges on the same row

 

it shouldn't affect other columns on the sheet, however, if you are not sure, i suggest you to make a copy first before changing anything. once you have done, make sure all the data tested before used.

 

it properly quite complicated and tedious work but it make sense to me. hope it is useful to you.

[davep1270]

can you help - just registered and can't find the spread sheet please help[email protected]

hi houls

go to the bank templates library and click the link for interest calculation spreadsheets. hope this helps

 

davep