My boss want by me the calculation of Cash Credit Bank A/c Interest Calculation Day to Day how much he paid to Bank.In bank statement its show at the end of month,but my boss want day to day detail of interest,any solution in excel and tally format.
14 May 2011
Interest on CC account are charged on daily closing balance by the banks. So u just need to apply the ROI applicable on the closing balance. Make a report in Excel and at the end of the day. just put the closing balance in the sheet from your online banking statement.