Hi Everyone,

I was wondering if someone could help me. I am managing funds for small group of people for charity. My Excel skills are very basic so I thought I'll post my question here to get some help.

I have 10 members in the group, each member pays small amount of money on weekly basis. I have created 10 different sheets in a workbook to keep a track of funds paid by each member. The funds are then reconciled at the end of each month as total collection from all the members.

However recently one of the member has become bit irregular in payments and some times pays in advance as lump sum or falls behind.

My issue lies that I need to get the results in Balance column accordingly on weekly basis. For example if this member pays one week in advance as lump sum or pays additional funds to cover extra weeks the running balance should show as credit or if this member falls behind week or two then the running balance should be in Debit until the payments are made to bring the balance to nil

I would appreciate if someone could post a formula here that can help me achieve the result as described above.

I hope I am making any sense.

Thank you so much in advance

CrazynWild