Lotto syndicate payment tracker

Hi,
does anyone have a spreadsheet that tracks payments of members and when the next payment is due? I am having difficulty setting one up.
I had columns of Player name, Amount Paid, Date paid and therefore can calculate when payment due. However, I don't know how to keep a revolving balance. I.e. if someone tops up their account, the due date doesn't calculate properly.
Thanks in advance for any help.
Cheers
tammy

can you post an example of what you have, and what your looking to happen?

please remember to desensitize it so that any personal information is not contained.

Hey Tammy,

i know this is an old post but did you get any help with this?? I am after the exact same thing

Jubbs