sleek12
Board Regular
- Joined
- May 3, 2014
- Messages
- 71
- Office Version
- 365
- Platform
- Windows
After the reconciliation was complete, The range gives out as values in both worksheets, values only in first worksheet and values only in second worksheet. (see last portion)
But my area of interest is values in both worksheets. See below.
What i want is Green portion filtered out, and all those values posted as separate worksheets in same workbook.
An example of the one of the values would be as :-
To keep information complete, also refer to :- (I believe XL2BB made a constraint here as info was too large), herewith is portion from dec2021NBK502 bank statement
And also portion from dec2021 Cash book:-
Any help with PQ, Macros, LET, λ is welcome, mine is Office 365 home version on Windows 10 platform.
But my area of interest is values in both worksheets. See below.
UseMasterrecon11 | ||||||||
---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | |||
1 | dec2021CASHBOOK | dec2021NBK502 | BOTH | |||||
2 | Amount | Count Of Credit | Sum Of Credit | Count Of Debit | Sum Of Debit | Frequency difference | ||
3 | 2.50 | - | - | 5 | 12.50 | - 5 | ||
4 | 17.22 | - | - | 1 | 17.22 | - 1 | ||
5 | 30.00 | - | - | 2 | 60.00 | - 2 | ||
6 | 60.00 | - | - | 5 | 300.00 | - 5 | ||
7 | 150.00 | - | - | 2 | 300.00 | - 2 | ||
8 | 300.00 | - | - | 5 | 1,500.00 | - 5 | ||
9 | 720.00 | - | - | 1 | 720.00 | - 1 | ||
10 | 960.00 | - | - | 1 | 960.00 | - 1 | ||
11 | 5,063.00 | - | - | 1 | 5,063.00 | - 1 | ||
12 | 13,000.00 | - | - | 1 | 13,000.00 | - 1 | ||
13 | 14,000.00 | - | - | 1 | 14,000.00 | - 1 | ||
14 | 14,113.00 | - | - | 1 | 14,113.00 | - 1 | ||
15 | 20,000.00 | - | - | 1 | 20,000.00 | - 1 | ||
16 | 23,000.00 | - | - | 1 | 23,000.00 | - 1 | ||
17 | 23,750.00 | 1 | 23,750.00 | 1 | 23,750.00 | - | ||
18 | 30,449.65 | - | - | 1 | 30,449.65 | - 1 | ||
19 | 32,700.00 | 1 | 32,700.00 | - | - | 1 | ||
20 | 40,000.00 | - | - | 1 | 40,000.00 | - 1 | ||
21 | 41,225.00 | - | - | 1 | 41,225.00 | - 1 | ||
22 | 41,276.65 | 1 | 41,276.65 | 1 | 41,276.65 | - | ||
23 | 50,000.00 | 4 | 200,000.00 | 30 | 1,500,000.00 | - 26 | ||
24 | 65,076.65 | - | - | 1 | 65,076.65 | - 1 | ||
25 | 70,000.00 | - | - | 2 | 140,000.00 | - 2 | ||
26 | 71,820.00 | 1 | 71,820.00 | - | - | 1 | ||
27 | 75,000.00 | - | - | 2 | 150,000.00 | - 2 | ||
28 | 80,776.65 | 1 | 80,776.65 | - | - | 1 | ||
29 | 100,000.00 | 3 | 300,000.00 | 4 | 400,000.00 | - 1 | ||
30 | 104,000.00 | - | - | 1 | 104,000.00 | - 1 | ||
31 | 105,000.00 | - | - | 1 | 105,000.00 | - 1 | ||
32 | 110,776.65 | 1 | 110,776.65 | 1 | 110,776.65 | - | ||
33 | 139,729.95 | 1 | 139,729.95 | 1 | 139,729.95 | - | ||
34 | 145,776.65 | 1 | 145,776.65 | 1 | 145,776.65 | - | ||
35 | 150,000.00 | - | - | 5 | 750,000.00 | - 5 | ||
36 | 158,206.60 | 1 | 158,206.60 | 1 | 158,206.60 | - | ||
37 | 164,000.00 | - | - | 1 | 164,000.00 | - 1 | ||
38 | 167,450.00 | 1 | 167,450.00 | 1 | 167,450.00 | - | ||
39 | 200,000.00 | 2 | 400,000.00 | 5 | 1,000,000.00 | - 3 | ||
40 | 200,553.30 | 1 | 200,553.30 | 1 | 200,553.30 | - | ||
41 | 208,800.00 | - | - | 1 | 208,800.00 | - 1 | ||
42 | 213,659.90 | 1 | 213,659.90 | 1 | 213,659.90 | - | ||
43 | 221,553.30 | 1 | 221,553.30 | 1 | 221,553.30 | - | ||
44 | 225,852.00 | - | - | 1 | 225,852.00 | - 1 | ||
45 | 238,803.30 | 1 | 238,803.30 | 1 | 238,803.30 | - | ||
46 | 269,153.30 | 1 | 269,153.30 | 1 | 269,153.30 | - | ||
47 | 269,222.50 | 1 | 269,222.50 | 1 | 269,222.50 | - | ||
48 | 271,183.25 | 1 | 271,183.25 | 1 | 271,183.25 | - | ||
49 | 276,450.00 | - | - | 1 | 276,450.00 | - 1 | ||
50 | 281,403.30 | 1 | 281,403.30 | 1 | 281,403.30 | - | ||
51 | 300,000.00 | - | - | 2 | 600,000.00 | - 2 | ||
52 | 309,883.25 | 1 | 309,883.25 | 1 | 309,883.25 | - | ||
53 | 319,756.65 | 1 | 319,756.65 | 1 | 319,756.65 | - | ||
54 | 350,000.00 | - | - | 8 | 2,800,000.00 | - 8 | ||
55 | 352,994.20 | 1 | 352,994.20 | 1 | 352,994.20 | - | ||
56 | 500,000.00 | 1 | 500,000.00 | 1 | 500,000.00 | - | ||
57 | 770,000.00 | 1 | 770,000.00 | 1 | 770,000.00 | - | ||
58 | 826,576.55 | 1 | 826,576.55 | 1 | 826,576.55 | - | ||
59 | 869,536.27 | 1 | 869,536.27 | 1 | 869,536.27 | - | ||
payments |
Cell Formulas | ||
---|---|---|
Range | Formula | |
A3:A59 | A3 | = VStackλ(NBK.debit, ERP.credit) |
B3:F59 | B3 | = LET( countCredit, COUNTIFS(ERP.credit, amounts), countDebit, COUNTIFS(NBK.debit, amounts), freqDiff, countCredit - countDebit, sumCredit, amounts * countCredit, sumDebit, amounts * countDebit, CHOOSE({1,2,3,4,5}, countCredit, sumCredit,countDebit,sumDebit,freqDiff)) |
Dynamic array formulas. |
Cells with Conditional Formatting | ||||
---|---|---|---|---|
Cell | Condition | Cell Format | Stop If True | |
A3:A1452 | Expression | =$B3*$D3 | text | NO |
A3:A1452 | Expression | =$D3 | text | NO |
A3:A1452 | Expression | =$B3 | text | NO |
What i want is Green portion filtered out, and all those values posted as separate worksheets in same workbook.
UseMasterrecon11 | ||||||||
---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | |||
1 | dec2021CASHBOOK | dec2021NBK502 | BOTH | |||||
17 | 23,750.00 | 1 | 23,750.00 | 1 | 23,750.00 | - | ||
22 | 41,276.65 | 1 | 41,276.65 | 1 | 41,276.65 | - | ||
23 | 50,000.00 | 4 | 200,000.00 | 30 | 1,500,000.00 | - 26 | ||
29 | 100,000.00 | 3 | 300,000.00 | 4 | 400,000.00 | - 1 | ||
32 | 110,776.65 | 1 | 110,776.65 | 1 | 110,776.65 | - | ||
33 | 139,729.95 | 1 | 139,729.95 | 1 | 139,729.95 | - | ||
34 | 145,776.65 | 1 | 145,776.65 | 1 | 145,776.65 | - | ||
36 | 158,206.60 | 1 | 158,206.60 | 1 | 158,206.60 | - | ||
38 | 167,450.00 | 1 | 167,450.00 | 1 | 167,450.00 | - | ||
39 | 200,000.00 | 2 | 400,000.00 | 5 | 1,000,000.00 | - 3 | ||
40 | 200,553.30 | 1 | 200,553.30 | 1 | 200,553.30 | - | ||
42 | 213,659.90 | 1 | 213,659.90 | 1 | 213,659.90 | - | ||
43 | 221,553.30 | 1 | 221,553.30 | 1 | 221,553.30 | - | ||
45 | 238,803.30 | 1 | 238,803.30 | 1 | 238,803.30 | - | ||
46 | 269,153.30 | 1 | 269,153.30 | 1 | 269,153.30 | - | ||
47 | 269,222.50 | 1 | 269,222.50 | 1 | 269,222.50 | - | ||
48 | 271,183.25 | 1 | 271,183.25 | 1 | 271,183.25 | - | ||
50 | 281,403.30 | 1 | 281,403.30 | 1 | 281,403.30 | - | ||
52 | 309,883.25 | 1 | 309,883.25 | 1 | 309,883.25 | - | ||
53 | 319,756.65 | 1 | 319,756.65 | 1 | 319,756.65 | - | ||
55 | 352,994.20 | 1 | 352,994.20 | 1 | 352,994.20 | - | ||
56 | 500,000.00 | 1 | 500,000.00 | 1 | 500,000.00 | - | ||
57 | 770,000.00 | 1 | 770,000.00 | 1 | 770,000.00 | - | ||
58 | 826,576.55 | 1 | 826,576.55 | 1 | 826,576.55 | - | ||
payments |
Cells with Conditional Formatting | ||||
---|---|---|---|---|
Cell | Condition | Cell Format | Stop If True | |
A3:A1452 | Expression | =$B3*$D3 | text | NO |
A3:A1452 | Expression | =$D3 | text | NO |
A3:A1452 | Expression | =$B3 | text | NO |
An example of the one of the values would be as :-
UseMasterrecon11 | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | |||
1 | 50000 | dec2021Cash book | dec2021NBK502 | |||||||
2 | 23/12/2021 | private info | 0 | 0 | 31/12/2021 | Private info | 50000 | |||
3 | 23/12/2021 | private info | 004668 | 0 | 30/12/2021 | Private info | 50000 | |||
4 | 23/12/2021 | private info | 004672 | 0 | 30/12/2021 | Private info | 50000 | |||
5 | 23/12/2021 | private info | 004688 | 0 | 29/12/2021 | Private info | 50000 | |||
6 | 29/12/2021 | Private info | 50000 | |||||||
7 | 29/12/2021 | Private info | 50000 | |||||||
8 | 28/12/2021 | Private info | 50000 | |||||||
9 | 24/12/2021 | Private info | 50000 | |||||||
10 | 23/12/2021 | Private info | 50000 | |||||||
11 | 23/12/2021 | Private info | 50000 | |||||||
12 | 23/12/2021 | Private info | 50000 | |||||||
13 | 23/12/2021 | Private info | 50000 | |||||||
14 | 22/12/2021 | Private info | 50000 | |||||||
15 | 21/12/2021 | Private info | 50000 | |||||||
16 | 20/12/2021 | Private info | 50000 | |||||||
17 | 20/12/2021 | Private info | 50000 | |||||||
18 | 17/12/2021 | Private info | 50000 | |||||||
19 | 16/12/2021 | Private info | 50000 | |||||||
20 | 15/12/2021 | Private info | 50000 | |||||||
21 | 14/12/2021 | Private info | 50000 | |||||||
22 | 14/12/2021 | Private info | 50000 | |||||||
23 | 10/12/2021 | Private info | 50000 | |||||||
24 | 09/12/2021 | Private info | 50000 | |||||||
25 | 08/12/2021 | Private info | 50000 | |||||||
26 | 07/12/2021 | Private info | 50000 | |||||||
27 | 06/12/2021 | Private info | 50000 | |||||||
28 | 06/12/2021 | Private info | 50000 | |||||||
29 | 03/12/2021 | Private info | 50000 | |||||||
30 | 02/12/2021 | Private info | 50000 | |||||||
31 | 01/12/2021 | Private info | 50000 | |||||||
50000 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
A2:D5 | A2 | =FILTER(dec2021COREcashbook!A1:D491,dec2021COREcashbook!E1:E491=A1) |
F2:H31 | F2 | =FILTER(Table1_2[[#All],[Date]:[Debit ]],Table1_2[[#All],[Debit ]]=A1) |
Dynamic array formulas. |
Named Ranges | ||
---|---|---|
Name | Refers To | Cells |
dec2021COREcashbook!_FilterDatabase | =dec2021COREcashbook!$A$1:$F$491 | A2 |
dec2021nbk502!_FilterDatabase | =dec2021nbk502!$A$1:$D$569 | F2 |
ERP.debit | =dec2021COREcashbook!$D$2:$D$491 | A2 |
dec2021nbk502!ExternalData_1 | =dec2021nbk502!$A$1:$D$569 | F2 |
To keep information complete, also refer to :- (I believe XL2BB made a constraint here as info was too large), herewith is portion from dec2021NBK502 bank statement
UseMasterrecon11 | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | Date | Particulars | Debit | Credit | ||
2 | 31/12/2021 | Private info | 17.22 | |||
3 | 31/12/2021 | Private info | 113,000.00 | |||
4 | 31/12/2021 | Private info | 11,498.00 | |||
5 | 31/12/2021 | Private info | 281,403.30 | |||
6 | 31/12/2021 | Private info | 145,776.65 | |||
7 | 31/12/2021 | Private info | 36,734.00 | |||
8 | 31/12/2021 | Private info | 60,000.00 | |||
9 | 31/12/2021 | Private info | 500,000.00 | |||
10 | 31/12/2021 | Private info | 6,064.00 | |||
11 | 31/12/2021 | Private info | 300.00 | |||
12 | 31/12/2021 | Private info | 2.50 | |||
13 | 31/12/2021 | Private info | 60.00 | |||
14 | 31/12/2021 | Private info | 164,000.00 | |||
15 | 31/12/2021 | Private info | 9,732.00 | |||
16 | 31/12/2021 | Private info | 3,550.00 | |||
17 | 31/12/2021 | Private info | 150,000.00 | |||
18 | 31/12/2021 | Private info | 11,671.00 | |||
19 | 31/12/2021 | Private info | 99,751.00 | |||
20 | 31/12/2021 | Private info | 83,000.00 | |||
21 | 31/12/2021 | Private info | 10,500.00 | |||
22 | 31/12/2021 | Private info | 18,084.00 | |||
23 | 31/12/2021 | Private info | 19,000.00 | |||
24 | 31/12/2021 | Private info | 46,000.00 | |||
25 | 31/12/2021 | Private info | 16,000.00 | |||
26 | 31/12/2021 | Private info | 43,087.00 | |||
27 | 31/12/2021 | Private info | 42,302.00 | |||
28 | 31/12/2021 | Private info | 90,054.00 | |||
29 | 31/12/2021 | Private info | 50,000.00 | |||
30 | 31/12/2021 | Private info | 15,000.00 | |||
31 | 31/12/2021 | Private info | 1,200.00 | |||
32 | 31/12/2021 | Private info | 15,000.00 | |||
33 | 31/12/2021 | Private info | 33,143.00 | |||
34 | 31/12/2021 | Private info | 7,187.00 | |||
35 | 31/12/2021 | Private info | 62,467.00 | |||
36 | 31/12/2021 | Private info | 29,600.00 | |||
37 | 31/12/2021 | Private info | 29,600.00 | |||
38 | 31/12/2021 | Private info | 221,553.30 | |||
39 | 31/12/2021 | Private info | 238,803.30 | |||
40 | 31/12/2021 | Private info | 110,776.65 | |||
41 | 31/12/2021 | Private info | 26,922.00 | |||
42 | 31/12/2021 | Private info | 8,949.00 | |||
43 | 31/12/2021 | Private info | 35,953.00 | |||
44 | 31/12/2021 | Private info | 2,100.00 | |||
45 | 31/12/2021 | Private info | 11,000.00 | |||
46 | 31/12/2021 | Private info | 11,000.00 | |||
47 | 31/12/2021 | Private info | 24,691.00 | |||
48 | 31/12/2021 | Private info | 24,691.00 | |||
49 | 31/12/2021 | Private info | 21,210.00 | |||
50 | 31/12/2021 | Private info | 46,297.00 | |||
51 | 31/12/2021 | Private info | 1,659.00 | |||
52 | 31/12/2021 | Private info | 12,008.00 | |||
53 | 31/12/2021 | Private info | 9,033.00 | |||
54 | 31/12/2021 | Private info | 14,023.00 | |||
55 | 31/12/2021 | Private info | 10,251.00 | |||
56 | 31/12/2021 | Private info | 11,055.00 | |||
57 | 31/12/2021 | Private info | 7,101.00 | |||
58 | 31/12/2021 | Private info | 5,116.00 | |||
59 | 31/12/2021 | Private info | 24,385.00 | |||
60 | 31/12/2021 | Private info | 27,594.00 | |||
61 | 31/12/2021 | Private info | 11,367.00 | |||
62 | 31/12/2021 | Private info | 50,000.00 | |||
63 | 31/12/2021 | Private info | 6,860.00 | |||
64 | 31/12/2021 | Private info | 12,324.00 | |||
65 | 31/12/2021 | Private info | 32,567.00 | |||
66 | 31/12/2021 | Private info | 5,100.00 | |||
67 | 31/12/2021 | Private info | 5,670.00 | |||
68 | 31/12/2021 | Private info | 19,690.00 | |||
69 | 31/12/2021 | Private info | 1,300.00 | |||
70 | 31/12/2021 | Private info | 30.00 | |||
71 | 31/12/2021 | Private info | 150.00 | |||
72 | 31/12/2021 | Private info | 39,478.00 | |||
73 | 31/12/2021 | Private info | 30.00 | |||
74 | 31/12/2021 | Private info | 150.00 | |||
75 | 31/12/2021 | Private info | 21,414.00 | |||
76 | 31/12/2021 | Private info | 19,756.00 | |||
77 | 31/12/2021 | Private info | 30,315.00 | |||
78 | 31/12/2021 | Private info | 13,204.00 | |||
79 | 31/12/2021 | Private info | 1,870.00 | |||
80 | 31/12/2021 | Private info | 100,000.00 | |||
81 | 31/12/2021 | Private info | 104,000.00 | |||
82 | 31/12/2021 | Private info | 350,000.00 | |||
83 | 31/12/2021 | Private info | 150,000.00 | |||
84 | 30/12/2021 | Private info | 600,000.00 | |||
85 | 30/12/2021 | Private info | 327,457.00 | |||
86 | 30/12/2021 | Private info | 4,300.00 | |||
87 | 30/12/2021 | Private info | 11,093.00 | |||
88 | 30/12/2021 | Private info | 352,994.20 | |||
89 | 30/12/2021 | Private info | 40,000.00 | |||
90 | 30/12/2021 | Private info | 269,153.30 | |||
91 | 30/12/2021 | Private info | 3,800.00 | |||
92 | 30/12/2021 | Private info | 85,900.00 | |||
93 | 30/12/2021 | Private info | 22,401.00 | |||
94 | 30/12/2021 | Private info | 25,805.00 | |||
95 | 30/12/2021 | Private info | 75,876.00 | |||
96 | 30/12/2021 | Private info | 38,240.00 | |||
97 | 30/12/2021 | Private info | 8,841.00 | |||
98 | 30/12/2021 | Private info | 11,011.00 | |||
99 | 30/12/2021 | Private info | 6,000.00 | |||
100 | 30/12/2021 | Private info | 12,000.00 | |||
101 | 30/12/2021 | Private info | 20,000.00 | |||
102 | 30/12/2021 | Private info | 6,209.00 | |||
103 | 30/12/2021 | Private info | 10,000.00 | |||
104 | 30/12/2021 | Private info | 9,800.00 | |||
105 | 30/12/2021 | Private info | 15,000.00 | |||
106 | 30/12/2021 | Private info | 43,000.00 | |||
107 | 30/12/2021 | Private info | 45,810.00 | |||
108 | 30/12/2021 | Private info | 11,500.00 | |||
109 | 30/12/2021 | Private info | 2,500.00 | |||
110 | 30/12/2021 | Private info | 52,197.00 | |||
111 | 30/12/2021 | Private info | 20,000.00 | |||
112 | 30/12/2021 | Private info | 29,000.00 | |||
113 | 30/12/2021 | Private info | 70,000.00 | |||
114 | 30/12/2021 | Private info | 10,000.00 | |||
115 | 30/12/2021 | Private info | 50,000.00 | |||
116 | 30/12/2021 | Private info | 50,000.00 | |||
117 | 30/12/2021 | Private info | 120,000.00 | |||
118 | 30/12/2021 | Private info | 15,423.00 | |||
119 | 30/12/2021 | Private info | 15,423.00 | |||
120 | 30/12/2021 | Private info | 10,000.00 | |||
121 | 30/12/2021 | Private info | 10,000.00 | |||
122 | 30/12/2021 | Private info | 30,000.00 | |||
123 | 30/12/2021 | Private info | 30,000.00 | |||
124 | 30/12/2021 | Private info | 2,500.00 | |||
125 | 30/12/2021 | Private info | 3,800.00 | |||
126 | 30/12/2021 | Private info | 7,441.00 | |||
127 | 30/12/2021 | Private info | 2,600.00 | |||
128 | 30/12/2021 | Private info | 20,876.00 | |||
129 | 30/12/2021 | Private info | 50,000.00 | |||
130 | 30/12/2021 | Private info | 31,854.00 | |||
131 | 30/12/2021 | Private info | 49,002.00 | |||
132 | 30/12/2021 | Private info | 16,290.00 | |||
133 | 30/12/2021 | Private info | 49,479.00 | |||
134 | 30/12/2021 | Private info | 10,500.00 | |||
135 | 30/12/2021 | Private info | 15,163.00 | |||
136 | 30/12/2021 | Private info | 13,285.00 | |||
137 | 30/12/2021 | Private info | 27,522.00 | |||
138 | 30/12/2021 | Private info | 3,800.00 | |||
139 | 30/12/2021 | Private info | 5,101.00 | |||
140 | 30/12/2021 | Private info | 7,656.00 | |||
141 | 30/12/2021 | Private info | 3,800.00 | |||
142 | 30/12/2021 | Private info | 25,870.00 | |||
143 | 30/12/2021 | Private info | 3,800.00 | |||
144 | 30/12/2021 | Private info | 2,067.00 | |||
145 | 30/12/2021 | Private info | 7,113.00 | |||
146 | 30/12/2021 | Private info | 5,771.00 | |||
147 | 30/12/2021 | Private info | 29,678.00 | |||
148 | 30/12/2021 | Private info | 12,903.00 | |||
149 | 30/12/2021 | Private info | 13,182.00 | |||
150 | 30/12/2021 | Private info | 15,411.00 | |||
151 | 30/12/2021 | Private info | 23,447.00 | |||
152 | 30/12/2021 | Private info | 17,600.00 | |||
153 | 30/12/2021 | Private info | 42,744.00 | |||
154 | 30/12/2021 | Private info | 6,205.00 | |||
155 | 30/12/2021 | Private info | 36,697.00 | |||
156 | 30/12/2021 | Private info | 70,000.00 | |||
157 | 30/12/2021 | Private info | 100,000.00 | |||
158 | 30/12/2021 | Private info | 50,000.00 | |||
159 | 30/12/2021 | Private info | 150,000.00 | |||
160 | 30/12/2021 | Private info | 350,000.00 | |||
161 | 29/12/2021 | Private info | 3,899.00 | |||
162 | 29/12/2021 | Private info | 8,870.00 | |||
163 | 29/12/2021 | Private info | 300.00 | |||
164 | 29/12/2021 | Private info | 2.50 | |||
165 | 29/12/2021 | Private info | 60.00 | |||
166 | 29/12/2021 | Private info | 200,000.00 | |||
167 | 29/12/2021 | Private info | 44,000.00 | |||
168 | 29/12/2021 | Private info | 43,449.00 | |||
169 | 29/12/2021 | Private info | 25,000.00 | |||
170 | 29/12/2021 | Private info | 13,000.00 | |||
171 | 29/12/2021 | Private info | 17,000.00 | |||
172 | 29/12/2021 | Private info | 12,290.00 | |||
173 | 29/12/2021 | Private info | 62,126.00 | |||
174 | 29/12/2021 | Private info | 17,000.00 | |||
175 | 29/12/2021 | Private info | 46,214.00 | |||
176 | 29/12/2021 | Private info | 50,000.00 | |||
177 | 29/12/2021 | Private info | 10,000.00 | |||
178 | 29/12/2021 | Private info | 50,000.00 | |||
179 | 29/12/2021 | Private info | 20,000.00 | |||
180 | 29/12/2021 | Private info | 23,000.00 | |||
181 | 29/12/2021 | Private info | 50,000.00 | |||
182 | 29/12/2021 | Private info | 13,000.00 | |||
183 | 29/12/2021 | Private info | 17,000.00 | |||
184 | 29/12/2021 | Private info | 15,711.00 | |||
185 | 29/12/2021 | Private info | 18,000.00 | |||
186 | 29/12/2021 | Private info | 4,072.00 | |||
187 | 29/12/2021 | Private info | 32,541.00 | |||
188 | 29/12/2021 | Private info | 50,000.00 | |||
189 | 29/12/2021 | Private info | 55,863.00 | |||
190 | 29/12/2021 | Private info | 2,800.00 | |||
191 | 29/12/2021 | Private info | 45,321.00 | |||
192 | 29/12/2021 | Private info | 91,696.00 | |||
193 | 29/12/2021 | Private info | 21,865.00 | |||
194 | 29/12/2021 | Private info | 34,652.00 | |||
195 | 29/12/2021 | Private info | 15,121.00 | |||
196 | 29/12/2021 | Private info | 11,907.00 | |||
197 | 29/12/2021 | Private info | 17,452.00 | |||
198 | 29/12/2021 | Private info | 6,199.00 | |||
199 | 29/12/2021 | Private info | 22,876.00 | |||
200 | 29/12/2021 | Private info | 15,517.00 | |||
dec2021nbk502 |
And also portion from dec2021 Cash book:-
UseMasterrecon11 | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | Date | Particulars | Debit | Credit | ||
2 | 31/12/2021 | Private info | 17.22 | |||
3 | 31/12/2021 | Private info | 113,000.00 | |||
4 | 31/12/2021 | Private info | 11,498.00 | |||
5 | 31/12/2021 | Private info | 281,403.30 | |||
6 | 31/12/2021 | Private info | 145,776.65 | |||
7 | 31/12/2021 | Private info | 36,734.00 | |||
8 | 31/12/2021 | Private info | 60,000.00 | |||
9 | 31/12/2021 | Private info | 500,000.00 | |||
10 | 31/12/2021 | Private info | 6,064.00 | |||
11 | 31/12/2021 | Private info | 300.00 | |||
12 | 31/12/2021 | Private info | 2.50 | |||
13 | 31/12/2021 | Private info | 60.00 | |||
14 | 31/12/2021 | Private info | 164,000.00 | |||
15 | 31/12/2021 | Private info | 9,732.00 | |||
16 | 31/12/2021 | Private info | 3,550.00 | |||
17 | 31/12/2021 | Private info | 150,000.00 | |||
18 | 31/12/2021 | Private info | 11,671.00 | |||
19 | 31/12/2021 | Private info | 99,751.00 | |||
20 | 31/12/2021 | Private info | 83,000.00 | |||
21 | 31/12/2021 | Private info | 10,500.00 | |||
22 | 31/12/2021 | Private info | 18,084.00 | |||
23 | 31/12/2021 | Private info | 19,000.00 | |||
24 | 31/12/2021 | Private info | 46,000.00 | |||
25 | 31/12/2021 | Private info | 16,000.00 | |||
26 | 31/12/2021 | Private info | 43,087.00 | |||
27 | 31/12/2021 | Private info | 42,302.00 | |||
28 | 31/12/2021 | Private info | 90,054.00 | |||
29 | 31/12/2021 | Private info | 50,000.00 | |||
30 | 31/12/2021 | Private info | 15,000.00 | |||
31 | 31/12/2021 | Private info | 1,200.00 | |||
32 | 31/12/2021 | Private info | 15,000.00 | |||
33 | 31/12/2021 | Private info | 33,143.00 | |||
34 | 31/12/2021 | Private info | 7,187.00 | |||
35 | 31/12/2021 | Private info | 62,467.00 | |||
36 | 31/12/2021 | Private info | 29,600.00 | |||
37 | 31/12/2021 | Private info | 29,600.00 | |||
38 | 31/12/2021 | Private info | 221,553.30 | |||
39 | 31/12/2021 | Private info | 238,803.30 | |||
40 | 31/12/2021 | Private info | 110,776.65 | |||
41 | 31/12/2021 | Private info | 26,922.00 | |||
42 | 31/12/2021 | Private info | 8,949.00 | |||
43 | 31/12/2021 | Private info | 35,953.00 | |||
44 | 31/12/2021 | Private info | 2,100.00 | |||
45 | 31/12/2021 | Private info | 11,000.00 | |||
46 | 31/12/2021 | Private info | 11,000.00 | |||
47 | 31/12/2021 | Private info | 24,691.00 | |||
48 | 31/12/2021 | Private info | 24,691.00 | |||
49 | 31/12/2021 | Private info | 21,210.00 | |||
50 | 31/12/2021 | Private info | 46,297.00 | |||
51 | 31/12/2021 | Private info | 1,659.00 | |||
52 | 31/12/2021 | Private info | 12,008.00 | |||
53 | 31/12/2021 | Private info | 9,033.00 | |||
54 | 31/12/2021 | Private info | 14,023.00 | |||
55 | 31/12/2021 | Private info | 10,251.00 | |||
56 | 31/12/2021 | Private info | 11,055.00 | |||
57 | 31/12/2021 | Private info | 7,101.00 | |||
58 | 31/12/2021 | Private info | 5,116.00 | |||
59 | 31/12/2021 | Private info | 24,385.00 | |||
60 | 31/12/2021 | Private info | 27,594.00 | |||
61 | 31/12/2021 | Private info | 11,367.00 | |||
62 | 31/12/2021 | Private info | 50,000.00 | |||
63 | 31/12/2021 | Private info | 6,860.00 | |||
64 | 31/12/2021 | Private info | 12,324.00 | |||
65 | 31/12/2021 | Private info | 32,567.00 | |||
66 | 31/12/2021 | Private info | 5,100.00 | |||
67 | 31/12/2021 | Private info | 5,670.00 | |||
68 | 31/12/2021 | Private info | 19,690.00 | |||
69 | 31/12/2021 | Private info | 1,300.00 | |||
70 | 31/12/2021 | Private info | 30.00 | |||
71 | 31/12/2021 | Private info | 150.00 | |||
72 | 31/12/2021 | Private info | 39,478.00 | |||
73 | 31/12/2021 | Private info | 30.00 | |||
74 | 31/12/2021 | Private info | 150.00 | |||
75 | 31/12/2021 | Private info | 21,414.00 | |||
76 | 31/12/2021 | Private info | 19,756.00 | |||
77 | 31/12/2021 | Private info | 30,315.00 | |||
78 | 31/12/2021 | Private info | 13,204.00 | |||
79 | 31/12/2021 | Private info | 1,870.00 | |||
80 | 31/12/2021 | Private info | 100,000.00 | |||
81 | 31/12/2021 | Private info | 104,000.00 | |||
82 | 31/12/2021 | Private info | 350,000.00 | |||
83 | 31/12/2021 | Private info | 150,000.00 | |||
84 | 30/12/2021 | Private info | 600,000.00 | |||
85 | 30/12/2021 | Private info | 327,457.00 | |||
86 | 30/12/2021 | Private info | 4,300.00 | |||
87 | 30/12/2021 | Private info | 11,093.00 | |||
88 | 30/12/2021 | Private info | 352,994.20 | |||
89 | 30/12/2021 | Private info | 40,000.00 | |||
90 | 30/12/2021 | Private info | 269,153.30 | |||
91 | 30/12/2021 | Private info | 3,800.00 | |||
92 | 30/12/2021 | Private info | 85,900.00 | |||
93 | 30/12/2021 | Private info | 22,401.00 | |||
94 | 30/12/2021 | Private info | 25,805.00 | |||
95 | 30/12/2021 | Private info | 75,876.00 | |||
96 | 30/12/2021 | Private info | 38,240.00 | |||
97 | 30/12/2021 | Private info | 8,841.00 | |||
98 | 30/12/2021 | Private info | 11,011.00 | |||
99 | 30/12/2021 | Private info | 6,000.00 | |||
100 | 30/12/2021 | Private info | 12,000.00 | |||
101 | 30/12/2021 | Private info | 20,000.00 | |||
102 | 30/12/2021 | Private info | 6,209.00 | |||
103 | 30/12/2021 | Private info | 10,000.00 | |||
104 | 30/12/2021 | Private info | 9,800.00 | |||
105 | 30/12/2021 | Private info | 15,000.00 | |||
106 | 30/12/2021 | Private info | 43,000.00 | |||
107 | 30/12/2021 | Private info | 45,810.00 | |||
108 | 30/12/2021 | Private info | 11,500.00 | |||
109 | 30/12/2021 | Private info | 2,500.00 | |||
110 | 30/12/2021 | Private info | 52,197.00 | |||
111 | 30/12/2021 | Private info | 20,000.00 | |||
112 | 30/12/2021 | Private info | 29,000.00 | |||
113 | 30/12/2021 | Private info | 70,000.00 | |||
114 | 30/12/2021 | Private info | 10,000.00 | |||
115 | 30/12/2021 | Private info | 50,000.00 | |||
116 | 30/12/2021 | Private info | 50,000.00 | |||
117 | 30/12/2021 | Private info | 120,000.00 | |||
118 | 30/12/2021 | Private info | 15,423.00 | |||
119 | 30/12/2021 | Private info | 15,423.00 | |||
120 | 30/12/2021 | Private info | 10,000.00 | |||
121 | 30/12/2021 | Private info | 10,000.00 | |||
122 | 30/12/2021 | Private info | 30,000.00 | |||
123 | 30/12/2021 | Private info | 30,000.00 | |||
124 | 30/12/2021 | Private info | 2,500.00 | |||
125 | 30/12/2021 | Private info | 3,800.00 | |||
126 | 30/12/2021 | Private info | 7,441.00 | |||
127 | 30/12/2021 | Private info | 2,600.00 | |||
128 | 30/12/2021 | Private info | 20,876.00 | |||
129 | 30/12/2021 | Private info | 50,000.00 | |||
130 | 30/12/2021 | Private info | 31,854.00 | |||
131 | 30/12/2021 | Private info | 49,002.00 | |||
132 | 30/12/2021 | Private info | 16,290.00 | |||
133 | 30/12/2021 | Private info | 49,479.00 | |||
134 | 30/12/2021 | Private info | 10,500.00 | |||
135 | 30/12/2021 | Private info | 15,163.00 | |||
136 | 30/12/2021 | Private info | 13,285.00 | |||
137 | 30/12/2021 | Private info | 27,522.00 | |||
138 | 30/12/2021 | Private info | 3,800.00 | |||
139 | 30/12/2021 | Private info | 5,101.00 | |||
140 | 30/12/2021 | Private info | 7,656.00 | |||
141 | 30/12/2021 | Private info | 3,800.00 | |||
142 | 30/12/2021 | Private info | 25,870.00 | |||
143 | 30/12/2021 | Private info | 3,800.00 | |||
144 | 30/12/2021 | Private info | 2,067.00 | |||
145 | 30/12/2021 | Private info | 7,113.00 | |||
146 | 30/12/2021 | Private info | 5,771.00 | |||
147 | 30/12/2021 | Private info | 29,678.00 | |||
148 | 30/12/2021 | Private info | 12,903.00 | |||
149 | 30/12/2021 | Private info | 13,182.00 | |||
150 | 30/12/2021 | Private info | 15,411.00 | |||
151 | 30/12/2021 | Private info | 23,447.00 | |||
152 | 30/12/2021 | Private info | 17,600.00 | |||
153 | 30/12/2021 | Private info | 42,744.00 | |||
154 | 30/12/2021 | Private info | 6,205.00 | |||
155 | 30/12/2021 | Private info | 36,697.00 | |||
156 | 30/12/2021 | Private info | 70,000.00 | |||
157 | 30/12/2021 | Private info | 100,000.00 | |||
158 | 30/12/2021 | Private info | 50,000.00 | |||
159 | 30/12/2021 | Private info | 150,000.00 | |||
160 | 30/12/2021 | Private info | 350,000.00 | |||
161 | 29/12/2021 | Private info | 3,899.00 | |||
162 | 29/12/2021 | Private info | 8,870.00 | |||
163 | 29/12/2021 | Private info | 300.00 | |||
164 | 29/12/2021 | Private info | 2.50 | |||
165 | 29/12/2021 | Private info | 60.00 | |||
166 | 29/12/2021 | Private info | 200,000.00 | |||
167 | 29/12/2021 | Private info | 44,000.00 | |||
168 | 29/12/2021 | Private info | 43,449.00 | |||
169 | 29/12/2021 | Private info | 25,000.00 | |||
170 | 29/12/2021 | Private info | 13,000.00 | |||
171 | 29/12/2021 | Private info | 17,000.00 | |||
172 | 29/12/2021 | Private info | 12,290.00 | |||
173 | 29/12/2021 | Private info | 62,126.00 | |||
174 | 29/12/2021 | Private info | 17,000.00 | |||
175 | 29/12/2021 | Private info | 46,214.00 | |||
176 | 29/12/2021 | Private info | 50,000.00 | |||
177 | 29/12/2021 | Private info | 10,000.00 | |||
178 | 29/12/2021 | Private info | 50,000.00 | |||
179 | 29/12/2021 | Private info | 20,000.00 | |||
180 | 29/12/2021 | Private info | 23,000.00 | |||
181 | 29/12/2021 | Private info | 50,000.00 | |||
182 | 29/12/2021 | Private info | 13,000.00 | |||
183 | 29/12/2021 | Private info | 17,000.00 | |||
184 | 29/12/2021 | Private info | 15,711.00 | |||
185 | 29/12/2021 | Private info | 18,000.00 | |||
186 | 29/12/2021 | Private info | 4,072.00 | |||
187 | 29/12/2021 | Private info | 32,541.00 | |||
188 | 29/12/2021 | Private info | 50,000.00 | |||
189 | 29/12/2021 | Private info | 55,863.00 | |||
190 | 29/12/2021 | Private info | 2,800.00 | |||
191 | 29/12/2021 | Private info | 45,321.00 | |||
192 | 29/12/2021 | Private info | 91,696.00 | |||
193 | 29/12/2021 | Private info | 21,865.00 | |||
194 | 29/12/2021 | Private info | 34,652.00 | |||
195 | 29/12/2021 | Private info | 15,121.00 | |||
196 | 29/12/2021 | Private info | 11,907.00 | |||
197 | 29/12/2021 | Private info | 17,452.00 | |||
198 | 29/12/2021 | Private info | 6,199.00 | |||
199 | 29/12/2021 | Private info | 22,876.00 | |||
200 | 29/12/2021 | Private info | 15,517.00 | |||
dec2021nbk502 |
Any help with PQ, Macros, LET, λ is welcome, mine is Office 365 home version on Windows 10 platform.