Index match working but not all information being brought in

[LarryLewis]

I am creating a double entry accounting spreadsheet for my cousins small business. I have most of the sheets done just waiting for some info to finish up. I have input test data so i can see how things are coming throughbut on the yearly roll-up tab i can only get one of the months (Jun) to show up there is data for the month of july but it is not coming into the sheet and i cannot see why it isn't. any help to figure out what is going on would be grestly appreciated. Not worried about anything on the General tab just the rollup.

HillBilly Pops 2023 Ledger.xlsx
	A	B	C	D	E	F
1	Month	Income	Bank Name Checking	Bank Name Creidt Card	Bank Name Savings	Supplies
2	Jan
3	Feb
4	Mar
5	Apr
6	May
7	Jun	$ (3,456.00)	$ 3,956.00	$ (500.00)	$ 500.00	$ -
8	Jul	$ -	$ -	$ -	$ -	$ -
9	Aug
10	Sep
11	Oct
12	Nov
13	Dec
14	Total	$ (3,456.00)	$ 3,956.00	$ (500.00)	$ 500.00	$ -
Yearly Roll Up

Cell Formulas
Range	Formula
B2:B13	B2	=IF(ISNA(SUMIF('General Ledger'!$F$3:$F$100,$A2,INDEX('General Ledger'!$F$3:$AA$100,MATCH($A2,'General Ledger'!$F$3:$F$100,0),2))),"",SUMIF('General Ledger'!$F$3:$F$100,$A2,INDEX('General Ledger'!$F$3:$AA$100,MATCH($A2,'General Ledger'!$F$3:$F$100,0),2)))
C2:C13	C2	=IF(ISNA(SUMIF('General Ledger'!$F$3:$F$100,$A2,INDEX('General Ledger'!$F$3:$AA$100,MATCH($A2,'General Ledger'!$F$3:$F$100,0),3))),"",SUMIF('General Ledger'!$F$3:$F$100,$A2,INDEX('General Ledger'!$F$3:$AA$100,MATCH($A2,'General Ledger'!$F$3:$F$100,0),3)))
D2:D13	D2	=IF(ISNA(SUMIF('General Ledger'!$F$3:$F$100,$A2,INDEX('General Ledger'!$F$3:$AA$100,MATCH($A2,'General Ledger'!$F$3:$F$100,0),4))),"",SUMIF('General Ledger'!$F$3:$F$100,$A2,INDEX('General Ledger'!$F$3:$AA$100,MATCH($A2,'General Ledger'!$F$3:$F$100,0),4)))
E2:E13	E2	=IF(ISNA(SUMIF('General Ledger'!$F$3:$F$100,$A2,INDEX('General Ledger'!$F$3:$AA$100,MATCH($A2,'General Ledger'!$F$3:$F$100,0),5))),"",SUMIF('General Ledger'!$F$3:$F$100,$A2,INDEX('General Ledger'!$F$3:$AA$100,MATCH($A2,'General Ledger'!$F$3:$F$100,0),5)))
F2:F13	F2	=IF(ISNA(SUMIF('General Ledger'!$F$3:$F$100,$A2,INDEX('General Ledger'!$F$3:$AA$100,MATCH($A2,'General Ledger'!$F$3:$F$100,0),6))),"",SUMIF('General Ledger'!$F$3:$F$100,$A2,INDEX('General Ledger'!$F$3:$AA$100,MATCH($A2,'General Ledger'!$F$3:$F$100,0),6)))
B14	B14	=SUBTOTAL(109,[Income])
C14	C14	=SUBTOTAL(109,[Bank Name Checking])
D14	D14	=SUBTOTAL(109,[Bank Name Creidt Card])
E14	E14	=SUBTOTAL(109,[Bank Name Savings])
F14	F14	=SUBTOTAL(109,[Supplies])
Press CTRL+SHIFT+ENTER to enter array formulas.

HillBilly Pops 2023 Ledger.xlsx
	A	B	C	D	E	F	G	H	I	J	K
1	Notes	Date	Account	Debit	Credit	$ -	Income	Bank Name Checking	Bank Name Credit Card	Bank Name Savings	Supplies
2						Total Row	$ (6,912.00)	$ 7,042.00	$ (250.00)	$ 500.00	$ 120.00
3	Opening Balance	6/29/2023	Bank Name Checking	$ 500.00		Jun	$ -	$ 500.00	$ -	$ -	$ -
4			Opening Balance		$ 500.00	Jun	$ -	$ -	$ -	$ -	$ -
5	Opening Balance	6/29/2023	Opening Balance	$ 500.00		Jun	$ -	$ -	$ -	$ -	$ -
6			Bank Name Credit Card		$ 500.00	Jun	$ -	$ -	$ (500.00)	$ -	$ -
7	Opening Balance	6/29/2023	Bank Name Savings	$ 500.00		Jun	$ -	$ -	$ -	$ 500.00	$ -
8			Opening Balance		$ 500.00	Jun	$ -	$ -	$ -	$ -	$ -
9	PayDay	6/30/2023	Bank Name Checking	$ 3,456.00		Jun	$ -	$ 3,456.00	$ -	$ -	$ -
10			Income		$ 3,456.00	Jun	$ (3,456.00)	$ -	$ -	$ -	$ -
11	Purchase Bottles	7/1/2023	Supplies	$ 120.00		Jul	$ -	$ -	$ -	$ -	$ 120.00
12			Bank Name Checking		$ 120.00	Jul	$ -	$ (120.00)	$ -	$ -	$ -
13	Credit Card Payment	7/3/2023	Bank Name Credit Card	$ 250.00		Jul	$ -	$ -	$ 250.00	$ -	$ -
14			Bank Name Checking		$ 250.00	Jul	$ -	$ (250.00)	$ -	$ -	$ -
15	payday	7/15/2023	Bank Name Checking	$ 3,456.00		Jul	$ -	$ 3,456.00	$ -	$ -	$ -
16			Income		$ 3,456.00	Jul	$ (3,456.00)	$ -	$ -	$ -	$ -
General Ledger

Cell Formulas
Range	Formula
F1	F1	=SUBTOTAL(9,D:D)-SUBTOTAL(9,E:E)
G2:K2	G2	=SUM(G3:G3000)
G3:K16	G3	=IF($C3=G$1,$D3-$E3,0)
F3:F10	F3	=IF(C3="","",IF(ISBLANK(B3),TEXT(B2,"MMM"),TEXT(B3,"MMM")))

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
F1:G1	Expression	=$F$1>0	text	NO

Cells with Data Validation
Cell	Allow	Criteria
C3:C16	List	='Table of Categories'!$A$2:$A$100

 

[Peter_SSs]

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[LarryLewis]

I predominantly use office 2019 products across the board

 

[Peter_SSs]

Thanks for updating your details.

I predominantly use office 2019 products across the board

Given that, and the fact that the headings in 'Yearly Roll Up' appear to be in the same order as in 'General Ledger', could you use this?

LarryLewis.xlsm
	F	G	H	I	J	K
1	0	Income	Bank Name Checking	Bank Name Credit Card	Bank Name Savings	Supplies
2	Total Row	-6912	7042	-250	500	120
3	Jun	0	500	0	0	0
4	Jun	0	0	0	0	0
5	Jun	0	0	0	0	0
6	Jun	0	0	-500	0	0
7	Jun	0	0	0	500	0
8	Jun	0	0	0	0	0
9	Jun	0	3456	0	0	0
10	Jun	-3456	0	0	0	0
11	Jul	0	0	0	0	120
12	Jul	0	-120	0	0	0
13	Jul	0	0	250	0	0
14	Jul	0	-250	0	0	0
15	Jul	0	3456	0	0	0
16	Jul	-3456	0	0	0	0
General Ledger

Cell Formulas
Range	Formula
F1	F1	=SUBTOTAL(9,D:D)-SUBTOTAL(9,E:E)
G2:K2	G2	=SUM(G3:G3000)
G3:K16	G3	=IF($C3=G$1,$D3-$E3,0)
F3:F10	F3	=IF(C3="","",IF(ISBLANK(B3),TEXT(B2,"MMM"),TEXT(B3,"MMM")))

LarryLewis.xlsm
	A	B	C	D	E	F
1	Month	Income	Bank Name Checking	Bank Name Creidt Card	Bank Name Savings	Supplies
2	Jan
3	Feb
4	Mar
5	Apr
6	May
7	Jun	-3456	3956	-500	500	0
8	Jul	-3456	3086	250	0	120
9	Aug
10	Sep
11	Oct
12	Nov
13	Dec
Yearly Roll Up

Cell Formulas
Range	Formula
B2:F13	B2	=IF(ISNUMBER(MATCH($A2,'General Ledger'!$F:$F,0)),SUMIF('General Ledger'!$F$3:$F$100,$A2,'General Ledger'!G$3:G$100),"")