Best way to analyze inconsistencies?

[Accountant1000]

I am an accountant. Each month we run a report that shows expenses paid over the last 3 months and where each expense is coded in the general ledger. We have two columns - Vendor and the GL account. We are trying to look for items that need their coding fixed, so we look for inconsistencies between the prior month and current month coding. I am also open to using an AI or other analysis tool, but I don't know where to start. The item in yellow is the problem that we will fix.

 

[StephenCrump]

Welcome to the Forum!

If all expenses for each vendor are to be allocated to the same account, you can identify inconsistencies like this:

	A	B	C
1	Vendor	Account	Problem?
2	A	p
3	B	r	YES
4	D	t
5	D	t
6	A	p
7	B	q	YES
8	D	t
9	C	s
10	A	p
11	C	s
Sheet1

Cell Formulas
Range	Formula
C2:C11	C2	=IF(COUNTIFS(A2:A11,A2:A11,B2:B11,B2:B11)<>COUNTIFS(A2:A11,A2:A11),"YES","")
Dynamic array formulas.