G
Guest
Hi
Can anyone help me to create a spreedsheet that will track payments and late
fees?
Here's the scenario:
A1=begining of month (8-01-05)
A2-12=clients
C=amount paid
D=date paid
I=previous balance
J=late fee (if paid after 10th of the month)
K=balance due
E=monthly payment
Now I would assume that the formulas will be several 2-part formulas
First part: I'm trying to get K(balance due) to find the result of C + J +
I(amount paid + late fee + previos balance) if D(date paid) is greater than
A1 by 10 days.
Second part: K(balance due) also need to reogonize that if none of E(monthly
payment) is paid to add E,J & I. Also J(late fee) need to recognize if
D(date paid) is after the 10th to add $25.
So here's the first scenario: once I type in the name(A2),the amount
paid(C2) and the date(D2), J2 should automatically implement a late fee and
K2 should automatically add C2, I2 & J2 because of D2.
A1=8/01/05
A2=Mr Jones
C2=$200
D2=8/11/05
E2=$400
I2=$25
J2=$25
K2=$250
Second scenario: Once I type in the name(A2), the amount paid(C2) and the
date(D2), J2 should automatically implement a late fee and K2 should
automatically add C2, E2, I2 & J2 because of C2's amout and D2.
A1=8/01/05
A2=Mr Jones
C2=$0
D2=8/11/05
E2=$400
I2=$25
J2=$25
K2=$450
I hope I haven't confused anyone it is a CHALLENGE! Pleas help me to do
this in the simpliest form possible. Thanks in advance.
Can anyone help me to create a spreedsheet that will track payments and late
fees?
Here's the scenario:
A1=begining of month (8-01-05)
A2-12=clients
C=amount paid
D=date paid
I=previous balance
J=late fee (if paid after 10th of the month)
K=balance due
E=monthly payment
Now I would assume that the formulas will be several 2-part formulas
First part: I'm trying to get K(balance due) to find the result of C + J +
I(amount paid + late fee + previos balance) if D(date paid) is greater than
A1 by 10 days.
Second part: K(balance due) also need to reogonize that if none of E(monthly
payment) is paid to add E,J & I. Also J(late fee) need to recognize if
D(date paid) is after the 10th to add $25.
So here's the first scenario: once I type in the name(A2),the amount
paid(C2) and the date(D2), J2 should automatically implement a late fee and
K2 should automatically add C2, I2 & J2 because of D2.
A1=8/01/05
A2=Mr Jones
C2=$200
D2=8/11/05
E2=$400
I2=$25
J2=$25
K2=$250
Second scenario: Once I type in the name(A2), the amount paid(C2) and the
date(D2), J2 should automatically implement a late fee and K2 should
automatically add C2, E2, I2 & J2 because of C2's amout and D2.
A1=8/01/05
A2=Mr Jones
C2=$0
D2=8/11/05
E2=$400
I2=$25
J2=$25
K2=$450
I hope I haven't confused anyone it is a CHALLENGE! Pleas help me to do
this in the simpliest form possible. Thanks in advance.