I have some challenge that i am having difficulty designing.
I have an organization that wtith membership (of course).
Each member is required to pay on an annual basis $120.00
So, the base annual duess $120.00
Beginning from 2014, each year should have two columns, one shows how much each member has paid his/her $120.00 dues.
The second column (again for each year) should show how much is left.
For instance, 2014, member pays $60.00 on one column and the other column for 2014 shows the remaining $60.00 to be paid.
Even though the year begins in 2014, it span up to 2050.
There are also miscileanous events such as fund raising. This could occur at any year. That even should show how much a member pledged to pay, how much is paid and how much is left to pay.
Eventually, the total paid and the total remaing should show horizontally and then vertically.
John Doe pays $60.00 out of annual dues of $120. Then John Doe pledges to pay $100.00 for fund raising and pays $0.00.
At far right will be a total of $60.00 and total of $160.00 by John Doe.
Then at bottom shows total paid for each year and total owed
Can someone please suggest the best way to design the excel spreadship to accommodate this requirement?
Attached spreadsheet shows sample of what I am trying to accomplish.
Thanks a lot for your assistance.