I have a workbook that I compile every month of o going payments, which have outstanding charges and credits.
The problem that I have is that sometimes folks pay their outstanding balances and sometimes not. Also I may have folks paying off their charges with credits balances.
Since these debits and credits can keep going from month to month I need to figure out a way to keep them ongoing to the current worksheet.
Cell E: Total Charge Persnl Mins
Cell G: Payment Text Mins.
Cell H: Other
Cell I: Roaming Charge
Cell J: Previous Debits
Cell K: Previous Credits
Cell M: Amt. Paying from Credit
Cell N: Amt Paying
Cell Q: Current Debit
Cell R: Crurrent Credit
Cell S: New Balance
I have created the formulas but I am having a problems with the credits and debits. When the credit or debit does carry over to the next month how can it show as a debit and credit?
Please help obviously I thought that the formulas that I had done would work but they are not.
Thank you all for your time and expertise.
I have attached a copy of what I am trying to do.
Bookmarks