Small business owner needs help with excel formula

[roqalexander]

For context:

Right now I am a small business owner who uses quickbooks. my customers are set up with monthly payment plans that I manually keep track of. my business has grown so it’s hard to keep track of all these customers at this point.

SO the columns I have are:

customer name,
Amount paid last month
Date of most recent payment
Amount due this month,
invoice due date,
total outstanding balance,


i manually put in the invoice due dates but is there anyway to have them change to the next month automatically if a customer actually pays for the month?

JUST AN Example: Customer X’s Invoice due date is on 4/15/2021 and then IF for example they paid their monthly installment on 4/14/2021 their due date on excel CHANGES to the next due date 5/15/2021 as long as the balance is above 0 dollars aka not paid off.

have no idea if this could be done but boy it would save me a time of time on customer data.

many thanks in advance if this can be done. Like seriously.

 

[Sulprobil]

I suggest to google for
monitor customer payments filetype:xls
or for
accounts payable register filetype:xls
You might want to aim for something which helps you to download your bank statements and to link this to the above.

 

[kweaver]

Without knowing more about the layout you have and/or want, something like this might get you started:

Book4
	A	B	C	D	E	F	G
1	Customer Name	Amount Paid Last Month	Date Of Most Recent Payment	Amount Due This Month	Invoice Due Date	Total Outstanding Balance	Next Due Date
2	AAAA	$1,000.00	4/14/2021	$1,000.00	4/15/2021		5/15/2021
3	BBBB	$500.00	3/20/2021	$500.00	4/20/2021		4/20/2021
Sheet1

Cell Formulas
Range	Formula
G2:G3	G2	=IF(AND(MONTH(C2)=MONTH(E2),C2<=E2),E2+30,E2)