LOL...i have asked so many questions about this spreadsheet. I have attached it, if it is locked for some reason, the password is "loan". When a payment is made in the data tab, and it is less than the interest accrual account, then it does not report accurately in the report tab under interest paid and principal paid for that payment C and D17 respectively. How do I get that to show accurate reports when payment is not larger than the interest owed on that date of payment. There is an example payment in the monthly report tab now on 1/2/2012.
The formulas in this spreadsheet have now officially become too complicated for me to understand unless I were to spend many hours staring and processing. Overload...reboot...reboot