Making Bills program

[TLS49]

I never made billing on excel before I not sure what to do. that why I need help with this problem I having. I be happy any help or ideas.

BILLS.xlsb
	A	B	C	D	E	F	G
1	DATE		AMOUNT I PAID ON BILL		AMOUNT I OWN ON BILL		LEFT ON THE BILL
2	Tuesday, August 11, 2020		0.00		1,351.00		0.00
BILL 1

BILLS.xlsb
	A	B	C	D	E	F	G
1	DATE		AMOUNT I PAID ON BILL		AMOUNT I OWN ON BILL		LEFT ON THE BILL
2	Tuesday, August 11, 2020		0.00		617.00		0.00
BILL 2

BILLS.xlsb
	A	B	C	D	E	F	G
1	DATE		AMOUNT I PAID ON BILL		AMOUNT I OWN ON BILL		LEFT ON THE BILL
2	Tuesday, August 11, 2020		$0.00		$1,005.00		$0.00
BILL 3

BILLS.xlsb
	A	B	C	D	E	F	G
1	DATE		AMOUNT I PAID ON BILL		AMOUNT I OWN ON BILL		LEFT ON THE BILL
2	Tuesday, August 11, 2020		0.00		167.00		0.00
BILL 4

BILLS.xlsb
	A	B	C
1	DATE		GRAND TOTAL ALL BILLS AFTER PAID
2	Tuesday, August 11, 2020		$0.00
GRAND TOTAL I PAID

Thanks You

Thomas

 

[sykes]

Hi Thomas
Here's one idea:

test.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M
1	Bill details ($)	Initial amount	Date paid	Amount paid	Date paid	Amount paid	Date paid	Amount paid	Date paid	Amount paid	Date paid	Amount paid	Outstanding
2	Electricity	235.98	02-Jan-20	38.20	30-Jan-20	46.30							151.48
3	Water	139.62											139.62
4	Taxes	598.25											598.25
5	Credit card 1	523.22	23-May-19	100.00	24-Jun-19	25.50	23-Aug-19	23.20	22-Nov-19	38.00	23-Feb-20	26.00	310.52
6	Credit card 2	120.01											120.01
7	Credit card 3	362.47											362.47
8	Loan	5000.00	31-Jan-20	220.00	28-Feb-20	220.00	31-Mar-20	220.00	30-Apr-20	220.00	31-May-20	220.00	3900.00
9													0.00
10													0.00
11													0.00
12													0.00
13													0.00
14													0.00
15													0.00
16													0.00
17													0.00
18													0.00
19													0.00
20													0.00
21													0.00
22											Total outstanding		-$5,582.35
Sheet2

Cell Formulas
Range	Formula
M2:M21	M2	=B2-(D2+F2+H2+J2+L2)
M22	M22	=-SUM(M2:M21)

You'd probably need to add more date paid/amount paid columns - if you had large bills, and only paid small amounts each time, but it gives you an idea, perhaps?