Identifying variances in excel

I copied the pivot tables and pasted as values, then ran the macro AlignKeys (available in https://app.box.com/shared/elrnbidnr7) to get this (partial) result:

	A	B	C	D
1	GL Key	amt	VX Key	amt
2			(blank)	82.30
3			CNU-0000004	0.00
4			CNU-0000005	0.00
5			CNU-0000006	0.00
6	CNU-0000007	12.35	CNU-0000007	(12.35)
7			CNU-0000008	0.00
8			CNU-0000009	0.00
9			CNU-0000011	0.00
10			CNU-0000012	0.00
11			CNU-0000013	0.00
12			CNU-0000014	0.00
13			CNU-0000015	0.00
14			CNU-0000016	0.00
15			CNU-0000017	0.00
16	CNU-0000018	36.85	CNU-0000018	(36.85)
17	CNU-0000019	39.17	CNU-0000019	(39.17)
18	CNU-0000020	35.64	CNU-0000020	(35.64)
19			CNU-0000022	0.00
20			CNU-0000023	0.00
21			CNU-0000024	0.00
22			CNU-0000025	0.00
23			CNU-0000026	0.00
24			CNU-0000027	0.00
25			CNU-0000028	0.00
26			CNU-0000030	0.00
27			CNU-0000031	0.00
28			CNU-0000032	0.00
29			CNU-0000034	0.00
30			CNU-0000035	0.00
31	CNU-0000036	85.53	CNU-0000036	(85.53)
32			CNU-0000037	0.00
33	CNU-0000038	22.21	CNU-0000038	(22.21)
34	CNU-0000039	54.10	CNU-0000039	(54.10)
35			CNU-0000040	0.00
36			CNU-0000041	0.00
37	CNU-0000042	40.39	CNU-0000042	0.00
38			CNU-0000045	0.00
39	CNU-0000046	6.44	CNU-0000046	0.00
40			CNU-0000047	0.00
41	CNU-0000048	54.88	CNU-0000048	(54.88)
42			CNU-0000050	0.00
43	CNU-0000051	27.14	CNU-0000051	(27.14)
44			CNU-0000052	0.00
45			CNU-0000053	(171.86)
46	CNU-0000054	45.71	CNU-0000054	(45.71)
47			CNU-0000055	0.00

Does that help?