T
Tyler Jones
I am trying to set up a spread sheet that will keep a
running balance of customers that have paid and customers
that have a balance. For instance I have 40 customers
that owe $10.00 or whatever amount at the first of each
month. Some pay for the year, some pay as they are
supposed to, and some I have to track down to get paid. I
want a spread sheet that I can put the amount that is due,
day that it is due, and then the amount that has been
paid. So if they pay for year it calculates 0 balance, or
if they pay monthly and on time when I enter there payment
it keeps running balance and knows next payment is due 1st
of next month and the amount and if they pay late it keeps
running total of how much is due and the months it was due
for. Hope this makes sense and I appreciate any info that
can be given.
running balance of customers that have paid and customers
that have a balance. For instance I have 40 customers
that owe $10.00 or whatever amount at the first of each
month. Some pay for the year, some pay as they are
supposed to, and some I have to track down to get paid. I
want a spread sheet that I can put the amount that is due,
day that it is due, and then the amount that has been
paid. So if they pay for year it calculates 0 balance, or
if they pay monthly and on time when I enter there payment
it keeps running balance and knows next payment is due 1st
of next month and the amount and if they pay late it keeps
running total of how much is due and the months it was due
for. Hope this makes sense and I appreciate any info that
can be given.