Compare two sheets based on lastrow with highlighted cells

[abdo meghari]

Hi,
I have two sheets contains data and every time the last row will change in location so what I want compare amount in lastrow for column F in INVOICE sheet with amount in lastrow for column E in ACCOUNT sheet .if the amount in last row in ACCOUNT sheet bigger than amount in last row in INVOICE sheet then will highlighted by red and write the difference for adjacent cell by plus or deficit and amount , and if it's matched the amounts between two sheets then will highlighted yellow and write matched .
will show result for both sheets in last amount in last column .
example:

COMPARE.xlsm
	B	C	D	E	F
21	ITEM	BRAND	QTY	PRICE	BALANCE
22	1	VEGA 70A R KOR	4.00	500.00	2,000.00
23	2	VEGA 55A R KOR	2.00	425.00	850.00
24	3	LARGEST 60A L HIGH JAP	2.00	440.00	880.00
25	4	KM 215/65R16 TA31 KOR	4.00	460.00	1,840.00
26	5	265/70R16 ALGERIA	4.00	630.00	2,520.00
27	6	KM 205/65R16 HS63 KOR	4.00	445.00	1,780.00
28	7	GC 385/65R22.5 AT131 CHI	2.00	1,650.00	3,300.00
29	8	KM 265/70R16 KOR	4.00	880.00	3,520.00
30	9	DONGA 66A L KOR	2.00	460.00	920.00
31	10	KM 235/65R17 HP71 KOR	4.00	625.00	2,500.00
32	11	KM 235/55R19 PS71 KOR	4.00	675.00	2,700.00
33	12	DROUB 90A L KOR	1.00	575.00	575.00
34	13	KM 13R22.5 MA11 KOR	2.00	2,550.00	5,100.00
35	TOTAL		39.00		28,485.00
INVOICE

Cell Formulas
Range	Formula
D35,F35	D35	=SUM(D22:D34)
F22:F34	F22	=D22*E22

COMPARE.xlsm
	A	B	C	D	E
1	DATE	INFO	DEBIT	CREDIT	BALANCE
2	01/11/2024	SALES INVOICE NO BSJ2000	2,000.00		2,000.00
3	02/11/2024	SALES INVOICE NO BSJ2001	3,000.00		5,000.00
4	03/11/2024	SALES RETURNS INVOICE NO BSJ789		3,000.00	2,000.00
5	03/11/2024	VOUCHER NO VBGH6788		1,500.00	500.00
6	04/11/2024	SALES INVOICE NO BSJ2003	15,000.00		15,500.00
7	04/11/2024	SALES INVOICE NO BSJ2004	13,000.00		28,500.00
8
9
10
11
12
13
14
15
ACCOUNT

Cell Formulas
Range	Formula
E2	E2	=C2-D2
E3:E7	E3	=E2+C3-D3

result

COMPARE.xlsm
	A	B	C	D	E	F
1	DATE	INFO	DEBIT	CREDIT	BALANCE
2	01/11/2024	SALES INVOICE NO BSJ2000	2,000.00		2,000.00
3	02/11/2024	SALES INVOICE NO BSJ2001	3,000.00		5,000.00
4	03/11/2024	SALES RETURNS INVOICE NO BSJ789		3,000.00	2,000.00
5	03/11/2024	VOUCHER NO VBGH6788		1,500.00	500.00
6	04/11/2024	SALES INVOICE NO BSJ2003	15,000.00		15,500.00
7	04/11/2024	SALES INVOICE NO BSJ2004	13,000.00		28,500.00	PLUS 15.00
8
9
10
11
12
13
14
15
ACCOUNT

Cell Formulas
Range	Formula
E2	E2	=C2-D2
E3:E7	E3	=E2+C3-D3

COMPARE.xlsm
	B	C	D	E	F	G
21	ITEM	BRAND	QTY	PRICE	BALANCE
22	1	VEGA 70A R KOR	4.00	500.00	2,000.00
23	2	VEGA 55A R KOR	2.00	425.00	850.00
24	3	LARGEST 60A L HIGH JAP	2.00	440.00	880.00
25	4	KM 215/65R16 TA31 KOR	4.00	460.00	1,840.00
26	5	265/70R16 ALGERIA	4.00	630.00	2,520.00
27	6	KM 205/65R16 HS63 KOR	4.00	445.00	1,780.00
28	7	GC 385/65R22.5 AT131 CHI	2.00	1,650.00	3,300.00
29	8	KM 265/70R16 KOR	4.00	880.00	3,520.00
30	9	DONGA 66A L KOR	2.00	460.00	920.00
31	10	KM 235/65R17 HP71 KOR	4.00	625.00	2,500.00
32	11	KM 235/55R19 PS71 KOR	4.00	675.00	2,700.00
33	12	DROUB 90A L KOR	1.00	575.00	575.00
34	13	KM 13R22.5 MA11 KOR	2.00	2,550.00	5,100.00
35	TOTAL		39.00		28,485.00	DEFICIT -15.00
INVOICE

Cell Formulas
Range	Formula
D35,F35	D35	=SUM(D22:D34)
F22:F34	F22	=D22*E22

another example

COMPARE.xlsm
	B	C	D	E	F
21	ITEM	BRAND	QTY	PRICE	BALANCE
22	1	VEGA 70A R KOR	4.00	500.00	2,000.00
23	2	VEGA 55A R KOR	2.00	425.00	850.00
24	3	LARGEST 60A L HIGH JAP	2.00	440.00	880.00
25	4	KM 215/65R16 TA31 KOR	4.00	460.00	1,840.00
26	5	265/70R16 ALGERIA	4.00	630.00	2,520.00
27	6	KM 205/65R16 HS63 KOR	4.00	445.00	1,780.00
28	7	GC 385/65R22.5 AT131 CHI	2.00	1,650.00	3,300.00
29	8	KM 265/70R16 KOR	4.00	880.00	3,520.00
30	9	DONGA 66A L KOR	2.00	460.00	920.00
31	10	KM 235/65R17 HP71 KOR	4.00	625.00	2,500.00
32	11	KM 235/55R19 PS71 KOR	4.00	675.00	2,700.00
33	12	XCV 90A L KOR	1.00	580.00	580.00
34	13	BJS 13R22.5 MA11 KOR	2.00	2,555.00	5,110.00
35	14	KM 13R22.5 MA11 KOR	5.00	2,000.00	10,000.00
36	TOTAL		44.00		38,500.00
INVOICE

Cell Formulas
Range	Formula
D36,F36	D36	=SUM(D22:D35)
F22:F35	F22	=D22*E22

COMPARE.xlsm
	A	B	C	D	E	F
1	DATE	INFO	DEBIT	CREDIT	BALANCE
2	01/11/2024	SALES INVOICE NO BSJ2000	2,000.00		2,000.00
3	02/11/2024	SALES INVOICE NO BSJ2001	3,000.00		5,000.00
4	03/11/2024	SALES RETURNS INVOICE NO BSJ789		3,000.00	2,000.00
5	03/11/2024	VOUCHER NO VBGH6788		1,500.00	500.00
6	04/11/2024	SALES INVOICE NO BSJ2003	15,000.00		15,500.00
7	04/11/2024	SALES INVOICE NO BSJ2004	13,000.00		28,500.00	PLUS 15.00
8	05/11/2024	SALES INVOICE NO BSJ2005	15,000.00		43,500.00
9	05/11/2024	SALES INVOICE NO BSJ2006	1,000.00		44,500.00
10	05/11/2024	VOUCHER NO VBGH6789		1,000.00	43,500.00
11	05/11/2024	VOUCHER NO VBGH6790		5,000.00	38,500.00
12
13
14
15
ACCOUNT

Cell Formulas
Range	Formula
E2	E2	=C2-D2
E3:E11	E3	=E2+C3-D3

result

COMPARE.xlsm
	B	C	D	E	F	G
21	ITEM	BRAND	QTY	PRICE	BALANCE
22	1	VEGA 70A R KOR	4.00	500.00	2,000.00
23	2	VEGA 55A R KOR	2.00	425.00	850.00
24	3	LARGEST 60A L HIGH JAP	2.00	440.00	880.00
25	4	KM 215/65R16 TA31 KOR	4.00	460.00	1,840.00
26	5	265/70R16 ALGERIA	4.00	630.00	2,520.00
27	6	KM 205/65R16 HS63 KOR	4.00	445.00	1,780.00
28	7	GC 385/65R22.5 AT131 CHI	2.00	1,650.00	3,300.00
29	8	KM 265/70R16 KOR	4.00	880.00	3,520.00
30	9	DONGA 66A L KOR	2.00	460.00	920.00
31	10	KM 235/65R17 HP71 KOR	4.00	625.00	2,500.00
32	11	KM 235/55R19 PS71 KOR	4.00	675.00	2,700.00
33	12	XCV 90A L KOR	1.00	580.00	580.00
34	13	BJS 13R22.5 MA11 KOR	2.00	2,555.00	5,110.00
35	14	KM 13R22.5 MA11 KOR	5.00	2,000.00	10,000.00
36	TOTAL		44.00		38,500.00	MATCHED
INVOICE

Cell Formulas
Range	Formula
D36,F36	D36	=SUM(D22:D35)
F22:F35	F22	=D22*E22

COMPARE.xlsm
	A	B	C	D	E	F
1	DATE	INFO	DEBIT	CREDIT	BALANCE
2	01/11/2024	SALES INVOICE NO BSJ2000	2,000.00		2,000.00
3	02/11/2024	SALES INVOICE NO BSJ2001	3,000.00		5,000.00
4	03/11/2024	SALES RETURNS INVOICE NO BSJ789		3,000.00	2,000.00
5	03/11/2024	VOUCHER NO VBGH6788		1,500.00	500.00
6	04/11/2024	SALES INVOICE NO BSJ2003	15,000.00		15,500.00
7	04/11/2024	SALES INVOICE NO BSJ2004	13,000.00		28,500.00	PLUS 15.00
8	05/11/2024	SALES INVOICE NO BSJ2005	15,000.00		43,500.00
9	05/11/2024	SALES INVOICE NO BSJ2006	1,000.00		44,500.00
10	05/11/2024	VOUCHER NO VBGH6789		1,000.00	43,500.00
11	05/11/2024	VOUCHER NO VBGH6790		5,000.00	38,500.00	MATCHED
12
13
14
15
ACCOUNT

Cell Formulas
Range	Formula
E2	E2	=C2-D2
E3:E11	E3	=E2+C3-D3

Last example

COMPARE.xlsm
	B	C	D	E	F
21	ITEM	BRAND	QTY	PRICE	BALANCE
22	1	BJS 13R22.5 MA11 KOR	10.00	2,555.00	25,550.00
23	2	KM 13R22.5 MA11 KOR	12.00	2,000.00	24,000.00
24	TOTAL		22.00		49,550.00
INVOICE

Cell Formulas
Range	Formula
D24,F24	D24	=SUM(D22:D23)
F22:F23	F22	=D22*E22

COMPARE.xlsm
	A	B	C	D	E	F
1	DATE	INFO	DEBIT	CREDIT	BALANCE
2	01/11/2024	SALES INVOICE NO BSJ2000	2,000.00		2,000.00
3	02/11/2024	SALES INVOICE NO BSJ2001	3,000.00		5,000.00
4	03/11/2024	SALES RETURNS INVOICE NO BSJ789		3,000.00	2,000.00
5	03/11/2024	VOUCHER NO VBGH6788		1,500.00	500.00
6	04/11/2024	SALES INVOICE NO BSJ2003	15,000.00		15,500.00
7	04/11/2024	SALES INVOICE NO BSJ2004	13,000.00		28,500.00	PLUS 15.00
8	05/11/2024	SALES INVOICE NO BSJ2005	15,000.00		43,500.00
9	05/11/2024	SALES INVOICE NO BSJ2006	1,000.00		44,500.00
10	05/11/2024	VOUCHER NO VBGH6789		1,000.00	43,500.00
11	05/11/2024	VOUCHER NO VBGH6790		5,000.00	38,500.00	MATCHED
12	05/11/2024	SALES INVOICE NO BSJ2007	2,000.00		40,500.00
13	05/11/2024	SALES INVOICE NO BSJ2008	3,000.00		43,500.00
14	05/11/2024	SALES INVOICE NO BSJ2009	5,000.00		48,500.00
15
ACCOUNT

Cell Formulas
Range	Formula
E2	E2	=C2-D2
E3:E14	E3	=E2+C3-D3

result

COMPARE.xlsm
	B	C	D	E	F	G
21	ITEM	BRAND	QTY	PRICE	BALANCE
22	1	BJS 13R22.5 MA11 KOR	10.00	2,555.00	25,550.00
23	2	KM 13R22.5 MA11 KOR	12.00	2,000.00	24,000.00
24	TOTAL		22.00		49,550.00	PLUS 1,050.00
INVOICE

Cell Formulas
Range	Formula
D24,F24	D24	=SUM(D22:D23)
F22:F23	F22	=D22*E22

COMPARE.xlsm
	A	B	C	D	E	F	G
1	DATE	INFO	DEBIT	CREDIT	BALANCE
2	01/11/2024	SALES INVOICE NO BSJ2000	2,000.00		2,000.00
3	02/11/2024	SALES INVOICE NO BSJ2001	3,000.00		5,000.00
4	03/11/2024	SALES RETURNS INVOICE NO BSJ789		3,000.00	2,000.00
5	03/11/2024	VOUCHER NO VBGH6788		1,500.00	500.00
6	04/11/2024	SALES INVOICE NO BSJ2003	15,000.00		15,500.00
7	04/11/2024	SALES INVOICE NO BSJ2004	13,000.00		28,500.00	PLUS 15.00
8	05/11/2024	SALES INVOICE NO BSJ2005	15,000.00		43,500.00
9	05/11/2024	SALES INVOICE NO BSJ2006	1,000.00		44,500.00
10	05/11/2024	VOUCHER NO VBGH6789		1,000.00	43,500.00
11	05/11/2024	VOUCHER NO VBGH6790		5,000.00	38,500.00	MATCHED
12	05/11/2024	SALES INVOICE NO BSJ2007	2,000.00		40,500.00
13	05/11/2024	SALES INVOICE NO BSJ2008	3,000.00		43,500.00
14	05/11/2024	SALES INVOICE NO BSJ2009	5,000.00		48,500.00	DEFICIT -1,050.00
15
ACCOUNT

Cell Formulas
Range	Formula
E2	E2	=C2-D2
E3:E14	E3	=E2+C3-D3

 

[abdo meghari]

COMPARE.xlsm
	B	C	D	E	F	G
21	ITEM	BRAND	QTY	PRICE	BALANCE
22	1	BJS 13R22.5 MA11 KOR	10	2555	25550
23	2	KM 14R22.5 MA11 KOR	12	2000	24000
24	3	KM 15R22.5 MA11 KOR	10	1000	10000
25	4	KM 16R22.5 MA11 KOR	10	1000	10000
26	TOTAL		32		69550	PLUS -34003
INVOICE

Cell Formulas
Range	Formula
D26	D26	=SUM(D22:D24)
F22:F25	F22	=D22*E22
F26	F26	=SUM(F22:F25)

 

[mumps]

Using the values 48,500.00 and 69550 in these two sheets, the difference is 21050 not 1,050 or 34003.

 

[abdo meghari]

I will check again and comeback later .

 

[abdo meghari]

Using the values 48,500.00 and 69550 in these two sheets, the difference is 21050 not 1,050 or 34003.

I changed value manually to test it.
but what about this?!

COMPARE.xlsm
	B	C	D	E	F	G
21	ITEM	BRAND	QTY	PRICE	BALANCE
22	1	BJS 13R22.5 MA11 KOR	10	2555	25550
23	2	KM 14R22.5 MA11 KOR	12	2000	24000
24	3	KM 15R22.5 MA11 KOR	10	1000	10000
25	4	KM 16R22.5 MA11 KOR	10	1000	10000
26	5	KM 16R22.5 MA11 KOR	20	2500	50000
27	TOTAL		32		119550	PLUS -52126
INVOICE

Cell Formulas
Range	Formula
D27	D27	=SUM(D22:D24)
F22:F26	F22	=D22*E22
F27	F27	=SUM(F22:F26)

COMPARE.xlsm
	A	B	C	D	E	F
1	DATE	INFO	DEBIT	CREDIT	BALANCE
2	01/11/2024	SALES INVOICE NO BSJ2000	2,000.00		2,000.00
3	02/11/2024	SALES INVOICE NO BSJ2001	3,000.00		5,000.00
4	03/11/2024	SALES RETURNS INVOICE NO BSJ789		3,000.00	2,000.00
5	03/11/2024	VOUCHER NO VBGH6788		1,500.00	500.00
6	04/11/2024	SALES INVOICE NO BSJ2003	15,000.00		15,500.00
7	04/11/2024	SALES INVOICE NO BSJ2004	13,000.00		28,500.00	DEFICIT -41050
8	05/11/2024	SALES INVOICE NO BSJ2005	13,001.00		41,501.00
9	06/11/2024	SALES INVOICE NO BSJ2006	13,002.00		54,503.00
10	07/11/2024	SALES INVOICE NO BSJ2007	13,003.00		67,506.00
11	08/11/2024	SALES INVOICE NO BSJ2008	13,004.00		80,510.00
12	09/11/2024	SALES INVOICE NO BSJ2009	13,005.00		93,515.00
13	10/11/2024	SALES INVOICE NO BSJ2010	13,006.00		106,521.00
14	11/11/2024	SALES INVOICE NO BSJ2011	13,029.00		119,550.00	MATCHED
15	12/11/2024	SALES INVOICE NO BSJ2012	13,030.00		132,580.00
16	13/11/2024	SALES INVOICE NO BSJ2013	13,031.00		145,611.00
17	14/11/2024	SALES INVOICE NO BSJ2014	13,032.00		158,643.00
18	15/11/2024	SALES INVOICE NO BSJ2015	13,033.00		171,676.00	DEFICIT 52126
ACCOUNT

Cell Formulas
Range	Formula
E2	E2	=C2-D2
E3:E18	E3	=E2+C3-D3

in ACCOUNT sheet should be PLUS 52126 and in INVOICE sheet should be DEFICIT- 52126

 

[mumps]

This works for me:'

Sub CompareValues()
    Application.ScreenUpdating = False
    Dim invWS As Worksheet, accWS As Worksheet, lRowInv As Long, lRowAcc As Long
    Set invWS = Sheets("INVOICE")
    Set accWS = Sheets("ACCOUNT")
    lRowInv = invWS.Range("F" & Rows.Count).End(xlUp).Row
    lRowAcc = accWS.Range("E" & Rows.Count).End(xlUp).Row
    If accWS.Range("E" & lRowAcc).Value > invWS.Range("F" & lRowInv).Value Or accWS.Range("E" & lRowAcc).Value < invWS.Range("F" & lRowInv).Value Then
        accWS.Range("E" & lRowAcc).Interior.ColorIndex = 3
        accWS.Range("F" & lRowAcc) = "DEFICIT " & accWS.Range("E" & lRowAcc).Value - invWS.Range("F" & lRowInv).Value
        invWS.Range("F" & lRowInv).Interior.ColorIndex = 3
        invWS.Range("G" & lRowInv).Value = "PLUS " & invWS.Range("F" & lRowInv).Value - accWS.Range("E" & lRowAcc).Value
    ElseIf accWS.Range("E" & lRowAcc).Value = invWS.Range("F" & lRowInv).Value Then
        accWS.Range("E" & lRowAcc).Interior.ColorIndex = 6
        accWS.Range("F" & lRowAcc) = "MATCHED "
        invWS.Range("F" & lRowInv).Interior.ColorIndex = 6
        invWS.Range("G" & lRowInv) = "MATCHED"
    End If
    Application.ScreenUpdating = True
End Sub

 

[abdo meghari]

in this case here is my file
maybe find out something
Dropbox

 

[mumps]

The macro worked properly with your file as well.

 

[abdo meghari]

so you want to say the values are saved in my file change to right like plus DEFICIT 52126 in ACCOUNT sheet ,DEFICIT -52126 in INVOICE sheet ?

 

[mumps]

Yes. This is what I got when I ran the macro.

COMPARE.xlsm
	A	B	C	D	E	F
1	DATE	INFO	DEBIT	CREDIT	BALANCE
2	2024-11-01	SALES INVOICE NO BSJ2000	2,000.00		2,000.00
3	2024-11-02	SALES INVOICE NO BSJ2001	3,000.00		5,000.00
4	2024-11-03	SALES RETURNS INVOICE NO BSJ789		3,000.00	2,000.00
5	2024-11-03	VOUCHER NO VBGH6788		1,500.00	500.00
6	2024-11-04	SALES INVOICE NO BSJ2003	15,000.00		15,500.00
7	2024-11-04	SALES INVOICE NO BSJ2004	13,000.00		28,500.00	DEFICIT -41050
8	2024-11-05	SALES INVOICE NO BSJ2005	13,001.00		41,501.00
9	2024-11-06	SALES INVOICE NO BSJ2006	13,002.00		54,503.00
10	2024-11-07	SALES INVOICE NO BSJ2007	13,003.00		67,506.00
11	2024-11-08	SALES INVOICE NO BSJ2008	13,004.00		80,510.00
12	2024-11-09	SALES INVOICE NO BSJ2009	13,005.00		93,515.00
13	2024-11-10	SALES INVOICE NO BSJ2010	13,006.00		106,521.00
14	2024-11-11	SALES INVOICE NO BSJ2011	13,029.00		119,550.00	MATCHED
15	2024-11-12	SALES INVOICE NO BSJ2012	13,030.00		132,580.00
16	2024-11-13	SALES INVOICE NO BSJ2013	13,031.00		145,611.00
17	2024-11-14	SALES INVOICE NO BSJ2014	13,032.00		158,643.00
18	2024-11-15	SALES INVOICE NO BSJ2015	13,033.00		171,676.00	DEFICIT 52126
ACCOUNT

Cell Formulas
Range	Formula
E2	E2	=C2-D2
E3:E18	E3	=E2+C3-D3

COMPARE.xlsm
	B	C	D	E	F	G
21	ITEM	BRAND	QTY	PRICE	BALANCE
22	1	BJS 13R22.5 MA11 KOR	10	2555	25550
23	2	KM 14R22.5 MA11 KOR	12	2000	24000
24	3	KM 15R22.5 MA11 KOR	10	1000	10000
25	4	KM 16R22.5 MA11 KOR	10	1000	10000
26	5	KM 16R22.5 MA11 KOR	20	2500	50000
27	TOTAL		32		119550	PLUS -52126
INVOICE

Cell Formulas
Range	Formula
D27	D27	=SUM(D22:D24)
F22:F26	F22	=D22*E22
F27	F27	=SUM(F22:F26)

 

[abdo meghari]

this is the same result for me !
may you read well my last post about values and words how should be please?

this is the correct result for both sheets

COMPARE.xlsm
	B	C	D	E	F	G
21	ITEM	BRAND	QTY	PRICE	BALANCE
22	1	BJS 13R22.5 MA11 KOR	10	2555	25550
23	2	KM 14R22.5 MA11 KOR	12	2000	24000
24	3	KM 15R22.5 MA11 KOR	10	1000	10000
25	4	KM 16R22.5 MA11 KOR	10	1000	10000
26	5	KM 16R22.5 MA11 KOR	20	2500	50000
27	TOTAL		32		119550	DEFICIT -52126
INVOICE

Cell Formulas
Range	Formula
D27	D27	=SUM(D22:D24)
F22:F26	F22	=D22*E22
F27	F27	=SUM(F22:F26)

COMPARE.xlsm
	A	B	C	D	E	F
1	DATE	INFO	DEBIT	CREDIT	BALANCE
2	01/11/2024	SALES INVOICE NO BSJ2000	2,000.00		2,000.00
3	02/11/2024	SALES INVOICE NO BSJ2001	3,000.00		5,000.00
4	03/11/2024	SALES RETURNS INVOICE NO BSJ789		3,000.00	2,000.00
5	03/11/2024	VOUCHER NO VBGH6788		1,500.00	500.00
6	04/11/2024	SALES INVOICE NO BSJ2003	15,000.00		15,500.00
7	04/11/2024	SALES INVOICE NO BSJ2004	13,000.00		28,500.00	DEFICIT -41050
8	05/11/2024	SALES INVOICE NO BSJ2005	13,001.00		41,501.00
9	06/11/2024	SALES INVOICE NO BSJ2006	13,002.00		54,503.00
10	07/11/2024	SALES INVOICE NO BSJ2007	13,003.00		67,506.00
11	08/11/2024	SALES INVOICE NO BSJ2008	13,004.00		80,510.00
12	09/11/2024	SALES INVOICE NO BSJ2009	13,005.00		93,515.00
13	10/11/2024	SALES INVOICE NO BSJ2010	13,006.00		106,521.00
14	11/11/2024	SALES INVOICE NO BSJ2011	13,029.00		119,550.00	MATCHED
15	12/11/2024	SALES INVOICE NO BSJ2012	13,030.00		132,580.00
16	13/11/2024	SALES INVOICE NO BSJ2013	13,031.00		145,611.00
17	14/11/2024	SALES INVOICE NO BSJ2014	13,032.00		158,643.00
18	15/11/2024	SALES INVOICE NO BSJ2015	13,033.00		171,676.00	PLUS 52126
ACCOUNT

Cell Formulas
Range	Formula
E2	E2	=C2-D2
E3:E18	E3	=E2+C3-D3